Question: Please show the correct Excel Formula and whether or not to build the strip mine The Ulmer Uranium Company is deciding whether or not it

Please show the correct Excel Formula and whether or not to build the strip mine

The Ulmer Uranium Company is deciding whether or not it should open a strip mine, the net cost of which is $5 million. Net cash inflows are expected to be $30 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. What is the projects Modified IRR given the discount rate below? Should Ulmer open the strip mine?
CF0 ($5,000,000)
CF1 $30,000,000
CF2 ($25,000,000)
Discount Rate 7.00%
Use the scratchpad to show your work in Excel.
Type your numercial answer into the yellow cell below.
Answers should be to two decimal places, e.g. 1.23% or $123.45.
Modified IRR 9.37%
Build the Strip Mine? (Y or N) Y

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!