The NPV and IRR calculator evaluates an investment from its cash flows. Paste the flows — the initial outlay as a negative, then each period's return — and get the Net Present Value at your discount rate, the Internal Rate of Return, the Modified IRR, and simple and discounted payback periods, with a chart of NPV across rates. It runs in your browser.
| Measure | Result |
|---|---|
| NPV at 10% | −21.04 |
| IRR | 8.90% |
| MIRR (10% / 12%) | 9.82% |
| Payback | 2.6 periods |
The value today of all future cash flows, discounted at your required rate, minus the investment. Positive NPV means the investment beats that rate.
The discount rate that makes NPV zero — the investment's own effective yearly return.
Excel's NPV() discounts the first value too. Use =NPV(rate, later flows) + first flow to match this calculator.
A modified IRR that assumes profits are reinvested at a realistic rate instead of the IRR itself.
No. It's calculated in your browser.
Cash flows are entered one per period, starting at period 0 (usually the negative initial investment). NPV discounts each flow by (1 + rate)^t and sums them, with period 0 undiscounted. IRR is the discount rate at which NPV equals zero; it's found by bisection, which is slower than Newton's method but always converges once a sign change is bracketed, searching from −99.99% to 1,000%. MIRR assumes negative flows are financed at the discount rate and positive flows are reinvested at a separate reinvestment rate: (future value of inflows ÷ present value of outflows)^(1/n) − 1, which avoids IRR's unrealistic assumption of reinvesting at the IRR itself. Payback is the period at which cumulative cash flow turns positive, interpolated within the period; discounted payback does the same with discounted flows. The NPV profile chart plots NPV for rates from 0% to 40%.