Payback Period Calculator · Calculation guide

Estimate when cash receipts recover an initial investment.

Calculation guide

For business owners exploring costs, cash flow or valuation scenarios.

Keep revenue, cost and time periods consistent. Profit margin divides by revenue; markup divides by cost. Discounted cash flows are scenario assumptions, and terminal growth must be below the discount rate. Payback uses linear interpolation within the recovery period. Customer lifetime value uses the entered finite horizon, retention, margin and discount assumptions. No valuation or business outcome is guaranteed. Negative cash flows represent money paid out; positive flows represent money received. Include the final valuation as a positive flow if relevant. IRR uses equal periods; XIRR discounts actual calendar-day differences using ACT/365F. Nonconventional sign-change patterns are reported as potentially ambiguous instead of silently choosing one root. NPV uses the entered discount rate.

k=min{n:Σ_{t≤n}PV(CF_t)≥P}; T=(k−1)+(P−Σ_{t<k}PV(CF_t))/PV(CF_k)

Inputs

Initial

Money already invested or available at the beginning of this calculation.

Annual interest / discount rate

Effective annual discount rate used to express future cash flows in today’s value.

Amount

Amount for this calculation or dated cash flow. Where negative amounts are allowed, negative means paid out and positive means received.

Worked example

InputValue
Initial100,000
Annual interest / discount rate0%

Forecast

Amount
50,000
60,000
70,000

Formula:

k=min{n:Σ_{t≤n}PV(CF_t)≥P}; T=(k−1)+(P−Σ_{t<k}PV(CF_t))/PV(CF_k)

Payback years = 1.83333333333333

Year = 1.00000000000000; Cash flow = 50000.0000000000; Present value = 50000.0000000000; Cumulative value = -50000.0000000000

Year = 3.00000000000000; Cash flow = 70000.0000000000; Present value = 70000.0000000000; Cumulative value = 80000.0000000000

ResultValue
Payback years1.833333 years
Net cash at horizon80,000

Interpreting the result

First recovery point, with a fractional year estimated within the recovery period.

Cumulative discounted receipts minus the original investment at the final forecast year.

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Initial100,000110,000Payback years1.833333 years2 years
Annual interest / discount rate0%1%Payback years1.833333 years1.8585 years
Amount (row 1)50,00055,000Payback years1.833333 years1.75 years
Payback Period Calculator →