The discounted payback period tells how long it takes to recover an investment when the future cash flows are discounted. The discounted payback period calculator discounts five years of cash flows, gives the payback in years, the simple payback for comparison, the net present value and the profitability index.
How the calculation works
- Enter the initial investment and the discount rate, which is your cost of capital or the return you could get elsewhere.
- Enter the expected cash flow of each of the 5 years. A year with no cash flow is entered as 0.
- The calculator discounts each cash flow with the factor 1 / (1 + r)^t and adds them year after year.
- The discounted payback period is the time at which the running total of the discounted cash flows reaches the investment. The calculator also shows the simple payback, the net present value and the profitability index.
Example
A project costs $50,000 and returns $15,000, $18,000, $20,000, $20,000 and $20,000 in the next five years. At 8 %, the discounted cash flows are $13,889, $15,432, $15,877, $14,701 and $13,612. After three years the total is $45,198, and the missing $4,802 is recovered in the fourth year, so the discounted payback is 3 + 4,802 / 14,701 = 3.33 years. The simple payback is 2.85 years, the net present value is $23,510 and the profitability index is 1.47.
Why it matters
The calculator helps business owners, managers, analysts and finance students to judge a purchase of equipment, a new store, a software project or a rental property. It shows how much the time value of money delays the recovery of the investment, and gives the NPV in the same screen.
Good to know
The calculator uses five annual cash flows received at the end of each year, and a constant discount rate. The cash flows after year five are not counted, and the payback is shown as 0 if the investment is not recovered by then. Use the figures after tax, and test several rates. The payback is a measure of liquidity and risk and not of profitability.
Related tools
The payback period calculator gives the simple version, the net present value calculator values the whole project, the profitability index calculator ranks projects per dollar invested, and the MIRR calculator corrects the reinvestment assumption of the IRR.