From Spreadsheets to Scale: Why REITs Can No Longer Afford to Operate on Excel Alone

But the opportunity comes with complexity. Two significant divergences are defining the current moment: a prolonged and widening gap between public and private real estate valuations, and a striking disconnect between REIT and broader equity market multiples — the latter driven in large part by the AI-fueled tech rally that dominated investor attention throughout 2025. According to Nareit, both divergences are historically unusual in their duration, and history suggests that when they close, they close in favor of REITs. The sector is increasingly seen as poised for a rebound — but capturing that upside requires moving quickly, with conviction, and with the analytical infrastructure to back it up.

Meanwhile, the universe of what constitutes a REIT has never been broader or more operationally diverse. Data centers, senior housing, industrial logistics, cell towers, and life sciences facilities now sit alongside traditional office, retail, and multifamily portfolios — each with its own demand drivers, lease structures, and capital requirements. Institutional investors, including more than 70% of U.S. pension funds by assets, are deepening their REIT allocations. The pressure to perform, report, and scale has never been greater.

Yet for many REIT finance teams, the tools used to manage this complexity have not kept pace with the ambition. The calculations are more intricate, the data sources more fragmented, and the stakeholder expectations higher — but the operational backbone is often still built on spreadsheets. This article makes the case for why that has to change, and why Anaplan is the platform best positioned to bridge the gap between where REITs are today and where they need to be.

A Business Unlike Any Other — With Calculations to Match

Despite their growing prominence, REITs remain one of the most analytically complex business structures in the investment world. Unlike a standard operating company, a REIT must simultaneously manage real estate operations, satisfy investor return requirements, maintain regulatory compliance, and navigate highly specific financial reporting requirements — all of which demand a purpose-built approach to planning and analysis.

The Data Integration Challenge

A REIT finance team does not work from a single source of truth — it works from many. A typical reporting cycle requires consolidating data from at least four distinct systems:

• Property Management Systems (e.g., MRI, Yardi, RealPage): Leasing schedules, occupancy rates, rent rolls, lease expiries, tenant credit profiles, and CAM reconciliations.

• Enterprise Resource Planning (ERP) systems: General ledger, trial balances, income statements, accounts payable/receivable, and entity-level financial performance.

• Debt Management Systems (DMS): Loan covenants, interest rate schedules, maturity dates, refinancing timelines, and lender reporting requirements.

• Cap Table / Share Management Tools: Share issuance history, dilution schedules, equity raise impact, OP unit conversions, and public market float information.

There is no off-the-shelf enterprise planning solution that natively integrates these four systems and speaks the language of REIT finance. Off-the-shelf FP&A platforms are built for standard corporate planning cycles — budgeting, forecasting, and headcount. They are not designed to handle lease-by-lease cash flow modeling, REIT compliance testing, or FFO-based valuation — the core currency of the sector.

The Calculation Complexity

Beyond data integration, REITs must perform a set of highly specific, recurring calculations that standard planning tools simply cannot accommodate out of the box. These include:

• AFFO (Adjusted Funds From Operations): The industry’s primary measure of sustainable cash flow and dividend-paying capacity, requiring FFO adjusted for recurring capex, straight-line rent, stock compensation, and other non-cash items. Each line item requires consistent logic across all properties and entities.

• Dividend Calculation and Payout Ratio Modeling: REITs are required by law to distribute at least 90% of taxable income as dividends. Calculating optimal payout ratios requires integrating AFFO projections, taxable income estimates, cash retention needs, and shareholder expectations — often under multiple scenario assumptions simultaneously.

• REIT Compliance Testing: IRS qualification tests — including the 75% and 95% gross income tests, the 75% asset test, and the distribution requirement — must be calculated quarterly and annually. Errors here are not just a reporting problem; they can result in loss of REIT status and devastating tax consequences.

• Share Issuance and Dilution Modeling: Equity raises, OP unit conversions, DRIP plan activity, and at-the-market (ATM) programs all affect share count and per-share metrics. Accurately modeling the dilutive impact on FFO per share and NAV per share requires a dynamic, connected calculation engine — not a static spreadsheet.

The Excel Trap: Familiar, But No Longer Fit for Purpose

For decades, REIT finance teams have relied on Excel to handle these complexities — and for a long time, it worked. Excel is flexible, familiar, and powerful in the right hands. But as REIT portfolios have grown in size, sector diversity, and investor scrutiny, the cracks in spreadsheet-based operations have become impossible to ignore.

The most commonly cited pain points include:

• Inability to scale: A model built for 50 properties becomes unmanageable at 200. Tabs multiply, files fragment, and performance degrades. Portfolio-wide analysis that should take minutes can take days.

• Formula errors and version control failures: Studies consistently show that the majority of large spreadsheets contain material errors. In REIT modeling, a broken link or hardcoded override in an AFFO or compliance model is not just an inconvenience — it’s a liability.

• Manual, time-consuming processes: Consolidating data from multiple property management systems, ERPs, and debt platforms into a single Excel model typically requires significant manual work each reporting cycle — time that could be spent on analysis, not data assembly.

• Error-prone scenario analysis: Running portfolio-wide sensitivities — interest rate stress tests, occupancy shocks, acquisition modelling — requires duplicating entire models, increasing the risk of inconsistency and error.

• No real-time data connectivity: Excel does not natively connect to Yardi, MRI, SAP, Oracle, or most DMS platforms. Manual data exports and imports introduce lag, inconsistency, and risk at every step.

• Audit trail and access control limitations: Excel provides limited auditability and virtually no granular access control. In a regulated environment with investor reporting obligations, this creates material governance risk.

• Limited collaboration: Multiple analysts working on the same model leads to version conflicts, overwritten work, and the perennial challenge of knowing which file is the current one.

Why Anaplan Is the Right Answer for REITs

Anaplan is a purpose-built connected planning platform designed to solve exactly the problems described above — at enterprise scale, with the flexibility to model any business logic and the connectivity to bridge siloed data sources into a single, governed planning environment.

For REITs specifically, Anaplan delivers on four critical dimensions:

• Connected data, unified model: Anaplan integrates directly with property management systems, ERP platforms, debt management tools, and share registries. Rather than manually assembling data each cycle, REIT finance teams can operate from a single, always-current model that reflects live data across the portfolio.

• Purpose-built REIT calculations: Anaplan’s flexible calculation engine — built on a multidimensional in-memory model — can be configured to replicate any REIT-specific logic: AFFO computation, REIT compliance testing, dividend and payout ratio modeling, share issuance and dilution calculations. Once built, these models are reusable, auditable, and governed.

• Portfolio-wide scenario analysis at speed: With Anaplan, running a 200-basis-point interest rate stress test across an entire portfolio, or modeling the FFO impact of a new acquisition, takes minutes rather than days. All scenarios run within the same governed model, eliminating version drift and inconsistency.

• Enterprise-grade governance and auditability: Every change in Anaplan is tracked, timestamped, and attributable. Role-based access controls ensure that each team member sees only what they need to see — and that no single user can inadvertently overwrite a shared calculation. For investor reporting and regulatory compliance, this is not optional.

The Time to Act Is Now

Excel has served REIT finance teams well. For many years, it was the best available tool for the job — flexible enough to handle complex calculations, accessible enough to require no specialist expertise. There is no shame in having relied on it. But the landscape has fundamentally changed.

The REITs that will lead the next decade are those that can move fast. Fast to respond to market dislocations. Fast to model an acquisition. Fast to answer a shareholder question with current, accurate, data-driven insight rather than a spreadsheet that was last updated three days ago. In today’s environment — where AI is accelerating the pace of decision-making across every sector, where investors demand transparency and speed, and where competitive advantage is measured in hours, not weeks — operating on Excel is no longer a conservative choice. It is a strategic risk.

Anaplan is not a rip-and-replace solution. It is the platform that allows REITs to step up — to retain the analytical flexibility they depend on while eliminating the operational fragility, governance gaps, and scalability limits that come with spreadsheet-based planning. It is the foundation from which a REIT can grow with confidence, move with conviction, and compete on the quality of its insight.

The question for REIT leadership is no longer whether to modernize. The question is whether to act before the next cycle, or after it.

To continue the conversation, contact Partner Douglas Eaton today: Douglas.Eaton@alphafmc.com