The strength of each method
The whole book, all five methods: the size of the miss, whichever way, averaged over every close from December 2021 to September 2026.
A distance shows only where 12 or more closes stand behind it. Straight Line and Seasonal stop at 12 months: a December close reaches no further, so past 12 months they would be read from a different set of closes.
Cohort and Power Law sit on top of each other: the tiers split the same year, they don’t change its size.
The trend line steps up past 12 months. That’s where December closes start forecasting January, and a line drawn through the last twelve totals runs well over a low month.
| Straight Line: Typical size | Straight Line: Closes | Seasonal: Typical size | Seasonal: Closes | Cohort: Typical size | Cohort: Closes | Power Law: Typical size | Power Law: Closes | Trend line: Typical size | Trend line: Closes | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 month ahead | 3.6% | 58 | 1.4% | 58 | 0.6% | 58 | 0.6% | 58 | 6.2% | 58 |
| 2 months ahead | 3.6% | 57 | 1.7% | 57 | 1.0% | 57 | 1.0% | 57 | 7.0% | 57 |
| 3 months ahead | 3.7% | 56 | 2.0% | 56 | 1.3% | 56 | 1.3% | 56 | 7.4% | 56 |
| 4 months ahead | 3.7% | 55 | 2.4% | 55 | 1.7% | 55 | 1.7% | 55 | 7.6% | 55 |
| 5 months ahead | 3.8% | 54 | 2.8% | 54 | 2.1% | 54 | 2.1% | 54 | 7.9% | 54 |
| 6 months ahead | 4.1% | 53 | 3.3% | 53 | 2.4% | 53 | 2.4% | 53 | 7.9% | 53 |
| 7 months ahead | 4.3% | 52 | 3.6% | 52 | 2.7% | 52 | 2.7% | 52 | 7.4% | 52 |
| 8 months ahead | 4.6% | 51 | 4.0% | 51 | 3.0% | 51 | 3.0% | 51 | 6.9% | 51 |
| 9 months ahead | 5.0% | 50 | 4.3% | 50 | 3.3% | 50 | 3.3% | 50 | 6.5% | 50 |
| 10 months ahead | 5.5% | 49 | 4.6% | 49 | 3.5% | 49 | 3.5% | 49 | 6.6% | 49 |
| 11 months ahead | 5.9% | 48 | 4.9% | 48 | 3.7% | 48 | 3.8% | 48 | 6.1% | 48 |
| 12 months ahead | 6.0% | 47 | 5.0% | 47 | 4.0% | 47 | 4.1% | 47 | 7.5% | 47 |
| 13 months ahead | 4.0% | 46 | 4.1% | 46 | 10.5% | 46 | ||||
| 14 months ahead | 4.0% | 45 | 4.0% | 45 | 11.3% | 45 | ||||
| 15 months ahead | 3.8% | 44 | 3.9% | 44 | 11.6% | 44 | ||||
| 16 months ahead | 3.7% | 43 | 3.7% | 43 | 11.6% | 43 | ||||
| 17 months ahead | 3.5% | 42 | 3.5% | 42 | 12.1% | 42 | ||||
| 18 months ahead | 3.2% | 41 | 3.3% | 41 | 12.1% | 41 | ||||
| 19 months ahead | 3.0% | 40 | 3.0% | 40 | 11.1% | 40 | ||||
| 20 months ahead | 2.8% | 39 | 2.7% | 39 | 10.3% | 39 | ||||
| 21 months ahead | 2.6% | 38 | 2.5% | 38 | 10.2% | 38 | ||||
| 22 months ahead | 2.3% | 37 | 2.3% | 37 | 10.0% | 37 | ||||
| 23 months ahead | 2.4% | 36 | 2.3% | 36 | 9.1% | 36 | ||||
| 24 months ahead | 2.5% | 34 | 2.4% | 34 | 10.9% | 35 |
Sample data: an invented payments portfolio, no client data.