This is from the appendixes in the 7th edition of financial accounting by Weygandt, kimmel, and kieso. Instructions;
(a) Based on the information contained in these financial statements, determine each of the following for each company. Please show all numerical equations including numerator and denominator, not just a final number. Present your work in a comparative format using a table as illustrated:
1) Gross profit for 2008 PepsiCo Coca-Cola and Gross profit rate for 2008. 2) Percent change in operating income from 2007 to 2008.
3) Accounts receivable turnover for 2008.
4) Days sales in receivable for 2008.
5) Inventory turnover for 2008.
6) Days inventory on hand for 2008.
7) Increase (decrease) in cash and cash equivalents from 2007 to 2008.
8) Asset turnover ratio for 2008.
9) Working capital at the end of 2008.
10) Current ratio at the end of 2008.
11) Debt (excluding “deferred income taxes”) to total assets at the end of 2008.
12) Book value per share at the end of 2008.
(Hint: Use the value reported for “common shareholders’ equity” as the numerator for PepsiCo.)
13) Compare the market value per share for each company to the book value per share at the end of 2008. Assume that the market value of Coca-Cola’s stock was $45.27
14) Why are book value and market value per share different?
15) Return on common stockholders’ equity at the end of 2008.
Answer: | PepsiCo | Coca-Cola | | 2008 | 2008 | 1) Gross profit rate for 2008. (Gross Profit / Sales) | 52.9% | 64.4% | 2) Percent change in operating income from 2007 to 2008. | -3.10% | 16.46% | 3) Accounts receivable turnover for 2008. (sales / Average accounts receivable) | 9.54 | 9.97 | 4) Days sales in receivable for 2008. (365 / Accounts receivable turnover) | 38 | 37 | 5) Inventory turnover for 2008. (Cost of goods