Owner earnings calculator excel - if that is what brought you here in May 2026, you are likely doing what every serious value investor was reminded to do at the Berkshire Hathaway annual meeting in Omaha this past weekend: focus on the cash a business can pay out without shrinking its productive capacity. This guide walks through Warren Buffett's exact owner earnings formula, shows how to wire it up with live MarketXLS data in a 7-sheet Excel template, and gives you a free download to apply the framework across a 20-stock quality watchlist.
The 2026 Berkshire annual meeting put the spotlight back on Buffett's approach to valuation. With reported earnings, free cash flow, and adjusted EBITDA all telling slightly different stories during Q1 2026 earnings season, the cleanest cash-on-cash measure remains the one Buffett laid out almost 40 years ago in his 1986 letter to shareholders. This template puts that measure on a working dashboard and pairs it with a quality screener so you can sort the watchlist on the metric that actually matters.
Owner Earnings: The Buffett Formula in One Line
In the 1986 Berkshire shareholder letter, Buffett proposed owner earnings as the answer to a deceptively simple question: how much cash can the owners of a business take out each year without impairing the business's ability to keep operating at its current scale?
His formula:
Owner Earnings = Reported Earnings
+ Depreciation, Amortization, and other non-cash items
- Average annual capitalized expenditures (maintenance CapEx)
- Increases in working capital
The first three lines look like the start of a free cash flow calculation. The critical difference is in the fourth line: only the maintenance portion of capital expenditure is subtracted, not the full reported CapEx number. Growth CapEx, the spending a company puts into expanding capacity rather than replacing what is wearing out, gets credited back to owners as part of the cash they could in theory withdraw.
That single distinction matters enormously. A company aggressively expanding into new markets, building new factories, or rolling out new product lines may report low free cash flow simply because it is choosing to grow. Owner earnings strips out the growth investment to show what the existing business throws off. It rewards capital-light compounders and is more honest about capital-heavy growth bets than headline FCF often is.
Why Owner Earnings Calculator Excel Matters in May 2026
Three things make this metric particularly relevant heading into the rest of 2026.
First, Q1 2026 earnings season has produced unusual divergence between reported net income and free cash flow across the Magnificent 7 and the broader S&P 500. Some hyperscalers are reporting strong net income while their owner earnings are roughly flat because so much of their CapEx is plowing into AI infrastructure that the formula treats as growth investment. Other large-cap industrials are showing the reverse, with depressed earnings but steady owner earnings because depreciation timing makes their P&L look weaker than the underlying cash conversion.
Second, the Berkshire annual meeting on May 2-3, 2026 reminded investors that the Berkshire model itself is built around finding businesses where owner earnings are durable, growing, and not dependent on heroic CapEx assumptions. That focus has been re-amplified across financial media as the succession discussions continue and Buffett's investment philosophy stays in the headlines.
Third, the 10-year Treasury yield has settled into a 4.20% to 4.50% range, which means an owner earnings yield of 5% no longer screams "cheap" the way it did three years ago. Comparing owner earnings yield to the risk-free rate is a quick way to see whether a quality compounder is actually being rewarded for its quality.
Owner Earnings vs Free Cash Flow: A 20-Stock May 2026 Snapshot
The owner earnings calculator excel template at the end of this post applies the formula to a 20-stock Buffett-aligned watchlist. The table below summarizes what the template produces - actual values are computed live from MarketXLS data when you open the workbook.
| Metric | What It Captures | Why It Matters |
|---|---|---|
| Net Income | Reported GAAP earnings | Starting point - the headline P&L number |
| D&A Add-Back | Depreciation, amortization, accretion | Adds back non-cash charges from the income statement |
| Total CapEx | All capital expenditure | Includes both maintenance and growth |
| Maintenance CapEx | Estimated as % of total CapEx | Only this portion is subtracted from owner earnings |
| Working Capital Change | Year-over-year change | Increase in WC reduces cash available to owners |
| Owner Earnings | Net Income + D&A - Maint CapEx - WC | Buffett's bottom line |
| Reported Free Cash Flow | OCF - Total CapEx | Standard GAAP-derived cash measure |
| Diff (OE - FCF) | Owner Earnings minus Reported FCF | Positive = company is investing in growth |
The Diff column is the single most useful field in the table. A consistently positive Diff means the company's reported free cash flow is depressed by growth CapEx that owner earnings credits back to shareholders. A negative Diff usually means the company has unusual non-cash items pushing reported FCF artificially high.
How to Calculate Owner Earnings in Excel with MarketXLS Formulas
Building this from scratch in Excel without a real-time data feed is painful. You would have to manually pull each component from each company's 10-K every year. With MarketXLS, every line of the formula becomes a single function call. Here are the verified formulas the template uses, each linked to a specific component of Buffett's owner earnings equation.
Step 1: Pull Reported Earnings
=HF_NET_INCOME("AAPL", 2025)
The HF_NET_INCOME function returns the annual net income for the specified fiscal year. The template pulls it for every ticker on the watchlist with one formula per cell.
Step 2: Add Back Non-Cash Charges
=HF_DEPRECIATION_AMORTIZATION_AND_ACCRETION("AAPL", 2025)
This consolidated function returns the full D&A line from the cash flow statement, including accretion. For companies that disclose them separately, you can also use:
=HF_DEPRECIATION("AAPL", 2025)
=HF_AMORTIZATION("AAPL", 2025)
Step 3: Estimate Maintenance Capital Expenditure
This is the judgment-heavy step. Buffett himself acknowledged in the 1986 letter that maintenance CapEx is an estimate, not a reported figure. The template uses a configurable percentage of total CapEx, defaulting to 70%, controlled from the Main Dashboard input cell:
=HF_CAPITAL_EXPENDITURE("AAPL", 2025) * 'Main Dashboard'!B10
For asset-light businesses like Visa or Mastercard, you might dial the maintenance percentage down to 50% because most of their CapEx is genuinely growth-related. For utilities or telcos, you might dial it up to 90% because their CapEx is mostly replacing old infrastructure.
Step 4: Subtract Working Capital Increases
=HF_INCREASE_DECREASE_IN_OTHER_WORKING_CAPITAL("AAPL", 2025)
If working capital increased during the year, that cash is locked up in receivables or inventory rather than available to owners. The template only subtracts increases (uses a MAX function), since decreases in working capital actually free up cash.
Step 5: Combine Into Owner Earnings
= NetIncome + DepreciationAmortization - MaintenanceCapEx - MAX(WorkingCapitalIncrease, 0)
Each component is in its own column on the Owner Earnings Calc sheet, so you can audit the math line by line. The total is then carried to the Per-Share Metrics sheet for yield and multiple calculations.
Step 6: Cross-Check with Reported Free Cash Flow
=HF_FREE_CASH_FLOW("AAPL", 2025)
=HF_FREE_CASH_FLOW_PER_SHARE("AAPL", 2025)
The template displays reported FCF next to owner earnings on every sheet so you can see exactly where the two diverge.
The Two-Stage DCF Built On Owner Earnings
A single-year owner earnings figure is interesting but not actionable. The template's Scenario Analysis sheet wires it into a two-stage discounted cash flow model that produces an intrinsic value estimate. The mechanics:
- Year 0 owner earnings is your starting cash flow figure.
- Years 1-5 grow at the near-term growth rate (default 7%) from the Main Dashboard.
- Year 6 onward grows at the terminal growth rate (default 3%).
- Discount rate (default 9%) is applied to bring all future cash flows back to present value.
- Terminal value is computed via the Gordon growth model: Year 6 OE / (r - g).
- Sum of discounted cash flows plus the discounted terminal value gives intrinsic value.
The sensitivity grid at the bottom of the sheet shows intrinsic value at five discount rates crossed with five growth rates. The spread is usually surprising - a one-percentage-point change in either input typically swings fair value by 25% to 40%. That spread is exactly why Buffett insists on a margin of safety.
The default margin of safety input on the Main Dashboard is 25%. Apply that haircut to the intrinsic value cell before deciding whether the current market price is attractive. If a stock is trading at or below intrinsic value times 0.75, you have a Buffett-style margin of safety baked into the entry price.
Quality Screener Overlay - Owner Earnings Without Quality Is a Trap
Owner earnings yield in isolation is a number. Owner earnings yield paired with a durable competitive moat is a thesis. The template's Quality Screener sheet applies four classic Buffett-aligned filters to the watchlist:
- Return on equity above 15% - signals the business compounds capital efficiently.
- Total debt to equity below 1.50 - keeps balance-sheet risk in check.
- Operating margin above 15% - confirms there is pricing power.
- Revenue growth above 4% - rules out melting-ice-cube businesses.
Each company gets a 0-to-4 score based on how many filters it passes. A score of 4 earns the "Wide Moat" label. Score of 3 is "Quality." Scores of 0 to 2 are flagged "Mixed" or "Weak" so they get a closer look before being acted on.
The MarketXLS formulas powering these filters:
=ReturnOnEquity("AAPL") -> TTM return on equity
=TotalDebtToEquity("AAPL") -> Total debt to equity ratio
=OperatingMargin("AAPL") -> TTM operating margin
=HF_REVENUE_GROWTH("AAPL", 2025) -> Revenue growth rate
=HF_PROFIT_MARGIN("AAPL", 2025) -> Annual profit margin
=Beta("AAPL") -> Five year beta vs market
The Comparison Matrix sheet then ranks the watchlist on owner earnings yield while simultaneously flagging the quality score. The ideal hit is a name with both a high owner earnings yield and a Wide Moat label - the verdict column flags those as "Strong cash + moat."
What's In The Owner Earnings Calculator Excel Template
The free template at the end of this post is a 7-sheet Excel workbook built specifically around Buffett's owner earnings framework. Every value is either an input you control or a live MarketXLS formula. Here's what each sheet does.
Sheet 1: How To Use
The opening tutorial. Explains the formula, what each subsequent sheet does, and how to drive the workbook from the Main Dashboard input cells. Also lists every MarketXLS function used in the workbook in one place so you can refer back to it.
Sheet 2: Main Dashboard
The control panel. Yellow input cells set the discount rate, near-term growth rate, terminal growth rate, maintenance CapEx percentage, margin of safety, and portfolio size. Below the inputs is a 20-stock watchlist snapshot showing live price, market cap, P/E, ROE, and dividend yield. Average summary statistics let you see the watchlist's average quality and valuation at a glance.
Sheet 3: Owner Earnings Calc
The line-by-line owner earnings calculation for each watchlist company. Net Income, D&A, Total CapEx, Maintenance CapEx (driven by the Main Dashboard percentage), Working Capital change, Owner Earnings, Reported FCF, and the Diff column. A totals row at the bottom shows watchlist-level cash generation.
Sheet 4: Per-Share Metrics
Translates total owner earnings into per-share figures. Owner earnings per share, owner earnings yield (OE/Price), price-to-owner-earnings multiple, FCF yield, and the difference between OE yield and FCF yield. This is the sheet you scan when you want to find the cheapest names on a Buffett basis.
Sheet 5: Scenario Analysis
The two-stage DCF described above. Editable inputs for owner earnings, growth, and discount rate. Year-by-year forecast. Discounted cash flow table. Sensitivity grid showing intrinsic value at 25 different discount-rate / terminal-growth-rate combinations. This is where you stress-test fair value before acting.
Sheet 6: Quality Screener
Four-filter Buffett-style screen with adjustable thresholds. ROE, Debt/Equity, Operating Margin, Revenue Growth. Each company is scored 0-4 and labeled Wide Moat, Quality, Mixed, or Weak. Aggregate counts at the bottom show how many of the watchlist names pass the bar.
Sheet 7: Comparison Matrix
Final ranking. Ticker, sector, price, OE yield, FCF yield, earnings yield (1/PE), quality label, and a verdict column. The verdict combines yield and quality into one of four categories: "Strong cash + moat," "High OE yield," "Quality compounder," or "Watch." Sort the table on any column to find the top-ranked names.
Real Worked Example: Applying Owner Earnings to a Berkshire Holding
Take any large-cap holding from Berkshire's 13F filings and the workflow is the same. Open the template, the Owner Earnings Calc sheet has it computed already, but here's the manual walkthrough using the MarketXLS formulas.
Start with reported earnings:
=HF_NET_INCOME("AAPL", 2025) / 1000000000
That returns Apple's full-year net income in billions. Add back D&A:
=HF_DEPRECIATION_AMORTIZATION_AND_ACCRETION("AAPL", 2025) / 1000000000
Now subtract maintenance CapEx, which the template estimates as 70% of total CapEx:
=ABS(HF_CAPITAL_EXPENDITURE("AAPL", 2025)) / 1000000000 * 0.70
Subtract any working capital increase:
=MAX(HF_INCREASE_DECREASE_IN_OTHER_WORKING_CAPITAL("AAPL", 2025) / 1000000000, 0)
The result is owner earnings in billions. Divide by total common shares outstanding:
=HF_TOTAL_COMMON_SHARES_OUTSTANDING("AAPL", 2025) / 1000000000
That gives owner earnings per share. Divide by the current price for the owner earnings yield:
=QM_Last("AAPL")
Now compare to the 10-year Treasury yield. If owner earnings yield is meaningfully above the risk-free rate AND the company passes the quality filters AND it is trading below your DCF-derived intrinsic value times your margin of safety, you have a Buffett-style buy candidate.
Owner Earnings vs Other Valuation Metrics
It is worth being clear about what owner earnings does and does not replace.
| Metric | What It Tells You | What It Misses |
|---|---|---|
| EPS / P/E | Headline accounting profit | Ignores cash conversion quality |
| EBITDA | Operating cash before interest and taxes | Ignores CapEx entirely |
| Reported FCF | Cash after all CapEx | Treats growth CapEx as a cost |
| Owner Earnings | Cash after maintenance CapEx only | Requires judgment on maint vs growth split |
Owner earnings is the cleanest measure of cash available to owners after the business has fully reinvested to maintain its current capacity. It rewards capital-light compounders. It penalizes companies whose maintenance CapEx is structurally higher than a peer's, even if their reported FCF looks identical.
Investors who rely solely on EPS-based multiples will misprice both ends of the quality spectrum. Owner earnings narrows that gap.
How to Customize the Template for Your Own Watchlist
The template ships with 20 Buffett-aligned tickers but works on any US-listed equity. To swap in your own list:
- Open the Main Dashboard sheet.
- Replace any ticker in column A of the watchlist table with your own.
- The formulas on every downstream sheet automatically update because they reference the ticker column on Main Dashboard.
You can also adjust the maintenance CapEx percentage on a per-sector basis. The template uses one global percentage from the Main Dashboard, but if you want a more nuanced approach, copy the Owner Earnings Calc sheet, override column F with sector-specific assumptions, and reference the new sheet from Per-Share Metrics.
For a deep dive on building Excel-native investment screeners, the stock screener guide on MarketXLS walks through how to chain MarketXLS functions into custom multi-factor models.
Download the Owner Earnings Calculator Excel Templates
Download the templates:
- - Pre-filled with illustrative values from May 2026 plus formula reference column
- - Every cell is a live MarketXLS formula
The sample file is a good way to see how the math works before you wire up live data. The template file is what you use day-to-day. Both contain the same 7-sheet structure: How To Use, Main Dashboard, Owner Earnings Calc, Per-Share Metrics, Scenario Analysis, Quality Screener, and Comparison Matrix.
Frequently Asked Questions
What is Warren Buffett's owner earnings formula?
Owner earnings is defined in Warren Buffett's 1986 letter to Berkshire Hathaway shareholders as: Reported Earnings + Depreciation, Amortization, and other non-cash items - Average annual capitalized expenditures (maintenance CapEx) - Increases in working capital. It represents the cash a business could distribute to owners without impairing its ability to continue operating at current scale.
How is owner earnings different from free cash flow?
Free cash flow subtracts total capital expenditure from operating cash flow. Owner earnings only subtracts the maintenance portion of CapEx, treating growth CapEx as discretionary investment that could in theory be returned to owners. This makes owner earnings higher than reported FCF for companies investing aggressively in expansion, and roughly equal to FCF for steady-state businesses with no growth investment.
How do I estimate maintenance CapEx?
Maintenance CapEx is not a reported figure - it is an estimate. The most common approaches are: (1) a fixed percentage of total CapEx (70% is a common starting point for a diversified portfolio), (2) D&A as a proxy on the assumption that depreciation tracks the cost of replacing assets in steady state, or (3) a sector-specific assumption (90%+ for utilities and telcos, 50% for asset-light software businesses). The owner earnings calculator excel template uses a configurable percentage so you can stress-test different assumptions.
What is a good owner earnings yield?
The right benchmark is the 10-year Treasury yield plus a risk premium. With the 10-year Treasury at 4.20% to 4.50% in May 2026, an owner earnings yield of 5% is roughly fair value, 6% to 7% is attractive, and 8%+ usually signals either a deep value opportunity or a quality concern. Always pair owner earnings yield with the quality screener output before acting.
Can I use owner earnings for a DCF model?
Yes - it is arguably the cleanest input to a DCF. Reported earnings include non-cash charges and tax-shield distortions. Reported FCF mixes maintenance and growth investment. Owner earnings is the closest you can get to the cash a business could distribute, which is what a discount rate is supposed to be applied to. The template's Scenario Analysis sheet runs a two-stage DCF directly off the owner earnings figure.
Why do I see large differences between owner earnings and reported FCF?
The two diverge most when companies are investing heavily in growth. Hyperscale cloud providers, semiconductor capacity build-outs, and large industrials in the middle of expansion programs typically show owner earnings well above reported FCF because so much of their CapEx is growth-related. Conversely, mature consumer staples businesses often show owner earnings roughly equal to reported FCF because most of their CapEx is genuinely maintenance.
Does this work for non-US stocks?
The MarketXLS HF_ functions support a broad range of international equities, but coverage and reporting standards vary. The template is built around US GAAP fiscal-year reporting. For non-US names, double-check the fiscal-year conventions and adjust the Main Dashboard year input accordingly.
The Bottom Line
Owner earnings calculator excel is the single most useful Buffett-aligned valuation tool you can build. It turns a 1986 framework into a live, sortable, screenable Excel dashboard that ranks any watchlist on the cleanest cash basis. The template at the top of this post does that for 20 quality compounders out of the box and works on any US-listed ticker you swap in.
What makes the framework durable is its insistence on judgment. Maintenance CapEx is an estimate. Growth rates are estimates. Discount rates are estimates. The discipline of working through each input forces you to articulate your investment thesis explicitly, rather than hiding behind a single P/E multiple. That discipline is exactly what the Berkshire annual meeting weekend reminded investors about - and exactly what Buffett's 1986 letter was pushing toward in the first place.
Pair the owner earnings yield with the quality screener output, apply your margin of safety, and you have a workable framework for finding compounders that are still being rewarded for their durability. Use the comparison matrix to rank your watchlist, the scenario analysis to stress-test fair value, and the quality screener to weed out yield traps before they become losses.
For more Excel-native investment frameworks, explore MarketXLS features covering options analytics, real-time streaming data, and 1,100+ purpose-built financial functions. To see the full Buffett-style toolkit in action with your own watchlist and live data, book a demo and we'll walk you through wiring it up end-to-end.
This workbook is educational only. Owner earnings is a framework, not investment advice. Always consult a licensed advisor before acting on any valuation output.
