Payback Period Calculator
Payback period ยท Discounted payback ยท NPV ยท IRR ยท Full annual schedule
| Year | Cash Flow ($) |
|---|
โฑ๏ธ Enter your investment cost and expected cash flows to calculate payback period, discounted payback, and NPV.
What Is the Payback Period?
The payback period is the time it takes to recover the initial cost of an investment from its cumulative cash flows. Once cumulative cash flows equal the initial investment, the project has paid for itself.
For unequal cash flows, the payback period is found by tracking cumulative cash flows year by year until the running total exceeds the initial investment, then interpolating within the final year:
Payback period is used in capital budgeting to screen investments. A company might require that all projects pay back within 3 years, rejecting any that take longer regardless of their total profitability. This is a risk reduction measure: the sooner your capital is returned, the less exposure you have to project uncertainty.
Limitations
The payback period ignores two important things. First, it does not account for the time value of money - $1 received in year 1 is treated the same as $1 received in year 4, even though the earlier dollar is more valuable. Second, it ignores all cash flows after the payback date. A project with a 3-year payback that generates nothing afterward is far less valuable than one with a 3-year payback followed by 20 years of strong cash flows, but both show the same payback period.
Discounted Payback Period
The discounted payback period applies the time value of money. Each year's cash flow is discounted to its present value before cumulating. Because a dollar received in the future is worth less than a dollar today, the discounted payback period is always longer than the simple payback period.
Using the same $100,000 project earning $25,000 per year at a 10% discount rate:
| Year | Cash Flow | PV at 10% | Cumulative PV |
|---|---|---|---|
| 1 | $25,000 | $22,727 | $22,727 |
| 2 | $25,000 | $20,661 | $43,388 |
| 3 | $25,000 | $18,783 | $62,171 |
| 4 | $25,000 | $17,075 | $79,246 |
| 5 | $25,000 | $15,523 | $94,769 |
| 6 | $25,000 | $14,112 | $108,881 |
Simple payback: 4.0 years. Discounted payback at 10%: 5 + ($100,000 - $94,769) / $14,112 = 5.37 years. The 1.37-year gap reflects the cost of waiting for the cash flows to arrive.
NPV and the Relationship to Payback Period
Net Present Value (NPV) is the sum of all discounted future cash flows minus the initial investment. A positive NPV means the project creates value above the required return rate; a negative NPV means it destroys value. NPV and discounted payback period are derived from the same discounted cash flow framework but answer different questions.
| Metric | Answers | Accounts for Time Value? | Main Limitation |
|---|---|---|---|
| Payback Period | How fast do I get my money back? | No | Ignores post-payback cash flows |
| Discounted Payback | How fast (in real terms) do I get my money back? | Yes | Still ignores post-payback cash flows |
| NPV | How much value does the project create? | Yes | Requires estimating all cash flows |
| IRR | What annual return does the project earn? | Yes | Can produce multiple solutions |
| ROI | What is the total percentage return? | No (unless annualized) | Ignores timing of cash flows |
Payback period is most useful as a liquidity and risk screen, not as a value measure. A short payback reduces the risk that business conditions change before you recover your capital. For value measurement, NPV is the correct tool. The two metrics complement each other: use NPV to decide if a project is worth doing, and payback period to understand your liquidity exposure.
Payback Period Benchmarks by Industry
Acceptable payback periods vary significantly by sector, asset type, and company policy. These are typical ranges observed in practice:
| Investment Type | Typical Payback Target | Notes |
|---|---|---|
| Manufacturing equipment | 2 to 5 years | Depends on asset life and obsolescence risk |
| IT systems and software | 1 to 3 years | Technology risk favors short payback |
| Energy efficiency upgrades | 3 to 7 years | Often subsidized with incentives |
| Solar and renewable energy | 5 to 12 years | Long asset life supports longer payback |
| Residential real estate | 10 to 20 years | Gross rent multiplier often used instead |
| Commercial real estate | 7 to 15 years | Varies by cap rate and financing |
| R&D and new products | 3 to 8 years | Often not calculable before launch |
| Small business acquisition | 3 to 6 years | SBA loans often require under 5-year payback |
Companies in fast-moving industries (technology, fashion, consumer electronics) tend to require shorter payback periods because market conditions change rapidly. Capital-intensive industries with long-lived assets (utilities, pipelines, mining) accept longer payback horizons because the assets are stable and durable.
Discount Rate and WACC
The discount rate used for the discounted payback period and NPV calculations is typically the Weighted Average Cost of Capital (WACC) for a company evaluating a capital project.
WACC reflects the blended cost of the two sources of capital a company uses: equity (from shareholders, who expect a return for bearing risk) and debt (from lenders, who charge interest). Both have a cost, and both must be compensated before a project creates value for the firm.
For a project to create value, its IRR must exceed the WACC. A project with an IRR of 15% at a WACC of 9% creates 6 percentage points of excess return per year, compounding over the project's life. The NPV is the present value of this excess return.
Choosing the Discount Rate in Practice
- Corporate capital projects: Use the company's WACC, which ranges from 7 to 12% for most large-cap US companies.
- Small business: Owner's required rate of return, typically 15 to 25%.
- Real estate: Investors commonly use the capitalization rate or a target cash-on-cash return of 8 to 12%.
- Government projects: A social discount rate of 3 to 7%, reflecting the lower risk and the public welfare component.