Exercise 12-14A 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 $103,000. b. Dividends of $86,000 cash were declared and paid. c. The only noncash expense was $73,000 of depreciation. d. Purchased plant assets for $73,000 cash. e. Notes payable of $23,000 were issued for $23,000 cash. f. $73,000 increase in accounts receivable. g. $23,000 decrease in inventory. h. $13,000 decrease in accounts payable. SCORETECK CORPORATION Spreadsheet for Statement of Cash FlowsIndirect Method For Year Ended December 31, 2019 Analysis of Changes Dec. 31, 2018 Dec. 31, 2019 Debit Credit Balance Sheet-Debit Bal. Accounts Cash $ 89,000 $ 66,000 Accounts receivable 123,000 196,000 Inventory 256,000 233,000 Plant assets 603,000 676,000 $ 1,071,000 $ $ 1,171,000 Balance Sheet-Credit Bal. Accounts Accumulated depreciation $ 103,000 176,000 Accounts payable 156,000 143,000 Notes payable 373,000 396,000 Common stock 203,000 203,000 Retained earnings 236,000 253,000 $ 1,071,000 $ 1,171,000 Statement of Cash Flows Operating activities Notes payable 373,000 396,000 Common stock 203,000 203,000 Retained earnings 236,000 253,000 $ 1,071,000 $ 1,171,000 Statement of Cash Flows Operating activities Investing activities Financing activities $ 0 $ 0