NPV & IRR Calculator
Calculate Net Present Value (NPV) and Internal Rate of Return (IRR) for any investment. Enter up to 20 years of cash flows, discount rate, and initial investment to evaluate profitability, payback period, and profitability index.
Annual Cash Flows
5/20 years| Year | Cash Flow ($) | Present Value | |
|---|---|---|---|
| 0 | −$100,000(initial) | −$100,000 | |
| 1 | $ | $22,727.27 | |
| 2 | $ | $24,793.39 | |
| 3 | $ | $26,296.02 | |
| 4 | $ | $27,320.54 | |
| 5 | $ | $27,941.46 |
Investment Creates Value
NPV of $29.08K means this investment returns more than your 10% hurdle rate. IRR of 19.71% is above your 10% required return.
Net Present Value
$29.08K
Positive — accept
IRR
19.71%
Above 10% hurdle
MIRR
15.76%
Modified IRR
Profitability Index
1.291
PI ≥ 1.0 — accept
Payback Analysis
Cash Flow Summary
NPV Sensitivity to Discount Rate
| 5% | 7% | 10% | 12% | 15% | 20% |
|---|---|---|---|---|---|
| $49.42K | $40.74K | $29.08K | $22.10K | $12.68K | -$704.09 |
Highlighted column = your current discount rate. Positive NPV = green, negative = red.
Decision Rules
NPV Rule
Accept — NPV ≥ 0
IRR Rule
Accept — 19.71% ≥ 10%
PI Rule
Accept — PI = 1.291
Bookmark this calculator
Save it for one-tap access or share it with someone who needs it.
Rate this calculator