5 Exercise 12-13AA Indirect: Cash flows spreadsheet LO P4 a. Net income for the year was $100,000. b. Dividends of $80,000 cash were declared and paid. c. Scoreteck's only noncash expense was $70,000 of depreciation d. The company purchased plant assets for $70,000 cash. 1.25 points 04:00:5e. Notes payable of $20,000 were issued for $20,000 cash. Complete the following spreadsheet in preparation of the statement of cash flow. me statement of eash lows s not equined operating activities under the indirect method. (Enter all amounts as positive values.) eBook RETECK CORPORATION Spreadsheet for Statement of Cash Flowsndirect Method For Year Ended December 31, 2017 1.25 points Dec. 31 Analysis of Changes Debit Dec. 31 2016 Credit 2017 04:00:49 Balance Sheet-Debit Bal. Accounts Cash 80,000 120,000 250,000 600,000 $ 1,050,000 60,000 190,000 230,000 670,000 $1,150,000 Accounts receivable eBook Plant assets Hint Balance Sheet-Credit Bal. Accounts Accumulated depreciation Accounts payable Notes payable Common stock Retained eamings 100,000 150,000 370,000 200,000 230,000 $1,050,000 $170,000 140,000 390,000 200,000 250,000 $ 1,150,000 Print Statement of Cash Flows Operating activities Investing activities Financing activities