To calculate discounted payback period, you need to discount all of the cash flows back to their present value. The present value is the value of a future payment or series of payments, discounted back to the present. The payback period value is a popular metric because it’s easy to calculate and understand.

How do I calculate the discounted payback period?

This means that you would need to earn a return of at least 9.1% on your investment to break even. This means that you would need to earn a return of at least 19.6% on your investment to break even. Another advantage of this method is that it’s easy to calculate and understand.

How to Calculate Discounted Payback Period in Excel

However, it doesn’t take into account money’s time value, which is the idea that a dollar today is worth more than a dollar in the future. The screenshot below shows that the time required to recover the initial $20 million cash outlay is estimated to be ~5.4 years under the discounted payback period method. In particular, the added step of discounting a project’s cash flows is critical for projects with prolonged payback periods (i.e., 10+ years).

By considering the time value of money, this metric accounts for the opportunity cost of capital and adjusts for risk. As a result, it offers a more realistic perspective on the investment’s potential returns. The time value of money is an essential idea in finance, which means that having a dollar now is more valuable than receiving a dollar later because of its potential to earn.

Decision-Making Implications

We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems. In the next step, we’ll create a table with the period numbers (”Year”) listed on the y-axis, whereas the x-axis consists of three columns. Suppose a company is considering whether to approve or reject a proposed project.

Create a free account to unlock this Template

• HBS Online’s CORe and CLIMB programs require the completion of a brief application.
• The discounted payback period calculation begins with the -$3,000 cash outlay in the starting period.
• Once we’ve calculated the discounted cash flows for each period of the project, we can subtract them from the initial cost figure until we arrive at zero.
• Forecast cash flows that are likely to occur within every year of the project.
• The discounted payback period is a projection of the time it will take to receive a full recovery on an investment that has an accompanying discount rate.
• This means that you would only invest in this project if you could get a return of 20% or more.

If you’re discounting at a rate of 10%, your payback period would be 5 years. Discounted payback period refers to the number of years it takes for the present value of cash inflows to equal the initial investment. Essentially, you can determine how long you’re going to need until your original investment amount is equal to other cash flows.

This adjustment reflects the opportunity cost of tying up capital and ensures a more comprehensive assessment. Add all the discounted cash flows cumulatively until the total equals or exceeds the initial investment. The project has an initial investment of $1,000 and will generate annual cash flows of $100 for the next 10 years. The main advantage is that the metric takes into account money’s time value. This is important because money today is worth more than money in the future. The discount rate represents the opportunity cost of investing your money.

• Explore Strategic Financial Analysis—one of our online finance and accounting courses—to leverage financial insights to drive strategic decision-making.
• The payback period value is a popular metric because it’s easy to calculate and understand.
• Thprojectent value adjustment maximizes the decision-making process and accurately depicts the project’s profitability.
• By factoring in the time value of money, you gain a more accurate picture of when an investment will start reaping profits.
• Please refer to the Payment & Financial Aid page for further information.

Next, we divide the number by the year-end cash flow in order to get the percentage of the time period left over after the project has been paid back. From a capital budgeting perspective, this method is a much better method than a simple payback period. After the initial purchase period (Year 0), the project generates $5 million in cash flows each year. The discounted payback period, in theory, is the more accurate measure, since fundamentally, a dollar today is worth more than a dollar received in the future. Therefore, it would be more practical to consider the time value of money when deciding which projects to approve (or reject) – which is where the discounted payback period variation comes in.

How do you calculate the discounted payback period?

Uneven Cash Flow refers to a series of unequal payments made over a certain period, for instance a series of $5000, $8500, and $10000 made over 3 years. Since the project’s life is calculated at 5 years, we can infer that the project returns a positive NPV. To make the best decision about whether to pursue a project or not, a company’s management needs to the rules for deducting business expenses on federal taxes decide which metrics to prioritize. You can deepen your understanding of DCF and other valuation methods, including the discounted dividend model (DDM), by taking an online finance course like Strategic Financial Analysis.

Sales & Investments Calculators

This makes it a good choice for decision-makers who don’t have a lot of experience with financial analysis. This means that you would only invest in this project if you could get a return of 20% or more. You need to provide the two inputs of Cumulative cash flow in reorder points a year before recovery and Discounted cash flow in a year after recovery. I hope you guys got a reasonable understanding of what is payback period and discounted payback period.

How to Calculate Discounted Cash Flow

The above steps ensure that cash flows are treated relatively during discounting time. The next step how to set up an etsy shop 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.

The payback period and discounted payback period are two different methods used to analyze when an investment is to be recovered. The main difference is that the discounted payback period considers the time value of money, making it a more realistic approach. Choose a discount rate, which may usually be either the cost of capital of the concerned company or the rate of return required.