Financial Modeling Tutorials
- Financial Modeling Basics
- Excel Modeling
- Financial Functions in Excel
- Sensitivity Analysis in Excel
- Sensitivity Analysis
- Capital Budgeting Techniques
- 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
- Deferred Annuity Formula
- Internal Rate of Return (IRR)
- IRR Examples (Internal Rate of Return)
- NPV vs XNPV
- NPV vs IRR
- NPV Formula
- NPV Profile
- NPV Examples
- 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
- Mean Examples
- Population Mean Formula
- Weighted Mean Formula
- Harmonic Mean Formula
- Median Formula in Statistics
- Range Formula
- Outlier Formula
- Decile Formula
- Midrange Formula
- Quartile Deviation
- Expected Value Formula
- Exponential Growth Formula
- Margin of Error Formula
- Decrease Percentage Formula
- Percent Error Formula
- Holding Period Return Formula
- Cost Benefit Analysis
- Cost Benefit Analysis Examples
- Cost Volume Profit Analysis
- Opportunity Cost Formula
- Opportunity Cost Examples
- Mortgage APR vs Interest Rate
- Normal Distribution Formula
- Standard Normal Distribution Formula
- Normalization Formula
- Bell Curve
- T Distribution Formula
- Regression Formula
- Regression Analysis Formula
- Multiple Regression Formula
- Correlation Coefficient Formula
- Correlation Formula
- Population Variance Formula
- Covariance Formula
- Coefficient of Variation Formula
- Sample Standard Deviation Formula
- Relative Standard Deviation Formula
- Standard Deviation Formula
- Volatility Formula
- Binomial Distribution Formula
- Quartile Formula
- P Value Formula
- Skewness Formula
- R Squared Formula
- Adjusted R Squared
- Regression vs ANOVA
- Z Test Formula
- F-Test Formula
- Quantitative Research
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.
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.
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
|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.
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.
- Dividend Formula
- Examples of Capital Budgeting Techniques
- 5 Best Examples of Capital Budgeting
- Calculate Time Value of Money Formula
- Calculate the Formula for Cost of Capital
- Preferred Dividend Formula
- Perpetuity Formula
- Retention Ratio Formula
- Risk Premium Formula
- 35+ Courses
- 120+ Hours of Videos
- Full Lifetime Access
- Certificate of Completion
- Basic Microsoft Excel Training
- MS Excel 2010 Training Course: Advanced
- Microsoft Excel Basic Training
- Microsoft Excel 2013 – Advanced
- Microsoft Excel 2016 – Beginners
- Microsoft Excel 2016 – Advanced