how to find payback period

If the IRR of an investment is higher than the company’s or the investor’s required rate of return, this sends a strong signal that it is worth undertaking. Just like the basic payback period, its modified counterpart calculates the time types of inventory required to retrieve the invested funds. It provides a straightforward and easy way for calculating even and uneven cash flows. The simplest way to differentiate between even and uneven cash flows is by evoking the concept of an annuity.

how to find payback period

Discount rate is useful because it can take future expected payments from different periods and discount everything to a single point in time for comparison purposes. Cash flow is the inflow and outflow of cash or cash-equivalents of a project, an individual, an organization, or other entities. Positive cash flow that occurs during a period, such as revenue or accounts receivable means an increase in liquid assets. On the other hand, negative cash flow such as the payment for expenses, rent, and taxes indicate a decrease in liquid assets.

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. For the most thorough, balanced look into a project’s risk vs. reward, investors should combine a variety of these models. There are some clear advantages and disadvantages of payback period calculations. Conversely, if proceeds after the period have a dramatic uptick and move into the green, then the investment is a wise decision. Payback period is a vital metric for evaluating the time taken for an investment to break even.

Example of Payback Period

The breakeven point is the level at which the costs of production equal the revenue for a product or service. The Payback Period Calculator can calculate payback periods, discounted payback periods, average returns, and schedules of investments. While the payback period shows us how long it takes for the return on investment, it does not show what the return on investment is. 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.

  1. 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.
  2. The appropriate timeframe for an investment will vary depending on the type of project or investment and the expectations of those undertaking it.
  3. The breakeven point is a specific price or value that an investment or project must reach so that the initial cost of that investment or project is completely returned.
  4. In conditions of uncertainty, the shorter payback means good cushioning and risk mitigation.

Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling. However, the major benefit of MIRR is that it provides a more realistic idea of the return on investment. Unconventional cash flows refer to the streams of revenues and/or expenses that a business generates and/or incurs that are unexpected and haven’t been adjusted for in the predictions. Conversely, if the IRR falls below the required rate of return that the company or the investor seeks, then other more economically viable alternatives should be considered. It should be used with, but not limited to, the mentioned cash flow metrics, NPV and RoR, to build a more exhaustive picture of the viability of a project, its downside risks, and trade-offs. As a result, it does not provide adjustments for what a cash flow will be worth now and in the future, nor does it make any provisions for collecting the money.

Payback Period Formula

Unlike the break-even point, which uses the number of units sold to offset the costs, the payback is the length of time required for an investment to pay back for itself. So, if an investment of $200 has an annual return of $100, the ROI will be 50%, whereas the payback period will be 2 years ($200/$100). The situation gets a bit more complicated if you’d like to consider the time value of money formula (see time value of money calculator).

how to find payback period

The out put of using the payback tool is expressed in years or a fraction of years. It is a function of the initial invested capital and the average annual net cash flows generated by the investment. The breakeven point is a specific price or value that an investment or project must reach so that the initial cost of that investment or project is completely returned. Whereas the payback period refers to the time it takes to reach the breakeven point.

This is due to the fact that the future value is affected by factors such as inflation, eroding purchasing power, liquidity, and default risks. Despite its simplicity, the payback period is a practical and handy accounting metric that offers a number of advantages worth considering. Conversely, a good investment is one that takes less time to generate returns or is of a relatively short length. The payback period is a valuable and simple analysis tool that can facilitate the comparison of alternative investments. The following hypothetical example will provide better clarification regarding comparing investments.

People and corporations mainly invest their money to get paid back, which is why the payback period is so important. In essence, the shorter 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. However, it adds a layer of complexity to the basic model by introducing the total sum of all cash outflows and recording all positive cash inflows.

Create a free account to unlock this Template

The profitability index, or PI, indicates the profitability and attractiveness of the investment in a project. The PI is the expressed ratio of the present value of discounted future cash flows to the initial invested capital. The payback period is an accounting metric in capital budgeting that refers to the amount of time it takes to recover the funds invested in a project or reach a break-even point. 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. Also, it is a simple measure of risk, as it shows how quickly money can be returned from an investment.

How to calculate payback period with irregular cash flows

But since the payback period metric rarely comes out to be a precise, whole number, the more practical formula is as follows. 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. 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). 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. The index is a good indicator of whether a project creates or destroys company value.

The capital budgeting measure has two variants outlined below with their respective advances and disadvantages. With this in mind, it becomes clear that the tool is insufficient for estimating the value of an investment and its returns. A good place to start getting to grips with them is our Accounting Foundations Course and the Excel Modeling Course. The calculation can also be performed using a payback period calculator or in Excel for the provided reference values. In the first case, the period over which the capital is paid back for project A is 10 years, while for project B it is 5 years. Mr. Arora is an experienced private equity investment professional, with experience working across multiple markets.

Rohan has a focus in particular on consumer and business services transactions and operational growth. Rohan has also worked at Evercore, where he also spent time in private equity advisory. By adopting cloud accounting software like Deskera, you can track your costs, send purchase orders, overview your bills, generate expense reports, and much more – through a single, user-friendly platform. In this guide, we’ll be covering what the payback period is, what are the pros and cons of the method, and how you can calculate it, with concrete business examples. Financial modeling best practices require calculations to be transparent and easily auditable.

However, there are additional considerations that should be taken into account when performing the capital budgeting process. To determine how to calculate payback period in practice, you simply divide the initial cash outlay of a project by the amount of net cash inflow that the project generates each year. For the purposes of calculating the payback period formula, you can assume that the net cash inflow is the same each year. This payback period calculator is a tool that lets you estimate the number of years required to break even from an initial investment. You can use it when analyzing different possibilities to invest your money and combine it with other tools, such as the net present value (NPV calculator) or internal rate of return metrics (IRR calculator).