Step 2

Close out this year, add the new accounts, draw the line

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

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

JanFebMarAprMayJunJulAugSepOctNovDec
PY (last year)8,0947,8627,6447,4437,2497,0676,8936,7286,5786,4366,3186,179
+ Last year’s new2,581
IY (this year)8,5588,3078,0847,8737,6977,5347,3377,1777,0416,9106,7836,634
+ This year’s new2,595
NY (next year)9,0408,8508,6618,4718,2818,0927,9027,7137,5237,3337,1446,954

The math

ValueHow it is worked out
PY, December$2,579,320the PY row’s December
Last year’s new accounts, December$638,776Chapter 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,180the closed IY cells, added up
November and December as a share of PY16.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,966Chapter 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 IY8.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, December6,634= October’s 6,910 × PY’s December ÷ October (0.960)
This year’s new accounts billing in December2,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 with9,229= IY December + this year’s new accounts
NY December, billing accounts6,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.