Xacc 280- Week 7 Check Point Ratio

Calculations- Liabilities and Assets for PepsiCo Inc. based on their consolidated Balance Sheet Current Ratio= 10,454 (Current Assets) | = 1.11% | 9,406 (Current Liabilities) | | 2005

2004 Current Ratio= 8,639 (Current Assets) | = 1.28% | 6,752 (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 (10454 (total current assets 2005) / (8639 (total current assets 2004) = 1.2101 | Or 21% |

Horizontal Analysis- 2004 (9404 (total current liabilities 2005) / (6752 (total current liabilities 2004) = 1.393 | Or 39% | These analysis show: that the PepsiCo has had an increase in assets by 21%, with an increase in liabilities of 39%. This is a result of the company obtaining more liabilities. | |
Calculations- Liabilities and Assets for Coca-Cola Co. based on their consolidated Balance Sheet

2005 Current Ratio= 10,250 (Current Assets) | = % | 9,836(Current Liabilities) | |

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

Vertical Analysis- 2005

%= 4,701(Cash, and Cash Equivalent) | = 0.1598 or | 29,427(Total Assets) | |

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

Horizontal Analysis- 2005 (10250 (total current assets 2005) / (12,281 (total current assets