Financial Modeling Tutorials
 Financial Modeling Basics
 Excel Modeling
 Financial Functions in Excel
 Sensitivity Analysis in Excel
 Time Value of Money
 Future Value Formula
 Present Value Factor
 Perpetuity Formula
 Present Value vs Future Value
 Annuity vs Pension
 Present Value of an Annuity
 Doubling Time Formula
 Annuity Formula
 Annuity vs Perpetuity
 Annuity vs Lump Sum
 Internal Rate of Return (IRR)
 NPV vs XNPV
 NPV vs IRR
 NPV Formula
 PV vs NPV
 IRR vs ROI
 Break Even Point
 Payback Period & Discounted Payback Period
 Payback period Formula
 Discounted Payback Period Formula
 Profitability Index
 Cash Burn Rate
 Simple Interest
 Simple Interest vs Compound Interest
 Simple Interest Formula
 CAGR Formula (Compounded Annual Growth Rate)
 Effective Interest Rate
 Loan Amortization Schedule
 Mortgage Formula
 Loan Principal Amount
 Interest Rate Formula
 Rate of Return Formula
 Effective Annual Rate
 Effective Annual Rate Formula (EAR)
 Daily Compound Interest
 Monthly Compound Interest Formula
 Discount Rate vs Interest Rate
 Rule of 72
 Geometric Mean Return
 Real Rate of Return Formula
 Continuous compounding Formula
 Weighted average Formula
 Average Formula
 Average Rate of Return Formula
 Mean Formula
 Weighted Mean Formula
 Harmonic Mean Formula
 Median Formula in Statistics
 Range Formula
 Expected Value Formula
 Exponential Growth Formula
 Margin of Error Formula
 Decrease Percentage Formula
 Percent Error Formula
 Holding Period Return Formula
 Cost Benefit Analysis
 Cost Volume Profit Analysis
 Opportunity Cost Formula
 Mortgage APR vs Interest Rate
 Regression Formula
 Correlation Coefficient Formula
 Covariance Formula
 Coefficient of Variation Formula
 Sample Standard Deviation Formula
 Relative Standard Deviation Formula
 Volatility Formula
 Binomial Distribution Formula
 Quartile Formula
 P Value Formula
 Skewness Formula
 Regression vs ANOVA
Payback Period Formula
Payback period is one of the most popular formulas used by investors. Through payback, they want to know how long it would generally take to recoup their initial investments.
Here’s the payback period formula –
Example of Payback Formula
Let’s take an example of payback period formula.
High Rise Ltd. has been looking at different investments. They have shortlisted three investments that seem to be attractive enough in terms of return. Among these three, they want to choose just one. The only criterion of this selection is the payback formula.
Here is a snapshot of three investments –
 Initial investment – $100,000; Cash inflow per year – $20,000.
 Initial investment – $150,000; Cash inflow per year – $50,000.
 Initial investment – $120,000; Cash inflow per year – $60,000.
From the point of view of payback, which project High Rise Ltd. should choose?
First, let’s calculate the payback period of the above investments.
The Payback Formula = Initial investment made / Net annual cash inflow
4.9 (927 ratings)
 For Investment A, the payback is = $100,000 / $20,000 = 5 years.
 For Investment B, the payback is = $150,000 / $50,000 = 3 years.
 For Investment C, the payback is = $120,000 / $60,000 = 2 years.
On the basis of payback, High Rise Ltd. should choose Investment C since the payback of this particular investment is significantly lower.
Recommended Courses
Explanation of Payback Formula
Let’s take an example to illustrate the payback. Let’s say that you have enrolled for an MBA. The fees for the MBA programme are $100,000. The institute has promised that if you can complete your MBA programme successfully, you would get a job which would pay around $50,000 per annum in the beginning.
So, if you make a rough calculation of how much time it would take to get back the money you have invested in your MBA programme, then you need to calculate the payback. And here’s what you should do.
You just need to divide your initial investment by the salary you would expect to get. Actually, you should do this calculation before you ever decide to invest in an MBA programme.
And here’s the calculation for the payback (the above example) = $100,000 / $50,000 = 2 years.
Use of Payback Formula
Payback formula is widely used.
There are few reasons why this method is so very popular –
 First of all, payback Period formula is very easy to calculate. All you need to remember is the initial investment and the cash inflow in near future.
 Secondly, payback Period formula gives a tentative period of time to recoup your initial investment and as a result, you can make a prudent decision.
However, payback has few limitations as well.
 Firstly, the calculation of payback is overly simplistic. As a result, you may find it easy to calculate; but the result is not very accurate.
 Secondly, payback doesn’t take the time value of money into the account. The value of $100 today won’t be same in the next year.
 Thirdly, payback doesn’t track the ultimate profitability of the project. It concentrates too much on recouping the initial investments.
Calculator
You can use the following Payback Period Calculator
Initial investment made  
Net annual cash inflow  
Payback Period Formula =  
Payback Period Formula = 


Payback Period in Excel (with excel template)
Let us now do the same example as above in Excel. This is very simple. You need to provide the two inputs of Initial investment made and Net annual cash inflow.
You can easily calculate the Payback in the template provided.
Recommended Articles
This has been a guide to Payback period formula, its usefulness along with examples. Here we also provide you with payback period calculator along with Payback Period Formula excel template download. You may also have a look at these articles below to learn more about Corporate Finance.
Leave a Reply