Open Seas Inc is evaluating the purchase of a new cruise ship. The ship would cost $501 million, but would operate for 20 years OpenSeas expects annual cash flows from operating the ship to be 569.4 million (at the end of each year) and its cost of capital is 120% a. Prepare an NPV profile of the purchase using discount rates of 2.0%, 115% and 17 0% b. Identify the IRR to the nearest 1%) on a graph c. Is the purchase attractive 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 rate from the actual IRR. Use Excel to compute the actual IRR a. Prepare an NPV profile of the purchase using discount rates of 20%, 11.5% and 17,0% The NPV for a discount rates of 20% is million (Round to the nearest Integer) S SS