IF completed in Excel please show formulas as well

OpenSeas, Inc. is evaluating the purchase of a new cruise ship. The ship will cost $503 million, and will operate for 20 years. OpenSeas expects annual cash flows from operating the ship to be $68.7 million and its cost of capital is 11.4%. a. Prepare an NPV profile of the purchase. b. Identify the IRR on the graph. c. Should Open Seas proceed with the purchase? d. How far off could OpenSeas' cost of capital estimate be before your purchase decision would change? a. Prepare an NPV profile of the purchase. To plot the NPV profile we compute the NPV of the project for various discount rates and plot the curve. The NPV for a discount rate of 2.0% is $ million. (Round to one decimal place.) The NPV for a discount rate of 11.5% is $1 million. (Round to one decimal place.) The NPV for a discount rate of 17.0% is $ million. (Round to one decimal place.) The NPV profile is: NPV Profile of Cruise Ship Investment 1,000+ 9004 NPV ($ millions) 1001 - 3 4 6 10 12 16 18 20 -2001 Discount rate (%) b. Identify the IRR on the graph. The approximate IRR from the graph is %. (Round your answer to one decimal place.) c. Should Open Seas go ahead with the purchase? (Select the best choice below.) O A. No, because at a discount rate of 11.4%, the NPV is negative. OB. Yes, because at a discount rate of 11.4%, the NPV is positive. OC. Yes, because at a discount rate of 11.4%, the NPV is negative. OD. No, because at a discount rate of 11.4%, the NPV is positive. d. How far off could Open Seas' cost of capital estimate be before your purchase decision would change? (Note: Subtract the discount rate from the approximate IRR.) The cost of capital estimate can be off by %. (Round to one decimal place.)