Payback Period Example: Equal and Uneven Cash Flows

Define the financial payback question

Payback period measures how long the modeled net cash inflows take to recover an initial investment. It is a financial time calculation and has no relationship to a menstrual Period Calculator. Begin with the initial cash outlay at time zero and a schedule of subsequent net cash flows. The word net matters: revenue alone may omit operating cash costs needed to generate it. A payback calculation uses the stated cash-flow schedule; it does not automatically forecast customer demand, identify taxes or estimate an asset's future maintenance requirements.

Use division for equal recurring cash flows

For an initial outlay of 30,000 and a constant net cash inflow of 10,000 per year, ordinary payback is 30,000/10,000=3 years. If the annual amount falls to 7,500, the corresponding result is 4 years. This shortcut applies when the recurring cash-flow assumption is appropriate. It does not mean a project with varying inflows can be summarized by dividing the initial investment by whichever year's figure is easiest to find. Record whether receipts occur evenly during the year or arrive only at the year end, because that affects the interpretation of fractional results.

Accumulate uneven inflows in order

Suppose the initial cost is 30,000 and the next three annual net inflows are 8,000, 11,000 and 16,000. Cumulative recovery is 8,000 after year one, 19,000 after year two and 35,000 after year three. The investment is therefore recovered during the third year if the year-three cash arrives throughout the year. After two full years, 11,000 remains unrecovered. Dividing that balance by the third year's 16,000 gives 0.6875 of a year. Under the even-flow assumption, payback is 2.6875 years, or approximately two years and 8.25 months.

State the timing assumption behind a partial year

If all of the third year's 16,000 arrives as one payment at the end of year three, the cash is not actually recovered at year 2.6875. Recovery occurs at the year-three payment date. The fractional-year formula interpolates within the period; it does not create cash receipts between the specified dates. For monthly data, accumulate the monthly amounts instead of converting an annual total into a fictitious smooth stream. An investment may also fail to recover its initial cost within the available forecast. In that case, report that no payback occurs within the stated horizon.

Compare ordinary and discounted recovery

Ordinary payback adds cash amounts without adjusting for the time value of money. Discounted payback first discounts each future inflow at the chosen rate. At an illustrative 10% annual discount rate, the present values of the three inflows above sum to approximately 28,384.67. This remains below the 30,000 outlay even though undiscounted inflows total 35,000. Thus ordinary recovery occurs within the three-year schedule under the specified timing, while discounted recovery has not occurred by its end. The discount rate is an assumption that must be chosen for the analysis, not a universal constant supplied by the formula.

Keep payback separate from total profitability

A project can recover its initial cost quickly and then generate little additional value, while another may recover more slowly and produce much larger later cash flows. Ordinary payback does not summarize those later benefits. It also differs from an accounting profit measure, which may include noncash expenses such as depreciation. Use net present value or another appropriate analysis when the question concerns value over the complete project life. Payback is useful as a timing measure under a defined schedule, but it cannot by itself rank every investment or replace the assumptions behind the forecast.

Check the arithmetic in a reproducible worksheet

Create columns for period, net cash flow, cumulative cash flow and amount still unrecovered. Use the Scientific Calculator for the individual sums and divisions; it does not accept a complete payback schedule or infer the crossing period. For the uneven example, check 8,000+11,000=19,000, 30,000−19,000=11,000 and 2+11,000/16,000=2.6875. Retain the schedule and timing convention beside the result. If a later cost or withdrawal makes cumulative recovery fall below zero again, describe that event rather than treating the first crossing as a complete picture of the project's cash requirements.

Related guides

Weighted Portfolio Return: Formula and Worked Example

Calculate a portfolio’s single-period weighted return, reconcile it to values, and distinguish it from time-weighted and money-weighted performance.

Calculate IRR in Excel with a Checked Cash-Flow Example

Use Excel IRR for equally spaced cash flows, verify the result with NPV, and distinguish monthly returns, irregular dates and multiple solutions.

Business Margin Calculation: Profit, Cost and Revenue

Calculate business profit margin with a checked example, distinguish margin from markup, and combine product margins using revenue weights.