Problem 16-7BA Indirect: Cash flows spreadsheet P4 Refer to the information reported about Satu Company in Problem 16-6B. Required Prepare a complete statement of cash flows using a spreadsheet as in Exhibit 16A.1 under the indirect method. Identify the debits and credits in the Analysis of Changes columns with letters that correspond to the following list of transactions and events. a. Net income was $202,767. b. Accounts receivable decreased. c. Inventory increased. d. Accounts payable decreased. e. Income taxes payable decreased. f. Depreciation expense was $15.700. g. Purchased equipment for $30,250 cash. h. Issued 3,000 shares at $21 cash per share. i. Declared and paid $60,000 of cash dividends. Check Analysis of Changes column total, 5543,860 SATU COMPANY Comparative Balance Sheets Current Year Prior Year At December 31 Assets Cash Accounts receivable Total current assets Inventory Equipment Accum. depreciation Equipment Total assets Liabilities and Equity Accounts payable Income taxes payable Total current liabilities Equity Common stock, $5 par value Paid-in capital in excess of par, common stock Retained earnings Total liabilities and equity $ 58.750 20 222 78,972 165.667 107.750 (46,700) $305,689 $ 28,400 25,860 54,260 140,320 77.500 (31,000) $241,080 $ 20,372 2.100 $157.530 6,100 163.630 22472 40,000 68,000 25,000 20.000 32.450 175,217 $305.689 $241.080 SATU COMPANY Income Statement For Current Year Ended December 31 Sales $750,800 Cost of goods sold 269,200 Gross profit 481,600 Operating expenses Depreciation expense $ 15,700 Other expenses 173,933 189,633 Income before taxes Income taxes expense 89,200 Net income $202.767 Other ex 291,967 Additional Information on Current-Year Transactions a. Purchased equipment for $30,250 cash. b. Issued 3,000 shares of common stock for $21 cash per share. c. Declared and paid $60,000 of cash dividends