Prepare a spreadsheet to support a statement of cash flows


Assignment

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.

Required:

1. Prepare a spreadsheet to support a statement of cash flows for the year ended June 30, 2017.

2. 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.

3. 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.

Format your assignment according to the following formatting requirements:

1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.

2. The response also include a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.

3. Also Include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.

Attachment:- Smart-Company.rar

Request for Solution File

Ask an Expert for Answer!!
Financial Management: Prepare a spreadsheet to support a statement of cash flows
Reference No:- TGS02129214

Expected delivery within 24 Hours