Session 24: Insurance Regulations & Digital Governance

1. The IRDAI Regulatory Framework

The Insurance Regulatory and Development Authority of India (IRDAI) is the statutory body responsible for regulating and developing the insurance industry in India. Its mandate is dual: to protect the interests of policyholders AND to promote the orderly growth of the insurance market. These two objectives sometimes pull in opposite directions — stricter regulation protects consumers but may slow market growth — and IRDAI's success is measured by how well it balances both.

1.1 The Legal Foundation

1.2 IRDAI's Regulatory Powers

IRDAI exercises its authority through: Regulations (binding rules issued under the IRDAI Act — the primary regulatory instrument), Circulars (clarifications or directions on specific topics — more common than regulations for day-to-day guidance), Guidelines (non-binding guidance on best practices), and Orders (specific directions to individual entities). For insurance analytics professionals, the most important documents to track are: the annual IRDAI Annual Report (industry data and regulatory priorities), the Master Circulars (consolidated regulatory requirements updated annually), and the Exposure Drafts (proposed regulations open for public comment — the best source for anticipating regulatory change).

2. Solvency & Capital Adequacy

Solvency regulation is the most important function of any insurance regulator. An insurer that cannot pay its claims because it lacks capital is not just a failed business — it is a social crisis that destroys the financial security of millions of policyholders. Solvency regulation sets minimum capital requirements to ensure that insurers can survive severe but plausible loss scenarios.

2.1 The Solvency Framework

IRDAI's solvency framework follows a three-pillar structure similar to the Basel capital framework for banks and Solvency II for European insurers:

• Pillar 1 — Quantitative Requirements: The insurer must maintain an Available Solvency Margin (ASM) at least 1.5 times the Required Solvency Margin (RSM). The RSM is calculated as a percentage of unearned premium reserve and outstanding claims reserve (for general insurance) or as a percentage of sum at risk and mathematical reserves (for life insurance). The current solvency ratio requirement is 1.5.
• Pillar 2 — Risk Management and Governance: The insurer must have a documented risk management framework, a board-appointed Chief Risk Officer, and a Risk Management Committee. This pillar includes the Own Risk and Solvency Assessment (ORSA) — a forward-looking self-assessment of the insurer's risk profile and capital adequacy.
• Pillar 3 — Disclosure and Market Discipline: The insurer must disclose its solvency position in its annual report and to IRDAI in quarterly filings. Material changes in solvency must be reported immediately. This pillar ensures transparency and enables market participants (analysts, rating agencies, policyholders) to assess the insurer's financial strength.

2.2 The Solvency Calculation

import pandas as pd
import numpy as np

# Solvency calculation — illustrative example for a general insurer
# Based on IRDAI's solvency framework

# ASSUMPTIONS
gross_premium = 500_00_00_000        # ₹500 Cr gross written premium
reinsurance_cession = 0.20            # 20% ceded to reinsurer
claims_outstanding = 75_00_00_000    # ₹75 Cr outstanding claims
incurred_claims = 320_00_00_000      # ₹320 Cr incurred claims (annual)
investment_portfolio = 250_00_00_000 # ₹250 Cr investment portfolio
equity_allocation = 0.35             # 35% equity, rest debt

print("=" * 60)
print("SOLVENCY CALCULATION — ILLUSTRATIVE GENERAL INSURER")
print("=" * 60)

# Step 1: Net Premium
net_premium = gross_premium * (1 - reinsurance_cession)
print(f"\n1. Net Premium")
print(f"   Gross Written Premium:    ₹{gross_premium/1e7:.0f} Cr")
print(f"   Reinsurance Ceded (20%):  ₹{gross_premium*reinsurance_cession/1e7:.0f} Cr")
print(f"   Net Written Premium:      ₹{net_premium/1e7:.0f} Cr")

# Step 2: Required Solvency Margin (RSM)
# General insurance: higher of 50% of net premium or 30% of technical reserves
rms_based_on_premium = net_premium * 0.20  # Simplified: 20% of net premium
rms_based_on_reserves = claims_outstanding * 0.30  # Simplified: 30% of outstanding claims
rsm = max(rms_based_on_premium, rms_based_on_reserves)

print(f"\n2. Required Solvency Margin (RSM)")
print(f"   20% of Net Premium:       ₹{rms_based_on_premium/1e7:.1f} Cr")
print(f"   30% of Outstanding Claims:₹{rms_based_on_reserves/1e7:.1f} Cr")
print(f"   RSM (higher of the two):  ₹{rsm/1e7:.1f} Cr")

# Step 3: Available Solvency Margin (ASM)
# ASM = Net assets + certain admissible reserves — intangible assets
total_assets = investment_portfolio + claims_outstanding + 100_00_00_000  # other assets
total_liabilities = claims_outstanding + 250_00_00_000  # other liabilities
net_assets = total_assets - total_liabilities
asm = net_assets + 10_00_00_000  # add investment fluctuation reserve (simplified)

print(f"\n3. Available Solvency Margin (ASM)")
print(f"   Total Assets:             ₹{total_assets/1e7:.0f} Cr")
print(f"   Total Liabilities:        ₹{total_liabilities/1e7:.0f} Cr")
print(f"   Net Assets:               ₹{net_assets/1e7:.0f} Cr")
print(f"   Add: Investment Reserve:  ₹{10_00_00_000/1e7:.0f} Cr")
print(f"   ASM:                      ₹{asm/1e7:.1f} Cr")

# Step 4: Solvency Ratio
solvency_ratio = asm / rsm
print(f"\n4. SOLVENCY RATIO")
print(f"   ASM / RSM = {asm/1e7:.1f} / {rsm/1e7:.1f} = {solvency_ratio:.2f}")
print(f"   IRDAI Minimum: 1.50")

if solvency_ratio >= 2.5:
    status = "Strong — comfortable capital position"
elif solvency_ratio >= 2.0:
    status = "Healthy — above regulatory minimum with headroom"
elif solvency_ratio >= 1.5:
    status = "Adequate — meets regulatory minimum but needs monitoring"
elif solvency_ratio >= 1.25:
    status = "WARNING — below minimum. Insurer must submit a capital restoration plan"
else:
    status = "CRITICAL — regulatory intervention imminent"

print(f"   Status: {status}")
print(f"   Gap to minimum: +₹{(asm - rsm * 1.5)/1e7:.1f} Cr (above minimum)")
print(f"   OR Gap to minimum: +₹{(asm - rsm * 1.5)/1e7:.1f} Cr")

5. Compliance Monitoring Dashboard in Power BI

A compliance monitoring dashboard enables the compliance team, the CFO, and the board to monitor the insurer's regulatory compliance status in real-time. Instead of waiting for quarterly filing deadlines to discover a compliance gap, the dashboard surfaces issues immediately — when corrective action is still possible.

5.1 Key Compliance Metrics and Dashboard Layout

COMPLIANCE MONITORING DASHBOARD — PAGE 1: REGULATORY STANDING

┌─────────────────────────────────────────────────────────────────────┐
│ COMPLIANCE MONITOR                         [As of: 30 Sep 2026]
├──────────────┬──────────────┬──────────────┬──────────────┬──────────┤
│ Solvency     │ Claim        │ Expense of   │ Rural        │ Grievance│
│ Ratio 2.30  │ Settlement   │ Management   │ Business 12% │ Redressal│
│ Target ≥1.50│ Ratio 94.5%  │ 26.2%        │ Target ≥10%  │ 92%      │
│ ▲ Above min  │ ▲ On track   │ ✓ Within lim │ ✓ Exceeded   │ ✓ On trk│
│ Status: GREEN│ Status: GREEN│ Status: GREEN│ Status: GREEN│ GREEN   │
├──────────────┴──────────────┴──────────────┴──────────────┴──────────┤
│ Trend: Solvency Ratio (Last 8 Quarters) — Bar Chart + Line           │
│ ┌─────────────────────────────────────────────────────────────────┐ │
│ │  2.5│ ██     ██     ██     ██     ██     ██     ██     ██       │ │
│ │  2.0│ ██  ██ ██  ██ ██  ██ ██  ██ ██  ██ ██  ██ ██  ██       │ │
│ │  1.5│ ██████████████████████████████████████████████████─── min│ │
│ │  1.0│──────────────────────────────────────────────────────────│ │
│ │     │ Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4  Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4        │ │
│ │     │ 2023      │ 2024      │ 2025      │ 2026                 │ │
│ └─────────────────────────────────────────────────────────────────┘ │
│ ▲ Regulatory minimum: 1.50    Comfort threshold: 1.75              │
│                                                                     │
├──────────────┬──────────────────────┬──────────────────────────────┤
│ Product      │ Product-wise         │ Red Flag Items               │
│ Compliance Status│ Compliance Detail  │ (Specific items needing      │
│ (Table)      │ (Expandable rows)    │  action)                      │
│ Product  CR  │ ───────────────── │ ──────────────────────────── │
│ Motor   100.2│ Motor TP: Required │ • Motor TP combined ratio    │
│ Health  91.5│ solvency for motor │   108% — exceeds internal    │
│ Property95.2│ TP segment is      │   threshold of 105%. Rate   │
│ Crop    112.0│ higher than for     │   filing required.          │
│ Travel  72.5│ own-damage. Net     │ • Crop insurance combined   │
│              │ premium growth 18%  │   ratio 112% — 3rd quarter  │
│              │ vs 25% expected in  │   in a row above 105%.      │
│              │ business plan.      │   Revisit pricing model     │
│              │ Expense ratio 24.5% │   and review reinsurance.   │
│              │ vs 26% budget.      │                             │
└──────────────┴──────────────────────┴──────────────────────────────┘

5.2 DAX Measures for Compliance Monitoring

-- Solvency Compliance
Solvency Ratio = [ASM] / [RSM]  -- From financial data

Solvency Status = IF(
    [Solvency Ratio] >= 1.75, "Strong",
    IF([Solvency Ratio] >= 1.50, "Adequate",
    IF([Solvency Ratio] >= 1.25, "Warning — Action Required",
    "Critical — Regulatory Risk")))

-- Expense of Management (as % of GWP)
Expense of Management Ratio = DIVIDE(
    SUM('Financial'[operating_expenses]),
    SUM('Financial'[gross_written_premium]),
    0
)

-- Claim Settlement Ratio (specific to health insurance where IRDAI publishes benchmarks)
Claim Settlement Ratio = DIVIDE(
    CALCULATE([Claim Count], Claims[status] = "Settled"),
    CALCULATE([Claim Count], Claims[status] <> "Pending"),
    0
)

-- Rural Business Compliance
Rural Business % = DIVIDE(
    CALCULATE([Total Premium], Policies[location_type] = "Rural"),
    [Total Premium],
    0
)

-- Grievance Redressal Rate
Grievances Resolved Rate = DIVIDE(
    SUM(Complaints[resolved_count]),
    SUM(Complaints[received_count]),
    0
)

-- Grievance Resolution Time (Average Days)
Avg Grievance Resolution Days = AVERAGE(Complaints[days_to_resolve])

-- Compliance Composite Index (weighted average of all compliance KPIs)
Compliance Index = (
    [Solvency Status Weight] * 0.30 +
    [Claim Settlement Weight] * 0.20 +
    [Expense Ratio Weight] * 0.20 +
    [Rural Business Weight] * 0.15 +
    [Grievance Weight] * 0.15
)

-- Each component weight is a score from 0-100 based on how far from target

5.3 Building the Dashboard — Key Steps

1. Data sources: Load quarterly financial data (premium, claims, expenses, solvency), claims data with settlement status, policy data with rural/urban classification, and complaint/grievance data. Each data source should be in a separate table with date relationships.
2. Measures: Create all the DAX measures from Section 5.2 plus standard time-intelligence measures for quarter-over-quarter and year-over-year comparisons.
3. Top row — KPI cards: Five scorecards with conditional formatting: green if compliant, red if non-compliant, amber if approaching the threshold. Each scorecard should show the current value, the regulatory target, and the gap.
4. Solvency trend chart: Line chart with solvency ratio by quarter. Add a constant line at 1.50 (regulatory minimum) and another at 1.75 (internal alert threshold). The gap between the current ratio and the minimum line is the "capital headroom" — one of the most important metrics for the board.
5. Compliance matrix: A table showing each product line with key compliance metrics (combined ratio, expense ratio, growth rate). Conditional formatting: combined ratio above 105 → red, expense ratio above regulatory limit → red.
6. Red flag items: A table at the bottom listing specific items requiring management attention. This is the "action list" — the most important element on the dashboard. Each red flag should have: the metric, the current value, the threshold, the business impact, and the recommended action.