In: Finance
You own a coal mining company and are considering opening a new mine. The mine itself will cost $ 118.1 million to open. If this money is spent immediately, the mine will generate $ 21.3 million for the next 10 years. After that, the coal will run out and the site must be cleaned and maintained at environmental standards. The cleaning and maintenance are expected to cost $ 1.7 million per year in perpetuity. What does the IRR rule say about whether you should accept this opportunity? If the cost of capital is 8.3 %, what does the NPV rule say?
First of all we shall calculate the IRR of the project by using the below formula:
Lower Rate + [ Lower Rate NPV / ( Lower Rate NPV - Higher Rate NPV ) ] x ( Higher Rate - Lower Rate )
Now lets calculate the projects NPV at a rate of say 10%
= ( $ 118.1 million) + $ 21.3 million / 1.101 + $ 21.3 million / 1.102 + $ 21.3 million / 1.103 + $ 21.3 million / 1.104 + $ 21.3 million / 1.105 + $ 21.3 million / 1.106 + $ 21.3 million / 1.107 + $ 21.3 million / 1.108 + $ 21.3 million / 1.109 + $ 21.3 million / 1.1010 - 1 / 1.1010 ( $ 1.7 million / 0.10 )
= $ 6.23 Million Approximately
Now lets calculate the projects NPV at a rate of say 11.5%
= ( $ 118.1 million) + $ 21.3 million / 1.1151 + $ 21.3 million / 1.1152 + $ 21.3 million / 1.1153 + $ 21.3 million / 1.1154 + $ 21.3 million / 1.1155 + $ 21.3 million / 1.1156 + $ 21.3 million / 1.1157 + $ 21.3 million / 1.1158 + $ 21.3 million / 1.1159 + $ 21.3 million / 1.11510 - 1 / 1.11510 ( $ 1.7 million / 0.115 )
= $ - 0.22 Million Approximately
Since IRR is the rate at which the projects NPV is zero, hence the IRR must be in between these two rates.
Now feeding these values in the above mentioned formula we shall get IRR as below:
10% + [ $ 6.23 million / ( $ 6.23 million - ( $ 0.22 million ) ] x ( 11.5 - 10 )
= 11.45% Approximately
Since IRR is greater than the cost of capital hence the project should be accepted.
NPV computation at cost of capital of 8.3%
= ( $ 118.1 million) + $ 21.3 million / 1.0831 + $ 21.3 million / 1.0832 + $ 21.3 million / 1.0833 + $ 21.3 million / 1.0834 + $ 21.3 million / 1.0835 + $ 21.3 million / 1.0836 + $ 21.3 million / 1.0837 + $ 21.3 million / 1.0838 + $ 21.3 million / 1.0839 + $ 21.3 million / 1.08310 - 1 / 1.08310 ( $ 1.7 million / 0.083 )
= $ 13.68 million Approximately
Since the NPV of the project is positive, hence the project should be accepted
Feel free to ask in case of any query relating to this question