Finance · Capital recovery

Payback Period: Formula, Discounted Payback, and Worked Examples

Payback period measures how long a project takes to recover its initial cash outlay. It is useful for discussing exposure and recovery timing, but it does not measure all the value an investment creates. This guide explains ordinary and discounted payback using the same equipment project as the NPV and IRR guides.

← Finance hub · NPV · IRR

The payback formulas

For a simple initial outlay followed by equal annual net inflows, ordinary payback = initial investment ÷ annual net cash inflow. Use that shortcut only when the equal-flow and timing assumptions fit.

For uneven flows, build a cumulative schedule. Where cash is reasonably assumed to arrive evenly during the recovery year, a common approximation is:

Use incremental cash flows, not accounting profit. Include the initial working-capital commitment and other project cash costs. Later large outflows can make “recovered” cash turn negative again, so inspect the full timeline and define the recovery measure carefully.

The shared equipment project

Original hypothetical example: equipment and installation cost $100,000 today and require $10,000 of incremental working capital. Future operating cash flows are assumed incremental after operating cash costs and project cash taxes, before financing flows. Year 4 includes $5,000 after-tax disposal proceeds and $10,000 working-capital recovery.

All future flows arrive at year-end. The annual discount rate for discounted payback is an illustrative 10%. There are no other cash flows.

Ordinary payback: accumulate the cash flows

Exact ordinary payback is 4 years under the stated year-end timing. After Year 3, $5,000 remains unrecovered. No additional cash is received until the end of Year 4, so the recovery date cannot be moved earlier without changing the timing assumptions.

The $50,000 final undiscounted surplus is not NPV. It simply subtracts the $110,000 outlay from $160,000 of total future inflows without allowing for the time value of money.

Why a fractional answer needs a timing assumption

Change only the Year 4 operating timing for a separate approximation: suppose its $40,000 operating inflow arrives evenly during the year, while $15,000 of terminal proceeds still arrives at year-end. The unrecovered $5,000 would be covered after $5,000 ÷ $40,000 = 0.125 of that year, producing an approximate ordinary payback of 3.125 years.

Do not divide $5,000 by the entire $55,000 and report 3.09 years as exact. That would spread the equipment sale and working-capital release across the year, even though the model says they arrive at the end.

The 3.125-year result uses a different within-year cash pattern from the shared year-end model. If that timing becomes the valuation assumption, recalculate NPV and IRR with an appropriate time grid instead of carrying over the year-end results unchanged.

Discounted payback at 10%

For each future flow, calculate present value = cash flow ÷ (1.10)^year. Then accumulate those present values, including the initial −$110,000 at time zero.

Discounted payback is also 4 years under the stated year-end timing. Both methods happen to cross zero on the same scheduled receipt date, but the remaining exposure and final surplus are very different. The final cumulative discounted amount is the project’s NPV at 10%.

Dividing the Year 3 discounted shortfall by the Year 4 discounted total would produce an interpolation estimate, not an exact recovery date for these year-end cash flows. A more detailed model needs the actual or explicitly assumed dates of receipts.

A second example: discounting delays recovery

Consider a separate project costing $120,000 today and paying $40,000 at each year-end for four years. Ordinary payback is exactly 3 years, since three receipts total $120,000.

At a 10% required return, the first three receipts have a combined present value of only $99,474.08. Adding the fourth receipt increases their total present value to $126,794.62. Discounted payback is therefore 4 years under this year-end timing.

If this second project ended after Year 3, it would meet ordinary payback but never achieve discounted payback within its life at 10%. Recovering nominal dollars is not the same as earning the required return.

Use payback as a screen, not a value ranking

A company may set a maximum recovery period because capital is scarce, technology changes quickly, or management wants to limit exposure. Document that policy and its purpose. There is no single required cutoff that makes every project acceptable.

In the shared project, a strict 3.5-year cutoff would reject the investment under the year-end timing even though NPV is positive at 10%. That conflict makes the tradeoff visible: the cutoff limits recovery time, while NPV measures estimated total value at the required return.

Payback also ignores cash flows after the recovery point. Two projects can pay back on the same date and then generate very different benefits. Discounted payback addresses the time-value issue but still ignores later value when used as a recovery-only ranking.

Build the schedule in Excel

Put years 0–4 in A2:A6 and project cash flows −110000, 30000, 35000, 40000, and 55000 in B2:B6. Put 10% in E2.

• Cumulative ordinary cash: enter =SUM($B$2:B2) in C2 and copy down.
• Present value: enter =B2/(1+$E$2)^A2 in D2 and copy down.
• Cumulative discounted cash: enter =SUM($D$2:D2) in F2 and copy down.

With the stated year-end timing, identify the first future scheduled date at which each cumulative series reaches zero or becomes positive. If no crossing occurs during the forecast life, report “not recovered within the modeled life,” rather than extending a fraction beyond the available cash flows.

For a real project with irregular dates, retain dates and model their timing explicitly. Do not assume annual, quarterly, and monthly periods are interchangeable.

Compare the three methods

Read NPV and IRR for the same project’s value and return calculations. None of these methods guarantees the forecast cash flows will occur.

Common mistakes

• Using net income instead of project cash flow.
• Omitting initial working capital or later cash commitments.
• Dividing initial investment by an average inflow when annual flows are uneven.
• Spreading terminal proceeds across a year to manufacture a fractional payback.
• Calling ordinary payback a discounted measure.
• Ignoring later outflows that can make cumulative cash negative again.
• Choosing the fastest payback without examining total value, risk, and feasibility.

Frequently asked questions

Is a shorter payback always better?

It recovers the initial cash sooner on the modeled timeline, but it may sacrifice later value. Review the whole project and the reason for the cutoff.

What if the investment never pays back?

Report that it is not recovered within the modeled life and show the remaining shortfall. Do not imply future receipts without forecasting and supporting them.

Does payback measure cash available to the business?

It measures cumulative project recovery, not the entire company’s cash balance. Other receipts, payments, restrictions, and financing still matter.

Continue learning

Connect the project to Rolling Forecasts and short-term cash planning. Return to Finance.

Sources and example notes

• OpenStax: Payback Period Method — recovery concept and limitations.
• OpenStax: Alternative Methods — discounted payback context.

The project, timing comparisons, calculations, Excel schedule, and decision discussion are original educational illustrations. Actual dates and investment assumptions require validation.