Sep 02

Comments Off on Payback Period Formulas, Calculation & Examples

This is because they factor in the time value of money, working opportunity cost into the formula for a more detailed and accurate assessment. Another option is to use the discounted payback period formula instead, which adds time value of money into the equation. According to payback method, the project that promises a quick recovery of initial investment is considered desirable. If the payback period of a project is shorter than or equal to the management’s maximum desired payback period, the project is accepted, otherwise rejected.

Julia Kagan is a financial/consumer journalist and former senior editor, personal finance, of Investopedia.
Projecting a break-even time in years means little if the after-tax cash flow estimates don’t materialize.
These two calculations, although similar, may not return the same result due to the discounting of cash flows.
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.

Recipients are individuals, businesses, schools, nonprofits, municipalities, county offices, state agencies and anyone else who has lived or done business in Colorado. The state updates its list each year with new lost money or unclaimed property, so Coloradans should check each year. Payback is used measured in terms of years and months, though any period could be used depending on the life of the project (e.g. weeks, months).

Free Financial Modeling Lessons

Start with a free account to explore 20+ always-free courses and hundreds of finance templates and cheat sheets. Next, the “Unrecovered Amount” represents the negative balance in the year preceding the year in which the cumulative net cash flow of the company exceeds zero. 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. In most cases, this is a pretty good payback period as experts say it can take as much as years for residential homeowners in the United States to break even on their investment. One observation to make from the example above is that the discounted payback period of the project is reached exactly at the end of a year. In other circumstances, we may see projects where the payback occurs during, rather than at the end of, a given year.

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. For example, imagine a company invests $200,000 in new manufacturing equipment which results in a positive cash flow of $50,000 per year. 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.

For this reason, the payback period may return a positive figure, while the discounted payback period returns a negative figure.
Harold Averkamp (CPA, MBA) has worked as a university accounting instructor, accountant, and consultant for more than 25 years.
Over 1.8 million professionals use CFI to learn accounting, financial analysis, modeling and more.
We’ll now move to a modeling exercise, which you can access by filling out the form below.

If undertaken, the initial investment in the project will cost the company approximately $20 million. The payback period for this project is 3.375 years which is longer than the maximum desired payback period of the management (3 frequently asked questions about the aicpa years). To begin, the periodic cash flows of a project must be estimated and shown by each period in a table or spreadsheet. These cash flows are then reduced by their present value factor to reflect the discounting process.

There are two ways to calculate the payback period, which are described below. The discounted payback period is a modified version of the payback period that accounts for the time value of money. Both metrics are used to calculate the amount of time that it will take for a project to “break even,” or to get the point where the net cash flows generated cover the initial cost of the project. Both the payback period and the discounted payback period can be used to evaluate the profitability and feasibility of a specific project.

Discounted Payback Period Example Calculation

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. 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. The two calculated values – the Year number and the fractional amount – can be added together to arrive at the estimated payback period.

Payback method

The Payback Period shows how long it takes for a business to recoup an investment. This type of analysis allows firms to compare alternative investment opportunities and decide on a project that returns its investment in the shortest time if that criteria is important to them. The table is structured the same as the previous example, however, the cash flows are discounted to account for the time value of money.

Irregular Cash Flow Each Year

Unclaimed property is tangible or intangible property that has had no activity for a specific period of time. The discounted payback period, in theory, is the more accurate measure, since fundamentally, a dollar today is worth more than a dollar received in the future. According to payback method, machine Y is more desirable than machine X because it has a shorter payback period than machine X.

Acting as a simple risk analysis, the payback period formula is easy to understand. It gives a quick overview of how quickly you can expect to recover your initial investment. The payback period also facilitates side-by-side analysis of two competing projects. If one has a longer payback period than the other, it might not be the better option.

This can be done using the present value function and a table in a spreadsheet program. 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. Between mutually exclusive projects having similar return, the decision should be to invest in the project having the shortest payback period. 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). After all, your $100,000 will not be worth the same after ten years; in fact, it will be worth a lot less. Every year, your money will depreciate by a certain percentage, called the discount rate.

Supercharge your skills with Premium Templates

Based on the project’s risk profile and the returns on comparable investments, the discount rate – i.e., the required rate of return – is assumed to be 10%. Machine X would cost $25,000 and would have a useful life of 10 years with zero salvage value. Payback period is used not only in financial industries, but also by businesses to calculate the rate of return on any new asset or technology upgrade. For example, a small business owner could calculate the payback period of installing solar panels to determine if they’re a cost-effective option. Cash flow is the inflow and outflow of cash or cash-equivalents of a project, an individual, an organization, or other entities.

On the other hand, payback period calculations can be so quick and easy that they’re overly simplistic. The payback period is the amount of time it would take for an investor to recover a project’s initial cost. The discounted payback period of 7.27 years is longer than the 5 years as calculated by the regular payback period because the time value of money is factored in. 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. 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.