Preview

Horizontal and Vertical Analysis

Better Essays
Open Document
Open Document
1833 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Horizontal and Vertical Analysis
Financial Analysis

XACC280

June 28, 2012

Accounting is the way all companies keep track of their out-going and in-coming finances. Applying accounting principles in any business is incredibly important because it allows for the least amount of mistakes and gives a comprehensive view of all transactions. There are many tools used in accounting, each with it’s own unique function. Statements are used to show a specific time period’s overview of assets, liabilities, and all transactions. These statements allow for easier comparing of months, years, or even different companies accounts. Two of the tools of financial statement analysis are called vertical analysis and horizontal analysis. Much like the definitions of vertical and horizontal, these two analyses are similar, but also have striking differences. In this paper I will provide you with information regarding the two tools, vertical and horizontal analysis, and how comparing them is applied to two big businesses called PepsiCo, Incorporated and Coca-Cola Company.

When referring to vertical analysis, we are referring to when a total percentage is calculated for one financial statement. As defined on “Accounting Coach” (2012), “A type of financial analysis involving income statements and balance sheets. All income statement amounts are divided by the amount of net sales so that the income statement figures will become percentages of net sales. All balance sheet amounts are divided by total assets so that the balance sheet figures will become percentages of total assets,” (Dictionary). Using vertical analysis is very helpful when comparing a company’s percentages between statements, (Price, Haddock, & Brock, para. Vertical analysis of financial statements, 2007). It can also be helpful when comparing numbers of two companies that are within the same trade; such as the companies being compared in this paper: PepsiCo, Inc. and Coca-Cola Company. Using vertical analysis will help us to compare how



References: Accounting coach. (2012). Retrieved from http://www.accountingcoach.com/ Price, J. E., Haddock, M. D., & Brock, H. R. (2007). College Accouting (11th ed.). Retrieved from http://highered.mcgraw-hill.com/sites/0073029920/student_view0/ebook/chapter23/chbody45/vertical_analysis_of_financial_statements.html. Investopedia. (2012). Retrieved from http://www.investopedia.com/terms/h/horizontalanalysis.asp#axzz1z91O1lS9 University of Phoenix. (2008). Appendix A- Specimen financial statements: PepsiCo, Inc. Retrieved from University of Phoenix, XACC 280 - Accounting Concepts and Principles website. University of Phoenix. (2008). Appendix B- Specimen financial statements: The Coca-Cola Company. Retrieved from University of Phoenix, XACC 280 - Accounting Concepts and Principles website.

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Vertical analysis is another important and simple tool. It is comparing the individual components of financial statements to the whole—as a percentage of the total. For example, if cash equals $15,000 and total assets equal $100,000 then cash equals 15% of total assets. Vertical analysis is also called common-size analysis.…

    • 330 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Fnt Task 1

    • 1124 Words
    • 3 Pages

    A horizontal analysis Income Statement was performed for Company G utilizing financial data from income statements in 2011 and 2012. A listing of ratios used, calculations and year-to-year comparison follows.…

    • 1124 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Horizontal (or trend) analysis concentrated on evaluation of financial statements for a certain timeframe and is mainly used for the needs within company. It is usually performed for each item of statement, thus giving figures of increase of decrease for each item separately (including the totals of statement). The main goal is determining whether the company grows or decreases, the result can be shown in the amounts or percentage rates; it is relatively easy to read and it provides…

    • 746 Words
    • 3 Pages
    Good Essays
  • Better Essays

    Xacc280 Financial Analysis

    • 1828 Words
    • 8 Pages

    Butler, A. (2006). The History of Pepsi-Cola. Associated Content, Inc. Retrieved July 10, 2010 from http://www.associatedcontent.com/article/44579/the_history_of_pepsicola.html?cat=3…

    • 1828 Words
    • 8 Pages
    Better Essays
  • Satisfactory Essays

    Review the annual reports for PepsiCo., Inc and the Coca-Cola Company in the Appendixes A B of Financial Accounting. Select either PepsiCo, Inc or Coca-Cola Company. In your estimation, the company you chose may be financially healthier or weaker.…

    • 452 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Accounting400 Week 5

    • 631 Words
    • 3 Pages

    Financial statement analysis is done by every successful corporation, as your team at Ventura Electronics very well knows. “Comparisons within a company are often useful to detect changes in financial relationships and significant trends” (Kimmel, Weygandt, and Keiso p. 653). Financial statement analysis is done by horizontal analysis, vertical analysis, and ratio analysis. “Horizontal analysis, also known as trend analysis, is a technique for evaluating a series of financial statement data over a period of time (Kimmel, Weygandt, and Keiso p.654). If Ventura Electronics is interested in determining any increase or decrease in, for example, net sales (as an amount or percentage) than horizontal analysis are appropriate. Vertical analysis analyzes more specific data on the financial statement. “Vertical analysis, also called common-size analysis, is a technique for evaluating financial statement data that expresses each item in a financial statement as a percent of a base amount”(Kimmel, Weygandt, and Keiso p.656). Ventura Electronics can not only analyze the relative size of each category on the financial statement, but can also see the percentage change in the individual asset, liability, and stockholders’ equity. Ventura Electronic can also use this analysis when comparing its financial statements to the competition. The last tool commonly used for financial statement analysis is ratio analysis. These ratios are useful in evaluating the financial health and performance of a company. In ratio analysis we use three different ratios; liquidity ratios, solvency ratios, and profitability ratios. Liquidity ratios are important because it evaluates the short-term ability of a business to pay their obligations as well as meet their unexpected cash flow needs. When Ventura Electronics wants to measure the ability of the company to survive over a long period of time then solvency ratios are appropriate. Profitability ratios…

    • 631 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    ACC 281 week 1 dq 2

    • 335 Words
    • 2 Pages

    We need financial and managerial accounting in order to determine exactly how a business is doing from a financial standpoint. Without financial and managerial accounting, an organization would not be able to determine whether it is making revenue or not. These tools make it possible for an organization to identify exactly how it is functioning. There are fundamental differences between financial and managerial accounting. Financial accounting delivers information that is used mainly by stockholders, creditors, and others externally. In comparison, managerial accounting concentrates on information that is used by managers, and staff members who work inside of the organization. A.J. Filipovitch (2004) explains, “There are two types of accounting—financial accounting (provides information to outside parties and is subject to outside audit) & managerial accounting (provides information to an organization’s managers and is normally not shared outside the organization)”. They are equally important in order for an organization to operate successfully.…

    • 335 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Xacc/280 Final

    • 632 Words
    • 3 Pages

    A variety of tools are used to assess the importance of financial data. Frequently used tools of financial statement analysis consist of horizontal analysis, vertical analysis and ratio analysis. These techniques assist in the evaluation of financial statements providing information regarding the financial condition of a business.…

    • 632 Words
    • 3 Pages
    Good Essays
  • Better Essays

    Xacc280 Financial Analysis

    • 1673 Words
    • 7 Pages

    In this paper, after reviewing and analyzing Appendix A Specimen Financial Statement for PepsiCo and Appendix B Specimen Financial Statement for the Coca Cola Company, I would be providing a financial comparison between the two most known beverages company in the world PepsiCo and Coca-Cola. I will be supporting my financial analysis by showing vertical, horizontal, and ratio financial analysis for both companies. To provide explanation as to what to find in each financial analysis; vertical analysis refers to assets, liabilities and equities as a percentage as a whole. It is a method where each entry for each of the categories in a balance sheet is represented as a proportion of the total account. Horizontal analysis is a method which is used for evaluating financial statements data over a specific period of time. It shows if the company’s performance is improving or decreasing and it can be expressed in numeric amounts or percentage amounts. Finally, the Ratio analysis is the calculation and comparison of ratios which are shown in the company’s financial statements. It determines or states if the company is worth investing in or not.…

    • 1673 Words
    • 7 Pages
    Better Essays
  • Good Essays

    The three of financial statement analysis are horizontal analysis, vertical analysis, and ratio analysis. The function of all three analyses is to evaluate the significance of financial statements data. Horizontal analysis function is to evaluate and compare data given by the financial statement for at least two years with in its own company. Vertical analysis expresses the amounts of the financial statements as a percentage from the amounts given on the financial statements. Vertical analysis also makes it so that companies can compare how they are doing with competing companies. Ratio analysis is used to evaluate liquidity, profitability, and solvency.…

    • 769 Words
    • 4 Pages
    Good Essays
  • Better Essays

    Competition Bikes Task 1

    • 5733 Words
    • 23 Pages

    The horizontal analysis is a method used to analyze changes in the company’s financial health between years in values of dollars and percentages using data from the balance sheet and income statement. In the horizontal analysis a base year is set and then other years are compared to the base year. The horizontal analysis will be used to assess Competition Bikes actual financial operating performance based on the time period between years 6 through 8, with year 6 set as the base year. Starting with an analysis between year 6 and year 7, we look at the horizontal financial changes to determine actual performance by the percentages. Net sales in years 6 and 7 reflect a change of $1,495,000 at a 33% increase change. This change is positive which translates into higher sales which also mean the operating performance was good for the company and customers really liked the products. The cost of goods sold reflects a change of $1,048,000 at a 31% increase change. This percentage is financial strength for company again which means the customer liked the products. This percentage should remain lower than the net sales, and the percentage reflect an added strength for the company because this percentage is lower than net sales, so here the Competition Bikes has control over the cost of making the Bikes to increase revenue. In the same years (6 and 7) the horizontal comparison ratio for gross profits reflected a change of $447,000 which is a positive increase of 37.5%. Therefore, 37.5% of each dollar from sales was retained after the cost of…

    • 5733 Words
    • 23 Pages
    Better Essays
  • Powerful Essays

    Final Financial Analysis

    • 1870 Words
    • 8 Pages

    The three most common tools of financial analysis are the vertical analysis, the horizontal analysis, and the ration analysis (which will be discussed later). The vertical analysis evaluates financial statement data by expressing each item in a financial statement as a percentage of an original base amount (2010). The vertical analysis is also referred to as the common size analysis. The vertical analysis shows all data on a financial statement document in terms of a percentage. The vertical analysis will show how much assets, liabilities, or stockholders equity have gone up or declined from the year before. I am providing two examples of vertical analysis, one for PepsiCo. and one for Coca Cola to show which company has improved with assets and…

    • 1870 Words
    • 8 Pages
    Powerful Essays
  • Satisfactory Essays

    Acc 400

    • 406 Words
    • 6 Pages

    BYP13-4 The Coca-Cola Company and PepsiCo, Inc. provide refreshments to every corner of the world. Selected data from the 2004 consolidated financial statements for The Coca-Cola Company and for PepsiCo, Inc., are presented here (in millions).Coca-Cola PepsiCoTotal current assets $ 12,094 $ 8,639Total current liabilities 10,971 6,752Net sales 21,962 29,261Cost of goods sold 7,638 13,406Net income 4,847 4,212Average (net) receivables for the year 2,131 2,915Average inventories for the year 1,336 1,477Average total assets 29,335 26,657Average common stockholders’ equity 15,013 12,734Average current liabilities 9,429 6,584Average total liabilities 14,322 27,917Total assets 31,327 27,987Total liabilities 15,392 14,464Income taxes 1,375 1,372Interest expense 196 167Cash provided by operating activities 5,968 5,054Capital expenditures 755 1,387Cash dividends 2,429 1,329Instructions(a) Compute the following liquidity ratios for 2004 for Coca-Cola and for PepsiCo and comment on the relative liquidity of the two competitors.(1) Current ratio. (4) Inventory turnover.(2) Receivables turnover. (5) Days in inventory.(3) Average collection period. (6) Current cash debt coverage.(b) Compute the following solvency ratios for the two companies and comment on the relative solvency of the two competitors.(1) Debt to total assets ratio.(2) Times interest earned.(3) Cash debt coverage ratio.(4) Free cash flow.(c) Compute the following profitability ratios for the two companies and comment on the relative profitability of the two competitors.(1) Profit margin.(2) Asset turnover.(3) Return on assets.(4) Return on common stockholders’ equity.…

    • 406 Words
    • 6 Pages
    Satisfactory Essays
  • Powerful Essays

    Cola War

    • 9264 Words
    • 38 Pages

    For over a century, carbonated drink was introduced to mankind. Two major contenders in the industry stand Coca-Cola and PepsiCo. The two soar in the industry as they compete with each other. There were amazing monopolistic behaviors found in their doings. Have you ever wondered why such drink without any redeeming health benefits, but rather sublimely known as one of the causes to sugar and fat related diseases, can be so profitable? By setting the health benefits aside, have you ever wondered why such drinks are so popular yet a lot of competitors are unable to imitate and stand up to beat them? The secret lies…

    • 9264 Words
    • 38 Pages
    Powerful Essays
  • Powerful Essays

    Method Analysis

    • 945 Words
    • 4 Pages

    Vertical analysis: uses percentages to compare individual components of financial statements to a key statement figure. Horizontal analysis compares items over many time periods; vertical analysis compares many items within the same time period.…

    • 945 Words
    • 4 Pages
    Powerful Essays