Vertical And Horizontal Analysis

Improved Essays
Part 1 – Vertical and Horizontal Analysis
Vertical Analysis
A vertical analysis is a measure in which the entry of three of the major categories of the balance sheet are represented as a proportion of the total amount. The main advantage is that the balance sheets, income statements and other financial reports can be compared quite easily. The main idea of a vertical analysis is that it identifies each line item of a financial statement as a percentage of the main focus of the statement. For example, on a balance sheet, each line item would be representative of total assets and in a cash flow statement, each line is conveyed as a percentage of the total cash and cash equivalents. The most common use of a vertical analysis is in a financial
…show more content…
The net sales of the company demonstrate a slight increase in dollars but when converted to percentage we can see a very slight decrease from 2013 to 2014 to 2015. This decrease in net sales is proportional to the increase in membership and other income for 2015 which is 0.71% for 2014 it is 0.68% and for 2013 it is 0.65%. From the analysis we can see that there is a slight decrease in the operating income from 2012 where in it was at 5.93% to 2015 where it stood at 5.59%. There is an evident decrease in the consolidated net income from 2013 3.63% to 3.36% in …show more content…
But then, we see how for the following years it changes in a positive from 2013 to 2014 by $171 million or 5.61% and from 2014 to 2015 by $204 or 6.34%.
When we look into the operation income and the consolidated net income of Walmart from 2014 in comparison to 2013, it is evident that 2014 was not a positive year for them. Their operating income decreased by $853 million or -3.08%, due to an increase in their administrative, operating and selling expenses in 2014. Yet then when we go into the following year, 2015, we can see an increase in the operating income of $275 million or 1.02%. While that is a positive change we can see by analyzing a little further that it is not as positive as in the previous year’s comparison, 2013 to 2012 where it was $1234 million or 4.66%. The consolidated net income of 2014 showed a decrease of $977 million or -5.75%. However, this decrease did not affect the dividends declared per common share in 2014, actually quite the contrary was demonstrated, a 0.29 or 18.24% increase in the common share

Related Documents

  • Great Essays

    Net profit margin 27.32 25.91 24.89 1.813 4.10 Return on equity 30.45 35.72 36.39 29.16 -2.61 Return on assets 17.87 19.34 16.69 9.71 -0.65 Return on Capital 22.33 23.85 22.08 16.06 2.08 Income/Employee 960 1,043 934 655 -55 Revenue Employee 5,342 6,186 15,727 4,782 5,594 Revenue turn over 1.00 1.15 1.02 0.83 0.56 Inventory turnover 61.80…

    • 595 Words
    • 3 Pages
    Great Essays
  • Great Essays

    Pizza Pizza – Changes in Sales, Total Assets, Shareholder’s Equity & Net Income Change in sales: Pizza Pizza’s sales have increased by 5.3% in 2015 to 533.8 million from 505.4 million in 2014, this was primarily due to geographic diversification among eastern provinces which helped provide consistent restaurant sales and stable growth in sales over the past five years. Change in Net Income: Pizza Pizza’s net income increased by 0.871% to 25.23 million from 25.16 million in 2014. The increase is mainly attributable to an increase in royalty income and a decrease in interest expense balanced by an increase in current tax expense. Royalty income had increase because of additional restaurants added to the same store sales pool on January 1,…

    • 1526 Words
    • 7 Pages
    Great Essays
  • Decent Essays

    Pharmasim Case Study

    • 285 Words
    • 2 Pages

    1. Allstar captured an additional 16.5% of the cold product segment of the market. Accordingly, their market share of manufacturer sales of the OTC Cold product market increased from 23.8% to 39.1%. 2. Allround OTC cold medication maintained the leadership position at period 10.…

    • 285 Words
    • 2 Pages
    Decent Essays
  • Decent Essays

    Hi Peeps Analysis

    • 364 Words
    • 2 Pages

    Hi Peeps, Today's Quote "The Good Missions Act spotlights the Good Deeds of the many Wonderful Grandparents who are involved with the lives of their Grandchildren-- bridging the gap and filling in the missing information of family values, History, solid work ethics, and God's Commandments with vigor, enlightenment, excitement and experience. This is hard to do for the disobedient and inexperienced Missing in Action Grandparents." ` Jon Barnes Missing in Action There are many reasons why people are missing in action on their assignments, but the scope of this is not to address the excuses; we are focusing on the Actions. Grandparents who are doing the Good Missions Act are engaged, involved, inspired, and courageous to pick up the Cross,…

    • 364 Words
    • 2 Pages
    Decent Essays
  • Improved Essays

    Target Financial Analysis

    • 786 Words
    • 4 Pages

    Conclusion Target When looking at the cover brand of Target, it is easy to assume that they are excelling quicker than many other retailers. After applying the balance sheet and income statement to the ratios, I found that Target is not as embellished as I once thought. I will show you what I found looking at the liquidity, debt management, asset management and, and profitability ratios and why it is a good time to buy Target stocks. Before I start with my analysis, I would like to point out years 2014 and 2015 in the Target Corporation.…

    • 786 Words
    • 4 Pages
    Improved Essays
  • Improved Essays

    Dr. Paz, Home Depot was enjoying the early years of the 21st century when the United States housing market was booming. However, due to the slow down in the real estate market in 2006, they announced that revenues for the first half of 2007 were 3 percent lower than revenues for the first six months of 2006. In addition, their earnings for the first half of 2007 were 21 percent lower than for the same period in the prior year. I will explain how a 3 percent decline in sales could cause a 21 percent decline in profits.…

    • 400 Words
    • 2 Pages
    Improved Essays
  • Improved Essays

    Art can convey different messages to the viewer, for example, the paintings of Circe on slide 41. In the painting to the left Circe seems to be like a lonely and angry queen, but in the painting to the right she seems to be more like a nurturing shepherd. The colors within the painting to the left makes Circe seem broody, but in the painting to the right the lighter colors make her seem joyful and loving. The colors within the painting to the left are much darker.…

    • 708 Words
    • 3 Pages
    Improved Essays
  • Improved Essays

    Motomart Case Study

    • 815 Words
    • 4 Pages

    Heather Hastings 761 Golden Oak Circle, Crystal Lake, IL 60014 Student#: 53587431 Project #: 50089600 Senior Capstone, BUS 450 Case 2: Motomart Heatherhastings0328@gmail.com Step 1 When looking at tables 3-5, yes, some of the amounts do appear to be odd. Over the five-year period, the company’s operating profits had consistently declined. However, in 1987, the loss slightly decreased compared to the previous year’s decline.…

    • 815 Words
    • 4 Pages
    Improved Essays
  • Great Essays

    Panera Bread Case Study

    • 2208 Words
    • 9 Pages

    Analysis: Financial: | |CAGR |2002 |2003 |2004 |2005 |2006 | |Net Income |28.9 |21300 |30669 |38430 |52183 |58849 | |EPS |26.9 |.71 |1.00 |1.25 |1.65 |1.84 | |Net cash by | | | | | | | |Operating Activities |22.7 |46323 |73102 |84284 |110628 |104895 | |Total Revenue |30.9 |212645 |265933 |362121 |640422 |828971…

    • 2208 Words
    • 9 Pages
    Great Essays
  • Great Essays

    Be Our Guest Case Analysis

    • 1591 Words
    • 7 Pages

    Although net income decreased 22.8% from 1995 to 1997, because depreciation increased 25.8% from 1995 to 1997, the total net income adjusted for non-cash charges increased by 4% from $250,000 to $259,000, from 1995 to 1997. The changes to Accounts Receivable over the years reduce cash flow from operations by $75,000, $46, $42,633 in 1995, 1996, and 1997, respectively. These increases in accounts receivable cause the cash flow from operations to decrease because Be Our Guest, Inc. collected less money from their customers compared to the sales. Whereas, the changes in Accounts payable & accruals of, $5,768, $19,063, and $14,859, in 1995, 1996, and 1997, respectively, caused the cash flow from operations to increase because Be Our Guest, Inc. is paying their suppliers less, indicating they are retaining more cash for…

    • 1591 Words
    • 7 Pages
    Great Essays
  • Improved Essays

    The Walt Disney Company Financial Statement Analysis My cull of the company to base on in my financial statement analysis is the Walt Disney Company. This is a company that mainly deals with the regalement industry by animation. Its aim is to become one of the leading providers of entertainment and information to their audiences. This is done by their efforts to invest in creativity so that they are able to pull more audiences towards their oeuvres.…

    • 729 Words
    • 3 Pages
    Improved Essays
  • Decent Essays

    Case Analysis Of Nintendo

    • 756 Words
    • 4 Pages

    As an example, operating income from 2015 to 2016 increased by 32.75%. Revenues, net income, and earnings per share have decreased on a year to year basis…

    • 756 Words
    • 4 Pages
    Decent Essays
  • Improved Essays

    As a grocery store, Whole Foods has a very unique culture and mission. With its tight-knit Business to Consumer business model, Whole Foods seeks to supply its customers with all natural and organic foods. Whole Foods strives to maintain the highest quality standard the food industry provides. As said in an article from the Whole Foods Market website, Whole Foods is a mission driven company who will not let anything get in their way (Whole Foods Market IP LP, 2016). Because Whole Foods has a mission to provide such high quality foods, the choice of its suppliers is extremely important.…

    • 644 Words
    • 3 Pages
    Improved Essays
  • Improved Essays

    | Total liabilities and stockholders' equity | $1,000,000 | $1,300,000 | $1,894,000 | | | | | | Exhibit 3 | Selected Industry Ratios | | | 200X | 200Y | 200Z | | Growth in sales | ----- | 9.98% | 10.02% | | Profit margin | 5.75% | 5.80% | 5.81% | | Return on assets (investment) | 8.22% | 8.24% | 8.48% | | Return on equity | 3.26% | 13.62% | 14.16% | | Receivables turnover | 10x | 9.5x | 10.1x | | Average collection period | 36 days | 37.9 days | 35.6 days | | Inventory turnover | 5.71x | 5.62x | 5.84x | | Fixed asset turnover | 2.75x | 2.66x | 2.20x | | Total asset turnover | 1.43x | 1.42x | 1.46x | | Current ratio | 2.10x | 2.08x | 2.15x | | Quick ratio | 1.05x | 1.02x | 1.10x | | Debt to total assets | 38% | 39.5% | 40.1% | | Times interest earned | 5.00x | 5.20x | 5.26x | | Fixed charge coverage | 3.85x | 3.95x | 3.97x | | Growth in earnings per share | ----- | 9.7% | 9.8% | | | Rubric: Watson Leisure Time Sporting Goods | | | 200X | 200Y | 200Z…

    • 1715 Words
    • 7 Pages
    Improved Essays
  • Decent Essays

    Vertical Analysis Of Nike

    • 2199 Words
    • 9 Pages

    ncome statement: In order to analysis the financial statement thoughtfully, we apply the horizontal analysis technique to find out the significant change in dollar amount and percentage grow rate. From the income statement vertical analysis below (table 1), we could compare a series of financial statement data over a period of time. Sales revenue increase by around 10% from 2013 to 2014. If excluding the currency change, revenue from NIKE Company’s continuing operations grew 11 % for the fiscal year 2014. From the table 2, it provide the revenue structure of NIKE.…

    • 2199 Words
    • 9 Pages
    Decent Essays