As you can see, using this payback period calculator you a percentage as an answer. Multiply this percentage by 365 and you will arrive at the number of days it will take for the project or investment to earn enough cash to pay for itself. Management uses the payback period calculation to decide what investments or projects to pursue. That’s why business owners and managers need to use capital budgeting techniques to determine which projects will deliver the best returns, and yield the most profitable outcome. Unlike the regular payback period, the discounted payback period metric considers this depreciation of your money.

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. Use Excel’s present value formula to calculate the present value of cash flows. The payback period is a measure organizations use to determine the time needed to recover the initial investment in a business project. It is a crucial factor in decision-making, as a shorter payback period signifies a faster return to profitability.

- As the equation above shows, the payback period calculation is a simple one.
- Initially the project involves a cash outflow, arising from the original investment of £500,000 and some project losses in Year 1 of £50,000.
- The management of Health Supplement Inc. wants to reduce its labor cost by installing a new machine in its production process.
- The cash flow balance in year zero is negative as it marks the initial outlay of capital.

Payback period is a financial or capital budgeting method that calculates the number of days required for an investment to produce cash flows equal to the original investment cost. In other words, it’s the amount of time it takes an investment to earn enough money to pay for itself or breakeven. This time-based measurement is particularly important to management for analyzing risk. 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.

In short, a variety of considerations should be discussed when purchasing an asset, and especially when the investment is a substantial one. Alaskan Lumber is considering the purchase of a band saw that costs $50,000 and which will generate $10,000 per year of net cash flow. Alaskan is also considering the purchase of a conveyor system for $36,000, which will reduce sawmill transport costs by $12,000 per year. When calculating break-even in business, businesses use several types of payback periods.

## Comparing Different Investment Options Using Payback Period Analysis

Company C is planning to undertake a project requiring initial investment of $105 million. The project is expected to generate $25 million per year in net cash flows for 7 years. The payback period is calculated by dividing the initial capital outlay of an investment by the annual cash flow. Given its nature, the payback period is often used as an initial analysis that can be understood without much technical knowledge. It is easy to calculate and is often referred to as the “back of the envelope” calculation.

## Advantages and disadvantages of payback period

Look at past data, market research, or expert forecasts to estimate these figures accurately. Another frequently used method is IRR, or internal rate of return, which emphasizes the rate of return from a particular project each year. Last, a payback rule called the payback period calculates the time required to recover the investment cost.

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. A higher payback period means it will take longer for a company to cover its initial investment. All else being equal, it’s usually better for a company to have a lower payback period as this typically represents a less https://simple-accounting.org/ risky investment. The quicker a company can recoup its initial investment, the less exposure the company has to a potential loss on the endeavor. 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. For example, if it takes five years to recover the cost of an investment, the payback period is five years.

As a general rule of thumb, the shorter the payback period, the more attractive the investment, and the better off the company would be. Since IRR does not take risk into account, it should be looked at in conjunction with the payback period to determine how to depreciate assets using the straight which project is most attractive. As an alternative to looking at how quickly an investment is paid back, and given the drawback outline above, it may be better for firms to look at the internal rate of return (IRR) when comparing projects.

Others like to use it as an additional point of reference in a capital budgeting decision framework. The formula for the simple payback period and discounted variation are virtually identical. Before you invest thousands in any asset, be sure you calculate your payback period.

## Example of Payback Period

Oftentimes, cash flow is conveyed as a net of the sum total of both positive and negative cash flows during a period, as is done for the calculator. The study of cash flow provides a general indication of solvency; generally, having adequate cash reserves is a positive sign of financial health for an individual or organization. The payback period is favored when a company is under liquidity constraints because it can show how long it should take to recover the money laid out for the project. If short-term cash flows are a concern, a short payback period may be more attractive than a longer-term investment that has a higher NPV. Getting repaid or recovering the initial cost of a project or investment should be achieved as quickly as it allows.

## What is the payback period formula?

Yes, you can use Excel to calculate the payback period by setting up a simple formula or using financial functions. This method helps businesses analyze different projects quickly before making financial decisions about them. In Excel, you divide the total invested money by the yearly cash flow to get the payback period. The table indicates that the real payback period is located somewhere between Year 4 and Year 5.

Referring to our example, cash flows continue beyond period 3, but they are not relevant in accordance with the decision rule in the payback method. Payback period is the amount of time it takes to break even on an investment. The appropriate timeframe for an investment will vary depending on the type of project or investment and the expectations of those undertaking it. Investors may use payback in conjunction with return on investment (ROI) to determine whether or not to invest or enter a trade. Corporations and business managers also use the payback period to evaluate the relative favorability of potential projects in conjunction with tools like IRR or NPV. Although calculating the payback period is useful in financial and capital budgeting, this metric has applications in other industries.

This is an especially good rule to follow when you must choose between one or more projects or investments. The reason for this is because the longer cash is tied up, the less chance there is for you to invest elsewhere, and grow as a business. 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.

Did you know that although simple, the payback period is an essential tool used by finance professionals worldwide? It might not factor in every financial variable but provides a clear metric for recovery time on investments. According to payback method, machine Y is more desirable than machine X because it has a shorter payback period than machine X.

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts. CFI is the global institution behind the financial modeling and valuation analyst FMVA® Designation. 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. Yarilet Perez is an experienced multimedia journalist and fact-checker with a Master of Science in Journalism.