Step 2
Dollars per approved account. Month 1 is the month of approval.
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | First 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.