Calcavia

Free calculators & converters

Finance

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.

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.