reate an Excel spreadsheet for a production plant that the companywill lease for 5 years at US$1,500,000 per year

Create an Excel spreadsheet for a production plant that the companywill lease for 5 years at US$1,500,000 per year; it will cost the firmUS$4,000,000 in capital (straight-line depreciation, 5 year life) inyear 0; it will cost the firm an additional US$150,000 per year afterthe new production plant is brought online for other expenses; and itwill generate an incremental revenue of US$3,500,000 per year. Use a40% tax rate, a 10% cost of capital, and a 12% re-investment rate.Assume the company will use cash flow to finance the project.Discuss how the project would fair under hurdle rate scenarios of 10%,15%, and 20% (based on MIRR).