Horizontal and Vertical Analysis

Financial Analysis XACC280 June 28, 2012 chronicle is the way two companies turn back track of their out-going and in-coming finances. Applying beaking principles in either business is incredibly essential because it allows for the least amount of mistakes and gives a comprehensive experience of all transactions. in that location be many tools used in accounting, each with its get unique function. Statements are used to show a specific date periods overview of assets, liabilities, and all transactions. These controls allow for easier study of months, geezerhood, or correct different companies accounts. both of the tools of financial statement compend are called steep abstract and plain compend. Much like the definitions of upended and plain, these two analyses are similar, but also consent striking differences. In this paper I allow for provide you with information regarding the two tools, vertical and swimming abridgment, and how canvas them is use to tw o big businesses called PepsiCo, Incorporated and Coca-Cola Company. When referring to vertical depth psychology, we are referring to when a summation percentage is calculated for one financial statement.As defined on Accounting Coach (2012), A type of financial analysis involving income statements and residue sheets. every income statement amounts are allotd by the amount of net gross sales so that the income statement figures pass on become percentages of net sales. All sense of equilibrium sheet amounts are divided up by complete assets so that the balance sheet figures will become percentages of total assets, (Dictionary). Using vertical analysis is very helpful when comparing a societys percentages amid 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 corresponding trade more(prenominal) as the companies being discriminated in this paper PepsiCo, Inc. and Coca-Cola Company. Using vertical analysis will help us to compare how well each federation did in the certain accounts that were analyzed. The reason we want to do these comparisons is because it can sometimes be difficult to determine how much each statement is cost within a telephoner or when compared to an confrontation larger or smaller company.By converting them into percentages, it becomes effortless to compare and understand that information each statement gives. To perform a vertical analysis of PepsiCo we divide the afoot(predicate) assets by the total assets. This will tell us what percentage of the assets in the company are accepted. To find this we divide the current assets, $4,882, by the total assets, $31,727, (University of Phoenix, 2008). By doing this math, we now know that the current assets machinate up 6. 5%. We will perform a similar problem to find what percentage of total assets are stockholder equity.pickings the total assets, $31,7 27, and dividing that by the shareholder equity, $14,320, we see that the shareholder equity captures up 2. 22% of the total assets, (University of Phoenix, 2008). This can be do to all other accounts to find what percentage of total assets each account is. Below is the example of percentages of total assets that the current assets and shareholder equity make up. Two measures of vertical analysis- 1. present-day(prenominal) assets divided by total assets- 4882 / 31727 = 6. 5% 2. Shareholder equity divided by total assets- 14320 / 31727 = 2. 22%A vertical analysis of Coca-Cola will show us similar percentages to those of PepsiCo. We divide he total assets, $29,427 by the current assets of $10,250. From this we now know that 2. 87% of the total assets are made up of current assets. Using the same equation, we substitute the current assets with the shareholder equity of $16,355, (University of Phoenix, 2008). By dividing the total assets of $29,427 by $16,355 we are left with 1. 79% . This means that the shareholder equity make up 1. 79% of the total assets of Coca-Cola Company. See the equations below Two measures of vertical analysis- 1. new assets divided by total assets- 10250 / 29427 = 2. 87% 2. Shareholder equity divided by total assets- 16355 / 29427 = 1. 79% Differing from total percentages from one financial statement, is plain analysis. According to Accounting Coach (2012), This method involves financial statements reporting amounts for several(prenominal) grades. The earliest year presented is designated as the base year and the subsequent years are expressed as a percentage of the base year amounts. This allows the analyst to to a greater extent easily see the trend as all amounts are now a percentage of the base year amounts, (Dictionary).Horizontal analysis is used to show profitability over certain time periods. When a company is able to tell the public or its investors that its assets change magnitude by 12% since the previous year, that comp any is using horizontal analysis to show where that 12% came from. This is especially helpful in comparing two companies like PepsiCo Inc and Coca-Cola Company. The reason it is helpful is quite simple. As antecedently explained, horizontal analysis allows for analysts to show how much an account has increased of diminish since the previous time period, (Investopedia,2012).When comparing PepsiCo and Coca-Cola, using horizontal analysis, we can view how much the revenues for each company have increased or reduced in 2004 or 2005. This enables investors to see the profit of a company and gives sagacity into which companies are outperform to invest in. To perform a horizontal analysis of PepsiCo we will compare accounts from the year 2004 to 2005. By doing this we will get an root of how much the assets and liabilities for PepsiCo have increased. In 2004 the current assets of the company were $3,445. In 2005, they increased to $4,822. This shows an increase of 1. %. Next we will lo ok at the liabilities. The current liabilities in 2004 were $14,464. They were raised to $17,476 in 2005, (University of Phoenix, 2008). This shows an increase of 1. 21%. These figures are shown below Two measures of horizontal analysis for PepsiCo, Inc. 1. Current assets in 2005 divided by current assets in 2004- 4822 / 3445 = 1. 4% Current liabilities in 2005 divided by current liabilities in 2004- 17476 / 14464 = 1. 21% What we can infer from this information is that PepsiCo has increased both their assets and liabilities from 2004 to 2005.There could be any number of reasons for this. Perhaps the company is responding to competition and change magnitude their assets and liabilities in anticipation of a higher ratio of consumers. We cannot judge what is best to invest in based exclusively on the information gained from this horizontal analysis. We must also compare numbers from the vertical analysis listed above. As we have done for PepsiCo, we will compare accounts for Coca-C ola Company during the same years, 2004 to 2005. In keeping with our above listed accounts, we will find the percentages of the assets and liabilities.In 2004, Coca-Colas current assets were $12,281. The assets change magnitude to $10,250 in 2005, dropping by a percentage of 1. 2%, (University of Phoenix, 2008). A similar comparison can be found for the liabilities. In 2004 Coca-Colas current liabilities were $11,133. In 2005 we see a decrease to $9,836, (University of Phoenix, 2008). This decrease a percentage of 1. 13%. The figures are shown below Two measures of horizontal analysis- 1. Current assets in 2005 divided by current assets in 2004- 10250 / 12281 = -1. 2% Current liabilities in 2005 divided by current liabilities in 2004- 9836 / 11133 = -1. 3% sound judgment on the numbers, we can see that Coca-Cola had a decent decrease in both their assets and liabilities. This is positive thing in the eyes of investors or potency investors because it can mean that the company is victorious in less. Taking in less is something investors look for because an ideal company will be taking in very little and gear upting out substantially more. By performing vertical and horizontal analyses on two companies like PepsiCo, Inc and Coca-Cola Company, we are able get a look at how the numbers of both compare not only to previous years, but to each other as well.As with any company, it is to be assumed that improvements will need to be made. Based on the numbers we show in the vertical analysis of both companies, it is safe to say that Coca-Cola has better looking numbers. However, we cannot make our judgements solely on the percentages we concluded from the horizontal analysis. Simply because Coca-Colas current assets and liabilities decrease in percentage from 2004 to 2005 does not mean they are a wiser spend choice. It might obviously show that they did not add any assets or liabilities but what it does not obviously show is why. There could be any number of reaso ns.I would suggest for Coca-Cola to try and improve its percentage of shareholder equity within the company based on the information from the vertical analysis. Perhaps if investors see that others thought it a wise choice to put their money into the company, they will too. My suggestion for PepsiCo is based on the numbers from their horizontal analysis. Comparing PepsiCo to Coca-Cola shows that PepsiCo is taking in far too many assets and liabilities amongst their yearly periods. It is ideal for them to take in the same, or even less. Adding more assets and liabilities can mean that the company is not doing as well as they previously were.An investor wants to see a company putting out much more than they are taking in. Higher liabilities and assets can mean the opposite is happening. PepsiCo would be making a wise choice if they avoid increase those accounts. Comparing accounts, statements, and percentages within a company or to another company is made much easier with tools such as vertical and horizontal analyses. To compare numbers and percentages within a company, vertical analysis is the tool needed. Taking that comparison one step farther by including other companies is why we have horizontal analysis. PepsiCo, Inc. nd Coca-Cola Company have been compared and helpful suggestions have been made for each company to improve. It is important to remember that The information authoritative from the two types of analyses can influence investors and potential clients alike. Maintaining balanced percentages with increasing and change magnitude values where necessary is the key to financial success. 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. om/sites/0073029920/student_view0/ebook/chapter23/chbody45/vertical_analysis_of_financial_statements. html. Investopedia. (2012). Retrieved from http//w ww. investopedia. com/terms/h/horizontalanalysis. aspaxzz1z91O1lS9 University of Phoenix. (2008). Appendix A- type 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.