B. Calculate the firms operating cash flow for the year Ended Dec. 31, 2012 using figure 2.2

(I need this to be used in Excel, thanks in advance.)

Income Statement Data (2012, $ in millions)

Depreciation expense $1600

Earnings before interest and taxes (EBIT) 4,500

Taxes 1,300

Net profit after taxes 2,400

SMG Industries Balance Sheets ($ in millions) December December Liabilities and December December Assets 31, 2012 Stockholders' Equity 31, 2011 31, 2012 31, 2011 Cash $ 3,500 $ 3,000 $ 3,500 4,200 1,300 $9,000 $ 6,000 $11,000 5,800 $ 3,600 4,800 1,200 $9.600 $ 6,000 $11,000 6,400 Accounts payable Notes payable Accruals Marketable securities 3,800 3,200 Accounts Total current liabilities Long-term debt Common stock Retained earnings Total stockholders receivable 4,000 3,800 Inventories 4.900 4,800 Total current $16.200 $14,800 assets $17,400 $16,800 equity Total liabilities and Gross fixed $30,100 $31,500 assets stockholders' equity $33,000 $31,800 Less Accumulated 13,100 14,700 depreciation Net fixed $16.800 $33,000 $17,000 $31,800 assets Total assets