Net Debt to EBITDA Screener Excel: Balance Sheet Quality Dashboard for 2026

Net Debt to EBITDA screener Excel - if you came here looking for a presentation-ready spreadsheet that ranks every US large-cap on balance sheet quality, you are in the right place. With the Federal Open Market Committee meeting June 11-12, 2026 and the policy rate expected to stay elevated through year-end, the question advisors and analysts keep asking is simple: which companies can comfortably carry their debt at these rates, and which ones are about to feel the pressure. This guide walks through the Net Debt to EBITDA ratio in depth, shows you how to build the screener in Excel using live MarketXLS formulas, and gives you a free premium template that comes pre-loaded with a 27-name universe, KPI dashboard, sector heatmap, scenario screens, and an interest coverage stress test.

The template is built for advisors, analysts, and serious self-directed investors who want a single workbook that reads like a designed product on first open. Cover page, six KPI tiles across the dashboard, embedded charts, conditional formatting heatmaps on every screener column, data validation dropdowns on the inputs, and a stress test that flags which names break first under +100, +200, and +300 basis point rate shocks. Download the static sample to see exactly what the formulas produce, or grab the live-formula template that updates the moment you click Data > Refresh All.

Key Leverage Snapshot - June 2026

The table below shows representative June 2026 Net Debt / EBITDA ratios across the 27-name universe in the template. Lower is better. Negative values mean the company holds more cash than debt - a fortress balance sheet.

A few quick observations from the snapshot. The mega-cap technology and communication services names dominate the fortress tier - they generate enough cash that their gross debt is more than offset by their treasuries of T-bills and short-term investments. Energy majors look surprisingly strong after a multi-year debt paydown cycle. Telecommunications and parts of consumer staples sit at the higher end of acceptable leverage, while Boeing's near-zero EBITDA pushes the ratio into distressed territory even though the absolute debt is well below telecom peers.

The reason this single ratio captures so much is that it folds three things into one number: how much absolute debt a company carries, how much cash it sits on, and how much annual cash earnings power it generates. Rating agencies use it, leveraged finance desks use it, M&A advisors use it, and corporate treasurers use it. When you screen on Net Debt / EBITDA, you are effectively running a junior version of the same analysis that determines whether a company gets an A credit rating or a B credit rating.

What Net Debt to EBITDA Actually Measures

Net Debt is total interest-bearing debt minus total cash and cash equivalents. EBITDA is earnings before interest, taxes, depreciation, and amortization - a proxy for the cash a business throws off before capital structure decisions enter the picture. Divide one by the other and you get a ratio that reads as "how many years of cash earnings would this company need to fully retire its debt if it stopped paying dividends, stopped buying back stock, and stopped reinvesting in growth."

The intuition is clean. A company at 1x Net Debt / EBITDA could theoretically clear its balance sheet in a single year. A company at 4x would need four years of cash earnings - and if EBITDA fell 30% in a recession, the same 4x ratio would balloon to 5.7x without a dollar of new borrowing. That is the interaction every credit analyst watches. Leverage compounds when earnings compress, and earnings compress when consumers tighten, when commodity prices fall, when interest costs rise, or when capex cycles roll over. The ratio is forward-pointing precisely because it tells you how thick the cushion is before any of those scenarios hit.

There is no universal "safe" threshold because cash flow stability varies by industry. A regulated utility can comfortably sit at 5x because revenue is locked in by rate cases. A semiconductor company at 5x would be in serious trouble because chip demand is famously cyclical. The template handles this through a sector heatmap that lets you see at a glance which sectors structurally carry more leverage, and through scenario screens that you can tune to be more or less strict depending on your tolerance for cyclical risk.

How to Build a Net Debt to EBITDA Screener in Excel

Building this from scratch with MarketXLS takes about ten formulas. Start with a column of tickers and use these functions to pull the inputs you need:

• =TotalDebt("AAPL") returns total debt in dollars
• =TotalCash("AAPL") returns cash and short-term investments in dollars
• =EBITDA("AAPL") returns trailing twelve month EBITDA in dollars
• =Ebitda_Margins("AAPL") returns the EBITDA margin as a decimal
• =InterestCoverage("AAPL") returns EBIT divided by interest expense
• =LeveredFreeCashFlow("AAPL") returns trailing levered free cash flow
• =Revenue("AAPL") returns trailing twelve month revenue

The Net Debt / EBITDA calculation itself is a single cell:

=(TotalDebt("AAPL") - TotalCash("AAPL")) / EBITDA("AAPL")

That cell returns the multiple. You can wrap it in a ROUND or format it as 0.00"x" to display as "1.42x" instead of "1.42." Build a column of these formulas down the screener and you have a live ranking.

For the composite balance sheet score in the template, the formula combines four signals with these weights: 45% Net Debt / EBITDA (the dominant metric), 25% interest coverage, 20% free cash flow / total debt, and 10% EBITDA margin. The scoring is piecewise linear so that a fortress balance sheet (negative net debt) scores 100 on the leverage component, an investment grade name (under 1.5x) scores in the high 70s and low 80s, and a distressed name (above 4.5x) scores in the single digits. You can edit the weights in the Methodology sheet if you want to emphasize coverage or cash flow over the absolute leverage multiple.

For the sector heatmap, group by =Sector("AAPL") and aggregate each metric. Apply Excel's built-in 3-color conditional formatting (Home > Conditional Formatting > Color Scales) to get the red-amber-green heatmap effect. The template uses ColorScaleRule from openpyxl under the hood and inverts the scale on leverage columns so that low ratios show green.

Why June 2026 Is the Moment to Run This Screen

Three things make balance sheet quality matter more right now than at almost any point in the post-2020 cycle. First, the Federal Reserve is widely expected to hold rates in the 4.5% to 4.75% range through the June 11-12 meeting and into the second half of the year. Sticky services inflation and a stable labor market have removed the rate-cut tailwind that propped up leveraged names through 2024. Second, the 2020 and 2021 debt issuance wave - when companies refinanced into multi-year bonds at sub-3% coupons - is starting to come due. Companies that issued five-year paper in 2021 face refinancing in 2026 at materially higher rates. Investment grade refinancing spreads have widened roughly 75 basis points from their 2024 tights. Third, equity markets are pricing for soft-landing perfection, which means valuations leave little room for a leverage-driven earnings miss to be absorbed.

In that environment, a 4x Net Debt / EBITDA company with a refinancing wall in 2027 is a fundamentally different risk than the same company was at 4x in 2021 when rates were near zero. The ratio looks identical but the interest expense after rolling debt could be 40-60% higher. Interest coverage compresses. Free cash flow available for capex, dividends, and buybacks shrinks. If you are an advisor running quality screens or an analyst sizing positions, the leverage ratio plus a forward rate stress test gives you a fuller picture than either metric alone.

The Interest Coverage Stress sheet in the template applies +100, +200, and +300 basis point parallel shocks to a 5% baseline effective rate and recalculates coverage under each scenario. It assumes interest expense scales proportionally with the rate shock (a conservative assumption since most companies have a mix of fixed and floating debt). The result is a per-ticker break point: at what shock level does coverage fall through 2x. Names like AT&T, Verizon, NextEra, and Boeing show up first under the stress because they combine high absolute debt with already-thin coverage. Names like Microsoft, Apple, NVIDIA, and Exxon barely budge.

What's Inside the Template

The premium template ships with twelve sheets. Each one is designed to read like a section of a fund-letter or research note rather than a generic spreadsheet grid.

1. Cover - Branded cover page with title, subtitle, version, "Data as of" date, executive summary description, table of contents, and a marketxls.com footer. Hidden gridlines, navy background, gold accents. This is the first thing the user sees when they open the file.

2. How To Use - Eight-step tutorial covering open in Excel, refresh data, set inputs, read the dashboard, inspect the screener, run scenarios, stress the coverage, and build the portfolio. Includes a function reference table listing every MarketXLS formula used in the workbook with a one-line description.

3. Dashboard - The headline sheet. Six KPI tiles across the top showing average Net Debt / EBITDA, average interest coverage, average EBITDA margin, average FCF / debt, average balance sheet score, and survivor count out of 27. Below the KPI row, a 15-name leaderboard ranks the universe by composite balance sheet score with conditional formatting on every metric column and a credit rating label (Fortress, Investment Grade, Solid, Stretched, Watchlist, Distressed). Bottom of the sheet has a sector summary with an embedded bar chart showing average Net Debt / EBITDA by sector. Hidden gridlines, print area set for landscape printing.

4. Inputs & Controls - All workbook inputs in one place with yellow-highlighted cells, thick navy borders, and data validation dropdowns. Scenario selector, leverage thresholds, portfolio size, weighting method, sector cap, rate shock magnitude, risk tolerance, and three custom tickers for the comparison matrix. Changing one input flows through every other sheet.

5. Leverage Screener - The full 27-name screener with 14 columns: ticker, company, sector, price, market cap, total debt, cash, EBITDA, Net Debt / EBITDA, interest coverage, EBITDA margin, FCF / debt, revenue growth, dividend yield, and composite score. Conditional formatting on every metric column (red-amber-green for ranking, data bars for magnitude). Frozen panes on the first three columns so you can scroll horizontally without losing context.

6. Scenario Analysis - Seven preset leverage threshold combinations: Fortress Balance Sheet, Investment Grade, Solid (Default), Moderate Leverage, Stretched, Income Tilt (yield over 3%), and Cash-Rich Only. Each row shows the thresholds, survivor count, survival rate, and average score for the names that pass. Below the summary, a pass / fail matrix shows every ticker against every scenario with green / red flags.

7. Sector Heatmap - Sector-level averages with red-amber-green conditional formatting. Lets you see at a glance whether technology is structurally less levered than utilities, where the FCF / debt strength sits, and which sectors are carrying the most rate sensitivity into the FOMC meeting.

8. Interest Coverage Stress - The rate shock sheet. For every ticker, shows current interest coverage and stressed coverage at +100, +200, and +300 basis point parallel rate shocks. Identifies a per-ticker break point and assigns a risk flag (LOW, MODERATE, ELEVATED, HIGH) based on where coverage falls through 2x. Color-coded so high-risk names stand out immediately.

9. Portfolio Allocation - Position sizing for the qualifying universe under the Solid (Default) scenario. Shows equal-weight, score-weighted, and cap-weighted dollar allocations from a configurable portfolio size. Includes a pie chart of the score-weighted allocation so you can see concentration visually.

10. Comparison Matrix - Side-by-side comparison of three custom tickers (default: AAPL, MSFT, T) across 17 metrics with row-by-row conditional formatting that highlights the best name on each metric. Edit the custom tickers in the Inputs sheet and the comparison updates instantly.

11. Methodology - Eleven sections covering why Net Debt to EBITDA matters, the calculation, how to read the scale, universe definition, composite score formula, credit rating labels, the June 2026 macro context, scenario thresholds, data sources, the stress test design, limitations, and the not-investment-advice disclaimer. This is the section that gives the template fund-letter credibility - any analyst or advisor receiving this file can read the methodology and verify the construction.

12. Glossary & Disclaimer - 21 term definitions covering Net Debt, EBITDA, the leverage ratio, interest coverage, EBITDA margin, free cash flow, debt-to-equity, investment grade, high yield, fortress balance sheet, watchlist, refinancing wall, rate shock, composite score, rating label, survival rate, allocation methods, and sector cap. Plus a prominent educational disclaimer.

Walking Through the Dashboard

Open the workbook and you land on the Cover sheet first. Click the Dashboard tab and the first thing you see is a six-tile KPI row across the top. The tiles use 22-point bold numbers in MarketXLS navy with 9-point gray uppercase labels above and a small italic "delta" hint below. Alternating tile backgrounds in white and light gray create the dashboard feel without crowding the eye.

The first tile shows the universe average Net Debt / EBITDA. The label below reads "Lower = stronger" in amber italic. The second tile shows average interest coverage with a green "Higher = stronger" hint. The next four cover EBITDA margin, FCF / debt, balance sheet score, and survivor count. Together they tell you the shape of the universe at a glance: is this a healthy market for low-leverage screens, or has the median company crept up the leverage curve.

Below the KPI row, the leaderboard. The 15 highest-scoring names appear in rank order with their key metrics. Every numeric column has a conditional format rule. The Net Debt / EBITDA column inverts the usual scale: low values show green, high values show red. The interest coverage column does the opposite. The score column shows a data bar so you can see the relative strength at a glance. The YTD return column uses a diverging color scale centered on zero so up names show green and down names show red.

Below the leaderboard, a sector summary table aggregates every metric to the sector level, sorted by average Net Debt / EBITDA. An embedded bar chart visualizes the same data so you can see which sectors carry the most leverage. Technology and communication services typically sit at the low end, while utilities, telecommunications, and parts of consumer staples cluster at the higher end. The chart updates automatically when the underlying numbers change.

Print area is set on the Dashboard sheet so you can print the whole thing on a single landscape page if you want to drop it into a client meeting binder.

Running the Scenario Screens

Scenarios are where the template earns its keep for advisor workflows. The default screen (Solid) requires Net Debt / EBITDA under 2.5x, interest coverage above 8x, FCF / debt above 20%, and EBITDA margin above 12%. That combination typically passes around two-thirds of the universe in a healthy market. Tighten the screen to Fortress Balance Sheet (under 0.5x, coverage above 20x) and the survivors shrink to a handful of mega-cap technology and energy names. Open it up to Stretched (under 4.5x, coverage above 3x) and almost everything passes - which itself is informative because it tells you the market is not yet in a leverage panic.

The Income Tilt scenario adds a 3% dividend yield floor on top of moderate leverage thresholds. This is the screen advisors use when they want a high-quality income sleeve - companies that pay a real yield but are not stretching the balance sheet to fund it. AT&T, Verizon, and AbbVie often pass this screen even though they carry above-average leverage, because their dividend cushion is comfortably covered by free cash flow.

The Cash-Rich Only scenario filters to companies with negative net debt. In June 2026 this is a short list: Alphabet, Meta, NVIDIA, Microsoft, Apple, Costco, Exxon Mobil, and a small handful of others. These are the names that benefit from higher rates because their interest income on cash holdings rises while their borrowing costs remain capped.

The pass / fail matrix below the scenario summary is a useful visualization. Names that show green across multiple scenarios are robust - they survive even strict screens. Names that show green only on the loosest screens are signaling balance sheet strain.

Using the Interest Coverage Stress Test

The stress test is the sheet that gives this template a credit-analyst edge over a typical valuation screener. The methodology is simple: assume an effective interest rate of 5% on outstanding debt, then re-price the debt at +100, +200, and +300 basis points. Interest expense scales with the rate shock. New coverage = EBITDA / new interest expense.

Three names that show the value of the stress immediately. Apple's coverage at 38x today barely moves under any shock - it could refinance at 10% and still cover interest more than ten times over. AT&T's coverage at 4.8x today falls to roughly 3.5x at +200 bps and 3.0x at +300 bps. Still above the 2x covenant threshold but the cushion is shrinking. Boeing's coverage at 0.5x falls into negative territory under any meaningful shock - the company already does not generate enough EBIT to cover interest, and any incremental rate pressure makes the math worse.

The risk flag column translates the stressed numbers into plain English: LOW, MODERATE, ELEVATED, or HIGH. Use this as a quick first-pass filter when you are looking at a 20-name watchlist and need to identify which ones to research further.

A word on the stress assumptions. The 5% baseline is a round-number approximation; in practice every company has a different effective rate driven by their existing debt mix. The +300 bps shock is meant to represent a worst-case parallel shift, not a base-case forecast. And the calculation assumes 100% of debt re-prices, which is conservative since most large-caps have a mix of fixed and floating debt with staggered maturities. Treat the stress as a directional indicator of relative vulnerability, not a precise dollar forecast.

Customizing the Inputs

Every input lives on the Inputs & Controls sheet with a yellow cell, thick navy border, and data validation dropdown where applicable. The Scenario dropdown lets you pick from seven preset combinations. The leverage thresholds (Max Net Debt / EBITDA, Min Interest Coverage, Min FCF / Debt, Min EBITDA Margin) are editable directly if you want a custom screen. Portfolio Size flows into the Portfolio Allocation sheet and changes every dollar amount in real time. Weighting Method selects between equal-weight, score-weighted, and cap-weighted sleeves. Sector Cap limits any one sector to a maximum portfolio weight. Rate Shock changes the stress sheet calculations.

Three custom ticker slots feed the Comparison Matrix. Drop in any three tickers and the entire metric grid updates with live values. This is the workflow for ad-hoc analysis: an advisor says "compare AAPL, MSFT, and KO on balance sheet quality" and you swap the three tickers in C16, C17, C18 and the comparison sheet rebuilds itself.

The Benchmark Index input lets you compare the universe against SPY, IVV, VOO, QQQ, or IWB. The template does not yet automate the benchmark comparison but the field is wired for future expansion.

FAQ - Net Debt to EBITDA Screener Excel

What is a good Net Debt to EBITDA ratio?

There is no universal "good" threshold because cash flow stability varies dramatically by industry. As a rough guide, under 1x is fortress territory, 1x to 2.5x is solid investment grade, 2.5x to 4x is acceptable but stretched, and above 4x is leveraged. Utilities and telecoms can comfortably sit at 4-5x because revenue is stable. Cyclical industrials and semiconductors should ideally stay under 2x because earnings compress sharply in downturns. The sector heatmap in the template shows you what's "normal" for each industry so you can calibrate your thresholds.

How is Net Debt to EBITDA different from Debt to Equity?

Debt to Equity uses balance sheet accounting values for both numerator and denominator. Net Debt to EBITDA uses a debt value net of cash on top, and a cash earnings value on the bottom. The Debt to Equity ratio can be distorted by share buybacks (which reduce equity), goodwill writedowns, and accounting conventions. Net Debt to EBITDA is closer to how credit analysts and rating agencies actually think about leverage because it ties debt to the cash earnings that service it. Both ratios appear in the template, but Net Debt to EBITDA is the primary screen.

Does the template work with the free version of Excel?

The static sample workbook opens in any version of Excel from 2016 onward, including Excel on the Web. All formula references are visible as comments on each data cell so you can see exactly what would generate each value. The live-formula template requires the MarketXLS add-in to be installed and active so that the TotalDebt, EBITDA, InterestCoverage, and other functions can refresh. Visit marketxls.com to learn about the platform and request a demo at marketxls.com/book-demo.

Why are banks and insurers excluded from the universe?

Net Debt to EBITDA is not a meaningful leverage metric for financial issuers. Banks intermediate debt - their balance sheets are structurally levered in a way that the EBITDA framework cannot capture. Capital adequacy ratios (Common Equity Tier 1), leverage ratio (Tier 1 capital / total exposure), and Liquidity Coverage Ratio are the appropriate metrics. For insurers, RBC ratios and combined ratios apply. The template covers 27 non-financial corporates across the remaining nine GICS sectors and one Utilities name. For bank leverage analysis, use a dedicated bank screener that focuses on CET1 and net interest margin.

Can I add my own tickers to the screener?

The static template ships with a 27-name preset universe. To add tickers, edit the UNIVERSE list in the build script and rerun, or insert rows in the Leverage Screener sheet and replicate the formula pattern from any existing row. Every formula references the ticker symbol in column B of the same row, so duplicating the pattern is a quick copy-paste operation. The Comparison Matrix sheet also lets you compare three arbitrary tickers without editing the underlying universe.

How often should I refresh the data?

Balance sheet metrics update quarterly with each company's 10-Q or 10-K filing, so the underlying inputs do not change daily. Price-driven fields (market cap, YTD return) update intra-day. For most workflows, a refresh once a week is sufficient. During earnings season (mid-July through mid-August for Q2 2026), refresh after each company in the universe reports to capture the latest TTM ratios.

What's the difference between EBITDA and adjusted EBITDA?

EBITDA in the template uses the GAAP EBITDA reported in the cash flow statement. Adjusted EBITDA is a non-GAAP metric where management adds back stock-based compensation, restructuring charges, M&A expenses, and other "non-recurring" items. Management adjusted EBITDA almost always looks better than GAAP EBITDA. For a leverage screen, GAAP EBITDA is the more honest input because that's the cash that actually services debt. The MarketXLS EBITDA() function returns the GAAP value.

Is this template appropriate for high-yield credit analysis?

The framework is the same but the thresholds shift. High yield analysts typically focus on Net Debt / EBITDA above 4x where this template flags names as Distressed. They also pay much more attention to FCF / debt because the absolute size of free cash flow relative to a thin equity cushion determines refinancing risk. The template handles high yield names within its universe (Boeing, NextEra, AT&T) but a dedicated HY workbook would include covenant analysis, maturity walls, and recovery rate estimates. Treat this template as a quality screen with a high-yield flagging layer, not a stand-alone HY workflow.

The Bottom Line

Net Debt to EBITDA is the single most efficient way to compare balance sheet quality across companies in different sectors and at different scales. In an elevated-rate environment heading into Q2 2026 earnings, it deserves a permanent spot in every quality-focused screener. The premium template ships with a designed dashboard, scenario flexibility, sector context, and a rate-shock stress test so you can move from screening to decision-making inside a single workbook.

Download the static sample to see the design and check the formula references on every cell, or grab the live-formula template if you have MarketXLS installed and want the data to refresh in real time. Both files are free.

Download the templates:

• - Pre-filled with representative June 2026 values, formula comments on every data cell
• - Live formulas, refreshes the moment you click Data > Refresh All

Want to see what else MarketXLS can do for credit and quality analysis? Browse the platform at marketxls.com or book a one-on-one walkthrough at marketxls.com/book-demo. For related screens, see our Free Cash Flow Yield Dashboard, Altman Z-Score Screener, and Buffett Indicator Dashboard.

This template is educational only. Nothing in this workbook constitutes financial, investment, tax, or legal advice. Always consult a qualified financial advisor before making investment decisions.