# Allstate (ALL) Financial Model Free Excel 3-statement financial model and company analysis for Allstate. - Canonical: https://finamodel.com/companies/allstate - Industry: Insurance - Downloadable model: Yes - Excel download: https://finamodel.com/company-models/ALL.xlsx ## Model Purpose This model projects Allstate's underwriting profitability, investment income, and capital return capacity to determine its equity valuation, specifically evaluating the impact of recent auto rate increases and the 2025 divestiture of its Health and Benefits businesses. ## Company Overview The Allstate Corporation is one of the largest publicly held personal lines property and casualty insurers in the United States. The company protects people from life's uncertainties through auto, homeowners, and other personal lines insurance, distributed via exclusive agents, independent agents, and direct channels. Business segments include: * **Allstate Protection** (approx. 92% of premiums): Private passenger auto, homeowners, and other personal lines. * **Protection Services** (approx. 5% of revenues): Allstate Protection Plans, Roadside Assistance, and identity protection. * **Investments**: Management of the float and capital to generate net investment income. Key geographies are strictly domestic, with operations heavily concentrated in the United States and a minor presence in Canada. The business model is a traditional P&C insurance model, relying on underwriting margin (collecting more in premiums than paid out in claims and expenses) and investment income generated from float. Allstate holds a top-tier market share in US personal lines, competing directly with Progressive, Geico, State Farm, and Travelers. In 2025, Allstate executed a major strategic shift by divesting its Employer Voluntary Benefits business to StanCorp for $2.0 billion and its Group Health business to Nationwide for $1.25 billion, pivoting to a pure-play property-liability and protection services focus. ## Revenue Deep Dive ### Allstate Protection - Auto Insurance * **Segment name**: Allstate Protection - Auto * **Revenue driver formula**: Policies in Force (PIF) x Average Premium per Policy * **Historical growth rate**: 4-6% CAGR (driven heavily by recent rate increases rather than volume) * **Key growth levers and headwinds**: Regulatory approval for rate increases, frequency of driving (miles driven), customer retention rates, and direct-to-consumer channel growth. * **Pricing dynamics**: Highly regulated at the state level; Allstate must file for rate increases with state departments of insurance to offset inflation in vehicle repair and medical costs. * **Revenue recognition notes**: Premiums are written upfront and earned pro-rata over the life of the policy (typically 6 months). * **Seasonality**: Premium writing is relatively smooth, but earned premiums follow the amortisation of the unearned premium reserve. ### Allstate Protection - Homeowners Insurance * **Segment name**: Allstate Protection - Homeowners * **Revenue driver formula**: Policies in Force (PIF) x Average Premium per Policy * **Historical growth rate**: 8-12% CAGR * **Key growth levers and headwinds**: Housing market turnover, inflation in building materials (driving up insured values), and climate-related risk appetite in states like California and Florida. * **Pricing dynamics**: Regulated state-by-state; pricing is heavily dependent on catastrophe modelling and reinsurance costs. * **Revenue recognition notes**: Earned pro-rata over the 12-month policy term. * **Seasonality**: Q2 and Q3 typically see higher catastrophe losses (weather events), which impacts the net underwriting income rather than the top-line revenue. ### Protection Services * **Segment name**: Protection Services * **Revenue driver formula**: Active Subscriptions/Plans x Average Revenue per Plan * **Historical growth rate**: 8-12% CAGR * **Key growth levers and headwinds**: Retail partnerships (e.g., selling extended warranties on electronics), consumer electronics sales volumes, and vehicle sales (for roadside assistance). * **Pricing dynamics**: Contractual and competitive, often embedded at the point of sale with retail partners. * **Revenue recognition notes**: Recognised over the life of the protection plan or warranty contract. * **Seasonality**: Q4 is typically strongest due to holiday retail sales driving new protection plan attachments. ### Net Investment Income * **Segment name**: Net Investment Income * **Revenue driver formula**: Average Invested Assets x Portfolio Yield * **Historical growth rate**: Highly variable based on interest rate environment (grew significantly in 2024-2025). * **Key growth levers and headwinds**: Federal Reserve interest rate policy, fixed income duration management, and operating cash flow generation (adding to the float). * **Pricing dynamics**: Market-driven yields on fixed income securities and alternative investments. * **Revenue recognition notes**: Interest and dividends recognised as earned; realised capital gains/losses reported separately. * **Seasonality**: Generally smooth, though alternative investment income (private equity/real estate) can be lumpy and is often reported on a one-quarter lag. ## Cost Structure ### Losses and Loss Adjustment Expenses (LAE) * **Line-by-line breakdown**: Claims paid to policyholders, costs to settle claims (adjuster fees, legal defence), and changes in reserves for claims incurred but not reported (IBNR). * **Gross margin range**: In insurance, this is viewed via the Loss Ratio (Losses & LAE / Earned Premiums). The 5-year range is highly volatile, from 65% to 85%. * **Key input costs and commodity exposures**: Used car prices, auto parts, medical inflation, lumber, and roofing materials. * **How COGS scales with revenue**: Step-function based on weather events (catastrophes) and inflation trends; it does not scale linearly with premiums in the short term. ### Operating Expenses * **Amortisation of Deferred Acquisition Costs (DAC)**: Commissions and premium taxes capitalised and expensed over the policy term. Typically runs at 10-12% of premiums. * **Other Underwriting Expenses**: Advertising, IT, and administrative salaries. Allstate has aggressively reduced this through its Transformative Growth initiative. * **Restructuring / one-time charges**: Frequent in recent years due to real estate footprint reductions and agent compensation restructuring. ### Margin Profile * **Combined Ratio**: The primary margin metric (Loss Ratio + Expense Ratio). A ratio below 100 indicates an underwriting profit. Allstate's FY2025 combined ratio was 85.2 (a massive improvement from the unprofitable 2022-2023 period). * **Margin trend**: Expanding rapidly in 2025 as cumulative auto rate increases outpaced moderating loss cost inflation. * **Segment-level margins**: Homeowners combined ratio was 84.4 in FY2025; Auto combined ratio was approximately 85.0 for FY2025. ## Balance Sheet Structure * **Total assets**: Approximately $100 billion. * **Key asset categories**: Fixed income securities (the float), Premium Receivables, Deferred Acquisition Costs (DAC), and Reinsurance Recoverables. * **Goodwill & intangibles as % of total assets**: Less than 5%, primarily from the National General acquisition. * **Working capital profile**: * Insurance companies do not use traditional working capital metrics (DSO/DIO/DPO). * Instead, they operate with negative working capital dynamics: premiums are collected upfront (Unearned Premium Reserve liability) and claims are paid later (Reserve for Property-Liability Claims liability). * **PP&E**: Minimal. The company has been reducing its owned real estate footprint. * **Right-of-use assets / operating leases**: Immaterial relative to the investment portfolio. ## Capital Expenditure & Investment * **Capex as % of revenue**: Less than 1%. * **Maintenance capex vs. growth capex**: Almost entirely IT infrastructure and capitalised software development for direct-to-consumer platforms. * **Major capex programmes underway or planned**: Telematics technology (Drivewise) and pricing algorithm enhancements. * **M&A pattern**: Historically a bolt-on acquirer (National General in 2021), but 2024/2025 was marked by major divestitures ($3.25 billion combined sale of Health and Benefits units). ## Debt & Capital Structure * **Total debt**: Approximately $8 billion. * **Debt/Capital ratio**: Target range is 20-25%. * **Credit rating**: A- range (S&P/Moody's). * **Key debt instruments**: Senior notes, subordinated debentures, and preferred stock. * **Maturity profile**: Well-laddered with average maturity exceeding 10 years. * **Interest rate profile**: Predominantly fixed-rate unsecured debt. * **Share repurchase programme**: Highly active. Initiated a new $4.0 billion programme in Q1 2026 after completing a $1.5 billion programme in 2025. * **Dividend policy**: Progressive dividend policy. Increased to $1.08 per quarter ($4.32 annualised) in early 2026. ## Cash Flow Characteristics * **Operating cash flow conversion**: Highly dependent on reserve development. Strong premium growth increases OCF immediately due to upfront collection. * **Free cash flow margin**: Not a standard metric for insurers. Analysts focus on Parent Company Deployable Assets and statutory dividend capacity from the insurance subsidiaries to the holding company. * **Major non-cash items**: Change in unearned premiums, change in loss reserves, depreciation, and amortisation of DAC. * **Working capital cash flow impact**: Growth in policies in force provides a massive source of cash flow due to the float. * **Capex intensity**: Extremely low. * **Cash tax rate vs. GAAP effective tax rate**: Generally aligned around 21%, though tax-exempt municipal bond income lowers the effective rate. ## Sheet Structure 1. **Assumptions**: Hardcoded inputs for PIF growth, rate increases, loss ratios, expense ratios, investment yields, and capital return policies. 2. **Scenarios & Summary**: Dashboard showing base, bull, and bear cases for catastrophe losses and auto severity inflation, alongside a 5-year financial summary. 3. **Premium Build**: Row-level detail for Allstate Protection (Auto PIF, Auto Premium/Policy, Homeowners PIF, Homeowners Premium/Policy) and Protection Services. Calculates Written and Earned Premiums. 4. **Underwriting & Claims**: Calculates Losses and LAE (split by catastrophe and non-catastrophe), Amortisation of DAC, and Other Underwriting Expenses to derive the Combined Ratio for each segment. 5. **Investment Portfolio**: Tracks the fixed income and equity asset balances, applies the portfolio yield, and calculates Net Investment Income. 6. **Income Statement**: Mirrors the 10-K. Revenues (Premiums earned, Net investment income, Protection Services revenue) less Costs (Property-liability insurance claims, DAC amortisation, Operating costs) to calculate Net Income. 7. **Balance Sheet**: Assets (Investments, Premium Receivables, DAC) and Liabilities (Reserve for claims, Unearned premiums, Debt). Must include a schedule for Parent Company Deployable Assets. 8. **Cash Flow Statement**: Net income bridged by reserve changes and unearned premium changes to Operating Cash Flow. 9. **Debt & Equity Schedule**: Tracks debt maturities, preferred stock dividends, common dividends, and the $4.0 billion share repurchase programme. 10. **Valuation**: Dividend Discount Model (DDM) and Price/Book or Price/Earnings multiple valuation, as DCF is inappropriate for financial institutions. ## Key Financial Relationships 1. `Auto Written Premiums = Auto Beginning PIF x Auto Average Premium per Policy x (1 + Rate Increase %)` 2. `Earned Premiums = Beginning Unearned Premiums + Written Premiums - Ending Unearned Premiums` 3. `Property-Liability Claims and Claims Expense = Earned Premiums x Loss Ratio` 4. `Loss Ratio = (Non-Catastrophe Losses + Catastrophe Losses + Prior Year Reserve Re-estimates) / Earned Premiums` 5. `Amortisation of DAC = Earned Premiums x DAC Expense Ratio (historically ~10-12%)` 6. `Underwriting Expense Ratio = Other Underwriting Expenses / Earned Premiums` 7. `Combined Ratio = Loss Ratio + DAC Expense Ratio + Underwriting Expense Ratio` 8. `Underwriting Income = Earned Premiums x (1 - Combined Ratio)` 9. `Net Investment Income = Average Total Investments x Annualised Portfolio Yield` 10. `Ending Unearned Premium Reserve = Beginning Unearned Premium Reserve + Written Premiums - Earned Premiums` 11. `Ending Loss Reserve = Beginning Loss Reserve + Incurred Claims - Paid Claims` 12. `Parent Company Dividend Capacity = Statutory Net Income of Insurance Subsidiaries x Maximum Allowable Payout Ratio` ## Cross-Sheet Dependencies * The **Premium Build** sheet feeds Written Premiums to the **Balance Sheet** (Unearned Premiums) and Earned Premiums to the **Income Statement**. * The **Underwriting & Claims** sheet relies on Earned Premiums from the **Premium Build** sheet to calculate dollar-value claims based on assumed Loss Ratios. * The **Cash Flow Statement** requires the change in Unearned Premiums and Loss Reserves from the **Balance Sheet** to calculate Operating Cash Flow. * Operating Cash Flow feeds the **Investment Portfolio** balance, which in turn drives Net Investment Income on the **Income Statement**. * Circularity risk: Share repurchases on the **Debt & Equity Schedule** reduce Cash/Investments, which lowers Net Investment Income, which lowers Net Income, which lowers Retained Earnings and Cash. This requires an iterative calculation or a macro to resolve. ## Sign Convention * Premiums, Revenues, and Net Investment Income are entered and displayed as positive numbers. * Claims, LAE, DAC Amortisation, and Operating Expenses are entered as positive assumptions (e.g., a 70% loss ratio) but subtracted in the Income Statement to calculate Net Income. * In the Cash Flow Statement, increases in assets (like Premium Receivables) are negative, while increases in liabilities (like Unearned Premiums or Loss Reserves) are positive. * Dividends and Share Repurchases are negative cash flows in the financing section. ## Things Most Likely to Go Wrong * **Health & Benefits Divestiture**: The model must exclude the Employer Voluntary Benefits and Group Health segments from 2026 onwards, as they were sold in 2025. Historicals will look artificially inflated compared to the forecast if not adjusted. * **Catastrophe Loss Volatility**: Assuming a flat dollar amount for cat losses is dangerous. The model must forecast cat losses as a percentage of earned premiums (typically 6-8%) to scale with exposure growth. * **Prior Year Reserve Development**: Allstate frequently reports reserve re-estimates (e.g., $719 million favourable in Q4 2025). The forecast should assume zero prior-year development, but historicals must isolate this to calculate the *underlying* combined ratio. * **Statutory vs GAAP Equity**: Valuation multiples (Price/Book) rely on GAAP equity, but dividend capacity relies on Statutory capital. The model must not confuse the two. * **Float Miscalculation**: Failing to link the growth in Unearned Premiums and Loss Reserves to the Investment Portfolio balance will severely understate Net Investment Income. * **Share Count Reduction**: With a $4.0 billion buyback programme against a ~$55 billion market cap, the share count will drop rapidly. EPS will grow much faster than Net Income. * **DAC Capitalisation**: Do not expense all acquisition costs upfront. They must be deferred and amortised over the policy period. * **Interest Rate Sensitivity**: Locking the investment yield at a static historical rate ignores the reality of maturing bonds being reinvested at current market rates. ## Validation Checks * "Consolidated Combined Ratio must be between 85.0 and 100.0; flag if outside this band." * "Auto Loss Ratio should be in the 65-75% range; flag if severity inflation assumptions push this higher." * "Total Assets must equal Total Liabilities + Shareholders' Equity in every period." * "Net Investment Income yield should approximate 4.5-5.0% based on the current fixed-income environment." * "Share count must decrease by the Share Repurchase Amount divided by the Average Share Price in each period." * "Dividends paid cannot exceed Parent Company Deployable Assets without triggering a debt issuance." * "Premium growth should not exceed 10% without a corresponding increase in the Unearned Premium Reserve." ## Key Assumptions (Default Values) | Assumption | Default Value | Unit | Rationale | |---|---|---|---| | Auto PIF Growth | 2.5 | % | Based on Q4 2025 recovery in policy growth after years of intentional shrinkage. | | Auto Premium Rate Increase | 4.0 | % | Moderating from the double-digit increases of 2023-2024 as rate adequacy is achieved. | | Homeowners PIF Growth | 3.0 | % | Consistent with FY2025 actual growth driven by broad distribution. | | Homeowners Premium Rate Increase | 6.0 | % | Ongoing adjustments for elevated building material costs and reinsurance rates. | | Auto Underlying Combined Ratio | 85.0 | % | Aligns with FY2025 actuals following successful profitability initiatives. | | Homeowners Combined Ratio | 84.5 | % | Matches FY2025 actual performance (84.4 reported). | | Catastrophe Losses (% of Premiums) | 7.0 | % | Long-term historical average to normalise weather volatility. | | DAC Expense Ratio | 11.0 | % | Stable historical average for commission and acquisition cost amortisation. | | Investment Portfolio Yield | 4.8 | % | Reflects the higher interest rate environment and recent portfolio duration extensions. | | Effective Tax Rate | 21.0 | % | Standard US corporate rate, adjusted slightly for tax-advantaged municipal bonds. | | Annual Share Repurchases | 2,000 | $ Millions | Run-rate to execute the new $4.0 billion programme over approximately two years. | | Quarterly Dividend per Share | 1.08 | $ | Actual declared dividend increase for Q2 2026. | | Cost of Equity (Ke) | 9.0 | % | Standard CAPM assumption for a large-cap, regulated P&C insurer. | | Terminal P/B Multiple | 2.2 | x | Historical average for Allstate when generating mid-to-high teens ROE. | ## Data Sources & Benchmarks * **Filings**: SEC EDGAR (Allstate 10-K, 10-Q, 8-K) and Allstate Investor Relations website (allstateinvestors.com) for quarterly financial supplements and slides. * **Key Peers**: Progressive (PGR), Travelers (TRV), Chubb (CB), and Berkshire Hathaway / Geico (BRK.B). * **Industry Data**: A.M. Best for P&C industry combined ratio benchmarks; NAIC (National Association of Insurance Commissioners) for statutory data. * **Macro Data**: Manheim Used Vehicle Value Index (for auto severity inflation), FRED (Federal Reserve Economic Data) for 10-year Treasury yields driving investment income. ## Sources * Allstate Q4 2025 Earnings Release and Presentation Slides (February 2026) * Allstate 2024 and 2025 Annual Reports on Form 10-K * Press Release: Allstate Completes Sale of Employer Voluntary Benefits Business to StanCorp (April 2025) * Press Release: Allstate Completes Sale of Group Health Business to Nationwide (July 2025) * Allstate Chair, President & CEO Letter to Shareholders (April 2025) --- ## Frequently asked questions ### What is Allstate's primary business model? Allstate operates as a traditional Property & Casualty (P&C) insurer, primarily generating revenue through underwriting margins and investment income. The company collects premiums upfront and invests the 'float' until claims are paid, aiming to profit from both activities. ### How does Allstate generate its revenue? Allstate primarily generates revenue from premiums collected for auto, homeowners, and other personal lines insurance through its Allstate Protection segment. Additionally, it earns revenue from Protection Services like Allstate Protection Plans and Roadside Assistance, and significant investment income from managing its capital and float. ### What are the key assumptions regarding Allstate's revenue growth in financial models? Financial models for Allstate often assume a revenue growth rate, such as 8.28% in the provided context, reflecting expected premium increases and business expansion. This assumption is crucial for projecting future top-line performance and overall profitability. ### What is Allstate's capital expenditure strategy? Allstate's capital expenditure is minimal, typically less than 1% of revenue, and primarily focused on IT infrastructure and capitalized software development. These investments support telematics technology and pricing algorithm enhancements rather than significant physical assets. ### How does Allstate's balance sheet structure impact its valuation? Allstate's balance sheet features significant fixed income securities as key assets and operates with negative working capital dynamics, where premiums are collected upfront. These unique characteristics, including large Unearned Premium Reserve and Claims liabilities, are critical inputs for determining its equity valuation and capital return capacity. ### Where can I download a financial model for Allstate (ALL)? A downloadable Excel financial model for Allstate (ALL) is available, forecasting performance from FY2026 to FY2030. This model allows users to analyze underwriting profitability, investment income, and the impact of strategic shifts like recent auto rate increases and the 2025 divestiture of Health and Benefits businesses. [Interactive forecast calculator](https://finamodel.com/companies/allstate/forecast)