For example, if a project indicates that the funds or initial investment will never be recovered by the discounted value of related cash inflows, the project would not be profitable at all. The company should therefore refrain from investing its funds in such project. The time value of money is the concept that a dollar today is worth more than a dollar in the future, because money can earn interest or returns if invested. At the end of Year 4, the cumulative discounted cash flows exceed the initial investment.
- This makes it a good choice for decision-makers who don’t have a lot of experience with financial analysis.
- Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.
- In Excel, create a cell for the discounted rate and columns for the year, cash flows, the present value of the cash flows, and the cumulative cash flow balance.
From above example, we can observe that the outcome with discounted payback method is less favorable than with simple payback method. Since discounting decreases the value of cash flows, the discounted payback period will always be longer than the simple payback period as long as the cash flows and discount rate are positive. Remember, the discounted payback period provides the time in which the initial investment will be recovered in terms of discounted or present value cash flows.
Discounted Payback Period vs. Payback Period
For instance, let’s say you own a retail company and are considering a proposed growth strategy that involves opening up new store locations in the hopes of benefiting from the expanded geographic reach. Julia Kagan is a financial/consumer journalist and former senior editor, personal finance, of Investopedia. Suppose a company is considering whether to approve or reject a proposed project. 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.
Advantages of Discounted Payback Period
The formula for the simple payback period and discounted variation are virtually identical. 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. The Discounted Payback Period estimates the time needed for a project to generate enough cash flows to break even and become profitable.
This makes it a good choice for decision-makers who don’t have a lot of experience with financial analysis. 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. I will briefly explain how the payback period functions to help you better understand the concept. 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.
Discounted payback period refers to time needed to recoup your original investment. In other words, it’s the amount of time it would take for your cumulative cash flows to equal your initial investment. To calculate the cumulative cash flow balance, add the present value of cash flows to the previous year’s balance. The cash flow balance in year zero is negative as it marks the initial outlay of capital. Therefore, the cumulative cash flow balance in year 1 equals the negative balance from year 0 plus the present value of cash flows from year 1. The discounted payback period is calculated by adding the year to the absolute value of the period’s cumulative cash flow balance and dividing it by the following year’s present value of cash flows.
We see that in year 3, the investment is not just recovered but the remaining cash inflow is surplus. The project is acceptable according to simple payback period method because the recovery period under this method (2.5 years) is less than the maximum desired payback period of the management (3 years). Most capital budgeting formulas, such as net present value (NPV), internal rate of return (IRR), and discounted cash flow, consider the TVM. So if you pay an investor tomorrow, it must include an opportunity cost. The payback period is the time it takes an investment to break even (generate enough cash flows to cover the initial cost).
The easiest method to audit and understand is to have all the data in one table and then break out the calculations line by line. Financial modeling best practices require calculations to be transparent and easily auditable. The trouble with piling all of the calculations into a formula is that you can’t easily see what numbers go where or what numbers are user inputs or hard-coded. Prior to accepting a position as the Director of Operations Strategy at DJO Global, Manu was a management consultant with McKinsey & Company in Houston. He served clients, including presenting directly to C-level executives, in digital, strategy, M&A, and operations projects. The sooner the break-even point is met, the more likely additional profits are to follow (or at the very least, the risk of losing capital on the project is significantly reduced).
Calculating the Payback Period With Excel
Its recovery depends on cash flow only, it not even consider the time value of money. This method completely ignores accrual basic and the time value of money. In its simplest form, the formula to calculate the payback period involves dividing the cost of the initial investment by the annual cash flow. Payback period doesn’t take into account money’s time value or cash flows beyond payback period. Essentially, you can determine how long you’re going to need until your original investment amount is equal to other cash flows.
WACC is the calculation of a firm’s cost of capital, where each category of capital, such as equity or bonds, is proportionately weighted. For more detailed cash flow analysis, WACC is usually used in place of discount rate because it is a more accurate measurement of the financial opportunity cost of investments. WACC can be used in place of discount rate for either of the calculations. The discounted payback period is the number of years it takes to pay back the initial investment after discounting cash flows. In Excel, create a cell for the discounted rate and columns for the year, cash flows, the present value of the cash flows, and the cumulative cash flow balance. Input the known values (year, cash flows, and discount rate) in their respective cells.
In other words, the investment will not be recovered
within the time horizon of this projection. The payback period is the amount of time for a project to break even in cash collections using nominal dollars. The calculation of the arpa advanced research projects agency can be more complex than the standard payback period because it involves discounting the future cash flows of the investment. The discounted payback period is a capital budgeting procedure which is frequently used to determine the profitability of a project. It is an extension of the payback period method of capital budgeting, which does not account for the time value of money.
Example of Discounted Payback Period
For example, it first arbitrarily chooses a cutoff period and then ignores all cash flows that occur after that period. This approach might look a bit similar to net present value https://intuit-payroll.org/ method but is, in fact, just a poor compromise between NPV and simple payback technique. The discounted payback method takes into account the present value of cash flows.
Inflows are any items that go into the investment, such as deposits, dividends, or earnings. Cash outflows include any fees or charges that are subtracted from the balance. Although calculating the payback period is useful in financial and capital budgeting, this metric has applications in other industries.
The discounted payback period is often used to better account for some of the shortcomings, such as using the present value of future cash flows. For this reason, the simple payback period may be favorable, while the discounted payback period might indicate an unfavorable investment. The time it takes for the present value of future cash flows to equal the initial cost of a project indicates when the project or investment will break even.
When deciding on any project to embark on, a company or investor wants to know when their investment will pay off, meaning when the cash flows generated from the project will cover the cost of the project. But there are a few important disadvantages that disqualify the payback period from being a primary factor in making investment decisions. First, it ignores the time value of money, which is a critical component of capital budgeting. For example, three projects can have the same payback period; however, they could have varying flows of cash. The discounted payback method may seem like an attractive approach at first glance. On closer inspection, however, we find that it shares some of the same significant flaws as the simple payback method.
It involves the cash flows when they occurred and the rate of return in the market. Assume that Company A has a project requiring an initial cash outlay of $3,000. The project is expected to return $1,000 each period for the next five periods, and the appropriate discount rate is 4%. The discounted payback period calculation begins with the -$3,000 cash outlay in the starting period.
Discounted payback period calculation is a simple way to analyze an investment. One limitation is that it doesn’t take into account money’s time value. This means that it doesn’t consider that money today is worth more than money in the future. As the equation above shows, the payback period calculation is a simple one.

