Business math, made visible
Payback period calculator
Payback period calculator
Find how long constant cash inflows take to recover cost.
Inputs stay in this browser. Results use your entries and the formula below.
This simple payback period calculator divides an initial investment by a constant annual net cash inflow or net operating savings amount. The result shows the recovery time in years and the equivalent months. The EPA example uses an equipment purchase and annual savings to demonstrate the method. This page is for uniform cash flows. It does not discount future amounts, build a year-by-year cash flow schedule, or evaluate benefits that occur after the cost has been recovered.
Worked example
| Source item | Published value |
|---|---|
| Equipment total cost | $120,000 |
| Expected savings per year | $48,000 |
| Payback period | 2.5 years |
The EPA Organizational Guide to Pollution Prevention gives this equipment example. Dividing $120,000 by $48,000 gives 2.5 years. The month figure in the calculator is a unit conversion of that result. Source: EPA: Organizational Guide to Pollution Prevention.
How it works
Simple payback period (years) = initial investment / annual net cash inflow
Formula basis: EPA: Organizational Guide to Pollution Prevention. Ratios are converted to percentages for display. Intermediate values retain full calculation precision; displayed amounts are rounded.
Use net annual savings or net cash inflow
Use the annual amount available to recover the initial cost after the relevant recurring costs. Revenue alone is not necessarily the money available for payback. For a cost-saving purchase, record what the savings include and exclude. If a quoted savings amount leaves out additional annual maintenance, entering it without adjustment would describe a different scenario. The tool cannot infer operating costs from an investment amount.
Understand the uniform-flow assumption
The division assumes the same annual inflow continues and is earned evenly over time when a fractional year is reported. If receipts happen only at year end, the fractional result should not be read as the exact date money arrives. If cash flows vary, accumulate a period-by-period schedule and find when cumulative net inflows recover the initial investment. That schedule is a different calculation from the constant-flow tool on this page.
Use recovery time alongside other measures
Payback answers a timing question within its limited model. It does not supply a percentage return, and it leaves cash flows after recovery outside the measure. It also does not account for the time value of money. The EPA source discusses a more detailed profitability analysis for projects with significant capital costs. Compare this timing result with ROI only when the inputs and periods describe the same project.
Use the formula in a spreadsheet
With initial investment in A1 and constant annual net cash inflow in B1, use =A1/B1 for years. Multiplying that result by 12 gives equivalent months. Keep annual and monthly cash-flow inputs separate rather than changing the label on an unchanged number.
Frequently asked questions
What is the simple payback formula?
Divide the initial investment by constant annual net cash inflow or net operating savings. The result is in years when the inflow is annual.
How do I calculate payback in Excel?
Use =A1/B1 with initial investment in A1 and annual net cash inflow in B1. This works for the constant-flow model.
Is this discounted payback?
No. The tool does not apply a discount rate. Discounted payback requires a discounted cash-flow schedule.
Can I calculate payback in months?
The tool shows years and equivalent months. Its input remains an annual inflow, so convert monthly figures to a consistent annual amount first.
What if annual cash inflow is zero or negative?
The calculator requires a positive annual inflow. A constant zero or negative inflow cannot recover a positive initial investment in this model.
What if cash flows change each year?
Do not use this constant-flow result as the exact recovery time. Use a cumulative cash-flow schedule that preserves the amount and timing of each receipt.
Sources
Data as of 2026-10-05. Examples are historical teaching examples, not current prices or market benchmarks. Calculated results are derived from entered values.
Return to the business calculator hub to choose another measure.