Discounted Payback Period Calculator
About the Discounted Payback Period Calculator
Calculate the discounted payback period of an investment: the time it takes for the discounted cash flows to repay the initial investment. Enter the investment, the discount rate and the cash flow of each year.
How it is calculated
Discounted cash flow of year t = cash flow ÷ (1 + r)^t
Each yearly cash flow is discounted to its present value with the discount rate. The discounted cash flows are added up year by year; the payback period is reached when the cumulative total equals the initial investment, with the last year counted as a fraction.
Because it uses the time value of money, the discounted payback period is always longer than the simple payback period.
Example
An investment of 10,000 with cash flows of 4,000 a year and a discount rate of 10% has discounted flows of 3,636, 3,306 and 3,005: after three years 9,947 has been recovered, so the discounted payback period is just over 3 years.
Frequently asked questions
What discount rate should I use?
Usually the cost of capital or the return you could earn on an alternative investment with similar risk.
What is the difference with the simple payback period?
The simple payback period ignores the time value of money; the discounted version gives less weight to cash received later.
What does it not show?
It ignores the cash flows after the payback year, so use it together with NPV or IRR to compare projects.