Payback period can be defined as period of time required to recover its initial cost and expenses and cost of investment done for project to reach at time where there is no loss no profit i.e. breakeven point.
This is a method to check the viability of projects or investments. Here, if the payback period is longer, then the project does not have so much benefit. However, a shorter period will be more acceptable since the cost of the investment can be recovered within a short time. It is considered to be more economically efficient and its sustainability is considered to be more.
The payback period is a metric in the field of finance that helps in assessing the time requirement for recovering the initial investment made in a project. It has a wide usage in the investment field to evaluate the viability of putting money in an opportunity after assessing the payback time horizon.
Every investor, be it individual or corporate will want to assess how long it will take for them to get back the initial capital. The shorter the period, the more favorable it is. This is because it is always worthwhile to invest in an opportunity in which there is enough net revenue to cover the initial cost.
Since the concept helps compute payback period with the breakeven point, the investor can easily plan their financial strategies further and make more decisions regarding the next step. It is calculated by dividing the investment made by the cash flow received every year. This is a valuable metric for fund managers and analysts who use it to determine the feasibility of an investment. However, it is to be noted that the method does not take into account time value of money.
The above article notes that Tesla's Powerwall is not economically viable for most people. As per the assumptions used in this article, Powerwall's payback ranged from 17 years to 26 years. Considering Tesla's warranty is only limited to 10 years, the payback period higher than 10 years is not idea.
The payback period formula is one of the most popular formulas used by investors to know how long it would generally take to recoup their investments and is calculated as the ratio of the total initial investment made to the net cash inflows. The below mentioned formula helps to compute payback period.
When cash flows are uniform over the useful life of the asset, then the calculation is made through the following payback period equation.
Payback period Formula = Total initial capital investment /Expected annual after-tax cash inflow.
When cash flows are NOT uniform over the use full life of the asset, then the cumulative cash flow from operations must be calculated for each year. In this case, the payback period shall be the corresponding period when cumulative cash flows are equal to the initial cash outlay.
In case the sum does not match, then the period in which it lies should be identified. After that, we need to calculate the fraction of the year that is needed to complete the payback.
Let us understand the concept of how to calculate payback period with the help of some suitable examples.
Suppose ABC ltd is analyzing a project which requires an investment of $2,00,000 and it is expected to generate cash flows as follows
| Year Annual cash inflows | |
|---|---|
| 1 | 80,000 |
| 2 | 60,000 |
| 3 | 60,000 |
| 4 | 20,000 |
In this cash payback period can be calculated as follows by calculating cumulative cashflows
| Year | Annual cash inflows | Cumulative Annual cash inflows | Payback period |
|---|---|---|---|
| 1 | 80,000 | 80,000 | |
| 2 | 60,000 | 1,40,000(80,000+60,000) | |
| 3 | 60,000 | 2,00,000(1,40,000+60,000) | In this Year 3 we got initial investment of $ 2,00,000 so this is the pay back year |
| 4 | 20,000 | 2,20,000(2,00,000+20,000) |
Suppose, in the above case, if the cash outlay is $2,05,000, then pa back period is
| Year | Annual cash inflows | Cumulative Annual cash inflows | Payback period |
|---|---|---|---|
| 1 | 80,000 | 80,000 | |
| 2 | 60,000 | 1,40,000(80,000+60,000) | |
| 3 | 60,000 | 2,00,000(1,40,000+60,000) | |
| 4 | 20,000 | 2,20,000(2,00,000+20,000) | The payback period is between 3 and 4 years |
For up to three years, a sum of $2,00,000 is recovered, the balance amount of $ 5,000($2,05,000-$2,00,000) is recovered in a fraction of the year, which is as follows.
Forgetting $20,000 additional cash flows, the project is taking complete 12 months. So for getting additional of $ 5,000($2,05,000-$2,00,000) it will take (5,000/20,000) 1/4 th Year. i.e., 3 months.
So, the project payback period is 3 years 3 months.
Let us see an example of how to calculate the payback period equation when cash flows are uniform over using the full life of the asset.
A project costs $2Mn and yields a profit of $30,000 after depreciation of 10% (straight line) but before tax of 30%. Lets us calculate payback period of the project.
Less: Tax@30%(30000*30%) $ 9,000
Profit after tax $ 21,000
Add: Depreciation(2Mn*10%) $ 2,00,000
Total cash inflow $ 2,21000
While calculating cash inflow, generally, depreciation is added back as it does not result in cash out flow.
Payback Period Formula = Total initial capital investment /Expected annual after-tax cash inflow
= $ 20,00,000/$2,21000 = 9 Years(Approx)
Some important advantages of the concept of payback period in excel are as follows:
Here are some disadvantages of the method. Let us study them in detail.
The following are the disadvantages of the payback period.
Thus, the above are some benefits and limitations of the concept of payback period in excel. It is important for players in the financial market to understand them clearly so that they can be used appropriately as and when required and get the benefit of it to the maximum possible extent.
Payback reciprocal is the reverse of the payback period, and it is calculated by using the following formula
Payback reciprocal = Annual average cash flow/Initial investment
For example, a project cost is $ 20,000, and annual cash flows are uniform at $4,000 per annum, and the life of the asset acquire is 5 years, then the payback period reciprocal will be as follows.
$ 4,000/20,000 = 20%
This 20% represents the rate of return the project or investment gives every year.
Both the above are important financial metrics used by analysts and investors to evaluate the profitability and viability of an investment. However, some differences between them are as follows;
Therefore the above points reflect the basic differences between the two financial concepts.
Both the above are financial metrics used for analysis and evaluation of projects and investment opportunities. But they differ in the technique used for calculation. Let us study the differences.
Thus, the above are some noteworthy differences between the two concepts.
Guide to what is Payback Period. We explain its formula, how to calculate, example, advantages, disadvantages & differences with ROI.
Join Wallstreetmojo Youtube
Learn MS Excel right from scratch. Master excel formulas, graphs, shortcuts with 3+hrs of Video.
Join Wallstreetmojo Instagram
Learn Financial Modeling in Excel with this Step by Step Guide (Colgate Case Study)
Join Wallstreetmojo Linkedin
