Interest Coverage Ratio Screener Excel: Debt Risk Watchlist for May 2026

Interest coverage ratio screener excel - if that is what brought you here, this guide is for you. With Treasury yields still elevated through May 2026 and a wall of corporate debt rolling in 2026 and 2027, the question every advisor and self-directed investor is asking is simple: which companies in my watchlist might struggle to service their interest bill if rates do not come down quickly? An interest coverage ratio screener built in Excel is the cleanest way to answer that. It ranks names by Interest Coverage Ratio (ICR), flags borderline cases, stress-tests them against EBIT haircuts and rate shocks, and bubbles up the ones worth a closer look.

This post shows what the screener does, why it matters in the current rate environment, the exact MarketXLS formulas that power it, and a downloadable Excel template you can plug your portfolio into.

Why interest coverage ratio matters in May 2026

Interest coverage ratio is the cleanest single number for measuring how easily a company can pay the interest on its outstanding debt. The formula is straightforward:

“

Interest Coverage Ratio = EBIT / Interest Expense

A reading of 5.0x means a company earns five times its annual interest bill before interest and taxes. A reading below 1.5x means there is very little cushion between operating earnings and the interest the company owes.

Why is this relevant right now? Three reasons:

1. Higher rates flow through with a lag. Most large-cap balance sheets are still rotating from 3 percent coupons to 6 percent and higher coupons as old bonds mature.
2. The Q1 2026 earnings cycle has slowed. Top-line growth is mid-single-digits across the S&P 500 ex-Mag-7, and consensus EBIT growth for many cyclicals has rolled over.
3. A meaningful slice of the high yield market matures in 2026 and 2027. Companies that issued at low coupons during 2020 and 2021 now face refinancing at meaningfully higher rates.

Put together, the spread between cash earnings and cash interest is compressing. That is exactly the environment where an interest coverage ratio screener excel template earns its keep.

Interest coverage ratio screener excel - quick reference table

The screener uses the following risk buckets. Anything below 1.5x belongs on a watchlist; below 1.0x is a warning that operating profit is not currently covering interest at all.

These bands are not absolute. Cyclicals can recover from sub-1.0x readings; capital-intensive utilities and pipelines can run safely on lower ICRs because of long, contracted cash flows. The buckets are a starting point for the screener, not an automatic decision.

What the interest coverage ratio screener excel template does

The downloadable template has six sheets:

1. How To Use - tutorial and a list of every MarketXLS function used.
2. Main Dashboard - input cells for portfolio size, minimum acceptable ICR, and stress assumptions, plus a 25-stock watchlist that ranks names by ICR with a 0-100 risk score.
3. Scenario Analysis - stress-test the watchlist with an EBIT haircut and a rate-shock in basis points. The sheet recomputes ICR under stress and tags Pass/Fail vs the dashboard threshold.
4. Strategy & Watchlist - the watchlist is split into Low-Risk (ICR >= 5) and High-Risk (ICR < 3) buckets so you can see at a glance which names are foundation-quality and which need monitoring.
5. Portfolio Allocation - inverse-risk-weighted position sizes computed from your input portfolio dollar amount.
6. Sector Heatmap - average ICR and average Net Debt / EBITDA per sector, with a color scale.

Yellow cells are inputs, blue cells are headers, and every sheet includes a "MarketXLS Functions Used" reference box at the bottom.

How to build an interest coverage ratio screener excel from scratch

The template ships ready to go, but if you want to understand each line, here is how the screener is wired together using MarketXLS functions.

Step 1: Pull live ICR for any ticker

The simplest way is the dedicated formula:

=INTERESTCOVERAGE("AAPL")

This returns the trailing twelve-month interest coverage ratio for any ticker. If you want to compute it yourself, the building blocks are:

=HF_EBIT("AAPL", , , TRUE)              -> trailing twelve month EBIT
=HF_INTEREST_EXPENSE("AAPL", , , TRUE)  -> trailing twelve month interest expense

So the manual ICR formula is:

=HF_EBIT(A2, , , TRUE) / HF_INTEREST_EXPENSE(A2, , , TRUE)

Step 2: Pull total debt and EBITDA for the leverage check

Net Debt / EBITDA is the second leg of debt risk. Total debt and EBITDA come from:

=TOTALDEBT("AAPL")                    -> total debt (short + long term)
=HF_EBITDA("AAPL", , , TRUE)          -> trailing twelve month EBITDA
=HF_CASH_AND_EQUIVALENTS("AAPL", , , TRUE) -> cash for net-debt

Net Debt / EBITDA in one cell:

=(TOTALDEBT(A2) - HF_CASH_AND_EQUIVALENTS(A2,,,TRUE)) / HF_EBITDA(A2,,,TRUE)

Step 3: Layer in cash flow coverage as a sanity check

EBIT can be flattering when there are large non-cash items. The screener also uses free cash flow as a coverage backup:

=HF_FREE_CASH_FLOW("AAPL", , , TRUE)
=LEVEREDFREECASHFLOW("AAPL")
=OPERATINGCASHFLOW("AAPL")

If FCF / Interest Expense and EBIT / Interest Expense both look weak, that is a stronger warning than either signal alone.

Step 4: Tag the risk bucket with a nested IF

Inside the dashboard, the bucket label is a single nested IF:

=IF(G2<1,"Distress",IF(G2<1.5,"Weak",IF(G2<3,"Moderate",IF(G2<5,"Healthy","Very strong"))))

The 0-100 risk score makes a heatmap easy:

=MAX(0, MIN(100, ROUND(100 - (G2 * 10), 0)))

Lower ICR pushes the score higher (more risk).

Step 5: Stress-test the screener

The Scenario Analysis sheet asks two questions:

1. What if EBIT falls? For each name, recompute stressed EBIT as Base EBIT * (1 - haircut).
2. What if rates rise? Add Total Debt * rate shock (bps) / 10000 to interest expense.

Stressed ICR is then Stressed EBIT / Stressed Interest Expense. The Pass/Fail column compares it against the minimum acceptable ICR you set on the dashboard.

A worked example: stress-testing the watchlist

The default watchlist in the template includes 25 large-cap names spanning automakers, telecom, airlines, retailers, and tech. With a 20 percent EBIT haircut and a 200 basis point rate shock, the screener typically separates the universe into three patterns:

• High-leverage cyclicals (autos, airlines, cruise lines): often start with ICR in the 1-3x range and fall through 1.0x under stress. These are the names where refinancing risk is real if the macro picture deteriorates.
• Telecom and large media (T, VZ, CMCSA): start in the 3-5x range and remain above 2x under stress because of stable subscription cash flows.
• Quality compounders (AAPL, MSFT, WMT, HD): often have ICR above 10x and remain comfortably above the threshold even under heavy stress, because their interest expense is small relative to their EBIT.

Run your own portfolio through the screener and you will see the same pattern: ICR is a useful filter, not because it identifies "bad" companies, but because it separates the watchlist into "I do not need to think about debt risk for this name" and "this is a name where the next earnings print matters a lot."

Why this is hard to do without a screener

The data points exist on every company's 10-Q and 10-K, but stitching them together for 25 or 50 tickers, refreshing each quarter, and running stress scenarios is the kind of work where Excel formulas beat manual research:

• Quarterly refresh. ICR changes every 90 days when each company files. With live formulas, opening the workbook is the refresh.
• Cross-sectional comparison. The Sector Heatmap turns 25 individual numbers into a single picture of which sectors carry the most refinancing risk.
• Scenario analysis. Computing what happens to ICR under a 100 bps or 200 bps rate shock for 25 names by hand takes hours. With formulas it is a single yellow input cell.

This is exactly the gap that MarketXLS closes for advisors and self-directed investors. The full library of MarketXLS functions covers fundamentals, technical indicators, options data, and live prices, so a screener like this can be assembled in an afternoon and updated forever.

The interest coverage ratio screener excel template - what is inside

Each sheet has been designed around the First Word framework: the Main Dashboard is the action sheet, and every other sheet either feeds into it or expands on a single dimension.

Main Dashboard

Twelve columns: Ticker, Company, Sector, Price, EBIT, Interest Expense, ICR, Total Debt, Net Debt / EBITDA, FCF, Risk Bucket, and Risk Score. Yellow cells at the top hold:

• Portfolio Size (default $100,000)
• Min Acceptable ICR (default 3.0x)
• Max Net Debt / EBITDA (default 3.0x)
• Risk Tolerance (1-5)
• EBIT Stress Haircut (default 20 percent)

Color scales on ICR and Risk Score make the table readable at a glance.

Scenario Analysis

A 10-stock subset focused on the most levered names. Two yellow cells: EBIT haircut (linked to dashboard) and rate shock in basis points (default 200 bps). For each name the sheet recomputes stressed EBIT and stressed interest expense, then grades the new ICR against your minimum threshold.

Strategy & Watchlist

Splits the universe into Low-Risk (ICR >= 5) and High-Risk (ICR < 3). The Low-Risk bucket is your foundation-quality pool. The High-Risk bucket is the watchlist. Each row carries a one-line idea so you can tell at a glance whether a name is a "core" candidate or a "monitor" candidate.

Portfolio Allocation

Risk-weighted position sizing using ICR as the weight (higher ICR -> larger position) on the Low-Risk plus Healthy buckets. Inputs are pulled directly from the Main Dashboard so changing portfolio size flows through automatically.

Sector Heatmap

Average ICR, min ICR, max ICR, and average Net Debt / EBITDA per sector. Two color scales (one on ICR, one on Net Debt / EBITDA) and a Risk Tier column make this a quick way to compare sector debt risk in a single screen.

MarketXLS formulas used across the workbook

The screener is built entirely from documented MarketXLS functions. The complete list:

Each formula is referenced in a "MarketXLS Functions Used" box at the bottom of the sheet that uses it, so users always know which function powered which column.

Who should use this template

• Independent financial advisors running due diligence on client holdings and wanting a single Excel-native view of debt risk.
• Self-directed investors building dividend or quality-factor portfolios who want to avoid blow-ups in cyclical names.
• Equity analysts who need a fast first-pass screen before doing deeper credit work.
• Portfolio managers monitoring a watchlist and looking for stress-test capability that does not require a Bloomberg terminal.

If your workflow currently involves copying ICR numbers from filings into a spreadsheet by hand, a live MarketXLS-powered screener will save hours every quarter and dramatically reduce the chance of stale data.

Download the templates:

• - pre-filled with current data and a "Data as of" date
• - live-updating formulas, plug in your own tickers

To run the formula version you need MarketXLS installed in Excel. See MarketXLS and book a demo if you want a walkthrough.

Frequently asked questions

What is a good interest coverage ratio?

For most non-financial S&P 500 companies, an ICR above 5.0x is considered very strong, 3.0x to 5.0x is healthy, and below 1.5x is a yellow flag. Capital-intensive sectors such as utilities, REITs and pipelines can operate safely on lower ICRs because of stable, contracted cash flows. The right benchmark depends on the sector and the predictability of the cash flows.

Why use EBIT instead of EBITDA in the interest coverage ratio?

EBIT is the more conservative numerator because it deducts depreciation and amortization, which are non-cash but still reflect the cost of replacing capital assets over time. Some analysts also compute EBITDA / Interest Expense as a complementary measure. The screener template includes both EBIT-based ICR and the building blocks (HF_EBITDA) so you can compare.

How is interest coverage ratio different from net debt to EBITDA?

ICR measures whether a company earns enough to pay this year's interest. Net Debt / EBITDA measures how many years of EBITDA it would take to repay the debt outright. ICR is a coverage measure; Net Debt / EBITDA is a leverage measure. Both belong on the same dashboard - a company can have a healthy ICR today but unsustainable leverage if rates rise materially when debt rolls.

How often should I update the screener?

The live version refreshes whenever the workbook recalculates, so opening the file is effectively the update. Most fundamentals data refreshes on filing dates (every 90 days for most US companies). Prices update on every recalc. A monthly review is usually enough; a deeper review around earnings season is sensible.

Can I add my own tickers to the screener?

Yes. The watchlist on the Main Dashboard is just a list of tickers in column A. Replace any ticker with one of your own and every formula in the row will recompute. The Strategy and Allocation sheets pull from the same column, so a single edit flows everywhere.

Why are some ICR values negative or blank in the screener?

Negative ICR usually means EBIT is negative (the company posted an operating loss in the trailing twelve months). Blanks usually mean MarketXLS does not have a reliable interest expense line for that ticker (often the case for some financials, where interest expense is a cost of doing business rather than a leverage signal). The IFERROR wrappers in the template handle these cases gracefully.

Is this template financial advice?

No. The screener is an educational tool for understanding which names in a watchlist face the most refinancing pressure under stress. It does not constitute investment, legal or tax advice and should not be used as the sole basis for any trading decision. Always do your own research and consult a licensed financial professional.

The bottom line

An interest coverage ratio screener excel template is one of the highest-value tools an advisor or self-directed investor can keep open during a higher-for-longer rate cycle. It turns a single number from a 10-Q footnote into a live dashboard that ranks the watchlist, stress-tests rate shocks and EBIT haircuts, and flags the names that need a closer read before the next earnings print.

The downloadable template ships with 25 default tickers, but the real value is plugging in your own portfolio. Five minutes of setup pays back forever in faster, cleaner debt-risk monitoring.

If you want to see the full breadth of what is possible when Excel meets professional-grade market data, head to marketxls.com or book a demo to walk through the screener with the team.