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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
