The excell is done but needs to checked over.

The main part needed to be done is the powerpoint

1) Congratulations! You have just been hired as the Manager of Financial Analysis at Moog, an East Aurora based manufacturer of sophisticated controls parts for the airline and aerospace industries.
Your first project is for the Anodyne XRT-750, a hydraulic switch that will control a rocket motor on a new generation of cell phone satellites. When fully implemented, these satellites will replace most cell phone towers, and allow you to use your cell phone anywhere in the world. Working with the engineering and marketing staff at Moog, here is what you have learned about the Anodyne XRT-750:
Sales:
In the five years that project is expected to last, your unit sales are projected as:
Year 1: 150, Year 2: 250 Year 3: 450 Year 4: 300 and Year 5: 200
The introduction of the new unit will however result in a decrease in the sale of your existing unit, the Anodyne 100. These units only sell about 25 per year, at $25,000 each, and a gross margin of 50%.
Pricing:
Pricing will start at $100,000 each in year 1, and increase by 8% each year.
Cost of Goods Sold:
It will cost $66,000 to manufacture the units in the first year, and then these costs will decline by 6.5% each year as you gain economies of scale.
Capital Investment: To manufacture the units, you will need to purchase the following:
Deltek 4000 CNC Work Center $5,450,000
Trewson Solid Surface 3-D printer $1,786,000
Each of these has a five-year life for depreciation purposes and is depreciated using straight line. Assume that you pay cash for this equipment at the start of the project.
There is no expected salvage value.
There will also be an increase in New Working Capital of $800,000 at the start of the project, that will be released at the end of the project.
In addition to the Capital Investment, Moog has already spent $650,000 on an engineering feasibility study that was done by an outside consultant.

Incremental Expenses:
You will need to increase salaries in the Manufacturing Department by $567,000, with additional benefits of 65% of salaries. additional administrative salaries will be $345,000, with added benefits of 65%.
Moog has a Cost of Capital of 12.3 %, and a tax rate of 34%. It has a maximum discounted payback of 3 years on new projects.

Analysis Required: You have been asked to make a presentation to John ORourke, CEO of Moog, next Wednesday, April 6. You should prepare a Power Point presentation, with a maximum of five slides, that show the following:
1) A five-year pro-forma income statement and cash flow statement.
2) The projects Net Present Value, Internal Rate of Return, Profitability Index, and Discounted Payback period.
3) A sensitivity analysis of the project based on + 10% and -10% on the unit sales forecast.
4) Your recommendation as to whether Moog should pursue the project.