Payback Period Calculator

Use this Payback Period Calculator to find how long it takes to earn back an initial investment using either fixed cash flow per period or a custom cash flow list. You can also turn on discounted payback to account for the time value of money and see a mini schedule that shows the break-even point.

Advanced options
Discounted payback settings
Uneven cash flow list (List mode only)
To reduce mistakes, List mode requires the list length to equal the analysis horizon.
Calculating…
Simple payback (periods)
How many periods it takes for cumulative (not discounted) cash flows to reach the initial investment. If it never happens within the horizon, this shows N/A. Smaller is faster. This ignores the time value of money.
Simple payback (years)
Simple payback converted into years using your selected cash flow period (for example monthly periods are divided by 12). Use this to compare results across monthly vs yearly cash flow inputs.
Per-period discount rate used (percent)
The discount rate applied each period after converting from the annual discount rate using your selected conversion method and cash flow period. This helps you verify the discounting math.
Discounted payback (periods)
How many periods it takes for cumulative discounted cash flows to reach the initial investment. Shows N/A if not recovered within the horizon or if discounted payback is turned off. Discounted payback is usually longer than simple payback when the discount rate is positive.
Discounted payback (years)
Discounted payback converted into years using your selected cash flow period. Good for comparing projects when timing matters.
Payback occurs in period (simple)
The first period where the cumulative amount reaches or exceeds the initial investment. Example: if this is 4, payback happens during period 4.
Unrecovered amount before recovery period (USD)
How much of the initial investment is still not recovered right before the recovery period starts (simple method). If this is 0, payback happened earlier or exactly at a period boundary.
Fraction of the recovery period needed
If payback happens during a period, this shows the fraction of that period needed to break even (0 to 1). Multiply by months per period if you want an approximate number of months into that period.
Remaining unrecovered amount at horizon (USD)
If payback does not happen within the horizon, this shows how much is still unrecovered by the end of the last period. If this is negative, you recovered the investment before the horizon and ended with extra net cash flow.
Mini schedule (first 12 periods and payoff period)
A small table showing period number, cash flow, cumulative cash flow, discounted cash flow, and cumulative discounted cash flow. Includes periods 1 to 12 and also the payoff period if later.
Did we solve your problem today?

How to use our Payback Period Calculator

  1. Choose a Cash flow input mode: Fixed (same cash flow every period) or List (cash flow changes each period).
  2. Enter the Initial investment (USD): the up-front amount you pay at time 0 (use a positive number).
  3. Select the Cash flow period (Monthly, Quarterly, or Yearly). This controls how periods convert to years.
  4. Enter the Analysis horizon (number of periods). This is how far the calculator will check for payback.
  5. If you chose Fixed mode, enter Net cash flow per period (USD).
  6. If you chose List mode, paste Cash flows list (USD, one per period). Make sure the list has exactly the same number of entries as your horizon.
  7. Open Advanced options if you want discounted payback, then check Also calculate discounted payback.
  8. If discounted payback is on, enter Discount rate (annual percent), choose the Discount rate conversion, and choose Cash flow timing (end vs beginning of period).
  9. Click Calculate to see payback in periods and years, the recovery period and fraction, remaining unrecovered at the horizon, and the mini schedule.

Definitions

Initial investment: The money you pay up front at time 0 to start the project.

Cash flow (net cash flow): Money in minus money out during a period. Positive means you gained money; negative means you lost money.

Period: The time step your cash flows use (monthly, quarterly, or yearly).

Horizon (analysis horizon): How many periods you want to check before stopping.

Simple payback period: How long it takes for total cash flows (not discounted) to add up to the initial investment.

Discount rate: A percent used to reduce (discount) future cash flows because money now is worth more than money later.

Discounted payback period: Payback found after discounting each period cash flow first [2].

Present value (PV): What a future cash flow is worth in today dollars after discounting.

Cash flow timing: Whether each period cash flow is treated as arriving at the end of the period (common) or the beginning.

Interpolation (fraction of a period): Estimating how far into the recovery period you break even, using the unrecovered amount divided by that period's cash flow.


Methodology

Overview

This calculator finds the first period where the running total (cumulative) cash flow reaches or passes the initial investment. It works for both fixed cash flows and uneven cash flows, and it uses the same cumulative method for discounted payback (but with discounted cash flows) [1] [2].

Step 1: Set periods per year (m)

m = 12 (monthly), 4 (quarterly), or 1 (yearly)

Step 2: Build the per-period cash flow series

If you use Fixed mode, the cash flow for every period 1 through horizon is the same number. If you use List mode, the list is used as period 1, period 2, and so on, and the list length must exactly match the horizon to avoid silent assumptions.

Step 3: Simple payback (no discounting)

Let CF_t be the net cash flow in period t. Compute a cumulative sum until you hit (or pass) the initial investment.

CumCF_t = sum_{k=1..t} CF_k

Find the smallest recovery period t where CumCF_t >= InitialInvestment. If there is no such t by the horizon, simple payback is N/A.

UnrecoveredBefore = InitialInvestment - CumCF_{t-1}

If CF_t is positive, compute the fraction of the recovery period needed (0 to 1) and the payback in periods.

FractionNeeded = UnrecoveredBefore / CF_t

SimplePaybackPeriods = (t - 1) + FractionNeeded

If CF_t is 0 or negative at a point where interpolation would be needed, the calculator does not divide by 0 or a negative; it keeps searching later periods. If the cumulative total never reaches the initial investment by the horizon, payback stays N/A.

Step 4: Convert annual discount rate to a per-period rate (optional)

Discounting is only used when


Sources