Forecasting: Revenue
Next year's forecast on one book: net new in year and the existing book, each built four ways and reforecast as the months close, then back tested against what was billed.
3 chapters, about 38 minutes in all · A guide by Broad Eye Solutions · Version 1.0 · Updated November 14, 2026
3 chaptersAll chapters
Next year’s forecast is due before the year closes, and everyone from the board to the sales floor will be held to it. This guide builds it on one book, an invented payments portfolio with sample data and no client data.
Chapter 1 covers net new in year: the revenue from accounts approved during the year, in the months they bill that year. It builds next year four ways. Straight Line is the number you can have in an afternoon, drawn as a straight line through the months. Seasonal gives the same number the shape of the year. Cohort rebuilds the year from each month’s new accounts. Power Law splits those accounts by size. Each section ends in a complete forecast and a Reforecast: the same build made again at the 3+9, the 6+6, the 9+3 and every month.
Chapter 2 takes the existing book, the accounts already billing when the year starts and most of next year’s revenue, as a layer cake built the way Chapter 1 builds net new: Straight Line from this year closed out plus this year’s new accounts, then the time of year, then every cohort, then every tier.
Chapter 3 adds the two for the whole book, then back tests every method, plus the trend line most teams reach for during the year. It makes each forecast again at every past close, with only what was known at the time, and sets it against what was billed, out as far as 24 months.
What it finds, in one line: twelve months ahead, the builds made from the accounts missed the whole book’s month by 4.1% on average, against 5.0% for Seasonal and 6.0% for Straight Line. On next year’s new accounts, every method is only as good as the plan’s count.
Each layer adds what the one before it left out, and each asks more of your data. Each section begins with what you’ll need and what it starts from, and ends with what it can’t tell you.
Every step has a grid with the numbers filled in, so you can lay your own book out the same way.
Terms used in the guide
- Net new in year: revenue from accounts approved during the year, in the months they bill that year.
- Existing book: the accounts already billing when the year begins.
- Revenue: what each account billed in the month, as on its statement.
- PY and IY: the prior year, and the year you’re in.
- Close: a month-end close. The 3+9 means three months closed and nine forecast; the 6+6 and 9+3 the same way.
- Straight line: January at this year’s January share of the year, and every month after moving by the same step, so the months add up to the year.
- Entering book: every account approved before January, at what it billed in December. Last year’s new accounts join it heading into January.
- Kept: the share of the entering book’s December revenue, or of its billing accounts, still there the next December.
- Cohort: accounts grouped together and followed over time. This guide’s cohort is the approval month: the month each account was created in the system the revenue comes from. Any other grouping every account carries, such as its tier, splits those lines further.
- Age curve: what an account bills in its first month on the book, its second, and so on.
- Time-of-year factor: how a calendar month bills against an average month, with the accounts’ ages taken out.
- Tier: an account’s size class, A to D, cut by Power Law Nested Means: split the accounts at their average, then split the ones above it at their own average and the ones below it at theirs. New accounts are still growing into their size, so Chapter 1 cuts them on monthly volume and keeps the best tier each has reached. The existing book has settled, so Chapter 2 cuts it on what each account billed over the last twelve months.
- Plan’s count: the number of new accounts the plan expects, here 10% more than this year.
- Miss: a forecast against what billed. + means the forecast ran over what billed, − that it ran under.
- Average miss: the miss with its sign, averaged over every close.
- Typical miss: the size of a forecast’s miss, whichever way, averaged over every close.
- Band: the average miss plus or minus one standard deviation.
The guide, chapter by chapter
- 1Net New In YearNext year’s new accounts four ways: Straight Line, Seasonal, Cohort and Power Law, each reforecast as the months close.18 min read
- 2Existing BookThe accounts already on the book, the same four ways, each reforecast as the months close.10 min read
- 3Back TestingThe whole book four ways, then every method made again from each close since 2021, against what billed.10 min read
Where the guide lands you
Three chapters, each layer adding what the last one left out, and each asking a little more of your data.
- Straight Line gets you a number, a count, a budget and a straight line through the months in an afternoon.
- Seasonal gives the same number the shape of the year.
- Cohort builds the year from the accounts that make it.
- Power Law splits each line by the size of the account, and shows how much of the year rests on a few of them.
- Each build can be made again at every close: the 3+9, the 6+6, the 9+3 or every month.
- The existing book is built in the same four, as layers, each starting from the one before, and with net new in year it makes the whole book.
- The back test shows which to trust, and for what. On the months and the quarters, the builds made from the accounts land closest and hold the tightest band, out to two years. On the year, Straight Line and Seasonal are level with them, and on net new every method is only as good as the plan’s count.
Straight Line gets you a number in an afternoon. What the layers add is the shape of the year, and a tighter band for the months and quarters ahead.
The working files
The files behind this guide are on GitHub: BroadEyeSolutions/power-law-forecasting-revenue. They hold the grids as an Excel workbook with live formulas, each table as a CSV file, templates for your own book, an engine that runs every step and the back test, and instructions an AI can follow to reproduce the guide’s numbers before it builds yours. The repository carries Straight Line, Seasonal and Cohort. Power Law, which splits each cohort by tier, is built in this guide.