Payback Period Calculator
Calculates how long an investment takes to pay for itself from the cash it generates. Enter the initial investment and either a steady annual cash flow or different cash flows for each of up to ten years. You get the simple payback period, and with a discount rate the discounted payback period, which accounts for the time value of money, plus the net present value of the cash flows and a year-by-year table of cumulative and discounted cash flows.
- Cash flows arrive evenly during each year.
- Steady cash flows are projected for up to 100 years; irregular ones use only the years you enter.
Formula
Payback = years before recovery + unrecovered amount at the start of that year ÷ cash flow in that year; discounted payback uses CFₜ ÷ (1 + r)ᵗ
- With a steady cash flow, the simple payback is investment ÷ annual cash flow.
- Discounted cash flow in year t = CFₜ ÷ (1 + r)ᵗ, which makes later cash worth less today.
- Cash is assumed to arrive evenly through each year, so the final fraction of a year is interpolated.
- NPV = Σ discounted cash flows − initial investment.
10,000 investment returning 2,500 a year at a 10% discount rate
Inputs
- Initial investment: 10000
- Discount rate: 10 %/yr
- Cash flows: steady
- Annual cash flow: 2500
- Year 1 cash flow: 3000
- Year 2 cash flow: 4000
- Year 3 cash flow: 4000
- Year 4 cash flow: 3000
- Year 5 cash flow: 2000
Simple payback: 10,000 ÷ 2,500 = 4 years. Discounted at 10%, the yearly flows are worth 2,272.73, 2,066.12, 1,878.29, 1,707.53, 1,552.30 and 1,411.18; after 5 years 9,476.97 is recovered, and the remaining 523.03 takes 523.03 ÷ 1,411.18 = 0.37 of year 6, so the discounted payback is 5.37 years.
Sources & references
Frequently asked questions
What is the payback period?
The time it takes for an investment's cash inflows to repay the initial cost. A machine costing 20,000 that saves 5,000 a year pays back in 4 years.
Why use the discounted payback period?
Money received later is worth less than money today. Discounting each year's cash flow by the cost of capital gives a longer, more realistic payback period.
What are the limits of the payback period?
It ignores cash flows after the payback point and, in its simple form, the time value of money. Use it alongside NPV or IRR when comparing projects.
Related calculators
Break-Even Analysis Calculator Finds the break-even point: how many units you must sell, and how much revenue you need, before sales cover all fixed and variable costs. Enter the selling price per unit, the variable cost per unit and your fixed costs, and optionally a target profit. You also get the contribution margin per unit and as a ratio, the profit margin and markup on each unit, and the profit or loss at any sales volume you enter. ROI Calculator Calculates the return on investment (ROI): how much an investment gained or lost relative to what was put in. Enter the amount invested and the amount returned (the final value, including any income received) to get the profit or loss and the ROI percentage. Add how long the money was invested to also get the annualized ROI, the constant yearly rate of return that would produce the same result, which lets you compare investments held for different lengths of time. CAGR Calculator Calculates the compound annual growth rate (CAGR): the steady yearly rate at which a value would have to grow to go from its starting value to its ending value over a number of years. Use it for investments, revenue, users or any quantity that grows over time. Enter any three of initial value, final value, number of periods and CAGR to find the fourth, and see the total change and the value at the end of each period.