REIT Earnings Tracker Excel: Q1 2026 Commercial Real Estate Watchlist

REIT earnings tracker Excel is what advisors, income investors, and self-directed allocators reach for when commercial real estate steps into the spotlight again, and Q1 2026 reporting season is exactly that moment. Twelve of the largest publicly traded REITs report between late April and mid May 2026, spanning data center, cell tower, industrial, residential, retail, healthcare, storage, and gaming sub-groups. The headline question is no longer "what will the Fed do" but "how is each REIT compounding cash flow with the rate environment as it actually is in 2026." This guide pairs a market lens on Q1 2026 REIT earnings with two ready-to-use Excel templates wired to live MarketXLS formulas so the watchlist stays current after every print.

Q1 2026 REIT Earnings: The Key Data Table

Below is a snapshot of the 12 REITs included in the template. The values shown are static for blog illustration; the included Excel file pulls each metric live via MarketXLS once you open it in Excel.

Operating cash flow per share is shown as a public-data proxy for FFO (funds from operations). The Excel template includes both the formula reference and the cell-coverage check so you can substitute reported FFO when each company files its supplement.

Why a REIT Earnings Tracker Excel Matters Right Now

The Q1 2026 reporting window arrives with a different macro setup than the past three years.

1. Rates are no longer the entire story. The Fed pivot earlier in 2026 meant overnight rates eased, but the long end of the curve has stayed sticky. That changes how REITs refinance debt walls coming due in 2026 and 2027. Higher-leverage names (towers, mall) are still feeling the cost-of-capital headwind, while lower-leverage residential and net-lease REITs have more flexibility on growth capital. A REIT earnings tracker Excel lets you see leverage in context with cash flow on the same row, instead of toggling between filings.

2. AI capex is rewriting the data center sub-group. Equinix and Digital Realty have been working through booking strength and power constraints since mid 2025. In Q1 2026 the conversation has shifted to what percent of new leases are pre-signed for 2027 delivery, what wholesale rates look like in Northern Virginia and Frankfurt, and how interconnect revenue is scaling alongside hyperscaler tenancies. The same conversation now flows through to towers, where 5G densification capex from carriers feeds AMT and CCI revenue.

3. Office is mostly out of the index, but commercial real estate stress is not gone. Most of the largest pure office REITs have either consolidated or have shrunk dramatically in market cap. The 12 names in this template intentionally skip commodity office to focus on sub-groups where Q1 2026 earnings will move the tape: data center bookings, industrial rent spreads on lease renewals, residential same-store revenue (Sunbelt vs coastal), net-lease tenant credit, and gaming rent escalators.

4. Dividend coverage matters more than headline yield. A 6%-plus yield gets attention, but it only matters if operating cash flow per share covers the payout with margin to spare. The template has a "coverage check" that divides cash flow per share by the annual dividend amount.

The Q1 2026 Tracker focuses on these themes through 12 large-cap names, with sub-groups labeled so you can compare apples to apples (a tower REIT next to a data center REIT next to a net-lease REIT) without losing context.

REIT Earnings Tracker Excel: Sub-Group Breakdown

This breakdown matters because REITs are not a single asset class. The valuation multiples, leverage profiles, and growth drivers differ wildly between, say, EQIX and SPG. A single screener with a single threshold misses that nuance. The template uses sub-group as a slice so you can rank within each rather than mixing data center hyperscalers with mall operators.

Q1 2026 REIT Earnings: The Approach (Educational Hypothesis, Not Advice)

The framework the dashboard uses is built around four lenses, deliberately leaning on metrics that are publicly available and pullable through MarketXLS without manual data entry.

Lens 1: Cash flow coverage of dividends. Operating cash flow per share is the public-data proxy for FFO that a quarterly tracker can pull live every day. If CashFlowPerShare / DividendPerShare is above 1.5, the dividend looks well covered on a trailing basis. If it sits near 1.0 or below, that is a flag to look at the full disclosure rather than the headline number.

Lens 2: Leverage versus sub-group. Tower REITs and mall REITs structurally carry more debt, which makes raw TotalDebtToEquity numbers misleading without sub-group context. The template shows the metric and lets you compare AMT to CCI, or SPG to a residential operator, instead of ranking across the whole list.

Lens 3: Trend overlay. A 50-day simple moving average and 52-week high/low give a quick read on how the market has been pricing the sub-group going into earnings. Names trading near the 52-week high with strong cash flow coverage are different from names near the low with weak coverage. Same template, different stories.

Lens 4: Valuation discipline. Price-to-book is imperfect for REITs because depreciation accounting understates real estate values, but it is a starting reference. P/E is included for context but is less informative for REITs than FFO multiples; the included template flags this so you can sanity-check the headline P/E against cash flow per share before making any judgment.

This is an analytical framework, not a recommendation. Use it to read each quarterly print faster, not as a model that decides what to own.

MarketXLS Implementation: REIT Formulas That Power the Template

Every cell in the live template is a verified MarketXLS function. The full list is documented in the MarketXLS function reference. Here are the ones doing the heavy lifting on the REIT tracker:

=QM_Last("O")                  -> Current price for Realty Income
=PERatio("O")                  -> Trailing P/E ratio
=DividendYield("O")            -> Trailing dividend yield (decimal)
=DividendPerShare("O")         -> Annual dividend dollar amount
=CashFlowPerShare("O")         -> OCF per share (FFO proxy)
=PriceToBook("O")              -> Price relative to book value
=TotalDebtToEquity("O")        -> Leverage on the balance sheet
=Beta("O")                     -> Risk lens vs the broad market
=MarketCapitalization("O")     -> Market cap in USD
=Revenue("O")                  -> Trailing revenue
=SimpleMovingAverage("O","50") -> 50-day SMA for trend
=RSI("O")                      -> Momentum oscillator
=FiftyTwoWeekHigh("O")         -> Annual high
=FiftyTwoWeekLow("O")          -> Annual low
=Sector("O")                   -> Sector classification
=Industry("O")                 -> Industry classification

These are the primitives. The dashboard layers them into a single row per REIT and a composite score at the right edge. Every formula references the Symbol cell (column A) so you can swap any ticker and the row repopulates automatically.

For a deeper look at how to build screeners with MarketXLS formulas, our existing post on building a REIT screener walks through the logic from a screening angle. The Q1 2026 tracker focuses on the earnings-season layer that screeners by themselves do not capture.

The Composite Score Logic

The tracker assigns each REIT a composite score on the dashboard. The formula is fully exposed so you can change the weights:

=ROUND(
  (Yield / MAX(Yield_Range)) * 25 +
  (OCF_per_Share / MAX(OCF_Range)) * 20 +
  (1 - PriceToBook / MAX(PB_Range)) * 15 +
  (1 - DebtEquity / MAX(DE_Range)) * 15 +
  (SMA50 / Price) * 15 +
  (OCF_per_Share / Dividend_per_Share) * 10
, 2)

This is a relative score, normalized within the watchlist. A REIT with the highest yield, strongest cash flow, lowest debt, and trading below its 50-day SMA scores best. You can rebalance the 25/20/15/15/15/10 weights to match your own preferences (income-first, quality-first, contrarian, etc.).

Important note on intent: the score is a sorting tool, not a buy/sell signal. The full reading still requires reading the supplement.

REIT Earnings Tracker Excel: Inside the Template

The download includes two files: a static Sample with formula references, and a live Template that pulls everything via MarketXLS. Both files share the same six-sheet structure.

Sheet 1 - How To Use

A short one-page guide with purpose, sheet roster, sample-vs-template explanation, "Data as of" date for the Sample, and a list of every MarketXLS function used across the workbook.

Sheet 2 - Main Dashboard

The headline view. Yellow input cells in the top left let you set:

• Portfolio Size (default $100,000)
• Max Position Weight (default 18%)
• Base Scenario Same-Store NOI Move (default 3%)
• Earnings Season Flag (1 = on)

Below that is the 12-row REIT table with columns for Ticker, Company, Sub-Group, Sector, Last Price, P/E, Dividend Yield, Dividend per Share, Beta, Market Cap, Revenue, OCF per Share, Price/Book, Debt/Equity, 50D SMA, RSI, 52W High, 52W Low, and Composite Score. The Score column has a 3-color heatmap (red to yellow to green) so the eye lands on the highest-scoring names first.

Sheet 3 - Scenario Analysis

Five named scenarios cross-tabbed against rates outlook, occupancy trend, same-store NOI move, implied FFO move, cap rate direction, and watchlist bias:

The implied FFO move column is the "what if" that drives Sheet 5 allocations.

Sheet 4 - Strategy Positioning

A Core vs Satellite tier per REIT, with a sub-group-aware theme tag. The logic is simple and exposed: IF(Yield > 4% AND DebtToEquity < 2, "Core", "Satellite"). Change the thresholds to fit your own income-vs-growth tradeoff. Each row has a "Review Trigger" pointing to "Recheck after Q1 2026 print" so the worksheet doubles as an earnings-season checklist.

Sheet 5 - Portfolio Allocation

Position sizing flows from the Score on the Main Dashboard. The Target Weight formula caps each position at the user-defined Max Position Weight from the input cell. Dollar Allocation multiplies the weight by Portfolio Size. The sheet also surfaces Yield Contribution and Annual Dividend Dollars so you see what your full allocation produces in income on a trailing basis. A Dividend Frequency column flags O as monthly versus the rest as quarterly.

Sheet 6 - Correlation Comparison

A wide comparison table so you can see, on one screen, how each REIT is positioned relative to its 50-day trend, its 52-week range, its leverage neighbors, and its sub-group peers on yield and price-to-book. Useful right before earnings to spot which names already have a lot priced in.

Download the Templates

Download both files to follow along:

• - Pre-filled with snapshot data so you can see the layout immediately
• - Live-updating formulas that refresh whenever you open the file

To use the live version you need MarketXLS installed in Excel and an active license. The template is a starting point; the score weights, ticker list, and scenario inputs are all designed to be edited.

Practical Workflow During Q1 2026 Earnings Season

How to actually use the file as REITs report through late April and May:

1. Pre-print: open the template the morning of each REIT report. Note the current price, OCF per share, dividend coverage, and where the name sits on the 50-day SMA. Snap the row.
2. Read the supplement, not just the headline. REIT supplements give same-store NOI, leasing spreads, FFO, AFFO, and the debt maturity schedule. Compare reported FFO to the OCF/Share proxy in your worksheet to validate the proxy.
3. Update assumption cells if guidance changes. If management raises full-year same-store NOI guidance, change the input on the Main Dashboard from 3% to whatever they guided.
4. Re-rank the table. The composite score is recomputed automatically. Watch which sub-group rotates up or down after each set of prints.
5. Save a snapshot. The static Sample format works as a "post-print" record. Save a copy with the date in the filename so you have a quarter-end versioned tracker.

This is closer to how a professional REIT analyst works through earnings season than a one-shot screener can be.

Q1 2026 Themes Already Visible

A few patterns showing up in early reports and Q4 2025 calls that the tracker is designed to surface:

Data center bookings remain the bull case for the sub-group. Equinix and Digital Realty signaled record bookings going into 2026. The watch is on power availability and how much of 2027 capacity is already pre-leased. The tracker shows this through OCF per share and price-to-book, both of which have re-rated for these names.

Tower carrier spending is stabilizing. AMT and CCI were under pressure for two years on carrier capex slowdowns and 5G consolidation. Q1 2026 will reveal whether services growth is offsetting churn from the consolidation. The leverage column on the tracker is meaningful here - tower REITs structurally carry the highest debt loads on the watchlist.

Industrial rent change on renewal is moderating. Prologis was reporting +60% to +75% net effective rent change on renewals through 2024-2025. Those comps will get harder. The tracker uses revenue and OCF per share to surface the underlying growth rate.

Net lease coverage matters as tenants get scrutinized. Realty Income's strength is the diversification of tenant credit. Watch occupancy and rent collection commentary in the Q1 print. Same for VICI on its gaming tenant base.

Residential is a tale of two geographies. AvalonBay (coastal) versus Sunbelt-heavy operators. The same-store NOI gap between coastal and Sunbelt has narrowed. Look for forward guidance commentary on supply absorption.

The tracker is built to flag these stories quickly without paging through ten Q1 2026 supplements one by one.

REIT Earnings Tracker Excel FAQ

What is the difference between FFO and operating cash flow for REITs?

FFO (funds from operations) is the REIT-industry standard earnings metric, defined by NAREIT as net income plus depreciation and amortization, minus gains on property sales. Operating cash flow per share, which is what the MarketXLS CashFlowPerShare formula returns, is from the cash flow statement. The two are highly correlated and the operating cash flow proxy works well for trailing-basis tracking. For exact FFO and AFFO numbers each quarter, pull the supplemental disclosure when each REIT reports and substitute the value into the worksheet.

Why is price-to-book misleading for REITs?

Real estate on the balance sheet is recorded at cost less accumulated depreciation. After years of depreciation, the book value can be far below market value of the underlying assets, which makes price-to-book ratios appear high (a stylized example is a tower REIT with very high P/B). Use it as a relative reference inside a sub-group, not as a standalone valuation signal across all REIT sub-groups.

How often should I refresh the REIT earnings tracker Excel?

The MarketXLS formulas refresh on file open and can be set to refresh on an interval. During earnings season, reopening the template once a day is enough. The composite score recomputes automatically when prices or fundamentals update. For event-driven moments (an earnings beat or miss, a guidance change), force a refresh and re-read the row immediately.

Which REIT sub-groups are most rate-sensitive?

In general, the most leveraged sub-groups are most rate-sensitive: cell tower (AMT, CCI), mall (SPG), and specialty (IRM) names tend to carry more debt. Lower-leverage residential, net lease, and storage REITs are less sensitive at the margin. The Debt/Equity column on the dashboard surfaces this directly. The bull-cut and bear-no-cuts scenarios in Sheet 3 are designed to show how the watchlist bias rotates by rate path.

Can I add or remove REITs from the watchlist?

Yes. On the Main Dashboard, replace the ticker in column A. Every formula in the row references that cell, so the rest of the row repopulates with the new symbol's data automatically. The composite score reranks across the new list. The only manual edits are the Company, Sub-Group, and Theme columns since those are descriptive labels.

Does the template work for international REITs?

Most MarketXLS coverage is US-listed equities and ADRs. International REITs that trade as ADRs in the US (a handful are in the index) will work. For non-US-listed REITs, the data feeds may not return values. The 12 names in this template are all US-listed.

What is the difference between this REIT tracker and a generic REIT screener?

A screener typically applies a single set of thresholds across the entire universe and surfaces the names that pass. This tracker is designed for earnings season specifically: it pulls live data into a known watchlist, scores them against each other, and pairs the scores with a scenario layer for occupancy, rates, and same-store NOI. Together they support an earnings-season workflow rather than a one-shot screen.

The Bottom Line

REITs in Q1 2026 are no longer the rates trade they were in 2022 and 2023. The story now is operational: data center bookings, tower carrier spending, industrial rent spreads, residential same-store NOI, and net-lease tenant credit. A REIT earnings tracker Excel that pulls cash flow, dividends, leverage, and trend on one screen, with sub-group context, is the difference between reading every Q1 2026 supplement cold and having a baseline already loaded the morning of each report.

The two downloadable files give you a starting point. Edit the inputs, swap tickers, adjust the score weights, and use the scenario sheet to stress test the watchlist for the rate path you actually expect through 2026.

For the full library of templates, model walkthroughs, and Excel finance functions, see MarketXLS. To talk through how the platform fits a real income-and-real-assets process, book a demo.

This article is for educational purposes only. Nothing here is a recommendation to buy or sell any security. Tickers are referenced solely as examples of how the formulas and template work. Always do your own research and consult a registered advisor before making investment decisions.