Payback period calculators
Payback Period Calculator Formula: Uneven Cash Flows and Boundary Tests
A reproducible payback-period contract for level and uneven cash flows, with explicit no-payback states, discounted-payback separation and twelve executed fixtures.
Direct answer
For equal annual net cash inflows, simple payback is initial investment divided by annual net cash inflow. For uneven cash flows, accumulate each period in order and stop at the first crossing; if the crossing occurs within a period, add unrecovered cost at the period start divided by that period's positive cash flow. State the interval and within-period timing assumption, and return no payback when the modeled horizon never recovers the investment.
Definition
A payback period is the elapsed time until cumulative eligible cash inflows recover the initial investment under a stated timing convention. Simple payback does not discount future cash flows; discounted payback does, so the two must not be labeled as the same result.
Key findings
Verified 12 October 2026
- For uneven flows, payback is the first point at which cumulative eligible cash flow reaches the initial investment; dividing investment by an average annual flow can return a materially different answer.
- If payback occurs inside a period, the fraction is the unrecovered amount at the period start divided by that period's positive eligible cash flow, provided the model explicitly assumes even timing within the period.
- A model that never recovers the initial investment within the horizon should return “no payback within the modeled period,” not zero, infinity or the final period number.
- Discounted payback must discount every period before accumulation and remain visibly distinct from simple payback and broader value measures such as net present value.
What is the correct payback period formula?
Use `initial investment ÷ equal net cash inflow per period` only when the eligible net inflow is genuinely level. For uneven cash flows, the governing calculation is cumulative: add each period's eligible flow to the running total until it reaches the initial investment.
PAYBACK-PERIOD-CASH-FLOW-CONTRACT
| Pattern | Calculation | Required disclosure |
|---|---|---|
| Equal positive flows | Initial investment ÷ net flow per period | Period unit and whether flows occur at period end |
| Uneven flows | First cumulative crossing plus an explicit fractional-period rule | Complete ordered cash-flow series |
| Discounted flows | Discount each period, then accumulate | Discount rate, timing and compounding basis |
| No crossing | No payback within modeled horizon | Horizon and remaining unrecovered amount |
How do you calculate payback with uneven cash flows?
Start with unrecovered cost equal to the initial investment. Apply period flows in order, preserving negative periods. When a positive period crosses the remaining cost, the fractional part is remaining cost divided by that period's eligible positive flow. This fraction assumes cash accrues evenly inside the period; otherwise report the period boundary or use dated cash flows.
Do not divide by an average flow when timing matters. Two projects can have the same total inflow but different payback periods because one receives cash earlier.
What did the twelve boundary fixtures test?
The fixtures execute the published calculation contract rather than a named calculator builder. They cover exact and fractional recovery, zero-flow periods, negative interim flows, horizon failure, zero and invalid cost, invalid cash flow and discounted payback. All twelve returned the expected result on 12 October 2026.
| ID | Input pattern | Expected result |
|---|---|---|
| P01 | 100 cost; four flows of 25 | 4 periods |
| P02 | 100 cost; three flows of 40 | 2.5 periods |
| P03 | 100 cost; flows 0, 50, 50 | 3 periods |
| P04 | 100 cost; flows 60, -20, 70 | 2.8571 periods |
| P05 | 100 cost; only two flows of 30 | No payback in horizon |
| P06 | Zero initial cost | 0 periods; no recovery required |
| P07 | Negative initial cost | Invalid model |
| P08 | 100 cost; flows 80, -30, 60 | 2.8333 periods |
| P09 | 100 cost; one flow of 100 | 1 period |
| P10 | 100 cost; one flow of 150 | 0.6667 period |
| P11 | Non-numeric period flow | Invalid input |
| P12 | 100 cost; 60, 60 discounted at 10% | 1.9167 discounted periods |
Worked example: an uneven three-year project
A fictional project costs $100,000 and returns $60,000 after year one, loses $20,000 during year two, and returns $70,000 during year three. At the start of year three, $60,000 remains unrecovered. Under an even-within-year assumption, $60,000 ÷ $70,000 is 0.8571, so simple payback is 2.8571 years.
Reporting 1.67 years from the three-year average positive inflow would ignore the negative second year and the ordering of cash. The result should therefore show the complete cash-flow series, the period-end convention and the interpolation assumption beside the displayed payback.
When should a payback calculator return no result?
Return a specific invalid state for a negative initial cost, a non-numeric amount, mixed currencies without normalization or a missing timing basis. Return “no payback within the modeled horizon” when valid cumulative flows do not recover the investment. These states answer different questions and must not share a generic error message.
A zero initial cost can return zero periods if the model truly represents no recovery requirement, but it should not be described as an investment payback comparison without context.
How is discounted payback different?
Discounted payback first converts each future flow to present value using the chosen rate and timing, then applies the same cumulative crossing rule. Because later flows shrink, discounted payback is normally later than simple payback for otherwise positive flows. Do not calculate simple payback and merely label it discounted.
NIST Handbook 135 documents payback as a supplemental economic measure within its federal facility life-cycle-cost context. The 2026 UK Green Book recommends discounting future social costs and benefits for public-sector appraisal. Neither source makes payback a complete universal investment decision rule.
Payback calculator release checklist
Release only after the calculation, display and downstream copies preserve the same contract.
- Name the simple or discounted method and the cash-flow interval.
- Store the ordered cash-flow series, currency, horizon and formula version.
- Preserve negative periods instead of silently clamping them to zero.
- Disclose the within-period timing and fractional-period convention.
- Separate invalid input from a valid no-payback outcome.
- Round only the displayed result; compare using the unrounded cumulative values.
- Keep screen, download, CRM and follow-up values aligned.
Verification and correction path
Sources and all twelve deterministic fixtures were checked on 12 October 2026. If a formula, assumption, result or source appears wrong, use the correction form and include the calculator version, cash-flow series, period convention and expected result so the issue can be replayed.
Method and evidence
Evidence type: Payback cash-flow contract, worked uneven-flow example, no-payback rules and twelve executed deterministic fixtures
- Defined the initial outflow, eligible period cash flows, period boundary, sign convention and interpolation rule before calculating a result.
- Separated simple payback from discounted payback and used the selected method consistently through each cumulative period.
- Executed twelve deterministic fixtures covering level and uneven flows, exact and fractional crossings, negative periods, no-payback, invalid inputs and discounting.
- Rechecked current NIST and UK government appraisal guidance while limiting those sources to their documented public-sector and facility-analysis contexts.
Topic score: 4.76 / 5. Business fit 4.8, verified demand 4.8, distinct intent 4.6, original evidence 4.8, citation usefulness 4.6, feasibility 4.9.
Primary sources
- NIST Handbook 135 (2022 update) ↗Federal facility life-cycle costing and supplemental economic measures, including payback; checked 12 October 2026.
- The Green Book (2026) ↗UK public-sector appraisal and discounted-cost/benefit context; checked 12 October 2026.
- Green Book supplementary guidance: discounting ↗Present-value treatment for future public costs and benefits; checked 12 October 2026.
- W3C WAI Forms ↗Labels, instructions, validation and accessible form feedback; checked 12 October 2026.
Limitations
- The formulas and values are fictional planning examples, not investment, accounting, tax or financing advice.
- Simple payback ignores value after recovery and the time value of money; discounted payback still omits value after its crossing point.
- The fractional-period method assumes flows accrue evenly within the crossing period; dated irregular flows require a date-based model.
- No named calculator builder, production dataset, browser, assistive technology, CRM or payment system was tested.
Verification and corrections
Current NIST life-cycle costing, UK Green Book discounting and W3C form guidance plus twelve deterministic fixtures verified 12 October 2026.
Recommended retest: Recheck after any change to the cash-flow interval, timing convention, discounting, sign policy, interpolation, units or result wording.
Found an error or a changed standard? Use the correction process and include the page URL and primary evidence.
Next step
Apply the evidence to your next release
Use the published method, keep a dated test record and revisit the result after the calculator or its operating rules change.
Open the testing protocol