Carrier commission & bonus revenue modeling — mirrors the Carrier / Rules / Calculations logic from the source workbook.
Full revenue breakdown by source per carrier. What-If column shows projected revenue if you hit your growth target.
| Carrier | NB Comm | Renewal Comm | Bonus Comm | Additional Comm | Aggregator Comm | Total Revenue | What-If Revenue | ROI |
|---|---|---|---|---|---|---|---|---|
| #1Carrier 1 LR 45.0% | $6,000 | $135,000 | $66,825 | $0 | $0 | $207,825 | $209,580 +4% growth |
15.39% |
| #2Carrier 2 LR 42.0% | $4,200 | $102,000 | $612,000 | $0 | $0 | $718,200 | $768,180 +7% growth |
70.41% |
| #3Carrier 3 LR 58.0% | $2,200 | $50,400 | $2,240 | $0 | $0 | $54,840 | $60,798 +9% growth |
9.79% |
| #4Carrier 4 LR 33.0% | $7,800 | $45,100 | $11,787 | $0 | $0 | $64,688 | $69,239 +8% growth |
15.78% |
| #5Carrier 5 LR 50.0% | $1,500 | $118,000 | $23,231 | $0 | $0 | $142,731 | $198,177 +18% growth |
9.68% |
Enter your premium, loss ratio and new business per carrier.
| Carrier | Prior Year DWP | Current Year DWP | Loss Ratio % | New Business | What-If Growth % | |
|---|---|---|---|---|---|---|
Base commission rates per carrier — mirrors the Rules sheet.
| Carrier | Carrier Type | NB Comm % | RN Comm % | Incentive Comm % | Aggregator |
|---|---|---|---|---|---|
| Carrier 1 | |||||
| Carrier 2 | |||||
| Carrier 3 | |||||
| Carrier 4 | |||||
| Carrier 5 |
Full tier-by-tier breakdown — mirrors the Calculations sheet.
| Carrier | Current DWP | LR | Growth % | LR Tier | LR Bonus % | Profit Factor | Growth Mult. | Bonus Payment | NB Comm % | RN Comm % | Incentive Comm % | New Business | YTD Premium | Commission Payment | Total Carrier Rev | Rev / Premium |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| #1Carrier 1 | $1,350,000 | 45.0% | 8.0% | 45-49.9 | 2.25% | 4.95% | 2.20x | $66,825 | 12.00% | 10.00% | 0.00% | $50,000 | $1,350,000 | $141,000 | $207,825 | 15.39% |
| #2Carrier 2 | $1,020,000 | 42.0% | 13.3% | 40-44.9 | 40.00% profit bonus |
60.00% | 20.00% growth bonus |
$612,000 | 12.00% | 10.00% | 0.00% | $35,000 | $1,020,000 | $106,200 | $718,200 | 70.41% |
| #3Carrier 3 | $560,000 | 58.0% | -6.7% | 55-59.9 | 0.50% | 0.40% | 0.80x | $2,240 | 11.00% | 9.00% | 0.00% | $20,000 | $560,000 | $52,600 | $54,840 | 9.79% |
| #4Carrier 4 | $410,000 | 33.0% | 36.7% | 30-34.9 | 2.50% | 2.88% | 1.15x | $11,787 | 13.00% | 11.00% | 0.00% | $60,000 | $410,000 | $52,900 | $64,688 | 15.78% |
| #5Carrier 5 | $1,475,000 | 50.0% | -1.7% | 50-54.9 | 1.50% | 1.57% | 1.05x | $23,231 | 10.00% | 8.00% | 0.00% | $15,000 | $1,475,000 | $119,500 | $142,731 | 9.68% |