Step 1

Every year the book came in

The existing book entering each year: every account approved before January, at what it billed in December.

EnteringDecember revenueOf it, last year’s new accountsBilling accountsOf them, last year’s newNext December’s revenueRevenue keptNext December’s billing accountsAccounts kept
2021$2.10M$385K5,6311,471$1.79M85.4%4,28076.0%
2022$2.30M$508K6,2311,951$1.97M85.6%4,73976.1%
2023$2.58M$609K6,8512,112$2.18M84.6%5,14275.1%
2024$2.73M$555K7,5852,443$2.38M87.2%5,69575.1%
2025$3.02M$634K8,2892,594$2.58M85.5%6,17974.5%
2026$3.22M$639K8,7602,581$2.74M85.2%6,63475.7%
Average, 2021 to 202585.6%75.3%

What billed   Still billing a year later   Forecast at the October close (Step 2)   The rate the accounts line uses

A billing account billed more than zero that month. Last year’s new accounts join the book heading into January. An older account not billing in December has closed and isn’t counted.

Sample data: an invented payments portfolio, no client data.