Payback Period Calculator
Work out how long an investment takes to recover its cost. Use a steady annual cash flow (with an optional growth rate) or type in a different amount for each year, add a discount rate for the discounted payback period, and see the average return, total return, simple ROI and a full year-by-year breakdown.
Formula
Worked example
A 50,000 machine that returns 12,500 in net cash each year pays back in 50,000 / 12,500 = 4 years. At a 10% discount rate the discounted payback is longer, near 5.4 years, because later cash is worth less today. With irregular flows of 15,000, 18,000, 20,000 the cumulative cash crosses 50,000 partway through year 3.
What the payback period tells you
The payback period is the time it takes for an investment to generate enough cash to recover its initial cost. With a level annual cash flow it is simply the upfront outlay divided by the yearly inflow. When the cash flow varies, the calculator adds up each year in turn and interpolates across the year the running total crosses the investment. Managers use payback as a quick screen for risk: the sooner you get your money back, the less time your capital is tied up and exposed to uncertainty. A project that returns its cost in two years is generally considered safer than one that takes eight, all else being equal.
Fixed versus irregular cash flows
Choose the fixed mode when the investment returns roughly the same amount every year; you can add a growth rate to model a steady ramp-up or decline. Switch to the irregular mode when the cash flow differs year to year, which is common for projects that start slow, peak in the middle, or wind down. In irregular mode you type a separate amount for each year, the first number being year one, and the calculator sums them in order until the cost is recovered. Both modes feed the same year-by-year breakdown, chart and discounted payback.
Simple payback versus discounted payback
The simple payback period treats every dollar as equally valuable no matter when it arrives, which is its biggest weakness. The discounted payback period fixes that by dividing each year's cash flow by (1 + d) to the power of the year number, where d is your discount rate or cost of capital, before adding it to the running total. Because future cash is worth less once discounted, the discounted payback is always longer than the simple one. Set the discount rate above zero to see both figures side by side and the gap the time value of money opens up.
Average return, project life and ROI
Turn on the project-life option to total the cash over the full life of the investment, see the average cash flow per year (often called the average return), read the net profit after the upfront cost, and get a simple return on investment. Payback answers how long until you break even; ROI and the average return answer how much you earn over the whole project. Use them together rather than relying on either alone, since a fast payback says nothing about the profit earned after break-even.
Strengths and limitations
Payback is easy to calculate and easy to explain, which is why it remains popular for first-pass decisions. But even the discounted version ignores every dollar earned after the break-even point, so a highly profitable long-term project can look worse than a mediocre short-term one. For larger decisions, pair payback with net present value and internal rate of return, which value the entire stream of cash flows rather than stopping at break-even. Treat the figures here as a screen, not a final verdict.
How to read a payback period
| Payback period | Interpretation |
|---|---|
| Under 2 years | Fast |
| 2 to 5 years | Moderate |
| Over 5 years | Slow |
Rough guidance, acceptable payback varies by industry and risk appetite.
Frequently asked questions
How do I calculate the payback period?
For a level cash flow, divide the initial investment by the annual cash inflow. A 40,000 investment that returns 10,000 per year pays back in 40,000 / 10,000 = 4 years. When the cash flow varies, add each year's cash to a running total and find the year it first reaches the investment, interpolating across that year for a fractional result.
How do I handle different cash flows each year?
Switch the cash flow type to "different each year" and type the net cash for year 1, year 2, year 3 and so on, separated by commas. The calculator adds them in order and reports the exact year the running total reaches your investment, along with a full breakdown table and a cumulative-cash chart.
What is the discounted payback period?
It is the payback period after each future cash flow is reduced to its present value using a discount rate. Because money received later is worth less today, the discounted payback is always longer than the simple payback. Enter a discount rate above zero, often your cost of capital or required return, to see it.
What is a good payback period?
It depends on the industry and how much risk you can tolerate, but shorter is generally better. Many businesses look for paybacks under three to five years; capital-intensive projects may accept longer ones. Compare the result against your own hurdle and against alternative uses of the same capital.
Does payback period account for the time value of money?
The simple payback period does not, it treats all future cash as equally valuable. The discounted payback period does, because it discounts each year's cash before adding it up. For a fuller picture, also look at net present value and internal rate of return, which value the whole life of the project.