Berkshire Hathaway Financial Model
Insurance Company Financials Example (Free Excel Download)
Berkshire Hathaway is a multinational conglomerate holding company overseen by Warren Buffett.
professionals from Deloitte
Used by professionals from
About this model
This model forecasts Berkshire Hathaway's operating earnings and performs a sum-of-the-parts valuation to determine the intrinsic value per share for equity investment decisions.
Berkshire Hathaway is a multinational conglomerate holding company overseen by Warren Buffett. The firm wholly owns businesses in insurance, rail transportation, energy, manufacturing, services, and retailing, whilst also holding a massive portfolio of public equity securities and cash.
Business segments and approximate revenue contribution:
- Insurance Underwriting and Investment Income (25%)
- BNSF Railway (6%)
- Berkshire Hathaway Energy (BHE) (7%)
- McLane Company (14%)
- Manufacturing, Service and Retailing (MSR) (48%)
The company operates primarily in the United States, though several manufacturing and service businesses have global footprints. The business model relies on generating low-cost "float" from insurance operations and reinvesting that capital into productive operating businesses and public equities. Berkshire holds a dominant competitive position due to its fortress balance sheet, unique corporate culture, and ability to act as a buyer of last resort during financial panics. Recent major events include the full acquisition of Pilot Travel Centers in early 2024, the passing of Vice Chairman Charlie Munger in late 2023, significant reductions in the Apple equity stake throughout 2024, and the accumulation of a record cash and short-term investments balance exceeding $300 billion.
The downloadable Berkshire Hathaway 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 & AssumptionsBerkshire Hathaway financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $191.25B | $207.77B | $254.91B | $249.71B | $247.24B |
| Total costs and expenses | $243.94B | $266.63B | $321.14B | $315.70B | $318.47B |
| Earnings attributable to noncontrolling interests | $1.01B | $761.0M | $924.0M | $566.0M | $292.0M |
| Net income | $89.94B | -$22.76B | $96.22B | $89.00B | $66.97B |
How to build a detailed financial model for Berkshire Hathaway
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Insurance Underwriting (GEICO, Berkshire Hathaway Primary Group, Berkshire Hathaway Reinsurance Group)
- Segment name: Insurance Underwriting
- Revenue driver formula: Policies in Force x Average Premium per Policy
- Historical growth rate: 5-8% CAGR
- Key growth levers and headwinds: Auto insurance pricing cycles, catastrophe frequency, reinsurance pricing (hard vs soft markets).
- Pricing dynamics: Highly regulated in primary auto (GEICO), highly competitive and cyclical in reinsurance.
- Revenue recognition notes: Premiums are recognised as earned pro-rata over the term of the policy. Unearned premiums sit on the balance sheet as a liability.
- Seasonality: Reinsurance premiums often spike in Q1 and Q3 due to treaty renewal dates. Catastrophe losses typically peak in Q3 due to the US hurricane season.
Insurance Investment Income
- Segment name: Insurance Investment Income
- Revenue driver formula: Average Invested Assets x Blended Yield
- Historical growth rate: Highly variable based on interest rates and dividend payouts from the equity portfolio.
- Key growth levers and headwinds: Short-term Treasury yields, dividend policies of major equity holdings (e.g., Bank of America, Chevron).
- Pricing dynamics: Market-driven based on macroeconomic interest rate environments.
- Revenue recognition notes: Interest is recognised as earned. Dividends are recognised on the ex-dividend date.
- Seasonality: Generally smooth, though dividend receipts can be lumpy depending on the declaration schedules of investees.
BNSF Railway
- Segment name: Railroad (BNSF)
- Revenue driver formula: Carloads x Average Revenue per Carload
- Historical growth rate: 1-3% CAGR
- Key growth levers and headwinds: US macroeconomic growth, coal secular decline, intermodal volume shifts, agricultural yields.
- Pricing dynamics: Contractual and spot pricing, often including fuel surcharge mechanisms.
- Revenue recognition notes: Recognised over time as freight moves from origin to destination.
- Seasonality: Q3 and Q4 are typically strongest due to the autumn harvest and holiday retail stocking.
Berkshire Hathaway Energy (BHE)
- Segment name: Utilities and Energy (BHE)
- Revenue driver formula: Megawatt Hours Sold x Regulated Rate per MWh
- Historical growth rate: 3-5% CAGR
- Key growth levers and headwinds: Regulated rate base growth, renewable energy transition, wildfire liability risks.
- Pricing dynamics: Highly regulated by state public utility commissions.
- Revenue recognition notes: Recognised upon delivery of electricity or gas to customers.
- Seasonality: Peaks in Q3 due to summer cooling demand and Q1 due to winter heating demand.
McLane Company
- Segment name: McLane Company
- Revenue driver formula: Wholesale Volume x Price per Unit
- Historical growth rate: 2-4% CAGR
- Key growth levers and headwinds: Convenience store foot traffic, grocery demand, supply chain efficiency.
- Pricing dynamics: Extremely low margin, high volume. Prices fluctuate with underlying food and tobacco costs.
- Revenue recognition notes: Recognised upon delivery to the customer.
- Seasonality: Relatively stable throughout the year.
Manufacturing, Service and Retailing (MSR)
- Segment name: Manufacturing, Service and Retailing
- Revenue driver formula: Aggregate Segment Revenue (modeled via GDP multiplier or historical growth rate due to the vast number of sub-businesses like Precision Castparts, Lubrizol, Marmon, and Pilot).
- Historical growth rate: 4-7% CAGR (distorted by acquisitions like Pilot).
- Key growth levers and headwinds: Industrial production, aerospace recovery, housing market (Shaw, Benjamin Moore, Johns Manville), consumer spending.
- Pricing dynamics: Varies wildly from highly engineered industrial components to retail consumer goods.
- Revenue recognition notes: Generally recognised at the point of sale or shipment.
- Seasonality: Varies by underlying business. Housing-related businesses peak in Q2 and Q3.
Cost Structure
Variable Costs / COGS
- Insurance: Losses and loss adjustment expenses (claims paid and reserved).
- BNSF: Compensation and benefits, fuel, purchased services.
- BHE: Cost of fuel and energy, operations and maintenance.
- McLane: Cost of goods sold (food, tobacco, beverages).
- MSR: Raw materials, direct labour, manufacturing overhead.
- Gross margin range: McLane operates at 5-6% gross margin. MSR operates at 25-30%. BHE and BNSF are evaluated on operating margins rather than traditional gross margins.
- Key input costs and commodity exposures: Diesel fuel (BNSF, Pilot), natural gas and coal (BHE), auto parts and medical costs (GEICO).
- How COGS scales with revenue: McLane is highly linear. BNSF and BHE have massive operating leverage due to high fixed asset bases.
Operating Expenses
- R&D: Negligible at the consolidated level.
- SG&A: Insurance underwriting expenses (commissions, advertising for GEICO). MSR selling and administrative expenses.
- Depreciation & Amortisation: Massive for BNSF and BHE. Consolidated D&A runs at approximately 3-4% of total revenues.
- Stock-Based Compensation: Zero. Berkshire Hathaway does not issue stock-based compensation at the parent level.
- Restructuring / one-time charges: Rare, though occasional large impairments occur (e.g., Precision Castparts in 2020).
Margin Profile
- Insurance: Evaluated on the Combined Ratio (Losses + Expenses / Premiums). Target is under 100%. GEICO typically runs 95-98%.
- BNSF: Evaluated on the Operating Ratio (Operating Expenses / Operating Revenues). Typically runs 65-68%.
- BHE: Operating margins typically 15-20%.
- MSR: Pre-tax margins typically 8-10%.
- Margin trend: GEICO margins have improved recently following aggressive rate hikes. BNSF margins have faced pressure from wage inflation.
Balance Sheet Structure
- Total assets: Approximately $1.1 trillion.
- Key asset categories: Investments in equity securities, cash and short-term investments (Treasury bills), property, plant and equipment, goodwill.
- Goodwill & intangibles as % of total assets: Approximately 10-12%, reflecting a long history of acquisitions.
- Working capital profile:
- Days Sales Outstanding (DSO): 30-40 days for non-insurance businesses.
- Days Inventory Outstanding (DIO): 45-60 days for MSR.
- Days Payable Outstanding (DPO): 30-45 days.
- Net working capital as % of revenue: Varies heavily by segment.
- Is working capital positive or negative? The insurance float acts as massive negative working capital, providing over $170 billion in interest-free funding.
- PP&E: Heavily concentrated in BNSF (track, locomotives) and BHE (power plants, transmission lines). Useful lives range from 10 to 40+ years.
- Right-of-use assets / operating leases: Material for retail operations, but small relative to the consolidated balance sheet.
Capital Expenditure & Investment
- Capex as % of revenue: 5-6% consolidated.
- Maintenance capex vs. growth capex: BNSF and BHE require massive maintenance capex just to keep operations running safely. Growth capex is focused on BHE's renewable energy transition.
- Major capex programmes underway: BHE's multi-billion dollar investments in wind and solar generation and transmission infrastructure.
- Capitalised software / development costs: Immaterial.
- M&A pattern: Transformational "elephant" acquisitions (BNSF, Precision Castparts, Alleghany) mixed with frequent bolt-on acquisitions by subsidiaries.
- Typical acquisition multiple paid: Historically disciplined, targeting 10-15x pre-tax earnings.
Debt & Capital Structure
- Total debt: Approximately $130 billion consolidated.
- Debt/EBITDA ratio: Not a relevant metric for Berkshire due to the insurance operations.
- Credit rating: AA (S&P), Aa2 (Moody's).
- Key debt instruments: Subsidiary-level unsecured bonds and term loans.
- Maturity profile: Well-laddered.
- Interest rate profile: Predominantly fixed-rate long-term debt.
- Covenants: Standard investment-grade covenants. No material restrictive financial covenants at the parent level.
- Share repurchase programme: Highly active but discretionary. Buffett repurchases shares only when he believes they are trading below conservative estimates of intrinsic value. Annual magnitude has ranged from $2 billion to $27 billion recently.
- Dividend policy: Berkshire Hathaway pays no dividend.
Cash Flow Characteristics
- Operating cash flow conversion: Extremely strong. Operating cash flow consistently exceeds operating earnings due to depreciation add-backs and float growth.
- Free cash flow margin: 7-10% of revenues.
- Major non-cash items that bridge net income to OCF: Depreciation and amortisation, unrealised gains/losses on equity securities (which swing wildly), growth in insurance float.
- Working capital cash flow impact: Float growth is a massive source of cash.
- Capex intensity: High for BNSF and BHE, low for Insurance and McLane.
- Cash tax rate vs. GAAP effective tax rate: Generally aligned around 19-21%, benefiting from the dividends received deduction on equity investments.
Sheet Structure
- Cover: Company name, ticker, model purpose, and contact details.
- Assumptions: Hardcoded drivers for all segments, macroeconomic inputs, and valuation parameters.
- SOTP Valuation: Sum-of-the-parts aggregation valuing Insurance, BNSF, BHE, MSR, and adding cash/investments to determine intrinsic value per share.
- Consolidated Income Statement: Aggregation of all segment revenues and operating earnings, plus investment income and realised/unrealised equity gains.
- Insurance Segment: Premiums, losses, underwriting expenses, combined ratios, and float calculation for GEICO, Primary, and Reinsurance.
- BNSF Segment: Carloads, revenue per carload, operating expenses, operating ratio, and net earnings.
- BHE Segment: Energy volumes, regulated rates, operating expenses, and net earnings.
- MSR & McLane Segment: Revenue growth, gross margins, SG&A, and pre-tax earnings for the remaining operating businesses.
- Equity Portfolio & Cash: Schedule tracking the massive cash balance, Treasury bill yields, equity portfolio size, and dividend income.
- Consolidated Balance Sheet: Assets, liabilities, and shareholders' equity.
- Consolidated Cash Flow: Operating, investing, and financing cash flows.
- Debt Schedule: Parent vs subsidiary debt balances and interest expense calculations.
Key Financial Relationships
- `GEICO Underwriting Profit = GEICO Earned Premiums x (1 - GEICO Combined Ratio)`
- `Insurance Float = Unpaid Losses + Unearned Premiums + Other Policyholder Liabilities - Premium Balances Receivable - Reinsurance Recoverables`
- `Insurance Investment Income = Average Cash and Fixed Maturity Investments x Average Yield + Equity Portfolio Dividend Income`
- `BNSF Operating Revenues = Freight Carloads x Average Revenue per Carload`
- `BNSF Operating Profit = BNSF Operating Revenues x (1 - BNSF Operating Ratio)`
- `BHE Net Earnings = BHE Revenues - BHE Operating Expenses - BHE Interest Expense - BHE Taxes`
- `McLane Pre-Tax Earnings = McLane Revenues x McLane Pre-Tax Margin`
- `MSR Pre-Tax Earnings = MSR Revenues x MSR Pre-Tax Margin`
- `Consolidated Operating Earnings = Insurance Underwriting Profit + Insurance Investment Income + BNSF Net Earnings + BHE Net Earnings + MSR/McLane Net Earnings - Corporate Interest and Overhead`
- `Reported Net Income = Consolidated Operating Earnings + Realised Capital Gains/Losses + Unrealised Capital Gains/Losses on Equity Securities`
- `Ending Cash Balance = Beginning Cash Balance + Free Cash Flow - Share Repurchases - Cash Paid for Acquisitions`
- `Shares Outstanding = Beginning Shares Outstanding - (Share Repurchase Spend / Average Share Price)`
- `SOTP Value per Share = (Value of Operating Businesses + Cash and Short-Term Investments + Equity Portfolio - Parent Company Debt) / Shares Outstanding`
Cross-Sheet Dependencies
- The Assumptions sheet feeds drivers into the Insurance Segment, BNSF Segment, BHE Segment, MSR & McLane Segment, and Equity Portfolio & Cash sheets.
- All segment sheets feed their respective revenue and expense lines into the Consolidated Income Statement.
- The Consolidated Income Statement feeds net income into the Consolidated Cash Flow sheet.
- The Insurance Segment feeds the float liability balances into the Consolidated Balance Sheet.
- The Consolidated Cash Flow sheet feeds the ending cash balance into the Consolidated Balance Sheet and the Equity Portfolio & Cash sheet.
- The Debt Schedule feeds interest expense into the Consolidated Income Statement and debt balances into the Consolidated Balance Sheet.
- The SOTP Valuation pulls operating earnings from the segment sheets, cash/investments from the Consolidated Balance Sheet, and share counts from the Consolidated Income Statement.
- Circularity risk: Interest income depends on the cash balance, which depends on net income, which depends on interest income. The builder must use a beginning-of-period cash balance for interest income calculations to avoid circular references.
Sign Convention
- Revenues, premiums, and volumes are entered and displayed as positive numbers.
- Expenses (COGS, SG&A, Losses, Interest, Taxes) are entered as positive numbers in the assumptions but subtracted in formulas.
- On the Cash Flow statement, cash inflows are positive and cash outflows (capex, share repurchases, debt repayment) are negative.
- On the Balance Sheet, all assets, liabilities, and equity balances are positive.
Things Most Likely to Go Wrong
- GAAP Net Income Distortion: Due to ASU 2016-01, Berkshire must run unrealised gains and losses from its massive equity portfolio through the income statement. This makes GAAP Net Income useless for valuation. The model must focus strictly on Operating Earnings.
- Float Misclassification: Builders often treat insurance float as traditional debt. It is a liability, but it does not carry a traditional interest expense and should not be deducted in an Enterprise Value calculation like standard debt.
- Non-Recourse Debt: BNSF and BHE issue their own debt which is not guaranteed by the parent company. The model must separate subsidiary debt from parent company debt.
- Share Count Complexity: Berkshire has Class A and Class B shares. The model must convert all shares to Class A equivalents (or Class B equivalents) for per-share calculations. One Class A share equals 1,500 Class B shares.
- Cash Yield Underestimation: With over $300 billion in cash and short-term Treasury bills, a small change in the assumed interest rate creates a massive swing in Insurance Investment Income.
- Pilot Travel Centers Integration: Pilot was fully acquired in early 2024. Historical MSR segment data prior to 2023 does not include Pilot, making historical growth rates look artificially high.
- BHE Wildfire Liabilities: BHE faces significant potential liabilities from wildfires in the western US. The model must account for potential legal settlement outflows in the cash flow statement.
- Capital Expenditure Mismatch: Depreciation heavily understates the true maintenance capital expenditure required for BNSF and BHE. Free cash flow calculations must use actual capex, not D&A.
Validation Checks
- "Consolidated Operating Earnings should be in the $35B - $45B range; flag if outside this band."
- "Cash and short-term investments must not drop below $30 billion (Buffett's stated absolute minimum)."
- "GEICO combined ratio should remain between 94% and 99%; flag if it drops below 90% or exceeds 105%."
- "BNSF operating ratio should be between 64% and 69%."
- "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."
- "Unrealised gains/losses on equities should be excluded from the operating earnings subtotal."
- "Effective tax rate should be 19-21%, benefiting from the dividends received deduction."
- "Share repurchases should not exceed Free Cash Flow in any given year unless explicitly modelled as a special event."
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| GEICO Premium Growth | 5.0 | % | Reflects recent rate increases stabilising. |
| GEICO Combined Ratio | 96.5 | % | Historical average following recent underwriting corrections. |
| BNSF Carload Growth | 1.0 | % | Flat to low growth due to coal declines offsetting intermodal growth. |
| BNSF Operating Ratio | 68.0 | % | Recent average reflecting wage inflation and union agreements. |
| BHE Revenue Growth | 4.0 | % | Steady rate base growth and renewable investments. |
| BHE Operating Margin | 16.0 | % | Historical average for the regulated utility segment. |
| McLane Revenue Growth | 2.0 | % | Tracks inflation and stable convenience store demand. |
| McLane Pre-Tax Margin | 1.0 | % | Extremely low-margin wholesale distribution business. |
| MSR Revenue Growth | 4.0 | % | Blended industrial and consumer growth rate. |
| MSR Pre-Tax Margin | 9.5 | % | Historical average for the manufacturing and retail group. |
| Cash & T-Bill Yield | 4.5 | % | Current short-term Treasury rate environment. |
| Equity Portfolio Dividend Yield | 1.8 | % | Blended yield of top holdings (Apple, BofA, Amex, Coca-Cola). |
| Consolidated Capex / Revenue | 5.5 | % | Driven heavily by BNSF and BHE capital intensity. |
| Effective Tax Rate | 20.0 | % | Historical average reflecting dividend tax advantages. |
| Annual Share Repurchases | 5.0 | $ Billions | Conservative estimate based on recent disciplined buyback behaviour. |
| Class A to Class B Ratio | 1,500 | Multiplier | Fixed conversion ratio per corporate charter. |
| SOTP Discount Rate (WACC) | 8.5 | % | Blended cost of capital for the operating businesses. |
| Terminal Growth Rate | 2.0 | % | Long-term macroeconomic growth proxy. |
Data Sources & Benchmarks
- SEC EDGAR: Berkshire Hathaway 10-K and 10-Q filings.
- Investor Relations: berkshirehathaway.com (annual letters to shareholders are critical for qualitative context).
- Key peers for benchmarking:
- Insurance: Progressive (PGR), Allstate (ALL), Markel (MKL).
- Railroad: Union Pacific (UNP), CSX Corporation (CSX).
- Energy: NextEra Energy (NEE), Duke Energy (DUK).
- Consensus estimates source: Bloomberg or FactSet for SOTP valuation components.
- Proprietary data: A.M. Best for insurance subsidiary ratings and statutory filings; Surface Transportation Board (STB) weekly carload data for BNSF tracking.
Sources
Do more with the Berkshire Hathaway model
Frequently asked
What is Berkshire Hathaway's primary business model?+
Berkshire Hathaway operates as a multinational conglomerate, generating low-cost "float" from its insurance operations. This capital is then strategically reinvested into productive operating businesses across various sectors and public equity securities.
What are the main revenue segments for Berkshire Hathaway?+
Berkshire Hathaway's revenue is primarily driven by its Manufacturing, Service and Retailing segment (MSR) at approximately 48%, followed by Insurance Underwriting and Investment Income at 25%. Other significant contributors include McLane Company, Berkshire Hathaway Energy, and BNSF Railway.
What is Berkshire Hathaway's typical capital expenditure as a percentage of revenue?+
Berkshire Hathaway's consolidated capital expenditure typically ranges from 5-6% of its revenue. A significant portion of this is maintenance capex, particularly for BNSF and Berkshire Hathaway Energy, with growth capex focused on BHE's renewable energy transition.
How does Berkshire Hathaway's insurance float impact its working capital?+
The insurance float acts as a massive source of negative working capital for Berkshire Hathaway, providing over $170 billion in interest-free funding. This unique characteristic significantly influences its overall balance sheet structure and financial flexibility.
What is Berkshire Hathaway's approach to mergers and acquisitions?+
Berkshire Hathaway's M&A strategy involves a mix of transformational "elephant" acquisitions and frequent bolt-on acquisitions by its subsidiaries. Historically, the company has been disciplined, targeting acquisition multiples of 10-15x pre-tax earnings.
What is the purpose of a financial model for Berkshire Hathaway?+
A financial model for Berkshire Hathaway aims to forecast its operating earnings and perform a sum-of-the-parts valuation. This analysis helps determine the intrinsic value per share, assisting in equity investment decisions.
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.
Brown & Brown
Brown & Brown is a leading global insurance brokerage firm that provides risk management solutions to individuals and businesses, earning commissions and fees for placing property, casualty, and employee benefits insurance.
Explore more Financial Services financial model templates.
