Step 1
Net new revenue. November and December haven’t closed, so they’re forecast from how last year finished.
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Year | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PY (last year) | $27.1K | $77.3K | $157.9K | $230.2K | $298.3K | $356.2K | $387.4K | $435.3K | $472.0K | $521.0K | $557.8K | $638.8K | $4,159.3K |
| IY (this year) | $21.8K | $60.4K | $117.7K | $181.2K | $249.2K | $306.7K | $364.4K | $423.2K | $448.1K | $507.9K | $504.7K | $578.0K | $3,763.4K |
| January as a share of IY | 0.58% | ||||||||||||
| NY (next year) | $24.0K | $82.4K | $140.7K | $199.1K | $257.4K | $315.8K | $374.2K | $432.5K | $490.9K | $549.2K | $607.6K | $665.9K | $4,139.7K |
The math
| Value | How it is worked out | |
|---|---|---|
| IY, January to October (closed) | $2,680,678 | the closed IY cells, added up |
| November and December as a share of PY | 28.8% | PY: (Nov + Dec) ÷ the year |
| IY, the full year | $3,763,377 | = closed ÷ (1 − that share) |
| Goal | 10% | set by the company |
| Target, next year | $4,139,715 | = the full year × (1 + the goal) |
| January as a share of IY | 0.58% | IY January ÷ IY, the full year |
| NY January | $24,028 | = the target × that share |
| Each month after | +$58,354 | = (the target − 12 × NY January) ÷ 66, so the twelve months add up to the target |
| NY December | $665,924 | = NY January + 11 steps |
Closed months Forecast The share NY starts from The answer this step is after
A straight line: every month after January adds the same amount, so the year never curves. 66 = 1 + 2 + … + 11, the steps the eleven months after January add up to.
Sample data: an invented payments portfolio, no client data.