Payback Period Calculator
A project payback model (simple and discounted).
It measures years to recover the investment — not customer-channel CAC months.
Use it when recovery speed matters alongside NPV for capital rationing.
Your numbers stay in this browser. Export only — nothing is uploaded. Illustrative, not financial advice.
Payback Period Calculator
Years to recover the investment — simple payback and discounted payback (cash flows present-valued at your discount rate). Project years, not customer-channel months.
Sample figures (100k · 30k × 5 · 10%). Distinct from LTV:CAC & CAC Payback.
Outlay, discount rate, and cash flows
Persist locally · Jump to results
Simple and discounted payback
Fractional year = year_before + remaining ÷ CF that year. Cumulative helpers below.
Equations
- CumUndisc[t] = Σ CF1…t · SimplePayback when cum crosses Initial
- PVt = CFt ÷ (1+r)t · CumDisc similarly → DiscountedPaybackYears
- Fractional ≈ year_before + (Initial − Cum_before) ÷ CF_year
How this is calculated
- Simple payback (years) — years until cumulative undiscounted CF recovers Initial
- Discounted payback (years) — same using present-valued cash flows at your discount rate
- Fractional year ≈ year before crossing + remaining balance ÷ that year’s CF (or PV)
- This is project payback in years — not LTV:CAC / CAC Payback (customer unit-economics months)
Illustrative — not financial advice.
Take it with you
Get the worked example workbook in Excel — type your own numbers into it.
The Excel is the worked example workbook — type your own numbers into it. Stays on your device.