solve on excel please

PART 1: Please answer and upload the following question as Excel document. The Easterwood Corporation Capital Budgeting. Cost of new plant and equipment: $ 20,900,000 Shipping and installation cost: $ 300,000 . Unit Sales: Year 1 2 3 Unit sold 100.000 IB01000 160.000 100.000 60.000 Sales price per unit: $500 / unit in years 1-4, $380 /unit in year 5 Variable costiper unit: $260 / unit Annual fixed costs: $ 300.000 Net Working Capital (NWC) Requirement: There will be an initial working capital requirement of $1500,000just to get production started. Then, additional networking capital investment each year equal to 7% of the dollar value of sales for that year. Finally, 90% of net working capital will be liquidated at the termination of the project at the end of year 5. The Depretiation Method: Seven-year MARCS percentage will be used. It is assumed that the plan. In five year, this equipment can be sold for about 20% of its acquisition cost.. Assume that the tax rate is 35% and the required return is 25%. Assume that Dophical Corporation has hired you as the financial assistant to prepare a Pro Forma Income Statement. Given the above information, prepare a Proforma Income Statement and determine the free cash flows associated with the project, and apply calculate the following investment technique on Excel. A) the Net Present Value B) the Internal Rate of Return C) the Profitability Index (Bonus)