Payback Period Calculator

Payback Period Formula

The formula for different cash inflows:

PBP = A + (NCO – C) / D

Here,
PBP = Payback period
A = The year in which the cumulative net cash flow is nearer to NCO.
C = The cumulative net cash flow of year A.
D = Net cash flow of the year following the year A.
NCO = Net Cash Outlay

The formula for Same Cash Inflows Each Year:

PBP = NCO / NCB (or Average CFAT)

Here,
NCO = Net Cash Outlay
NCB = Net Cash Benefit
CFAT = Cash Flows After Tax

How to Calculate Payback Period?

You can use the two formulas defined above to calculate the payback period. In case your annual expected cash inflows remain the same for every year throughout the project’s life, you can calculate the payback period simply by dividing the NCO by the Net Cash Benefit (NCB) or Cash Flows After Tax (CFAT).

If your expected cash inflows are different, then this task can be a bit complex. But it is easier than you think. Create a table with three columns named the number of years, Cash Flows After Tax (CFAT), and Cumulated Cash Flows After Tax (C.CFAT).

We have already discussed the formula above. Now let’s take a look at an example:

Payback Period Example: Problems with Solutions

Let’s say a project requires an initial investment of $8,000 with a life of 5 years. The cash inflows for the five years are $1000, $1500, $2000, $2500, and $3000, respectively.

The column to calculate the payback period:

Apply the formula, PBP = A + (NCO – C) / D

Here,
A = 4
NCO = 8000
C = 7000
D = 3000

Now,
PBP = 4 + (8000 – 7000) / 3000
Or, 4 + 1000 / 3000
Or, 4 + 0.3 = 4.3 years

Calculating the payback period with our automatic calculator is super easy. You can use it to save your time.

Frequently Asked Questions (FAQs)

1. What is the Payback Period?

The Payback Period is the amount of time it takes for an investment to generate cash flows sufficient to recover its initial cost (Net Cash Outlay). It helps investors assess the risk and liquidity of an investment.

2. How is the Payback Period calculated?

The Payback Period (PBP) is calculated using the formula: PBP = A + (NCO – C) / D or PBP = NCO / NCB

3. What is Net Cash Outlay (NCO)?

Net Cash Outlay is the initial investment or cost required to start a project or acquire an asset. It is usually a lump-sum amount paid upfront.

4. Why is Payback Period important?

It helps businesses and investors understand how quickly they can recover their investments. Shorter payback periods are generally preferred, especially for high-risk investments.

5. Is a shorter Payback Period always better?

Not necessarily. While shorter periods indicate quicker recovery, they don’t account for profitability or returns after the payback period. It should be used alongside other financial metrics like NPV or IRR.

6. Can the payback period be used for all types of investments?

It is most useful for capital budgeting decisions involving predictable cash flows. However, it may not be suitable for projects with irregular or uncertain returns.

7. Does the Payback Period consider the time value of money?

The basic Payback Period does not account for the time value of money. For that, you should use the Discounted Payback Period, which considers the present value of future cash flows.

8. What happens if the investment never pays back?

If the cumulative cash inflows never equal or exceed the initial investment, the payback period is considered undefined or infinite, indicating a poor investment choice.

9. Can the Payback Period be calculated if cash inflows vary each year?

Yes, the Payback Period can still be calculated with varying cash inflows by summing up the cumulative cash inflows year by year until the Net Cash Outlay is recovered.

10. What are the limitations of the Payback Period method?

• Ignores returns after payback
• Doesn’t consider time value of money (unless discounted)
• Doesn’t measure profitability
• Not suitable for long-term projects with slow returns