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 $106.000, b. Dividends of $92,000 cash were declared and paid. c. The only noncash expense was $76,000 of depreciation d. Purchased plant assets for $76,000 cash. e. Notes payable of $26,000 were issued for $26,000 cash. f. $76,000 increase in accounts receivable, g. $26.000 decrease in inventory. h. $16,000 decrease in accounts payable SCORETECK CORPORATION Spreadsheet for Statement of Cash Flows-Indirect Method For Year Ended December 31, 2019 Analysis of Changes Dec 31, 2018 Dec 31, 2019 Debid Credit Balance Sheet-Debit Bal Accounts Cash $ 98,000 72,000 Accounts receivable 126,000 76.000 202.000 Inventory 262,000 236,000 Plant assets 606,000 76,000 682,000 $ 1.092,000 $ 1,192,000 Balance Sheet Credit Bal Accounts Accumulated depreciation 5 105,000 76.00015 182 000 Accounts payable 162.000 16,000 146,000 Notes payable 376,000 26.000 402.000 Common stock 206,000 206,000 Retained earnings 242,000 92,000 106,000 256,000 $ 1.092,000 5 1.192.000 Statement of Cash Flows 76,000 Accounts receivable Inventory Plant assets 126,000 262,000 606,000 1,092,000 202,000 236,000 682,000 1,192,000 76,000 S $ 76,000 $ Balance Sheet-Credit Bal. Accounts Accumulated depreciation Accounts payable Notes payable Common stock Retained earnings 106,000 162,000 376.000 16,000 26,000 206.000 182,000 146,000 402,000 206,000 256,000 1,192,000 92,000 242,000 1,092,000 106,000 $ $ Statement of Cash Flows Operating activities Net income Depreciation expense Increase in accounts receivable 106,000 76,000 76,000 26,000 Decrease in accounts payable 16,000 Investing activities Cash paid to purchase plant assets 76,000 Financing activities Cash from issuance of notes payable Cash paid for dividends 26,000 92.000 $ 494,000 $ 468,000