27-7 (similar to) Question Help O OpenSeas, Inc. is evaluating the purchase of a new cruise ship. The ship would cost $500 million, but would operate for 20 years. Open Seas expects annual cash fows from operating the ship to be 5688 milion (at the end of each year, and its cost of capitalis 11.8% a. Prepare an NPV profile of the purchase using discount rates of 20% 11.5% and 17.0% b. Identity the IRR to the nearest 1%) on a graph. c. Is the purchase wractive based on these estimates? d. How far off could Open Seas? cost of capital be to the nearest 1%) before your purchase decision would change? Note: Subtract the discount from the IRR Use Excel to compute the actual IRR a. Prepare an NPV profle of the purchase using discount rates of 2.0%, 11.5% and 17.9%. The NPV for a discount rates of 2.0% is $milon (Round to the nearest integer) Enter your wwwer in the answer box and then click Check Awet CA 5 ports ring