Step 1
Chapter 1’s tiers: monthly processing volume, each account at the best tier it has reached. Each tier runs at its own ratio, by age.
One line per tier.
| Accounts | December revenue | Share of December | Year against December | Next year | |
|---|---|---|---|---|---|
| Tier A | 738 | $1,769K | 53.3% | 10.40× | $18,394K |
| Tier B | 1,477 | $916K | 27.6% | 10.17× | $9,317K |
| Tier C | 2,820 | $410K | 12.3% | 9.75× | $3,993K |
| Tier D | 3,920 | $184K | 5.5% | 9.91× | $1,819K |
| Approved, not billing yet | 15 | $0K | 0.0% | $29K | |
| Still to be approved (plan) | 274 | $42K | 1.3% | 9.83× | $417K |
| All tiers | $33,968K |
Each tier opened by how long its accounts have been on the book.
| Accounts | December revenue | Share of December | Year against December | Next year | |
|---|---|---|---|---|---|
| Tier A, last year’s new accounts | 84 | $173K | 5.2% | 9.82× | $1,703K |
| Tier A, one to two years old | 106 | $224K | 6.7% | 10.35× | $2,320K |
| Tier A, two to four years old | 181 | $364K | 11.0% | 10.51× | $3,826K |
| Tier A, four years and older | 367 | $1,008K | 30.3% | 10.47× | $10,545K |
| Tier B, last year’s new accounts | 307 | $203K | 6.1% | 10.13× | $2,058K |
| Tier B, one to two years old | 252 | $164K | 5.0% | 10.05× | $1,653K |
| Tier B, two to four years old | 388 | $236K | 7.1% | 10.30× | $2,429K |
| Tier B, four years and older | 529 | $312K | 9.4% | 10.17× | $3,177K |
| Tier C, last year’s new accounts | 636 | $98K | 3.0% | 9.39× | $921K |
| Tier C, one to two years old | 552 | $83K | 2.5% | 9.94× | $821K |
| Tier C, two to four years old | 725 | $107K | 3.2% | 9.83× | $1,048K |
| Tier C, four years and older | 907 | $122K | 3.7% | 9.83× | $1,202K |
| Tier D, last year’s new accounts | 1,293 | $61K | 1.8% | 9.59× | $582K |
| Tier D, one to two years old | 746 | $36K | 1.1% | 9.99× | $359K |
| Tier D, two to four years old | 1,016 | $48K | 1.4% | 10.08× | $483K |
| Tier D, four years and older | 865 | $39K | 1.2% | 10.12× | $394K |
| Approved, not billing yet | 15 | $0K | 0.0% | $29K | |
| Still to be approved (plan) | 274 | $42K | 1.3% | 9.83× | $417K |
| All tiers | $33,968K |
Where the tier starts The ratio for its tier and age, from earlier years This layer’s year
Accounts approved but not billing yet, and those still to be approved, read at the ratio of every tier at their age.
Sample data: an invented payments portfolio, no client data.