Tutorials › VEE Accounting and Finance › Calculating Simple Payback

VEE Accounting and Finance · IRR, Payback, and Alternatives · Tutorial 459 of 996

Calculating Simple Payback

Calculate the first year in which cumulative undiscounted net project inflows recover the initial investment, and identify when the available cash flows are insufficient to determine payback.

Intermediate 10 min read

What You'll Learn

  • Define simple payback using cumulative undiscounted project cash flows
  • Apply the first-recovery test to level and uneven annual inflows
  • Track the unrecovered investment balance year by year
  • Compare projects without claiming recovery beyond the stated cash-flow horizon
  • Avoid common errors involving timing, signs, and unsupported conclusions

What Simple Payback Measures

A capital project usually requires an outflow before it produces benefits. Simple payback measures how long it takes for the project’s accumulated cash inflows to recover that initial investment. The calculation is deliberately based on undiscounted cash flows: it adds the annual amounts without adjusting them for the time value of money.

The key task is to find the first year in which cumulative net project inflows equal or exceed the initial cost. For projects with uneven annual inflows, this requires keeping a running total rather than dividing the initial investment by one year’s cash flow. The result describes recovery at the annual reporting points; it does not by itself determine whether a project creates value.

Definition: Let \(I_0>0\) be a project’s initial investment at time 0, and let \(F_t\) be its net cash inflow at the end of year \(t\). The cumulative inflow through the end of year \(n\) is \(C_n=\sum_{t=1}^{n}F_t\). The simple payback period, measured in whole years using annual cash-flow data, is the first year \(n\) for which \(C_n\ge I_0\). If no such year occurs within the stated cash-flow horizon, payback has not been established from the available data.

Here, an annual net cash inflow means the project’s cash receipts less its cash operating outflows for that year, using the cash-flow estimates given in the problem. The initial investment is recorded separately at time 0; it is not an annual inflow. If an annual net cash flow is negative, include it with its negative sign when forming the cumulative total.

The definition uses a first-recovery test. If cumulative inflows are below the investment after year 2 but meet or exceed it after year 3, the reported payback is 3 years. The annual data identify the first year-end when recovery has occurred. They do not establish the exact date within that year, so this calculation does not interpolate between annual observations.

Why the Cumulative Test Works

The cumulative calculation is equivalent to tracking the part of the initial investment that has not yet been recovered. Let \(B_n\) denote that unrecovered balance after year \(n\). Start with \(B_0=I_0\). Each year’s net inflow reduces the balance, so after \(n\) years:

$$ B_n=I_0-\sum_{t=1}^{n}F_t=I_0-C_n $$

Recovery has occurred by year \(n\) exactly when the remaining balance is zero or negative. Therefore, \(B_n\le 0\) is equivalent to \(C_n\ge I_0\). Taking the first year that satisfies this condition gives the simple payback period. This also explains why the initial outflow is not added again to annual inflows: it is already represented by the starting balance \(B_0=I_0\).

1
Set the initial amount.
Record the initial investment as a positive amount \(I_0\) to be recovered. Keep the time-0 outflow separate from year-end cash flows.
2
Accumulate year by year.
Add each annual net cash inflow, with its sign, to the cumulative total from prior years.
3
Find the first recovery year.
Identify the first year-end at which the cumulative total is at least the initial investment.
4
Check the conclusion against the data.
If the cumulative total remains below the investment through the last year provided, report that payback is not reached within the stated horizon. Do not infer an unreported future cash flow.

Level Annual Inflows

When the same positive net inflow \(A\) arrives at each year-end, the cumulative inflow after \(n\) years is \(nA\). Under the whole-year convention, payback is the smallest integer \(n\) satisfying \(nA\ge I_0\). This shortcut is useful only when annual inflows are level; with uneven inflows, add each year separately.

Worked Example: Level Inflows Recover the Investment Exactly

A hypothetical equipment project costs $150,000 at time 0 and is expected to generate a net cash inflow of $50,000 at the end of each of years 1 through 4. Find its simple payback period using annual year-end observations.

Method. For level annual inflows, compare the cumulative amount \(nA\) with the initial investment. Here, \(I_0=\$150{,}000\) and \(A=\$50{,}000\).

Year 1: Cumulative inflow is $50,000. The unrecovered balance is $150,000 − $50,000 = $100,000.

Year 2: Cumulative inflow is $50,000 + $50,000 = $100,000. The unrecovered balance is $150,000 − $100,000 = $50,000.

Year 3: Cumulative inflow is $100,000 + $50,000 = $150,000. The unrecovered balance is $150,000 − $150,000 = $0.

The first year with cumulative inflows of at least $150,000 is year 3. The simple payback period is 3 years. The check is direct: three annual inflows total \(3\times \$50{,}000=\$150{,}000\), exactly the initial investment.

Common mistake avoided: Counting the time-0 investment as if it were a year-1 inflow would shift the timeline and give an incorrect answer. The investment is the amount to recover; the first $50,000 inflow arrives at the end of year 1.

Uneven Annual Inflows

If annual cash inflows differ, there is no single annual amount to divide into the investment. Accumulate each year’s actual net inflow in sequence and stop at the first year that meets or exceeds the investment. A table helps make the timing and the recovery test visible.

Worked Example: Uneven Inflows Cross the Investment in Year 4

A hypothetical service-center project requires an initial investment of $240,000. Its estimated net cash inflows at the ends of years 1 through 5 are $55,000, $65,000, $70,000, $80,000, and $45,000, respectively. Determine the simple payback period.

Method. Add the uneven annual inflows cumulatively and compare each year-end total with \(I_0=\$240{,}000\).

End of year 1: \(C_1=\$55{,}000\). Unrecovered balance: $240,000 − $55,000 = $185,000.

End of year 2: \(C_2=\$55{,}000+\$65{,}000=\$120{,}000\). Unrecovered balance: $240,000 − $120,000 = $120,000.

End of year 3: \(C_3=\$120{,}000+\$70{,}000=\$190{,}000\). Unrecovered balance: $240,000 − $190,000 = $50,000.

End of year 4: \(C_4=\$190{,}000+\$80{,}000=\$270{,}000\). The cumulative inflow now exceeds the investment by $270,000 − $240,000 = $30,000.

At the end of year 3, cumulative inflows are still below the investment, while at the end of year 4 they are above it. Therefore, the first year-end recovery occurs in year 4, so simple payback is 4 years at the stated annual resolution.

Check: The first three inflows total $190,000, which is less than $240,000. Including year 4 gives $270,000, which is at least $240,000. Both sides of the first-recovery test are verified.

Common mistake avoided: Dividing $240,000 by the first-year inflow of $55,000 would treat the first year’s amount as if it continued every year. It does not. The year-by-year cumulative method uses all four actual inflows and identifies the correct recovery year.

When the Data Do Not Show Recovery

A payback calculation cannot establish recovery beyond the cash-flow information supplied. In particular, if cumulative inflows are still less than the initial investment at the end of the last listed year, the supported conclusion is that the project has not paid back within the stated horizon. A future year may eventually bring recovery, but that requires a cash-flow estimate that is not yet available in the problem.

Worked Example: Compare Recovery Without Inventing a Missing Year

Two hypothetical projects have the following initial investments and annual net cash inflows, all in thousands of dollars:

Project X costs $125,000 and has inflows of $50,000, $45,000, and $40,000 in years 1, 2, and 3. Project Y costs $160,000 and has inflows of $70,000, $45,000, and $40,000 in years 1, 2, and 3. No year-4 inflows are provided. Determine what can be concluded about their payback.

Project X. After year 1, cumulative inflows are $50,000. After year 2, they are $50,000 + $45,000 = $95,000. After year 3, they are $95,000 + $40,000 = $135,000. The first two totals are below the $125,000 investment, and the third is above it. Project X pays back in 3 years.

Project Y. After year 1, cumulative inflows are $70,000. After year 2, they are $70,000 + $45,000 = $115,000. After year 3, they are $115,000 + $40,000 = $155,000. The $155,000 total is $5,000 short of the $160,000 investment.

Project Y has not recovered its investment by the end of year 3. No year-4 inflow is given, so its eventual payback period cannot be determined. Project X is the only project with established recovery in the supplied period; the data do not establish that Project Y pays back in year 4.

Common mistake avoided: Assigning Project Y a 4-year payback merely because it has not recovered by year 3 assumes an unreported year-4 cash flow. The cumulative total of $155,000 is below $160,000, and without additional data there is no valid year-4 calculation.

Common Calculation Checks

Before reporting a simple payback period, verify the timing, signs, and cumulative totals. These checks are especially useful when cash flows are uneven or when the question provides only a limited forecast horizon.

  • Use cash flows, not an accounting profit figure. Accumulate the project’s stated net cash inflows. Do not substitute earnings unless the problem has explicitly converted them into the relevant cash flows.
  • Keep the initial investment at time 0. It is the target amount to be recovered, not an additional annual inflow or a year in the payback count.
  • Do not discount the inflows. Simple payback uses the stated cash amounts without a discount factor. Applying an interest rate changes the calculation to a different measure.
  • Respect negative cash flows. If a year’s net project cash flow is negative, add that signed amount; do not treat every listed figure as a positive inflow.
  • Do not claim a year that is not supported. If the investment is unrecovered after the final year listed, report that fact rather than assuming a later inflow.
Key takeaway: Simple payback is the first year-end at which cumulative undiscounted net project inflows equal or exceed the initial investment. For uneven cash flows, calculate the cumulative total one year at a time, and report no recovery within the available horizon if the threshold is never reached.

Check Your Understanding

For each problem, use annual year-end cash flows and report payback in whole years based only on the years provided.

  1. A hypothetical laboratory upgrade costs $80,000 and generates net inflows of $20,000, $30,000, and $30,000 in years 1 through 3. In which year is the investment first recovered? (Answer: 3 years.)
  2. A hypothetical distribution project costs $145,000 and has annual net inflows of $35,000, $45,000, $50,000, and $20,000. Find its simple payback period. (Answer: 4 years.)
  3. A hypothetical software platform requires $200,000 initially. Its net inflows are $60,000, $55,000, $50,000, and $40,000 in years 1 through 4. Has it paid back by year 4? (Answer: Yes; cumulative inflows are $205,000, so payback is 4 years.)
  4. Project A costs $100,000 and produces inflows of $40,000, $35,000, and $30,000 in years 1 through 3. Project B costs $130,000 and produces inflows of $50,000, $40,000, and $35,000 in those years. No later inflows are provided. State each supported conclusion. (Answer: A pays back in year 3; B has not paid back by the end of year 3, and its eventual payback cannot be determined.)
  5. A hypothetical retrofit costs $120,000 and has net cash flows of $50,000 in year 1, $45,000 in year 2, −$10,000 in year 3, and $40,000 in year 4. Find the simple payback period, including the year-3 cash flow with its sign. (Answer: 4 years; cumulative inflows are $50,000, $95,000, $85,000, and $125,000, so recovery first occurs in year 4.)
Clinical Biostats