Calcority
Guide

Payback period calculator

Formula reviewed by Tahir Asif, CMA

A project that costs $500,000 and returns $145,000 a year recovers its cost in 3.45 years on a simple basis, and 4.78 years once each future dollar is discounted at 12.4%. A different $300,000 project that returns $310,000 in its first year, then loses $5,000 a year for three more years, pays back in under twelve months and never pays back at all on a discounted basis: its NPV is −$33,937. The fast one looks better on payback and is the worse investment.

The calculator finds both simple and discounted payback from any cash flow schedule, and shows NPV, IRR and the profitability index from the same numbers, so a fast payback never stands alone as the whole story.

NPV, IRR, payback and profitability index calculatorLive

The project

Cash flow each year after that

A negative number is another outflow, such as a cost to decommission the project.

The starting values are an illustration. Only years with a nonzero cash flow count toward payback and the profile below.

Simple payback

3.45 years

Discounted payback

4.78 years

NPV at 12.4%

$17,554

IRR

13.82%

All the numbers together

Present value of the cash coming in, years 1 to 5

$517,554

Less the outlay

−$500,000

Net present value at 12.4%

$17,554

Internal rate of return

13.82%

Modified internal rate of return

12.79%

Simple payback

3.45 years

Discounted payback

4.78 years

Profitability index

1.035

NPV at other discount rates

-10%-5%0%5%10%12.4%15%20%25%30%40%50%75%100%
$505,588$347,831$225,000$127,774$49,664$17,554−$13,938−$66,361−$110,054−$146,842−$204,901−$248,189−$318,446−$359,531

Where this row crosses from negative to positive is the IRR. If it crosses more than once, IRR is ambiguous.

IRR is solved numerically and assumes cash flows are reinvested at the IRR itself, which can be unrealistic when IRR is very high; MIRR uses the reinvestment and finance rates you set instead. Payback ignores everything after the payback point. Profitability index divides the present value of future cash flows by the outlay. Not investment advice.

Free download · .xlsx · no signup

A capital budgeting workbook: one project's NPV, IRR, MIRR, simple and discounted payback and profitability index, with a cumulative-cash-flow helper table you can trace by eye, an NPV profile, a two-project ranking-conflict sheet, and a profitability-index ranking of several projects under a budget. Every formula is editable, and the starting values are illustrations.

Download the workbook

Who reaches for this

A small business buying equipment

Wants to know how many months or years before the purchase pays for itself.

A finance manager screening several capital requests

Wants a quick liquidity filter before running a full NPV analysis.

An investor comparing two deals with different cash flow timing

Wants to see whether a fast payback is hiding a weak return.

A student working through a capital budgeting problem set

Wants both the simple and discounted method worked through with real numbers.

A lender or landlord assessing a tenant's buildout investment

Wants a sense of how quickly the improvement recovers its cost.

Section 01

How this payback period calculator works

Payback period
The year cumulative cash flow turns positive, interpolated within that year
Discounted payback does the same after discounting each year's cash flow at the project's discount rate first.

You enter the initial outlay and up to ten years of cash flow after it, plus a discount rate. The calculator adds each year's cash flow to a running total, starting from the negative outlay, and finds the point where that total crosses from negative to positive. It reports the year and a fraction of the year, then repeats the exercise on discounted cash flows for the discounted payback period. NPV, IRR and the profitability index come from the same numbers.

Payback is a screen, and the other numbers are the fuller picture. The IRR calculator covers the internal rate of return and the multiple-IRR problem, and the profitability index calculator covers ranking projects under a budget. Both use this same engine.

Section 02

Simple vs. discounted payback

Simple payback treats every dollar the same regardless of when it arrives. A $500,000 outlay recovering $145,000 a year crosses zero partway through year four: after three years, $435,000 has come back, $65,000 short of $500,000, and the fourth year's $145,000 supplies that in 65,000 ÷ 145,000 = 0.45 of the year. Simple payback is 3.45 years.

Year
Cash flow
Cumulative
0
−$500,000
−$500,000
1
$145,000
−$355,000
2
$145,000
−$210,000
3
$145,000
−$65,000
4
$145,000
$80,000
5
$145,000
$225,000

Discounted payback repeats the exercise after discounting each year's cash flow at the project's discount rate, 12.4% here. Year one's $145,000 is worth $129,003 today, year two's is worth $114,772, and so on: each later year contributes less to recovering the outlay than its face value suggests. The running total does not turn positive until partway through year five, giving a discounted payback of 4.78 years, 1.33 years longer than the simple figure.

Discounted payback is always at or later than simple payback for a project with a positive discount rate, because discounting can only shrink future cash flows, never grow them. The gap between the two grows with the discount rate: at a 6% rate the same project's discounted payback is 3.98 years, and at a 20% rate it never pays back within the five years shown, even though its simple payback is unchanged at 3.45.

Section 03

Uneven cash flows

Real projects rarely produce the same cash flow every year. A ramp-up period, a maintenance year, or a large final-year salvage value all break a simple outlay-divided-by-annual-cash-flow shortcut, which assumes equal payments. The running-total method used here does not have that limitation: it adds up whatever each year's actual cash flow is, in order, and finds where the total crosses zero.

A project that earns little in its first year and much more later pays back later than a naive average would suggest, and a project front-loaded with strong early cash flows pays back sooner. Enter the actual year-by-year numbers rather than an average, since payback is sensitive to timing in exactly the way an average discards.

Reading the running total by eye

Payback problems are easy to check by hand, which is part of why the metric has stuck around. Keep a running balance: start at the negative outlay, and add each year's cash flow to it. The year the balance turns positive is the year payback happens, and the fraction of that year is however much of that year's cash flow was still needed at the start of it, divided by the whole year's cash flow.

For a project with irregular cash flows, for example a slow first year, a strong middle stretch, and a smaller final year, work through the balance one year at a time rather than guessing where it lands. It is one of the few capital budgeting numbers a person can compute on paper in a couple of minutes, which is also why it remains popular for a first read of a proposal before it goes to someone who will run the full analysis.

Section 04

The fast-payback trap

A short payback period looks safe, and it can hide a bad investment if the cash flows after the payback point turn negative or simply stop. Two $300,000 projects make the point.

Project D (fast)
Project E (slower)
Cash flow, year 1
$310,000
$90,000
Cash flow, years 2 to 4 (D) / 2 to 5 (E)
−$5,000 each
$90,000 each
Simple payback
0.97 years
3.33 years
NPV at 12%
−$33,937
$24,430
Profitability index
0.887
1.081

Project D returns almost its whole cost in the first year, a payback of under twelve months, and then loses money for three more years: a maintenance obligation, a warranty cost, or a contract that turns unprofitable, for example. Its NPV is negative, and it never pays back at all on a discounted basis, since the small losses after year one are themselves discounted and never offset by anything positive again. Project E takes over three years to pay back and goes on to add real value, with an NPV of $24,430 and a profitability index above 1.

A payback screen alone would favor Project D. It is the clearest argument for using payback as a first filter and not a final verdict: it says nothing about what happens after the cutoff, and what happens after the cutoff is exactly where Project D goes wrong.

Section 05

When a project never pays back

Payback can be undefined in two ways. On a simple basis, if cumulative cash flow never turns positive within the years you consider, the project has not recovered its cost in that window. A $200,000 outlay earning $20,000 a year has recovered only $100,000 after five years, so simple payback is undefined within a five-year view, and the calculator reports it as never paying back rather than guessing at a longer horizon you have not entered.

Discounted payback fails more easily than simple payback, because discounting shrinks every later cash flow. The rate-sensitivity table below shows the same project's discounted payback lengthening as the rate rises, and eventually failing to resolve within the period shown even while simple payback stays fixed.

Discount rate
Simple payback
Discounted payback
0%
3.45 years
3.45 years
6%
3.45 years
3.98 years
12.4%
3.45 years
4.78 years
20%
3.45 years
never, within 5 years

A project reported as never paying back is not automatically a bad one. It may simply run longer than the years you entered, or its early cash flows may be thin relative to a high discount rate that reflects real risk. Either way, it is a signal to look at NPV directly rather than to conclude the project has no value.

Section 06

Payback cutoffs, treated carefully

Many companies set a maximum acceptable payback period and reject anything longer, regardless of NPV. Guides sometimes cite two to three years for smaller equipment purchases and longer periods for larger infrastructure, and I could not trace a specific figure to a primary source. Cutoffs vary by industry, by how fast technology in the field changes, and by how much capital the company has to tie up.

A strict cutoff has a real cost: it rejects long-payback projects that may have excellent NPV, and it can systematically favor short, low-value projects over longer, high-value ones, the same pattern the fast-payback trap illustrates. Some companies soften this by using payback only to flag projects for closer review, or by using discounted payback with a cutoff set closer to the length of time the company's forecasts are actually reliable for.

Payback in loan and lease decisions

Payback is not only a corporate capital budgeting tool. A homeowner comparing solar panels, a landlord weighing a renovation, or a small business owner pricing new equipment against a loan all ask a version of the same question: how many years of savings or extra income does it take to recover what was spent. In these settings the calculation is identical, the outlay is the cost after any rebates or financing, and the cash flow is the savings or the extra income each year.

When the purchase is financed rather than paid in cash, run the payback on the cash actually out of pocket: the down payment plus the loan payments, against the savings or income, rather than on the full price. A loan can make a purchase look faster to pay back on a cash basis even though the total cost, including interest, is higher, which is its own trade-off worth looking at separately with a proper loan comparison.

Section 07

What payback is actually good for

Despite its limitations, payback measures something real: how much of the future you are betting on. A project with a one-year payback depends on one year of forecasts holding up. A project with a seven-year payback depends on seven, and markets, technology, competitors and regulations can all change a great deal in seven years.

Liquidity

A shorter payback returns cash sooner, which matters when capital is limited or expensive to raise again.

Forecast risk

Fewer years of assumed cash flow means fewer chances for the forecast to be wrong.

Simplicity

Payback is easy to explain to people who are not finance specialists, and easy to sanity-check by eye.

A quick first filter

Before running a full NPV and IRR analysis on every proposal, payback can rule out the clearly impractical ones.

None of these make payback a substitute for NPV. They explain why it survives as a complementary tool: a fast payback is a genuine point in a project's favor, worth weighing alongside NPV and IRR, not a reason to skip them.

A useful discipline is to write the payback figure down next to the outlay and the NPV every time, rather than quoting payback on its own. A three-line summary, outlay, payback, NPV, takes no longer to produce and prevents the fast-payback trap from slipping past a reviewer who only glances at one number.

Payback and inflation

Simple payback compares raw dollars from different years as if they were interchangeable, and inflation is one more reason they are not. A dollar of cash flow in year five will not buy as much as a dollar today, even setting aside the time value of money that discounting addresses. If cash flow forecasts are in nominal terms, meaning they already include expected price increases, a nominal discount rate for the discounted payback calculation keeps the two consistent. If the forecasts are in real, inflation-adjusted terms, use a real discount rate instead. Mixing the two, a real forecast discounted at a nominal rate, understates the true payback and overstates the project's apparent speed.

Section 08

Payback vs. break-even

The two terms get used loosely and mean different things. Payback period is about one investment: how long until its own cash flows return its own cost. Operating break-even is about a whole business or a product line for a period, usually a month or a year: the sales volume or revenue at which revenue equals costs, so profit is zero.

A retailer might ask when a new store's buildout cost pays back, which is payback period, and separately ask how many units a month the store must sell to cover its rent and staff, which is break-even. The break-even calculator on this site covers the second question. If a search result or a spreadsheet template calls something a break-even period, check which of the two it actually means before comparing numbers.

Comparing two projects on payback alone

Payback also invites a size mistake similar to the one IRR makes. A $50,000 project that pays back in one year and a $2,000,000 project that pays back in three years cannot be judged on payback alone, since the small project ties up far less capital for its one year than the large one does across its three. A payback period is a length of time, not a rate, so it says nothing about how much money is actually at risk during that time or how much value the project creates once it has paid back.

A useful habit is to pair the payback figure with the size of the outlay whenever you compare projects: "$50,000 back in one year" and "$2,000,000 back in three years" are both fast in their own terms, and deciding between them needs NPV, IRR, or the profitability index, exactly the numbers a payback-only comparison leaves out.

Section 09

NPV, IRR and profitability index, briefly

Payback answers one question, and these three answer others from the same cash flow schedule.

Net present value

The dollar value the project adds at a chosen discount rate, $17,554 in the main example. It accounts for every year, not just the years up to payback. Covered on the IRR calculator.

Internal rate of return

The annualized return the cash flows imply, 13.82% here. It can be unreliable when the cash flow changes sign more than once. Covered in depth on the IRR calculator.

Profitability index

Present value of future cash flows per dollar invested, 1.035 here. Useful for ranking projects when a budget cannot fund every positive-NPV one. Covered on the profitability index calculator.

A sensible order for a quick screen: check payback for a sense of how exposed the capital is, check NPV and IRR against the company's cost of capital for the accept-or-reject decision, and reach for profitability index only when a budget forces a choice among several positive-NPV projects.

Section 10

Common mistakes

Most payback errors come from treating it as more than the liquidity screen it is, or from skipping the discounting step when it matters.

Using payback as the final decision

It ignores everything after the payback point. Check NPV before rejecting a longer-payback project.

Confusing payback with NPV or IRR

A fast payback and a good return are different things, as the trap example shows.

Using the equal-payment shortcut on uneven cash flows

Outlay ÷ annual cash flow only works when the cash flow is the same every year.

Skipping discounted payback when the discount rate is high

At a high enough rate, a project that pays back on a simple basis may not on a discounted one.

Applying a borrowed cutoff

A two- or three-year rule from another company or industry may not fit your own capital constraints or risk.

Confusing payback period with break-even

One is about a single investment, the other about a whole business for a period.

Ignoring cash flows that go negative later

A maintenance cost, warranty claim or closing cost after payback can turn a fast-looking project into a loss.

Reporting payback without NPV or IRR

A number of years with no value or rate attached tells only part of the story.

Section 11

What this calculator can't tell you

It computes payback, NPV, IRR and the profitability index from the cash flows and discount rate you enter, and does not check whether those cash flow forecasts are realistic. It looks only within the years you enter, up to ten, so a project that pays back in year eleven or later will read as never paying back unless you extend the schedule.

It treats each year's cash flow as certain and arriving on schedule, and does not model risk, taxes, inflation, or financing structure. The fast-payback trap and never-pays-back examples are illustrations built to show the mechanics, not forecasts of any real project.

This is a planning aid, not investment advice.

Section 12

Sources

Simple and discounted payback period, and the running cumulative-cash-flow method for uneven cash flows, are standard topics in corporate finance and capital budgeting texts, as are their limitations relative to NPV and IRR. Surveys of corporate finance practice have long found payback period among the most widely used capital budgeting tools alongside NPV and IRR, despite its acknowledged shortcomings, and is why this page treats it as a legitimate, useful first screen rather than something to be dismissed outright. The examples were computed with the same engine as the IRR calculator, and the workbook reproduces them: cumulative cash flow crosses zero at 3.45 years on a simple basis and 4.78 years on a discounted basis for the main example, and Project D's discounted cumulative cash flow never crosses zero.

Section 13

Frequently asked questions

Payback period is how long it takes a project's cash flows to return its initial cost. A project costing $500,000 and returning $145,000 a year recovers that cost partway through year four, at 3.45 years. It answers a narrow, practical question: how long is the money tied up before the project has paid for itself, ignoring anything it earns after that point.

Payback period is the year cumulative cash flow turns from negative to positive, interpolated within that year for a fractional answer. For even annual cash flows, it simplifies to outlay ÷ annual cash flow. For uneven cash flows, add each year's cash flow to a running total starting from the negative outlay, and find where the total crosses zero: year of crossing minus one, plus the fraction of that year's cash flow needed to reach zero.

Simple payback adds up raw cash flows. Discounted payback discounts each year's cash flow at the project's discount rate before adding it up, so it accounts for the time value of money. A project with a $500,000 outlay and $145,000 a year has a simple payback of 3.45 years and, at a 12.4% discount rate, a discounted payback of 4.78 years, over a year longer, because each future dollar counts for less than a dollar today.

The same running-total method works regardless of whether the cash flows are equal each year. Add each year's actual cash flow to the cumulative total, starting from the negative outlay, and find the year the total crosses zero. A project with a slow first year and a strong second year pays back later than the simple average would suggest, and the running-total method captures that automatically, where a shortcut formula built for equal payments would not.

The right cutoff turns on the kind of investment and how much uncertainty surrounds the cash flows further out. Guides sometimes cite two to three years as a common cutoff for equipment and smaller projects, and longer for infrastructure, though I could not trace that range to a primary source. A shorter payback is generally safer, since fewer years of forecast have to hold up, but a strict cutoff can reject good long-term projects in favor of mediocre short-term ones.

Because payback ignores value created after the cutoff, and a project with a longer payback can still be worth far more. A $300,000 project returning $310,000 in year one and then losing $5,000 a year for three years has a 0.97-year payback but an NPV of −$33,937: it looks fast and is a poor investment. A second $300,000 project returning $90,000 a year for five years pays back more slowly, in 3.33 years, but has an NPV of $24,430 and a profitability index above 1. Payback alone would favor the wrong one.

Yes, on either basis. If cumulative cash flow never turns positive within the years you enter, simple payback is undefined, meaning the project never recovers its cost in the period considered. Discounted payback fails more easily: a project that pays back on an undiscounted basis in 3.45 years can fail to pay back at all on a discounted basis if the discount rate is high enough, since discounting shrinks every later cash flow.

They are related but not identical, and the terms get used loosely. Payback period is when a specific investment's cash flows recover its cost, measured in cash. Operating break-even is the sales volume or revenue at which a business's revenue equals its costs for a period, usually a month or a year, and it is a separate calculation covered on this site's break-even calculators. If you are asking when a business as a whole stops losing money, that is break-even; if you are asking when a specific project or purchase pays for itself, that is payback.

Simple payback does not: a dollar in year one and a dollar in year five count the same. Discounted payback does, by discounting each year's cash flow first. Neither accounts for cash flows after the payback point, which is the bigger limitation of both versions. For a measure that captures the time value of money and the whole cash flow stream, use net present value.

As a first screen, not a final answer. Many companies use payback to rule out projects that tie up capital for too long or depend on too many years of forecast, then evaluate the survivors on NPV and IRR, which account for the whole cash flow stream and its timing. A project can pass a payback screen and still have a poor NPV, or fail a strict payback cutoff while having an excellent NPV, which is why payback works best as a quick filter alongside the other measures, not instead of them.

Because it is easy to explain, easy to compute, and it captures something NPV and IRR do not directly show: how exposed the capital is to being wrong about the distant future. A project with a one-year payback depends on one year of forecasts holding up. A project with a seven-year payback depends on seven, and markets, technology, competitors and regulations can all change a great deal in seven years.

Build a running total: put each year's cash flow in one column and a cumulative sum in the next, starting from the negative outlay. Find the last row where the cumulative total is negative, and the first where it turns positive. Payback = (that row's year number) + (the negative cumulative amount at the end of the prior year) ÷ (that year's cash flow). The workbook on this page builds exactly this, for both simple and discounted payback.

See the full return a project implies with the IRR calculator, or rank several projects under a budget with the profitability index calculator.

Glossary:Payback Period,Discounted Payback Period,NPV,IRR

Related calculators