We’ll now move to a modeling exercise, which you can access by filling out the form below.
For the past 52 years, Harold Averkamp (CPA, MBA) has worked as an accounting supervisor, manager, consultant, university instructor, and innovator in teaching accounting online. As you can see in the example below, a DCF model is used to graph the payback period (middle graph below). The Ascent is a Motley Fool service that rates and reviews essential products for your everyday money matters.
What is the payback period formula?
Also, the payback calculation does not address a project’s total profitability over its entire life, nor are the cash flows discounted for the time value of money. Are you still undecided about investing in new machinery for your manufacturing business? Perhaps you’re torn between two investments and want to know which one can be recouped faster?
How the payback period calculation can help your business
Over the next five years, the firm receives positive cash flows that diminish over time. As seen from the graph below, the initial investment is fully offset by positive cash flows somewhere between periods 2 and 3. People and corporations mainly invest their money to get paid back, which is why the payback period is so important. In essence, the shorter the payback an investment has, the more attractive it becomes. Determining the payback period is useful for anyone and can be done by dividing the initial investment by the average cash flows. The simple payback period formula is calculated by dividing the cost of the project or investment by its annual cash inflows.
Each company will internally have its own set of standards for the timing criteria related to accepting (or declining) a project, but the industry that the company operates within also plays a critical role. 2020 review of xero 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. Julia Kagan is a financial/consumer journalist and former senior editor, personal finance, of Investopedia. For the past 52 years, Harold Averkamp (CPA, MBA) hasworked as an accounting supervisor, manager, consultant, university instructor, and innovator in teaching accounting online.
But since the payback period metric rarely comes out to be a precise, whole number, the more practical formula is as follows. 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. 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. 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.
For instance, if an asset is purchased mid-year, during the first year, your cash flow would be half of what it would be in subsequent years. Conceptually, the payback period is the amount of time between the date of the initial investment (i.e., project cost) and the date when the break-even point has been reached. Without considering the time value of money, it is difficult or impossible to determine which project is worth considering.
Calculating your payback period can be helpful in the decision-making process. It may be the deciding factor in whether you should go ahead with the purchase of that big-ticket asset, or hold off until your cash flow is better. Small businesses in particular can benefit from payback analysis simply by calculating the payback period of any investment they’re considering. The Payback Period measures the amount of time required to recoup the cost of an initial investment via the cash flows generated by the investment. 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.
- Capital equipment is purchased to increase cash flow by saving money or earning money from the asset purchased.
- It may be the deciding factor in whether you should go ahead with the purchase of that big-ticket asset, or hold off until your cash flow is better.
- For example, if it takes five years to recover the cost of an investment, the payback period is five years.
- However, there are additional considerations that should be taken into account when performing the capital budgeting process.
- However, not all projects 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.
Calculating the payback period is also useful in financial forecasting, where you can use the net cash flow formula to determine how quickly you can recoup your initial investment. Whether you’re using accounting software in your business or are using a manual accounting system, you can easily calculate your payback period. In its simplest form, the formula to calculate the payback retained earnings def period involves dividing the cost of the initial investment by the annual cash flow. The payback period is calculated by dividing the initial capital outlay of an investment by the annual cash flow. Keep in mind that the cash payback period principle does not work with all types of investments like stocks and bonds equally as well as it does with capital investments.
Create a free account to unlock this Template
The payback period is the expected number of years it will take for a company to recoup the cash it invested in a project. Jim estimates that the new buffing wheel will save 10 labor hours a week. Thus, at $250 a week, the buffer will have generated enough income (cash savings) to pay for itself in 40 weeks. In essence, the payback period is used very similarly to a Breakeven Analysis, but instead of the number of units to cover fixed costs, it considers the amount of time required to return an investment. Before you invest thousands in any asset, be sure you calculate your payback period. Cathy currently owns a small manufacturing business that produces 5,000 cashmere scarfs each year.
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.
For example, if it takes five years to recover the cost of an investment, the payback period is five years. The payback period is the amount of time it takes to recover the cost of an investment. Simply put, it is the length of time an investment reaches a breakeven point. 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. In Jim’s example, he has the option of purchasing equipment that will be paid back 40 weeks or 100 weeks. It’s obvious that he should choose the 40-week investment because after he earns his money back from the buffer, he can reinvest it in the sand blaster.
Assume Company A invests $1 million in a project that is expected to save the company $250,000 each year. If we divide $1 million by $250,000, we arrive at a payback period of four years for this investment. Others like to use it as an additional point of reference in a capital budgeting decision framework. For example, if solar panels cost $5,000 to install and the savings are $100 each month, it would take 4.2 years to reach the payback period. The payback period is a method commonly used by investors, financial professionals, and corporations to calculate investment returns. CFI is the global institution behind the financial modeling and valuation analyst FMVA® Designation.
What Is the Formula for Payback Period in Excel?
She has worked in multiple cities covering breaking news, politics, education, and more. On the other hand, Jim could purchase the sand blaster and save $100 a week from without having to outsource his sand blasting. We’re firm believers in the Golden Rule, which is why editorial opinions are ours alone and have not been previously reviewed, approved, or endorsed by included advertisers. The Ascent, a Motley Fool service, does not cover all offers on the market. We’ll explain what the payback period is and provide you with the formula for calculating it. First, we’ll calculate the metric under the non-discounted approach using the two assumptions below.
The payback period is the time it will take for your business to recoup invested funds. For instance, if your business was considering upgrading assembly line equipment, you would calculate the payback period to determine how long it would take to recoup the funds used to purchase the equipment. The payback period is a fundamental capital budgeting tool in corporate finance, and perhaps the simplest method for evaluating the feasibility of undertaking a potential investment or project. 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. The breakeven point is the price or value that an investment or project must rise to cover the initial costs or outlay.