Erie Indemnity Financial Model
Insurance Company Financials Example (Free Excel Download)
Erie Indemnity Company (ERIE) operates a unique business model as the managing attorney-in-fact for the subscribers (policyholders) at the Erie Insurance Exchange, a reciprocal insurance exchange.
professionals from Deloitte
Used by professionals from
About this model
This model forecasts the earnings and cash flow generation of Erie Indemnity to determine its equity valuation, specifically evaluating how premium growth and underwriting profitability at the affiliated Erie Insurance Exchange translate into management fee revenue and commission expenses for the publicly traded attorney-in-fact.
Erie Indemnity Company (ERIE) operates a unique business model as the managing attorney-in-fact for the subscribers (policyholders) at the Erie Insurance Exchange, a reciprocal insurance exchange. ERIE does not underwrite insurance or bear underwriting risk itself; instead, it provides policy issuance, renewal, and administrative services to the Exchange.
- Business segments: ERIE operates as a single reportable segment (management operations), but revenue is split into Management Fee Revenue - Policy Issuance & Renewal (~77%), Administrative Services Reimbursement Revenue (~21%), and Management Fee Revenue - Administrative Services (~2%).
- Key geographies: United States (primarily Pennsylvania, Maryland, Ohio, Virginia, and surrounding states).
- Business model type: Asset-light, fee-based management model. ERIE earns a management fee of up to 25% of the direct and affiliated assumed written premiums of the Exchange.
- Competitive position: Sells exclusively through a network of independent agencies. Its fortunes are entirely tied to the growth and retention of the Erie Insurance Exchange.
- Recent major events: In Q4 2025, ERIE made a one-time $100 million charitable contribution to the Erie Insurance Foundation, which depressed reported net income but did not impact operating income. The Exchange experienced significant premium growth in 2024 (18%) and 2025 (~9%) driven by rate increases to combat inflation and catastrophe losses.
The downloadable Erie Indemnity financial model includes SEC-sourced historical financials, forecast assumptions, core operating schedules, and valuation outputs in an Excel workbook built for review and scenario analysis.
A turnkey financial model
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
Historicals & AssumptionsErie Indemnity financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $2.63B | $2.84B | $3.27B | $3.80B | $4.07B |
| Income before income taxes | $376.4M | $376.5M | $561.9M | $757.3M | $710.6M |
| Operating income | $318.1M | $376.2M | $520.3M | $676.5M | $717.2M |
| Net income | $297.9M | $298.6M | $446.1M | $600.3M | $559.3M |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Erie Indemnity
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Management Fee Revenue - Policy Issuance and Renewal Services
- Segment name: Management fee revenue - policy issuance and renewal services
- Revenue driver formula: Erie Insurance Exchange Direct and Affiliated Assumed Written Premiums × Management Fee Rate (historically set at the maximum 25%)
- Historical growth rate: 8-10% CAGR (accelerated recently due to hard market rate increases).
- Key growth levers and headwinds: Driven entirely by the Exchange's ability to grow policies in force and increase average premium per policy. Headwinds include policyholder attrition (retention dropped to 88.4% in 2025) due to aggressive rate hikes.
- Pricing dynamics: The management fee rate is capped at 25% by the subscriber agreement. ERIE's Board sets the rate annually, but it has consistently been at the 25% maximum.
- Revenue recognition notes: Recognized over the period the related insurance coverage is provided.
- Seasonality: Slight seasonality mirroring auto and home insurance buying patterns (Q2 and Q3 tend to be slightly stronger for written premiums).
Administrative Services Reimbursement Revenue
- Segment name: Administrative services reimbursement revenue
- Revenue driver formula: Equals 100% of the allowable administrative costs incurred by ERIE on behalf of the Exchange.
- Historical growth rate: 4-6% CAGR.
- Pricing dynamics: This is a pure pass-through revenue stream with zero margin.
- Revenue recognition notes: Recognized as the related expenses are incurred.
Management Fee Revenue - Administrative Services
- Segment name: Management fee revenue - administrative services
- Revenue driver formula: Fixed fees or specific service-based fees charged to the Exchange.
- Historical growth rate: 7-9% CAGR.
Cost Structure
Variable Costs / COGS
ERIE does not report traditional COGS, but its primary direct cost is agent compensation.
- Commissions: The largest expense. Paid to independent agents for selling and renewing Exchange policies. Includes base commissions and agent incentive compensation (which fluctuates based on the Exchange's underwriting profitability).
- Gross margin range: Not applicable in traditional terms, but commission expense typically runs at 50-55% of Management Fee Revenue.
- How COGS scales with revenue: Base commissions scale linearly with Exchange premiums. Incentive commissions are highly variable and step-function based on the Exchange's 3-year trailing combined ratio.
Operating Expenses
- Non-commission expenses: Includes underwriting, policy processing, IT, and administrative costs.
- Administrative services reimbursement expenses: Exactly matches the Administrative services reimbursement revenue line (zero net impact on operating income).
- Depreciation & Amortisation: Minimal (~1-2% of revenue), primarily related to capitalized software and home office facilities.
- One-time charges: $100 million charitable contribution in Q4 2025 (must be excluded from run-rate operating margin calculations).
Margin Profile
- Operating margin: Typically 16-18% of total operating revenue (2025 operating income was $717.2 million on ~$4.07 billion of total operating revenue, yielding ~17.6%).
- Margin trend: Stable to slightly expanding. Management fee growth (driven by rate increases) has outpaced non-commission expense growth, though agent incentive compensation can cause year-to-year volatility.
Balance Sheet Structure
- Total assets: ~$3.3 billion (as of late 2025).
- Key asset categories: Cash and cash equivalents, Fixed maturity investments, Equity securities, and Receivables from Erie Insurance Exchange (timing differences in fee collection).
- Goodwill & intangibles: Zero or negligible. ERIE grows organically alongside the Exchange.
- Working capital profile:
- DSO: 30-45 days (receivables from the Exchange).
- DPO: 30-45 days (commissions payable to agents).
- Net working capital: Generally neutral to slightly positive.
- PP&E: Primarily the home office complex in Erie, PA, and capitalized IT hardware/software. ERIE recently committed $77.5 million to home office renovations.
Capital Expenditure & Investment
- Capex as % of revenue: 1.5% - 2.5%.
- Maintenance capex vs. growth capex: Heavily skewed toward IT modernization (cloud migration, new billing platforms like Business Auto 2.0) and facility renovations.
- Capitalised software: Material component of total capex due to ongoing legacy system modernization.
- M&A pattern: None. ERIE does not acquire other companies; its sole purpose is to manage the Erie Insurance Exchange.
Debt & Capital Structure
- Total debt: $0 long-term debt. ERIE operates with a highly conservative, unlevered balance sheet.
- Key debt instruments: Maintains an undrawn bank line of credit for liquidity purposes.
- Share repurchase programme: Active, but primarily used to offset dilution from stock-based compensation rather than to reduce share count aggressively.
- Dividend policy: Very strong dividend payer. The Board approved a 7.1% increase to the quarterly cash dividend for 2026. Payout ratio typically runs at 40-50% of net income.
Cash Flow Characteristics
- Operating cash flow conversion: Very high (>1.0x OCF / Net Income) due to the asset-light nature of the attorney-in-fact model and lack of underwriting risk.
- Free cash flow margin: 12-15% of total operating revenue.
- Major non-cash items: Depreciation, stock-based compensation, and deferred income taxes.
- Working capital cash flow impact: Minimal drag; fluctuates based on the timing of month-end settlements with the Exchange.
- Capex intensity: Very low, resulting in FCF closely mirroring OCF.
Sheet Structure
- Assumptions: Hardcoded inputs for Exchange premium growth, fee rates, commission ratios, tax rates, and dividend growth.
- Exchange Premium Forecast: A schedule projecting the Erie Insurance Exchange's Direct Written Premiums (the fundamental driver of ERIE's revenue).
- Income Statement: ERIE's consolidated statement of operations, explicitly separating Management Fee Revenue, Reimbursement Revenue, Commissions, and Non-Commission Expenses.
- Balance Sheet: ERIE's assets and liabilities, highlighting Investments, Receivables from Exchange, and Commissions Payable.
- Cash Flow Statement: Standard indirect method bridging Net Income to OCF, CFI (investment portfolio purchases/sales), and CFF (dividends).
- Debt & Equity Schedule: Tracking share count, dividend payouts, and the zero-debt capital structure.
- DCF Valuation: Unlevered free cash flow build, WACC calculation, and terminal value based on the Gordon Growth Model.
Key Financial Relationships
- `Exchange Direct Written Premiums = Prior Year Exchange DWP * (1 + DWP Growth Rate)`
- `Management Fee Revenue - Policy Issuance = Exchange Direct Written Premiums * Management Fee Rate (25%)`
- `Administrative Services Reimbursement Revenue = Administrative Services Reimbursement Expense`
- `Total Operating Revenue = Management Fee Revenue (Policy Issuance) + Management Fee Revenue (Admin) + Admin Services Reimbursement Revenue + Service Agreement Revenue`
- `Commission Expense = Exchange Direct Written Premiums * Commission Rate %`
- `Non-Commission Expense = Prior Year Non-Commission Expense * (1 + Non-Commission Expense Growth Rate)`
- `Total Cost of Operations = Commission Expense + Non-Commission Expense + Admin Services Reimbursement Expense`
- `Operating Income = Total Operating Revenue - Total Cost of Operations`
- `Net Investment Income = Average Investment Portfolio Balance * Portfolio Yield`
- `Pre-Tax Income = Operating Income + Net Investment Income + Other Income`
- `Net Income = Pre-Tax Income * (1 - Effective Tax Rate)`
- `Dividends Paid = Prior Year Dividends Paid * (1 + Dividend Growth Rate)`
Cross-Sheet Dependencies
- The Exchange Premium Forecast is the critical engine of the model; it directly feeds the Income Statement to calculate `Management Fee Revenue` and `Commission Expense`.
- The Income Statement generates `Net Income`, which feeds the top line of the Cash Flow Statement and the `Retained Earnings` line on the Balance Sheet.
- The Cash Flow Statement calculates the change in cash, which feeds the `Cash and Cash Equivalents` line on the Balance Sheet.
- `Administrative Services Reimbursement Revenue` on the Income Statement must be hard-linked to equal `Administrative Services Reimbursement Expense` to prevent margin distortion.
Sign Convention
- Revenues and Assets: Positive.
- Expenses: Positive in their specific build schedules, but subtracted in the Income Statement to calculate Operating Income.
- Cash Flow: Inflows are positive, outflows (capex, dividends, purchasing investments) are negative.
- Reimbursement items: Both revenue and expense should be positive numbers, netting to zero in the margin calculation.
Things Most Likely to Go Wrong
- Confusing ERIE with the Exchange: ERIE is the management company. Do not model loss ratios, combined ratios, or reserve development on ERIE's income statement. Those belong to the Exchange.
- Mismodeling Reimbursement Revenue: If the builder applies a margin to the Administrative Services Reimbursement Revenue, it will artificially inflate operating income. It must be a 100% pass-through.
- Overestimating the Management Fee Rate: The fee rate is contractually capped at 25%. Do not forecast this rate expanding to 26% or 27% to drive growth.
- Including the 2025 Charitable Contribution in Run-Rate: The $100 million contribution to the Erie Insurance Foundation in Q4 2025 was a one-time event. It must be excluded from go-forward operating expense run-rates.
- Ignoring Agent Incentive Volatility: Commission expenses include base and incentive components. If the Exchange's underwriting profitability improves, ERIE pays higher incentive commissions, which compresses ERIE's operating margin slightly.
- Modeling Debt: ERIE carries no long-term debt. Adding a standard debt paydown schedule will break the reality of their capital structure.
Validation Checks
- `Management Fee Rate` must exactly equal 25.0% in all forecast periods.
- `Administrative Services Reimbursement Revenue` minus `Administrative Services Reimbursement Expense` must equal exactly $0.
- `Operating Margin` (Operating Income / Total Operating Revenue) should remain in the 16.0% - 18.5% band.
- `Total Debt` must equal $0.
- `Balance Sheet Check`: Total Assets minus (Total Liabilities + Shareholders' Equity) must equal $0 in every period.
- `Dividend Payout Ratio` should remain between 40% and 60% of Net Income.
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| Exchange DWP Growth Rate | 7.5 | % | Blended rate reflecting recent 9-18% hard market growth normalizing back toward historical mid-single digits. |
| Management Fee Rate | 25.0 | % | Contractual maximum, consistently applied by the Board. |
| Admin Services Reimbursement Growth | 5.0 | % | Historical average growth of pass-through administrative costs. |
| Commission Rate (% of DWP) | 12.5 | % | Historical average of base plus incentive commissions paid to independent agents. |
| Non-Commission Expense Growth | 4.0 | % | Reflects inflation and ongoing IT modernization investments. |
| Investment Portfolio Yield | 4.5 | % | Blended yield on fixed maturities and limited partnership investments. |
| Effective Tax Rate | 21.5 | % | Standard US corporate tax rate plus minor state taxes. |
| Dividend Growth Rate | 7.1 | % | Matches the Board-approved increase for 2026. |
| Capex as % of Total Revenue | 2.0 | % | Historical average for IT and facility investments. |
| WACC | 8.0 | % | Unlevered cost of equity for a stable, fee-based financial services firm. |
| Terminal Growth Rate | 2.5 | % | Long-term inflation and GDP growth proxy. |
Data Sources & Benchmarks
- Filings: SEC EDGAR (Erie Indemnity Company, Ticker: ERIE).
- Investor Relations: erieinsurance.com (Investor Supplement provides crucial breakout of Exchange vs. Indemnity financials).
- Peers for Benchmarking: Brown & Brown (BRO), Arthur J. Gallagher (AJG), Marsh & McLennan (MMC). *Note: ERIE's captive attorney-in-fact model is unique, so peer margins are only loosely comparable.*
- Industry Data: AM Best (for property & casualty insurance pricing trends which drive the Exchange's premium growth).
Sources
Do more with the Erie Indemnity model
Frequently asked
How does Erie Indemnity make money?+
Erie Indemnity (ERIE) operates as the managing attorney-in-fact for the Erie Insurance Exchange, earning management fees for providing policy issuance, renewal, and administrative services. It does not underwrite insurance or bear underwriting risk itself, focusing instead on its fee-based management model.
What are the primary drivers of Erie Indemnity's revenue growth?+
Erie Indemnity's revenue is primarily driven by the direct and affiliated assumed written premiums of the Erie Insurance Exchange, from which it earns a management fee of up to 25%. Its fortunes are entirely tied to the growth and retention of the Exchange's policyholders.
What is Erie Indemnity's typical capital expenditure profile?+
Erie Indemnity's capital expenditure, typically 1.5% - 2.5% of revenue, is heavily skewed toward IT modernization, including cloud migration and new billing platforms. It also includes facility renovations, such as the recently committed $77.5 million for its home office complex.
How does Erie Indemnity's asset-light business model impact its profitability?+
As an asset-light, fee-based management company, Erie Indemnity does not bear underwriting risk, which contributes to a more predictable revenue stream. Its profitability is tied to the management fees earned from the Erie Insurance Exchange, rather than direct insurance underwriting results.
What is the significance of the Erie Insurance Exchange to Erie Indemnity's valuation?+
The Erie Insurance Exchange is central to Erie Indemnity's valuation because ERIE's earnings and cash flow are directly derived from the Exchange's premium growth and underwriting profitability. ERIE's business model is entirely dependent on managing the Exchange and earning fees from its operations.
Can I download a financial model for Erie Indemnity?+
Yes, a downloadable Excel model is available for Erie Indemnity (ERIE) to forecast its earnings and cash flow generation. This model evaluates how premium growth and underwriting profitability at the affiliated Erie Insurance Exchange translate into ERIE's management fee revenue and commission expenses.
Have more financial modelling questions? Contact us
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Other Insurance Company Financial Models
Browse another company in the same sector.
Arch Capital Group
Arch Capital Group is a Bermuda-based global provider of specialty property and casualty insurance, reinsurance, and mortgage insurance, dynamically allocating capital across underwriting opportunities.
Aflac
Aflac Incorporated is a leading provider of supplemental health and life insurance products, designed to pay cash benefits directly to policyholders for costs not covered by primary health insurance.
American International Group
American International Group (AIG) is a leading global insurance organisation providing property casualty insurance solutions to businesses and individuals in over 200 countries and jurisdictions.
Assurant
Assurant is a global provider of risk management solutions, protecting consumer purchases such as mobile devices, vehicles, and homes through B2B2C partnerships with brands, telecom providers, and financial institutions.
Arthur J. Gallagher & Co.
Arthur J.
Allstate
The Allstate Corporation is one of the largest publicly held personal lines property and casualty insurers in the United States.
Aon
Aon plc is a leading global professional services firm providing a broad range of risk, retirement, and health solutions.
Berkshire Hathaway
Berkshire Hathaway is a multinational conglomerate holding company overseen by Warren Buffett.
Explore more Financial Services financial model templates.
