What the discounted payback period measures
Discounted payback is the point at which a project has returned your capital and paid the required return on it for the whole time it was tied up. Ordinary payback only asks when the nominal dollars come back. This version asks when the present value of what has come back equals what you put in — a strictly harder test whenever your required return is above zero.
The difference is not cosmetic. Discounting a stream of positive receipts shrinks every one of them, so the running total climbs more slowly and the crossing point moves later. On the default five-year stream in this calculator, recovery moves from 2.875 periods to 3.447 periods once a 10% cost of capital is applied — better than half a year later. At a high enough rate, recovery may never happen at all: four annual receipts of $30,000 against a $100,000 outlay repay the money nominally, but discounted at 20% they are worth only $77,662 today, so the outlay is never covered.
That last case is the useful property of the measure. On a conventional stream — one outlay followed by nothing but inflows — a positive net present value guarantees a finite discounted payback, and a negative NPV guarantees there is none. The cumulative present value climbs steadily from −C₀ and finishes at the NPV, so it crosses zero exactly when the NPV ends above zero. Discounted payback therefore carries a genuine accept-or-reject test that ordinary payback lacks, while still telling you the thing payback exists to tell you: how long your capital is exposed.
Put an interim outflow into the stream and half of that guarantee lapses. The running total is no longer monotonic, so it can cross zero and later fall back below it. Commit $100,000, collect $200,000 in year 1 and pay $150,000 of remediation in year 2, all at a 10% required return: the running present value reaches the outlay after 0.55 periods, because $100,000 ÷ $181,818.18 = 0.55, yet the stream's net present value is $181,818.18 − $123,966.94 − $100,000 = −$42,148.76. A finite discounted payback on a non-conventional stream is not on its own an accept. That is why this calculator reports the NPV beside it.
What it still ignores is everything after the crossing point. Use it as a liquidity-and-return screen and read it next to net present value, which values every period in the forecast.
How the formula works, term by term
There are three moves, and the first two are borrowed wholesale from ordinary payback.
Discount each flow. Multiply the cash flow in period t by (1 + r)−t, the present value of $1 received t periods from now. At 10% that factor is 0.9091 in period 1, 0.7513 in period 3 and 0.6209 in period 5 — so the later a receipt arrives, the less it contributes to recovering your outlay.
Accumulate. Add the present values in order and find m, the last period at which the running total is still below the outlay. Recovery happens inside period m + 1.
Interpolate. Divide the present value still unrecovered at the start of that period by the present value arriving during it, and add the fraction to m.
Two things about the discount rate decide whether the answer means anything. It must be the return you require on capital of this project's risk — build it from the weighted average cost of capital of a business with the same risk profile, not from the interest rate on the facility that funds it. And it must be expressed for the same period length as your cash flows: with quarterly flows, a 12% annual required return becomes 1.120.25 − 1 = 2.874% per quarter, not 3%.
For a level cash flow the whole thing collapses to a closed form. Setting the annuity factor equal to the payback multiple C₀ ÷ CF and solving for the number of periods gives DPB = −ln(1 − r·C₀/CF) ÷ ln(1 + r). That formula also shows you the failure boundary: the logarithm is undefined once r·C₀/CF reaches 1, which is another way of saying a perpetual level stream discounted at r can never be worth more than CF ÷ r. If your outlay exceeds that ceiling, no finite payback exists at any horizon.
Worked example: the same machine, now with a 10% cost of capital
A $100,000 packaging line returns $30,000, $35,000, $40,000, $45,000 and $50,000 over five years. The cost of capital is 10%, and the capital committee's cutoff on the discounted figure is four years.
- Year 1. Factor 1 ÷ 1.10 = 0.909091. PV = 30,000 × 0.909091 = $27,272.73. Cumulative: $27,272.73.
- Year 2. 1.102 = 1.21, factor 0.826446. PV = 35,000 × 0.826446 = $28,925.62. Cumulative: $56,198.35.
- Year 3. 1.103 = 1.331, factor 0.751315. PV = 40,000 × 0.751315 = $30,052.59. Cumulative: $86,250.94 — still below $100,000, so m = 3.
- Year 4. 1.104 = 1.4641, factor 0.683013. PV = 45,000 × 0.683013 = $30,735.61. Cumulative: $116,986.55, which passes the outlay. Recovery happens during year 4.
- Interpolate. Unrecovered at the start of year 4: 100,000 − 86,250.94 = $13,749.06. Fraction of the year needed: 13,749.06 ÷ 30,735.61 = 0.447333.
- Add. Discounted payback = 3 + 0.447333 = 3.447 years, comfortably inside the four-year cutoff with 0.553 years of margin.
Compare the two measures directly. The undiscounted payback on the same stream is 2 + 35,000 ÷ 40,000 = 2.875 years. Applying the 10% cost of capital pushes recovery out by 3.447 − 2.875 = 0.572 years, close to seven months. That gap is the price of the time your capital was tied up, expressed in time rather than in dollars.
Finish by adding year 5: PV = 50,000 × 0.620921 = $31,046.07, bringing total present value to $148,032.61 and net present value to $48,032.61. Notice what that figure is: since exactly $100,000 of present value had been recovered at the 3.447-year mark, the remaining $48,032.61 is the present value the project delivers after discounted payback. The two numbers are two views of the same schedule.
How to read the result
Start with whether a finite answer exists at all. If the calculator returns a dash, the discounted flows never reach the outlay inside your horizon, and the project's net present value over that horizon is negative — it is a reject, not merely a slow payer.
Then compare the figure with your cutoff. A cutoff on the discounted measure should be set higher than one on the raw measure, because the discounted figure is systematically later for a stream of positive receipts. Applying a three-year rule written for undiscounted payback to a discounted number quietly tightens the standard; on the worked example it would flip an accept into a reject.
Then read the gap between the two paybacks. It is a sensitivity measure in disguise. A small gap means the project's cash arrives early enough that the cost of capital barely matters. A large gap — more than a year on a five-year project, say — means your answer is highly geared to the discount rate, and it is worth recomputing at your hurdle rate plus three points before committing.
Finally, look at what happens after the crossing. The net present value output is the present value delivered after discounted payback, so the ratio of that figure to the outlay tells you how much of the project's value sits beyond the recovery point. On the worked example that ratio is 48,032.61 ÷ 100,000 = 0.48, which is also the profitability index minus one. A project whose entire value sits in the years after payback is a bet on the tail of your forecast; one that clears its cost early is not.
What discounting does to a level-stream payback
| Undiscounted payback | 0% | 5% | 10% | 15% | 20% |
|---|---|---|---|---|---|
| 2.0 periods | 2.00 | 2.16 | 2.34 | 2.55 | 2.80 |
| 3.0 periods | 3.00 | 3.33 | 3.74 | 4.28 | 5.03 |
| 4.0 periods | 4.00 | 4.57 | 5.36 | 6.56 | 8.83 |
| 5.0 periods | 5.00 | 5.90 | 7.27 | 9.92 | never |
The "never" cell is not rounding: a level stream discounted at r can never be worth more than CF ÷ r however long it runs, so at 20% a stream worth 5 times the annual flow exactly reaches the outlay only in the limit. Notice how the penalty compounds — at 20% a four-year nominal payback more than doubles.
When a positive NPV guarantees a finite discounted payback
The cumulative present value in the schedule starts at minus the outlay and ends at the net present value. A positive NPV therefore always means the running total crossed zero somewhere, and that first crossing is the discounted payback — no exceptions. So discounted payback can never fail to find a value-creating project.
The converse holds only when every period after the outlay is an inflow. Then the running total rises monotonically, and a negative NPV means it never got as far as zero. Once an interim period is negative the total can rise past zero and come back down, so a project can report a short discounted payback and still destroy value. Check the NPV output before you read a fast recovery as an accept.
The failure mode that survives in every case is the opposite one: rejecting a positive-NPV project because its crossing lands later than an arbitrary cutoff allows. That is a risk policy, not an analytical result, and it is the reason no serious capital process uses discounted payback as its sole rule.
Pitfalls and what this calculator does not model
- Using a nominal rate with real cash flows. Holding cash flows flat in today's prices while discounting at a nominal cost of capital double-counts inflation and pushes payback out for no economic reason. Keep both nominal or both real.
- Mismatching the rate to the period. A 12% annual requirement is 2.874% per quarter, obtained by compounding, not 3%. Using 3% overstates the discount and lengthens the reported payback.
- Applying an undiscounted cutoff to a discounted answer. The discounted figure is later for a positive stream. Cutoffs must be restated when you switch measures.
- Discounting accounting profit. Depreciation is not a cash outflow. Work from after-tax operating cash flow, plus depreciation, less capital expenditure and less the increase in working capital.
- Subtracting interest from the cash flows. The discount rate already charges for financing; deducting interest as well counts the cost of capital twice.
- Forgetting working capital at both ends. Inventory and receivables committed at the start belong in the outlay; their release belongs in the final period.
- Reading a dash as an error. No discounted payback means the discounted flows never cover the outlay over the periods you entered. Extend the horizon or accept that the project's NPV is negative.
- Assuming equal periods when the calendar is irregular. This calculation places each flow at the end of an equal period. For receipts on arbitrary dates use a date-aware method such as XIRR.
Where discounted payback fits among the decision rules
Discounted payback sits between raw payback and net present value, and it is best understood as payback with the time-value defect repaired but the truncation defect left in place.
Against raw payback: it costs you nothing but a discount rate and it removes the indefensible assumption that a dollar in year five is worth a dollar today. If your organisation insists on a payback rule, this is the version to insist on.
Against net present value: it still throws away every cash flow after the crossing point, so it cannot rank projects and cannot tell you how much value one creates. NPV is the decision rule; discounted payback is a constraint on how long capital may stay at risk.
Against the rate-based rules: the internal rate of return converts the same schedule into a return that can be held against a hurdle, and the modified internal rate of return does the same while letting you state a reinvestment rate. Neither says anything about exposure over time, which is exactly what payback measures.
A workable protocol for a capital committee: require positive NPV, require discounted payback inside a cutoff set as a fraction of the asset's useful life, and quote IRR alongside so the numbers can be discussed as returns. Where NPV and a payback cutoff conflict, the cutoff is a risk policy and should be argued as one — not treated as an analytical result.
Key terms
- Discounted payback period
- The time taken for the cumulative present value of a project's cash flows to equal its initial outlay, measured in the same period units as the cash flows.
- Discount factor
- The present value of $1 received in period t, equal to (1 + r)−t. Multiply a cash flow by it to move the money back to today.
- Cumulative position
- Running total of present values less the outlay. It begins at minus the outlay and ends at the net present value; the discounted payback is where it reaches zero.
- Cutoff period
- The longest payback an organisation will accept. A risk policy, and one that must be restated when you move from the undiscounted to the discounted measure.
- Annuity factor
- (1 − (1 + r)−n) ÷ r, the present value of $1 per period for n periods. Its ceiling as n grows is 1 ÷ r, which is why some level streams never pay back in present-value terms.