Why You Need a Template
Token allocation is one of the first tasks when designing tokenomics. You need to distribute total supply among stakeholder groups, set vesting parameters, and verify that the cumulative unlock schedule doesn’t create dangerous sell pressure spikes.
Doing this by hand on paper guarantees errors. A spreadsheet calculates automatically: change one parameter — the entire 60-month schedule recalculates.
Below is a ready-made model in Google Sheets. Open it, make a copy, plug in your numbers.
Allocation and Vesting Model
What’s Inside the Model
The model consists of five sheets.
“Input Data” Sheet
Input data for each stakeholder group:
| Parameter | Description |
|---|---|
| Group | Stakeholder group name (editable) |
| Share (%) | Percentage of total supply allocated to the group |
| TGE (%) | Share of the group’s tokens available at launch |
| Cliff (months) | Period after TGE with no new unlocks |
| Vesting (months) | Duration of linear unlock after cliff |
The sheet automatically calculates absolute token amounts, verifies that shares sum to 100%, and computes MC/FDV at TGE.
“Unlock” Sheet
Monthly calculation of unlocked tokens for each group over a 60-month horizon. The unlock formula:
- U(t) — tokens unlocked by month t (computed)
- T — total tokens in the group
- TGE_% — share unlocked at TGE
- Cliff — cliff period in months
- Vesting — vesting duration in months
- When Vesting = 0: U(t) = T × TGE_%
Columns:
- Total — cumulative unlock across all groups
- % Supply — percentage of total supply
- Monthly delta — sell pressure (highlighted red if >5%)
Chart Sheets
Each chart is on its own tab:
- Allocation (chart) — pie chart showing share distribution among groups
- Unlock (chart) — stacked area chart of cumulative unlocks by month
“Checks” Sheet
Nine automatic model validations: sum = 100%, team cliff and vesting >= investors, MC/FDV in healthy range, liquidity >= 5%, maximum monthly unlock <= 5%.
Pre-Filled Example
The model contains a typical allocation for an infrastructure project:
| Group | Share | TGE | Cliff | Vesting |
|---|---|---|---|---|
| Team | 17% | 0% | 12 months | 36 months |
| Seed investors | 6% | 5% | 6 months | 24 months |
| Private investors | 10% | 10% | 3 months | 18 months |
| Community | 20% | 50% | 0 months | 6 months |
| Staking rewards | 15% | 0% | 0 months | 48 months |
| Treasury | 20% | 0% | 6 months | 36 months |
| Liquidity | 8% | 100% | 0 months | 0 months |
| Advisors | 4% | 0% | 6 months | 24 months |
Cliff periods are intentionally staggered: seed — 6 months, private — 3, team — 12. This prevents simultaneous large-volume unlocks.
How to Adapt for Your Project
- Copy the spreadsheet via File → Make a copy
- Change Total Supply in cell B2 on the “Input Data” sheet
- Enter your groups, shares, and vesting parameters in the yellow cells
- Verify that shares sum to 100% (cell B13)
- Navigate to chart tabs — they update automatically
- Open the “Checks” sheet — all rows should show PASS
For more on allocation principles, common mistakes, and model types — see Allocation as a Token Supply Model.
Need help with tokenomics?
We design allocation and vesting models, run stress tests, and deliver ready-to-use spreadsheets.
Get in touch