Interest Rate Sensitive Stocks Screener: How to Identify and Analyze Rate-Exposed Equities in Excel

Interest rate sensitive stocks screener tools have become essential for investors navigating the current Federal Reserve rate environment. With the Fed holding rates steady at 3.5–3.75% at the March 2026 FOMC meeting, citing persistent inflation concerns and geopolitical uncertainty from the Iran conflict, understanding which equities carry the most rate exposure is no longer optional — it is a core portfolio management requirement. Whether you manage a personal portfolio or advise clients, having a systematic, data-driven way to identify, score, and monitor rate-sensitive stocks in Excel can give you a meaningful edge.

In this guide, we walk through the methodology behind building an interest rate sensitive stocks screener, explain which financial metrics matter most, and show you how to construct a live, formula-driven screening tool using MarketXLS directly inside Microsoft Excel.

Rate Sensitivity by Sector: A Quick Comparison

Before diving into the screener methodology, here is a high-level overview of how major equity sectors respond to interest rate changes:

This table makes an important point: rate sensitivity is not uniform. The same Fed decision can be a tailwind for one sector and a headwind for another. A screener that quantifies this difference across individual stocks — not just sectors — is far more actionable.

Understanding What Makes a Stock Rate-Sensitive

Three fundamental characteristics determine how much a stock's valuation will move in response to interest rate changes:

1. Leverage (Debt-to-Equity Ratio)

Companies with high debt-to-equity ratios are directly exposed to interest rate changes. When rates rise, the cost of refinancing existing debt increases, which compresses margins and reduces free cash flow. Utilities and REITs typically carry D/E ratios above 1.5, making them structurally more rate-sensitive than technology companies that often operate with net cash positions.

The MarketXLS formula for this metric is:

=hf_Debt_to_Equity_Ratio("NEE", 2025, 4)

This pulls the most recent quarterly debt-to-equity ratio for NextEra Energy, one of the largest utility holding companies.

2. Interest Coverage Ratio

The interest coverage ratio measures how many times a company can cover its interest expense with operating income. A low ratio (below 3.0) signals that the company is already stretching to service its debt — any rate increase magnifies the problem. A high ratio (above 8.0) suggests the company can absorb rate changes without material impact on profitability.

=InterestCoverage("DUK")

Duke Energy, for example, typically carries an interest coverage ratio between 3.0 and 4.0, placing it in the moderately vulnerable category.

3. Dividend Yield as a Bond Proxy

High-dividend stocks compete directly with bonds for income-oriented capital. When interest rates rise, risk-free yields become more attractive, and investors rotate out of dividend stocks. This "bond proxy" effect is strongest in utilities, REITs, and telecom. A stock yielding 5% becomes less appealing when a 10-year Treasury yields 4.5% with zero credit risk.

=DividendYield("O")

Realty Income (O), often called "The Monthly Dividend Company," yields above 5%, making it one of the most rate-sensitive names in the REIT universe.

The Beta Factor

Beta measures a stock's volatility relative to the broader market, but it also serves as a proxy for how aggressively a stock moves in response to macro events, including rate decisions. Low-beta utilities (0.3–0.5) tend to move gradually but persistently in response to rate expectations, while high-beta financials (1.1–1.4) can swing sharply on FOMC announcement days.

=Beta("JPM")

JPMorgan Chase typically carries a beta above 1.1, reflecting its sensitivity to both rate expectations and broader economic conditions.

The Screener Methodology: Building a Rate Sensitivity Score

A useful screener does not just display raw data — it synthesizes multiple metrics into a single, comparable score. Our rate sensitivity score combines three components with the following weights:

Rate Sensitivity Score = Beta Component (30%) + Leverage Component (40%) + Coverage Component (30%)

Where:

• Beta Component = MIN(Beta / 1.5, 1.0) × 30
• Leverage Component = MIN(D/E Ratio / 3.0, 1.0) × 40
• Coverage Component = MAX(0, (1 − Interest Coverage / 10)) × 30

This produces a score between 0 and 100, where higher scores indicate greater rate sensitivity. The weighting prioritizes leverage because debt levels are the most direct transmission mechanism from rates to fundamentals.

In Excel, the formula for a stock in row 5 with Beta in column D, D/E in column E, and Interest Coverage in column F would be:

=MIN(D5/1.5,1)*30 + MIN(E5/3,1)*40 + MAX(0,(1-F5/10))*30

Interpreting the Score

Building the Screener in Excel with MarketXLS

The real power of this approach is automation. Instead of manually looking up metrics for each ticker, you can use MarketXLS formulas to pull live data directly into your spreadsheet. Here is a step-by-step walkthrough of constructing the screener.

Step 1: Set Up Your Ticker List

In column A, list the tickers you want to screen. For a comprehensive rate sensitivity analysis, include representatives from each major sensitive sector:

• Utilities: XLU, NEE, DUK, SO
• Financials: XLF, JPM, BAC, GS
• REITs: AMT, O, PLD
• Telecom: VZ, T
• Technology (comparison): AAPL

Step 2: Pull Sector and Price Data

In column B, use the Sector function to auto-classify each ticker:

=Sector("NEE")

In column C, pull the current price:

=Last("NEE")

The Last function returns the most recent closing price for any ticker supported by MarketXLS, including ETFs like XLU and XLF.

Step 3: Pull Rate Sensitivity Metrics

Across columns D through I, add the key metrics:

Step 4: Calculate the Rate Sensitivity Score

In column J, apply the composite scoring formula:

=MIN(D5/1.5,1)*30 + MIN(E5/3,1)*40 + MAX(0,(1-F5/10))*30

Step 5: Add Scenario Inputs

Create a yellow input cell at the top of the sheet where you can enter a rate change scenario in basis points (e.g., +50 or -50). Then calculate estimated price impacts using a duration-based approximation:

Estimated Impact = Current Price × (1 − Beta × Duration_Approx × Rate_Change / 10000)

Where Duration_Approx is set to 5 as a reasonable estimate for equity duration. This gives a rough but useful directional view of how each stock might respond to a hypothetical rate move.

Step 6: Sort and Filter

Sort by the Rate Sensitivity Score in descending order to see the most rate-exposed stocks first. You can also use Excel's built-in filtering to isolate specific sectors or score ranges.

Scenario Analysis: Modeling Rate Change Impacts

The Scenario Analysis sheet extends the screener by showing estimated price impacts across five standardized rate scenarios:

For each ticker, the estimated new price under each scenario is calculated as:

=Last("TICKER") * (1 - Beta("TICKER") * 5 * RATE_CHANGE / 10000)

This is a simplified model — real-world price reactions depend on many additional factors including market expectations, forward guidance, and earnings revisions. However, it provides a useful framework for comparing relative sensitivity across your watchlist.

For example, a stock like NextEra Energy (NEE) with a beta of approximately 0.52 would see roughly a 2.6% price decline in a +100 bps scenario, while Goldman Sachs (GS) with a beta of approximately 1.42 would see a roughly 7.1% decline — nearly three times the impact.

The Template: Six Sheets for Complete Rate Sensitivity Analysis

The downloadable Excel template includes six purpose-built sheets:

Sheet 1: How To Use

An orientation guide explaining each sheet, the formulas used, and links to MarketXLS and the demo booking page. Start here if you are new to MarketXLS or want to understand the template structure.

Sheet 2: Rate Sensitivity Dashboard

The core screening sheet. Contains 14 tickers across five sectors with live formulas for price, beta, debt-to-equity ratio, interest coverage, dividend yield, P/E ratio, and current ratio. The Rate Sensitivity Score is calculated automatically for each ticker. A yellow input cell at the top allows you to enter a rate change scenario in basis points.

Key formulas on this sheet:

• =Last("TICKER") for current price
• =Beta("TICKER") for market beta
• =hf_Debt_to_Equity_Ratio("TICKER", 2025, 4) for leverage
• =InterestCoverage("TICKER") for debt coverage
• =DividendYield("TICKER") for yield
• =PERatio("TICKER") for valuation
• =current_ratio("TICKER") for liquidity

Sheet 3: Scenario Analysis

Models the estimated price impact of five rate scenarios (−100 bps through +100 bps) for all 14 tickers. Uses the beta-based duration approximation described above. This sheet helps you quickly visualize which stocks have the most to gain or lose from potential Fed actions.

Sheet 4: Sector Strategy

A qualitative analysis of how each sector responds to different rate environments. Covers utilities, financials, REITs, telecom, and technology with specific commentary on rate hold, rate cut, and rate hike scenarios. This sheet is educational — it provides context for interpreting the quantitative scores on the Dashboard sheet.

Sheet 5: Portfolio Allocation

A position sizing calculator with three yellow input cells: portfolio size, risk tolerance (1–10 scale), and maximum single-position percentage. The sheet automatically calculates suggested weights, dollar amounts, and share counts for each ticker based on your inputs. Uses =Last("TICKER") to calculate share quantities at current prices.

Sheet 6: Correlation Matrix

A color-coded correlation matrix showing the approximate relationship between utilities, financials, REITs, telecom, and technology sectors. Green cells indicate low correlation (below 0.4), orange indicates moderate correlation (0.4–0.7), and red indicates high correlation (above 0.7). Key insight: utilities and REITs are highly correlated at approximately 0.72, meaning they tend to move together in response to rate changes and offer limited diversification benefit when combined.

Download the Templates

Two versions are available:

Sample File (Static Data): Pre-populated with representative data as of March 19, 2026. Use this to explore the template structure and methodology without needing MarketXLS installed.

Live Template (MarketXLS Formulas): All data cells contain live MarketXLS formulas that update automatically. Requires an active MarketXLS subscription.

To get started with MarketXLS, visit marketxls.com or book a demo to see the add-in in action. You can also review pricing options to find the plan that fits your workflow.

Additional MarketXLS Formulas for Extended Analysis

Beyond the core screening metrics, MarketXLS offers several additional formulas that can enhance your rate sensitivity analysis:

• =MarketCapitalization("TICKER") — Useful for size-based filtering. Large-cap stocks often respond differently to rate changes than small-caps.
• =Revenue("TICKER") — Revenue trends can indicate whether a company is growing through a rate headwind.
• =EarningsPerShare("TICKER") — Earnings per share help validate whether rate sensitivity is flowing through to the bottom line.
• =CashFlowPerShare("TICKER") — Cash flow durability is critical for highly leveraged, rate-sensitive companies.
• =hf_Long_term_debt("TICKER", 2025, 4) — Long-term debt levels determine how much of a company's cost structure is exposed to rate changes.
• =RSI("TICKER") — The Relative Strength Index can help time entries into rate-sensitive stocks that have become oversold after a rate scare.
• =SimpleMovingAverage("TICKER", 200) — The 200-day SMA helps determine whether a rate-sensitive stock is in a long-term uptrend or downtrend.
• =BookValuePerShare("TICKER") — Book value is particularly relevant for financials and REITs where tangible asset values drive floor valuations.
• =PricePerBook("TICKER") — The price-to-book ratio helps identify whether rate-sensitive stocks are trading at a premium or discount to their assets.

You can add any of these to additional columns on the Dashboard sheet to build a more comprehensive screening view.

Practical Application: The March 2026 Rate Hold

The Fed's decision to hold rates at 3.5–3.75% at the March 2026 meeting creates a specific analytical challenge. In a "higher for longer" environment:

1. Utilities remain under pressure because their bond-proxy yields must compete with elevated risk-free rates. However, if the market begins pricing in eventual cuts, utilities could rally sharply — the screener helps you identify which utilities are most positioned to benefit.

2. Financials are mixed. Banks benefit from wider net interest margins in a higher-rate world, but loan demand may soften. The screener's interest coverage and D/E components help distinguish banks that are thriving from those that are struggling.

3. REITs face headwinds from higher cap rates and financing costs. The correlation matrix shows that REITs move closely with utilities (0.72 correlation), so owning both provides less diversification than many investors assume.

4. Telecom companies carry moderate sensitivity primarily through their debt loads. Companies like VZ and T have significant long-term debt that becomes more expensive to service or refinance.

5. Technology serves as a natural hedge in a rate-sensitive portfolio. AAPL's low beta and strong interest coverage make it largely rate-insensitive, which is why it is included in the screener as a comparison point.

Frequently Asked Questions

What is a rate sensitivity score and how is it calculated?

A rate sensitivity score is a composite metric that combines multiple financial indicators — specifically beta, debt-to-equity ratio, and interest coverage ratio — into a single number between 0 and 100. Higher scores indicate greater exposure to interest rate changes. The formula weights leverage most heavily (40%) because debt levels create the most direct transmission mechanism from rate changes to company fundamentals. Beta contributes 30% to capture market-implied volatility, and interest coverage contributes 30% to measure debt servicing vulnerability.

Which sectors are most sensitive to interest rate changes?

Utilities, REITs, and financials are the three most rate-sensitive equity sectors. Utilities and REITs are sensitive because they carry high debt loads and their dividends compete with bond yields (the "bond proxy" effect). Financials are sensitive because their core business model — borrowing short and lending long — is directly tied to the rate curve. However, financials are unique in that they can benefit from rate increases through wider net interest margins, whereas utilities and REITs almost always suffer.

How does the Fed holding rates affect rate-sensitive stocks?

A rate hold creates a "status quo" environment where rate-sensitive stocks are influenced primarily by expectations about future moves rather than the current decision. If the market interprets a hold as a precursor to cuts, utilities and REITs tend to rally on anticipation. If the hold is interpreted as "higher for longer" (as in March 2026), these sectors may remain under pressure. The screener helps you quantify the relative exposure so you can position accordingly.

Can I customize the screener with my own tickers?

Yes. The template is designed to be fully customizable. Simply replace the tickers in column A with any stock or ETF symbol supported by MarketXLS, and all formulas will automatically update with live data for the new tickers. You can screen any number of stocks — just copy the formula rows down.

What is the difference between the sample file and the live template?

The sample file contains static data as of March 19, 2026, and can be opened in any version of Excel without MarketXLS. It is useful for understanding the template structure and methodology. The live template contains MarketXLS formulas that pull real-time data from the MarketXLS servers. It requires an active MarketXLS subscription and the Excel add-in to function.

How often should I update the screener?

In a stable rate environment, weekly updates are generally sufficient. However, around FOMC meetings, employment reports, and CPI releases, it is worth refreshing the data more frequently. The live template updates automatically whenever you open the file or trigger a recalculation in Excel, so the data is always current.

The Bottom Line

Building an interest rate sensitive stocks screener in Excel transforms rate analysis from guesswork into a systematic, repeatable process. By combining beta, leverage, interest coverage, and dividend yield into a composite sensitivity score, you can quickly identify which stocks in your portfolio or watchlist carry the most rate exposure — and make informed decisions about position sizing, sector allocation, and risk management.

The downloadable templates provide a ready-to-use starting point with 14 representative tickers across five sectors. The live version, powered by MarketXLS formulas, keeps your screening data current without manual entry.

To explore the full capabilities of MarketXLS for rate sensitivity analysis and hundreds of other use cases, visit marketxls.com or book a demo to see the platform in action.