Back to BlogTechnology & Operations

The Shift: AI NOI Forecasting Is Coming for the Budget Spreadsheet

Chirayu AgarwalAugust 19, 20263 min read
The Shift: AI NOI Forecasting Is Coming for the Budget Spreadsheet
Photo by Jakub Żerdzicki / Unsplash

The budget spreadsheet is one of the most durable artifacts in commercial real estate operations. Operators have been building annual NOI forecasts in Excel since Excel existed — inputting rent rolls, vacancy assumptions, operating expense line items, and capital expenditure schedules, and producing a bottom-up estimate of what a property will generate over the next 12 months. The process is familiar, controllable, and deeply embedded in how asset managers think.

It is also increasingly obsolete — not because the logic is wrong, but because it is being outperformed by machine learning models that incorporate data sources the Excel model was never designed to process.

What the new generation of NOI forecasting tools actually does:

The leading platforms in this space — VTS Activate, Reonomy Intelligence, and several newer entrants including Procore's analytics layer and Lessen's portfolio performance module — are now offering NOI forecasting functionality that pulls from a fundamentally different data architecture than traditional budgeting:

Lease expiration and rollover modeling uses ML to predict not just scheduled expirations but probability-weighted renewal likelihood based on tenant payment history, comparable market rents, tenant industry health (using public financial data), and lease concession trends in the specific submarket. The output is a more accurate expected-case NOI that accounts for rollover probability rather than treating every lease as either renewed or vacated at the binary lease end date.

Operating expense forecasting pulls from utility cost trend data, insurance premium trajectory models (particularly relevant in coastal markets), maintenance and repair cost indices by property type and vintage, and property tax assessment probability models that predict reassessment risk based on historical assessment cycles and recent comp sales. This is the category where Excel models are most consistently wrong — opex surprises are the most common source of NOI variance in stabilized portfolios.

Capex prediction uses building systems data — where available through IoT sensor integration — or actuarial tables for building vintage and system age to predict the probability and expected cost of major capital expenditures within the forecast horizon. Rooftop HVAC units that are eight years past median replacement age are a statistical liability in a one-year NOI forecast; traditional budgets treat them as zero-cost until the failure happens.

The variance reduction data:

Three mid-market operators that disclosed their forecasting accuracy data in a Q1 2026 NAIOP technology survey reported the following: average NOI forecast variance versus actual (the traditional measure of budget accuracy) improved from 8.2% under traditional Excel-based budgeting to 6.1% under AI-assisted forecasting — a 25% reduction in forecast error. The improvement was most pronounced in operating expense prediction, where the AI models consistently outperformed human estimates by incorporating data the budgeting team didn't have access to.

For a $30M asset generating $1.8M in NOI, a 25% reduction in forecast variance represents approximately $45,000 in mean error reduction per cycle. Across a 10-asset portfolio, that's the difference between a portfolio that consistently hits its investor reporting benchmarks and one that is constantly explaining variances.

The deployment gap:

The tools exist. The deployment gap is the data infrastructure problem again — AI NOI forecasting requires clean, current, structured data: unit-level rent rolls, operating expense ledgers by category, lease abstracts in machine-readable format, maintenance work order histories, and utility bills by meter. Most operators have all of this data. It is distributed across Yardi or MRI, email attachments, paper files in property management offices, and spreadsheets on individual asset managers' computers.

The data integration project is the prerequisite. And it is ongoing — not a one-time setup.


Klyvora note: The data infrastructure that AI forecasting tools require — clean, current, structured, continuously maintained — is exactly what Klyvora's offshore real estate teams build and maintain as an ongoing service. We don't just help operators adopt PropTech; we run the data layer underneath it that makes the technology actually work.


#PropTech #AIRealEstate #NOIForecasting #AssetManagement #RealEstateTechnology #CREOperations #Klyvora #DailySnapshot

Technology & OperationsRENZ Weekly