Exercise 12-14 A 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 os positive values.) Additional information: a. Net income for the year was $118,000. b. Dividends of $116,000 cash were declared and paid. c. The only noncash expense was $88,000 of depreciation d. Purchased plant assets for $88,000 cash e. Notes payable of $38,000 were issued for $38,000 cash f. 588,000 increase in accounts receivable. 9. $38,000 decrease in inventory h. $28.000 decrease in accounts payable SCORETECK CORPORATION Spreadsheet for Statement of Cash Flows Indirect Mothod For Year Ended December 31, 2019 Analysis of Changes Dec 31, 2018 le we Dec 31, 2019 Dec. 31, 2019 $ SCORETECK CORPORATION Spreadsheet for Statement of Cash Flows Indirect Method For Year Ended December 31, 2019 Analysis of Changes Dec 31, 2018 Debit Credit Balance Sheet-Debit Bal Accounts Cash $ 134,000 Accounts receivable 138,000 Inventory 286,000 Plant assets 618,000 $ 1,176,000 Balance Sheet Credit Bal Accounts Accumulated depreciation $ 118,000 Accounts payable 186,000 Notes payable 388,000 Common stock 218,000 Retained earnings 266,000 $ 1.176,000 96,000 226,000 248,000 706,000 1,276,000 $ 206.000 158,000 426,000 218 000 268.000 1276 000 $ Common stock Retained earnings 218,000 266,000 1,176,000 218,000 268,000 1,276,000 GA $ Statement of Cash Flows Operating activities Investing activities Financing activities