VanillaPM
Sign in Get started free Dashboard
Free calculator

NPV, IRR and payback calculator

A free project selection calculator — enter the initial investment, a discount rate and the cost and benefit for each period to get NPV, IRR, payback period, benefit-cost ratio and ROI, with the cash flows worked through.

#CostBenefit
NPV
IRR
Paybackperiods
BCRPV(benefits) ÷ PV(costs)
PeriodNetCumulativeDiscounted
0
NPV = −initial + Σ net ÷ (1 + r)t
ROI = (benefits − total cost) ÷ total cost
Download as Excel (.xlsx) The spreadsheet has live formulas: change the yellow cells and it recalculates.

What each number tells you

  • NPV (net present value): today's value of all the future net cash flows, minus the initial investment, at your discount rate. Above zero, the project creates value at that rate. It's the decision metric.
  • IRR (internal rate of return): the discount rate at which NPV would be exactly zero. Compare it with your hurdle rate: above it, the project clears the bar.
  • Payback period: how many periods until the cumulative net cash flow turns positive. Shorter is safer, but it ignores everything after payback and the time value of money.
  • BCR (benefit-cost ratio): present value of benefits ÷ present value of costs. Above 1 pays back.
  • ROI: total benefit minus total cost, over total cost. Simple, but not discounted.

How to use it

Enter the initial investment (period 0), the organisation's discount (hurdle) rate, then the cost and benefit for each period. The table shows the net, cumulative and discounted cash flow per period, so you can see where payback falls.

On a real project

The business case for the Coral Ridge sample clears its 12% hurdle with an IRR of about 18%. The value-based delivery lesson shows how those numbers are revisited during the project, not only at the start.

See it used on a real project: Pr3 · Help ensure value-based delivery