Financial Modeling Tutorials
 Financial Modeling Basics
 Excel Modeling
 Financial Functions in Excel
 Sensitivity Analysis in Excel
 Time Value of Money
 Future Value Formula
 Present Value Factor
 Perpetuity Formula
 Present Value vs Future Value
 Annuity vs Pension
 Present Value of an Annuity
 Doubling Time Formula
 Annuity Formula
 Annuity vs Perpetuity
 Annuity vs Lump Sum
 Internal Rate of Return (IRR)
 NPV vs XNPV
 NPV vs IRR
 NPV Formula
 PV vs NPV
 IRR vs ROI
 Break Even Point
 Payback Period & Discounted Payback Period
 Payback period Formula
 Discounted Payback Period Formula
 Profitability Index
 Cash Burn Rate
 Simple Interest
 Simple Interest vs Compound Interest
 Simple Interest Formula
 CAGR Formula (Compounded Annual Growth Rate)
 Effective Interest Rate
 Loan Amortization Schedule
 Mortgage Formula
 Loan Principal Amount
 Interest Rate Formula
 Rate of Return Formula
 Effective Annual Rate
 Effective Annual Rate Formula (EAR)
 Daily Compound Interest
 Monthly Compound Interest Formula
 Discount Rate vs Interest Rate
 Rule of 72
 Geometric Mean Return
 Real Rate of Return Formula
 Continuous compounding Formula
 Weighted average Formula
 Average Formula
 Average Rate of Return Formula
 Mean Formula
 Weighted Mean Formula
 Harmonic Mean Formula
 Median Formula in Statistics
 Range Formula
 Expected Value Formula
 Exponential Growth Formula
 Margin of Error Formula
 Decrease Percentage Formula
 Percent Error Formula
 Holding Period Return Formula
 Cost Benefit Analysis
 Cost Volume Profit Analysis
 Opportunity Cost Formula
 Mortgage APR vs Interest Rate
 Regression Formula
 Correlation Coefficient Formula
 Covariance Formula
 Coefficient of Variation Formula
 Sample Standard Deviation Formula
 Relative Standard Deviation Formula
 Volatility Formula
 Binomial Distribution Formula
 Quartile Formula
 P Value Formula
 Skewness Formula
 Regression vs ANOVA
Discounted Payback Period Formula – Flow of the article
Discounted Payback Period Formula
Discounted payback period Formula is a better option for calculating how much time a project would get back its initial investment; because in simple payback period, there’s no consideration for the time value of money.
Let’s have a look at the formula of discounted payback period –
Here one thing you need to remember – discounted payback period occurs when the negative cash flow turns into the positive cash flow.
Explanation of Discounted Payback Period Formula
From a capital budgeting perspective, discounted payback period formula is much better method than simple payback period.
In discounted payback period formula, there are two parts.
 The first part is “a year before the discounted payback period occurs”. This is important because by taking the prior year we can get the integer.
 The next part is the division between cumulative cash flow in year before recovery and discounted cash flow in year after recovery. The purpose of this part is find out the proportion of how much is yet to be recovered.
Recommended Courses
Use of Discounted Payback Period Formula
 Discounted payback period formula can’t be called the best formula for finding out the payback period.
 But from the perspective of capital budgeting and accuracy, this method is far superior to simple payback period; because in simple payback period there is no consideration for time value of money and cost of capital.
 Many managers have been shifting their focus from simple payback period to discounted payback period to find more accurate estimation of tenure for recouping the initial investments of their firms.
 Even if this method is very complex than simple payback period; but by using the right steps you can find out the discounted payback period.
Example of Discounted Payback Period Formula
Let’s take an example and solve the example step by step.
Funny Inc. would like to invest $150,000 into a project as initial investment. The firm expects to generate $70,000 in the first year, $60,000 in the second year, and $60,000 in the third year. The weighted average cost of capital is 10%. Find out the discounted payback period of Funny Inc.
4.9 (927 ratings)
We will go step by step in calculating the discounted payback period of Funny Inc.
First, we will find out the present value of the cash flow.
Let’s look at the calculations.
Please note the formula of present value – PV = FV / (1+i) ^n
 Year 0: – $150,000 / (1+0.10) ^0 = $150,000
 Year 1: $70,000 / (1+0.10) ^1 = $63,636.36
 Year 2: $60,000 / (1+0.10) ^2 = $49,586.78
 Year 3: $60,000 / (1+0.10) ^3 = $45,078.89
Now, we will calculate the cumulative discounted cash flows –
 Year 0: – $150,000
 Year 1: – 86,363.64
 Year 2: – 36,776.86
 Year 3: $8,302.03
Now, we will use the formula of discounted payback period to find out the DPP.
Discounted Payback Period formula = Year before the discounted payback period occurs + (Cumulative cash flow in year before recovery / Discounted cash flow in year after recovery)
Or, Discounted Payback Period = 2 + ($36.776.86 / $45,078.89) = 2 + 0.82 = 2.82 years.
Discounted Payback Period Calculator
You can use the following Discounted Payback Period Calculator
Year before the discounted payback period occurs  
Cumulative cash flow in year before recovery  
Discounted cash flow in year after recovery  
Discounted Payback Period Formula =  
Discounted Payback Period Formula =  Year before the discounted payback period occurs + 



Discounted Payback Period in Excel (with excel template)
Let us now do the same example above in Excel.
This is very simple. You need to provide the two inputs of Cumulative cash flow in a year before recovery and Discounted cash flow in a year after recovery. You can easily calculate the discounted payback period in the template provided.
Recommended Articles
This has been a guide to discounted payback period formula, its uses along with practical examples. Here we also provide you with discounted payback period calculator with downloadable excel template.
Leave a Reply