Prepare a spreadsheet to support a statement of cash flows

Assignment Help Financial Management

Reference no: EM132134296

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.

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.

Reference no: EM132134296

Questions Cloud

What do you understand by product life cycle : B104 - Marketing Management - What do you understand by product life cycle? Discuss implications and limitations of product life cycle concept

What is the probability that more than one customer : What is the probability that more than one customer will arrive during the next 30 minutes?

Farmer friend claims that aliens made crop circles : Prof G's farmer friend claims that aliens made crop circles in his farm. Using economic theory, prove his farmer friend wrong.

Economic effects differ between the two types of goods : How will the economic effects differ between the two types of goods? How will the effects be similar?

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

Why would the government impose quotas : Why would the government impose quotas when tariffs not only would reduce imports but also bring in new revenues for the treasury?

Economic adviser to the president and someone made : If you were an economic adviser to the president and someone made this suggestion, what would you say in response to this proposal?

Calculate the equilibrium value of income : Calculate the equilibrium value of income. Calculate the value of the multiplier.

What is the equilibrium weekly wage and quantity of teachers : What is the equilibrium weekly wage and quantity of teachers in each school? What is the pay difference between the two schools?

User Account

All Pages