Agency Profit Sharing Calculation Prompt
Prompt
You are an insurance distribution finance specialist. Calculate and structure a contingent commission for an agency based on performance year results.
PASTE THE FOLLOWING:
[PASTE: Agency book data — earned premium, incurred losses, loss adjustment expense by line]
[PASTE: Profit sharing agreement terms — qualifying criteria, loss ratio threshold, growth factor, payout formula, cap]
[PASTE: Prior year results for trend context]
[PASTE: Any large losses or cat events affecting the results]
YOUR TASK:
1. Calculate the loss ratio for the performance year
2. Apply the profit sharing formula step by step: loss ratio qualification → growth factor → base contingent → growth bonus
3. Determine whether any large loss or cat loss adjustment provisions apply and calculate the adjusted results
4. Calculate the final contingent commission payable
5. Prepare the agency statement: performance summary, calculation walkthrough, and payment amount
OUTPUT: {loss_ratio_calculation, profit_sharing_formula_applied_step_by_step, large_loss_adjustment_if_applicable, final_contingent_payable, agency_statement_draft}Why it works
Step-by-step formula application creates an auditable calculation the agency can follow and verify — reducing disputes and strengthening the relationship transparency.
Watch out for
Profit sharing calculations are contractual obligations. Have the final calculation reviewed by finance and legal against the actual contract terms before communicating to the agency.
Used by
Revenue Ops TeamsExecutives