Calculate the discounted payback period of the investment if the discount rate is 11%. Given a choice between two investments having similar returns, the one with shorter payback period should be chosen. Management might also set a target payback period beyond which projects are generally rejected due to high risk and uncertainty. Next, assuming the project starts with a large cash outflow (or investment), the future discounted cash inflows are netted against the initial investment outflow.

We can also employ the COUNTIF and VLOOKUP functions to calculate the discounted payback period. If you want to calculate the payback period for two projects and compare them, you’ll have to choose the project that comes up with the shorter period. But always keep in mind if the projects are independent or mutually exclusive. So, the two parts of the calculation (the cash flow and PV factor) are shown above.We can conclude from this that the DCF is the calculation of the PV factor and the actual cash inflow. The following example illustrates the computation of both simple and discounted payback period as well as explains how the two analysis approaches differ from each other. However, one common criticism of the simple payback period metric is that the time value of money is neglected.

Discounted Payback Period Formula

This approach might look a bit similar to net present value method activity-based costing in healthcare saves millions but is, in fact, just a poor compromise between NPV and simple payback technique. The discounted payback period is a goodalternative to the payback period if the time value of money or the expectedrate of return needs to be considered. If DPP were the only relevant indicator,option 3 would be the project alternative of choice. DefinitionThe discounted payback is defined as the length of time it takes the discounted net cash revenue/cost savings of a project to payback the initial investment. In this case, we are given the profit figure so need to adjust for depreciation of ($40,000/8 years) $5,000 per year, to give an annual cash flow of ($12,500 + $5,000) $17,500.

How to Calculate Discounted Payback Period (Step-by-Step)

It refers to the inability to meet short-term financial obligations due to a lack of available… Amanda Bellucco-Chatham is an editor, writer, and fact-checker with years of experience researching personal finance topics. Specialties include general financial planning, career development, lending, retirement, tax preparation, and credit.

The next step is to subtract the number from 1 to obtain the percent of the year at which the project is paid back. Finally, we proceed to convert the percentage in months (e.g., 25% would be 3 months, etc.) and add the figure to the last year in order to arrive at the final discounted payback period number. Option 1 has a discounted payback period of5.07 years, option 3 of 4.65 years while with option 2, a recovery of theinvestment is not achieved. To calculate payback period with irregular cash flows, you will need to calculate the present value of each cash flow. Once you have this information, you can use the following formula to calculate discounted payback period. Payback also provides more focus on the earlier cash flows arising from a project, as these are both more certain and more important if an organisation has liquidity concerns.

Depending on the time period passed, your initial expenditure can affect your cash revenue. The discounted payback period influences decision-making processes by offering insights into the recovery of initial investment costs. It aids in identifying investments that not only recoup their costs but also generate profits within a reasonable timeframe. Compared to the standard payback period, which solely focuses on the time taken to recoup the initial investment, the discounted payback period accounts for the appropriate discount rate. This adjustment reflects the opportunity cost of tying up capital and ensures a more comprehensive assessment. According to discounted payback method, the initial investment would be recovered in 3.15 years which is slightly more than the management’s maximum desired payback period of 3 years.

Discounted Payback Period: What It Is and How to Calculate It

• The discounted payback period calculation begins with the -$3,000 cash outlay in the starting year (or period).
• So, for example, management can compare the required break-even date to the discounted payback period.
• It is calculated by dividing the initial investment by the annual cash flows generated by the investment.
• Organizations may need additional risk analysis tools to evaluate the overall risk profile of an investment.

Let’s use the first example, but expand it by including the fact that the organisation has a cost of capital of 10%. In this formula, cell D17 is the Discount Rate while cells B6 and C6 are Year 1 and Cash Flow of $9,000 respectively. The Present Value of Cash Flow is negative, so we use a negative sign to make the value positive. Different decision-makers may have varying opinions on the appropriate discount rate, leading to different results. The two calculated values – the Year number and the fractional amount – can be added together to arrive at the estimated payback period. All of the necessary inputs for our payback period calculation are shown below.

The discounted cash flows are then added to calculate the cumulative discounted cash flows. The payback period focuses solely on how long it takes to recover the initial investment. In contrast, the Discounted Payback Period takes into account the time value of money by applying discounts to future cash flows. This approach offers a clearer picture of how profitable an investment truly is. The discounted payback period is a modified version of the payback period that accounts for the time value of money. Both metrics are used to calculate the amount of time that it will take for a project to “break even,” or to get the point where the net cash flows generated cover the initial cost of the project.

Payback period is the time required to recover the cost of initial investment, it the time which the investment reaches its breakeven points. It calculates the number of years we need to generated the initial cost of investment. filing income tax return late Its recovery depends on cash flow only, it not even consider the time value of money. While it improves upon the traditional payback period, the discounted payback period still does not account for cash flows beyond the recovery period.

• The discounted payback period is a measureof how long it takes until the cumulated discounted net cash flows offset theinitial investment in an asset or a project.
• The discounted payback period is a valuable financial metric that addresses the limitations of the traditional payback period by considering the time value of money.
• So if the cash flow arises at the end of the year, payback is three years, and if cash flow arises during the year, the payback is two years and (0.29 x 12) three months (to the nearest month).
• Only the project relevant cash flows should be identified and included in the evaluation.
• Prepare a table to calculate discounted cash flow of each period by multiplying the actual cash flows by present value factor.

Pros and Cons of Discounted Payback Period

However, it’s not as accurate as the discounted cash flow version because it assumes only one, upfront investment, and does not factor in the time value of money. So it’s not as good at helping management to decide whether or not to take on a project. In project management, this measure is often used as a part of a cost-benefit analysis, supplementing other profitability-focused indicators such as internal rate of return or return on investment.

Understanding the discounted payback period can be a game-changer in your financial decision-making. By factoring in the time value of money, you gain a more accurate picture of when an investment will start reaping profits. The discounted payback period aligns with the goal of maximizing shareholder wealth.

The shorter the payback period, the more likely the project will be accepted – all else being equal. The increase in inflation for consumer prices in the United States in April 2025, according to the Bureau of Labor Statistics. The core rate, which is adjusted to remove food and energy pricing, was 2.8%. Investors should consider the diminishing value of money when planning 15 best practices in setting up and sending nonprofit newsletters future investments. Management then looks at a variety of metrics in order to obtain complete information. Comparing various profitability metrics for all projects is important when making a well-informed decision.

The discounted payback period is a valuable financial metric that addresses the limitations of the traditional payback period by considering the time value of money. It aids decision-makers in evaluating investment projects, real estate acquisitions, business expansions, and other financial opportunities. However, it is essential to recognize its complexities and subjectivity when applying it to real-world scenarios. When used appropriately, the discounted payback period can contribute to sound financial decision-making and resource allocation.

The implied payback period should thus be longer under the discounted method. Discounted payback period process is a helpful metric to assess whether or not an investment is worth pursuing. UsefulnessThe time value of money is considered when using discounted payback, but otherwise the points made previously regarding the usefulness of payback hold for discounted payback as well. So if the cash flow arises at the end of the year, payback is three years, and if cash flow arises during the year, the payback is two years and (0.29 x 12) three months (to the nearest month).

Importance Of Shorter Payback Periods

That makes the investment cost-benefit analysis simpler to compare for the company management. It gives greater weight-age to early cash inflows from the project, which improves the project payback period. When evaluating investments, businesses and investors often seek to understand how quickly they can recover their initial costs. While the traditional payback period provides a simple way to measure this, it has a major drawback—it ignores the time value of money.This is where the discounted payback period comes in.

The formula for the simple payback period and discounted variation are virtually identical. For example, where a project with higher return has a longer payback period thus higher risk and an alternate project having low risk but also lower return. In such cases the decision mostly rests on management’s judgment and their risk appetite.