Develop an Excel spreadsheet model to analyze the scenario within the case. Show AfterTax Cash Flow Analysis for the investment (Find at least Present Worth). You work at an aerospace manufacturing company and you are selected to be part of a team that will evaluate the company's investment. The company can invest in the following: 0 Invest $9.9 million to establish manufacturing capability to build company's next generation unmanned craft 0 Increase of revenue in 15' year is $3,200,000. This amount goes up each year by 5% ination rate. 0 Market Value of $1 .000,000 in today's dollars (Period 0). This amount goes up by 5% ination for 5 years at which point it is sold off. Life 5 years 0 Use Asset Class 37.2 Manufacturer of Aerospace Products- MACRS GDS 7 year recovery the old machines and for the upgrade investment. 0 From Finance Committee: 0 Committee has found investors willing to invest $16.25 million. Projects must meet after tax MARR 15% As an exchange rate. use 1 dollar = .7042 euro's State tax rate 7.7% Federal tax rate 21% Use MACRS GDS depreciation