The year and the quarter

Each method on the full year and the quarter, from each planning close

Forecast against what billed. 2022 from the December 2021 close; each later year from the October before it.

The whole book, full year

2022202320242025Average size
Straight Line−1.7%+3.3%0.0%−2.9%2.0%
Seasonal−1.7%+3.3%0.0%−2.9%2.0%
Cohort−1.0%+2.2%+3.1%−1.7%2.0%
Power Law−1.3%+1.9%+3.2%−2.1%2.1%
Trend line+9.3%+6.4%+1.6%+1.9%4.8%

Net new in year and the existing book, full year

2022202320242025Average size
Straight Line and Seasonal: net new−8.9%+16.6%−3.7%−0.3%7.4%
Cohort and Power Law: net new−5.4%+10.6%+14.4%+1.9%8.1%
Straight Line: existing book−0.6%+1.6%+0.5%−3.3%1.5%
Seasonal: existing book−0.6%+1.6%+0.5%−3.3%1.5%
Cohort: existing book−0.4%+1.1%+1.6%−2.1%1.3%
Power Law: existing book−0.7%+0.8%+1.6%−2.6%1.4%

The whole book by quarter: average size of the miss, 2022 to 2025

Q1Q2Q3Q4Largest single quarter
Straight Line1.7%4.7%2.1%3.6%−9.0%
Seasonal1.7%2.4%2.3%2.8%−4.8%
Cohort1.6%2.4%2.0%1.9%+4.2%
Power Law1.7%2.5%2.1%2.0%+4.3%
Trend line11.8%3.3%3.7%4.4%+14.8%

5% or more away from what billed

Average size = the size of the miss, whichever way, averaged over the four years. Straight Line and Seasonal bring in the same net new, and so do Cohort and Power Law; the existing book is each one’s own layer from Chapter 2.

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