Below you will find selected information (in millions) from Coca-Cola Co.’s 2012 Annual
limraIncome Taxes Payable | $471 |
Short-term Investments and Marketable Securities | 8,109 |
Cash | 8,442 |
Other non-current Liabilities | 10,449 |
Common Stock | 1,760 |
Receivables | 4,812 |
Other Current Assets | 2,973 |
Long-term Investments | 10,448 |
Other Non-current Assets | 3,585 |
Property, Plant and Equipment | 23,486 |
Trademarks | 6,527 |
Other Intangible Assets | 20,810 |
Allowance for Doubtful Accounts | 53 |
Accumulated Depreciation | 9,010 |
Accounts Payable | 8,680 |
Short Term Notes Payable | 17,874 |
Prepaid Expenses | 2,781 |
Other Current Liabilities | 796 |
Long-Term Liabilities | 14,736 |
Paid-in-Capital in Excess of Par Value | 11,379 |
Retained Earnings | 55,038 |
Inventories | 3,264 |
Treasury Stock | 35,009 |
Other information taken from the Annual Report:
Sales Revenue for 2012 | $48,017 |
Cost of Goods Sold for 2012 | 19,053 |
Net Income for 2012 | 9,019 |
Inventory Balance on 12/31/11 | 3,092 |
Net Accounts Receivable Balance on 12/31/11 | 4,920 |
Total Assets on 12/31/11 | 79,974 |
Equity Balance on 12/31/11 | 31,921 |
Required:
1. Using the information provided prepare a Balance Sheet. Separate the current assets from non-current assets and provide a total for each. Also separate the current liabilities from the non-current liabilities and provide a total for each.
2. Using the Balance Sheet from your answer above, calculate the Current Ratio and Return on common stockholders’ equity ratio. (Make sure to show all your work).
Question 2. (TCO B) The following selected data was retrieved from the Wal-Mart, Inc. financial statements for the year ending January 31, 2013:
Required: |
Question 3.
Required: 1) Please calculate the percentage increase or decrease in cash for the total line of the operating, investing, and financing sections bolded above and explain the major reasons for the increase or decrease for each of these sections. 2) Please calculate the free cash flow for 2012 and explain the meaning of this ratio. |
Question 4. a. Goforit carries significant electronics inventory in a competitive environment where prices are actually falling. Which inventory valuation method would you choose—LIFO, FIFO, or average cost? Assume that unit purchases exceed unit sales. |
Question 5.
Ratio Name | Johnson & Johnson | Pfizer |
|
|
|
Profit margin | 16.1% | 24.7% |
Inventory turnover ratio | 3.1 | 1.7 |
Average collection period | 59.4 days | 69.1 days |
Cash debt coverage ratio | .27 | .16 |
Debt to Total assets | 46.6% | 127.5% |
Required:
1) Please explain the meaning of each of the Pfizer ratios above.
2) Please state which company performed better for each ratio.
- 9 years ago
Purchase the answer to view it
- acct_504_final_exam_tutorial.xlsx