Answer :
Answer:
Without Mitigation:
Net Present Value $14,244,200
IRR 19.92%
With mitigation
Net Present Value: $ -7,071,600
IRR = 15.76%
The project should be started without hte mitigation effort as would decrease the return below the cost of capital of the company.
Explanation:
Present value without mitigation
[tex]C \times \frac{1-(1+r)^{-time} }{rate} = PV\\[/tex]
C 70.00
time 5
rate 0.17
[tex]70 \times \frac{1-(1+0.17)^{-5} }{0.17} = PV\\[/tex]
PV $223.9542
Less
cost $209.71
Net Present Value 14,2442
IRR (using excel)
we input the -209.71 in one cell
then, we enter the 70 millon five times below the cost
and use the IRR formula to get the answer:
0.1992 = 19.92%
With mitigation:
[tex]C \times \frac{1-(1+r)^{-time} }{rate} = PV\\[/tex]
C 75.84
time 5
rate 0.17
[tex]75.84 \times \frac{1-(1+0.17)^{-5} }{0.17} = PV\\[/tex]
PV $242.6384
Less
249.71 cost
Net present value -7,0716
IRR:
A
1 -249.71
2 +75.84
3 +75.84
4 +75.84
5 +75.84
6 +75.84
=IRR(A1:A6)
= 0.1576