Apers vs. Microsoft Copilot for CRE Modeling

Overview

Microsoft Copilot is built into Office 365 and works inside Excel, Word, and PowerPoint. It can suggest formulas, format data, create charts, and answer questions about your spreadsheet. If your firm already pays for Microsoft 365, Copilot is included — making it the most accessible AI assistant for Excel users.

Apers is a CRE-specific system that generates complete Excel workbooks from deal descriptions or documents via its Excel modeling engine. It doesn't work inside your existing spreadsheet — it creates new ones, pre-populated with institutional-grade formulas, tab structure, and deal-type-specific modeling.

The comparison is between a horizontal spreadsheet assistant and a vertical deal modeling system. Both involve AI and Excel. The similarity ends there.

Different Tools, Different Jobs

Table 1 — Copilot is a spreadsheet assistant. Apers is a deal modeling system. The distinction is scope: Copilot helps with cells, Apers generates complete models.

Excel Modeling

Copilot excels at small-scale spreadsheet tasks. "Write a formula to calculate DSCR in column F based on NOI in column D and debt service in column E" — and Copilot will produce the right formula. "Create a chart showing NOI growth over 10 years" — done. For individual formula assistance and data visualization, Copilot is genuinely useful.

What Copilot cannot do is build a complete financial model. It doesn't know that a multifamily acquisition model should have separate tabs for assumptions, unit mix, revenue, expenses, capital expenditures, cash flow, debt, returns, waterfall, and sensitivity. It doesn't understand that the waterfall tab needs to reference the returns tab which references the cash flow tab which references the revenue and expense tabs which reference the assumptions tab. This architectural knowledge — what makes a model institutionally structured rather than a collection of formulas on a single sheet — is exactly what CRE-specific tools provide.

Ask Copilot to "build a waterfall with an 8% preferred return and a 70/30 promote above a 12% IRR hurdle" and it won't know where to start. Not because the AI isn't capable — but because Copilot wasn't trained on deal modeling. It was trained on spreadsheet operations.

Document Handling

Copilot works inside your open applications. It can summarize a Word document or analyze data in an open Excel file. It cannot read a PDF offering memorandum, extract the rent roll, reconcile it against a trailing-12, and populate a financial model.

This matters because institutional underwriting starts with documents, not with spreadsheets. The OM arrives as a PDF. The rent roll is a PDF. The T-12 is a PDF. Getting from those documents to a populated Excel model is the bottleneck — and Copilot doesn't participate in that workflow at all.

Feature Comparison

Table 2 — Feature comparison. Copilot wins on cell-level formula assistance. Apers wins on everything that requires CRE domain knowledge or complete model generation.

When Copilot Works

• Formula assistance. "Write a SUMIFS formula for..." — Copilot handles this well. For analysts who know what they want to calculate but need help with Excel syntax, Copilot is genuinely useful.
• Data summarization. "Summarize this rent roll data" or "What's the average rent by unit type?" Copilot can analyze an open spreadsheet and answer questions about it.
• Formatting and presentation. Creating charts, formatting tables, cleaning up a spreadsheet for presentation — these are Copilot's strengths.
• You already have the model. If your team has strong templates and the model already exists, Copilot can help you work faster inside it. It's an efficiency tool for existing workflows.

When Apers Wins

• Building models from scratch. If you're starting from a deal description or a stack of documents and need a complete, institutional-quality Excel model, Copilot can't help. Apers generates the entire workbook.
• Deal-type-specific modeling. LIHTC basis calculations, waterfall distributions, development draws, multi-tranche debt sizing — these require CRE training, not spreadsheet assistance.
• Document-to-model pipeline. Getting from a PDF offering memorandum to a populated Excel model is the core workflow. Copilot doesn't read PDFs; Apers starts from them.
• Volume underwriting. Screening 20 deals a week means generating 20 models a week. With Copilot, you build each manually with formula help. With Apers, you describe the deal and get the model — including full sensitivity analysis.

Verdict

Copilot and Apers aren't really competitors — they solve different problems at different levels. Copilot makes you faster inside a spreadsheet. Apers eliminates the need to build the spreadsheet manually in the first place.

Many Apers users also use Copilot. They generate the model in Apers, open it in Excel, and use Copilot to customize formulas, add charts, or reformat for presentation. The tools are complementary when used this way.

The question is where your bottleneck lives. If it's individual formula construction, Copilot helps. If it's building complete models from deal documents, Copilot doesn't participate in that workflow — and that's the workflow Apers was built to replace. For more comparisons, see our full comparison overview or our breakdown of the best AI for real estate Excel.