Step 2

What a new account bills, by its month on the book

Dollars per approved account. Month 1 is the month of approval.

123456789101112First 12 months
PY January accounts$108$193$232$242$239$226$223$214$195$188$186$190$2,436
PY June accounts$94$166$198$194$193$191$181
The curve$110$190$218$216$208$201$183$168$167$169$184$194$2,208

The first two rows = a line of the PY grid รท its accounts, moved left so every line starts at month 1.

The curve = the same, across the last twelve approval months together, with the time of year taken out (step 3).

Sample data: an invented payments portfolio, no client data.