Ratio, Vertical, and Horizontal analyses
Not what you're looking for?
Examine PepsiCo, Inc.'s Consolidated Balance Sheet on p. A6 in Appendix A of Financial Accounting, especially its Current Assets, Current Liabilities, and Total Assets for years 2004 and 2005.
Calculate the following for PepsiCo, Inc. and show all calculations:
a) Debt to total Asset Ratio for 2005
b) Debt to total Asset Ratio for 2004
c) Compute the vertical analysis of current Liabilities to total Liabilities for 2005 & 2004, and express your result as a percentage
d) Compute the horizontal analysis since base period - the change in total assets for 2005 to 2004. Compute the change in current liabilities for 2005 to 2004
Examine The Coca-Cola Company's Consolidated Balance sheet on p. B2 in Appendix B of Financial Accounting, especially its Current Assets, Current Liabilities, and Total Assets for years 2005 and 2004.
Calculate the following for Coca-Cola and show your work:
a) Debt to total Asset Ratio for 2005
b) Debt to total Asset Ratio 2004
c) Compute the vertical analysis of current Liabilities to total Liabilities for 2005 & 2004, and express your result as a percentage
d) Compute the horizontal analysis since base period - the change in total assets for 2005 to 2004. Compute the change in current liabilities for 2005 to 2004
Purchase this Solution
Solution Summary
The expert examines ratio, vertical and horizontal analysis. Debt to total asset ratios are examined.
Solution Preview
I am attaching an Excel file here with all ratios (Liquidity, solvency, & profitability)
Wishing you all the best.
PEPSI CO.
Ratio Analysis
2004 2005
A) Liquidity Ratios:
Current Ratio 1.28 1.11
Acid Test Ratio 0.95 0.87
Receivables Turnover 9.76 9.99
Average Days Receivables 37.41 36.55
Inventory ...
Education
- BA, Ain Shams University, Cairo Egypt
- MBA, California State University, Sacramento
Recent Feedback
- "ty i have more need help with"
- "ty i have jmore i need help with"
- "great help"
- "excellent help"
- "Very helpful and easy to understand."
Purchase this Solution
Free BrainMass Quizzes
Academic Reading and Writing: Critical Thinking
Importance of Critical Thinking
Accounting: Statement of Cash flows
This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.
Balance Sheet
The Fundamental Classified Balance Sheet. What to know to make it easy.
Learning Lean
This quiz will help you understand the basic concepts of Lean.
MS Word 2010-Tricky Features
These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.