Answer the following question using excel and showing the cell formulas embedded in each cell in the template

Question 4. Answer the following problem based on the Corporate Financial Analysis textbook. Your answer should be formatted similarly to Figure 13-1 on page 403 of that textbook. ( 25 pts) Dinsmore Artists International is in the business of managing "pop" artists in the entertainment industry. It is considering the purchase of an executive jet plane to transport its executives and the artists it represents to various meetings and performance sites. It expects that by owning its own executive jet, it can save $1,400,000 the first year of operation for expenses that it would otherwise incur for buying seats on commercial flights or for chartering flights. It expects that the annual growth in savings would be 10%. The choice has narrowed down to two planes: the Acro Commander and the Super Eagle. Both provide the same savings and the same basic service (e,g, the same passenger and luggage capacity, flight speed, and maximum altitude of operation). The Aero Commander jet sells for $4,500,000. Its normal operating expenses would be $290,000 the first year and would increase 8% per year thereafter. In addition, there would be a cost of $350,000 for a major engine overhaul at the end of the third year. The cabin noise level in the Aero Commander is lower than in the Super Fagle, and its seats are somewhat more comfortable. The Super Eagle jet sells for $3,750,000. It normal operating expenses would be $325,000 the first year and would increase 8% per year thereafter. In addition, there would be major engine overhauls at the end of the second and fourth years, ench of which would cost $300,000. Dinsmore uses a WACC or discount rate of 10% and a reinvestment rate of 12% to value its investments in fixed assets. Tax rates are 38% for regular income and 25% for capital gains or losses. The jet purchased would be paid for and put into service during the first quarter of Dinsmore's financial year. It would be depreciated according the appropriate MACRS schedule (i.e., 7-year life with first-quarter convention). The MACRS percentages for years 15 are 25.0%,21.43%,15.31%,10.93%, and 8.75% Dinsmore expects to sell whichever plane it chooses at the end of the fifth year for 20% of its purchase price. 1. What is the net present value, internal rate of return, and modified internal rate of return associated with each of the two jet planes? Based on these values, what action do you recommend Dinsmore to take? 2. What non-financial information should Dinsmore take into consideration before making its final decision? Why might the information be important in Dinsmore's decision? How might this information change the decision in