Three-statement Excel model · 23 quarters and 5 fiscal years of history · 9 quarters and 5 fiscal years of projections
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.
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 | ||||||
|---|---|---|---|---|---|---|
| Actual | Estimate | |||||
| FY23 | FY24 | FY25 | FY26E | FY27E | FY28E | |
| Insurance Premiums Earned | 83,403 | 88,257 | 88,902 | 89,402 | 89,851 | 90,650 |
| Sales and Service Revenues | 155,687 | 202,334 | 199,524 | 227,149 | 236,235 | 242,141 |
| Leasing Revenues | 8,416 | 9,227 | 10,034 | 11,265 | 12,391 | 13,507 |
| Interest, Dividend and Other Investment Income | 15,561 | 21,825 | 23,261 | 22,686 | 23,965 | 25,348 |
| Insurance and Other Revenues | $263,067 | $321,643 | $321,721 | $350,502 | $362,442 | $371,645 |
| Railroad Transportation Revenues | 23,791 | 23,355 | 23,330 | 25,884 | 26,660 | 27,327 |
| Utility and Energy Operating Revenues | 72,693 | 21,518 | 21,856 | 23,311 | 24,593 | 25,823 |
| Service Revenues and Other Income | 4,931 | 4,917 | 4,537 | 4,484 | 4,439 | 4,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,486 | 12,855 | 13,476 | 14,515 | 15,527 | 16,082 |
| EBITDA | $60,827 | $73,791 | $71,516 | $78,221 | $80,337 | $82,860 |
| Weighted-Average Equivalent Class A Shares | 1,448,880 | 1,437,720 | 1,438,223 | 1,430,999 | 1,418,108 | 1,410,741 |
| Weighted-Average Equivalent Class B Shares (millions) | 2,173.3 | 2,156.6 | 2,157.3 | 2,146.5 | 2,127.2 | 2,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 Rate | 19.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.
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
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.