Step 3
What cohorts billed in each calendar month, against what their age alone says. Two years of data.
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Average | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Time-of-year factor | 0.91 | 0.88 | 0.98 | 0.99 | 1.03 | 1.05 | 1.03 | 1.03 | 0.99 | 1.02 | 1.01 | 1.07 | 1.00 |
| Against an average month | −9% | −12% | −2% | −1% | +3% | +5% | +3% | +3% | −1% | +2% | +1% | +7% |
The factor = billed in that calendar month ÷ (accounts × the age curve), over the last 24 months, set to average 1.00.
Sample data: an invented payments portfolio, no client data.