Step 2
The existing book. November and December haven’t closed, so they’re forecast from how last year’s book finished. Each year’s new accounts join the book heading into January.
Revenue
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Year | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PY (last year) | $2.49M | $2.43M | $2.66M | $2.70M | $2.74M | $2.69M | $2.66M | $2.65M | $2.47M | $2.46M | $2.46M | $2.58M | $30.99M |
| + Last year’s new | $0.64M | ||||||||||||
| IY (this year) | $2.67M | $2.59M | $2.83M | $2.83M | $2.88M | $2.84M | $2.82M | $2.83M | $2.65M | $2.66M | $2.62M | $2.74M | $32.96M |
| January as a share of IY | 8.11% | ||||||||||||
| + This year’s new | $0.58M | ||||||||||||
| NY (next year) | $2.76M | $2.77M | $2.78M | $2.80M | $2.81M | $2.83M | $2.84M | $2.86M | $2.87M | $2.88M | $2.90M | $2.91M | $34.01M |
Billing accounts
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PY (last year) | 8,094 | 7,862 | 7,644 | 7,443 | 7,249 | 7,067 | 6,893 | 6,728 | 6,578 | 6,436 | 6,318 | 6,179 |
| + Last year’s new | 2,581 | |||||||||||
| IY (this year) | 8,558 | 8,307 | 8,084 | 7,873 | 7,697 | 7,534 | 7,337 | 7,177 | 7,041 | 6,910 | 6,783 | 6,634 |
| + This year’s new | 2,595 | |||||||||||
| NY (next year) | 9,040 | 8,850 | 8,661 | 8,471 | 8,281 | 8,092 | 7,902 | 7,713 | 7,523 | 7,333 | 7,144 | 6,954 |
The math
| Value | How it is worked out | |
|---|---|---|
| PY, December | $2,579,320 | the PY row’s December |
| Last year’s new accounts, December | $638,776 | Chapter 1: PY’s December |
| IY’s book came in at | $3,218,096 | = PY December + last year’s new accounts |
| IY, January to October (closed) | $27,597,180 | the closed IY cells, added up |
| November and December as a share of PY | 16.3% | PY: (Nov + Dec) ÷ the year |
| IY, the full year | $32,958,209 | = closed ÷ (1 − that share) |
| IY, December | $2,742,724 | = the full year × PY’s December share |
| This year’s new accounts, December | $577,966 | Chapter 1: IY’s December |
| NY’s book comes in at | $3,320,689 | = IY December + this year’s new accounts |
| Bigger than IY’s book | +3.2% | = NY’s book ÷ IY’s book − 1 (where Chapter 1 has the goal) |
| Target, next year | $34,008,926 | = the full year × (1 + that) |
| January as a share of IY | 8.11% | IY January ÷ IY, the full year |
| NY January | $2,756,737 | = the target × that share |
| Each month after | +$14,062 | = (the target − 12 × NY January) ÷ 66, so the twelve months add up to the target |
| NY December | $2,911,417 | = NY January + 11 steps |
| IY billing accounts, December | 6,634 | = October’s 6,910 × PY’s December ÷ October (0.960) |
| This year’s new accounts billing in December | 2,595 | = Chapter 1’s count, 3,268 × the 79.4% of last year’s new accounts billing in December (2,581 of 3,250) |
| NY’s book comes in with | 9,229 | = IY December + this year’s new accounts |
| NY December, billing accounts | 6,954 | = that × the 75.3% average kept (Step 1), one equal step a month |
Closed months Forecast Chapter 1’s new accounts, and the share NY starts from The answer this step is after
Chapter 1’s Step 1 with the book you carry in: next year’s total is this year’s, grown by how much bigger the book comes in. 66 = 1 + 2 + … + 11, the steps the eleven months after January add up to.
Sample data: an invented payments portfolio, no client data.