Stock-based compensation dashboard Excel - if that is what brought you here, you are looking for a single workspace that shows where SBC is quietly eating into earnings, how much dilution is structural versus offset by buybacks, and how the adjusted EPS that AI and software companies report compares to GAAP. That is exactly what this premium dashboard delivers, with live MarketXLS formulas wired in across ten sheets.
This guide walks through the template's design, the SBC math that drives every column, and the case for treating stock-based compensation as a first-class metric when you analyze mega-cap tech and high-growth software in 2026.
Why SBC matters in 2026
The AI boom has pushed equity-heavy compensation back into the spotlight. When NVIDIA's revenue triples in two years and SBC scales with it, the absolute dollars get large enough that "non-cash" stops feeling like the right adjective. When Snowflake reports adjusted EPS but the GAAP line is still negative because SBC is roughly a third of revenue, the gap between reported and adjusted earnings becomes the entire investment debate.
Adjusted (non-GAAP) earnings exclude SBC at most software companies. GAAP earnings include it. The wider that gap gets, the more you need a structured way to see how the numbers reconcile, who is offsetting issuance with buybacks, and which names are running SBC at sustainable versus stretched levels.
| Watchlist | Approx SBC TTM | Approx SBC % of Revenue | Watchlist Tier |
|---|---|---|---|
| NVDA | $4.7B | 3.5% | AI hardware compounder |
| META | $16.8B | 10.8% | Big tech moderate |
| GOOGL | $22.5B | 6.3% | Big tech moderate |
| AMZN | $25.4B | 4.1% | Big tech moderate |
| MSFT | $10.8B | 4.3% | Big tech moderate |
| AAPL | $11.5B | 2.9% | Mega-cap conservative |
| CRM | $3.2B | 8.4% | Enterprise SaaS |
| NOW | $2.0B | 18.0% | High-growth SaaS |
| SNOW | $1.5B | 37.9% | Stretched / data cloud |
| CRWD | $0.8B | 22.0% | Stretched / cybersecurity |
| NET | $0.3B | 16.6% | Stretched / edge cloud |
| DDOG | $0.4B | 15.7% | Stretched / observability |
Figures above are illustrative and snapshot the 2026-05-28 view used to build the sample workbook. The live template pulls these numbers directly from MarketXLS formulas, so the screener refreshes whenever you open the file.
What is inside the template
The dashboard ships as two files - a Sample workbook with pre-filled values and embedded MarketXLS formula references, and a Template workbook that runs entirely on live formulas. Both files contain ten sheets that walk from a branded cover through the dashboard, scenario analysis, dilution math, and a glossary built for an analyst audience.
- Cover - presentation-ready landing sheet with the table of contents, version label, data-as-of stamp, and MarketXLS branding. Gridlines hidden.
- How To Use - tutorial that explains every input, every dropdown, and every KPI tile in plain English.
- Dashboard - the headline view. KPI tile row across the top, two embedded charts for SBC as a percent of revenue and aggregate SBC dollars, and a conditionally formatted screener at the bottom with green-to-red heatmaps for SBC intensity and the adjusted-versus-GAAP gap.
- Inputs - dedicated yellow-celled control sheet with portfolio size, SBC normalization rate, dilution penalty multiplier, analysis horizon, three scenario dropdowns, and an editable watchlist.
- Scenario Analysis - three SBC normalization scenarios (Aggressive, Base, Conservative) applied to each ticker. Shows what the implied PE looks like when you treat 100, 50, or 25 percent of SBC as a real cash expense.
- Dilution Impact - diluted weighted-average share count, year-over-year share growth, net buyback dollars, and the buyback offset ratio. Embedded bar chart of share dilution year over year.
- GAAP vs Adjusted - reconciles trailing GAAP diluted EPS against the consensus non-GAAP current-year adjusted EPS, then computes GAAP and adjusted PE side by side. Clustered column chart compares the two EPS series.
- Sector Comparison - aggregates SBC dollars and revenue by sector, computes a weighted SBC percent of revenue, and embeds a pie chart of SBC share by sector.
- Methodology - one-page explainer covering watchlist construction, metric definitions, scenario logic, GAAP vs adjusted logic, sector grouping, data sources, and limitations.
- Glossary and Disclaimer - sixteen defined terms including RSU, ESO, ESPP, Buyback Offset Ratio, and Normalization Rate, plus the educational-only disclosure.
Every sheet uses the same premium design language: navy and MarketXLS blue headers, gold-bordered yellow input cells, three-color heatmaps for ranking columns, data bars for magnitude columns, frozen panes, tab colors per sheet, and a "MarketXLS Functions Used" reference box at the bottom of every sheet. The Cover and Dashboard sheets hide gridlines, and the Dashboard's print area is configured to land cleanly on one landscape page.
The SBC math that drives every column
There are five core calculations in the dashboard. Once you understand these, every cell on every sheet becomes self-explanatory.
1. SBC as a percent of Revenue
The headline ratio. Read this first.
SBC % of Revenue = HF_SHARE_BASED_COMPENSATION(ticker, year, "", "TTM")
/ HF_REVENUE(ticker, year, "", "TTM")
A 2 to 5 percent reading is conservative. A 6 to 10 percent reading is typical for big-tech. Above 10 percent flags as stretched and turns the heatmap cell red on the Dashboard screener.
2. SBC as a percent of Free Cash Flow
The same dollar amount looks very different against free cash flow. If a company generates $1B of free cash flow and runs $500M of SBC, half of every dollar of cash it produces is being matched by equity issuance.
SBC % of FCF = HF_SHARE_BASED_COMPENSATION(ticker, year, "", "TTM")
/ LeveredFreeCashFlow(ticker)
Anything over 100 percent means SBC dollars exceed free cash flow dollars. The Dashboard screener flags this column in red above 50 percent.
3. Share dilution year over year
The single number that captures whether equity issuance is creating real dilution net of buybacks.
Dilution YoY = HF_SHARE_DILUTION_RATIO(ticker, year, "", "TTM")
A positive value means more shares this year than last; a negative value means buybacks have shrunk the float. Apple, for example, has run negative dilution for over a decade because its buyback program more than offsets RSU vesting.
4. GAAP versus adjusted EPS gap
Calculated on the GAAP vs Adjusted sheet. The premium column shows by what percent adjusted EPS exceeds GAAP EPS, which is almost always positive at SBC-heavy companies.
Adjusted Premium = (Adjusted EPS - GAAP EPS) / |Adjusted EPS|
Below 20 percent is normal. Above 50 percent is the kind of gap that should make you read the non-GAAP reconciliation carefully. The PE columns next to this show what valuation multiple each EPS basis implies at the current share price.
5. SBC normalization scenarios
Each scenario assumes a different fraction of SBC is treated as a real cash expense and subtracts that amount from the consensus adjusted EPS.
Normalized EPS = Adjusted EPS - normalization_rate * (SBC TTM / Diluted Shares)
Implied PE = Current Price / Normalized EPS
The Scenario Analysis sheet runs all three cases (Aggressive 100 percent, Base 50 percent, Conservative 25 percent) automatically and color-codes each implied PE so green is reasonable and red is stretched.
Three lenses for reading SBC
The dashboard is built to be read at three altitudes - basket, single name, and sector. Each surfaces a different question.
Basket lens
The KPI tile row on the Dashboard tells you the basket story in six numbers: median SBC percent of revenue, aggregate SBC dollars across the watchlist, count of names above the 10 percent threshold, median share dilution, the median adjusted-versus-GAAP gap, and the average SBC growth rate year over year. For a default high-SBC tech watchlist, the median SBC percent of revenue typically sits in the 7 to 9 percent range and aggregate SBC easily clears $90B annualized.
Single name lens
The screener at the bottom of the Dashboard ranks each ticker on fourteen columns and applies four kinds of conditional formatting. SBC as a percent of revenue runs a green-to-red color scale. SBC dollars runs as a data bar. Dilution YoY uses three-arrow icons (up arrow for positive dilution, flat for neutral, down arrow for net buyback). The adjusted-versus-GAAP gap uses a green-to-red color scale capped at 100 percent so SNOW or CRWD stand out immediately.
Sector lens
The Sector Comparison sheet rolls each name's SBC and revenue up to its sector, then divides at the sector level. This is the right way to compare Communication Services to Technology because it weights the aggregate dollars rather than averaging percentages. The pie chart shows SBC share by sector at a glance, and the conditional formatting flags any sector running above 10 percent weighted SBC intensity.
Reading the watchlist
The default twelve-name watchlist mixes three distinct cohorts so the dashboard surfaces contrast.
Mega-cap tech and AI hardware (NVDA, MSFT, AAPL, GOOGL, AMZN, META) sit in the 3 to 11 percent SBC-of-revenue band. These companies have the capital flexibility to run large buyback programs alongside SBC programs, which keeps net dilution low or negative. Apple is the cleanest example - SBC is roughly 3 percent of revenue and net dilution is meaningfully negative because the buyback program is so large.
Enterprise SaaS (CRM, NOW) sits in the 8 to 18 percent band. These are profitable software companies that still rely heavily on equity compensation to attract engineering and sales talent. SBC percent of FCF is the metric to watch here because the FCF margin is high but SBC scales with headcount.
High-growth software and infrastructure (SNOW, CRWD, NET, DDOG) sits in the 15 to 38 percent band. These names report adjusted EPS that often hides a negative GAAP line entirely. The buyback offset ratio is typically below 0.5x, which means dilution is structural rather than offset.
Mix and match these to fit your own watchlist. The Inputs sheet has a yellow watchlist block where you can swap any ticker. The Dashboard, Dilution Impact, GAAP vs Adjusted, and Sector Comparison sheets all refresh from that list.
Building the dashboard in Excel with MarketXLS
If you want to recreate the same screener from scratch instead of using the prebuilt template, every column reduces to a small number of MarketXLS calls. The most useful set:
=QM_Last("NVDA")
Live share price.
=HF_SHARE_BASED_COMPENSATION("NVDA", 2025, "", "TTM")
Stock-based compensation for the trailing twelve months.
=HF_REVENUE("NVDA", 2025, "", "TTM")
Revenue for the trailing twelve months.
=HF_WEIGHTED_AVERAGE_SHARES_DILUTED("NVDA", 2025, "", "TTM")
Diluted weighted average shares.
=HF_SHARE_DILUTION_RATIO("NVDA", 2025, "", "TTM")
Net share dilution year over year.
=HF_ISSUANCE_PURCHASE_OF_EQUITY_SHARES("NVDA", 2025, "", "TTM")
Net dollars of equity issued (negative means net buyback).
=HF_EPS("NVDA", 2025, "", "TTM")
Trailing twelve-month GAAP diluted EPS.
=EpsEstimateAvgCurrentYear("NVDA")
Consensus non-GAAP adjusted EPS for the current year.
=LeveredFreeCashFlow("NVDA")
Levered free cash flow.
=MarketCapitalization("NVDA")
Market capitalization in dollars.
=Sector("NVDA")
Sector classification.
=Industry("NVDA")
Industry classification.
=PERatio("NVDA")
Trailing PE ratio.
=Beta("NVDA")
Beta versus market.
Anchor those formulas in a row per ticker and the screener falls out naturally. Layer in ColorScale and DataBar conditional formatting from the Home ribbon, add a PivotTable for the sector roll-up, and you have a working version of the Dashboard sheet inside an afternoon. Or save the time and download the premium template below.
The Scenario Analysis sheet in detail
This is the sheet that pays for itself if you cover SaaS and AI software names. The math is simple but the framing is what most adjusted-EPS reconciliations miss.
Start with the consensus adjusted EPS. Subtract some fraction of the per-share SBC. Compare the result against the current price.
For a name like ServiceNow, where SBC runs roughly $2B against 208 million diluted shares, the SBC per share is around $9.50. With consensus adjusted EPS at $14.50 and the share price around $825:
- Conservative case (25 percent of SBC expensed): adjusted EPS drops to $12.13, implying a PE of roughly 68x.
- Base case (50 percent of SBC expensed): adjusted EPS drops to $9.75, implying a PE of roughly 85x.
- Aggressive case (100 percent of SBC expensed): adjusted EPS drops to $5.00, implying a PE north of 165x.
That spread is the conversation. Whatever your own view on SBC normalization, the dashboard gives you the math to test the position without rebuilding the model.
How the Dilution Impact sheet reads
Three columns on the Dilution Impact sheet do most of the work:
Diluted Shares ($M) - the raw share count. Useful for spotting names where one share class is dominating or where convertible debt is creating phantom dilution.
Net Buybacks ($M) - net dollars returned to shareholders through buyback programs. Sourced from HF_ISSUANCE_PURCHASE_OF_EQUITY_SHARES, sign-flipped so a positive number means buying.
Buyback Offset Ratio - net buyback dollars divided by SBC dollars. The single most useful number on this sheet. Above 1.0x means buybacks are covering SBC issuance. Below 1.0x means dilution is structural. Apple, Microsoft, Meta, and Alphabet all run above 1.0x consistently. NVIDIA has grown into a ratio above 1.0x as buyback dollars have scaled with revenue. Snowflake, Cloudflare, Datadog, and CrowdStrike all run below 0.5x today.
Conditional formatting makes the ratio readable at a glance. Red below 1.0x, yellow around 1.0x to 2.0x, green above 2.0x.
How the GAAP vs Adjusted sheet reads
For each ticker the sheet reports:
- Current share price
- Trailing GAAP diluted EPS
- Consensus non-GAAP adjusted EPS for the current year
- Premium (the percent gap between the two)
- Implied PE on GAAP EPS
- Implied PE on adjusted EPS
The premium column is the headline. A 5 to 20 percent premium is the typical band at mega-cap names. A premium above 50 percent flags as stretched and turns the cell amber. A premium above 100 percent means adjusted EPS is at least double GAAP EPS, which is the band where SNOW, NET, and CRWD typically sit. The clustered column chart at the bottom of the sheet visualizes the GAAP versus adjusted gap across the watchlist, with GAAP in MarketXLS blue and adjusted in gold.
The implied PE columns are the practical takeaway. If a name trades at 30x adjusted EPS but 200x GAAP EPS, the entire valuation argument depends on accepting the adjusted basis. The dashboard does not tell you whether to accept it; it tells you how much of the multiple depends on the adjustment.
A note on Apple
Apple is the outlier worth talking about. Despite running roughly $11.5B of SBC TTM, net dilution is meaningfully negative because the buyback program returns close to $100B a year to shareholders. The buyback offset ratio is roughly 8.5x. The adjusted-versus-GAAP premium sits around 12 percent. The SBC percent of revenue is under 3 percent.
That combination - high absolute SBC dollars, low SBC-of-revenue ratio, large buyback offset, narrow adjusted-versus-GAAP gap - is the textbook profile of a mega-cap returning cash to shareholders at scale. The dashboard surfaces it in three glances: red SBC dollars data bar (because the absolute number is large), green SBC-of-revenue heatmap cell, deep green dilution arrow, and a buyback offset ratio that lights up at the top of the heatmap.
It is also the implicit benchmark for every other name on the watchlist. If Snowflake has 38 percent SBC of revenue and a 0.3x buyback offset, you can quantify exactly what would need to change for it to run an Apple-style cash-return profile.
Customizing the watchlist
The Inputs sheet is built so you can replace the default twelve names without breaking anything downstream. Common variations:
Magnificent 7 only - swap CRM, NOW, SNOW, CRWD, NET, DDOG out and add TSLA. The KPI tiles, screener, and Sector Comparison all reflow.
SaaS deep-dive - swap the mega-caps out and add ADBE, INTU, WDAY, TEAM, ZS, OKTA, MDB, S, PANW, FTNT. The watchlist supports up to twelve rows; rebuild the formula cells in column B11 through B22 on the Inputs sheet.
AI infrastructure - NVDA, AVGO, MRVL, ASML, AMAT, LRCX, AMD, QCOM, ARM, MU, TSM, ANET. Useful for tracking SBC at the picks-and-shovels layer.
Custom basket - any twelve tickers MarketXLS covers. The HF_ formulas resolve any US-listed common stock.
Tab colors, formatting, and conditional rules all persist as you swap. The only manual step is renaming the workbook on save if you want to preserve the original.
Download the templates
Download the templates:
- - pre-filled with snapshot data and embedded formula comments on every data cell
- - live formulas across all ten sheets, refresh on open
Both files are free. The MarketXLS formulas in the live template require an active MarketXLS subscription; the Sample version opens in any Excel install and shows what the live numbers will look like when refreshed.
Frequently asked questions
What is stock-based compensation, and why does it matter?
Stock-based compensation is the dollar value of equity awards (mostly RSUs and stock options) granted to employees, expensed over the vesting period. It matters because it is a real cost to existing shareholders that does not show up in operating cash flow. The income statement treats it as a compensation expense, the cash flow statement adds it back to operating cash flow, and the equity issuance that ultimately settles the awards dilutes existing shareholders. The dashboard surfaces this three-way picture across SBC dollars, SBC as a percent of revenue and FCF, and share dilution.
Why is SBC excluded from non-GAAP adjusted earnings?
Companies argue that SBC is a non-cash expense, so excluding it gives a cleaner view of the underlying business. The counter-argument is that SBC is a real economic cost - the company is paying employees in equity it could otherwise sell on the market or use to buy back shares. The Scenario Analysis sheet in the dashboard lets you test the spectrum, treating 25, 50, or 100 percent of SBC as a cash-equivalent expense and seeing what each assumption does to the implied PE.
How do I read the buyback offset ratio?
The buyback offset ratio is net buyback dollars divided by SBC dollars. A reading of 1.0x means buybacks fully cover the equity issuance from SBC; the share count is approximately flat. A reading of 2.0x means buybacks are returning twice as much cash as SBC is issuing, which is why mega-caps with large buyback programs run negative dilution. A reading below 1.0x means dilution is structural - the company is issuing more equity through SBC than it is repurchasing.
Why does the template use HF_ formulas instead of QM_ formulas for SBC?
The HF_ family covers historical financial statement data with year, quarter, and TTM parameters. SBC, revenue, diluted shares, and dilution all live in the HF_ family because they come off the cash flow statement and the income statement. The QM_ family covers live quote data (price, market cap, shares outstanding). The dashboard uses HF_ for fundamentals and QM_ for prices, which mirrors how MarketXLS structures the data feeds internally.
Can I use this template on non-US stocks?
The MarketXLS HF_ functions cover US-listed common stocks. International ADRs that report under US GAAP work; foreign primary listings that report under IFRS or local GAAP may have different SBC disclosures, and the formulas may return errors for tickers MarketXLS does not cover. Test a single ticker before you swap an entire watchlist.
How often should I refresh the data?
SBC, revenue, and share counts update on company earnings cadence (quarterly). Prices, market caps, and consensus EPS estimates update intraday. Open the workbook once a week to refresh the price-dependent columns, and once a quarter to capture new fundamentals once earnings have been reported.
Is this dashboard suitable for screening for investment ideas?
The dashboard is built as an educational and analytical tool, not an investment recommendation. It surfaces which companies run SBC heavy and which do not, which adjust EPS aggressively and which do not, and which return more cash through buybacks than they issue through SBC. Use those signals as inputs to your own research process. Always read the company filings, consult a licensed financial advisor where appropriate, and remember that valuation multiples can stay stretched or compressed for long periods.
The bottom line
Stock-based compensation has gone from a footnote to one of the central debates in tech investing. The AI boom multiplied the absolute dollars. The shift to RSU-heavy comp at every level of the engineering org made the percent-of-revenue numbers structurally larger. The widening gap between adjusted and GAAP EPS at software companies made the headline numbers harder to compare across names. A dashboard that puts SBC dollars, SBC as a percent of revenue, SBC as a percent of free cash flow, share dilution, buyback offset, and the GAAP versus adjusted reconciliation on one screen is the cleanest way to see all of those moving parts at once.
The premium template above is designed to do exactly that. Ten sheets, KPI tiles, embedded charts, conditional formatting, scenario analysis, sector roll-ups, an interactive Inputs sheet, and live MarketXLS formulas across the watchlist. Download the Sample to see what the numbers look like populated. Download the Template to plug in your own watchlist and refresh.
Want to see MarketXLS power more dashboards like this? Visit marketxls.com for the full Excel add-in or book a demo to see live formulas, screeners, and portfolio analytics in action.
