Payback Period

Below, we listed the financial model templates for different industries which include a Payback Period section. The Payback period is the time required in order that investment can repay its original costs in form of cash flow, profits or savings. So, you can use the payback period Excel templates below as a reference and a base to start your very own financial model calculating the payback period. Further below, we also provided some information regarding how to calculate payback in Excel and explanation on the different ways of how to calculate payback period.

Optimize your Subscription-based B2C SaaS startup's financial planning with our…

Starting at: $150.00
Add to wish list
Excluding 8.1% tax

This Financial Model Template provides an advanced 5-year financial plan…

Starting at: $89.00
Add to wish list
Excluding 8.1% tax

Ultimate Budget Spreadsheet, Budget Dashboard, in both Google Sheets and…

Starting at: $20.00
Add to wish list
Excluding 8.1% tax

Dive into the financial planning of your Crane Rental Company…

Starting at: $129.95
Add to wish list
Excluding 8.1% tax

The AgroTech Services Financial Model with DCF (Discounted Cash Flow)…

Starting at: $0.00
Add to wish list
Excluding 8.1% tax

The Urban Micro-Mobility Services Financial Model with DCF (Discounted Cash…

Starting at: $0.00
Add to wish list
Excluding 8.1% tax

Step into the world of crane rental business success with…

Starting at: $129.95
Add to wish list
Excluding 8.1% tax

The Telehealth Services Company Financial Model with a 10+ Years…

Starting at: $0.00
Add to wish list
Excluding 8.1% tax

The Online Tutoring Services Financial Model is a comprehensive tool…

Starting at: $0.00
Add to wish list
Excluding 8.1% tax

Embrace the road ahead, where every mile traveled isn’t just…

Starting at: $129.95
Add to wish list
Excluding 8.1% tax

Unleash the power of precise, customizable forecasting with Pro Financial…

Starting at: $60.00
Add to wish list
Excluding 8.1% tax

The Oil and Gas financial model with DCF (Discounted Cash…

Starting at: $0.00
Add to wish list
Excluding 8.1% tax

Financial Model providing an advanced 5-year financial plan for a…

Starting at: $79.00
Add to wish list
Excluding 8.1% tax

This detailed 10-year monthly Excel template is specifically designed to…

Starting at: $129.95
Add to wish list
Excluding 8.1% tax

Embark on a journey to financial mastery with our Private…

Starting at: $129.95
Add to wish list
Excluding 8.1% tax

Discover the key to financial success in your webinar ventures…

Starting at: $129.95
Add to wish list
Excluding 8.1% tax

Introducing the Party Planning Business Financial Model – Your Ultimate…

Starting at: $129.95
Add to wish list
Excluding 8.1% tax

Financial Model providing a dynamic up to 10-year financial forecast…

Starting at: $99.00
Add to wish list
Excluding 8.1% tax

The Dog Grooming Services financial model is a comprehensive tool…

Starting at: $0.00
Add to wish list
Excluding 8.1% tax

Elevate your event planning business to new heights with our…

Starting at: $0.00
Add to wish list
Excluding 8.1% tax

This comprehensive 10-year monthly Excel template offers an ideal basis…

Starting at: $0.00
Add to wish list
Excluding 8.1% tax

Powerful Real Estate Rental Property Financial Model for Informed Decision-Making,…

Starting at: $80.00
Add to wish list
Excluding 8.1% tax

Average rating:

The Hotel Complex financial model is a comprehensive tool designed…

Starting at: $0.00
Add to wish list
Excluding 8.1% tax

Financial Model providing an advanced 5-year financial plan for a…

Starting at: $79.00
Add to wish list
Excluding 8.1% tax

Ideal for entrepreneurs and finance professionals, this tool offers a…

Starting at: $0.00
Add to wish list

Financial Model presenting an advanced 5-year financial plan of a…

Starting at: $139.00
Add to wish list
Excluding 8.1% tax

The EV Battery Recycling Plant financial model is a comprehensive…

Starting at: $0.00
Add to wish list
Excluding 8.1% tax

Financial Model providing an advanced 5-year financial plan for a…

Starting at: $79.00
Add to wish list
Excluding 8.1% tax

Financial Model presenting an advanced 5-year financial plan for a…

Starting at: $139.00
Add to wish list
Excluding 8.1% tax

Introducing our Tennis Courts and Club Financial Forecasting Model –…

Starting at: $49.00
Add to wish list
Excluding 8.1% tax

Introducing our indispensable 10-Year Excel Financial Forecasting Model, a vital…

Starting at: $40.00
Add to wish list
Excluding 8.1% tax

Financial Model providing an advanced 5-year financial plan for a…

Starting at: $79.00
Add to wish list
Excluding 8.1% tax

The catering services business financial model is a comprehensive tool…

Starting at: $0.00
Add to wish list
Excluding 8.1% tax

Average rating:

The moving services business financial model is a comprehensive tool…

Starting at: $0.00
Add to wish list
Excluding 8.1% tax

An integrated and comprehensive Blue Hydrogen Production Plant Model which…

Starting at: $149.00
Add to wish list
Excluding 8.1% tax

This Car Rental Business Financial Model Template in Excel offers…

Starting at: $129.95
Add to wish list
Excluding 8.1% tax

This Self-Storage Park development model will produce 20 years of…

Starting at: $50.00
Add to wish list
Excluding 8.1% tax

Financial Model providing an advanced 5-year financial plan for an…

Starting at: $89.00
Add to wish list
Excluding 8.1% tax

Financial Model providing an advanced 5-year financial plan for a…

Starting at: $139.00
Add to wish list
Excluding 8.1% tax

Financial Model providing a 10-year financial plan for a startup…

Starting at: $129.00
Add to wish list
Excluding 8.1% tax

Test many variables in this financial model for a subscription…

Starting at: $125.00
Add to wish list
Excluding 8.1% tax

Financial Model providing a 10-year financial plan for a startup…

Starting at: $129.00
Add to wish list
Excluding 8.1% tax

Financial Model providing an advanced 5-year financial plan for a…

Starting at: $139.00
Add to wish list
Excluding 8.1% tax

The report is containing full set of financial feasibility study…

Starting at: $0.00
Add to wish list
Excluding 8.1% tax

The Car Repair Shop Fin. Model (DCF and Valuation) is…

Starting at: $0.00
Add to wish list
Excluding 8.1% tax

Financial Model providing an advanced 5-year financial plan for a…

Starting at: $79.00
Add to wish list
Excluding 8.1% tax

The Olive Orchard Financial Model is a comprehensive tool tailored…

Starting at: $0.00
Add to wish list
Excluding 8.1% tax

This model is Financial Feasibility Study for investment funds or…

Starting at: $0.00
Add to wish list
Excluding 8.1% tax

The Business Plan is for Stone Fabrication & Installation industry,…

Starting at: $0.00
Add to wish list
Excluding 8.1% tax

This is business plan for rice mill industry, it is…

Starting at: $0.00
Add to wish list
Excluding 8.1% tax

Financial Model providing an advanced 5-year financial plan for a…

Starting at: $79.00
Add to wish list
Excluding 8.1% tax

This is startup Business Plan for metal scrap business, easy…

Starting at: $69.00
Add to wish list
Excluding 8.1% tax

Financial Model providing an advanced 5-year financial plan for a…

Starting at: $79.00
Add to wish list
Excluding 8.1% tax

Financial Model providing an advanced 5-year financial plan for a…

Starting at: $69.00
Add to wish list
Excluding 8.1% tax

Financial Model presenting a development and operating scenario of a…

Starting at: $109.00
Add to wish list
Excluding 8.1% tax

Financial Model providing an advanced 5-year financial plan for a…

Starting at: $69.00
Add to wish list
Excluding 8.1% tax

Financial Model providing a 5-Year Financial Forecast of a Leasing…

Starting at: $129.00
Add to wish list
Excluding 8.1% tax

Average rating:

The EPC Financial Model Template for Builders and JV Partners…

Starting at: $0.00
Add to wish list
Excluding 8.1% tax

Financial model presenting an acquisition scenario of a Yacht Marina.

Starting at: $129.00
Add to wish list
Excluding 8.1% tax

The paintball park business financial model is a comprehensive tool…

Starting at: $0.00
Add to wish list
Excluding 8.1% tax

Payback Period - The time it takes to recover the cost of the Initial Investment


The Payback Period is the time period required to recover the cost of a project. In other words, it is the length of time needed to know when a project's cumulated cash flow will be able to pay back for its initial investment. Also, it is a question of risk where the shorter the money is invested in a risky project, the less risky the investment is. But the main advantage of this ratio is that it is easy to calculate and also can be easily understood by anybody.

The attractiveness of an investment is proportional to its payback period. Shorter paybacks make investments more appealing. The payback period is a valuable metric in financial and capital budgeting, but it also has applications in other industries. It can be used by individuals and companies to measure the return on investment in energy-efficient technology such as solar panels and insulation, as well as the costs of repairs and upgrades.

Capital budgeting is at the heart of corporate finance. One of the most important principles for any corporate financial analyst to grasp is how to value various investments or operating ventures in order to choose the most profitable project or investment. The payback period is one way corporate financial analysts do this.

The payback period is calculated by dividing the investment expense by the annual cash flow. The investment is more appealing if the payback period is short.



Payback Period Purpose


Once you are ready to make a decision as to the profitability of a project, how to calculate payback in Excel is a very useful tool. The payback period is usually expressed in years or months and a very important factor if you want to measure the feasibility of a project or investment and its risk. By calculating the payback period, you will be able to answer the question, “How long will it take to recoup the initial investment?”. If the answer is less than or equal to the maximum allowable period, the project is considered to be acceptable. If the payback period is longer than is acceptable, then the project is rejected. Note that the payback period serves as a kind of break-even period, and thus provides some information regarding the liquidity of the project under analysis.

On the other hand, the limitation of this ratio is that in the simple form, it is not considering the time value of money and only focuses on short-term benefits. Basically, the cash flows at the beginning have the same weight as cash flows coming in the future. Also, the cash flows, after the project has paid back its investment, are excluded from the analysis.

In other words, a payback period has very clear advantages and disadvantages such as:

+ Simple financial metric easy to calculate
+ Easy to explain
- Focuses on Short-Term gains (excludes longer-term benefits from the analysis)
- Cash Flows in the near and distant future have the same weight

Despite its clear disadvantage, overall, how to calculate payback in Excel is a great and simple financial ratio to check whenever you consider an investment. Below, you can see an example of a simple calculation of the payback period.

 



With the given initial investment of $50M and projected cash flows for 5-yrs, the period calculated where the business will be able to pay back the initial investment as well as start accumulating income or basically, the payback period, is determined as 3.6 years just like how it is shown in the table above and the graph below.



 

How to Calculate Payback Period? - Examples


Though it sounds easy to determine the payback period, we will discuss in detail how to calculate the payback period from here on.

The cash flows or projected cash flows are critical elements in determining the payback period of a business. But it is not always the case where it is constant or even at certain periods. Hence, the way to calculate the payback period will differ. Basically, to determine a much more precise result, there are two ways on how to calculate the payback period. The first one applies to cases when cash flows are even and the other is when the cash flows are uneven.

Since the payback period is usually expressed in years, the steps for calculating the Payback Period is as follows:

  • Even Cash Flows – simply divide the initial investment by the cash inflow per period

  • Uneven Cash Flows – simply subtract the cash flows from the initial investment until the initial investment is covered


To put it in simpler terms and an easier way to understand, the following formulas are used:

When Even Cash Flows: PP = Initial Investment / Cash Inflow per Period
For Uneven Cash Flows: PP = A + (B / C)

Where:
A = The last period with negative cumulative cash flow;
B = The absolute value of the last negative cumulative cash flow at the end of period A;
C = The total cash flow received during the period after A

 

Calculation of Payback Period Example with Even Cash Flows using the formula:

Assuming that the expected cash flows of a certain business with a $50M initial investment is constantly $20.5M for every period. We will then calculate the payback period by dividing $50M to $20.5M, resulting in 2.45 years.

 

Calculation of Payback Period Example with Uneven Cash Flows using the Table shown below and applying the formula:

Payback Period with Uneven Cash Flows
Payback Period with Uneven Cash Flows


If we take the initial investment in the example above of $50M, you will see that in year 4 the cumulated cash flows become positive ($8M). This means the project's payback period is between year 3 and year 4. If we want to calculate it precisely, we need to divide the missing cash flow by end of year 3 (-$11M) by the cash flow received in year 4 ($19M).

Therefore, the payback period for this project is 3.6 (3 + 11/19) years.

 

Although the payback period makes a great deal of sense intuitively, it is not without its problems. As mentioned before, the principal problem is that the payback method ignores the time value of money. It should be obvious that most investments become increasingly attractive as the firm’s required return (WACC) falls and less attractive when the required return rises. However, the payback period doesn’t change when the WACC changes. A second difficulty with the payback period is that it does not take all of the cash flows into account. Because it ignores all cash flows beyond the payback period, it can lead to less than optimal decisions.

You don’t have to fret and think that maybe you shouldn’t waste your time with the methods in calculating the payback period. There is, of course, a way to fix the issue regarding the time value of money and that is by using the discounted payback period or also known as the dynamic payback period method which we will discuss further below.

 

Dynamic Payback Period Method | Discounted Payback Period Formula


Another variation in calculating the payback period is the dynamic payback period method or also known as the discounted payback period (DPP). In this method, you check when the discounted free cash flows pay back for its investment. Basically, a dynamic payback period is the period after which the capital invested has been recovered after considering the discounted net cash inflows from the project.

This method is identical to the regular payback period, except that we use the present value of the cash flows instead of the nominal values. Because present values are always less than nominal values, the discounted payback period will always be longer than the regular payback period. Compared to the static payback period method which is a much simpler approach to calculating the payback period, the dynamic payback period method or discounted payback period formula takes into account the time value of money (and therefore the risk of the business) just like the discounted cash flow (DCF) method.

In the end, normally, the dynamic payback period leads to a longer time required to pay back for the investment compared to the normal payback calculation. This is due to the fact that the positive cash flows in the future are discounted and, therefore, are reduced.

Dynamic Payback Period
Discounted Payback Period / Dynamic Payback Period


To calculate the discounted cash flows, you need to recall how to discount the cash flows to determine their present value just like the DCF method. As shown from the example above, we assumed a 10% discount rate. After determining the discounted cash flows, we can then apply the formula for calculating the Payback Period with Uneven Cash Flows:

Discounted Payback Period Formula = A + ( B / C )

Where:
A
 = The last period with negative cumulative discounted cash flow;
B = The absolute value of the last negative cumulative discounted cash flow at the end of period A;
C = The total discounted cash flow received during the period after A

PP = 4 + ( 5 / 14 ) = 4.4 years

The benefit of the discounted payback period method is that the acceptability of a project will change as required returns change. If the required return should rise, the discounted payback period will rise too and then the project would be rejected. Because the regular payback period ignores the time value of money, it would still suggest that the project is acceptable, regardless of the required return. This method has similar drawbacks as the first method to calculate uneven cash flows but can be a better tool as it includes the project's risk by discounting the future cash flows for their risk as a function of time. But you still need to take note that the discounted payback period still ignores cash flows beyond the period where payback is achieved.

 

Capital Budgeting and Payback Period


The payback period is the selection criterion, or determining factor, that most companies use to choose between possible capital projects in capital budgeting. Small and large companies alike prefer to prioritize initiatives with a higher probability of a quicker, more lucrative payback. The payback period of a capital project is calculated by taking into account project cash flows, initial expenditure, and other variables.

These capital projects begin with a capital budget, which specifies the project's initial investment and annual cash flows. With the assumption that the project generates the required cash flows per year, the budget contains a measure to display the projected payback period.

A capital project may include the purchase of a new plant or building, as well as the purchase of new or replacement equipment. Depending on their industry, most companies set a cut-off payback period, such as three-five years. In other terms, if the payback period is less than five years, the company can buy the asset or invest in the project. It would not if the payback took six years because it beats the firm's five-year payback goal.

 

Payback Period Example Models


Are you looking for financial model templates that include the calculation of the payback period of an investment or a project? If you are, then download you don’t have to spend too much time on building a model from scratch. Hiring an expert to build a model for you will also be too expensive so, it is preferable to utilize ready-made templates which include the calculation of the payback period.

To help you better understand how a payback period is calculated and works in a project financial model, you can refer to the above list of Payback Period Example Models. These payback periods Excel model templates are made by financial modeling experts with vast experience and industry know-how. These payback period example models will serve as your base to start with when creating a model of a project or investment and determine if it is feasible or not. The listed payback period example models above include payback period calculations for you to use as a reference and learn how it works.

You can also get other industry-specific financial model templates on how to calculate payback in Excel available for download here at eFinancialModels. These templates are used by various kind of users such as entrepreneurs, executives, bankers, etc., from different countries such as in the USA, UK, Germany, Japan, Switzerland, Egypt, and many more who are in need of help when it comes to building financial models as well as other financial modeling tasks.