ponderloop.com

IRR and NPV Calculator

One cash flow per line (or separated by commas, spaces or semicolons). The first is time 0, usually negative. Use a dot for decimals and no thousands separators.

NPV 1,307.29, IRR 16.34%

4 cash flows (periods 0 to 3) discounted at 10% a year.

NPV
1,307.29
IRR
16.34%
Profitability index
1.1307
Simple payback
2.41 years
Discounted payback
2.74 years
MIRR
14.6%
Sum of the cash flows
4,000.00
Cash flows
4 (periods 0 to 3)

Each cash flow is divided by (1 + rate)^period, with period 0 undiscounted. IRR is the rate that makes NPV exactly 0, found between −99% and 1,000% per period. An estimate, not financial advice.

The working, period by period

Discount factor = 1 ÷ (1 + rate)^period; present value = cash flow × discount factor. Every row is rounded on its own from the exact value, so a column can differ from its total by a cent.

PeriodCash flowDiscount factorPresent valueCumulative PVCumulative cash
0−10,000.001.000000−10,000.00−10,000.00−10,000.00
13,000.000.9090912,727.27−7,272.73−7,000.00
24,200.000.8264463,471.07−3,801.65−2,800.00
36,800.000.7513155,108.941,307.294,000.00

NPV profile: NPV at other discount rates

Annual discount rateNPVRule: NPV > 0
0%4,000.00Accept: NPV above 0
5%2,540.76Accept: NPV above 0
10%1,307.29Accept: NPV above 0
15%255.61Accept: NPV above 0
20%−648.15Reject: NPV below 0
25%−1,430.40Reject: NPV below 0
30%−2,111.97Reject: NPV below 0