Contingency and Profit-Sharing Bonus: Loss Ratio Tiers
This lesson is part of the course
In this lesson
You compute each carrier's loss ratio, look up the bonus tier with XLOOKUP, apply the minimum-volume rule and find how far one carrier is from the next tier.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- New vs Renewal Commission by Line of Business Locked
- Written Premium to Agency Revenue Locked
- Policy Retention and Account Rounding Locked
- Book of Business Growth Projection Locked
- Producer Compensation: New vs Renewal Splits and Validation Locked
- Contingency and Profit-Sharing Bonus: Loss Ratio Tiers Locked
- Agency P&L and EBITDA Margin Locked
- Agency and Book Valuation: Multiples and an Earnout (Chart) Locked