1. (TCO A) Below you will find selected information (in millions) from Coca-Cola Co.”?s 2012 Annual…

1. (TCO A) Below you will find selected information (in millions) from Coca-Cola Co. s 2012 Annual Report:

Income 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; Current Ratio, Days in Inventory, Average Collection Period, Return on Assets Ratio, Debt to Total Assets and Return on common stockholders equity ratio. (Make sure to show all your work)

(Points : 36)

"Is this question part of your assignment? We can help"

ORDER NOW