Skip to content
Omnikalc

Discounted payback period calculator with simple payback, NPV and profitability index for 5 years of cash flows

Enter the investment, the discount rate and five years of cash flows to get the discounted payback period, the simple payback, the net present value and the profitability index.

Updated on
Your inputs
$

Value out of range

%

Value out of range

$

Value out of range

$

Value out of range

$

Value out of range

$

Value out of range

$

Value out of range

Results

Discounted payback period

3.33 years

Slow recovery: most of the horizon is needed
Simple payback period (no discounting)
2.85 years
Present value of the 5 years of cash flows
$73,510
Net present value after 5 years
$23,510
Profitability index
1.47

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.

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.

Frequently asked questions

What is the discounted payback period?

The discounted payback period is the time needed to recover the initial investment when each future cash flow is first discounted to its present value. It is longer than the simple payback period because a dollar received later is worth less than a dollar today. The method keeps the simplicity of the payback rule and adds the time value of money.

How is it different from the simple payback period?

The simple payback adds the cash flows as they are, so it ignores the cost of capital. The discounted payback divides each cash flow by (1 + r) raised to the year, then adds them. The gap between the two numbers grows with the discount rate and with the length of the project. At a rate of zero, both are equal.

What is a good discounted payback period?

There is no universal value. Companies set a maximum, such as three years for a technology project or ten years for infrastructure, and they accept a project only if the discounted payback is shorter. A project that does not recover its cost within the horizon, shown here as 0, has a negative net present value over this period.

What are the limits of the method?

The method ignores the cash flows that come after the payback date, so it can reject a project with large late profits and accept one that pays back fast and then fails. It also depends on the discount rate chosen. For this reason it is used together with the net present value and the internal rate of return, and not alone.

Was this calculator helpful?

Thanks for your feedback!

Results are estimates provided for information purposes. They do not replace professional advice.