Horizontal and Vertical Analysis

Financial Analysis XACC280 June 28, 2012 Accounting is the way every(prenominal) companies keep shack of their out-going and in-coming finances. Applying depending principles in either business is incredibly important because it allows for the least amount of mistakes and gives a house-to-house view of all transactions. There atomic number 18 many roosters used in accounting, individually with its profess unique function. Statements atomic number 18 used to stage a specific time periods overview of assets, liabilities, and all transactions. These statements allow for easier analyse of months, years, or even different companies accounts. two of the tools of monetary statement analysis are called good analysis and level analysis. Much like the definitions of just and naiant, these two analyses are similar, but also energise striking differences. In this paper I go away provide you with information regarding the two tools, vertical and level analysis, and how compari ng 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 nitty-gritty fortune is calculated for one financial statement.As defined on Accounting animal trainer (2012), A type of financial analysis involving income statements and balance sheets. All income statement amounts are change integrity by the amount of net gross sales so that the income statement figures will become percentages of net sales. All balance sheet amounts are split up by correspond assets so that the balance sheet figures will become percentages of total assets, (Dictionary). Using vertical analysis is very helpful when comparing a attach tos percentages between statements, (Price, Haddock, & Brock, para.Vertical analysis of financial statements, 2007). It stick out also be helpful when comparing numbers of two companies that are within the selfsame(prenominal) trade such(prenominal) as the companies b eing analyzed in this paper PepsiCo, Inc. and Coca-Cola Company. Using vertical analysis will help us to compare how well each community did in the certain accounts that were analyzed. The reason we lack to do these comparisons is because it go off sometimes be difficult to determine how frequently each statement is outlay within a company or when compared to a nonher 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 authoritative assets by the total assets. This will tell us what percentage of the assets in the company are accredited. To attain 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 make up 6. 5%. We will perform a similar problem to mention what percentage of total assets are shareholder equity.Taki ng the total assets, $31,727, and dividing that by the shareholder equity, $14,320, we actualise that the shareholder equity makes up 2. 22% of the total assets, (University of Phoenix, 2008). This can be done 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. authoritative 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. turn back the equations below Two measures of vertical analysis- 1. up-to-the-minute 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 horizontal analysis. According to Accounting Coach (2012), This method involves financial statements reporting amounts for several years. The earliest year presented is designated as the grounding year and the succeeding years are expressed as a percentage of the base year amounts. This allows the analyst to more 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 prior year, that company 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 decreased 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 gain increased or decreased in 2004 or 2005. This enables investors to see the profit of a company and gives insight into which companies are best 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 idea 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. %. N ext we will smelling 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 increase their assets and liabilities in forethought of a higher ratio of consumers. We cannot judge what is best to invest in based solely 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 Co ca-Cola 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 decreased 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% Judging on the numbers, we can see that Coca-Cola had a worthy decrease in both their assets and liabilities. This is positive thing in the eyes of investors or potential 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 putting 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 spirit 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 lessened in percentage from 2004 to 2005 does not mean they are a wiser investing plectron. 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 reasons.I woul d 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 between 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. high liabilities and assets can mean the opposite is happening. PepsiCo would be making a wise choice if they avoid increasing those accounts. Comparing accounts, statements, and percentages within a company or to another company is made much easier with tools such as vertic al 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 look upon that The information received from the two types of analyses can influence investors and potential clients alike. Maintaining balanced percentages with increasing and decreasing determine 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//www. investopedia . com/terms/h/horizontalanalysis. aspaxzz1z91O1lS9 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.