By Haven Chavous, Senior Business Intelligence Architect

The commercial real estate industry has long been married to Microsoft Excel.

Walk into any acquisition meeting, investment committee presentation, or asset management review, and you’ll find analysts hunched over laptops, navigating through dozens of tabs in sprawling workbooks that have evolved over years—sometimes decades—into byzantine labyrinths of formulas, macros, and hidden assumptions. For those of us who cut our teeth building these models, Excel has been both our most powerful tool and our most persistent constraint.

After fifteen years of pushing Excel to its limits—building models that would make the application groan under the weight of circular references and volatile functions—I discovered what many quantitative professionals eventually realize: the future of financial modeling isn’t in making better spreadsheets. It’s in leaving them behind entirely, or more accurately, transcending their limitations while preserving their computational elegance.

The Excel Paradox in Commercial Real Estate

Commercial real estate professionals have a unique relationship with technology. We’re simultaneously dependent on sophisticated financial analysis and resistant to new technological paradigms. This isn’t born from technophobia but from practical experience.

We’ve seen too many “revolutionary” PropTech solutions promise to transform our industry, only to discover they don’t account for the nuanced realities of waterfall structures, promote calculations, or the dozens of edge cases that make each deal unique.

Excel became the industry standard because it offered something no packaged solution could: infinite flexibility.

• Need to model a ground lease with percentage rent bumps tied to CPI with a collar and a lookback provision? Excel can do that.
• Want to analyze a joint venture with a complex promote structure that includes catch-ups, clawbacks, and preferred returns that compound differently for different investor classes? Excel handles it, albeit with formulas that would make a mathematician weep.

But this flexibility comes at a tremendous cost.

I’ve watched seasoned professionals spend hours debugging a model because someone inadvertently changed a single cell reference. I’ve seen deals delayed because the only person who understood a model’s architecture was on vacation. I’ve observed how models that start clean and elegant inevitably evolve into Frankenstein’s monsters as they’re modified deal after deal, their original logic buried under layers of accommodations and workarounds.

The Mobile Generation Challenge

There’s another dimension to this technological transition that deserves examination: the fundamental shift in how professionals, particularly younger analysts, approach complex problem-solving.

The mobile revolution has conditioned an entire generation to expect immediate answers, visual dashboards, and swipeable insights. While this has democratized access to information, it has also created a troubling side effect—a diminishing capacity or willingness to “dig in” and understand how results are actually derived.

I’ve observed junior analysts who can navigate TikTok’s algorithm-driven content with remarkable sophistication yet struggle to trace through a basic waterfall calculation. They expect answers to materialize instantly, the way Google serves search results or Instagram surfaces relevant content. The idea of spending hours understanding the mechanics of a promote structure or the nuances of a construction interest reserve feels antiquated to professionals raised on apps that prioritize immediate gratification over deep understanding.

This presents both a challenge and an opportunity for web-based financial modeling.

The challenge is clear: if we simply create prettier interfaces that spit out IRRs without revealing their derivation, we risk creating a generation of investment professionals who understand less about their deals than their Excel-wielding predecessors. They might know that a deal yields 18% returns, but not why—or more critically, under what conditions those returns might evaporate.

The opportunity, however, is to use web-based platforms to bridge this gap. Unlike Excel, where understanding the model often requires diving into nested formulas across multiple hidden tabs, web platforms can progressively reveal complexity.

A junior analyst might start by seeing the high-level return metrics, but with a click, they can drill down into the cash flow projections. Another click reveals the rent growth assumptions. Another shows the comparable properties supporting those assumptions. It’s the same rigorous analysis, but presented in a way that aligns with how digital natives consume information—in layers, on-demand, with visual feedback at each step.

I’ve found that building “explanation layers” into web-based models actually improves analytical skills among younger team members.

When every calculation can expand to show its components, when assumptions link directly to source documents, when sensitivity analyses animate to show how changes ripple through the model, complex financial concepts become more accessible without being dumbed down. The platform meets users where they are—expecting immediate, visual feedback—while still demanding they understand the underlying mechanics.

This is particularly critical in commercial real estate, where a single overlooked assumption can mean the difference between a successful investment and a catastrophic loss. The industry can’t afford analysts who treat financial models like Instagram filters—applying them without understanding how they work. Web-based platforms must therefore strike a delicate balance: leveraging the engagement patterns of mobile-first users while maintaining the analytical rigor that sophisticated real estate investment demands.

The Web-Based Revolution That Actually Makes Sense

The transition from Excel to web-based platforms isn’t about abandoning what works—it’s about preserving the mathematical rigor while eliminating the operational friction.

When I began developing web-based financial models for real estate investment firms, I approached it not as a software developer trying to replace Excel, but as a financial modeler trying to transcend its limitations.

The mathematics remain identical. A discounted cash flow calculation works the same whether it’s computed in Excel or JavaScript. The difference lies in everything surrounding that calculation: how users interact with it, how it’s maintained, how it scales, and most importantly, how it integrates into the broader investment process.

Consider a typical investment committee scenario:

• In the Excel world, an analyst emails a 40MB file to committee members.
• Half can’t open it because they’re on different versions of Excel.
• Those who can open it accidentally break links or overwrite formulas. Version control becomes a nightmare—is everyone looking at “IC_Model_v2_FINAL_FINAL_actually_final_CB_edits.xlsx”?
• By the time the meeting starts, no one’s certain they’re all reviewing the same assumptions.

Contrast this with a web-based platform:

• Committee members log into a secure portal and see the exact same interface, with the same real-time data.
• They can adjust assumptions and immediately see the impact on returns, but they can’t accidentally break the underlying logic. The model’s integrity is preserved while its insights become more accessible. Version control is automatic. Audit trails are comprehensive.
• And perhaps most importantly, the intimidation factor disappears—suddenly, non-technical stakeholders who would never open Excel are actively engaging with the analysis.

The evolution from Excel to web-based financial modeling platforms isn’t just a technological upgrade, it’s a fundamental reimagining of how we approach commercial real estate investment analysis. After many years of building models that pushed Excel to its breaking point, I’ve come to see this transition not as abandoning a trusted tool, but more as preserving its analytical rigor while embracing the collaborative, accessible, and scalable possibilities of the web.