Step 1
The book entering next year, by when each account was approved. Each cohort’s year is its December times what cohorts of its age billed in a year against their December, in earlier years.
One line per year approved.
| Approved | December revenue | Billing accounts | Year against December | Next year | Next December’s billing accounts |
|---|---|---|---|---|---|
| 2017 and earlier | $458K | 746 | 10.24× | $4,687K | 611 |
| 2018 | $190K | 200 | 10.26× | $1,951K | 161 |
| 2019 | $143K | 195 | 10.25× | $1,464K | 156 |
| 2020 | $169K | 303 | 10.52× | $1,780K | 241 |
| 2021 | $254K | 546 | 10.38× | $2,633K | 435 |
| 2022 | $268K | 678 | 10.29× | $2,754K | 551 |
| 2023 | $322K | 980 | 10.50× | $3,377K | 784 |
| 2024 | $433K | 1,330 | 10.24× | $4,432K | 1,068 |
| 2025 | $507K | 1,656 | 10.18× | $5,160K | 1,317 |
| 2026 | $578K | 2,595 | 9.80× | $5,664K | 1,732 |
| All cohorts | $33,903K |
The two youngest years opened into their months; older years stay one line each.
| Approved | December revenue | Billing accounts | Year against December | Next year | Next December’s billing accounts |
|---|---|---|---|---|---|
| 2017 and earlier | $458K | 746 | 10.24× | $4,687K | 611 |
| 2018 | $190K | 200 | 10.26× | $1,951K | 161 |
| 2019 | $143K | 195 | 10.25× | $1,464K | 156 |
| 2020 | $169K | 303 | 10.52× | $1,780K | 241 |
| 2021 | $254K | 546 | 10.38× | $2,633K | 435 |
| 2022 | $268K | 678 | 10.29× | $2,754K | 551 |
| 2023 | $322K | 980 | 10.50× | $3,377K | 784 |
| 2024 | $433K | 1,330 | 10.24× | $4,432K | 1,068 |
| Jan 2025 | $44K | 124 | 10.63× | $466K | 99 |
| Feb 2025 | $47K | 137 | 9.86× | $461K | 105 |
| Mar 2025 | $36K | 155 | 9.87× | $357K | 122 |
| Apr 2025 | $45K | 134 | 9.91× | $444K | 107 |
| May 2025 | $41K | 124 | 10.30× | $423K | 98 |
| Jun 2025 | $31K | 132 | 10.12× | $309K | 109 |
| Jul 2025 | $41K | 136 | 10.21× | $416K | 109 |
| Aug 2025 | $51K | 141 | 9.76× | $500K | 111 |
| Sep 2025 | $40K | 133 | 10.42× | $412K | 107 |
| Oct 2025 | $30K | 129 | 10.45× | $309K | 104 |
| Nov 2025 | $52K | 156 | 10.42× | $543K | 123 |
| Dec 2025 | $51K | 155 | 10.26× | $520K | 124 |
| Jan 2026 | $35K | 179 | 10.33× | $357K | 135 |
| Feb 2026 | $41K | 208 | 10.03× | $416K | 159 |
| Mar 2026 | $40K | 178 | 9.95× | $397K | 138 |
| Apr 2026 | $69K | 229 | 9.47× | $656K | 163 |
| May 2026 | $69K | 220 | 8.89× | $612K | 150 |
| Jun 2026 | $51K | 220 | 8.84× | $448K | 138 |
| Jul 2026 | $67K | 279 | 8.84× | $593K | 176 |
| Aug 2026 | $77K | 283 | 10.57× | $813K | 218 |
| Sep 2026 | $56K | 279 | 8.99× | $502K | 157 |
| Oct 2026 | $31K | 247 | 9.25× | $286K | 147 |
| Nov 2026 | $26K | 131 | 11.44× | $302K | 73 |
| Dec 2026 | $16K | 143 | 17.63× | $282K | 77 |
| All cohorts | $33,903K |
Where the cohort starts The ratio for its age, from earlier years This layer’s year
The cohorts split Step 2’s start, $3.32M. 2026 includes the accounts still to be approved in November and December, at the plan’s count.
Sample data: an invented payments portfolio, no client data.