
This has been a guide to the discounted payback period and its meaning. Here we learn how to calculate a discounted period using its formula along with practical examples. Here we also provide you with a discounted payback period calculator with a downloadable excel template.
- The payback period is often used when liquidity is an important criteria to choose a project.
- Let’s say the new machine, by itself, is working wonderfully and operating at peak capacity.
- The payback method of evaluating capital expenditure projects is very popular because it’s easy to calculate and understand.
- First, it ignores the time value of money, which is a critical component of capital budgeting.
Find the premier business analysis Ebooks, templates, and apps at the Master Analyst Shop. When failure is not an option, wise project managers rely on the power of statistical process control to uncover hidden schedule risks, build teamwork, and guarantee on-time delivery. The blue line rising from the lower left to upper right is “cumulative” cash flow, appearing in straight-line segments between year endpoints.
At a saving of £45 and a cost of £139, the payback period is relatively short. Annual percentage rates vary from 23% to about 78%, depending on amount borrowed and payback period. All non-cash expenses are ignore while computing payback period. In the example with the even cash flows,supposed there is provision for depreciation but still depreciation is a non cash expense,how would it be. It can’t be called the best formula for finding out the payback period. You need to provide the two inputs of Cumulative cash flow in a year before recovery and Discounted cash flow in a year after recovery.
Cost
Evaluates how long it will take to recover the initial investment. For companies facing liquidity problems, it provides a good ranking of projects that would return money early. Payback is used measured in terms of years and months, though any period could be used depending on the life of the project (e.g. weeks, months). It is predicted that the machine will generate $120,000 in net cash flow every year. NPV can incidentally be criticized, as large expenditures far in the future are automatically thought fairly unimportant.

Getting repaid or recovering the initial cost of a project or investment should be achieved as quickly as it allows. However, not all projects and investments have the same time horizon, so the shortest possible https://www.bookstime.com/ needs to be nested within the larger context of that time horizon. For example, the payback period on a home improvement project can be decades while the payback period on a construction project may be five years or less. This period does not account for what happens after payback occurs.
New Lesson Resources For Financial Statements, Investment Appraisal And Ratios
Management uses the payback period calculation to decide what investments or projects to pursue. In this case, the analyst must estimate the payback period using interpolation, as the examples and here and in the next section illustrate. The assumption that cash flow is spread evenly through each year accounts for the straight-lines between year-end data points above.
When calculating the payback period, we don’t take time value of money into account. Analysts often assume that the longer it takes to recover funds, the more uncertain is the positive return. For this reason, they sometimes view payback period as a measure of risk, or at least a risk-related criterion to meet before spending funds. A company might decide, for instance, to undertake no significant expenditures that do not pay for themselves in, say, three years. The payback period and the breakeven point are similar, but there are some differences between the two.
A Refresher On Payback Method
Payback period method does not take into account the time value of money. Some businesses modified this method by adding the time value of money to get the discounted payback period. They discount the cash inflows of the project by a chosen discount rate , and then follow usual steps of calculating the payback period. Subtract each individual annual cash inflow from the initial cash outflow, until the payback period has been achieved. This approach works best when cash flows are expected to vary in subsequent years. For example, a large increase in cash flows several years in the future could result in an inaccurate payback period if using the averaging method.
A large purchase like a machine would be a capital expense, the cost of which is allocated for in a company’s accounting over many years. No such adjustment for this is made in the payback period calculation, instead it assumes this is a one-time cost.
- The Cumulative cash flow graph shows the payback period as the horizontal axis point where the payback event occurs.
- The payback period disregards the time value of money and is determined by counting the number of years it takes to recover the funds invested.
- When “cumulative” cash flow is positive in one period, but “negative” again in the next, there can be more than one break-even point in time.
- Perhaps other machines need to be shut down for extended periods in order to allow this new machine to produce.
- Like other cash flow metrics, payback period takes an “investment view” of the cash flow stream that follows an investment or action.
- If one investment has a shorter payback period than the rest, it might be the better option if earning an ROI quickly is important to the company.
- The payback period shouldn’t be used as a measure of investment project profitability.
This difference equals this one, so I can either use this number or I can calculate the difference. Again, because this number has a negative sign, please make sure that you include a negative sign for this number. The first investment has a Payback Period of two years, and the second investment has a payback period of three years. If the company requires a payback period of two years or less, the first investment is preferable. However, the first investment generates only $3,000 in cash after its payback period while the second investment generates $35,000 after its payback period. The payback method ignores both of these amounts even though the second investment generates significant cash inflows after year 3. Again, it would be preferable to calculate the IRR to compare these two investments.
Your Account
It gives the investor a first pass at deciding whether a particular investment is worth examining in greater detail or can provide a relative ranking of alternatives in terms of payback options. It is worth noting that PBP calculation uses cash flows, not the net income.

Payback period, as a tool of analysis, is often used because it is easy to apply and easy to understand for most individuals, regardless of academic training or field of endeavor. When used carefully or to compare similar investments, it can be quite useful. All else being equal, shorter payback periods are preferable to longer payback periods.
The longer it takes for an investment to earn cash inflows, the more likely it is that the investment will not breakeven or make a profit. Since most capital expansions and investments are based on estimates and future projections, there’s no real certainty as to what will happen to the income in the future.
In most cases, this is a pretty good payback period as experts say it can take as much as eight years for residential homeowners in the United States to break even on their investment. The project’s payback occurs the year before the cash flow turns positive. To find the last negative cash flow we use the VLOOKUP function, which takes three arguments as for our usage. Now, we calculate the negative cash flow which is the most recent, in other words the last or latest negative cash flow. James Woodruff has been a management consultant to more than 1,000 small businesses. As a senior management consultant and owner, he used his technical expertise to conduct an analysis of a company’s operational, financial and business management issues. James has been writing business and finance related topics for work.chron, bizfluent.com, smallbusiness.chron.com and e-commerce websites since 2007.
Frequently Asked Questions About Calculating The Payback Period
This is a significant strategic omission, particularly relevant in longer term initiatives. As a result, all corporate financial assessments should discount payback to weigh in the opportunity costs of capital being locked up in the project. Whilst the time value of money can be rectified by applying a weighted average cost of capital discount, it is generally agreed that this tool for investment decisions should not be used in isolation. The payback period is the amount of time it takes to recover an initial investment outlay, as measured in after-tax cash flows. It is an important calculation used in capital budgeting to help evaluate capital investments. For example, if a payback period is stated as 2.5 years, it means it will take 2½ years to receive your entire initial investment back.
The payback period is the expected number of years it will take for a company to recoup the cash it invested in a project. Let us take some more examples to understand the concept better. Another flaw is that payback tells you nothing about the rate of return, which is a problem if your company requires proposed investments to pass a certain hurdle rate. Since the machine will last three years, in this case the payback period is less than the life of the project. What you don’t know is how much of a total return it will give you over those three years. Imagine that your company wants to buy a $3,000 computer that will help one of your employees deliver a service to your customers in less time.
The shorter your payback period, the more quickly you can reinvest your cash into growth, and the faster you’ll grow. Management uses the cash payback period equation to see how quickly they will get the company’s money back from an investment—the quicker the better.

Discounted payback period will usually be greater than regular payback period. Investments with higher cash flows toward the end of their lives will have greater discounting. Forecasted future cash flows are discounted backward in time to determine a present value estimate, which is evaluated to conclude whether an investment is worthwhile. In DCF analysis, the weighted average cost of capital is the discount rate used to compute the present value of future 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.
What Is The Discounted Payback Period?
These values are converted to present values using the present-value equation, with the firm’s discount rate plugged in as the discount factor. Finally, the cumulative total of the benefits and the cumulative total of the costs are compared on a year-by-year basis. At the point in time when the cumulative present value of the benefits starts to exceed the cumulative present value of the costs, the project has reached the payback period. Ranking projects then becomes a matter of selecting those projects with the shortest payback period. Discount rate is sometimes described as an inverse interest rate. It is a rate that is applied to future payments in order to compute the present value or subsequent value of said future payments.
This is a much less straightforward calculation , but it is “far superior,” says Knight, especially if you’re only going to use the payback method. Payback period, which is used most often in capital budgeting, is the period of time required to reach the break-even point of an investment based on cash flow. For instance, a $2,000 investment at the start of the first year that returns $1,500 after the first year and $500 at the end of the second year has a two-year payback period. As a rule of thumb, the shorter the payback period, the better for an investment. Any investments with longer payback periods are generally not as enticing. The term payback period refers to the amount of time it takes to recover the cost of an investment.
The accounting rate of return is a formula that measures the net profit, or return, expected on an investment compared to the initial cost. Obviously, the longer it takes an investment to recoup its original cost, the more risky the investment.
Other “metrics” with an investment view include net present value NPV, internal rate of return IRR and return on investment ROI. Each metric compares expected costs to expected returns in one way or another. The finance team at Case Financial Investment Firm is comparing the payback periods for two potential investments and determine which one is better for the firm.
The payback period, typically stated in years, is the time it takes to generate enough cash receipts from an investment to cover the cash outflow for the investment. Additional complexity arises when the cash flow changes sign several times (i.e., it contains outflows in the midst or at the end of the project lifetime). Then the cumulative positive cash flows are determined for each period. The modified payback period is calculated as the moment in which the cumulative positive cash flow exceeds the total cash outflow. They discount the cash inflows of the project by the cost of capital, and then follow usual steps of calculating the payback period. The payback period is the amount of time required for cash inflows generated by a project to offset its initial cash outflow.
Defining The Payback Method
Current projects last less than one year, and companies typically show these costs as an expense on the income statement, rather than as a capitalized cost on the balance sheet. Suppose a project with initial cash investment of $1,000,000 with a cash flow pattern from 1 to 5 years – 120,000.00, 150,000.00, 300,000.00, 500,000.00 and 500,000.00. Without any further ado, let’s get started with calculating the payback period in Excel. For example, if a payback period is stated as 5 years, it means it will take 5 years for the investment to pay the entire initial investment back. For B2C businesses, a payback period of less than 1 month is GREAT, 6 months is GOOD, and 12 months is OK. And the exceptional cases can pay back their acquisition costs on the first transaction. They represent a long-term investment, with a long-term payback period and an annual income per vehicle that is extremely sensitive to the cost of overheads.