i have to create a balance sheet with the below information for an assignment due in 497465
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)
We've got everything to become your favourite writing service
Money back guarantee
Your money is safe. Even if we fail to satisfy your expectations, you can always request a refund and get your money back.
Confidentiality
We don’t share your private information with anyone. What happens on our website stays on our website.
Our service is legit
We provide you with a sample paper on the topic you need, and this kind of academic assistance is perfectly legitimate.
Get a plagiarism-free paper
We check every paper with our plagiarism-detection software, so you get a unique paper written for your particular purposes.
We can help with urgent tasks
Need a paper tomorrow? We can write it even while you’re sleeping. Place an order now and get your paper in 8 hours.
Pay a fair price
Our prices depend on urgency. If you want a cheap essay, place your order in advance. Our prices start from $11 per page.