Calculate the Net Present Value using:
Cash Flows you entered
Internal Rate of Return (IRR) of 5%
NPV formula:
PI = | NPV without Initial Investment |
| Initial Investment |
NPV = ΣPV
twhere PV
t is denoted as
where C
t = cash flow at time t
and i is the discount rate
Calculate the discount factor
(1 + i) = (1 + 0.05)
(1 + i) = 1.05
Now calculate each PV
Discount back to time 0
Time | Ct) | (1 + i)t | PVt = Ct/(1 + i)t | 0 | -5,000.00 | 1.00000 | -5,000.00 |
1 | 1,000.00 | 1.05000 | 952.38 |
2 | 2,000.00 | 1.10250 | 1,814.06 |
3 | 3,000.00 | 1.15763 | 2,591.50 |
Determine NPV
NPV = ΣPV
tNPV = -5,000.00 + 952.38 + 1,814.06 + 2,591.50
NPV =
357.94Since NPV is more than 0
We
should pursue the project.