Please answer each part correctly in Excel with proper labels and any required formulas. Part b requires a knowledgeable comment regarding BBB company's statement of cash flows and any key indicators that would reveal weaknesses in operating cash flows. A positive rating will be given if these instructions are followed. THANK YOU!

P 10-3 BBB Company's balance sheet and income statement follow: BBB COMPANY Balance Sheet December 31, 2011 and 2010 December 31 2011 2010 Assets Cash Marketable securities Accounts receivable Inventories $ 4,000 2,000 7,200 8,000 21,200 12,000 20,500 (3,000) 70,000 $ 4,500 6,800 Total current assets 21,300 11,000 24,000 (3,800) 70,000 (14,000) 108,500 2 Equipment Accumulated depreciation-equipment Building Accumulated depreciation-building Total assets Liabilities and Stodkholders' Equity Accounts payable Wages payable Taxes payab 108,700 $ 7,800 1,050 500 $ 7,000 1,000 1,500 Total current liabilities Bonds payable Common stock, $10 par Additional paid-in capital Retained earnings 30,000 32,000 21,000 16,150 $108,500 30,000 30,000 19,200 Total liabilities and stockholders' equity BBB COMPANY Income Statement For Year Ended December 31, 2011 $38,000 Operating expenses: $ 2,800 35.,000 Depreciation expense Other operating expenses Operating income Gain on sale of land Income before tax expense Tax expense Net income 1,000 500 500 (continued)