AI in Commercial Real Estate
November 20, 2026
AI in Commercial Real Estate
November 20, 2026

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.
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.
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.
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.

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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.

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
• 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.
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.
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.

Three risks matter most, and each looks different to an acquisitions team and a credit team. Each has a mitigation inside Smart Capital Center.
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.
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.
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.
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.
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 →
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.

November 20, 2026