Where the miss comes from

Typical miss by months ahead, net new in year and the existing book

In points of the whole book’s month: each part’s miss ÷ what the whole book billed. Every close from December 2021 to September 2026.

Net new in year

1 month ahead3 months6 months12 months
Straight Line0.81.11.51.5
Seasonal0.81.11.51.5
Cohort0.20.61.01.2
Power Law0.20.61.01.2

The existing book

1 month ahead3 months6 months12 months
Straight Line3.23.23.44.9
Seasonal0.81.11.83.7
Cohort0.61.01.73.1
Power Law0.60.91.63.2

The two parts don’t add up to the whole book’s typical miss: in the same month one part can miss high while the other misses low. The trend line is drawn through the whole book’s totals, so it has no split.

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