Berkshire Hathaway Portfolio Tracker Excel: Buffett-Style Watchlist for May 2026

Berkshire Hathaway portfolio tracker Excel is what investors look for the weekend of the Berkshire annual meeting, when attention turns once again to the publicly disclosed equity book that Warren Buffett and Greg Abel oversee. With the 2026 annual meeting in Omaha taking place this weekend and Berkshire's first-quarter 13F filing due to the SEC by May 15, this guide gives you a live Excel workbook for studying Berkshire's largest reported positions, scoring them on Buffett-style quality factors and sizing them inside your own portfolio. Every dashboard cell in the formula version is powered by MarketXLS, the Excel add-in for institutional-grade market data, so the prices, ratios and scores refresh in your spreadsheet without you ever leaving Excel.

This is an educational study workbook, not a recommendation. Berkshire's equity holdings are public information drawn from Form 13F filings on SEC EDGAR; they reflect a position date that may differ from today, and the portfolio is concentrated in a way most diversified investors would not replicate one for one. The point of the workbook is to use Berkshire's disclosed names as a starting universe for studying durable franchises - and to give you a re-usable Excel framework that you can point at any portfolio you care about.

What's in the Berkshire Hathaway portfolio tracker Excel workbook

Below is the at-a-glance summary of the 15-name watchlist baked into the workbook. The names are drawn from Berkshire's publicly disclosed 13F equity book; weights and metrics in this educational sample are illustrative.

The workbook does six things on top of this list:

1. Pulls every price, P/E, dividend yield, ROE and debt-to-equity from MarketXLS in real time.
2. Scores each name with a transparent Buffett-style quality formula combining ROE, debt-to-equity and operating margin.
3. Lets you flip between five allocation scenarios (equal weight, top-five concentrated, defensive tilt, income tilt, cash heavy).
4. Converts your portfolio size and per-name cap into target dollar values and share counts.
5. Maps sector concentration so you can see at a glance whether the watchlist is over-weight one bucket.
6. Gives you a per-holding compare matrix with beta, dividend yield, 200-day SMA, 52-week high/low and percent below the high.

The download links and the full breakdown of every sheet are below.

Why this Berkshire Hathaway portfolio tracker matters in May 2026

Three calendar items make this the right weekend to publish a Berkshire-themed Excel template.

1. The Berkshire annual meeting in Omaha. Berkshire's Q&A is the one place each year where retail investors hear long-form thinking on capital allocation, succession and the equity book. Every May, search interest in "berkshire hathaway holdings" spikes.

2. The Q1 2026 13F filing window closes May 15. All institutional managers with more than $100 million in US equities, including Berkshire, must report their holdings as of the quarter-end. Last quarter's 13F was already public; the next one is days away, which means the watchlist below is about to become a moving target. A live workbook is more useful than a static screenshot.

3. A live formula version travels. Once you have the structure, you can repoint the workbook at any 13F filer (Sequoia, Markel, Pabrai, Akre and so on). Berkshire is the demonstration case because the holdings are well known and the philosophy is well documented.

What Berkshire's portfolio teaches about quality investing

Buffett's approach is famously hard to summarise in formulas, but his shareholder letters reduce the framework to a short checklist that maps cleanly onto MarketXLS functions:

• A simple, understandable business
• Favourable long-term economics
• Honest and capable management
• A sensible price

The first three are qualitative. The fourth - and the durability of the second - is exactly where an Excel template earns its keep. We can build a quantitative Buffett-style screen out of three numbers MarketXLS exposes for almost any US-listed equity:

• Return on equity (=ReturnOnEquity("ticker")) - measures how productively management compounds shareholders' capital. Buffett's letters cite high, durable ROE as a hallmark of franchise-quality businesses.
• Total debt to equity (=TotalDebtToEquity("ticker")) - he wants high return on equity earned without piling on leverage. A high-ROE business with no debt is a different animal than one carrying 5x leverage.
• Operating margin (=OperatingMargin("ticker")) - the cleanest proxy for pricing power. Brands, networks and switching costs show up here.

The workbook combines them into a transparent quality score:

Quality Score = MIN(5, ROE / 15)
              - MIN(3, Debt-to-Equity / 2)
              + MIN(4, OperatingMargin / 10)

You can tune the weights to your own taste; the point is that the score is fully visible in the cell formula and can be inspected, edited or replaced. There is no black box.

How the Berkshire Hathaway portfolio tracker Excel template is structured

The workbook ships as two files. The first is a static sample that shows you what the dashboard looks like with snapshot data as of 2026-05-02. The second is the live formula version that pulls from MarketXLS every time you open it.

Sheet 1 - How To Use

Plain-English walkthrough of the workbook, the inputs, what the quality score means and the educational disclaimers. The "MarketXLS Functions Used" box at the bottom of every sheet doubles as a cheat sheet.

Sheet 2 - Main Dashboard

This is the cockpit. Yellow input cells let you set:

• Portfolio size (USD)
• Maximum single-position weight (default 10%)
• Minimum ROE filter (default 15%)
• Maximum debt-to-equity filter (default 2.0)
• Minimum dividend yield filter (default 0%, set higher to bias to income names)
• Benchmark ticker (default SPY)

Below the input block, the watchlist auto-renders: ticker, company, sector (=Sector("AAPL")), Buffett thesis tag, live price (=QM_Last("AAPL")), P/E (=PERatio("AAPL")), dividend yield (=DividendYield("AAPL")), ROE (=ReturnOnEquity("AAPL")), debt/equity (=TotalDebtToEquity("AAPL")) and the composite quality score.

Sheet 3 - Buffett Quality Metrics

A per-holding grid of the quality numbers Buffett-style investors actually study:

• ROE - =ReturnOnEquity("ticker")
• ROA - =ReturnOnAssets("ticker")
• ROIC (1-year) - =ReturnOnInvestedCapitalOneYear("ticker")
• Operating margin - =OperatingMargin("ticker")
• Gross margin - =GrossMargin("ticker")
• Debt/equity - =TotalDebtToEquity("ticker")
• Beta - =Beta("ticker")

A "Quality Pass / Watch" tag at the right of each row is calculated from your Main Dashboard input filters, so changing a filter in one place updates the tags everywhere.

Sheet 4 - Scenario Analysis

Five allocation approaches side by side:

Yellow input cells on this sheet let you change the weights and the assumed forward returns for each bucket; the blended return and dollar P/L update automatically.

Sheet 5 - Position Sizing

Pulls the portfolio size from Sheet 2, applies your per-name weight cap and converts the target dollar amount into a share count using the live price from MarketXLS. This is the sheet you actually look at when you want to translate research into an order ticket.

Sheet 6 - Sector Exposure & Comparison

Two blocks. The first is a sector exposure table - how concentrated is the watchlist in financials versus consumer defensive versus energy. The second is a per-holding compare matrix with beta, dividend yield, 200-day SMA, 52-week high and low, and percent below the 52-week high (=PercentBelowFiftyTwoWeekHigh("ticker")). This is your sanity check for diversification and for spotting names trading deepest off their highs.

Real MarketXLS formulas powering the Berkshire Hathaway portfolio tracker Excel

Here are the working MarketXLS functions used in the live workbook. Every one of these is a documented MarketXLS function; do not hand-edit them with invented names.

' Live price and basic quote data
=QM_Last("AAPL")                 ' Current price
=Last("AAPL")                    ' Current price (alias)
=Sector("AAPL")                  ' Sector classification text
=Industry("AAPL")                ' Industry classification text
=Beta("AAPL")                    ' Five-year beta vs the market
=MarketCapitalization("AAPL")    ' Market cap

' Valuation
=PERatio("AAPL")                 ' Trailing price to earnings
=PriceToBook("AAPL")             ' Price to book
=PriceToSales("AAPL")            ' Price to sales
=PriceToCashFlow("AAPL")         ' Price to cash flow
=EnterpriseValueToEbitda("AAPL") ' EV / EBITDA

' Profitability and quality
=ReturnOnEquity("AAPL")          ' Return on equity, percent
=ReturnOnAssets("AAPL")          ' Return on assets, percent
=ReturnOnInvestedCapitalOneYear("AAPL") ' One-year ROIC
=OperatingMargin("AAPL")         ' Operating margin, percent
=GrossMargin("AAPL")             ' Gross margin, percent
=Revenue("AAPL")                 ' Trailing revenue

' Income and balance sheet
=DividendYield("AAPL")           ' Annual dividend yield
=DividendPerShare("AAPL")        ' Dividend per share
=PayoutRatio("AAPL")             ' Dividend payout ratio
=TotalDebtToEquity("AAPL")       ' Debt to equity
=BookValuePerShare("AAPL")       ' Book value per share
=EarningsPerShare("AAPL")        ' Trailing EPS

' Trend and risk
=SimpleMovingAverage("AAPL", 200) ' 200-day SMA
=FiftyTwoWeekHigh("AAPL")        ' 52-week high price
=FiftyTwoWeekLow("AAPL")         ' 52-week low price
=PercentBelowFiftyTwoWeekHigh("AAPL") ' Percent below 52w high

If a QM_ function ever returns #NAME? in your live workbook it usually means the QuoteMedia session needs a refresh - the MarketXLS support team re-authenticates the session in seconds.

A Buffett-style quality screen, step by step

Open the live workbook and walk through the screen in three steps.

Step 1 - Pull the names into the dashboard.

The watchlist already contains the 15 disclosed Berkshire holdings, but the structure is generic. To repoint the workbook at any other 13F filer, copy the ticker column from your filing of choice (SEC EDGAR is free) and paste over the existing tickers. Every formula will recalculate.

Step 2 - Apply your quality filters in the input block.

The Main Dashboard input cells are intentionally simple. ROE > 15% and Debt/Equity < 2.0 is a reasonable starting bar - it lines up with the kind of business Buffett has historically called "great". Tighten or loosen those numbers to taste; the Quality Pass tag on the Buffett Quality Metrics sheet will update.

Step 3 - Use the position sizing sheet to convert the screen into a plan.

Set your portfolio size, set your per-name cap, and the workbook converts target weights into shares at the current price. If the position cap is hit before the equal weight is reached - because you have, say, 30 names instead of 15 - the workbook clips the dollar target appropriately.

The screen is not a recommendation. It is a study tool. Two of Berkshire's most famous historical purchases (Coca-Cola in 1988 and Apple from 2016 onward) came after Buffett spent months understanding the businesses qualitatively. The Excel screen filters the universe; the qualitative work is still on you.

How to study the 13F update on May 15 with this workbook

Because the workbook is generic, it is well suited to following the next 13F. Three suggestions:

1. Diff the new holdings against the old. Save a copy of the workbook today, dated, and again after the May 15 filing. New positions show up as additions to the ticker column, exits as removals, and trims as size changes. The structure does not change.
2. Recompute the quality score on every name in the new filing. The score is the same formula on every row, so adding a new ticker only requires copying a row and changing the symbol.
3. Re-run the position sizing sheet. A new position cap or a new portfolio size flows through in seconds.

This is the workflow institutional analysts run quarterly inside Bloomberg or YCharts. With MarketXLS in Excel you get the same live data without leaving the spreadsheet.

Sample output from the dashboard

For illustration, the static sample workbook (data as of 2026-05-02) shows the kind of view you get on the Main Dashboard. Numbers below are educational snapshots, not investment guidance.

Notice the pattern. The two payments-network names (V, MA) and Moody's score nearly identically on the quality lens; that is what a network-effect duopoly looks like in numbers. Coca-Cola screens lower because of historical leverage, but its operating margin and dividend coverage tell a different story - which is exactly the kind of nuance an Excel screen is supposed to surface for further qualitative work.

Comparison: Berkshire's portfolio versus a quality-only screen

Here is a useful exercise. Set the quality filter at ROE > 15% and Debt/Equity < 2.0. Some Berkshire names sail through: AAPL, V, MA, MCO, KO, AXP. A few do not: high leverage businesses such as Charter screen out on the debt filter. That is not a verdict on the businesses; it is a reminder that Buffett's portfolio includes positions taken for special reasons (fixed-income-like preferreds, regulatory-protected utilities, or businesses where Berkshire has board representation) that do not always fit a generic quality screen.

The takeaway: the screen and the portfolio are not the same artefact. Use the screen to understand which Berkshire holdings are quality compounders by formula, and which are special situations.

Risks and limitations of using the Berkshire Hathaway portfolio tracker Excel

Three honest caveats.

1. 13F data is delayed. Filings are 45 days behind quarter-end. The names you see today may already be different. The workbook is a snapshot tool, not a real-time mirror of Berkshire's book.

2. Position sizes are not directly disclosed at full granularity. 13Fs cover long US equity holdings; they do not cover short positions, foreign listings (such as Berkshire's well-known Japanese trading house positions, which sit on the parent's balance sheet), or non-public investments. Treat the watchlist as Berkshire's US listed equity book, not the entire economic engine.

3. Concentration is not a strategy by itself. Berkshire's largest position has historically been a third or more of the equity book. That works for an insurance balance sheet with permanent capital. It is rarely the right number for an individual portfolio. The workbook deliberately exposes a per-name cap input to make this trade-off explicit.

Download the templates

Download the Berkshire Hathaway portfolio tracker Excel templates:

• - Pre-filled with snapshot data as of 2026-05-02 so you can preview the dashboard without installing MarketXLS.
• - Every metric is a live MarketXLS formula, recalculating each time you open the workbook.

To use the live version you need MarketXLS installed in Excel.

Frequently Asked Questions

What is the Berkshire Hathaway portfolio tracker Excel?

It is a six-sheet Excel workbook that takes the publicly disclosed equity holdings of Berkshire Hathaway from SEC 13F filings and tracks them with live MarketXLS formulas. You see prices, P/E, dividend yield, ROE, debt/equity and a Buffett-style quality score, and you can size each name in your own portfolio. It is an educational tool for studying Buffett's approach in your own spreadsheet.

How often does Berkshire Hathaway disclose its holdings?

Like every institutional manager with more than $100 million in US-listed equities, Berkshire files a Form 13F with the SEC within 45 days of each calendar quarter-end. The Q1 2026 13F is due by May 15, 2026. 13Fs cover long US equity positions and are public on SEC EDGAR.

Which MarketXLS functions does the Berkshire Hathaway portfolio tracker Excel use?

The workbook uses =QM_Last("ticker") for live prices, =PERatio("ticker") for P/E, =DividendYield("ticker") for yield, =ReturnOnEquity("ticker") for ROE, =TotalDebtToEquity("ticker") for leverage, =OperatingMargin("ticker") for margin, =Sector("ticker") for sector tag, =Beta("ticker") for beta and =SimpleMovingAverage("ticker",200) for the 200-day SMA. Every function is documented inside the workbook in a "MarketXLS Functions Used" box on each sheet.

Can I repoint the Berkshire Hathaway portfolio tracker Excel at another 13F filer?

Yes. The structure is generic. Copy the ticker list from any 13F (Sequoia Fund, Markel, Pabrai Investment Funds, Akre Focus and so on) on SEC EDGAR, paste over the ticker column on the Main Dashboard, and every formula will recalculate. The workbook is built around the column structure, not around any single fund.

Is this Berkshire Hathaway portfolio tracker Excel template investment advice?

No. The workbook is an educational study tool. Berkshire's holdings are public disclosures from a previous quarter-end and do not represent today's positions, do not include non-equity investments, and do not constitute a recommendation to buy or sell any security. Always consult a licensed advisor before acting on any portfolio idea.

How does the Buffett quality score work?

The quality score in the Berkshire Hathaway portfolio tracker Excel is a transparent formula: it adds the lower of (5) and (ROE / 15), subtracts the lower of (3) and (Debt-to-Equity / 2), and adds the lower of (4) and (Operating Margin / 10). High-ROE, low-debt, high-margin businesses score the highest. The exact formula is visible in every row; you can edit the weights or replace the formula entirely.

Do I need MarketXLS to use the Berkshire Hathaway portfolio tracker Excel?

The static sample version opens in any Excel install with no MarketXLS required. The live formula version needs MarketXLS installed; otherwise the =QM_Last, =PERatio and similar functions will not resolve.

The bottom line

The Berkshire Hathaway portfolio tracker Excel is a structured way to study Buffett's disclosed equity book on the weekend of the annual meeting and to keep that study going as the next 13F drops. The names are public; the framework is transparent; the Excel structure is generic enough to repoint at any other quality-focused fund.

If your work involves screening for durable franchises, sizing positions inside a portfolio cap or comparing your own holdings to a quality benchmark, the same six-sheet structure is what you want. MarketXLS is the Excel add-in that makes the live data side of this workflow possible without leaving the spreadsheet, and the book a demo page is the fastest way to see the platform in action with your own watchlist.

Markets reward investors who do their homework. The tools that make that homework faster - and reproducible - are the ones worth keeping in the toolbox.