Exercise 12-16A (Static) Indirect: Cash flows spreadsheet LO P4 Complete the following Spreadsheet for the preparation of statement of cash flows under the indirect method . (The statement of cash flows is not required .) (Enter all amounts as positive values.) Additional information : a. Net income for the year was $100,000 b. Dividends of $80,000 cash were declared and paid. c. The only noncash expense was $70,000 of depreciation d. Purchased plant assets for $90,000 cash . e. Notes payable of $20,000 were issued for $20,000 cash f. $50,000 increase in accounts receivable . g. $30,000 decrease in inventory h. $10,000 decrease in accounts payable.

Check my work Exercise 12-16A (Static) Indirect: Cash flows spreadsheet LO P4 Complete the following Spreadsheet for the preparation of statement of cash flows under the indirect method (The statement of cash flows is not required.) (Enter all amounts as positive values.) Additional information: a. Net income for the year was $100,000. b. Dividends of $80,000 cash were declared and paid. c. The only noncash expense was $70,000 of depreciation d. Purchased plant assets for $90,000 cash. e. Notes payable of $20,000 were issued for $20,000 cash, f. $50,000 Increase in accounts receivable. g. $30,000 decrease in inventory. h. $10,000 decrease in accounts payable. SCORETECK CORPORATION Spreadsheet for Statement of Cash Flows-Indirect Method For Year Ended December 21, 2020 Analysis of Changes Dec 31, 2019 Debit Credit Dec 31, 2020 17 Dec 31, 2020 0.83 points $ ebook Hint 70.000 170.000 220.000 690,000 1.150.000 PI Reference 5 SCORETECK CORPORATION Spreadsheet for Statement of Cash Flows-Indirect Method For Yoar Ended December 31, 2020 Dec 31, 2019 Analysis of Changes Debit Credit Balance Sheel-Debit Bal. Accounts Cast $ 80.000 Accounts receivable 120,000 Inventory 250,000 Plant assets 600,000 $ 1,050,000 Balance Sheet.Credit Accounts Accumulated depreciation $ 100.000 Accounts payable 150,000 Notes payable 370,000 Common stock 200,000 Recained earings 230,000 $ 1.050,000 Statement of Cash Flows Opening activities Net income 100,000 Depreciation expense 70.000 Increase in outis receivable 50,000 Decrease in inventory 30.000 $ 170,000 140,000 390,000 200,000 250,000 1,150,000 S 0.83 points Accounts payable Notes payable Common stock Retained earnings 150,000 370,000 200,000 230,000 1,050,000 110,000 140,000 390,000 200,000 250,000 1,150,000 $ $ Book Statement of Cash Flows Operating activities 100.000 70,000 References Net income Depreciation expense Increase in accounts receivable Decrease in inventory Decrease in accounts payable 50,000 30,000 10,000 Investing activities Cash paid to purchase plant assets 90,000 Financing activities Cash from issuance of notes payable Cash paid for dividends 20,000 80,000 $ 220,000 $ 230.000