Hartford Financial Model
Insurance Company Financials Example (Free Excel Download)
The Hartford Financial Services Group, Inc. is a leading US-based insurance and financial services holding company.
professionals from Deloitte
Used by professionals from
About this model
This model provides a comprehensive sum-of-the-parts equity valuation and earnings forecasting tool for an equity research analyst covering The Hartford, focusing on property and casualty underwriting profitability, Group Benefits margin expansion, and investment portfolio yield.
The Hartford Financial Services Group, Inc. is a leading US-based insurance and financial services holding company. The company primarily provides property and casualty (P&C) insurance, group benefits, and mutual funds to individual and business customers.
Business segments include:
- Commercial Lines (approx. 55% of revenues): Workers' compensation, property, automobile, liability, and umbrella coverage for businesses.
- Personal Lines (approx. 15% of revenues): Standard automobile, homeowners, and personal umbrella coverage.
- Group Benefits (approx. 25% of revenues): Group life, disability, and other supplemental benefits.
- Hartford Funds (approx. 4% of revenues): Mutual funds and exchange-traded funds.
- Property & Casualty Other Operations (approx. 1% of revenues): Run-off asbestos and environmental exposures.
The company operates almost exclusively in the United States. Its business model is asset-heavy, relying on the collection of premiums upfront to generate a massive investment float before claims are paid out. The Hartford holds a strong competitive position in the small commercial and middle-market segments, ranking among the top workers' compensation insurers in the US. Recent major events include a strategic shift to restore profitability in Personal Lines auto through double-digit rate increases and the nationwide rollout of the "Prevail" platform, alongside aggressive share repurchase programmes.
The downloadable Hartford 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 & AssumptionsHartford financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $1.57B | $1.42B | $1.38B | $1.46B | $1.51B |
| Income before income taxes | $2.90B | $2.26B | $3.09B | $3.85B | $4.76B |
| Benefits, losses and loss adjustment expenses | $12.73B | $13.14B | $14.24B | $14.87B | $15.24B |
| Net income | $2.37B | $1.82B | $2.50B | $3.11B | $3.84B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Hartford
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Commercial Lines
- Segment name: Commercial Lines
- Revenue driver formula: Written Premiums x Premium Earning Curve
- Historical growth rate: 6% to 9% CAGR
- Key growth levers and headwinds: Rate increases exceeding loss cost trends, new business growth in specialty niches (marine, excess casualty), and macroeconomic employment levels driving workers' compensation payrolls.
- Pricing dynamics: Highly regulated but currently in a hard market for property and specialty, while workers' compensation pricing remains competitive.
- Revenue recognition notes: Premiums are recognised as earned pro-rata over the policy term; unearned premiums sit on the balance sheet as a liability.
- Seasonality: Q1 typically sees higher written premiums due to January 1 renewal cycles, but earned premiums are relatively smooth throughout the year.
Personal Lines
- Segment name: Personal Lines
- Revenue driver formula: Policies in Force x Average Premium per Policy
- Historical growth rate: 5% to 13% (recently elevated due to aggressive rate hikes)
- Key growth levers and headwinds: Regulatory approval for auto rate increases, frequency and severity of auto accidents, and the rollout of the Prevail bundled package platform.
- Pricing dynamics: Strictly regulated by state insurance departments; recent years required massive rate filings to combat inflation in auto repair and medical costs.
- Revenue recognition notes: Earned pro-rata over the typical 6-month or 12-month policy term.
- Seasonality: Q2 and Q3 typically experience higher weather-related homeowner claims, impacting net underwriting revenue.
Group Benefits
- Segment name: Group Benefits
- Revenue driver formula: Fully Insured Ongoing Premium + Administrative Fees
- Historical growth rate: 2% to 4% CAGR
- Key growth levers and headwinds: Wage inflation (disability premiums are often tied to salaries), employment levels, and mortality/morbidity trends.
- Pricing dynamics: Contractual, typically negotiated annually or multi-year with corporate employers.
- Revenue recognition notes: Premiums earned over the coverage period.
- Seasonality: Q1 often sees higher mortality claims (winter months), impacting margins.
Hartford Funds
- Segment name: Hartford Funds
- Revenue driver formula: Assets Under Management (AUM) x Average Management Fee Rate
- Historical growth rate: Highly variable, dependent on equity and fixed income market performance.
- Key growth levers and headwinds: Market appreciation, net fund flows, and the shift from active mutual funds to passive ETFs.
- Pricing dynamics: Competitive fee pressure from passive index funds.
- Revenue recognition notes: Fees accrued daily based on AUM balances.
- Seasonality: None, though market corrections cause immediate revenue step-downs.
Net Investment Income
- Segment name: Net Investment Income
- Revenue driver formula: Average Invested Assets x Annualised Portfolio Yield
- Historical growth rate: Yields have expanded from approx. 3.5% to 4.5%+ recently.
- Key growth levers and headwinds: Prevailing interest rates, reinvestment rates on maturing fixed income securities, and returns on limited partnerships (LPs).
- Pricing dynamics: Spot market rates for new money; LP returns are highly variable.
- Revenue recognition notes: Interest recognised as earned; LP returns reported on a one-quarter lag.
- Seasonality: LP returns often show Q4 spikes due to year-end private equity mark-to-market valuations.
Cost Structure
Variable Costs / COGS (Underwriting Losses)
- Line-by-line breakdown: For an insurer, "COGS" is represented by Benefits, Losses, and Loss Adjustment Expenses (LLAE). This includes Current Accident Year (CAY) losses, Catastrophe (CAT) losses, and Prior Year Development (PYD).
- Gross margin range: In insurance, this is viewed via the Loss Ratio (Losses / Earned Premiums), typically ranging from 55% to 65% for Commercial Lines and 65% to 75% for Personal Lines.
- Key input costs and commodity exposures: Auto repair costs, medical inflation, litigation trends (social inflation), and weather event frequency.
- How COGS scales with revenue: Directly proportional to earned premiums, but highly volatile due to unpredictable CAT events and reserve adjustments.
Operating Expenses (Underwriting Expenses)
- R&D: Not applicable for this industry.
- SG&A: Termed "Amortisation of Deferred Acquisition Costs" (commissions) and "Other Underwriting Expenses" (staffing, technology, marketing).
- Depreciation & Amortisation: Minimal relative to revenue; primarily relates to capitalised software and IT infrastructure.
- Stock-Based Compensation: Approx. 0.5% of revenue, not a material driver compared to tech companies.
- Restructuring / one-time charges: Infrequent, though occasional charges occur for real estate footprint reductions or IT overhauls.
Margin Profile
- Combined Ratio (Loss Ratio + Expense Ratio): The primary margin metric. A ratio below 100% indicates an underwriting profit. The Hartford typically targets an underlying combined ratio of 87% to 90% in Commercial Lines and 90% to 94% in Personal Lines.
- Margin trend: Expanding in Personal Lines due to earned pricing increases outpacing loss trends; stable and highly profitable in Commercial Lines.
- Segment-level margins: Group Benefits targets a core earnings margin of 7.5% to 8.5%.
Balance Sheet Structure
- Total assets: Approximately $75 billion to $80 billion.
- Key asset categories: Investments (fixed maturities, equities, limited partnerships) make up the vast majority of assets. Reinsurance recoverables, premiums receivable, and Deferred Acquisition Costs (DAC) are also material.
- Goodwill & intangibles as % of total assets: Low (approx. 2% to 3%), stemming from historical acquisitions like Navigators Group.
- Working capital profile:
- Days Sales Outstanding (DSO): Not a standard metric for insurance.
- Days Inventory Outstanding (DIO): Not applicable.
- Days Payable Outstanding (DPO): Not applicable.
- Net working capital as % of revenue: Insurers operate with massive negative working capital (float). They collect premiums upfront and hold them as reserves until claims are paid years later.
- PP&E: Immaterial. Consists mostly of corporate real estate and IT equipment.
- Right-of-use assets / operating leases: Minor, related to branch office leases.
Capital Expenditure & Investment
- Capex as % of revenue: Less than 1%.
- Maintenance capex vs. growth capex: Almost entirely IT infrastructure and software development (e.g., the Prevail platform).
- Major capex programmes underway or planned: Modernisation of claims systems and digital agency interfaces.
- Capitalised software / development costs if material: Yes, the majority of "capex" is capitalised internal-use software.
- M&A pattern: Historically a bolt-on acquirer (e.g., Navigators Group for specialty commercial lines, Aetna's US group life and disability business).
- Typical acquisition multiple paid: 1.5x to 2.0x Book Value for specialty P&C assets.
Debt & Capital Structure
- Total debt: Approximately $4.0 billion to $4.5 billion.
- Debt/EBITDA ratio: Insurers use Debt-to-Capital ratios. The Hartford targets a Debt-to-Capital ratio of 20% to 25%.
- Credit rating: A- range (S&P/Fitch) for the holding company; AA- range for the operating insurance subsidiaries.
- Key debt instruments: Senior unsecured notes and junior subordinated debentures.
- Maturity profile: Well-laddered, with average maturities exceeding 10 years.
- Interest rate profile: Almost entirely fixed-rate debt.
- Covenants: Standard limitations on liens and holding company debt limits; no restrictive financial maintenance covenants that are currently at risk.
- Share repurchase programme: Highly active. The Board authorised a $3.3 billion programme running through 2026, translating to roughly $400 million to $450 million in buybacks per quarter.
- Dividend policy: Quarterly dividend of approx. $0.52 per share, yielding around 1.5% to 2.0%, with a history of annual increases.
Cash Flow Characteristics
- Operating cash flow conversion: Highly variable due to the timing of claim payouts versus premium collection.
- Free cash flow margin: Not a primary valuation metric for insurers. Dividends from operating subsidiaries to the holding company are the true measure of "free cash flow" available to shareholders.
- Major non-cash items that bridge net income to OCF: Reserve changes (PYD), depreciation, amortisation of DAC, and realised/unrealised capital gains or losses.
- Working capital cash flow impact: Premium growth generates positive operating cash flow upfront (increasing float).
- Capex intensity: Extremely low.
- Cash tax rate vs. GAAP effective tax rate: Cash taxes often differ due to the timing of loss reserve deductibility and tax-exempt municipal bond income.
Sheet Structure
- Assumptions: Hardcoded drivers for premium growth, rate changes, loss ratios, expense ratios, investment yields, and capital return programmes.
- Summary & Scenarios: Consolidated outputs, core earnings per share, ROE metrics, and toggle switches for bull/base/bear cases.
- Commercial Lines: Written premiums, earned premiums, CAY losses, CAT losses, PYD, underwriting expenses, and combined ratio calculation.
- Personal Lines: Written premiums, earned premiums, auto vs home split, CAY losses, CAT losses, PYD, underwriting expenses, and combined ratio calculation.
- Group Benefits: Fully insured premiums, fee income, benefits and losses, operating expenses, and core earnings margin calculation.
- Hartford Funds & Corporate: AUM roll-forward, fee revenue, corporate interest expense, and run-off operations.
- Investment Portfolio: Asset allocation (fixed maturities, LPs), book yield, new money rate, and net investment income forecasting.
- Consolidated Income Statement: Aggregation of segment revenues, consolidated benefits/expenses, tax, and net income available to common stockholders.
- Balance Sheet: Invested assets, DAC, reserves (unpaid losses), unearned premiums, debt, and stockholders' equity (including AOCI).
- Holding Company Cash Flow: Dividends received from subsidiaries, interest paid, share repurchases, shareholder dividends paid, and holding company liquidity.
- Valuation: Sum-of-the-parts (SOTP) applying P/E multiples to segment core earnings, and a Dividend Discount Model (DDM) based on holding company cash flows.
Key Financial Relationships
- Commercial Lines Earned Premium = Prior Period Unearned Premium + Current Period Written Premium - Current Period Unearned Premium
- Commercial Lines Combined Ratio = (Losses and Loss Adjustment Expenses + Underwriting Expenses) / Earned Premiums
- Underlying Combined Ratio = Combined Ratio - (Catastrophe Losses / Earned Premiums) - (Prior Year Development / Earned Premiums)
- Personal Lines Auto Revenue = Auto Policies in Force x Average Auto Premium per Policy
- Group Benefits Core Earnings = Segment Revenues - Benefits and Expenses - Tax Expense
- Group Benefits Core Earnings Margin = Group Benefits Core Earnings / Total Segment Revenues
- Hartford Funds Revenue = Average AUM x Blended Management Fee Rate
- Net Investment Income = Average Invested Assets x Annualised Portfolio Yield
- Total Invested Assets = Prior Period Invested Assets + Operating Cash Flow - Dividends Paid - Share Repurchases
- Core Earnings = Net Income - Net Realised Capital Gains/Losses - Restructuring Charges
- Core Earnings ROE = Annualised Core Earnings / Average Common Equity Excluding AOCI
- Book Value Per Share (Ex-AOCI) = (Total Equity - AOCI) / Ending Shares Outstanding
- Ending Shares Outstanding = Prior Shares - (Share Repurchase Amount / Average Share Price)
Cross-Sheet Dependencies
- The Assumptions sheet drives the growth and margin inputs across all segment sheets (Commercial Lines, Personal Lines, Group Benefits, Hartford Funds & Corporate).
- The segment sheets feed directly into the Consolidated Income Statement to calculate total revenues and net income.
- The Consolidated Income Statement feeds net income to the Balance Sheet (Retained Earnings) and operating cash flow proxies to the Investment Portfolio.
- The Investment Portfolio calculates Net Investment Income, which feeds back into the Consolidated Income Statement. This creates a circular reference: higher net income increases invested assets, which increases net investment income, which increases net income. The builder must use a circularity breaker or average asset balances.
- The Holding Company Cash Flow sheet relies on net income from the Consolidated Income Statement to determine subsidiary dividend capacity, which dictates the cash available for the share repurchases calculated on the Balance Sheet.
Sign Convention
- Revenues (Premiums, Fees, Net Investment Income) are entered and displayed as positive numbers.
- Expenses (Losses, Underwriting Expenses, Interest Expense) are entered and displayed as positive numbers.
- In the Income Statement, calculate Net Income as Revenues minus Expenses.
- Prior Year Development (PYD): Favourable development (reserve releases) should be treated as a reduction to losses (negative expense). Unfavourable development should be treated as an addition to losses (positive expense).
- Cash flow outflows (dividends paid, share repurchases, debt paydown) are negative.
Things Most Likely to Go Wrong
- Failing to separate the Underlying Combined Ratio from the reported Combined Ratio. The model must explicitly forecast CAT losses and PYD separately from underlying loss trends, as underlying margins are the true run-rate of the business.
- Mishandling Accumulated Other Comprehensive Income (AOCI). Rising interest rates cause massive unrealised losses on the fixed income portfolio, crushing GAAP Book Value. The model must calculate Book Value *excluding* AOCI, as this is the metric management and analysts use.
- Incorrectly forecasting Net Investment Income by applying a single yield to all assets. Limited Partnerships (LPs) return 8% to 12% but are highly volatile, while fixed maturities yield 4% to 5%. These must be modelled as separate asset pools.
- Ignoring the share count reduction. The Hartford repurchases over $1.5 billion in stock annually. Failing to dynamically reduce the share count will severely understate EPS and overstate the market capitalisation.
- Misunderstanding Prior Year Development (PYD). The Hartford frequently releases reserves (favourable PYD) in workers' compensation, which flatters current earnings. The model should assume zero PYD in the terminal year to reflect true run-rate earnings.
- Applying standard corporate Free Cash Flow (FCF) concepts. Insurers do not have traditional FCF. The model must use Holding Company Dividend Capacity (statutory capital generation) to fund buybacks and dividends.
- Overestimating Personal Lines growth. The recent 12% to 14% growth is driven by massive rate increases to combat auto severity, not policy count growth. As rates normalise, premium growth will decelerate sharply.
- Failing to account for the Navigators ADC (Adverse Development Cover). The company amortises a deferred gain related to this reinsurance treaty, which appears as a specific benefit in PYD.
Validation Checks
- Commercial Lines Combined Ratio should remain in the 87% to 92% range; flag if it drops below 85% (unsustainably profitable) or exceeds 95%.
- Personal Lines Underlying Combined Ratio should trend towards 90%; flag if it remains above 95% beyond year 2.
- Group Benefits Core Earnings Margin should be between 7.0% and 8.5%; flag if outside this band.
- Total Assets must exactly equal Total Liabilities plus Stockholders' Equity in every forecast period.
- Net Investment Income yield on fixed maturities should closely track the assumed new money rate over a 5-year period.
- Debt-to-Capital ratio should remain between 20% and 25%; flag if leverage exceeds 30%.
- Core Earnings ROE should be in the 15% to 18% range based on recent management targets.
- Annual share repurchases should not exceed the holding company's available liquidity plus subsidiary dividend capacity.
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| Commercial Lines Premium Growth | 7.5 | % | Blended rate of specialty growth and workers' comp rate pressure based on recent 10-K. |
| Commercial Lines Underlying Combined Ratio | 87.5 | % | Aligns with recent management guidance and historical performance. |
| Commercial Lines CAT Load | 4.5 | % | Historical average catastrophe loss impact on the combined ratio. |
| Personal Lines Premium Growth | 10.0 | % | Reflects ongoing rate increases in auto, tapering off in outer years. |
| Personal Lines Underlying Combined Ratio | 90.5 | % | Target profitability level following recent aggressive pricing actions. |
| Personal Lines CAT Load | 8.0 | % | Higher exposure to weather events in the homeowners book. |
| Group Benefits Premium Growth | 3.0 | % | Steady growth in fully insured ongoing premiums. |
| Group Benefits Core Earnings Margin | 8.0 | % | Midpoint of management's long-term target range. |
| Fixed Income Portfolio Yield | 4.6 | % | Reflects current reinvestment rates and recent portfolio book yield. |
| Limited Partnership (LP) Return | 9.0 | % | Long-term historical average for private equity and real estate LP investments. |
| Effective Tax Rate | 19.5 | % | Lower than statutory 21% due to tax-exempt municipal bond income. |
| Annual Share Repurchases | 1,600 | $ Millions | Aligns with the $3.3 billion authorisation running through 2026. |
| Quarterly Dividend per Share | 0.52 | $ | Current declared dividend rate. |
| Cost of Equity (Ke) | 9.5 | % | Standard CAPM assumption for a large-cap P&C insurer. |
| Terminal P/E Multiple | 11.5 | x | Historical average forward multiple for HIG core earnings. |
Data Sources & Benchmarks
- SEC EDGAR / Investor Relations: The Hartford's Investor Relations page for the 2024/2025 10-K, Quarterly Financial Supplements (QFS), and Earnings Presentations.
- Key Peers for Benchmarking: The Travelers Companies (TRV), Chubb Limited (CB), The Progressive Corporation (PGR), and Allstate (ALL).
- Industry Data Sources: AM Best for P&C industry rating and loss cost trends; Council of Insurance Agents & Brokers (CIAB) for commercial P&C pricing indices.
- Consensus Estimates: FactSet or Bloomberg for consensus core EPS, combined ratios, and book value estimates.
Sources
- The Hartford Financial Services Group, Inc. Form 10-K for the fiscal year ended December 31, 2024.
- The Hartford Q4 2024 and Full Year 2024 Earnings Release.
- The Hartford Q4 2025 and Full Year 2025 Earnings Release.
- The Hartford Q2 2024 Earnings Release.
- The Hartford Q3 2024 Investor Financial Supplement (IFS).
- Trefis Strategic Expansion Analysis for HIG (2025/2026).
- StockStory HIG Q4 CY2025 Research Report.
Do more with the Hartford model
Frequently asked
What services does The Hartford Financial Services Group provide?+
The Hartford Financial Services Group, Inc. is a leading US-based insurance and financial services holding company. It primarily offers property and casualty insurance, group benefits, and mutual funds to individual and business customers. Its main business segments include Commercial Lines, Personal Lines, Group Benefits, and Hartford Funds.
How does The Hartford generate its revenue?+
The Hartford generates revenue primarily through premiums collected from its Commercial Lines, Personal Lines, and Group Benefits insurance products. Additionally, its Hartford Funds segment contributes through mutual funds and exchange-traded funds. The company's asset-heavy business model also relies on generating investment float from premiums collected upfront before claims are paid.
What is The Hartford's typical capital expenditure profile?+
The Hartford's capital expenditure as a percentage of revenue is typically less than 1%. This spending is almost entirely focused on IT infrastructure and software development, such as modernizing claims systems and digital agency interfaces. The majority of this "capex" is capitalized internal-use software.
What are the key focus areas for an equity valuation of The Hartford?+
An equity valuation of The Hartford would primarily focus on property and casualty underwriting profitability, Group Benefits margin expansion, and the yield generated from its investment portfolio. These aspects are critical for understanding the company's earnings potential and overall value.
Can I download an Excel financial model for The Hartford?+
Yes, an Excel financial model for The Hartford is available for download. This model provides a comprehensive sum-of-the-parts equity valuation and earnings forecasting tool. It covers a forecast horizon from FY2026 through FY2030.
How does The Hartford's working capital structure differ from typical companies?+
The Hartford, like other insurers, operates with massive negative working capital, often referred to as "float." This is because the company collects premiums upfront from customers and holds these funds as reserves for years before claims are paid out. This unique structure means standard working capital metrics like Days Sales Outstanding are not applicable.
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.
