Statement of cash flows (indirect method).The net changes in the balance sheet accounts of Keating Corporation for the year 2011 are shown below.

Statement of cash flows (indirect method).The net changes in the balance sheet accounts of Keating Corporation for the year 2011 are shown below.Account Debit Credit Cash $ 82,000Short-term investments $121,000Accounts receivable 83,200Allowance for doubtful accounts 13,300Inventory 74,200Prepaid expenses 17,800Investment in subsidiary (equity method) 20,000Plant and equipment 210,000Accumulated depreciation 130,000Accounts payable 80,700Accrued liabilities 21,500Deferred tax liability 15,5008% serial bonds 80,000Common stock, $10 par 90,000Additional paid-in capital 150,000Retained earnings—Appropriation for bonded indebtedness 60,000Retained earnings—Unappropriated 38,000 $643,600 $643,600An analysis of the Retained Earnings—Unappropriated account follows:Retained earnings unappropriated, December 31, 2010 $1,300,000Add: Net income 327,000Transfer from appropriation for bonded indebtedness 60,000Total $1,687,000Deduct: Cash dividends $185,000Stock dividend 240,000 425,000Retained earnings unappropriated, December 31, 2011 $1,262,0001. On January 2, 2011 short-term investments (classified as available-for-sale) costing $121,000 were sold for $155,000.2. The company paid a cash dividend on February 1, 2011.3. Accounts receivable of $16,200 and $19,400 were considered uncollectible and written off in 2011 and 2010, respectively.4. Major repairs of $33,000 to the equipment were debited to the Accumulated Depreciation account during the year. No assets were retired during 2011.5. The wholly owned subsidiary reported a net loss for the year of $20,000. The loss was recorded by the parent.6. At January 1, 2011, the cash balance was $166,000.InstructionsPrepare a statement of cash flows (indirect method) for the year ended December 31, 2011. Keating Corporation has no securities which are classified as cash equivalents.

If you want the formulas and any calculations, select the corresponding cell and press F2(Function Key on key board),It will show all calculations and formulas AutomaticallyQuestion:Statement of...