Initial investment = New Mining Equipment + Installation cost =
1,200,000 + 200,000 = 1,400,000
Cash Flows = 365,000
number of Periods = 5
Rate = 12%
NPV of Investment = -initial Investment + PV of all cash flows
using annuity formula = -1,400,000 +
365,000*(1-(1+12%)-5)/12% = -1,400,000 + 1,315,743.31 =
-84256.89
IRR using excel formula
A | B | C | D | E | F | |
1 | -1400000 | 365000 | 365000 | 365000 | 365000 | 365000 |
IRR | 9.54% | Using excel formula=IRR(A1:F1) |
b. No the project should not be overtaken as NPV is
negative and IRR is less than cost of capital.
c. Environmental impacts should be calculated and shown as costs in
each years or at the end of the project cleaning cost or one time
environmental damage cleanup cost is added or calculation.
Please Discuss in case of Doubt
Best of Luck. God Bless
Please Rate Well
Get Answers For Free
Most questions answered within 1 hours.