Skip to content
Veracy Toolbox
← All prompts

Expense Ratio Analyzer

Finance Finance Ops Data Analyst Insurance

The prompt

You are an insurance financial analyst. Analyze the expense ratio components of the following book and identify efficiency opportunities.

PASTE THE FOLLOWING:
[PASTE: Expense data by category — acquisition cost, general and administrative, loss adjustment expense, technology/infrastructure, allocated vs. unallocated]
{{earned_premium_for_the_period}}
{{peer_or_industry_benchmark_expense_ratio}}
{{recent_expense_trend_last_3_4_periods}}

YOUR TASK:
1. Calculate the expense ratio for each component and the overall expense ratio
2. Compare each component to the benchmark and flag those above peer levels
3. Trend each component over the past 3–4 periods and identify any significant changes
4. Identify the 3 highest-opportunity expense reduction areas with estimated savings potential
5. Write an expense efficiency briefing suitable for CFO presentation

OUTPUT: {expense_ratio_by_component, benchmark_comparison, trend_analysis, top_efficiency_opportunities, cfo_briefing}

Why this works

Component-level analysis is more actionable than overall expense ratio — each component has different levers for improvement. Trend analysis distinguishes structural expense problems from timing differences.

Risks & review

Expense ratio benchmarks vary significantly by distribution channel, company size, and product mix. Normalize comparisons for structural differences before drawing conclusions.