Suppose a company is considering whether to approve or reject a proposed project.
Table of content:
Since the total present value ($1,248.68) exceeds the cost of the tree ($200), the investment is worthwhile. As you go through the formula, you’ll notice the denominator you’re raising increases exponentially due to the compounding effects of the discount rates year over year. The articles and research support materials available on this site are educational and are not intended to be investment or tax advice. All such information is provided solely for convenience purposes only and all users thereof should be guided accordingly.
This rapid recovery indicates higher liquidity and reduced risk exposure for the investor, making it an attractive metric for decision-making in capital budgeting. Discounted payback method is a capital budgeting technique used to evaluate the profitability of a project based upon the inflows and outflows of cash. Since this method takes into account the time value of money, it can be considered as an upgraded variant of the simple payback method. The discount rate, often the weighted average cost of capital (WACC) or a required rate of return, is used to calculate the present value of future cash flows. This rate reflects the opportunity cost of investing in a particular project versus alternative investments. The discounted payback period method provides a useful investment appraisal method.
Discounted Payback Period Formula
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. The calculator below helps you calculate the discounted payback period based on the payroll fraud amount you initially invest, the discount rate, and the number of years. A project may have a longer discounted payback period but also a higher NPV than another if it creates much more cash inflows after its discounted payback period. According to the discounted payback rule, an investment is considered worthwhile if its payback period, adjusted for the time value of money, is shorter than or equal to a set benchmark.
The shorter the discounted payback period, the quicker the project generates cash inflows and breaks even. While comparing two mutually exclusive projects, the one with the shorter discounted payback period should be accepted. The basic method of the discounted payback period is taking the future estimated cash flows of a project and discounting them to the present value.
General Terms for Discounted Payback Period Calculation
All of the necessary inputs for our payback period calculation are shown below. The implied payback period should thus be longer under the discounted method. The inflation rate for consumer prices in the United States, rental property bookkeeping tips for landlords according to the Bureau of Labor Statistics in June 2024.
If the discounted payback period of a project is longer than its useful life, the company should reject the project. The initial outflow of cash flows is worth more right now, given the opportunity cost of capital, and the cash flows generated in the future are worth less the further out they extend. When comparing both methods, a discounted payback period guides investors towards projects that generate higher returns adjusted for the time value of money.
- If it is not financially viable enough to repay the initial investment within the time frame, then it is likely not a good investment.
- We also allow you to split your payment across 2 separate credit card transactions or send a payment link email to another person on your behalf.
- It evaluates an investment option for a project with the following relevant cash flow details.
- The period of time that a project or investment takes for the present value of future cash flows to equal the initial cost provides an indication of when the project or investment will break even.
- In other words, it’s the amount of time it would take for your cumulative cash flows to equal your initial investment.
Method 3 – Using VLOOKUP and COUNTIF Functions
- The shorter the payback period, the more likely the project will be accepted – all else being equal.
- Calculate the discounted payback period of this project if Mr Smith is using a discount rate of 10%.
- The cash flows are discounted at the company cost of capital or the weighted average cost of capital precisely.
- Only the project relevant cash flows should be identified and included in the evaluation.
- The discounted payback period takes this principle into account by applying a discount rate to future cash flows.
- All participants must be at least 18 years of age, proficient in English, and committed to learning and engaging with fellow participants throughout the program.
The cash flows are discounted at the company cost of capital or the weighted average cost of capital precisely. Only the project relevant cash flows should be identified and included in the evaluation. When businesses evaluate and appraise projects or investments, they consider two-factor evaluations. The rate of return on the investment and the time it will take to recover the project costs. Cash flows help improve the liquidity of a business, hence often play a critical role in final investment appraisals.
Advantages and disadvantages of discounted payback method
Thus, you should compare your year-end cash flow after making an investment. If undertaken, the initial investment in the project will cost the company approximately $20 million. In fact, the only difference is that the cash flows are discounted in the latter, as is implied by the name.
The discounted cash flows are then added to calculate the cumulative discounted cash flows. You can see by the examples above the benefit that knowing the discounted payback period would have on evaluating the potential of a new project or investment. A business would accept projects if the discounted cash flows pay for the initial investment in a set amount of time.
Is the payback period affected by discount rate?
If they invest, they would not be making their money back until 0.37 years after their deadline. As a result, the startup would not be a financially sound investment for the company. Discounted payback period serves as a way to tell whether an investment is worth undertaking. The lower the payback period, the more quickly an investment will pay for itself.
If you are new to HBS Online, you will be required to set up an account before starting an application for the program of your choice. This metric guides organizations in selecting projects that align with their financial objectives and long-term strategies. In this case, the startup would be able to make the money back in 5.37 years.
Discounted Payback Period Calculation in Excel
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. Initially an investment of $100,000 can be expected to make an income of $35k per annum for 4 years.If the discount rate is 10% then we can calculate the DPP. 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 retained earnings in accounting and what they can tell you calculation of the PV factor and the actual cash inflow.
At the end of the day, it doesn’t matter how “promising” the start-up or project is. If it is not financially viable enough to repay the initial investment within the time frame, then it is likely not a good investment. A regular payback period is an estimate of the length of time that it will take for an investment to generate enough cash flow to pay back the full amount of the cash invested. This is assuming that the investment would make regular payments to repay the money. We will calculate the present value (PV) for each year and determine the cumulative discounted cash flow. When using this metric, it’s important to keep in mind that a longer payback period doesn’t necessarily mean an investment is bad.