Share
Explore BrainMass

Annual reports of PepsiCo and Coca-Cola: Vertical and horizontal analysis

See the attached files.

Review the annual reports for PepsiCo, Inc. and The Coca-Cola Company in Appendixes A & B, especially the Consolidated Statements of Income and the Balance Sheets on pp. A4, A6, B1, & B2 of Financial Accounting.

Write a paper in APA format with citations and references that provides a financial comparison of the two companies and your recommendations to improve the financial status of each.

Include the following:

o An introductory paragraph with a statement of the purpose of your paper and a synopsis of what readers may expect to find in the paper - It is best to write this after writing the rest of the paper.

o Vertical analyses for both companies - You may use your calculations from the Checkpoint Ratio, Vertical, and Horizontal Analyses, providing you show your work.

o Horizontal analyses for both companies - You may use your calculations from the Checkpoint Ratio, Vertical, and Horizontal Analyses, providing you show your work.

Attachments

Solution Preview

Please find the file attached.

1. Final Project: Financial Analysis

? Review the annual reports for PepsiCo, Inc. and The Coca-Cola Company in Appendixes A & B, especially the Consolidated Statements of Income and the Balance Sheets on pp. A4, A6, B1, & B2 of Financial Accounting.

? Write a paper in APA format with citations and references that provides a financial comparison of the two companies and your recommendations to improve the financial status of each.

? Include the following:

o An introductory paragraph with a statement of the purpose of your paper and a synopsis of what readers may expect to find in the paper - It is best to write this after writing the rest of the paper.

o Vertical analyses for both companies - You may use your calculations from the Checkpoint Ratio, Vertical, and Horizontal Analyses, providing you show your work.

o Horizontal analyses for both companies - You may use your calculations from the Checkpoint Ratio, Vertical, and Horizontal Analyses, providing you show your work.

Please note that in conducting the analysis, I have used the current year's figures instead of averages since the data for 2003 is not available.

In this paper, I have attempted to analyze the financial statements of two industry leaders in the field of soft drinks, Pepsico, Inc., and The Coca-Cola Company. In this analysis, I have conducted a vertical analysis (also called common-size analysis) which is a technique that expresses each financial statement item as a percent of a base amount.

In this analysis, the base for assets is Total Assets, for liabilities and stockholders' equity, the base is the Total Liabilities, and Stockholders' Equity, and finally for Income Statement accounts, the base is Net Sales or Net Revenues.

I have also conducted a horizontal Analysis (also known as Trend Analysis) which is a technique for evaluating a series of financial statement data over a period of time. Its purpose is to determine the increase or decrease that has taken place. This change may be expressed as either an amount or a percentage.

Through examining the financial statements of Pepsico, Inc, and The Coca-Cola Company, I would like to present the following analysis:

Overall, both companies seem to be improving which can be seen from the Horizontal Analysis and Vertical Analysis on the attached excel sheet.

Almost all items on Pepsico's balance sheet have favorably increased between 2004 and 2005; yet it is obvious that current assets have not increased with the same rate as current liabilities, which would explain why the current ratio have decreased from 2004 to 2005.

For Coca-Cola, however current assets have decreased from $12,281 in 2004 to $10,250 in 2005, while current liabilities have decreased from $11,133 in 2004 to $9,836 in 2005.

For Pepsico, Inventories have increased from $1,541 in 2004 to $1,693 in 2005; this could be a favorable sign especially when we see the improvement in the ...

$2.19