The guide in one grid
One book, built up a layer at a time, then back tested. Each layer asks more of your data.
| What it needs | What it gives you | What it can’t see | |
|---|---|---|---|
| Straight Line | This year’s totals and a goal | A year, a count of new accounts and a budget, in an afternoon | The time of year |
| Seasonal | Each month’s revenue, back a few years | The same year, with each month carrying its usual share | Which accounts the year depends on |
| Cohort | Each account’s approval month and what it billed each month | A year built from the accounts that make it | A large account from a small one |
| Power Law | A tier for every account | The few accounts the year depends on, tier by tier | A new account’s tier before it signs |
| Reforecast | The months as they close | Each build made again at the 3+9, the 6+6, the 9+3, or every month | A month already missed |
| Back Testing | Every forecast made again with only what was known at the time | How far off each method lands on the month, the quarter and the year, and how wide its band is | The future: it shows how each method did, not how it will do |
Chapter 1 builds net new in year with the first four. Chapter 2 builds the existing book with the same four, as layers, each starting from the one before. Each section ends with its Reforecast. Chapter 3 adds the two and back tests every method.
Sample data: an invented payments portfolio, no client data.