← All financial models

Berkshire Hathaway (BRK-B) Financial Model

📊 Download Model

Three-statement Excel model · 23 quarters and 5 fiscal years of history · 9 quarters and 5 fiscal years of projections

current ✓ C13 recon ✓ C14 trace ✓ C15 terminals

About the BRK-B model

This three-statement Excel model covers Berkshire Hathaway Inc. (BRK-B): its income statement, balance sheet and cash flow statement. It holds 23 quarters and 5 fiscal years of history and 9 quarters and 5 fiscal years of projections.

Projected revenue is built from KPI drivers: Seven segment engines: premiums × per-unit growth (GEICO / Primary / Reinsurance), portfolio × yield, equity book × normalised return, across 7 segments.

Beyond the income statement, the workbook has these sections: KPI Drivers, Balance Sheet, Cash Flow Statement and Memo - Pilot Reclassification.

Model thesis: Operating earnings separated from the mark: investment gains are equity book × a 7% normalised return, not a forecast

On November 11, 2026, the model passed checks C13 (every subtotal reconciles to the reported figure at $0), C14 (every projected revenue cell traces to a KPI driver row) and C15 (each driver ends in a rate, a count or a historical anchor, never a typed-in projected dollar level). It was last updated November 11, 2026.

History
23 quarters and 5 fiscal years
Projections
9 quarters and 5 fiscal years
KPI
Seven segment engines: premiums × per-unit growth (GEICO / Primary / Reinsurance), portfolio × yield, equity book × normalised return
Segments
7
Units
Dollars in millions, except per share amounts
Verified
Updated
File
Excel workbook (.xlsx), 198 KB
Access
Free account required: 3 different models a month at no charge, then $9 a month.

Income statement preview

Columns FY23–FY25 are actual results and FY26E–FY28E are our estimates. Figures were recalculated in Excel on November 11, 2026. Dollars in millions, except per share amounts.

Income statement preview for BRK-B. Dollars in millions, except per share amounts. Actual fiscal years followed by our estimates.
Income Statement
ActualEstimate
FY23FY24FY25FY26EFY27EFY28E
Insurance Premiums Earned83,40388,25788,90289,40289,85190,650
Sales and Service Revenues155,687202,334199,524227,149236,235242,141
Leasing Revenues8,4169,22710,03411,26512,39113,507
Interest, Dividend and Other Investment Income15,56121,82523,26122,68623,96525,348
Insurance and Other Revenues$263,067$321,643$321,721$350,502$362,442$371,645
Railroad Transportation Revenues23,79123,35523,33025,88426,66027,327
Utility and Energy Operating Revenues72,69321,51821,85623,31124,59325,823
Service Revenues and Other Income4,9314,9174,5374,4844,4394,417
Railroad, Utilities and Energy Revenues$101,415$49,790$49,723$53,678$55,692$57,566
Total Revenues$364,482$371,433$371,444$404,180$418,134$429,211
Investment Gains (Losses)$74,855$52,799$39,078$32,338$24,535$26,372
Less: Insurance Losses and Loss Adjustment Expenses(57,187)(56,186)(57,307)(58,010)(58,933)(59,684)
Less: Life, Annuity and Health Insurance Benefits(4,029)(3,858)(4,379)(4,501)(4,493)(4,533)
Less: Insurance Underwriting Expenses(15,270)(16,808)(17,756)(18,860)(19,093)(19,309)
Less: Cost of Sales and Services(122,569)(163,642)(160,062)(183,462)(190,878)(195,892)
Less: Cost of Leasing(6,037)(7,069)(7,685)(8,539)(9,430)(10,279)
Less: Selling, General and Administrative Expenses(22,605)(25,642)(29,735)(28,619)(30,231)(31,032)
Less: Interest Expense - Insurance and Other(1,258)(1,594)(1,329)(1,309)(1,352)(1,390)
Insurance and Other Costs and Expenses($228,955)($274,799)($278,253)($303,300)($314,410)($322,117)
Less: Freight Rail Transportation Expenses(16,464)(15,965)(15,366)(16,902)(17,289)(17,653)
Less: Utilities and Energy Cost of Sales and Other Expenses(67,964)(16,984)(16,959)(17,383)(18,494)(19,419)
Less: Other Expenses(4,016)(4,343)(4,155)(4,198)(4,483)(4,634)
Less: Interest Expense - Railroad, Utilities and Energy(3,745)(3,606)(3,740)(4,062)(4,167)(4,283)
Railroad, Utilities and Energy Costs and Expenses($92,189)($40,898)($40,220)($42,545)($44,433)($45,988)
Total Costs and Expenses($321,144)($315,697)($318,473)($345,845)($358,843)($368,106)
Earnings Before Income Taxes and Equity Method Earnings$118,193$108,535$92,049$90,673$83,826$87,478
Equity Method Earnings (Losses)$1,973$1,841($9,590)$1,741$1,375$1,434
Earnings Before Income Taxes$120,166$110,376$82,459$92,414$85,202$88,912
Less: Income Tax Expense($23,019)($20,815)($15,199)($17,359)($16,188)($16,893)
Net Income$97,147$89,561$67,260$75,055$69,013$72,018
Less: Earnings Attributable to Noncontrolling Interests(924)(566)(292)(316)(262)(274)
Net Income Attributable to Berkshire Shareholders$96,223$88,995$66,968$74,738$68,751$71,745
Pre-Tax Operating Earnings (ex Investment Gains)$43,338$55,736$52,971$58,335$59,291$61,106
Depreciation and Amortization (per Cash Flow Statement)12,48612,85513,47614,51515,52716,082
EBITDA$60,827$73,791$71,516$78,221$80,337$82,860
Weighted-Average Equivalent Class A Shares1,448,8801,437,7201,438,2231,430,9991,418,1081,410,741
Weighted-Average Equivalent Class B Shares (millions)2,173.32,156.62,157.32,146.52,127.22,116.1
Net Earnings per Equivalent Class A Share$66,412$61,900$46,563$52,228$48,481$50,856
Net Earnings per Equivalent Class B Share$44.27$41.27$31.04$34.82$32.32$33.90
Ratios & Assumptions
Pre-Tax Operating Margin (ex Investment Gains)11.9%15.0%14.3%14.4%14.2%14.2%
Effective Tax Rate19.2%18.9%18.4%18.8%19.0%19.0%

The full workbook adds 23 historical and 9 projected quarters, plus KPI Drivers · Balance Sheet · Cash Flow Statement · Memo - Pilot Reclassification — every subtotal a live formula, every projection traced to a driver.

Download the full BRK-B model (xlsx)3 free models a month with an account, then $9 a month

Berkshire Hathaway research

Aardvark Labs Capital Research has published 6 reports on Berkshire Hathaway (BRK-B). The latest is the Q3 2026 Earnings Recap, published November 7, 2026, rated Underperform.

Downgrading to Underperform: GEICO Tripped Our Trigger, and an AI Rotation Lifted the Stock to 1.6x Book, 13% Above Where Berkshire Itself Was Buying

All BRK-B research →

Methodology

Every projected revenue cell traces to a KPI/driver row (C14). Terminal driver cells are rates, counts, or historical anchors — never typed-in projected dollar levels (C15). Every subtotal-vs-reported reconciliation row ties to $0 (C13). Each model is written per-ticker against its actual schema — no cloning, no level-input shortcuts.