W. R. Berkley Financial Model
Insurance Company Financials Example (Free Excel Download)
W.
professionals from Deloitte
Used by professionals from
About this model
This model projects the statutory and GAAP earnings, reserve adequacy, and dividend-paying capacity of W. R. Berkley Corporation to determine its equity valuation and assess its capital return profile for an equity research analyst.
W. R. Berkley Corporation is a commercial lines property and casualty (P&C) insurance holding company operating through a highly decentralised structure of over 50 distinct operating units. The company focuses on specialty niches and local markets, allowing it to maintain strict underwriting discipline and pricing power.
- Insurance Segment (approx. 85% of Net Premiums Written): Commercial insurance products including general liability, workers' compensation, commercial auto, and professional liability.
- Reinsurance & Monoline Excess Segment (approx. 15% of Net Premiums Written): Treaty and facultative reinsurance, alongside monoline excess coverage.
- Key Geographies: Primarily the United States, with select international operations in the UK, Continental Europe, South America, and Asia-Pacific.
- Business Model Type: Balance sheet intensive, float-driven P&C insurance model generating returns through both underwriting profitability and net investment income.
- Competitive Position: A top-tier US commercial lines writer known for its low-volatility underwriting, consistent reserve adequacy, and opportunistic capital management.
- Recent Major Events: Record gross premiums written of $15.1 billion in 2025, alongside significant capital returns including the repurchase of over four million shares and the payment of the largest special dividends in the company's history.
The downloadable W. R. Berkley 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 & AssumptionsW. R. Berkley financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $9.46B | $11.17B | $12.14B | $13.64B | $14.71B |
| Income before income taxes | $1.28B | $1.72B | $1.75B | $2.26B | $2.28B |
| Net income before noncontrolling interests | $1.03B | $1.38B | $1.38B | $1.75B | $1.78B |
| Net income | $1.02B | $1.38B | $1.38B | $1.76B | $1.78B |
How to build a detailed financial model for W. R. Berkley
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Insurance Segment
- Segment Name: Insurance
- Revenue Driver Formula: Gross Premiums Written (GPW) x Premium Retention Ratio = Net Premiums Written (NPW); NPW adjusted for Change in Unearned Premiums = Net Premiums Earned (NPE).
- Historical Growth Rate: 8-10% CAGR over the last 3 years, driven by strong rate increases.
- Key Growth Levers and Headwinds: Commercial P&C pricing cycles, inflation impacts on exposure bases, and competition in workers' compensation lines.
- Pricing Dynamics: Highly cyclical but currently benefiting from average rate increases of approximately 7.6% (excluding workers' compensation) in 2025.
- Revenue Recognition Notes: Premiums are earned pro-rata over the policy term; unearned premiums sit as a liability on the balance sheet.
- Seasonality: First quarter often sees high renewal volumes, but premium earning is smoothed over the year.
Reinsurance & Monoline Excess Segment
- Segment Name: Reinsurance & Monoline Excess
- Revenue Driver Formula: Assumed Premiums x Retention Ratio = NPW; NPW adjusted for Change in Unearned Premiums = NPE.
- Historical Growth Rate: 5-8% CAGR, highly dependent on capacity deployment decisions.
- Key Growth Levers and Headwinds: Catastrophe frequency, primary pricing trends, and alternative capital capacity in the reinsurance market.
- Pricing Dynamics: Spot pricing driven by January 1 and July 1 renewal seasons.
- Revenue Recognition Notes: Earned over the treaty period, often with lag reporting from cedants.
- Seasonality: Q1 and Q3 are critical for renewals, though earnings are recognised linearly.
Net Investment Income
- Segment Name: Net Investment Income
- Revenue Driver Formula: Average Invested Assets x Annualised Book Yield.
- Historical Growth Rate: 15-25% recent CAGR due to the transition from a zero-interest-rate environment to higher yields.
- Key Growth Levers and Headwinds: New money rates versus portfolio book yield, operating cash flow generation, and duration management.
- Pricing Dynamics: Market-driven; the fixed-maturity portfolio yield is the primary engine.
- Revenue Recognition Notes: Recognised as earned; realised and unrealised gains/losses are reported separately from operating income.
- Seasonality: Generally stable, though alternative investment fund returns can be lumpy in Q4.
Cost Structure
Variable Costs / COGS (Losses and LAE)
- Line-by-line breakdown: Losses and Loss Adjustment Expenses (LAE) represent the "COGS" of an insurer.
- Gross margin range: In insurance, this is the inverse of the Loss Ratio. The Loss Ratio typically runs between 60.0% and 64.0%.
- Key input costs: Medical inflation (for workers' compensation), social inflation/litigation costs (for liability lines), and weather events (catastrophes).
- How COGS scales with revenue: Scales directly with earned premium, subject to actuarial reserve development and catastrophe volatility.
Operating Expenses (Underwriting Expenses)
- R&D: Not applicable for this industry.
- SG&A: Termed "Other Operating Costs and Expenses" or "Underwriting Expenses". Includes broker commissions, premium taxes, and internal administrative headcount.
- Depreciation & Amortisation: Minimal, primarily related to IT systems and real estate.
- Stock-Based Compensation: Included in underwriting expenses; historically a low single-digit percentage of earned premiums.
- Restructuring / one-time charges: Rare; the decentralised model allows for organic scaling rather than large corporate restructurings.
Margin Profile
- Loss Ratio: 60.0% to 64.0%.
- Expense Ratio: 28.0% to 30.0%.
- Combined Ratio: 89.0% to 92.0% (89.4% in Q4 2025, 90.7% for full-year 2025).
- Margin trend: Stable to expanding underwriting margins due to disciplined rate increases outpacing loss cost trends.
Balance Sheet Structure
- Total assets: Approximately $35 billion to $40 billion.
- Key asset categories: Fixed maturity securities (largest component), equity securities, cash and cash equivalents, premiums and fees receivable, and reinsurance recoverables.
- Goodwill & intangibles: Very low (typically under 2% of assets) as the company grows organically rather than through large acquisitions.
- Working capital profile:
- Not measured via traditional DSO/DIO/DPO.
- Insurers operate with massive negative working capital (float). They collect premiums upfront and pay claims years later.
- PP&E: Immaterial; mostly corporate real estate and IT infrastructure.
- Right-of-use assets / operating leases: Minor, related to office space for the 50+ decentralised operating units.
Capital Expenditure & Investment
- Capex as % of revenue: Less than 1.0%.
- Maintenance capex vs. growth capex: Almost entirely maintenance and IT system upgrades.
- Major capex programmes underway or planned: Core system modernisations and data analytics platform enhancements.
- Capitalised software / development costs: Small but present for proprietary underwriting platforms.
- M&A pattern: Strictly organic grower. The company prefers to start new operating units from scratch rather than acquire legacy liabilities.
- Typical acquisition multiple paid: N/A.
Debt & Capital Structure
- Total debt: Approximately $3.0 billion to $3.5 billion.
- Debt/EBITDA ratio: Insurers use Debt-to-Total Capital, which typically runs between 20% and 25%.
- Credit rating: A- (S&P) / A3 (Moody's) for senior debt; operating subsidiaries are rated A+ (S&P) / A+ (A.M. Best).
- Key debt instruments: Senior unsecured notes and subordinated debentures.
- Maturity profile: Well-laddered with maturities extending out 10 to 30 years.
- Interest rate profile: Predominantly fixed-rate notes.
- Covenants: Standard debt-to-capital limits and minimum net worth requirements at the holding company level.
- Share repurchase programme: Highly active and opportunistic. Repurchased over 4 million shares in 2025.
- Dividend policy: Pays a modest regular dividend but frequently issues large special dividends when excess capital is not needed for organic growth.
Cash Flow Characteristics
- Operating cash flow conversion: Extremely strong. Operating cash flow routinely exceeds net income due to premium growth generating float.
- Free cash flow margin: Not a standard metric for insurance. Operating cash flow was a record $3.7 billion in 2024.
- Major non-cash items: Change in loss reserves, change in unearned premiums, and net unrealised investment gains/losses.
- Working capital cash flow impact: Premium growth is a massive source of cash (float generation).
- Capex intensity: Negligible.
- Cash tax rate vs. GAAP effective tax rate: Generally aligns closely, hovering around the 21% US statutory rate, adjusted slightly for tax-exempt municipal bond income.
Sheet Structure
- Assumptions: Hardcoded inputs for premium growth, rate changes, loss ratios, expense ratios, investment yields, and capital return policies.
- Premium Build: Projects GPW, NPW, and NPE for the Insurance and Reinsurance & Monoline Excess segments.
- Underwriting Income: Calculates Losses & LAE, Underwriting Expenses, and Pre-Tax Underwriting Income by segment.
- Investment Portfolio: Projects invested asset base, asset allocation, new money yields, and Net Investment Income.
- Income Statement: Consolidated GAAP P&L down to Net Income and Operating Income (excluding FX and investment gains/losses).
- Balance Sheet: Insurance-specific layout highlighting Invested Assets, Reinsurance Recoverables, Unearned Premiums, and Loss Reserves.
- Cash Flow Statement: Indirect method starting from Net Income, heavily driven by changes in reserves and unearned premiums.
- Capital & Dividends: Tracks retained earnings, share repurchases, regular dividends, and special dividends.
- Valuation: Price-to-Book (P/B) and Price-to-Earnings (P/E) multiples, plus a Dividend Discount Model (DDM) suitable for financial institutions.
Key Financial Relationships
- `Insurance NPW = Insurance GPW x Insurance Retention Ratio`
- `Reinsurance NPW = Reinsurance GPW x Reinsurance Retention Ratio`
- `Consolidated NPE = Prior Period Unearned Premiums + Current Period NPW - Ending Unearned Premiums`
- `Segment Losses & LAE = Segment NPE x Segment Loss Ratio`
- `Segment Underwriting Expenses = Segment NPE x Segment Expense Ratio`
- `Segment Combined Ratio = Segment Loss Ratio + Segment Expense Ratio`
- `Pre-Tax Underwriting Income = Consolidated NPE - Consolidated Losses & LAE - Consolidated Underwriting Expenses`
- `Average Invested Assets = (Beginning Invested Assets + Ending Invested Assets) / 2`
- `Net Investment Income = Average Invested Assets x Book Yield`
- `Operating Income = Net Income - After-Tax Net Investment Gains/Losses - After-Tax FX Gains/Losses`
- `Ending Loss Reserves = Beginning Loss Reserves + Losses & LAE Incurred - Paid Claims`
- `Ending Stockholders' Equity = Beginning Equity + Net Income - Regular Dividends - Special Dividends - Share Repurchases + Change in AOCI`
Cross-Sheet Dependencies
- The Premium Build sheet feeds NPE into the Underwriting Income sheet to calculate losses and expenses.
- The Underwriting Income sheet feeds Pre-Tax Underwriting Income into the Income Statement.
- The Premium Build and Underwriting Income sheets feed changes in Unearned Premiums and Loss Reserves into the Balance Sheet and Cash Flow Statement.
- The Cash Flow Statement generates Operating Cash Flow, which feeds the Investment Portfolio sheet to calculate the ending Invested Assets balance.
- The Investment Portfolio sheet calculates Net Investment Income, which feeds back into the Income Statement. This creates a slight circularity (Net Income -> Cash Flow -> Invested Assets -> Investment Income -> Net Income) which must be managed with an iteration toggle or average balance logic.
- The Capital & Dividends sheet draws Net Income from the Income Statement and feeds ending equity back to the Balance Sheet.
Sign Convention
- Revenues (Premiums, Investment Income): Positive.
- Costs and Expenses (Losses, LAE, Underwriting Expenses, Interest Expense): Positive in their specific build schedules, but subtracted in the Income Statement totals.
- Cash Flow: Inflows are positive, outflows (including dividends and share repurchases) are negative.
- Balance Sheet: Assets are positive. Liabilities and Equity are positive. The check must be `Assets - (Liabilities + Equity) = 0`.
- Ratios: Loss Ratio, Expense Ratio, and Combined Ratio are expressed as positive percentages.
Things Most Likely to Go Wrong
- Misunderstanding Float: Do not model working capital like a manufacturer. Premium growth increases cash and liabilities simultaneously; it does not consume cash.
- Ignoring Special Dividends: W. R. Berkley uses special dividends as a primary capital management tool. Failing to model these will result in an artificially inflated equity base and depressed ROE.
- Confusing Operating Income with Net Income: The company defines Operating Income by excluding after-tax net investment gains/losses and FX gains/losses. Valuation should be based on Operating Income.
- Catastrophe Volatility: Assuming a flat loss ratio ignores the reality of weather events. The model must include a baseline catastrophe load (typically 1.5 to 3.0 points on the combined ratio).
- Reserve Development: The company frequently reports favourable or adverse prior-year reserve development. The model should assume zero future development as a baseline, but allow for scenario toggles.
- Investment Yield Lag: Book yield does not instantly jump to the new money rate. The portfolio turns over slowly (duration is typically 3-4 years).
- Premium Retention Mismatch: Gross and Net premiums grow at different rates depending on reinsurance purchasing decisions.
- AOCI Swings: Unrealised gains/losses on fixed maturities flow through Accumulated Other Comprehensive Income (AOCI), causing massive swings in GAAP Book Value. Model Book Value both with and without AOCI.
Validation Checks
- "Combined Ratio must remain between 88.0% and 93.0%; flag if outside this band."
- "Loss Ratio should be in the 60.0% to 64.0% range based on recent history."
- "Debt-to-Total Capital must remain below 30% per rating agency constraints."
- "Operating Cash Flow must be strictly greater than Net Income in periods of premium growth."
- "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."
- "Return on Equity (ROE) should track between 15.0% and 22.0% (21.2% achieved in 2025)."
- "Effective tax rate should be 20.0% to 22.0%."
- "Net Investment Income yield should not exceed the prevailing market rate for A-rated corporate bonds."
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| Insurance GPW Growth | 6.5 | % | Normalised growth reflecting mid-single-digit rate increases and stable exposure. |
| Reinsurance GPW Growth | 5.0 | % | Slower growth reflecting disciplined capacity deployment. |
| Insurance Retention Ratio | 84.0 | % | Historical average of NPW / GPW for the primary segment. |
| Reinsurance Retention Ratio | 90.0 | % | Historical average for the reinsurance segment. |
| Insurance Loss Ratio | 61.0 | % | Aligns with 2025 reported loss ratio excluding major catastrophes. |
| Reinsurance Loss Ratio | 63.0 | % | Typically runs slightly higher than primary insurance. |
| Consolidated Expense Ratio | 29.5 | % | Stable historical average reflecting broker commissions and internal costs. |
| Catastrophe Load | 2.0 | % | Points added to the combined ratio for normalised weather events. |
| Fixed Maturity Book Yield | 4.8 | % | Based on 2025 reported average annualised yield. |
| Debt-to-Capital Target | 22.0 | % | Management's historical comfort zone for leverage. |
| Effective Tax Rate | 21.0 | % | Standard US corporate rate, adjusted for minor tax-exempt income. |
| Share Repurchases | 300 | $M | Baseline annual run-rate, though highly opportunistic. |
| Regular Dividend per Share | 0.48 | $ | Based on recent quarterly declarations. |
| Special Dividend Payout | 50.0 | % | Percentage of excess capital (above 20% ROE target) returned to shareholders. |
| Cost of Equity (Ke) | 9.5 | % | Standard CAPM output for a low-beta, high-quality P&C insurer. |
Data Sources & Benchmarks
- Filings: SEC EDGAR (Forms 10-K, 10-Q) and W. R. Berkley Investor Relations page (Financial Supplements are critical for Schedule P reserve data and segment breakdowns).
- Key Peers: Chubb (CB), The Hartford (HIG), Travelers (TRV), Markel (MKL), and Arch Capital Group (ACGL).
- Industry Data: A.M. Best for industry-wide combined ratio trends; CIAB (Council of Insurance Agents & Brokers) for commercial P&C pricing surveys.
- Consensus Estimates: FactSet or Bloomberg for EPS, ROE, and Combined Ratio consensus.
Sources
- W. R. Berkley Corporation Investor Relations: https://ir.berkley.com/
- W. R. Berkley Corporation Reports Fourth Quarter and Full Year 2025 Results (January 26, 2026)
- W. R. Berkley Corporation Q1 2025 Financial Supplement
- W. R. Berkley Corporation Q3 2025 Financial Supplement
- W. R. Berkley Corporation 2024 Annual Report
Do more with the W. R. Berkley model
Frequently asked
What is W. R. Berkley Corporation's core business model?+
W. R. Berkley Corporation operates as a commercial lines property and casualty (P&C) insurance holding company. Its business model is balance sheet intensive and float-driven, generating returns through both underwriting profitability and net investment income.
What are the main sources of W. R. Berkley's premiums written?+
W. R. Berkley's net premiums written primarily come from its Insurance Segment, which accounts for approximately 85% and includes commercial products like general liability and workers' compensation. The remaining 15% is derived from its Reinsurance & Monoline Excess Segment.
How does W. R. Berkley manage its capital expenditures?+
W. R. Berkley's capital expenditure is typically less than 1.0% of revenue, consisting almost entirely of maintenance and IT system upgrades. Major capex programs focus on core system modernizations and data analytics platform enhancements.
What is W. R. Berkley's strategy for growth and acquisitions?+
W. R. Berkley is a strictly organic grower, preferring to establish new operating units from scratch rather than acquiring companies. This approach helps avoid inheriting legacy liabilities and maintains its low goodwill and intangibles profile.
What are the key financial aspects considered when valuing W. R. Berkley Corporation?+
When valuing W. R. Berkley, an equity research analyst focuses on projecting statutory and GAAP earnings, assessing reserve adequacy, and determining its dividend-paying capacity. These factors are crucial for understanding its equity valuation and capital return profile.
Is an Excel financial model available for W. R. Berkley Corporation?+
Based on the information provided, there is no downloadable Excel financial model available for W. R. Berkley Corporation. The model described is for an equity research analyst's internal use to project earnings and assess valuation.
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.
