If you could possibly use the FSET template below that would be amazing! Thank you.

M4-25, Reconciling Net Income and Cash Flow from Operations Using FSET -For fiscal year 2015, Beyer GMBH had the following summary information available concerning its operating activities. The company had no investing or financing activities this year. 1. Sales of merchandise to customers on credit 2. Sales of merchandise to customers for cash... 3. Cost of merchandise sold on credit. . .. 4. Cost of merchandise sold for cash . . . . . . . 5. Purchases of merchandise from suppliers on credit..:. 6. Purchases of merchandise from suppliers for cash. . . . . .. 7. Collections from customers on accounts receivable. 8. Cash payments to suppliers on accounts payable . 9. Operating expenses (all paid in cash) . .. 507,400 91,500 . .. . 320,100 63,400 351,600 47,700 .. . . 483,400 340,200 . . 172,300 REQUIRED Enter the items above into the Financial Statement Effects Template. Under noncash assets, use two separate columns for accounts receivable and inventories. Calculate the totals for each column. What was the company's net income for the year? What was the cash flow from operating activities? (Use the direct method.) Indicate the direction and amounts by which each of the following accounts changed during the year. 1. Accounts receivable 2. Merchandise inventory 3. Accounts payable a. b. c. d. Using your results above, prepare the operating activities section of the statement of cash flows using the indirect format