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

    Acct4120

    • 310 Words
    • 2 Pages

    This quiz is based on the most recent annual report of PepsiCo, Inc. You can obtain Pepsi’?s financial statements from the firm’?s corporate web site at http://www.pepsico.com/Investors.html. Unless otherwise indicated, all questions relate to the current period’?s financial statements.…

    • 310 Words
    • 2 Pages
    Satisfactory Essays
  • 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

    • Examine PepsiCo, Inc.’s Consolidated Balance Sheet on p. A6 in Appendix A of Financial Accounting, especially its Current Assets, Current Liabilities, and Total Assets for years 2005 and 2004.…

    • 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
  • Powerful Essays

    Xacc280 Week 9 Final

    • 2678 Words
    • 11 Pages

    In order for a company to be financially healthy, it is of most importance that the company must analyze, interpret, and review the business’s annual financial reports. The financial analyses of the annual reports provide insights and information regarding the performances of the business. In this paper, I will be disclosing financial evaluations and comparisons between Coca-Coca and PepsiCo Incorporation. The visualizations used in this paper were designed to provide the analyses performed utilizing three financial analyses methods: vertical analysis, horizontal analysis, and ratios analysis. There will also be recommendations made on how Coke and Pepsi could improve their financial status.…

    • 2678 Words
    • 11 Pages
    Powerful Essays
  • Satisfactory Essays

    There are three ways to analyze financial statements there is the vertical analysis, which uses the base percentage to express the assets or liabilities and stockholders’ equity. Horizontal analysis or the trend analysis is how someone can evaluate the financial statement over a period. With this method, one can determine an increase or decrease in assets liabilities or stockholders equity. This can be done in percentage or totals Horizontal analysis is used primarily with an intercompany comparison. Ratio analysis is when one uses three comparisons to look at the financial statements it would look at industry average intracompany and intercompany. Ratio expresses the mathematical relationship in a percentage either a rate or a proportions. It depends on if you are a Short-term creditor or a stockholder which method will be most beneficial for the necessary information to make a sound decision. This information can be overwhelming so careful study and practice is important when analyzing finical statements.…

    • 292 Words
    • 2 Pages
    Satisfactory 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
  • 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

    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

    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
  • 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
  • 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
  • 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
  • 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
  • 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