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

    Final Financial Analysis

    • 1870 Words
    • 8 Pages

    Financial Analysis is very important to the inner workings of a business. Keep track of financial statements, taxes, audits, and various other areas of financials will show how well a company has done, is doing, and how well it will do in the future. Seeing how well a company is doing into the future is important so they can see any mistakes and try to fix them before they become an issue and hinder the growth of the company. In this essay I will compare financial statements in two companies, PepsiCo. and Coca Cola Company. I will describe what vertical and horizontal analysis is then I will go over the vertical analysis of both companies, comparing one to the other. I will go over the horizontal analysis of both companies, comparing them as well. I will describe ratio analysis and I will show the ratio analysis of both companies, including the testing of a liquidity ration, a solvency ratio, and a profitability ratio. I will explain in my own opinion which company is more financial stable and why, using comparisons of the data from the data stated. I will finally include three recommendations to improve each company’s financial health for the future.…

    • 1870 Words
    • 8 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
  • Good Essays

    There are three types of financial statement analysis; for example, (1) Horizontal Analysis, (2) Vertical Analysis, and (3) Ratio Analysis. First, the horizontal analysis is also known as trend analysis, which views the behavior of an individual financial statement items over several accounting, which may be several quarters within the same fiscal year or several different years; however, the analysis of a given item may focus on absolute dollar amount, according to Edmonds, T.P., Olds, P.R., McNair, F.M., and Tsay. (2010). Moreover, “percentage analysis sidesteps the materiality problems of comparing different size companies by measuring changes in percentages rather than absolute amount; in other words, each change is converted to a percentage of the base year.”( Edmonds et al 2010, p. 326). Second, as Edmonds et al stated, vertical analysis of an income statement also known as a common size statement, involves converting each income statement component to a percentage of sales; however, vertical analysis suggest examining only one period, which is useful to compare common size income statements for several years; which also involves converting each balance sheet component to a percentage of total assets. Third, “ratio analysis involves the study of various relationships between different items reported in a set of financial statement; for example, net earnings reported on the income statement may be compared to total assets reported on the balance sheet; however, analysis calculate many different ratios for a wide variety of purposes.” (Edmonds, et al, 2010).…

    • 485 Words
    • 2 Pages
    Good Essays
  • Better Essays

    You may easily see a horizontal analysis as an income statement for a business by creating a list of all assets for a period of more than one year. “Showing changes in dollar form helps the analyst focus on key factors that have affected profitability or financial position.” (http://www.accountingformanagement.com). This method of financial analysis may have common use in a business when keeping track of their revenue by year to show profit or loss.…

    • 925 Words
    • 4 Pages
    Better Essays
  • Satisfactory Essays

    Xacc Checkpoint Wk 7

    • 278 Words
    • 2 Pages

    · 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.…

    • 278 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    A financial statement analysis is the process of using data contained in a business’s financial statements to make judgments about financial condition. There are three basic financial statements: the income statement, the balance sheet, and the statement of cash flows. These statements show the firm’s operations and its financial position. The data obtained is detailed for two or three most recent periods, and a historical summary of key operating statistics for longer periods are included. Financial statement analysis is applied to historical data, which reflect the results of past managerial decisions and…

    • 728 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Personal Learning

    • 697 Words
    • 3 Pages

    * Horizontal & vertical Analysis of Balance sheet and Income statement – how to compare and contrast the given numbers…

    • 697 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Acc291 Reflection Week 4

    • 460 Words
    • 2 Pages

    Ratio analyses are used by companies to gather information in a company’s financial statement. Ratios and numbers from a company’s current year are compared to previous years and sometimes even the economy to judge the company’s performance. There are several ratios such as profitability ratios, liquidity ratios, activity ratios, leverage ratios and market ratios that can be used to calculate financial information. In vertical analyses, each entry of the assets, liabilities and equities in a balance sheet is represented as a proportion of the total account of the financial statement. In horizontal analysis a company’s ratios are compared in the financial statements over a period of time. Horizontal analysis can be used from revenues to earnings per share.…

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

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