Ratio, Vertical, and Horizontal Analysis Checkpoint

The three tools of the financial statement analysis are the company’s audited financials, exel templated specially designed for financial analysis or specialized software, and full information about the company’s profile. The tricky part about this would be putting all your skills together and analyzing all the different financials.

PepsiCo, Inc

2005
Current Ratio= 10,454 (Current Assets) = 1.11% 9,406 (Current Liabilities)
2004
Current Ratio= 8,639 (Current Assets) 1.28%
6752 (Current Liabilities) Vertical Analysis- 2005

1,716 (Cash, and Cash Equivalent) 0.054 or 5.4%
3,1727 (Total Assets)

Vertical Analysis- 2004 1,280 (Cash and Cash Equivalent) = 0.046 or 4.6% 27,987 (Total Assets)

Horizontal Analysis- 2005 2005 total current assets=10454 (8639 (total current assets 2004) = 1.2101 or 21%

Horizontal Analysis- 2004 2005 total current liabilities = 9404 (6752 total current liabilities 2004 = 1.393 or 39%.
These shows with the company obtaining more liabilities with an increase of 39% and an increase to its assets by 21%, the results were good.

Coca Cola Company
2005
Current Ratio= 10,250 (Current Assets) 9,836(Current Liabilities) = 1.04 %

2004
Current Ratio= 12,281 (Current Assets) 11,133(Current Liabilities) = 1.10 %

Vertical Analysis- 2005 4,701(Cash, and Cash Equivalent) 0.1598 or 1.6 % 29,427(Total Assets)

Vertical Analysis- 2004 6,707(Cash and Cash Equivalent)= 0.2133 or 2.1 % 31,441(Total Assets)

Horizontal Analysis- 2005
2005 total current assets=10250
2004 total current assets= 12281 =