AI in Commercial Real Estate

November 20, 2026

Excel AI Plugins vs Cloud Underwriting Platforms for CRE: Where Plugins Stop

Blog Details Image

Your analysts already work in spreadsheets, so an AI plugin inside the workbook is the easiest tool to roll out. The trouble starts a month later, when five analysts have five versions of the same deal, nobody can say which file is current, and no one can show where a number came from. That risk is measured: in  Spreadsheet Errors: What We Know. What We Think We Can Do., an arXiv paper posted in February 2008, Raymond Panko of the University of Hawaii reports that field audits found errors in 24% of the 367 spreadsheets audited, and that the most recent audits found errors in at least 86% of the spreadsheets they examined. AI that drafts faster inside the same file does not remove that exposure on its own.

Smart Capital Center's agentic AI keeps your team's Excel models and adds what a single workbook cannot hold: one shared deal record, source links on every figure, and an edit log. That means:

•     Your analysts keep their models: they work in the Excel files they trust, pre-filled with deal data.

•     Your team gets one current version: no more guessing which file is right before a decision.

•     Your work carries forward: figures feed memos and asset management instead of being rebuilt.

This post defines Excel AI plugins, shows what they do well, shows where they stop, compares them with a cloud underwriting platform, and explains how teams can have both. It is part of our guide to What Is AI Underwriting? How It Works in Commercial Real Estate Lending and Investing.

What Is an Excel AI Plugin for CRE Underwriting?

An Excel AI plugin for CRE underwriting is an assistant that works inside a workbook, so your analysts get AI help without leaving the model they already use. It reads the open file, drafts formulas, fills a template from an uploaded document, and answers questions about the workbook.

Why Do Analysts Adopt Excel AI Plugins So Quickly?

Analysts adopt plugins quickly because nothing about their habits has to change. A technology leader at a large CRE investment firm described the pattern this way:

“One thing that has been adopted really well as a tool internally, probably the best adoption that we've seen internally of any AI tool so far, has been just this Excel plugin tool that basically allows the analyst to continue to operate in Excel. Because that's their preference, that's the habit that they've formed.” A technology leader at a large CRE investment firm.

That adoption is a real advantage and a fair reason to start with a plugin. The question for a team is what happens after the first month, when the habit spreads across many analysts and many deals.

What Do Excel AI Plugins Do Well for CRE Underwriting?

Plugins save an individual analyst time on routine spreadsheet work. They handle three jobs well:

•     Drafting formulas: an analyst describes the calculation and the plugin writes it, which helps with debt service, waterfall and rollover logic.

•     Filling a template from an uploaded file: a rent roll or T-12 goes in and the plugin populates the matching cells.

•     Answering quick questions about one workbook: an analyst asks why a cell changed or what drives a return and gets an answer in plain language.

Looking How Claude for Excel Handles CRE Underwriting Models

How Do Claude for Excel and Copilot in Excel Handle CRE Underwriting Models?

General AI assistants inside Excel, including Claude for Excel and Copilot in Excel, give your analysts fast help with the mechanics of a model: formulas, formatting, summaries and questions about the open workbook. They are built for any spreadsheet, so the CRE judgment (which rent roll line is stale, which comparable fits, how a lender would size the loan) still comes from your analyst.

Used well, they shorten routine work on a single deal. They stop where all workbook-bound tools stop: they work on what is in the file, and they do not hold a shared record of the deal for your team. The next section covers those limits in detail.

What Is the Best Excel Plugin for CRE Underwriting and Cash Flow Models?

The best Excel plugin for CRE underwriting and cash flow models is the one that passes your own test on your own deals, so run the same recent deal through each option and compare the output. Judge each against your template, your documents, and the questions your credit or investment committee asks.

This post does not rank plugins, because the answer depends on what your team needs after the formula is written. Ask these five questions of any option:

•     Does it read your firm's model template without rebuilding it?

•     Can it show where each filled-in number came from in the source document?

•     Does it record who changed what, and when?

•     Does the deal data stay available to the whole team after the file is saved?

•     Does borrower data stay inside systems your firm controls?

A plugin that answers yes to the first question and no to the rest is a good personal tool. A team that needs all five is choosing a different category, covered below.

Where Do Excel AI Plugins Fall Short for CRE Underwriting Teams?

Plugins fall short at the team level, because the work product is a file on one analyst's machine. Five gaps show up as the number of analysts and deals grows.

Why Does Every Analyst's File Become Its Own Version?

A workbook has no shared deal record behind it. Two analysts who start from the same OM end up with two models, and a manager has no single place to see the current version of a deal.

Does the AI Check Its Work Against Source Documents?

A plugin works on whatever is in the file. If a misread rent roll line is already in the workbook, the plugin builds on it, because it has no comparison against the original document and no confidence score telling the analyst which figures to recheck.

Who Changed Which Number, and Why?

A workbook rarely keeps a log of who changed an input, when, and for what reason. In committee, "where did this cap rate come from" then depends on someone's memory.

What Happens to the Data After the Workbook Is Saved?

Data stops at the workbook. The memo, the asset management plan and portfolio reporting each pull numbers out of the file again, usually by hand, so the same work is done more than once.

Where Does Borrower Data Go When Files Are Uploaded?

Borrower files may end up outside the firm's controlled systems when analysts upload them to individual tools. A technology lead cannot govern what no one has a record of.

These gaps are documented well beyond CRE. The table lists three public cases and studies, each from a named source.

Source and date Finding Why it matters for CRE underwriting
Panko, Spreadsheet Errors, arXiv, February 2008 Field audits found errors in 24% of 367 spreadsheets, and the most recent audits found errors in at least 86%. Rent roll and T-12 workbooks carry the same risk, and a plugin edits them in place.
Public Health England statement, October 4, 2020 15,841 cases from September 25 to October 2, 2020 were left out of reporting because a file exceeded its maximum size. A file limit hid data from the people who needed it. Teams cannot see what a workbook silently drops.
U.S. Senate Permanent Subcommittee on Investigations, JPMorgan Chase Whale Trades, March 15, 2013 Trading losses of at least $6.2 billion; the subcommittee found that a new VaR model dramatically lowered the portfolio's reported risk profile and recommended scrutiny of any model that lowers reported risk. A model that changes without review can change the answer. An audit log makes each change reviewable.

 

The Senate case concerns trading risk models, not CRE plugins. It is included because it shows what happens when a model changes without independent review, which is the control an edit log provides.

What Does a Cloud Underwriting Platform Add to Excel?

A cloud underwriting platform gives your team one accurate record of every deal, so decisions rest on the right numbers. Smart Capital Center's agentic AI adds six capabilities that a single workbook cannot hold:

•     One deal record for the whole team: documents, figures and versions sit in one place, so everyone works from the same deal.

•     Version control and edit logs: each change records who made it and when.

•     Extraction with source links and confidence scores: every figure links to its source page, and low-confidence items are flagged for the analyst.

•     Scenarios side by side: your team compares cases without copying workbooks.

•     Memos drawn from the same data: credit and investment memos use the deal record, so nothing is retyped.

•     Data that carries into asset management: the deal record continues after close, backed by 120M+ properties, 1B+ live market data points and $500B+ analyzed transactions.

Results from firms using this approach: KeyBank Real Estate Capital cut financial model prep time by 40%, and Centers Dynamic Partners underwrites deals 4x faster with Smart Capital Center. Smart Capital Center is SOC 2 Type II certified, and client data is never shared or used to train models for other clients.

Wharton professor Kartik Hosanagar made the broader point at the Wharton Scale School session How to Scale Smarter with AI Agents and Automation, recorded April 22, 2026:

“Investments in CRM, ERP, digitization alone weren't enough. Workflows have to change, people have to be upskilled, organizations have to reinvent themselves.” Kartik Hosanagar, Professor at the Wharton School, How to Scale Smarter with AI Agents and Automation, Wharton Scale School, April 22, 2026

A tool that sits on one analyst's desktop improves one analyst's workflow. A shared deal record changes how the team works, which is the point Hosanagar makes.

Excel AI Plugin vs Cloud Underwriting Platform: Which Is Better for CRE Teams?

A plugin is better for one analyst working a few deals, and a cloud underwriting platform is better for a team underwriting many deals and carrying them into asset management. The table compares them on the six points that decide most team purchases.

CRE deal record

‍

Figure 1. Excel AI plugin alone vs Smart Capital Center with Excel sync, across six team-level criteria. See how Smart Capital Center handles underwriting

Criterion Excel AI plugin Cloud underwriting platform with Excel sync
Version control Each analyst's file is its own version One deal record with version control
Source traceability Works on the contents of the file, with no check against source documents Figures link to the source page, with confidence scores
Team access Files shared by email or folder The whole team works from the same record
Audit trail No log of who changed which number Edit log shows who changed what and when
Data security Depends on each user's upload habits SOC 2 Type II certified; client data is never shared or used to train models for other clients
Downstream reporting Data stops at the workbook Same data feeds memos, asset management and portfolio reporting

 

Which Fits Whom: One Analyst or a Whole Team?

•     One analyst working a few deals: a plugin is enough. The analyst owns the file, so version and audit questions stay small.

•     A team underwriting many deals: a shared record matters, because the cost of a wrong or stale file multiplies with each analyst.

•     A firm carrying deals into asset management: data that continues past close saves the rebuild that follows every acquisition.

For leaders, the larger gain is consistency. You get consistent underwriting across every analyst, not just faster individuals.

What Are the Leading Excel-Based Platforms for Private Equity Underwriting?

The leading Excel-based platforms for private equity underwriting are the ones that keep the Excel model and add a shared record behind it. For a private equity real estate team, that means your analysts keep their own models while the fund keeps one accurate version of every deal.

This post does not name or rank vendors. Instead, test any option on four points: whether it fills your template, links every figure to its source, records edits, and carries the deal into asset management and investor reporting. Our comparison post, Top CRE Investment Underwriting Software and Automation Platforms Compared, covers how to evaluate tools in the category.

Can CRE Teams Keep Their Excel Models and Still Use a Cloud Underwriting Platform?

Yes. Your analysts keep working in their own Excel models, and your team still works from one accurate record. Smart Capital Center fills the firm's model with deal data, and when the edited file is re-uploaded, Smarty, the AI assistant inside the platform, syncs the changes back.

Laura Krashakova, Founder & CEO of Smart Capital Center, described the choice analysts have:

“In fact, you can continue working in your own underwriting model the way you have it right now... You have a choice. You can work right here or you can work in Excel. And your Excel will already have all data pre-populated there with historical data, maybe some initial pro forma data.” Laura Krashakova, Founder & CEO, Smart Capital Center.

She also described where she sees the market heading, based on what lenders are asking for:

“Ultimately in the future, I do believe people will start moving away from Excel for many reasons. And we've seen it already now with some lenders, especially private lenders and debt funds. They do want to have data inside the system, all of the data, all different versions of underwriting there. The reason for that is data, accuracy of data, and being available to all different team members, different versions of underwriting.” Laura Krashakova, Founder & CEO, Smart Capital Center.

The sync means no one has to choose between a habit and a standard. Analysts keep the model they trust, and managers get the shared record they need.

working in CRE spredsheets

What Risks Should CRE Teams Plan for When Choosing Between an Excel Plugin and a Platform?

Three risks matter most, and each looks different to an acquisitions team and a credit team. Each has a mitigation inside Smart Capital Center.

Risk 1: A stale model drives an investment committee decision

An acquisitions team approves a bid on a version of the model that an analyst has since changed. Because each file is its own version, nobody notices until after the committee vote. Smart Capital Center mitigates this through one shared deal record with version control, so the committee sees the current version.

Risk 2: A misread rent roll figure flows into the credit file

A lender sizes a loan on net operating income built from a figure that was misread from a rent roll or T-12. A plugin working on the workbook has nothing to compare against, so the error looks like any other input. Smart Capital Center mitigates this through extraction with source links and confidence scores, so low-confidence figures are flagged and every number traces to its source page.

Risk 3: Borrower files sit outside the firm's controlled systems

A credit or technology lead cannot show where confidential borrower files were uploaded, which becomes a problem in a regulator or counterparty review. Individual uploads leave no firm-level record. Smart Capital Center mitigates this through a SOC 2 Type II certified environment where client data is never shared or used to train models for other clients.

How Can My CRE Team Test an Excel Plugin Against a Cloud Platform?

Run both on the same recent deal and score the results. Six steps keep the test fair:

1.     Pick one closed deal with a complete file: OM, rent roll, T-12 and your standard model.

2.     Fill your template with each option and time how long each takes from upload to a usable model.

3.     Check ten figures against the source documents. Note whether the tool shows you where each came from.

4.     Have a second analyst edit the model and see whether the first analyst can tell who changed what, and when.

5.     Draft the memo from the result and count how many numbers you retype.

6.     Ask your technology lead where the borrower files went, and whether the vendor can state that client data is never used to train models for other clients.

Smart Capital Center satisfies all six: it fills your model, links each figure to its source, keeps an edit log, drafts the memo from the same record, and keeps client data private. Book a test on your own deal in a demo.

What Should CRE Teams Take Away From the Excel Plugin vs Platform Choice?

Excel plugins make individual analysts faster, and a shared deal record makes the whole team consistent. Both are worth having, and the Excel sync means you do not have to pick one.

Smart Capital Center keeps your analysts in the Excel models they trust while your team works from one accurate version of every deal, with each figure traceable to its source.

Keep your analysts in their Excel models and give your team one current version of every deal. Book a demo with Smart Capital Center →

Frequently Asked Questions

Q: How can I keep my team's Excel models and still get one source of truth for every deal?

A: Use a platform that fills your model with deal data and syncs edits back when the file is re-uploaded, so analysts keep working in the models they trust and the team works from one accurate record instead of many versions. Smart Capital Center does this through Smarty, the AI assistant inside the platform.

Q: How can I tell whether an Excel AI plugin is enough for my CRE team?

A: Count your analysts and your deals. If one analyst works a few deals, a plugin is usually enough. If a team underwrites many deals and carries them into asset management, you will need a shared record, version control and an edit log.

Q: How can I check that AI in Excel did not misread a rent roll?

A: Compare filled-in figures to the source pages and look for confidence scores. A workbook-bound plugin works on what is in the file, so you check by hand. Smart Capital Center links each figure to its source page and flags low-confidence items, so your analyst rechecks only what needs it.

Q: Can I trust an Excel AI plugin with confidential borrower files?

A: Check where each upload goes and who controls it. Individual plugin use can place borrower files outside your firm's controlled systems. Ask any vendor whether it is SOC 2 Type II certified and whether client data is ever shared or used to train models for other clients.

Q: How can I move deal data from Excel into memos and asset management without retyping it?

A: Keep the deal data in one record that feeds each output, so the work done at underwriting is not rebuilt after close. Smart Capital Center drafts credit and investment memos from the same data and carries the deal record into asset management.

Q: How long before my team sees a difference after adding a cloud underwriting platform?

A: Most teams can judge the fit in one test on a recent deal. Compare the model, the source links and the memo with your current process. KeyBank Real Estate Capital cut financial model prep time by 40%, and Centers Dynamic Partners underwrites deals 4x faster with Smart Capital Center.

‍

Author's photo

Written by

Luis Leon

November 20, 2026