Corporate Finance & Valuation Capital Budgeting & Project Appraisal Payback period (undiscounted capital recovery)

Payback Period Calculator

The payback period is how long an investment takes to repay its own cost out of the cash it generates. Enter the outlay and the cash flow for each period, and this calculator accumulates the flows, finds the period in which the cumulative total first reaches the outlay, and interpolates inside that period so you get a precise answer rather than a whole number of years. You also get the full cumulative cash flow table, the cash the project keeps delivering after it has paid for itself, and a comparison against whatever cutoff your capital committee applies.

Calculator

This calculator runs in your browser. Enable JavaScript for live results — the inputs, formula and worked example below remain fully readable without it.

Inputs this calculator takes, with typical values
InputWhat to enterExample
Initial investment at t = 0The cash you commit before the project starts. Enter it as a positive number; it is treated as an outflow.100000 $
Maximum acceptable paybackThe cutoff your organisation applies. It changes only the verdict, never the payback period itself.3 periods
Cash flow for each period after t = 0One net cash flow per period, separated by commas. Put a minus sign in front of any period that is a net outflow.30000, 35000, 40000, 45000, 50000
Amounts are inApplies to the outlay and to every cash flow you type. Results are shown in whole dollars.Dollars
Assume cash arrives evenly through each periodOn, the answer is interpolated inside the recovery period. Off, payback is rounded up to whole periods because cash is assumed to land on the last day.Yes
Salvage or terminal valueAdded to the last period you typed. Payback rarely depends on it, but it changes the total cash the project returns.0 $

It returns

  • Payback period — How long the cash flows take to accumulate to the amount you invested.
  • Recovery completes during period
  • Margin inside your cutoff — Cutoff minus payback. Positive means the project recovers before the cutoff.
  • Net cash beyond recovery — Total cash flow less the outlay — the part payback ignores entirely. Negative if later periods hand money back.
  • Sum of cash flows, undiscounted
  • Periods detected

The formula

Payback=m+C0t=1mCFtCFm+1
Payback=C0CF

In plain text: Payback = m + (C₀ − cumulative CF through m) / CF in period m+1

  • C₀Cash outlay at time zero — the amount to be recovered ($)
  • CFₜNet cash flow in period t ($)
  • mNumber of complete periods before the cumulative total reaches the outlay (periods)

The fractional term assumes cash arrives evenly through the recovery period. Switch that assumption off and the answer becomes m + 1 whole periods, which is what you want when receipts land on a single date such as an annual royalty.

Updated Category Capital Budgeting & Project Appraisal Verified against published test cases Reading time 12 min

What the payback period measures, and what it deliberately ignores

Payback answers one question: how long is my money at risk? It counts forward from the outlay until the cumulative cash the project has produced equals the cumulative cash you put in. Everything after that moment is invisible to the measure, and so is the time value of money before it.

Those two omissions are usually presented as flaws, and as a measure of value they are. But payback is not a measure of value — it is a measure of exposure. A capital committee that caps payback at three periods is not claiming that year-four cash is worthless; it is saying it will not commit capital it cannot see coming back inside its own planning horizon. For a firm with tight liquidity, a technology on a two-year obsolescence cycle, or an asset sitting in a politically unstable jurisdiction, that is a defensible constraint rather than an analytical error.

It is also the measure managers actually use. In Graham and Harvey's survey of chief financial officers, just over half reported using payback always or almost always, despite every finance textbook warning against it — a gap between theory and practice that persists because payback captures something the discounted measures do not.

Use it as a screen, then. Compute payback to bound your exposure, and compute net present value to decide whether the project is worth doing at all. Where the two disagree, the accept decision belongs to NPV.

How the formula handles a recovery that lands mid-period

With a level cash flow the arithmetic is trivial: divide the outlay by the annual flow. A $100,000 asset returning $25,000 a year pays back in exactly four years. Real cash flow forecasts are not level, so the general method has two parts.

First, accumulate. Run a running total of the cash flows and find m, the last period at which that total is still below the outlay. Recovery happens somewhere inside period m + 1.

Second, interpolate. At the start of the recovery period you still need C₀ minus the total accumulated so far. Divide that shortfall by the cash flow arriving during the period, and you have the fraction of the period required. Add it to m.

The interpolation carries an assumption worth naming: that cash arrives at a constant rate through the period. For an operating business collecting receipts weekly, that is close enough to true. For a project whose only receipt is an annual licence fee paid every 31 December, it is false, and the honest answer is the whole period — which is why this calculator lets you switch interpolation off.

Two details change the answer more than people expect. Period length matters. Payback is reported in the units of your cash flows, so monthly flows give a payback in months. Do not label a 34-period monthly answer as 34 years. And negative interim flows can push the cumulative total back down after it has crossed. The convention this calculator follows is the standard one: payback is the first crossing. If a later overhaul drives the cumulative position negative again, that is real information, and it appears in the schedule and on the chart rather than in the headline number.

Worked example: a $100,000 machine with five uneven years

A plant buys a $100,000 packaging line. After-tax cash flows are forecast at $30,000, $35,000, $40,000, $45,000 and $50,000 over five years, and the capital committee will not approve anything with a payback beyond three years. Work it through.

  1. Set the target. You need to recover $100,000.
  2. Year 1. Cumulative cash flow = $30,000. Still unrecovered: 100,000 − 30,000 = $70,000.
  3. Year 2. Cumulative = 30,000 + 35,000 = $65,000. Still unrecovered: 100,000 − 65,000 = $35,000. The total is still below the outlay, so m = 2.
  4. Year 3. Cumulative = 65,000 + 40,000 = $105,000, which passes the outlay. Recovery happens during year 3.
  5. Interpolate. You entered year 3 needing $35,000, and year 3 delivers $40,000. The fraction required is 35,000 ÷ 40,000 = 0.875 of the year.
  6. Add. Payback = 2 + 0.875 = 2.875 years, which is 2 years and about 10.5 months.

Compare that with the cutoff: 3 − 2.875 = 0.125 years of margin, roughly six weeks. That is a thin cushion. Shave 10% off the year-3 cash flow — down to $36,000 — and the fraction becomes 35,000 ÷ 36,000 = 0.972, pushing payback to 2.972 years and leaving barely ten days of room.

Now look at what payback threw away. The five years deliver $200,000 in total against a $100,000 outlay, so $100,000 of net cash arrives after the recovery point, most of it in years 4 and 5. Payback treats a project that stops dead in year 3 and one that runs profitably for another decade as identical. That is the whole case for reading it next to NPV rather than instead of it.

One more check. Switch interpolation off and the answer becomes 3 years flat — the project now sits exactly on the cutoff rather than inside it. A convention, not a calculation, decided the verdict, which is a good reason to know which convention your committee applies.

How to read a payback period

Read it against three things: your cutoff, the asset's useful life, and the return the payback implies.

The cutoff is a policy, not a fact. Cutoffs of two to three years are common for equipment and IT, longer for infrastructure with a decades-long life. Whatever number your organisation uses, it should relate to the asset's life rather than to the calendar. A three-year cutoff applied to a twenty-year piece of civil works rejects almost everything worth building.

Compare payback with life. The ratio of payback to useful life is the informative figure. Recovering capital in 2.875 years on an asset with a five-year life means you spend 58% of the asset's life just getting your money back — the surplus comes from the last two years, which is exactly the part of the forecast you are least sure about. The same 2.875-year payback on a fifteen-year asset is a completely different proposition.

Translate payback into a return. For a level cash flow, the payback multiple is the present value annuity factor, so a payback period plus a useful life implies an internal rate of return. The reference table below inverts that relationship: it tells you the longest payback consistent with a given target return over a given life. To earn 15% on a level stream over a ten-year life, you must pay back within 5.02 periods; over a five-year life you must pay back within 3.35. That is the cleanest way to sanity-check a cutoff, and it is the bridge to the internal rate of return.

Finally, treat a payback that only just clears the cutoff as failing a stress test. Because the fraction inside the recovery period is a ratio of two forecast numbers, it is the least reliable digit in the answer.

The longest payback consistent with a target return

For a level cash flow, the payback multiple equals the present value annuity factor. Read the return you require and the asset's life, and the cell is the maximum payback in periods. A five-year asset that must return 15% has to pay back inside 3.35 periods.
Target return5-period life7-period life10-period life
0% (break even)5.007.0010.00
5%4.335.797.72
8%3.995.216.71
10%3.794.876.14
15%3.354.165.02
20%2.993.604.19
25%2.693.163.57

Each entry is the annuity factor (1 − (1 + r)⁻ⁿ) ÷ r, rounded to two places. It applies to a level stream only; for uneven cash flows compute the payback above and the IRR separately.

Payback in energy and efficiency work means something slightly different

In building services and energy retrofits, "simple payback" is normally quoted as the installed cost divided by the annual saving, with no interpolation and no escalation of energy prices. A $12,000 lighting upgrade saving $4,000 a year is a three-year payback on that convention. It is the same arithmetic as a level cash flow here — enter the cost as the outlay and the annual saving as a repeated cash flow.

Two adjustments matter in that setting. Savings usually rise with tariffs, so a flat annual figure understates recovery speed; and rebates or tax credits reduce the outlay rather than adding to the savings. Apply both to the inputs before reading the answer.

Mistakes that produce a misleading payback period

  • Using accounting profit instead of cash flow. Depreciation is not a cash outflow, so subtracting it understates the cash available to repay the outlay and lengthens payback artificially. Add it back.
  • Forgetting working capital in the outlay. Inventory and receivables the project ties up at the start are money at risk exactly like the equipment. Include them in the amount to be recovered.
  • Mislabelling the period. A payback of 34 computed from monthly cash flows is 34 months. Report the unit alongside the number.
  • Averaging away an uneven stream. Dividing the outlay by the mean annual cash flow gives the right answer only for a level stream. Where flows ramp up, that shortcut understates payback; where they decline, it overstates it.
  • Treating payback as a ranking tool. Two projects with identical paybacks can differ by an order of magnitude in value, because everything after recovery is excluded. Rank on NPV or profitability index.
  • Ignoring the interpolation convention. Whether the answer is 2.875 or 3.0 can decide a project against a 3-period cutoff. Agree the convention before the meeting, not during it.
  • Applying a single cutoff to every asset class. A cutoff should be a fraction of useful life. The same three-year rule that is sensible for a laptop fleet rejects viable long-lived infrastructure.

Payback sits at the bottom of a ladder of measures, each one adding back something the one below it ignores.

Discounted payback fixes the time value problem. Discount each cash flow at your required return, then accumulate the present values instead of the raw flows. Because a discount rate above zero shrinks every positive future flow, a stream of positive cash flows takes at least as long to recover in present-value terms as in nominal terms, and can fail to recover at all. The discounted payback period calculator does that arithmetic and reports both figures side by side.

Net present value fixes the truncation problem as well, by valuing every period in the forecast. It is the only measure of the three that tells you whether the project creates value, and it is additive across projects.

IRR and MIRR convert that value into a rate so it can be held against a cost of capital. IRR carries an implicit reinvestment assumption; the modified internal rate of return makes you state the reinvestment rate instead. When several projects compete for one fixed budget, rank them by profitability index.

A practical protocol: use payback as a gate on exposure, discounted payback when liquidity and the cost of capital both bind, and NPV as the decision. Build the discount rate for the last two from your weighted average cost of capital, not from the interest rate on the facility funding the purchase.

Key terms

Payback period
The time taken for cumulative net cash inflows to equal the initial outlay, measured in the same period units as the cash flows and ignoring the time value of money.
Cumulative net position
Running total of cash flows less the outlay. It starts at minus the outlay, and the payback period is the point at which it reaches zero.
Cutoff period
The maximum payback an organisation will accept. A policy choice about exposure, best set as a fraction of the asset's useful life.
Simple payback
The undiscounted version, cost divided by annual saving or annual cash flow. Standard usage in energy and efficiency work.
Bailout payback
A variant that adds the asset's resale value at each date to the cumulative cash flow, so recovery includes what you would get by walking away. Shorter than the standard measure whenever the asset holds value.

Frequently asked questions

Should I enter the initial investment as a negative number?

No. Type it as a positive figure in the Initial investment field and the calculator treats it as the outflow at period 0. Minus signs belong only inside the cash flow list, for periods that are net outflows such as a mid-life overhaul. Those reduce the running total, and because payback is measured at the first crossing, a dip after recovery does not change the headline figure.

What is a good payback period?

It depends on the asset's life, not on the calendar. The useful test is the ratio: recovering capital in under half the asset's useful life leaves the surplus coming from the more predictable middle of the forecast, while a payback stretching past three-quarters of the life makes the project a bet on the tail. In the worked example above, 2.875 years on a five-year asset is 58% of the life — acceptable, but with little room for error.

Why is my payback period undefined?

Because the cash flows you entered never accumulate to the outlay. Three $10,000 receipts total $30,000, which cannot recover $100,000 no matter how the arithmetic is arranged, so there is no crossing point to report. Either your forecast horizon is shorter than the recovery period — extend it — or the project genuinely never repays its cost, in which case its NPV is negative at every discount rate too.

Why does this give 2.875 years when my textbook says 3?

Both are right under different conventions. Interpolating inside the recovery period assumes cash arrives evenly through the year and gives 2.875. Counting whole periods assumes the year-3 cash lands on the last day and gives 3. Many textbooks and most spreadsheets built by hand use the whole-period version because it needs no assumption about timing. Switch the Assume cash arrives evenly box off to reproduce it.

Does the payback period account for the cost of capital?

No, and that is its defining limitation. Payback adds up nominal dollars, so a receipt in year five counts exactly as much as one in year one. Discounting each flow at your required return before accumulating produces the discounted payback period, which is always at least as long for a stream of positive cash flows and is the version to use when the cost of capital is a binding constraint.

Can I use this for a monthly or quarterly project?

Yes. Enter one cash flow per period and the answer comes back in those same units — 18 monthly flows produce a payback in months. Set the cutoff in the same units too. Nothing in the calculation assumes years; the only requirement is that all your periods are the same length, which is why an irregular calendar of receipts needs a date-aware method instead.

How do I handle working capital and salvage value?

Working capital committed at the start belongs in the outlay, because it is money at risk that has to come back. Its release at the end, together with any resale proceeds, belongs in the final period — use the salvage field. Salvage rarely changes the payback period itself, since recovery usually happens long before the last period, but it changes the total cash the project returns and therefore the NPV.

Which is better, payback or NPV?

NPV, for the accept-or-reject decision — it is the only one of the two that measures value created, and it is additive across projects. Payback answers a different and narrower question about how long capital is exposed, which matters when liquidity is tight or the technology is short-lived. Run both. Where they conflict, follow NPV and use the payback figure to argue about risk rather than about worth.

Does a shorter payback always mean a better project?

No. Payback is blind to everything after recovery, so it favours front-loaded projects regardless of how much total value they create. A project paying back in two years then stopping loses to one paying back in four years and running profitably for another decade, yet payback ranks them the other way round. Use it as a constraint to be satisfied, not as a score to be maximised.

References

  • Principles of Corporate Finance, 13th ed. — Chapter 5, Net Present Value and Other Investment Criteria — McGraw-Hill (Brealey, Myers & Allen)
  • The Theory and Practice of Corporate Finance: Evidence from the Field, Journal of Financial Economics 60 (2001) — Elsevier (John Graham & Campbell Harvey)
  • CFA Program Curriculum — Corporate Issuers: Capital Investments — CFA Institute
  • Fundamentals of Corporate Finance, 12th ed. — Investment Criteria — McGraw-Hill (Ross, Westerfield & Jordan)