Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Payback Period Formula | Calculator (with Excel Template)

Payback Period

Flow of the article

  • Payback Period Formula
  • Payback Calculator
  • Payback Template

Payback Period Formula

Payback period is one of the most popular formulas used by the investors. Through Payback, they want to know how long it would generally take to recoup their initial investments.

Here’s the payback period formula  –

Payback Period Formula

Explanation of Payback Period 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 formula is very easy to calculate. All you need to remember is the initial investment and the cash inflow in near future.
  • Secondly, payback 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.

Example of Payback Formula

Let’s take an example of payback period formula.

High Rise Ltd. has been looking at different investments. They have short-listed 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 period.

Here is a snapshot of three investments –

  1. Initial investment – $100,000; Cash inflow per year – $20,000.
  2. Initial investment – $150,000; Cash inflow per year – $50,000.
  3. 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 formula for payback period = Initial investment made / Net annual cash inflow

  • 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.

Payback Period Formula Calculator

You can use the following Payback Period Calculator

Initial investment made
Net annual cash inflow
Payback Period Formula =

Payback Period Formula =
Initial investment made
Net annual cash inflow
= 0

Payback Period in Excel (with excel template)

Let us now do the same example 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 Period in the template provided.

Payback Period Formula in Excel

You can download this Payback Period template here – Payback Period Excel Template

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 excel template download. You may also have a look at these articles below to learn more about Corporate Finance.

  • Financial Modeling Templates
  • XNPV vs NPV
  • IRR vs NPV
  • Break Even Point Formula
  • Payback vs Discounted Payback

The post Payback Period Formula | Calculator (with Excel Template) appeared first on Learn Investment Banking: Financial Modeling Training Online.

This post first appeared on Free Investment Banking Tutorials |WallStreetMojo, please read the originial post: here

Share the post

Payback Period Formula | Calculator (with Excel Template)


Subscribe to Free Investment Banking Tutorials |wallstreetmojo

Get updates delivered right to your inbox!

Thank you for your subscription