please solve :

- please use the same format when solving the problem.

- show on excel

- show work

- show formulas

-explain

Thank you!

E A F G H 2 3 P11-15M (See the modified information in the written material below) 4 5 OTR Trucking runs a fleet of long-haul trucks and has recently expanded into the Midwest, where it has decided to build a maintenance facility. This project will require an initial cash outlay of $24.5 million and will generate annual cash inflows of $4.7 million per year for Years 1 through 4. In Year 5, the project will provide a net negative cash flow of $3.5 million due ot anticipated expansion of and repairs to the facility. During Years 6 through 10, the project will provide cash inflows of $2.7 million per year Calculate the project's NPV, IRR, and MIRR, using 8% as the discount rate and the MIRR investment rate, 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Year 0 1 2 3 4 5 ORAN Project $(24,500,000.00) 4,700,000.00 4.700,000.00 4,700,000.00 4,700,000.00 (3,500,000.00) 2,700,000.00 2,700,000.00 2,700,000.00 2,700,000.00 2,700,000.00 7 8 9 10 D E E A B 21 6 7 22 23 8 2,700,000.00 2,700,000.00 2,700,000.00 2,700,000.00 2,700,000.00 9 10 24 25 26 27 Discount Rate 8.00% 28 29 30 31 32 FCF PV = NPV = PI = 33 34 IRR 35 36 37 38 MIRR 39 40 41