Complete the following questions. In addition to answering the items below, you must submit an analysis of the assignment. Analyze the specific outcomes and write an analysis directed toward the management team at Booster Company describing what the numbers mean and how they relate to the business. Submit journal entries in an Excel file and written segments in an MS Word document.
Booster Company is preparing its financial statements for the year ended June 30, 2018. The financial statements are complete except for the statement of cash flows. You have been asked to prepare a statement of cash flows for the year ended June 30, 2017.
Required:

Prepare a spreadsheet to support a statement of cash flows for the year ended June 30, 2018.
In the Excel Worksheet column named ‘Worksheet Entries’, show under Debit and Credit, the amounts that would be used in preparation of the statement of cash flows.
Prepare the Booster Company’s statement of cash flows for the year ended June 30, 2018. Prepare the statement of cash flows using the indirect method. Note: For full credit, you must prepare the statement of cash flow in good form with all necessary disclosures, including disclosures about non-cash financing and investing activities.