The Ulmer Uranium Company is deciding whether or not to open a strip mine whose net cost is $4.4 million. Net cash inflows are expected to be $27.7 million, all coming at the end of Year 1. The land must be returned to its natural state at a cost of $25 million, payable at the end of Year 2.

1. Select the correct graph for the project's NPV profile.

2. What is the project's MIRR at r = 6%? Do not round intermediate calculations. Round your answer to two decimal places.

%

3. What is the project's MIRR at r = 11%? Do not round intermediate calculations. Round your answer to two decimal places.

%

4. Calculate the two projects' NPVs. Do not round intermediate calculations. Round your answers to the nearest dollar. Use a minus sign to enter negative values, if any.

NPV at r = 6%: $

NPV at r = 11%: $

PLEASE SHOW WORK IN EXCEL WITH FORMULAS IF POSSIBLE

A B C D