This sum tells you how much cash you’ve generated up until that point in time. Furthermore, the payback analysis fails to consider inflows of cash that occur beyond the payback period, thus failing to compare the overall profitability of one project as compared to another. Since many capital investments provide investment returns over a period of many years, this can be an important consideration. Tools such as net present value (NPV) and internal rate of return (IRR) offer a more comprehensive view of investment profitability, but they are more complex to calculate.
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. This method also does not take into account other factors such as risk, financing or any other considerations that come into play with certain investments. Typically, this metric is expressed in years or months depending on your risk tolerance and the size of the cash investment. The management of Health Supplement Inc. wants to reduce its labor cost by installing a new machine in its production process.
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 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. One way corporate financial analysts do this is with the payback period. People and corporations mainly invest their money to get paid back, which is why the payback period is so important.
For example, you could use monthly, semi annual, or even two-year cash inflow periods. The cash inflows should be consistent with the length of the investment. 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 addition, the potential returns and estimated payback time of alternative projects the company could pursue instead can also be an influential determinant in the decision (i.e. opportunity costs).
When Would a Company Use the Payback Period for Capital Budgeting?
The first is that it fails to take into account the time value of money (TVM) and adjust the cash inflows accordingly. The TVM is the idea that the value of cash today how to calculate payback period will be worth more than in the future because of the present day’s earning potential. This analysis method is particularly helpful for smaller firms that need the liquidity provided by a capital investment with a short payback period. The sooner money used for capital investments is replaced, the sooner it can be applied to other capital investments. A quicker payback period also reduces the risk of loss occurring from possible changes in economic or market conditions over a longer period of time. The payback period refers to the amount of time it takes to recover the cost of an investment.
Payback Period Calculations In Excel: Ultimate Tutorial
The payback period is the expected number of years it will take for a company to recoup the cash it invested in a project. Cumulative net cash flow is the sum of inflows to date, minus the initial outflow. For example, using Meritech Capital’s PBP table, HubSpot’s payback period is 22.5 months while Bill.com’s (BILL) is 80 months. BILL can handle more risk exposure given the size of their company, though in our opinion, these PBP’s could be a lot better. Depreciation is a non-cash expense and therefore has been ignored while calculating the payback period of the project.
Moreover, it’s how long it takes for the cash flow of income from the investment to equal its initial cost. It’s important to consider other financial metrics in conjunction with payback period to get a clear picture of an investment’s profitability and risk. The discounted payback period is often used to better account for some of the shortcomings, such as using the present value of future cash flows. For this reason, the simple payback period may be favorable, while the discounted payback period might indicate an unfavorable investment. Using the averaging method, you should divide the annualized expected cash inflows into the expected initial expenditure for the asset. This approach works best when cash flows are expected to be steady in subsequent years.
- The more quickly the company can receive its initial cost in cash, the more acceptable and preferred the investment becomes.
- In such cases, we add the yearly earnings until the total investment is recovered.
- 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.
- In order to help you advance your career, CFI has compiled many resources to assist you along the path.
- Projects having larger cash inflows in the earlier periods are generally ranked higher when appraised with payback period, compared to similar projects having larger cash inflows in the later periods.
- Its positive measures are useful for risk assessments, quick decision-making, and short-term projects, and they help businesses determine the time to recover initial outlay costs.
How to Change Chart Type in Excel
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 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. Some companies rely heavily on payback period analysis and only consider investments for which the payback period does not exceed a specified number of years. Let’s assume that a company invests cash of $400,000 in more efficient equipment. The cash savings from the new equipment is expected to be $100,000 per year for 10 years.
The answer is found by dividing $200,000 by $100,000, which is two years. The second project will take less time to pay back, and the company’s earnings potential is greater. Based solely on the payback period method, the second project is a better investment if the company wants to prioritize recapturing its capital investment as quickly as possible. When deciding whether to invest in a project or when comparing projects having different returns, a decision based on payback period is relatively complex. The decision whether to accept or reject a project based on its payback period depends upon the risk appetite of the management.
The implications of this are that firms may choose investments with shorter payback periods at the expense of profitability. While the payback period is great for short projects, the calculation breaks down for investments that take years to start producing profit. The payback period is a simple yardstick for determining the most profitable option.
- When considering two similar capital investments, a company will be inclined to choose the one with the shortest payback period.
- However, there are additional considerations that should be taken into account when performing the capital budgeting process.
- As you can see in the example below, a DCF model is used to graph the payback period (middle graph below).
It is also possible to create a more detailed version of the subtraction method, using discounted cash flows. It has the most realistic outcome, but requires more effort to complete. The payback period is the amount of time required for cash inflows generated by a project to offset its initial cash outflow. This calculation is useful for risk reduction analysis, since a project that generates a quick return is less risky than one that generates the same return over a longer period of time.
AccountingTools
The payback period is expected to be 4 years ($400,000 divided by $100,000 per year). 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. 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.
Featured Companies
Understanding the limitations and how to interpret the results correctly is crucial for making informed decisions. By following these simple steps, you can easily calculate the payback period in Excel. Using Excel provides an accurate and straightforward way to determine the profitability of potential investments and is a valuable tool for businesses of all sizes. Financial analysts will perform financial modeling and IRR analysis to compare the attractiveness of different projects.
Additionally, if the payback period is longer than the expected useful life of the project, the investment is not profitable. It’s essential to consider other financial metrics in conjunction with payback period to get a clear picture of an investment’s profitability and risk. Knowing how to calculate payback period is crucial for companies and investors to determine how long it would take to regain their initial investment. The payback period is an easy financial measurement that assists in calculating how long it would take for an investment to earn enough cash flow to pay its initial price. It is extensively applied in capital budgeting to compare various projects and analyze the investment risk.
The table is structured the same as the previous example, however, the cash flows are discounted to account for the time value of money. 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. Below is a break down of subject weightings in the FMVA® financial analyst program. As you can see there is a heavy focus on financial modeling, finance, Excel, business valuation, budgeting/forecasting, PowerPoint presentations, accounting and business strategy. The Payback Period shows how long it takes for a business to recoup an investment.
Generally, you are aiming for a shorter payback period as it means you’ve recovered your investment sooner and lowered your risk exposure. 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. Although the payback period is easy to use as an investment measurement, it has some deficiencies. It disobeys the time value of money, distant profitability, as well as the economic risks that are involved when making large investments. Knowledge about these limitations can assist companies in selecting better assessment tools for investments. The payback period allows companies to know when it will take to recover an investment.
Your payback period calculates the time it takes for an investment to generate enough cash flow to recover its initial cost. In other words, it measures the period of time it takes for you to break even (another useful KPI). The payback period disregards any further cash flows after the investment recoups.