Annual model + a single Quarterly payout model (monthly draw, cap rules, and quarter-end true-up). Shareable and tweakable without spreadsheet-induced despair.
Key mechanics modelled: (1) Quarterly target variable = salary ÷ 4. (2) Quarter-end multiplier: 1.0x to 100%, 1.1x 100–120%, 1.2x 120%+. (3) Monthly draw cap: Month 1 capped to 1/3 of quarter target (100% pacing), Month 2 capped to 2/3 cumulative, Month 3 uncapped; quarter-end true-up reconciles to the final quarter commission. (4) Pacing bonus: Month 1 pacing $1,000; Months 1+2 pacing $500; converted via FX.
These drive annual totals. The quarterly model below is a single scenario to understand the monthly cap + true-up behaviour.
| Component | Value |
|---|
Pacing bonus total = (quarters hit) × (quarterly model pacing bonus). If you hit pacing in different patterns by quarter, set quarters hit conservatively and adjust the quarterly model to match the typical payout.
Cap logic (implemented): Month 1 draw capped to 33% of quarter (1/3). Month 2 cumulative draw capped to 66% of quarter (2/3). Month 3 uncapped.
| Period | QTD attainment | Monthly payout | Running paid |
|---|
Tip: use the share link to snapshot scenarios (e.g. “monster Month 1, capped anyway”).