Payback Period Calculator
Calculate simple and discounted payback period, NPV, and cumulative cash flow by year.
| Year | Cash Flow | Cumulative | PV of CF | Cumulative PV | Status |
|---|
Calculate the simple and discounted payback period for an investment, along with NPV and a full year-by-year cumulative cash flow breakdown.
How Payback Period Calculator Works
The simple payback period is the amount of time it takes for cumulative (undiscounted) cash inflows to equal the initial investment — found by tracking a running total and interpolating fractionally between the year the balance turns positive and the prior year.
The discounted payback period does the same thing, but first converts every year's cash flow to its present value using PV = Cash Flow ÷ (1 + Discount Rate)^Year before accumulating — since money received later is worth less today, discounted payback is always equal to or longer than simple payback.
Net Present Value (NPV) sums all discounted cash flows (including the negative initial investment) — a positive NPV indicates the investment is expected to generate more value than its cost at your chosen discount rate, complementing the payback period, which says nothing about profitability beyond the payback point itself.
See It In Action
Who Uses Payback Period Calculator and Why
- Checking how many years it takes for an investment\'s cash inflows to recover the initial cost.
- Comparing simple payback period against discounted payback period to see how much the time value of money changes the picture.
- Using NPV alongside payback period to judge whether an investment is profitable beyond just the point of recovering its cost.
- Evaluating a project with uneven, year-by-year cash flows rather than a uniform annual amount.
Mistakes to Avoid
- Using payback period as the sole decision metric — it ignores any cash flows after the initial investment is recovered, so a project with a longer payback but much larger long-term returns could still be the better investment, which is exactly why NPV is shown alongside it.
- Comparing simple payback period across two projects without also checking discounted payback — since discounted payback is always equal to or longer than simple payback, a project that looks fast to recover on a simple basis may look meaningfully slower once the time value of money is factored in.
- Assuming a positive NPV and a short payback period always go together — they measure different things, and it\'s possible for a project to reach payback quickly but still have relatively modest NPV, or vice versa.
Tips for Best Results
- Use discounted payback period, not simple payback, whenever you want the timing figure to actually reflect the time value of money — simple payback treats every future dollar as equally valuable, which understates how long true recovery takes.
- If comparing projects with uneven cash flows (revenue that ramps up or down over time), switch to "Variable" mode rather than approximating with a uniform annual amount.
Fixing Common Problems
My discounted payback period is noticeably longer than my simple payback period. — This is expected and not an error — discounting reduces the value of future cash flows before they count toward recovering the investment, so it always takes more calendar years of discounted cash flow to add up to the same initial investment as undiscounted cash flow would.
Terms Explained
Simple payback period: The time it takes for cumulative, undiscounted cash inflows to equal the initial investment.
Discounted payback period: The same calculation, but using each year\'s present value instead of its raw amount — always equal to or longer than simple payback.