Step 3

The time of year

What cohorts billed in each calendar month, against what their age alone says. Two years of data.

JanFebMarAprMayJunJulAugSepOctNovDecAverage
Time-of-year factor0.910.880.980.991.031.051.031.030.991.021.011.071.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.