Acquisition can look attractive in a revenue report while creating a difficult cash gap. A payback worksheet asks when the contribution collected from a defined group of customers covers the cash spent to acquire them. It is an operating planning tool, not a prediction that every customer will repay its cost or a substitute for the business’s full cash forecast.
Define The Group And The Starting Clock
Choose a cohort boundary that links acquisition effort to the customers it produced. That might be a named campaign or opportunities initiated during a specified period. Record acquisition cash outflows when they occurred and retain the lag to customer commitment. Grouping only by contract signing month can hide spending that happened much earlier.
Use a consistent cost boundary. Include the acquisition costs relevant to the decision and disclose exclusions, such as allocated employee time or shared overhead. If sales labor is included as an allocation rather than a separate cash outflow, label it accordingly. Do not compare a media-only cohort with a fully loaded cohort as though their payback measures were equivalent.
Track Collected Contribution Over Time
For each period, record cash actually collected from the cohort and direct cash costs attributable to delivering its work. Keep invoices, contracted revenue and forecast collections in separate columns. Subtract refunds and other relevant reversals. The cumulative collected contribution can then be compared with cumulative acquisition outflows under the chosen boundary.
Timing matters on the cost side too. A prepaid supplier or implementation expense may occur before the corresponding customer receipt. Record that cash use when it occurs instead of spreading it evenly because the presentation looks smoother. The worksheet should expose the largest funding gap as well as the eventual crossing point.
Work Through A Small Cohort
Illustrative example: acquisition requires $12,000 in month zero. The resulting cohort generates collected contribution of $3,000, $4,000 and $5,000 in months one through three after direct delivery cash costs. Cumulative contribution is $3,000, $7,000 and $12,000. Under these simplified assumptions, the cohort reaches acquisition payback at the end of month three.
If the third month’s $5,000 is only an unpaid invoice, payback has not occurred. If an omitted onboarding expense costs $2,000, the calculation changes again. These figures are not industry benchmarks or recommended spending levels. Their purpose is to show why a revenue total and a cash recovery date answer different questions.
Keep Immature Cohorts Visible
Compare cohorts at the same elapsed age. A recent campaign should not be judged against all collections from an older campaign without acknowledging the difference. Show observed receipts separately from scenarios for future receipts. If the recent cohort has not reached payback, report that directly rather than assigning an optimistic lifetime value.
Use a conservative scenario for late payment, refunds or weaker repeat purchases when evaluating another commitment. Explain which assumptions drive the result. An owner may tolerate a longer payback period, but that tolerance should be consistent with available cash, delivery obligations and other investments. There is no universal acceptable month count for every business.
Use The Worksheet To Set Exposure
Before adding a new cohort, estimate how several overlapping cohorts affect cash use. A campaign that eventually pays back can still create strain if the business starts many cohorts before earlier receipts arrive. Include other obligations in the wider cash forecast; acquisition payback alone does not establish overall profitability or solvency.
Assign a person to update actual receipts and costs and to explain material differences from assumptions. The resulting decision may be to slow acquisition, change payment sequencing, improve collection processes or revise the offer. Keep those choices separate from an unsupported claim that the channel itself is ineffective.
Common Questions
Is Revenue Divided By Acquisition Cost Enough?
No. That ratio omits delivery costs and collection timing. It can be a useful descriptive measure, but it does not show when acquisition cash has been recovered.
Should Repeat Purchases Be Included?
Include observed purchases attributable to the cohort within the stated scope. Show forecast repeat purchases separately and explain the assumptions instead of treating them as collected cash.