Basic: even cash flows recover an equipment purchase
A small bakery buys a $10,000 commercial oven and projects $3,000 of net annual cash inflow for five years from increased production capacity.
ResultCumulative CF runs -$10,000, -$7,000, -$4,000, -$1,000, +$2,000, +$5,000. Payback lands at about 3.33 years, final cash position is +$5,000, and the project is Profitable.
The calculator starts the running total at -$10,000 and adds $3,000 each year. After year 3 the total is -$1,000, and in year 4 the $3,000 inflow overshoots zero, so payback is interpolated as 3 + 1000/3000 ≈ 3.33 years. The final position of +$5,000 is the nominal profit before discounting.
Intermediate: SaaS launch with declining flows
A founder spends $50,000 to launch a SaaS product. Cash inflows peak in year 2 as churn rises and competition increases, producing an uneven payback curve.
ResultRunning totals: -$50,000, -$38,000, -$16,000, +$2,000, +$12,000, +$17,000. Payback occurs in year 3 (interpolated to about 2.89 years), and the final cash position is +$17,000.
Because flows are uneven, you cannot just divide investment by an average. The calculator walks period by period: -$16,000 entering year 3, plus $18,000 in year 3 crosses zero. Payback ≈ 2 + 16000/18000 ≈ 2.89 years. The declining tail flags a re-investment decision before year 5.
Edge case: startup runway that never breaks even
A pre-revenue startup raises $200,000 and burns cash for two years before small inflows begin. Without follow-on funding, the cumulative line stays negative across the projection.
ResultCumulative CF: -$200,000, -$240,000, -$260,000, -$235,000, -$175,000, -$85,000. Payback is shown as Never within five years, and final cash position is -$85,000 (Not Recovered).
Two negative operating years deepen the hole before inflows turn positive. Even after three good years, the project has not climbed back to zero. The Never label tells the founder they need either a longer horizon, larger out-year cash flows, or another funding round to bridge the gap.