ship to be $$71\mathrm{.}5$ million $($at the end of each year$)$ and its cost is $12\mathrm{.}3\%$

a$.$ Prepare an NPV profile of the purchase using discount rates of $2\mathrm{.}0\%,11\mathrm{.}5\%$ and $17\mathrm{.}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 OpenSeas' 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 $2\mathrm{.}0\%,11\mathrm{.}5\%$ and $17\mathrm{.}0\%.$

The NPV for a discount rates of $2\mathrm{.}0\%$ is $ million. $($Round to two decimal places.$)$