Step 1

Close out this year, add the goal, draw the line

Net new revenue. November and December haven’t closed, so they’re forecast from how last year finished.

JanFebMarAprMayJunJulAugSepOctNovDecYear
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 IY0.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

ValueHow it is worked out
IY, January to October (closed)$2,680,678the closed IY cells, added up
November and December as a share of PY28.8%PY: (Nov + Dec) ÷ the year
IY, the full year$3,763,377= closed ÷ (1 − that share)
Goal10%set by the company
Target, next year$4,139,715= the full year × (1 + the goal)
January as a share of IY0.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.