THIS IS THE ASSIGNMENT I NEED HELP WITH

Overview

Questions:

Alternate financial scenarios. Use this section to discuss the sensitivity of your financial projections to different scenarios. Be sure to address:

a. How would your projected financial performance change if sales fall 20% short of or are 20% higher than your base assumption? What does your analysis of these two scenarios imply for the proposed investment? Justify your response.

b. What do the net present value, internal rate of return, and payback values from your base scenario and the sales variation scenarios above imply for the proposed investment? Be sure to explain how the time value of money affects your calculations and analysis

Financial impact. This section should discuss the project's most likely financial implications and the consolidated financial projection with and without the project. Be sure to:

1. Project the incremental, annual, and cumulative cash benefits and outflows associated with the proposed expansion for the next seven to 10 years, using a spreadsheet or other relevant presentation vehicle to support your narrative. Be sure to justify your assumptions and methodology based on sound microeconomic and financial principles. For example, what assumptions have you made about demand, price, volume, capital purchase costs, incremental hiring, and so on?

2. Develop a consolidated financial projection of revenue, pretax income, and cash flow for the overall business, over that same number of years, both with and without the proposed investment. Use a spreadsheet or other relevant presentation vehicle to support your narrative, being sure to describe any relevant assumptions.