Payback Period Calculator
Payback tells you how long your money is at risk. Enter the investment and the cash it brings back, the discounted figure is the one to trust.
Last reviewed
Payback period
2.60 periods
3.10 periods discounted at 10%
- Simple payback
- 2.60
- Discounted payback
- 3.10
- NPV
- $1,839
- IRR
- 18.03%
| Period | Flow | Cumulative | Discounted |
|---|---|---|---|
| Now | -$10,000 | -$10,000 | -$10,000 |
| 1 | $3,000 | -$7,000 | -$7,273 |
| 2 | $4,000 | -$3,000 | -$3,967 |
| 3 | $5,000 | $2,000 | -$210 |
| 4 | $3,000 | $5,000 | $1,839 |
Discounting at 10% pushes payback out by 0.50 of a period, because money arriving later is worth less than its face value. The discounted figure is the honest one.
Payback stops counting the moment the money is back. It says nothing about what the project earns afterwards. Here $5,000 beyond the investment. Use it to judge risk, and NPV to judge value.
How long until the money is back
Payback period = the point at which cumulative cash flow turns positive.
Invest $10,000 and receive $3,000, $4,000, $5,000 and $3,000:
| Period | Flow | Cumulative |
|---|---|---|
| Now | −$10,000 | −$10,000 |
| 1 | $3,000 | −$7,000 |
| 2 | $4,000 | −$3,000 |
| 3 | $5,000 | $2,000 |
| 4 | $3,000 | $5,000 |
You are $3,000 short after year 2, and year 3 brings $5,000. So payback falls part-way through year 3:
2 + ($3,000 ÷ $5,000) = 2.60 years
The fraction assumes cash arrives evenly through the period, which is the standard convention and worth knowing if your money all arrives in December.
The discounted version is the honest one
Simple payback treats a dollar in year four as a dollar today. It is not. Discount each flow first and payback takes longer:
| Discount rate | Payback | NPV |
|---|---|---|
| 0% | 2.60 | $5,000.00 |
| 5% | 2.81 | $3,272.56 |
| 10% | 3.10 | $1,838.67 |
| 15% | 3.63 | $636.11 |
| 18.03% | never | −$0.37 |
Look at the last row. At 18.03%, which is this project’s IRR, the discounted cumulative only just fails to reach zero, and NPV is zero.
That is not a coincidence. Discounted payback completes exactly when NPV is positive, and never completes when NPV is negative. The two measures are the same fact seen from different angles: one asks when the cumulative discounted cash crosses zero, the other asks where it ends up.
What payback cannot see
It stops counting the moment the money is back. Everything after that is invisible.
Two projects, identical payback, utterly different:
| Flows | Payback | NPV at 10% | |
|---|---|---|---|
| Stops at year 2 | $5,000, $5,000 | 2.00 | −$1,322.31 |
| Runs to year 5 | $5,000 × 5 | 2.00 | $8,953.93 |
Both pay back in exactly two years. One destroys $1,322 of value and the other creates $8,954. Payback cannot tell them apart, because it has stopped looking.
And it can rank projects backwards:
| Flows | Payback | NPV at 10% | |
|---|---|---|---|
| Fast | $10,000, $500 | 1.00 | −$495.87 |
| Slow | $2,000, $4,000, $6,000, $8,000 | 2.67 | $5,095.96 |
The fast project pays back in a single year and loses money. The slow one takes nearly three and creates over $5,000. Choose on payback and you choose wrong.
So what is it good for?
Risk, not profitability.
Payback answers a question NPV does not: how long is my capital exposed? That matters when:
- The forecast gets unreliable fast. Cash flows five years out may be guesses. A project that pays back in two relies on the part of the forecast you can actually believe.
- The asset may become obsolete. A technology investment with a six-year payback and a four-year useful life is a problem no NPV calculation will flag if the NPV used optimistic years.
- Liquidity is tight. A small business that cannot wait four years for its money back has a real constraint regardless of NPV.
- The political or regulatory environment could change. Long paybacks carry risks that are hard to put in a discount rate.
This is why many firms set a payback cut-off, “nothing over three years”, as a constraint alongside NPV, not as a replacement for it. That is the correct use.
A project can pay back and still lose
Worth stating plainly, because the word “payback” sounds like success.
Returning exactly what you invested is break-even in cash and a loss in real terms, because that money could have earned something elsewhere. Invest $10,000, get $5,000 back in each of two years: payback is exactly 2.00 years, and the NPV at 10% is −$1,322.31.
You got your money back and you are worse off. Payback and profit are different things.
A worked example: solar panels
This is where most people meet payback, and it shows all three effects at once.
A $20,000 system saves $1,800 a year in electricity.
- Flat savings: $20,000 ÷ $1,800 = 11.11 years
- With electricity prices rising 3% a year: the savings grow each year, so payback shortens to 9.73 years
- Discounted at 5%, because the $20,000 could have earned something else: 13.07 years
Three defensible numbers between 9.7 and 13.1 years, from the same system. The assumptions are doing more work than the arithmetic, which is the honest summary of almost every payback calculation.
Note too what payback ignores here. Over a 25-year panel life those escalating savings total about $65,600 against a $20,000 outlay. A 13-year payback sounds slow and the project is still strongly positive. Payback is a measure of patience required, not of value created.
Reading the output
- Simple payback: how long in plain cash.
- Discounted payback: the same, honestly. Always longer, and sometimes “never” when the simple figure exists.
- NPV: what the project is worth, which is what should decide it.
- IRR: the break-even rate, covered on the IRR calculator. Both pages run on the same code, so they always agree about the same set of flows.
Before you rely on the number
- Match the period to your flows. Enter quarterly cash and the answer is in quarters.
- Include every outflow, including mid-project spending. Enter those as negative numbers and the cumulative column handles them.
- A short payback is not a good project, and a long one is not a bad one. It is one dimension of a decision, and on its own the least informative of the three measures on this page.
Frequently asked questions
How do I calculate the payback period?
Add the cash flows until the cumulative total turns positive, then interpolate within that period. Investing $10,000 and receiving $3,000, $4,000 and $5,000 leaves you $3,000 short after two years, and the third year brings $5,000, so payback is 2 + 3,000/5,000 = 2.60 years.
What is discounted payback period?
The same calculation after discounting each cash flow to today’s value. It is always longer, because money arriving later is worth less than its face value. The example above pays back in 2.60 years plain and 3.10 years discounted at 10%.
What is a good payback period?
It depends entirely on the risk and the asset’s life. A machine lasting twenty years can justify a seven-year payback; a technology project that may be obsolete in four cannot. Many firms set a cut-off as a rule, which is a risk policy rather than a measure of profitability.
Why is payback period criticised?
Because it stops counting the moment the money is back. Two projects that both pay back in two years are identical on this measure even if one then stops and the other earns for a decade. It also ignores the time value of money unless you use the discounted version.
Should I use payback or NPV?
Both, for different questions. Payback answers "how long is my money exposed?", a risk question. NPV answers "how much value does this create?", the profitability question. Choose between projects on NPV; use payback as a constraint alongside it.
Can a project pay back and still lose money?
Yes. Returning exactly what you invested is break-even in cash and a loss in real terms, because that money could have earned something elsewhere. A project returning $10,000 on a $10,000 investment over two years pays back in two years and has a negative NPV at any positive discount rate.
Related calculators
- IRR CalculatorIRR is the rate at which a project breaks even.
- Present Value CalculatorMoney later is worth less than money now.
- Future Value CalculatorEnter what you have, what you add, and the return you expect.
- Rental Property CalculatorEnter the price, the rent and the real running costs.
- CAGR CalculatorCAGR is the steady annual rate that would have taken you from one value to another.
Sources
This tool is for information only and is not financial advice. Figures are estimates, confirm anything you act on with your lender or a qualified adviser.