- Calculating Net Present Value (NPV) and Internal Rate of Return (IRR) in Excel
- Net Present Value of a Project
- The Capital Budgeting Process
- Principles of Capital Budgeting
- Mutually Exclusive Projects, Project Sequencing, and Capital Rationing
- How to Calculate Payback Period
- How to Calculate Discounted Payback Period
- Calculating Profitability Index of a Project
- Conflict Between NPV and IRR
How to Calculate Discounted Payback Period
We learned that one of the drawbacks of payback period is that it does not consider time value of money. An alternative is to use the discounted payback period.
The discounted payback period is the number of years it takes to recover the initial investment in terms of the present value of the cash flows. The present value of each cash flow is calculated and then added to arrive at the discounted payback period.
Let’s take the same example with the cash flows for 5 years. Assuming that the firm has a cost of capital of 10%, the discounted cash flows are presented in the third column. Column 4 shows the cumulative discounted cash flows.
Year | Cash Flow | Discounted Cash Flows | Cumulative Discounted Cash Flows |
0 | -5000.00 | ||
1 | 2000.00 | 1818.18 | 1818.18 |
2 | 2,000.00 | 1652.89 | 3471.07 |
3 | 2,000.00 | 1502.63 | 4973.70 |
4 | 1,000.00 | 683.01 | 5656.72 |
5 | 1,000.00 | 620.92 | 6277.64 |
As you can see, the project generates a total of $4973.70 in 3 years. By the end of four years, the total cash inflow is $5656.72. This means that the discounted payback period is between 3 and 4 years.
The discounted payback period can be calculated as follows:
Discounted Payback Period = 3 + (5000-4973.70)/683.01 = 3.04 years
Note that the discounted payback period is more than the simple payback period. This is because the cash flows have been discounted.
However, this method is still not considered a good measure of profitability because it doesn’t consider the cash flows that occur after the payback period.
Related Downloads
Related Quizzes
Data Science in Finance: 9-Book Bundle
Master R and Python for financial data science with our comprehensive bundle of 9 ebooks.
What's Included:
- Getting Started with R
- R Programming for Data Science
- Data Visualization with R
- Financial Time Series Analysis with R
- Quantitative Trading Strategies with R
- Derivatives with R
- Credit Risk Modelling With R
- Python for Data Science
- Machine Learning in Finance using Python
Each book includes PDFs, explanations, instructions, data files, and R code for all examples.
Get the Bundle for $29 (Regular $57)Free Guides - Getting Started with R and Python
Enter your name and email address below and we will email you the guides for R programming and Python.