ea Spreadsheet Assignments 94 65 Use 20x De 64 STATEMENT OF

ea Spreadsheet Assignments 94 65. Use 20x De 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: $237,000 Sales revenue Expenses Cost of goods sold.. Salary expense Depreciation expense.. Rent expense. Interest expense Income tax expense.... 103,000 45,000 29,000 11,000 2,000 9000 199,000 38,000 Additional data during fiscal year 20x2 Collections from customers were $7,000 more than sales. Payments to suppliers were $5,000 less than the sum of cost of goods sold plus rent expense Payment to employees were $1,000 more than salary expense. Interest expense and income tax expense equal their cash amounts. 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. a. b. c. d. e. f. Proceeds from sales of land, $14,000. Proceeds from issuance of common stock, $35,000. h. Payment of long-term note payable, $20,000. i. Payment of dividends, $10,000. j. Decrease in cash balance, $4,000. Prepare Aggieland Computing Company\'s statement of cash flows and accompanying schedule of noncash investing and financing activities. Report operating activities 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, and financing), and give the reason for your evaluation. 1. 2.

Solution

Cash flow from operating activities Cash collection from customer (237000+7000) 244000 Cash payments Payment to suppliers (103000+11000-5000) -109000 Payment to employees (45000+1000) -46000 Interest expense paid -2000 Income tax paid -9000 Total cash payments -166000 Cash flow from operating activities 78000 Cash flow from investing activities Purchase of equipment -101000 Sale of land 14000 Cash used in investing activities -87000 Cash flow from financing activities Issue of common stock 35000 Payment of long term notes payable -20000 Payment of dividends -10000 Cash flow from financing activities 5000 Net Cash and cash equivalent -4000