✏️Prompts

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