Where the miss comes from
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 ahead | 3 months | 6 months | 12 months | |
|---|---|---|---|---|
| Straight Line | 0.8 | 1.1 | 1.5 | 1.5 |
| Seasonal | 0.8 | 1.1 | 1.5 | 1.5 |
| Cohort | 0.2 | 0.6 | 1.0 | 1.2 |
| Power Law | 0.2 | 0.6 | 1.0 | 1.2 |
The existing book
| 1 month ahead | 3 months | 6 months | 12 months | |
|---|---|---|---|---|
| Straight Line | 3.2 | 3.2 | 3.4 | 4.9 |
| Seasonal | 0.8 | 1.1 | 1.8 | 3.7 |
| Cohort | 0.6 | 1.0 | 1.7 | 3.1 |
| Power Law | 0.6 | 0.9 | 1.6 | 3.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.