Payback Period & Capital Recovery Lab

Model simple and discounted payback periods, cumulative recovery milestones, hurdle rates, and post-payback profitability.

Scenario presets

Initial Outlay & Cash Flow Parameters

Payback & Liquidity Metrics

Calculating payback...

Payback
Simple (undiscounted) payback period
-
Discounted payback period
-
Time value of money drag
-
Total undiscounted cash inflows
-
Net undiscounted profit
-
Post-payback cash flow multiple
-
5-Year Net Present Value (NPV)
-

Cumulative Capital Recovery & Cash Flow Schedule

Compare undiscounted cash flow accumulation against present value recovery milestones.

Cumulative capital recovery schedule comparing undiscounted and discounted cash flows, cumulative balances, and unrecovered outlays.
PeriodCash Flow ($)Cumulative Cash ($)Discounted CF ($)Cumulative DCF ($)Capital Status

Sensitivity Analysis 1: Initial Outlay vs. Average Annual Inflow on Simple Payback (Years)

Payback period duration across capital expenditure fluctuations and annual cash generation.

Simple payback period by initial outlay and annual inflow. Rows change outlay, columns change annual inflow.
Outlay \ Annual Inflow$15,000$20,000$25,000 (Base)$30,000$35,000

Sensitivity Analysis 2: Average Annual Inflow vs. Discount Rate on Discounted Payback (Years)

Time value impact: capital recovery timeline as cost of capital or financing rates escalate.

Discounted payback period by annual inflow and discount rate. Rows change annual inflow, columns change discount rate.
Annual Inflow \ Discount Rate6.0%8.0%10.0% (Base)12.0%14.0%

Formulas and worked example

  • Simple Payback (Equal Cash Flows) = Initial Outlay / Annual Cash Inflow
  • Simple Payback (Unequal Cash Flows) = $A + (B / C)$, where $A$ is the last period with a negative cumulative balance, $B$ is the unrecovered cost at the end of period $A$, and $C$ is the cash inflow during period $A+1$.
  • Discounted Cash Flow = $\text{CF}_t / (1 + r)^t$
  • Time Value Drag = Discounted Payback Period - Simple Payback Period
  • Post-Payback Cash Multiple = Total Lifetime Inflows / Initial Outlay

An enterprise invests $50,000 into robotic process automation generating $25,000 annually in operating savings for 5 years at a 10.0% discount rate. The simple payback period is exactly 2.00 years ($50,000 / $25,000). Applying the 10.0% cost of capital, Year 1 discounted cash flow is $22,727 and Year 2 is $20,661 (cumulative $43,388, leaving $6,612 unrecovered). With Year 3 discounted inflow at $18,783, discounted payback occurs at $2.00 + (6,612 / 18,783) = 2.35$ years. The 0.35-year (4.2-month) difference represents the time value of money drag. Total 5-year cash inflows reach $125,000 (2.50x initial outlay), producing an NPV of $44,770.

Self-check quiz

1. Why does the discounted payback period always equal or exceed the simple payback period (for positive interest rates)?

2. Which major flaw of the simple payback method is partially resolved by discounted payback?

3. A project costs $100,000 and returns $40,000 in Year 1, $40,000 in Year 2, and $40,000 in Year 3. Its simple payback period is:

4. Why might a CFO prefer an investment with a 2-year payback over an alternative with a 4-year payback, even if the second has higher total lifetime cash flows?

Frequently asked questions

What is the payback period and how is it calculated?

The payback period measures the amount of time required for an investment's cumulative cash inflows to equal its initial cash outlay. For constant annual inflows, it equals Initial Outlay divided by Annual Cash Inflow. For uneven cash flows, it is calculated by adding annual inflows until cumulative cash flow turns positive, interpolating the exact fractional year.

What is the key difference between simple payback and discounted payback?

Simple payback evaluates nominal undiscounted cash flows, ignoring the time value of money and opportunity cost of capital. Discounted payback applies a hurdle rate or WACC to discount future cash flows to present value before evaluating break-even, resulting in a longer and more financially conservative recovery timeline.

What are the primary limitations of relying solely on the payback period?

The payback period has two major flaws: it ignores the time value of money (unless discounted payback is used) and it completely disregards all cash flows generated after the payback cutoff date, potentially rejecting highly profitable long-term infrastructure or innovation projects.

How do businesses establish an acceptable payback benchmark?

Firms establish target payback cutoffs based on industry risk, liquidity constraints, and technology obsolescence cycles. High-tech or fast-moving industries often require payback within 1.5 to 3 years, while capital-intensive manufacturing and utilities accept 5 to 10-year recovery horizons.