Net Debt to EBITDA screener Excel - if you searched for this, you are trying to do something specific: rank a basket of companies by how stretched their balance sheets are, decide which names sit safely on the right side of the 3x line, and stress test whether those rankings hold if EBITDA contracts or debt rolls at higher rates. This guide ships a dashboard-style premium template that does all three with live MarketXLS formulas, plus the analytical framework to read the output without falling into common traps.
By the time you finish, you will have a 10-sheet professional-grade workbook that runs a leverage screen across 25 large-cap names, classifies each into one of five credit-quality tiers, applies a 5x5 stress matrix on EBITDA and debt, rolls leverage up by GICS sector for a structural view, and proposes a position-sized portfolio of the cleanest balance sheets - all wired to MarketXLS so the numbers refresh on demand.
Leverage snapshot - where the S&P sits in May 2026
| Tier | Net Debt / EBITDA | Names in 25-company universe | Sectors represented |
|---|---|---|---|
| Net Cash | Below 0 | 6 | Tech, Communication Services, Consumer Disc |
| Conservative | 0 to 1.5x | 8 | Tech, Healthcare, Consumer Staples, Energy |
| Moderate | 1.5x to 3.0x | 6 | Consumer, Healthcare, Industrials |
| Elevated | 3.0x to 5.0x | 3 | Healthcare, Communication Services |
| High | Above 5.0x | 2 | Utilities, REITs |
The most-leveraged names cluster in capital-intensive sectors - utilities and large telecoms - while the mega-cap technology cohort still anchors the net-cash side of the distribution. The premium template surfaces this pattern in one screen and lets you re-run it against any custom basket.
Why leverage matters more in 2026
Three things make Net Debt to EBITDA a higher-stakes lens in 2026 than it was in the zero-rate decade:
The refinancing wall. A meaningful slug of corporate debt issued during the 2020-2021 cheap-money window is rolling. Companies that financed at sub-3 percent coupons are refinancing at 5 to 7 percent. The interest line on the income statement is climbing even before EBITDA reacts, and the ratio itself stays flat - so the screen is only half the story; the qualitative reads in this guide explain how to pair it with interest coverage.
EBITDA fragility post-tariff regime. Tariff impacts have made operating margin assumptions more brittle for industrials, autos, and import-heavy consumer names. A 15 percent EBITDA haircut that looked extreme in 2019 looks plausible now. The Scenario Analysis sheet runs that haircut as a base case.
Credit-rating agency thresholds. Most agencies use Net Debt to EBITDA as one of two or three top-line factors for investment grade versus high yield. A name drifting from 2.5x to 3.2x can trigger downgrade reviews; a name moving the other way can earn an upgrade. The screen catches the drift earlier than the rating action.
The template is built to make these dynamics visible at a glance.
What is Net Debt to EBITDA
Net Debt to EBITDA expresses, in years, how long a company would take to repay its net debt out of operating earnings at the current run rate. The formula is straightforward:
Net Debt = Total Debt - Total Cash
Net Debt / EBITDA = Net Debt / EBITDA
A ratio of 2.0x means the company could theoretically retire its net debt in two years if all EBITDA went to paydown. A ratio below zero means the company holds more cash than debt - a "net cash" position. A ratio above 5x is generally considered leveraged and lives in high-yield territory unless the business has unusually stable cash flow (utilities, regulated telecoms, well-located REITs).
The metric is the most cited leverage figure in credit research because it normalizes debt against operating earning power. Two companies with identical $20 billion of net debt look very different if one earns $5 billion of EBITDA (4.0x leverage) versus one earning $20 billion (1.0x leverage).
How the screener tiers work
The dashboard sorts every name into one of five tiers based on the ratio:
| Tier | Range | Read |
|---|---|---|
| Net Cash | < 0 | More cash than debt. Effectively unlevered. |
| Conservative | 0 to 1.5x | Comfortable cushion. Could absorb shocks. |
| Moderate | 1.5x to 3.0x | Normal corporate leverage. |
| Elevated | 3.0x to 5.0x | Bank covenant pressure starts here. |
| High | > 5.0x | High yield territory; cash flow has to be very stable. |
The five-tier scheme echoes how credit-rating agencies separate investment grade from leveraged credit. Above 3.0x net debt to EBITDA is roughly where BBB transitions to BB - the line between investment-grade and high-yield - though the agencies layer in cash flow stability, sector mix, and qualitative factors.
Inside the premium leverage dashboard - what is in the template
The workbook ships with 10 sheets. Each one is designed to look like a piece of a finished product, not a worksheet handout.
1. Cover. Branded title page with a navy banner, gold subtitle, version, last-updated date, and a clickable table of contents for the other nine sheets. Hidden gridlines so the page reads like a cover, not a spreadsheet.
2. How To Use. Eight-step tutorial that walks through every input cell and every sheet. Color-coded step badges and resource links at the bottom for the MarketXLS site, demo booking, and function documentation.
3. Dashboard. The headline sheet. Four KPI tiles across the top - universe size, names passing the threshold, median Net Debt to EBITDA, and the cleanest balance sheet in the cohort. Below the tiles, a sortable screener table with conditional formatting heatmaps on market cap, total debt, and the ND/EBITDA column itself. Tier badges in five colors. PASS/FAIL flags. Two embedded charts on the right - a horizontal bar chart of leverage by ticker and a scatter showing the debt vs EBITDA position of each name.
4. Inputs. Yellow-cell input panel with data-validation dropdowns for Scenario, Risk Tier, and Leverage Preference. Numeric inputs for portfolio size, max ND/EBITDA threshold, market cap floor, and max position percent. A scenario adjustments table and a risk-tier sizing table sit below for reference.
5. Scenario Analysis. A 5x5 sensitivity grid - rows are EBITDA haircuts from minus 30 percent to plus 20 percent, columns are debt changes from minus 10 percent to plus 20 percent - showing how many of the 25 names still stay below 3.0x leverage under each combination. Green cells = robust cohort even under stress. Five headline scenarios summarized below the grid, with a data-bar visualization of how many names pass each.
6. Strategy. Factor weights table showing how a quantitative leverage-aware strategy would combine Net Debt to EBITDA with Interest Coverage, EBITDA Margin, Market Cap Floor, and an EV/EBITDA penalty. Entry, exit, and rebalancing rules. Optional hedge recommendation.
7. Portfolio. The top 12 cleanest balance sheets ranked by ND/EBITDA, sized into capital allocations based on portfolio size and risk tier. Donut chart visualizes the proposed allocation. Totals row plus a cash-reserve row to track unallocated capital.
8. Sector Heatmap. Aggregates total debt, cash, and EBITDA across each GICS sector before computing the ratio - smoothing through company quirks to surface structural patterns. A horizontal bar chart of sector leverage and a qualitative read on each sector's debt profile. Conditional formatting paints utilities red and tech green.
9. Methodology. A one-page explainer covering what Net Debt to EBITDA actually measures, the formula, tier definitions, universe selection rationale, data sources, scenario mechanics, sector heatmap construction, position sizing logic, and a candid limitations section.
10. Glossary & Disclaimer. Term definitions for every concept used in the workbook, plus an educational-only disclaimer.
Every sheet has a frozen pane, a tab color, a MarketXLS Functions Used reference box at the bottom, and a footer with the MarketXLS site and demo URL. Cover and Dashboard have hidden gridlines for presentation polish.
The MarketXLS implementation - real formulas
The template runs on a small set of verified MarketXLS functions. Every formula below was confirmed via the MarketXLS Function Docs MCP - no invented function names.
Pull total debt:
=TotalDebt("AAPL")
Returns the latest reported total debt in dollars. The template divides by 1,000,000,000 to display in billions.
Pull total cash:
=TotalCash("AAPL")
Returns total cash and equivalents. Same scaling treatment.
Pull EBITDA:
=EBITDA("AAPL")
Trailing twelve-month EBITDA in dollars. Note this is GAAP EBITDA as reported - the screen does not adjust for one-time items.
Compute Net Debt to EBITDA:
=(TotalDebt("AAPL")-TotalCash("AAPL"))/EBITDA("AAPL")
The Dashboard sheet wraps this in IFERROR to handle names with negative or zero EBITDA gracefully.
Tier classification (nested IF):
=IF(J12<0,"Net Cash",IF(J12<1.5,"Conservative",IF(J12<3,"Moderate",IF(J12<5,"Elevated","High"))))
Where J12 holds the computed ratio.
Sector lookup:
=Sector("AAPL")
Returns the GICS sector classification - drives the Sector Heatmap rollup.
Interest coverage cross-check:
=InterestCoverage("AAPL")
Used in the Strategy sheet to layer credit-quality validation on top of the leverage ratio.
Live price for position sizing:
=QM_Last("AAPL")
Drives the Portfolio sheet's share count column.
Market cap floor:
=MarketCapitalization("AAPL")
Filters out names below the user-set market cap threshold.
These eight functions, wired into the workbook structure, produce the entire dashboard.
Reading the screener output
The Dashboard sorts names by Net Debt to EBITDA ascending - so the cleanest balance sheets appear at the top. A few patterns to read:
Tech mega-caps dominate the net-cash tier. Alphabet, Microsoft, Meta, NVIDIA, and Tesla all sit below zero - more cash than debt. This is structural. The technology sector has spent the last decade compounding cash on the balance sheet faster than it could deploy it, even after billions returned to shareholders.
Utilities and large telecoms run structurally hot. NextEra and Duke Energy sit above 5.0x. AT&T and Verizon sit in the 2.9x to 3.2x range. This is not distress - it is the operating model. Regulated utilities and large carriers generate highly predictable cash flow, and capital structure theory says you should lever predictable cash flow. The screen flags these names but the methodology section explains the context.
REITs sit structurally above 5.0x. Prologis and Realty Income carry leverage in the 6x range because the entire industrial REIT business model is built on borrowing against rent contracts. The screen will fail them on the 3.0x threshold by default; users can raise the threshold for a REIT-specific run.
Post-acquisition healthcare overhangs. Pfizer carries elevated leverage from the Seagen integration. Bristol-Myers Squibb sits at moderate-to-elevated from the Celgene deal still working through the balance sheet. These names tell you the acquisition math is now visible in the leverage line.
Energy is surprisingly clean. Exxon and Chevron sit in the Conservative tier despite carrying meaningful absolute debt - the EBITDA cushion is large enough that the ratios stay low. Occidental sits in Moderate, still working off Anadarko transaction debt.
Stress test - what happens if EBITDA shrinks
The Scenario Analysis sheet is the sheet most users underuse. The 5x5 grid answers a specific question: as EBITDA gets hit by recession or tariff impacts, and as debt creeps up from refinancing premiums, how many of the 25 names stay below 3.0x leverage?
The headline scenarios from the template:
| Scenario | EBITDA Change | Debt Change | Names Under 3x | Read |
|---|---|---|---|---|
| Hard Recession | -30% | +15% | About 14 | Mid-tier names slip into Elevated |
| Stress | -15% | +5% | About 17 | Modest slowdown still passes most |
| Base | 0% | 0% | About 19 | Current conditions |
| Soft Landing | +10% | -5% | About 21 | EBITDA growth plus deleveraging |
| Boom | +20% | -10% | About 23 | Almost all names clear comfortably |
The takeaway: the cohort is reasonably resilient. Even under a hard-recession assumption, more than half the universe holds the line. The names that slip in stress scenarios cluster in the healthcare and consumer discretionary buckets where EBITDA volatility is higher.
A useful way to use the grid is to ignore the headline scenarios and look at the corner cells. The bottom-left cell (EBITDA -30 percent, debt +20 percent) shows the absolute worst case. The top-right cell shows the broad-rebound case. Anything in green in the middle of the grid is a name set that survives a wide range of macro outcomes.
Sector heatmap - structural debt patterns
The Sector Heatmap rolls up total debt, total cash, and total EBITDA across each sector before computing the ratio. The picture that emerges:
- Technology: net cash overall. Industry-level ND/EBITDA is below zero.
- Communication Services: split personality. Mega-cap platforms (GOOG, META) sit deep in net cash; legacy telecoms (T, VZ) sit at 2.8x to 3.2x. The aggregate looks moderate because the platform side dominates.
- Consumer Staples: stable EBITDA, moderate leverage around 1.5x. Costco is the bright spot in net cash.
- Energy: strong cash flow keeps the sector in the Conservative tier despite the visual size of their debt stacks.
- Healthcare: post-acquisition overhangs at Pfizer and BMY pull the sector average to roughly Moderate.
- Utilities: structurally High at around 6x. This is the operating model, not a distress signal.
- Consumer Discretionary: ranges widely - Amazon and Home Depot anchor the middle, McDonald's elevated from the franchise model.
- Industrials: mid-tier at around 2x.
Knowing the structural pattern of a sector lets you read individual names more accurately. A utility at 5.0x is normal; a software company at 5.0x is a red flag.
Position sizing - how the Portfolio sheet works
The Portfolio sheet ranks the 12 cleanest balance sheets by Net Debt to EBITDA ascending, then sizes positions based on the user-selected Risk Tier:
- Conservative: 4 percent default weight across 15 names. Broadest spread, lowest concentration.
- Balanced: 6 percent default weight across 12 names. Default setting.
- Aggressive: 10 percent default weight across 8 names. Concentrated bet on top net-cash names.
Position sizes are capped by the Max Position percent input. A donut chart visualizes the proposed allocation. The totals row plus the cash-reserve row let you see at a glance how much capital is deployed versus held in reserve.
This is a long-only construction. The Strategy sheet documents an optional hedge recommendation (short 25 percent notional in HYG, the high-yield ETF) to neutralize spread risk for users who want to isolate the leverage factor.
Limitations - what the screen does not capture
The methodology section in the workbook is candid about what Net Debt to EBITDA does not measure. The most important blind spots:
- Lease liabilities. Post-ASC 842, operating leases sit on the balance sheet as right-of-use assets and corresponding liabilities. The TotalDebt() function may or may not include them depending on the reporter. McDonald's leverage looks moderate on the screen but its capitalized lease obligations push the picture meaningfully higher.
- Pension obligations. Underfunded pensions are a debt-like claim. The screen does not include them.
- Maturity profile. A company at 1.5x with a wall of maturities next year is more fragile than a peer at 3.0x with maturities staggered over a decade. The ratio is silent on this.
- Off-balance-sheet items. Securitizations, joint venture debt, contingent liabilities - none of these flow through the standard EBITDA line.
- Quality of EBITDA. A company growing EBITDA through real operational improvement is different from one growing EBITDA through capitalized R&D, aggressive depreciation policies, or one-time items. The screen treats them identically.
Treat the score as a starting filter, not a credit verdict. Pair it with the Interest Coverage column in the Strategy sheet and a qualitative read on the debt maturity stack before concluding anything about a specific name.
Download the templates
Both files are free for now as a lead magnet. The design quality alone is professional-grade - it would not look out of place on a sell-side desk.
Download the templates:
- - Pre-filled with current data and formula comments on every data cell
- - Live-updating formulas across all 10 sheets
Open the template version with the MarketXLS Excel add-in installed and every leverage number refreshes against the latest fundamentals.
Frequently asked questions
What is a good Net Debt to EBITDA ratio?
Below 3.0x is the conventional dividing line between investment-grade balance sheets and leveraged credit. Below 1.5x is comfortable; below zero (net cash) is a fortress. Above 5.0x is generally high-yield territory unless the company runs a structurally stable cash flow model like a regulated utility or a long-leased REIT.
How is Net Debt different from Total Debt?
Net Debt subtracts cash and equivalents from total debt. A company with $50 billion of debt and $60 billion of cash has minus $10 billion of net debt - meaning it could pay off all its debt and still hold $10 billion in cash. Net Debt is a more accurate read on credit risk because cash on the balance sheet is available to retire debt at the company's discretion.
Why is EBITDA used instead of net income?
EBITDA strips out interest, taxes, depreciation, and amortization - producing a number closer to operating cash flow before capital structure choices. Since leverage analysis is itself about capital structure, using EBITDA avoids the circularity of measuring debt against a profit number that is itself reduced by the interest expense from that debt.
Why are banks excluded from the screen?
Bank balance sheets are dominated by deposits, which are functionally debt but are not measured the same way as corporate debt. Banks are evaluated through capital ratios (Tier 1, CET1) and leverage ratios prescribed by regulators - Net Debt to EBITDA simply does not translate. The screen focuses on non-financial corporates where the ratio is informative.
Can I customize the universe?
Yes. The Dashboard sheet contains the universe as a list of ticker rows. Replace any ticker with one of your own choosing and the live MarketXLS formulas (TotalDebt, TotalCash, EBITDA) will refresh for the new name. Sector classification updates automatically through the Sector() function.
How often should I rerun the screen?
The screen reflects trailing-twelve-month EBITDA and the latest reported balance sheet, so the numbers move at the cadence of quarterly reporting. Running the screen once per earnings season - after the bulk of names have reported - is a reasonable cadence for long-term portfolio monitoring. For active credit work, refresh more often around large M&A or refinancing events.
Does this template require a MarketXLS subscription?
The static (sample) version opens and reads with no add-in - all values are pre-filled with formula references as cell comments. The live (template) version refreshes only when opened with the MarketXLS Excel add-in installed. Visit marketxls.com to learn more or book a demo to see the formulas in action.
The bottom line
A Net Debt to EBITDA screen is the cheapest, fastest credit-quality filter you can run on a public equity portfolio. It is not a substitute for full credit work, but it surfaces the names that should and should not be on a defensive watchlist faster than any other single metric. Paired with a sector heatmap (so you read leverage in context) and a stress matrix (so you know which names are fragile under recession assumptions), it becomes a real decision tool.
The premium template ships all three views in one workbook, with live formulas, dashboard-quality design, and a methodology page that documents what the screen does and does not measure. Download it, drop in your own universe, and you have a leverage dashboard for any basket you care about.
Learn more about MarketXLS at marketxls.com or book a demo to see how the leverage formulas plug into broader workflows.
