Payback Period Calculator

Investing and getting back a year for years pays back in 4.0 years, or 4.6 years counting a discount rate. Its NPV is $2,730.27 and its IRR is 12.01% a year.

Work backward

Find the that makes the NPV : ...

Start over
Year by year

Free calculator by ROI.fyi

How long until you get your money back?

The payback period is how long an investment takes to earn back what it cost. It is the simplest test of risk: the sooner your money comes back, the less can go wrong while you wait. Our example spends $20,000 and gets $6,000 back a year for 5 years. It pays back in 3.3 years, since $20,000 / $6,000 = 3.33.

The simple payback treats a dollar in year 3 as worth the same as a dollar today. The discounted payback doesn't. It shrinks each year's cash by a discount rate, your required return, before adding it up. At 8%, the example pays back in 4.0 years instead of 3.3. If the discounted payback is longer than the life of the investment, it never truly earns back its cost at that rate.

Choose Different each year to enter uneven cash, separated by commas. Timing makes a big difference. $20,000 that returns $2,000, $4,000, $6,000, $8,000 and $10,000 pays back in 4 years. The same total in reverse order pays back in 2.3 years and has an NPV of $5,182 at 8%, against $2,730 for the slow start. Open More options to see the NPV and IRR as well.

Use payback to screen equipment, energy upgrades, marketing and other business spending, or to compare two ways to fix the same problem. Pair it with NPV or IRR before you commit, because payback ignores everything after the money comes back. A project that pays back in 2 years and then stops can be worth less than one that pays back in 4 and keeps earning for 20.

The payback formula

\text{Payback} = \text{Years before full recovery} + \frac{\text{Cost not yet recovered}}{\text{Cash in the next year}}

With equal yearly cash, that is simply cost / yearly cash. The calculator assumes cash arrives evenly through each year when it works out the fraction.

Frequently Asked Questions

How do you calculate the payback period?

With equal yearly cash, divide the cost by the yearly cash: $20,000 / $6,000 = 3.33 years. With uneven cash, add up each year's cash until the running total reaches the cost, then add the fraction of the next year needed. In the uneven example, $2,000 + $4,000 + $6,000 + $8,000 = $20,000, so payback is exactly 4 years.

What is the discounted payback period?

It is the payback period after shrinking each future cash flow to today's value at your discount rate. At 8%, $6,000 in year 1 is worth $5,556 today and $6,000 in year 3 is worth $4,763. Because each payment counts for less, the discounted payback is always longer than the simple one: 4.0 years instead of 3.3 in our example.

What is a good payback period?

It depends on the investment's life and your risk. Many small businesses want equipment and marketing to pay back within 1 to 3 years. Energy upgrades like solar often take 6 to 10 years but keep paying for 25. A good rule of thumb: the payback should be well under half the useful life of what you're buying.

How do I calculate payback period in Excel?

List the cost as a negative number in B1 and each year's cash in B2 onward. In C1, enter =B1, and in C2, enter =C1+B2, then fill down for a running total. Payback falls in the first year the running total turns positive: the year before, plus the shortfall divided by that year's cash.

What are the limits of the payback period?

It ignores everything after payback, so it can't tell a project that stops earning from one that runs for decades. The simple version ignores the time value of money. It also has no single cutoff that is right for every investment. Use it to screen and compare risk, then decide with NPV or IRR.

What is the difference between payback period and ROI?

Payback is a length of time. ROI is a percentage gain. A $20,000 project that returns $30,000 over 5 years has a 50% ROI and a 3.3-year payback. Two projects can share the same ROI and have very different paybacks, depending on whether the money comes back early or late.

What is the difference between payback period and break-even?

Payback measures how long it takes to earn back an investment. Break-even usually means how many units you must sell, or how much revenue you need, to cover your costs in a period. Our break-even calculator answers that question for a product or business.

Can the payback period be longer than the life of the investment?

Yes, and then the investment never earns back its cost. If the cash stops before the running total reaches the cost, the calculator says it never pays back. With discounting, this happens more often, because later payments count for less.

Does payback period account for risk?

Indirectly. A shorter payback means less time for things to go wrong, which is why lenders and cautious owners like it. It doesn't measure how likely the cash is to arrive. Run a cautious case with lower yearly cash to see how much the payback stretches.

How do I use payback period for a business decision?

Set a maximum payback you're comfortable with, such as 3 years, and screen out anything longer. Among what's left, compare NPV or IRR to choose. For a project with costs and gains by month, the business ROI calculator shows the payback month, ROI and yearly return together.

More return and interest calculators

Measure a return

Turn a result into a yearly rate: CAGR, a run of yearly returns, deposits along the way or uneven cash flows.

Plan a project

What future money is worth today, when a project pays back and how much you need to sell to break even.

Grow savings

What a balance becomes with compounding, an APY, monthly deposits and inflation.

Rates & APR

Simple interest, the rate between two amounts, or what a loan really costs with its fees.