Step 1

Every cohort on its own line

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.

ApprovedDecember revenueBilling accountsYear against DecemberNext yearNext December’s billing accounts
2017 and earlier$458K74610.24×$4,687K611
2018$190K20010.26×$1,951K161
2019$143K19510.25×$1,464K156
2020$169K30310.52×$1,780K241
2021$254K54610.38×$2,633K435
2022$268K67810.29×$2,754K551
2023$322K98010.50×$3,377K784
2024$433K1,33010.24×$4,432K1,068
2025$507K1,65610.18×$5,160K1,317
2026$578K2,5959.80×$5,664K1,732
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.