Floating Rate ETF Screener Excel: June 2026 Rising-Rate Income Dashboard

Floating rate ETF screener excel is exactly what you want open on your desk when the Federal Reserve stops talking about cuts and starts talking about hikes. That is the world as of June 2026: at the June 16-17 meeting the FOMC held its benchmark range at 3.50 to 3.75 percent for a second straight meeting, raised its 2026 inflation outlook to 3.6 percent headline, and lifted the median year-end fed funds projection to 3.8 percent, which implies at least one more hike on the table this year. When short-term rates are sticky or rising, floating-rate funds are one of the few corners of fixed income whose income goes up instead of down. This guide shows you how to build a working floating rate ETF screener in Excel using live MarketXLS formulas, and it comes with a downloadable dashboard that ranks the major funds for you.

The post pairs with a downloadable that covers 11 floating-rate ETFs across senior loans, CLOs, and Treasury or investment-grade floating-rate bonds, computes a rising-rate income score, and includes a scenario analysis across five Fed rate paths.

Key Data Table - The Floating Rate ETF Universe

The table below groups the core floating-rate ETF universe into two buckets that behave very differently. Senior loan and CLO funds pay more because they take credit risk; Treasury and investment-grade floating-rate funds pay less but barely move. Every value in the live template updates through MarketXLS. The yields shown here are illustrative snapshots for context, not quotes.

The single most important idea in this table is duration. A traditional bond fund loses price when rates rise because its fixed coupon becomes less attractive. A floating-rate fund resets its coupon every one to three months in line with short-term rates, so its interest-rate duration is close to zero. That is why these funds are the natural fixed-income response to a hiking Fed.

Why Floating Rate ETFs Matter Right Now

Floating rate ETF screener excel demand tends to spike at exactly the moment the market stops expecting rate cuts. In June 2026 the catalysts are stacked up. Kevin Warsh chaired his first meeting as Fed chair and the committee not only held rates but nodded toward possible hikes, citing tariff-driven inflation and Middle East energy supply risk. The 10-year Treasury yield has hovered near 4.5 percent, and core inflation projections were nudged up to 3.3 percent. Consumer sentiment from the University of Michigan sits near historic lows around 48.9.

In plain terms: the easy-money tailwind that lifted long-duration bonds is gone, and the risk is now skewed toward rates staying higher for longer. For an income investor, that is the textbook setup for floating-rate exposure. When the Fed hikes, the coupon on a senior loan or a Treasury floating-rate note ratchets up at the next reset, so your income rises while a long-duration bond fund takes a price hit.

This is not a recommendation to pile into any single fund. It is an analytical observation about how a category behaves in a specific rate regime. The screener exists so you can compare funds on the metrics that matter and make your own decision.

The Two Buckets - Credit Risk Is the Real Trade-Off

Where many investors go wrong is treating all floating-rate funds as interchangeable. They are not. The screener splits the universe into two buckets for a reason.

Senior Loan and CLO Funds (Credit-Sensitive)

Senior loan funds like BKLN and SRLN hold leveraged loans made to below-investment-grade companies. CLO funds like JAAA, JBBB, and CLOZ hold tranches of collateralized loan obligations, which are pools of those same loans sliced into risk tiers. Both pay higher yields, often in the 7 to 8 percent range, precisely because they take credit risk. The reward is income. The risk is that in a recession, defaults rise and prices fall, even if interest rates stay high. Floating-rate does not mean risk-free; it means rate-risk-free, not credit-risk-free.

Treasury and Investment-Grade Floating Rate Funds (Low Credit Risk)

Treasury floating-rate funds like USFR and TFLO hold U.S. Treasury floating-rate notes, which carry essentially no credit risk. Investment-grade corporate floating-rate funds like FLOT, FLRN, and FLTR sit just above them on the risk ladder. These funds yield less, usually in the 4.5 to 5 percent range, but they hold their value through credit stress and function as a high-quality cash alternative that still benefits when rates rise.

A sensible floating-rate allocation usually blends a stable Treasury or IG core with a measured loan or CLO income sleeve. The comparison sheet in the template lays this out attribute by attribute.

The Rising-Rate Income Hypothesis (Educational, Not Advice)

The educational hypothesis behind the screener is simple to state. In a rate regime where the Fed is on hold or hiking, a portfolio tilted toward floating-rate income should generate rising cash flow with minimal price volatility, in contrast to a traditional bond ladder that loses market value as yields climb. The screener helps you test that idea by scoring each fund on income per unit of risk.

The catch, and it is an important one, is the economic cycle. The same higher-for-longer rate environment that boosts floating-rate income can also slow the economy and pressure leveraged borrowers. If you reach for the highest-yielding loan and CLO funds without regard to credit quality, you are taking an equity-like bet dressed up as fixed income. The screener makes that trade-off visible by showing yield and beta side by side, so you can see exactly how much risk you are being paid to take.

Nothing here is a forecast or a buy recommendation. Rates may not rise. Credit may deteriorate. This is a framework for analysis, and you should pair it with your own research or a licensed advisor.

Building the Screener in Excel with MarketXLS

The whole point of a floating rate ETF screener excel build is that you control the universe and the scoring. Here are the verified MarketXLS formulas the template uses. Each one was confirmed live before publishing, so you will not hit a broken function.

Pull the fund name and current price:

=Name("BKLN")
=QM_Last("BKLN")

Pull the distribution yield and the trailing distribution per share:

=ETFYield("BKLN")
=DividendPerShare("BKLN")
=DividendYield("BKLN")

Add risk and range context with beta and the 52-week range:

=Beta("BKLN")
=FiftyTwoWeekHigh("BKLN")
=FiftyTwoWeekLow("BKLN")
=PercentChangeFrom52_weekLow("BKLN")

Layer in liquidity and momentum:

=AverageDailyVolume("BKLN")
=SimpleMovingAverage("BKLN",50)
=RSI("BKLN")

With those columns in place, the rising-rate income score is a single formula that rewards yield above your target and penalizes beta above your tolerance. In the template the score for each row looks like this, referencing the yield column, the beta column, and your input cells:

=ROUND(MAX(0,MIN(100, 50 + (E8-$E$4)*8 - (G8-$F$4)*120 + (60-L8)*0.2)),0)

Because the score references your yellow input cells, changing your minimum yield target or maximum beta instantly re-ranks the entire universe. That is the advantage of building this in Excel rather than reading a static list: the screen is yours.

Inside the Template - What Each Sheet Does

The downloadable workbook follows a six-sheet structure so it works as a complete decision tool, not just a quote list.

1. How To Use walks through the workbook and the MarketXLS setup, and reminds you this is an educational tool.
2. Main Dashboard is the screener itself: all 11 funds with price, distribution yield, dividend per share, beta, 52-week range, percent off the low, average volume, RSI, and the rising-rate income score. Your portfolio size, minimum yield target, and maximum beta sit in yellow input cells at the top.
3. Scenario Analysis models annual income across five Fed rate paths, from two cuts to two hikes, using a yield-beta-to-Fed input so you can see how much a rate move flows through to your coupon. It contrasts the floating-rate outcome with what a fixed-rate bond would do.
4. Income Strategy lays out a floating-rate ladder concept with a stable IG or Treasury core, a senior-loan income sleeve, a structured CLO sleeve, and a cash buffer, each with entry, monitor, and exit notes.
5. Portfolio Allocation turns your portfolio size and per-fund weights into dollar allocations, estimated shares, and estimated annual income, then computes a blended portfolio yield.
6. Loan vs IG Comparison is the attribute-by-attribute breakdown of the two buckets plus a qualitative correlation read, so you understand the diversification you get by blending them.

The sample workbook is pre-filled with illustrative values as of June 27, 2026 and shows the exact MarketXLS formula behind each number. The formula version contains only live functions, so it refreshes whenever you press Refresh in the MarketXLS ribbon.

Scenario Analysis - How Income Reacts to the Fed

The scenario sheet is where the rising-rate logic becomes concrete. Suppose you hold 50,000 dollars in a blend yielding 6 percent today, and you assume roughly 85 percent of a Fed move passes through to your coupon over time. The estimated new yield in each scenario is computed as:

=current_yield + rate_change * yield_beta

and the annual income as:

=amount_invested * new_yield / 100

Walk it across the five paths and the pattern is clear. In the two-hike scenario your estimated income rises, in the hold scenario it is roughly flat, and in the two-cut scenario it falls. A fixed-rate bond fund would show the mirror image: price gains when rates fall, price losses when rates rise. That contrast is the entire case for floating-rate exposure in a hawkish regime, and the sheet lets you stress it with your own numbers.

How Floating Rate ETFs Fit a Portfolio

For a financial advisor or self-directed investor, floating-rate funds usually play one of two roles. The Treasury and IG floating-rate funds act as a cash-plus stabilizer, a place to earn a real yield on dry powder without taking duration risk. The senior loan and CLO funds act as an income sleeve that can lift the blended yield of a fixed-income allocation, accepting credit risk in exchange.

The allocation sheet is built to size both. Plug in your portfolio size, set a weight for each fund, and the template returns the dollar allocation, estimated shares, and estimated annual income for each line, plus a blended yield for the whole sleeve. Because the weights are input cells, you can dial credit risk up or down and watch the blended yield respond. If you want to compare this floating-rate sleeve against a high-yield approach, the junk bond ETF tracker and the interest rate sensitive stocks screener cover adjacent angles, and the MarketXLS ETF tools page lists the full function set.

Frequently Asked Questions

What is a floating rate ETF?

A floating rate ETF holds bonds or loans whose interest payments reset periodically in line with a short-term reference rate. Because the coupon adjusts, the fund has very low interest-rate duration, so its price moves little when rates change. The income, however, rises and falls with short-term rates, which is why these funds are popular when the Fed is hiking or holding.

Do floating rate ETFs go up when interest rates rise?

Floating rate ETFs do not typically gain much price when rates rise, but their income increases because the coupon resets higher. That is the opposite of a traditional bond fund, which loses price when rates rise. The benefit of floating-rate funds is income stability and capital preservation in a rising-rate regime, not price appreciation.

Are senior loan ETFs safe?

Senior loan ETFs carry meaningful credit risk because they lend to below-investment-grade companies. They sit higher in the capital structure than bonds, which helps in a default, but they can still fall in price during a recession or a credit-spread blowout. They are not a cash substitute. Treasury floating-rate funds like USFR and TFLO are the low-credit-risk option in the floating-rate space.

What is the difference between BKLN, FLOT, and USFR?

BKLN is a senior bank-loan fund with credit risk and a higher yield. FLOT holds investment-grade corporate floating-rate notes with modest credit risk and a moderate yield. USFR holds U.S. Treasury floating-rate notes with essentially no credit risk and the lowest yield of the three. They occupy three different points on the risk-versus-yield spectrum, which the screener makes easy to compare.

Which MarketXLS formulas does the floating rate ETF screener use?

The screener uses Name and QM_Last for the fund name and price, ETFYield and DividendPerShare for income, Beta for risk, FiftyTwoWeekHigh and FiftyTwoWeekLow with PercentChangeFrom52_weekLow for range context, AverageDailyVolume for liquidity, and SimpleMovingAverage and RSI for momentum. Every formula was verified live before publishing.

Can I build this screener for my own list of funds?

Yes. The template is fully editable. Replace the tickers in the dashboard with any floating-rate ETFs you follow, and the MarketXLS formulas will pull live data for them automatically. You can also adjust the income score weights to match how you trade off yield against credit and rate risk.

The Bottom Line

Floating rate ETF screener excel is the right tool for a June 2026 market where the Fed is signaling hikes rather than cuts and inflation forecasts are drifting higher. Floating-rate funds turn that rate pressure into rising income with minimal price risk, but the category splits cleanly into low-credit-risk Treasury and IG funds and higher-yielding loan and CLO funds that take real credit risk. A screener that scores both on yield and risk, and an allocation sheet that lets you blend them, is far more useful than any static best-of list.

Download the template, plug in your own portfolio size and risk tolerance, and let the live MarketXLS formulas do the data work. To see the full library of ETF and fixed-income functions, visit MarketXLS, and if you want a walkthrough of how advisors build income dashboards like this, book a demo.

Download the templates:

• - Pre-filled with illustrative June 2026 data
• - Live-updating formulas

This article is for educational purposes only and is not investment advice. Floating-rate loan and CLO funds carry credit and liquidity risk and can lose value. Yields shown are illustrative. Always do your own research or consult a licensed financial advisor before investing.