Home Uncategorized Payback Period Formula + Calculator

Payback Period Formula + Calculator

written by Barry and Joyce Vissell August 9, 2023

Cumulative net cash flow is the sum of inflows to date, minus the initial outflow. But since the payback period metric rarely comes out to be a precise, whole number, the more practical formula is as follows. So it would take two years before opening the new store locations has reached its break-even point and the initial investment has been recovered. Thus, the project is deemed illiquid and the probability of there being comparatively more profitable projects with quicker recoveries of the initial outflow is far greater. A longer payback time, on the other hand, suggests that the invested capital is going to be tied up for a long period. CFI is the global institution behind the financial modeling and valuation analyst FMVA® Designation.

  1. This target may be different for different projects because higher risk corresponds with higher return thus longer payback period being acceptable for profitable projects.
  2. The method is extremely simple to understand, as it only requires one straightforward calculation.
  3. Inflows are any items that go into the investment, such as deposits, dividends, or earnings.
  4. This approach works best when cash flows are expected to vary in subsequent years.
  5. According to payback period analysis, the purchase of machine X is desirable because its payback period is 2.5 years which is shorter than the maximum payback period of the company.

Payback period is popular due to its ease of use despite the recognized limitations described below. The NPV and IRR methods compare the profitability of each investment by considering the time value of money for all cash flows related to the investment. No because the first investment generates far more cash in year 1 than the second investment. In fact, it would be preferable to calculate the IRR to compare these two investments.

Drawback 2: Risk 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. A third drawback of this method is that cash flows after the payback period are ignored. However, Projects B and C end after year 5, while Project D has a large cash flow that occurs in year 6, which is excluded from the analysis. The payback method is shortsighted in that it favors projects that generate cash flows quickly while possibly rejecting projects that create much larger cash flows after the arbitrary payback time criterion.

Unlike net present value , profitability index and internal rate of return method, payback method does not take into account the time value of money. A modified variant of this method is the discounted payback method which considers the time value of money. Under payback method, an investment project is accepted or rejected on the basis of payback period. Payback period means the period of time that a project requires to recover the money invested in it.

Payback Period Explained, With the Formula and How to Calculate It

The term is also widely used in other types of investment areas, often with respect to energy efficiency technologies, maintenance, upgrades, or other changes. For example, a compact fluorescent light bulb may be described as having a payback period of a certain number of years or operating hours, assuming certain costs. Here, the return to the investment consists of reduced operating costs. Note that in both cases, the calculation is based on cash flows, not accounting net income (which is subject to non-cash adjustments).

CFI is on a mission to enable anyone to be a great financial analyst and have a great career path. In order to help you advance your career, CFI has compiled many resources to assist you along the path. 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. Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts. In closing, as shown in the completed output sheet, the break-even point occurs between Year 4 and Year 5.

Create a free account to unlock this Template

The payback method should not be used as the sole criterion for approval of a capital investment. In short, a variety of considerations should be discussed when purchasing an asset, and especially when the investment is a substantial one. 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.

There are a variety of ways to calculate a return on investment (ROI) — net present value, internal rate of return, breakeven — but the simplest is payback period. Getting repaid or recovering the initial cost of a project or investment should be achieved as quickly as it allows. However, not all projects https://www.wave-accounting.net/ and investments have the same time horizon, so the shortest possible payback period 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.

Return on Investment (ROI) is the annual return you receive on investment, and it measures the efficiency of the investment, compared to its cost. A payback period, on the other hand, is the time it takes to recover the cost of an investment. Considering that the payback period is simple and takes a few seconds to calculate, it can be suitable for projects of small investments. The method is also beneficial if you want to measure the cash liquidity of a project, and need to know how quickly you can get your hands on your cash.

The breakeven point is the level at which the costs of production equal the revenue for a product or service. If opening the new stores amounts to an initial investment of $400,000 and the expected cash flows from the stores would be $200,000 each year, then the period would be 2 years. In order to purchase the embroidery machine, Sam’s Sporting Goods must spend $16,000. During the first year, Sam’s expects to see a $2,000 benefit from purchasing the machine, but this means that after one year, the company will have spent $14,000 more than it has made from the project. During the second year that it uses the machine, Sam’s expects that its cash inflow will be $4,000 greater than it would have been if it had not had the machine.

Calculating Payback Using the Averaging Method

The payback method10 evaluates how long it will take to “pay back” or recover the initial investment. The payback period11, typically stated in years, is the time it takes to generate enough cash receipts from an investment to cover the cash outflows for the investment. A second disadvantage of using the payback period method is that there is not a clearly defined acceptance or rejection criterion. When the payback period method is used, a company will set a length of time in which a project must recover the initial investment for the project to be accepted. Projects with longer payback periods than the length of time the company has chosen will be rejected.

Is the Payback Period the Same Thing As the Break-Even Point?

In this case, the payback method does not provide a strong indication as to which project to choose. Thus, the averaging method reveals a payback of 2.5 years, while the subtraction method shows a payback of 4.0 years. Managers who are concerned about cash flow want to know how long it will take to recover the initial investment.

The payback period calculation focuses on how long it will take for a company to make enough free cash flow from the investment to recover the initial cost of the investment. 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 total cash flows over the five-year period are projected to be $2,000,000, which is an average of $400,000 per year. When divided into the $1,500,000 original investment, this results in a payback period of 3.75 years. However, the briefest perusal of the projected cash flows reveals that the flows are heavily weighted toward the far end of the time period, so the results of this calculation cannot be correct.

Use Excel’s present value formula to calculate the present value of cash flows. Using the subtraction method, subtract each individual annual cash inflow from segmentation 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.

Related Articles

Log In

Lost Password


The first step to becoming a member of the RD&T Community and the beginning of your personal Journey to Ultimate Success:

Join Now

Click the button below to register for a free membership and have access to unlimited articles.