Step by step with details( Excel chart) please compare the solution with cell contents of the exercise. ( statement of cash flows )

94 Spreadsheet Assignments 64. STATEMENT OF CASH FLOWS The income statement and additional data of Aggieland Computing Company follow: Aggieland Computing Company Income Statement Year Ended September 30, 20x2 Revenues: Sales revenue...... $237,000 Expenses: Cost of goods sold.. 103,000 Salary expense................. 45,000 Depreciation expense. 29,000 Rent expense.......... 11,000 Interest expense...... 2,000 Income tax expense..... 9,000 199.000 Net income....... $ 38.000 Additional data during fiscal year 20x2: a. Collections from customers were $7,000 more than sales. b. Payments to suppliers were $5,000 less than the sum of cost of goods sold plus rent expense. C . Payment to employees were $1,000 more than salary expense. d. Interest expense and income tax expense equal their cash amounts. e . Acquisition of equipment is $116,000. Of this amount, $101,000 was paid in cash, $15,000 by signing a long-term note payable. Aggieland sold no equipment during fiscal year 20x2. f. Proceeds from sales of land, $14,000. g . Proceeds from issuance of common stock, $35,000. h. Payment of long-term note payable, $20,000. Payment of dividends, $10,000. Decrease in cash balance, $4,000. 1. Prepare Aggieland Computing Company's statement of cash flows and accompanying schedule of noncash investing and financing activities. Report operating activities 2. by the direct method. Evaluate Aggieland Computing Company's cash flows for the year. In your evaluation, mention all three categories of cash flows (operating, investing, an financing), and give the reason for your evaluation