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 $70,000 cash e. Notes payable of $20,000 were issued for $20.000 cash . $70,000 increase in accounts receivable. g. $20.000 decrease in inventory h. $10,000 decrease in accounts payable Answer is not complete. 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 SheetDobit Bal Accounts Cash 30.000 $ 20,000 Accounts receivable 120.000 70,000 Inventory 250.000 20.000 Dec 31, 2019 $ 50.000 100 000 230.000 Balance Sheet-Debit Bal Accounts Cash 20,000 X $ Accounts receivable Inventory Plant assets 70,000 80,000 120,000 250,000 600,000 1,050,000 20,000 60,000 190,000 230,000 670,000 1,150,000 70,000 Balance Sheet-Credit Bal Accounts Accumulated depreciation Accounts payable Notes payable 70.000 $ 10,000 Common stock 100,000 150,000 370,000 200 000 230,000 1.050.000 20,000 170,000 140,000 390,000 200,000 250,000 1150 000 Retained earnings 20.000 $ Statement of Cash Flows Operating activities Not income Depreciation expense Increase in accounts receivable 100,000 Decro in inventory 70.000 -70,000 20,000 - 10,000 Increase in accounts payable