Step 1

Every cohort split by tier

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.

AccountsDecember revenueShare of DecemberYear against DecemberNext year
Tier A738$1,769K53.3%10.40×$18,394K
Tier B1,477$916K27.6%10.17×$9,317K
Tier C2,820$410K12.3%9.75×$3,993K
Tier D3,920$184K5.5%9.91×$1,819K
Approved, not billing yet15$0K0.0%$29K
Still to be approved (plan)274$42K1.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.