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 Smart 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. For written answers, please make sure your responses are well-written, formatted per CSU-Global Guide to Writing and APA and have proper citations, where applicable.
Smart Company is preparing its financial statements for the year ended June 30, 2017. 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.
Download the excel spreadsheet found in the link below.
- Prepare a spreadsheet to support a statement of cash flows for the year ended June 30, 2017.
- In the tab named ‘Journal Entries’, show in journal entry form, the entries that would be made in preparation of the statement of cash flows.
- Prepare Smart Company’s statement of cash flows for the year ended June 30, 2017. 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 noncash financing and investing activities.
Submit a well-formatted electronic file,