Payback period: formulas, how to calculate it and what is normal

Contents 14 sections
  1. What the payback period is
  2. The payback period formula
  3. How to calculate payback: an example
  4. Discounted payback period
  5. Payback period calculator
  6. Payback period formula in Excel and Google Sheets
  7. What is a normal payback period
  8. Payback period and ROI
  9. Payback, NPV and IRR compared
  10. Where the payback period misleads
  11. Payback period for a project in Spain
  12. Frequently asked questions
  13. Key points about the payback period
  14. Sources

The payback period is the time it takes a project’s cash flows to return the investment.

If the annual flow is the same every year, divide: investment ÷ annual cash flow. If the flows differ, use the cumulative total.

For example, €150,000 invested with €30,000–60,000 a year pays back in 3.5 years, or 4.5 at a 12% discount rate.

Below: the formulas for simple and discounted payback, a worked example, how to calculate payback in Excel, what a normal payback period is, how payback differs from ROI, NPV and IRR, and where it misleads. The page includes a payback, NPV and IRR calculator.

What the payback period is

The payback period answers a simple question: how many years until the money invested comes back.

Owners and banks like it because it shows risk at a glance — the longer the money is locked in a project, the more can go wrong.

There are two versions:

  • simple payback — on the cash flows as they are;
  • discounted payback — on the cash flows converted into today’s money at the discount rate. It is always longer than simple payback.

How to calculate the payback period1Investment — year 0price, refit, licences, start-up cash2Cash flows by yearafter tax, without depreciation3Cumulative totalthe year it turns positive4Fraction of the yearunrecovered ÷ payback-year flow5Same in today’s moneydiscounted payback is longerFINETIC CONSULTING

The payback period formula

If the annual flow is the same:

Payback period = Investment / Annual cash flow

€200,000 invested and €50,000 a year — 4 years.

If the flows differ, add them year by year until the cumulative total covers the investment, then add the fraction of the year:

Payback = Years before payback + Unrecovered amount / Cash flow in the payback year

The flow is net cash flow after corporate tax: receipts minus payments, without depreciation, which is not a cash payment.

Payback with monthly cash flows

For a small business it is often clearer in months: €36,000 invested in a shop refit that adds €1,500 of net cash flow a month pays back in 36,000 / 1,500 = 24 months.

A common mistake: dividing by the average flow

With uneven flows, the equal-flow formula applied to the average gives the wrong answer.

In the example below, flows of €30,000–60,000 average €48,000 a year: 150,000 / 48,000 ≈ 3.1 years, while the actual payback from the cumulative total is 3.5 years.

When the flows grow over time, the average makes payback look shorter than it is.

How to calculate payback: an example

An illustrative project: €150,000 invested, cash flows of €30,000, €40,000, €50,000, €60,000 and €60,000 by year, a 12% discount rate.

Year Cash flow Cumulative Today’s value (12%) Cumulative, today’s value
0 −€150,000 −€150,000 −€150,000 −€150,000
1 €30,000 −€120,000 €26,786 −€123,214
2 €40,000 −€80,000 €31,888 −€91,327
3 €50,000 −€30,000 €35,589 −€55,738
4 €60,000 +€30,000 €38,131 −€17,606
5 €60,000 +€90,000 €34,046 +€16,439
  • Simple payback. At the end of year 3, €30,000 is still unrecovered; year 4 brings €60,000: 3 + 30,000 / 60,000 = 3.5 years.
  • Discounted payback. At the end of year 4, €17,606 in today’s money is unrecovered; year 5 brings €34,046: 4 + 17,606 / 34,046 ≈ 4.5 years.

The year’s difference is the cost of money: at 12%, the project returns the investment noticeably later than the plain sums suggest.

Discounted payback period

Discounted payback is the time it takes the cash flows, converted into today’s money at the discount rate, to return the investment.

It answers the same question as simple payback but accounts for the cost of money.

Discounted payback = Years before payback + Unrecovered amount in today’s money / Discounted cash flow in the payback year

Each year’s discounted flow is CFt / (1 + r)t. Even with equal annual flows there is no shortcut division: the discounted flows shrink every year, so you need the cumulative total.

An illustrative example: €200,000 invested, €50,000 a year, a 10% rate. Simple payback is 200,000 / 50,000 = 4 years.

Year Cash flow Today’s value (10%) Cumulative, today’s value
0 −€200,000 −€200,000 −€200,000
1 €50,000 €45,455 −€154,545
2 €50,000 €41,322 −€113,223
3 €50,000 €37,566 −€75,657
4 €50,000 €34,151 −€41,507
5 €50,000 €31,046 −€10,461
6 €50,000 €28,224 +€17,763

Discounted payback: 5 + 10,461 / 28,224 ≈ 5.4 years — almost a year and a half longer than simple payback.

With equal flows there is a quick check: if the investment multiplied by the rate is equal to or greater than the annual flow, the project never pays back in today’s money — even an endless stream of such flows is worth no more than the investment. €200,000 at 10% needs more than €20,000 a year.

Payback vs discounted payback

Simple payback Discounted payback
Cash flows As they are Converted into today’s money
Cost of money Ignored Included at the discount rate
Result Shorter Longer whenever the rate is above zero
Example: €200,000, €50,000 a year, 10% 4.0 years ≈5.4 years
Flows after payback Ignored Ignored
When to use Quick filter, short projects, low rates Long projects, borrowed money, alongside NPV

If the discounted payback falls within the project’s life, NPV over that life is positive: discounted payback is the point at which the cumulative NPV crosses zero.

Payback period calculator

Enter the investment, the rate and the cash flows by year. The calculator shows simple and discounted payback, plus NPV and IRR — the table below shows how the flows accumulate.

If you are assessing the purchase of an existing business — a café, hotel, laundromat or garage — the calculator based on revenue and costs in the sector articles is more convenient, for example in Buying a café or bar in Spain.

Payback period formula in Excel and Google Sheets

Excel has no built-in payback function — you build it from columns:

  1. Column B holds the flows by year, with the investment as a negative number in B2.
  2. Column C holds the cumulative total: =B2 in C2, =C2+B3 in C3, and so on.
  3. The first year in which the cumulative total turns positive is the payback year. Payback: the previous year’s number + −C(previous) / B(payback year).
  4. For discounted payback, add a column with each flow in today’s money — =B3/(1+rate)^A3, with the year number in column A — and repeat steps 2–3 on it.

What is a normal payback period

There is no single standard — it depends on the risk and on what the owner keeps after payback:

  • A small business without property — café, bar, laundromat, garage — usually aims for 3–5 years: equipment ages and the lease may end.
  • A business with its building — hotel, campsite — pays back in 10–20 years, and that is normal: the owner keeps the building. Here the return on investment matters more.
  • Projects with fast-changing technology need a short payback: in a few years the product may be obsolete.

A very short payback is a warning sign too: if a business “pays for itself in a year”, check revenue against bank statements and tax returns, not the seller’s word.

Payback period and ROI

ROI (return on investment) is the percentage profit the money invested has earned.

ROI = (Return − Investment) / Investment × 100%

In the example, the project brought in €240,000 over five years on €150,000 invested: ROI = 90,000 / 150,000 = 60% over five years, 12% a year on average.

Payback says when the money comes back; ROI says how much it earns over the whole period. Neither accounts for when exactly the money arrived — that takes NPV and IRR.

Payback, NPV and IRR compared

Measure What it shows Accounts for the cost of money Counts flows after payback
Simple payback When the investment comes back No No
Discounted payback When it comes back, at the rate Yes No
ROI Return over the whole period No Yes
NPV Value created, in euros Yes Yes
IRR Annual return Yes Yes

Where the payback period misleads

  • It ignores money after payback. A project that pays back in 3 years and then closes looks better than a 4-year one that then earns for ten years.
  • Simple payback ignores the cost of money. For long projects the gap with discounted payback is years.
  • It depends on the forecast. Payback is only as accurate as the revenue and costs in the financial model.
  • It ignores residual value. A building or a business you can sell does not appear in the payback period.

So payback is a good first filter, but decisions are made on NPV and IRR.

Payback period for a project in Spain

  • Flows are calculated after corporate tax at the 2026 rates: 25% standard, 23% for turnover under €10m, 19% on the first €50,000 and 21% above for turnover under €1m, 15% for a new company in its first profitable year and the next.
  • VAT is left out of the flows, but the timing gap between collecting and paying VAT affects cash in the first months.
  • The investment includes not just the purchase or refit price, but also licences, design, deal taxes and start-up cash.

Frequently asked questions

How do you calculate the payback period?

With an equal annual flow, divide the investment by the annual flow. With uneven flows, add them year by year until the total covers the investment, then add the fraction of the year: the unrecovered amount divided by that year’s flow.

How does discounted payback differ from simple payback?

Discounted payback uses flows converted into today’s money at the discount rate, so it is always longer than simple payback. In the article’s example, 4.5 years against 3.5.

What is a good payback period?

For a small business without property, 3–5 years is the usual guide; for a business with its building, 10–20 years is normal. A very short payback is a reason to check the seller’s figures.

What is the difference between payback period and ROI?

Payback shows when the investment comes back; ROI shows what percentage it earned over the whole period. ROI counts money after payback; the payback period does not.

How do you calculate payback in Excel?

There is no built-in function: add a column with the cumulative total of the flows, find the year it turns positive and add the fraction of the year — the unrecovered amount divided by that year’s flow.

What is the payback period formula?

With equal annual flows: payback period = investment / annual cash flow. With uneven flows: years before payback + unrecovered amount / cash flow in the payback year. For discounted payback, use the flows converted into today’s money.

Can you use the average cash flow to calculate payback?

Only if the flows are roughly equal. With growing flows the average understates payback: in the article’s example it gives 3.1 years instead of 3.5.

Can a project never pay back in discounted terms?

Yes. With equal flows, if the investment multiplied by the discount rate is equal to or greater than the annual flow, the discounted flows never cover the investment, however long the project runs.

Key points about the payback period

  • The payback period is how long the cash flows take to return the investment.
  • Simple payback uses the flows as they are; discounted payback uses today’s values and is always longer.
  • The norm depends on the business: 3–5 years without property, 10–20 with the building.
  • Payback ignores money after payback and residual value.
  • Use payback as a first filter and decide on NPV and IRR.

Sources

Vladislav Panchenko

Have a question about your project?

Leave your contact details — we'll answer your question. If your case needs a closer look, we'll suggest a short call. Free, no obligation.

You will hear from Vladislav Panchenko, founder of Finetic Consulting

Fastest reply — Email us

Or leave your contact and we will get back to you:

Ask a questionWhatsApp

en