NPV & IRR Calculator
Is an investment worth it? Enter the upfront cost and yearly cash flows to get the Net Present Value (NPV), Internal Rate of Return (IRR), MIRR, profitability index and payback period
What you pay at the start, as a positive number
The return you could get elsewhere, or your cost of borrowing
Optional; blank = same as the discount rate
Cash flows
Money you get back (+) or pay in (−) at the end of each year. Empty years in between count as 0.
NPV (Net Present Value)
IRR (Internal Rate of Return)
MIRR (Modified IRR)
Profitability index
Value of what you get back ÷ investment; above 1 = worth it
Payback period
When the cash flows have repaid the investment
Discounted payback
Same, using the discounted (today's value) amounts
NPV at different discount rates
The higher the rate you could earn elsewhere, the less the investment is worth today. Where the line crosses zero is the IRR.
Year by year
| Year | Cash flow | Today's value | Running total (today's value) |
|---|
What NPV and IRR tell you
Money you get in five years is worth less than the same money today, because today's money could earn a return in the meantime. These measures convert each year's cash flow to today's value and compare it with what you invest:
- NPV (Net Present Value): today's value of all future cash flows minus the investment. Positive means the investment earns more than the discount rate.
- IRR (Internal Rate of Return): the yearly return the investment works out to; it is the discount rate at which NPV is exactly zero.
- MIRR (Modified Internal Rate of Return): like IRR, but assumes the cash you get back is reinvested at a rate you choose instead of at the IRR itself, which often gives a more realistic figure.
- Profitability index: today's value of the cash flows divided by the investment; useful for comparing projects of different sizes.
- Payback period: how long until the investment is earned back. The discounted version uses today's values, so it is always longer.
Cash flows are assumed to arrive at the end of each year. The discount rate is usually the return you could get on an alternative with similar risk, or what the money costs you to borrow.