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

A Berkshire Hathaway portfolio tracker in Excel is a workbook that lists the stocks Berkshire discloses in its SEC Form 13F filings and pulls current price, P/E, dividend yield, ROE and debt-to-equity for each one with MarketXLS formulas such as =QM_Last("KO") and =ReturnOnEquity("KO"). This guide gives you a free six-sheet template (a static sample and a live formula version) that scores 15 disclosed Berkshire holdings on a transparent Buffett-style quality formula and converts them into position sizes for your own portfolio. The live version needs the MarketXLS add-in; the static sample opens in any Excel.

See it in actionMarketXLS video

The full MarketXLS demo

Watch full demoBook a demo

Try it in your own spreadsheet

Get the free MarketXLS sample workbook (.xlsx).

Email address

Download free workbook

No account needed. MarketXLS live data requires a paid plan. Preview workbook

Explore more videos +

IntroductionHistorical DataOptions DataUse-cases

The template was published for the May 2026 Berkshire annual meeting, ahead of the Q1 2026 13F filing due May 15. It is an educational study workbook, not a recommendation. 13F holdings reflect a past quarter-end, and Berkshire's concentration is not something most diversified investors would copy one for one. Because the ticker column is generic, you can point the same workbook at any 13F filer or at your own portfolio.

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 (stock quotes are 15-minute delayed on the Standard plan and real-time on Advanced and Business).
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 track Berkshire's 13F holdings in a live workbook

A live workbook is more useful than a static holdings list because Berkshire's disclosed book changes every quarter and the metrics on each name change daily.

1. The Berkshire annual meeting in Omaha. The early-May meeting is where Berkshire discusses capital allocation, succession and the equity book at length, so it is a natural point to review the holdings.

2. The Q1 2026 13F filing was due May 15, 2026. Institutional managers with more than $100 million in US equities, including Berkshire, must report long US equity holdings within 45 days of quarter-end. Each new filing can add, trim or remove names, so the watchlist below is a moving target.

3. The structure works for any 13F filer. You can repoint the workbook at Sequoia, Markel, Pabrai, Akre or any other filer. Berkshire is the demonstration case because its holdings and philosophy are 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)

Formula documentation: OperatingMargin

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

The live workbook uses the MarketXLS functions below. They are written for the Windows desktop add-in; in the Microsoft 365 add-in (Excel on Mac and Excel for the web) the same functions take an mxls. prefix, for example =mxls.Last("AAPL"). Some functions differ by platform, so check the formula list if one does not resolve.

' 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

Formula documentation: QM_Last, Last, Sector, Industry, Beta, MarketCapitalization, PERatio, PriceToBook, PriceToSales, PriceToCashFlow, EnterpriseValueToEbitda, ReturnOnEquity, ReturnOnAssets, ReturnOnInvestedCapitalOneYear, OperatingMargin, GrossMargin, Revenue, DividendYield, DividendPerShare, PayoutRatio, TotalDebtToEquity, BookValuePerShare, EarningsPerShare, SimpleMovingAverage, FiftyTwoWeekHigh, FiftyTwoWeekLow, PercentBelowFiftyTwoWeekHigh

If a formula returns #NAME?, Excel is not recognizing the function: confirm the MarketXLS add-in is loaded and signed in, then contact support@marketxls.com if the problem persists.

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.

Because every metric is a formula, the quarterly update is a paste of new tickers rather than a rebuild.

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?

The Berkshire Hathaway portfolio tracker Excel is a six-sheet 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 current 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 a MarketXLS subscription and the add-in installed (Windows desktop add-in, or the Microsoft 365 add-in for Mac and Excel for the web); otherwise =QM_Last, =PERatio and similar functions will not resolve. Plans start at $70/month billed annually (Standard, with 15-minute delayed stock quotes).

The bottom line

The Berkshire Hathaway portfolio tracker Excel template lets you study Buffett's disclosed equity book and update it each time a new 13F is filed. The names are public; the framework is transparent; the Excel structure is generic enough to repoint at any other quality-focused fund.

The same six-sheet structure works for screening durable franchises, sizing positions under a per-name cap, or comparing your own holdings to a quality benchmark. MarketXLS supplies the live prices and fundamentals inside Excel; you can book a demo to see it run on your own watchlist.