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

Question # 00005815 Posted By: spqr Updated on: 12/27/2013 12:30 AM Due on: 01/30/2014
Subject Accounting Topic Accounting Tutorials:
Dot Image

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


1. Using the information provided prepare aBalanceSheet. Separate the current assets from non-currentassets 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 . (TCO B) The following selected data was retrieved from the Wal-Mart, Inc. financial statements for the year ending January 31, 2013:

Accounts Payable $38,080

Accounts Receivable 6,768

Cash 7,781

Common Stock 3,952

Cost of Goods Sold 352,488

IncomeTax Expense 7,981

Interest Expenses 2,064

Membership Revenues 3,048

Net Sales 466,114

Operating, Selling and Administrative Expenses 88,873

Retained Earnings 72,978


Using the information provided above:

1. Prepare a multiple-stepincomestatement

2. Calculate the Profit Margin, and Gross profit rate for the company. Be sure to provide the formula you are using, show your calculations, and discuss your findings/results.

Dot Image
Tutorials for this Question
  1. Tutorial # 00005605 Posted By: spqr Posted on: 12/27/2013 12:31 AM
    Puchased By: 3
    Tutorial Preview
    The solution of Below you will find selected information (in millions) from Coca-Cola Co.’s 2012 Annual Report:...
    cola12-21.xls (30 KB)
    Recent Feedback
    Rated By Feedback Comments Rated On
    co...12 Rating Highly informative tutorials 01/19/2016

Great! We have found the solution of this question!

Whatsapp Lisa