Minimalist feature image comparing Excel and ChatGPT for CRE underwriting. The design shows an Excel spreadsheet card and a ChatGPT workflow card connected by a versus symbol, representing a comparison of features, accuracy, speed, and underwriting applications in commercial real estate.
By Jake Heller June 9, 2026 Uncategorized

Excel vs ChatGPT for CRE Underwriting: Full Comparison

For years, Excel has been the foundation of commercial real estate underwriting. Analysts, brokers, lenders, and investors rely on spreadsheets to evaluate deals, model cash flows, and make investment decisions. Today, things are changing. Artificial intelligence tools are becoming part of daily CRE workflows. As a result, many professionals are asking the same question: which is better, Excel or ChatGPT? The discussion around Excel vs ChatGPT for CRE underwriting is not really about replacing one tool with another. Instead, it is about understanding where each tool performs best and how they can work together.

Excel remains the standard for financial modeling. It provides complete control over assumptions, formulas, and calculations. Most investment firms, lenders, and institutional investors still depend on spreadsheet-based underwriting models. ChatGPT, however, helps with different parts of the process. It can summarize offering memorandums, review rent rolls, identify risks, create investment summaries, and assist with research. Tasks that once took hours can often be completed much faster.

This is why the debate around Excel vs ChatGPT for CRE underwriting has become increasingly important. The best-performing teams are no longer choosing one or the other. They are combining both to improve efficiency while maintaining accuracy. Before comparing strengths and weaknesses, it helps to understand the broader impact AI is already having on business productivity.

Key AI & CRE Productivity Statistics

Artificial intelligence is no longer an experimental technology. Organizations across industries are using it to improve efficiency, reduce repetitive work, and increase productivity.

Here are several important statistics that help explain why AI is attracting so much attention in commercial real estate.

  • McKinsey estimates generative AI could add up to $4.4 trillion annually to the global economy.

  • PwC projects AI could contribute $15.7 trillion to worldwide economic output by 2030.

  • Deloitte research shows many organizations now prioritize AI for operational efficiency and workforce productivity.

  • Real estate firms continue to increase technology investments to improve decision-making and streamline operations.

  • CRE professionals increasingly use AI-assisted workflows for research, document analysis, and reporting tasks.

These numbers do not mean AI replaces skilled professionals. Instead, they highlight a growing trend. Technology is handling more repetitive work while people focus on analysis, judgment, and decision-making.

That trend directly affects underwriting.

Commercial real estate underwriting involves large amounts of data. Teams review property documents, market reports, financial statements, lease information, and operating expenses before making recommendations.

Many of these activities consume significant time.

This is where the comparison between Excel vs ChatGPT for CRE underwriting becomes relevant. Each tool addresses different challenges within the underwriting process.

What CRE Underwriting Actually Requires

Many discussions about AI in real estate focus on technology. However, understanding the actual underwriting process is more important than understanding the tools themselves.

A tool is only valuable if it improves a specific task. Before comparing Excel vs ChatGPT for CRE underwriting, let’s examine what underwriters actually do every day.

Core Tasks Every Underwriter Performs

Commercial real estate underwriting involves much more than entering numbers into a spreadsheet. Most professionals perform several key tasks during the evaluation process.

These often include:

  • Reviewing offering memorandums

  • Analyzing rent rolls

  • Examining trailing twelve-month statements (T-12s)

  • Forecasting revenue and expenses

  • Estimating future cash flows

  • Calculating net operating income (NOI)

  • Evaluating debt terms

  • Testing investment assumptions

  • Preparing investment committee materials

Every property type follows a slightly different process. However, these core activities remain largely consistent across multifamily, office, retail, and industrial assets.

CRE underwriting infographic showing the key tasks involved in evaluating commercial real estate investments, including financial analysis, forecasting, and risk assessment.
A simplified overview of commercial real estate (CRE) underwriting, highlighting the key responsibilities underwriters perform to assess risk, forecast performance, and evaluate investment opportunities.

Why Underwriting Is Still Time-Intensive

Technology has improved dramatically over the past decade. Yet underwriting remains one of the most labor-intensive functions in commercial real estate. One major reason is data quality.

Property information often arrives in multiple formats. Some documents contain structured data. Others require manual review. Analysts frequently spend hours gathering information before they even begin modeling.

Common time-consuming activities include:

  • Copying data from PDFs

  • Reviewing lease abstracts

  • Verifying expense information

  • Organizing market research

  • Building assumption sets

  • Creating reports for decision-makers

Even experienced underwriters can spend significant time preparing information before financial analysis begins.

Where Most Analyst Hours Are Spent

Many CRE professionals assume modeling consumes most underwriting hours. In reality, preparation often takes longer.

The table below illustrates how analyst time is commonly distributed during a typical underwriting assignment.

Typical Time Allocation During CRE Underwriting

Underwriting Task Estimated Time Share
Document Review 25%
Data Collection 20%
Data Cleaning & Validation 15%
Financial Modeling 20%
Market Research 10%
Investment Memo Preparation 10%

As the table shows, only a portion of the process involves actual modeling. Large amounts of time go toward reviewing documents, gathering information, and preparing reports. This is an important distinction when evaluating Excel vs ChatGPT for CRE underwriting.

Excel excels at calculations, forecasting, and financial modeling. It remains one of the most powerful tools available for structured analysis. ChatGPT serves a different purpose. It can help accelerate research, summarize documents, identify trends, and organize information before data enters the underwriting model.

In other words, both tools support underwriting, but they support different stages of the workflow. Understanding this difference helps avoid one of the biggest misconceptions in the industry: expecting AI to replace financial models entirely.

The reality is much more practical. Excel and ChatGPT solve different problems. The firms seeing the best results are using each tool where it delivers the most value.

What Excel Does Best in CRE Underwriting

Even with the rapid growth of AI, Excel remains the backbone of commercial real estate underwriting. Most acquisition teams, lenders, private equity firms, and institutional investors still rely on spreadsheets to evaluate opportunities.

While new technologies can improve efficiency, they have not replaced the need for detailed financial models.

When discussing Excel vs ChatGPT for CRE underwriting, it is important to understand that Excel was specifically built for calculations, data organization, and financial analysis. Those strengths continue to make it an essential tool in CRE.

Many CRE professionals are exploring ways to combine AI with existing Excel models instead of replacing them. This walkthrough shows a practical example of how AI can support spreadsheet-based underwriting.

Why Excel Remains the Industry Standard

Commercial real estate underwriting requires precision. Investors need to understand how a property performs under different scenarios. Lenders need confidence in debt coverage ratios. Investment committees need transparent assumptions.

Excel supports all of these requirements. For decades, firms have built underwriting templates that reflect their investment strategies. These models contain formulas, sensitivity tables, debt calculations, and reporting structures that have been tested over thousands of transactions.

Because of this history, Excel remains deeply integrated into CRE operations.

Most firms already have:

  • Standardized underwriting templates

  • Investment committee models

  • Acquisition models

  • Development models

  • Asset management reporting systems

Replacing these systems would require significant effort and risk. As a result, Excel continues to serve as the primary platform for financial analysis.

Complete Control Over Financial Models

One of Excel’s greatest strengths is flexibility. Underwriters can customize every assumption, formula, and calculation according to the specific property being analyzed.

For example, an analyst evaluating a multifamily acquisition may adjust:

  • Rent growth assumptions

  • Vacancy rates

  • Operating expense inflation

  • Capital expenditure schedules

  • Financing terms

  • Exit cap rates

Every change immediately affects projected returns. This level of control is critical because no two CRE deals are identical.

Unlike standardized software, Excel allows professionals to build models that reflect the unique characteristics of each investment opportunity.

This flexibility is one reason Excel continues to outperform AI tools for detailed financial modeling.

Institutional Acceptance and Auditability

Commercial real estate transactions often involve multiple stakeholders.

A deal may be reviewed by:

  • Analysts

  • Acquisition managers

  • Investment committees

  • Equity partners

  • Lenders

  • Auditors

Every party wants to understand how conclusions were reached. Excel provides a transparent audit trail because users can trace formulas, review assumptions, and verify calculations.

For example, if an investment committee questions projected NOI growth, the analyst can quickly show:

  • Revenue assumptions

  • Expense assumptions

  • Supporting calculations

  • Scenario analysis

This transparency helps build trust.

When comparing Excel vs ChatGPT for CRE underwriting, auditability remains one of Excel’s strongest advantages.

Advanced Financial Modeling Capabilities

Financial modeling is where Excel truly shines. CRE professionals use spreadsheets to perform calculations that require precision and consistency.

Common modeling functions include:

  • Discounted cash flow analysis

  • Internal rate of return (IRR)

  • Net present value (NPV)

  • Equity multiple calculations

  • Debt service coverage ratio calculations

  • Loan amortization schedules

  • Waterfall structures

  • Partnership distributions

These calculations often depend on dozens or even hundreds of interconnected assumptions. Excel manages these relationships efficiently. AI tools can assist with analysis, but they are not designed to replace institutional-quality financial models.

Scenario Analysis and Sensitivity Testing

Real estate investing involves uncertainty. Interest rates change. Occupancy changes. Market rents change. Exit values change. Successful investors evaluate multiple scenarios before making decisions.

Excel makes this process straightforward.

Analysts can test:

  • Best-case scenarios

  • Base-case scenarios

  • Worst-case scenarios

They can also analyze how changes affect returns. For example, a small increase in exit cap rate may significantly reduce projected IRR.

Sensitivity testing helps investors understand risk before committing capital. This remains one of Excel’s most valuable functions in the Excel vs ChatGPT for CRE underwriting discussion.

Integration With Existing CRE Workflows

Another reason Excel remains dominant is its compatibility with existing systems. Most organizations already use spreadsheets throughout the investment lifecycle.

Excel supports:

  • Acquisition underwriting

  • Debt analysis

  • Development modeling

  • Portfolio management

  • Budget forecasting

  • Asset management reporting

Because these workflows already exist, Excel fits naturally into day-to-day operations. Teams do not need extensive retraining. They simply continue using tools they already understand.

Common Excel Models Used by CRE Teams

Different property types require different underwriting approaches. However, several model categories are widely used across the industry.

Most Common Excel Underwriting Models Used in CRE

Model Type Primary Use Complexity Typical Users
Acquisition Model Evaluate property purchases High Investors, Analysts
Multifamily Model Apartment underwriting High Acquisition Teams
Development Model Ground-up projects Very High Developers
Debt Model Loan analysis Medium Lenders
Asset Management Model Portfolio monitoring Medium Asset Managers
Sensitivity Model Risk analysis Medium Investment Committees

These models often become core intellectual property for investment firms. Many organizations spend years refining them.

Biggest Advantages of Excel

Excel continues to dominate underwriting because it provides several practical benefits.

Key advantages include:

  • Complete transparency

  • Full control over formulas

  • Strong auditability

  • Industry-wide acceptance

  • Powerful financial calculations

  • Flexible scenario analysis

  • Easy customization

  • Reliable reporting

These capabilities make Excel extremely difficult to replace. Even firms adopting AI continue to use spreadsheets as their primary financial modeling platform.

Biggest Limitations of Excel

Although Excel remains powerful, it is not perfect. Many underwriting teams face challenges when relying exclusively on spreadsheets.

Common limitations include:

  • Manual data entry

  • Human calculation errors

  • Version control problems

  • Time-consuming document review

  • Duplicate work across teams

  • Slow information gathering

  • Limited automation

For example, an analyst may spend hours reviewing a 100-page offering memorandum before entering data into a model. The calculations themselves may only require a fraction of that time. This is where newer technologies begin to add value.

While Excel remains unmatched for modeling, it struggles with tasks such as document analysis, information extraction, and content creation. These are areas where AI tools can help reduce workload and improve efficiency.

What ChatGPT Does Best in CRE Underwriting

While Excel remains the leader for financial modeling, ChatGPT is changing how CRE professionals handle many of the tasks that happen before and after the model itself. This distinction is important.

The debate around Excel vs ChatGPT for CRE underwriting often assumes both tools are trying to do the same job. In reality, they excel at different parts of the underwriting process.

Excel focuses on calculations and financial projections. ChatGPT focuses on information processing, research, document review, and communication. When used correctly, ChatGPT can significantly reduce the time spent on repetitive tasks that slow down underwriting teams.

How ChatGPT Fits Into Underwriting Workflows

Most CRE professionals spend far more time gathering and reviewing information than actually building models.

Before an analyst enters a single number into Excel, they often need to review:

  • Offering memorandums

  • Rent rolls

  • T-12 statements

  • Property condition reports

  • Market reports

  • Loan documents

  • Lease abstracts

This preparation stage can consume several hours per deal. ChatGPT helps streamline much of this work. Instead of manually reviewing hundreds of pages, users can ask targeted questions and receive structured summaries.

This does not eliminate the need for human review. However, it can make the review process much faster.

Document Summarization and Extraction

One of ChatGPT’s most valuable underwriting uses is document analysis. Commercial real estate deals often come with large document packages.

These may include:

  • Offering memorandums

  • Market studies

  • Environmental reports

  • Due diligence materials

  • Property operating statements

Finding important information manually can be time-consuming.

ChatGPT can quickly identify:

  • Occupancy rates

  • Revenue trends

  • Major risks

  • Deferred maintenance issues

  • Tenant concentration concerns

  • Capital expenditure requirements

This allows analysts to focus on interpretation rather than document hunting. For many firms, this is one of the biggest productivity improvements in the Excel vs ChatGPT for CRE underwriting comparison.

Rent Roll and T-12 Review Assistance

Reviewing rent rolls and T-12 statements is a critical part of underwriting. However, these documents often contain hundreds of data points.

ChatGPT can help identify:

  • Vacancy patterns

  • Expiring leases

  • Unusual expenses

  • Revenue inconsistencies

  • Tenant concentration risks

  • Occupancy trends

For example, an analyst can upload a rent roll and ask:

  • Which leases expire within the next 12 months?

  • Which tenants occupy the most space?

  • Are there unusual rent variations?

  • What risks should I investigate further?

Instead of manually searching through spreadsheets, analysts can quickly focus on areas that require deeper review.

Market Research and Competitive Analysis

Market research is another area where ChatGPT can save significant time.

Underwriters often need information about:

  • Local market conditions

  • Rent growth trends

  • New developments

  • Vacancy rates

  • Comparable properties

  • Economic drivers

Gathering this information from multiple sources can take hours. ChatGPT can help organize findings, summarize reports, and identify key themes.

For example, an analyst evaluating an industrial property may ask ChatGPT to summarize:

  • Industrial demand trends

  • Local employment growth

  • New supply pipelines

  • Major market risks

This creates a faster starting point for investment analysis.

Investment Memo Drafting

Many acquisition teams spend substantial time preparing investment committee materials.

After completing the financial analysis, someone must still summarize:

  • Property details

  • Market conditions

  • Investment strengths

  • Risks

  • Return projections

  • Acquisition recommendations

ChatGPT can significantly reduce drafting time. Instead of starting from a blank page, analysts can generate first drafts that are later reviewed and refined. This helps teams move deals through the approval process faster.

Deal Screening Before Full Underwriting

Not every opportunity deserves a complete underwriting model. Many CRE professionals review dozens of opportunities before selecting a few for deeper analysis.

ChatGPT can help screen opportunities by identifying:

  • Obvious risks

  • Missing information

  • Market concerns

  • Operational issues

  • Questions requiring clarification

This helps acquisition teams prioritize their time more effectively. Rather than fully underwriting every deal, they can focus on the opportunities most likely to move forward.

Creating Investor and IC Summaries

Investment committees often need concise summaries rather than detailed spreadsheets.

ChatGPT can convert large amounts of information into clear reports that highlight:

  • Key assumptions

  • Financial performance

  • Major risks

  • Market conditions

  • Investment rationale

This improves communication between analysts, executives, and investors. As deal volume increases, this capability becomes increasingly valuable.

Biggest Advantages of ChatGPT

ChatGPT provides several benefits that complement traditional underwriting workflows.

Key advantages include:

  • Faster document review

  • Faster research

  • Improved report drafting

  • Better information organization

  • Reduced repetitive work

  • Quick summaries of large files

  • Enhanced productivity

  • Easier knowledge access

These strengths make ChatGPT particularly useful during the early stages of underwriting. Many firms are finding that combining ChatGPT with Excel creates a more efficient process than relying on spreadsheets alone.

Biggest Limitations of ChatGPT

Despite its strengths, ChatGPT has important limitations. Understanding these limitations is essential when comparing Excel vs ChatGPT for CRE underwriting.

Common challenges include:

  • Hallucinated information

  • Limited financial modeling capabilities

  • Lack of built-in audit trails

  • Difficulty handling highly customized models

  • Dependence on prompt quality

  • Need for human verification

Most importantly, ChatGPT should never be treated as a final source of truth. All outputs must be reviewed and verified before being used in investment decisions.

For example, if ChatGPT summarizes a rent roll or identifies projected risks, analysts should confirm those findings against the original documents.

The technology is best viewed as an assistant rather than a replacement for professional judgment.

ChatGPT Tasks That Save the Most Time for CRE Teams

The greatest value often comes from reducing repetitive administrative work.

ChatGPT Tasks That Save the Most Time for CRE Teams

Task Manual Time AI-Assisted Time Typical Savings
OM Review 60–90 min 10–20 min 70–80%
Rent Roll Summary 45–60 min 10–15 min 65–75%
T-12 Review 45–60 min 10–15 min 65–75%
Market Research Summary 2–3 hrs 30–45 min 70–80%
Investment Memo Draft 1–2 hrs 15–30 min 70–85%
Deal Screening 30–45 min 5–10 min 70–80%

These estimates vary by property type and workflow. However, they illustrate why AI adoption is growing across commercial real estate firms. The key takeaway is simple. Excel remains the better tool for modeling and calculations.

ChatGPT excels at research, document review, summarization, and communication. The most productive underwriting teams use both.

Excel vs ChatGPT for CRE Underwriting: Side-by-Side Comparison

By now, it should be clear that Excel and ChatGPT serve different purposes. Excel is designed for structured financial analysis. ChatGPT is designed for processing information, generating insights, and assisting with repetitive tasks.

However, many CRE professionals still want a direct comparison. If you had to choose between the two, which one would perform better for underwriting?

The answer depends entirely on the task. Let’s compare them across the areas that matter most to commercial real estate professionals.

Speed

Speed is one of the main reasons AI adoption is growing. Traditional underwriting often involves reviewing large documents before any modeling begins.

An analyst may spend hours reading offering memorandums, organizing data, and creating reports. ChatGPT can reduce much of this workload.

For example:

  • Summarizing a 100-page OM

  • Reviewing rent rolls

  • Extracting property information

  • Drafting investment memos

These tasks can often be completed in minutes instead of hours. Excel, on the other hand, is only as fast as the person using it. Data must still be entered, organized, and analyzed manually.

Winner: ChatGPT

Accuracy

Accuracy is critical in underwriting. A small error can change projected returns and affect investment decisions. Excel performs calculations consistently when formulas are built correctly. Results can also be audited and verified.

ChatGPT does not calculate investment returns with the same reliability. It may occasionally generate incorrect assumptions or inaccurate information. For this reason, AI outputs always require human review. When precision matters most, Excel remains the safer choice.

Winner: Excel

Financial Modeling

Financial modeling is where Excel dominates.

Commercial real estate models often include:

  • Monthly cash flows

  • Debt schedules

  • Waterfalls

  • Sensitivity tables

  • Partnership structures

  • Exit analyses

Excel was built specifically for this type of work. ChatGPT can explain calculations and help build formulas, but it is not designed to serve as a full underwriting model. Most institutional investors still require spreadsheet-based analysis.

Winner: Excel

Document Analysis

Commercial real estate transactions generate large volumes of documentation. Reviewing these materials manually takes time.

ChatGPT can quickly summarize:

  • Offering memorandums

  • Market reports

  • Lease abstracts

  • T-12 statements

  • Due diligence reports

Excel is not designed for document analysis. As a result, ChatGPT has a major advantage in this category.

Winner: ChatGPT

Reporting

Investment committees, lenders, and equity partners often need written summaries.

These reports explain:

  • Property performance

  • Risks

  • Opportunities

  • Investment recommendations

Creating these materials manually can take significant time. ChatGPT can generate first drafts within minutes. Excel can produce charts and reports, but writing remains largely manual.

Winner: ChatGPT

Collaboration

Collaboration requirements vary by organization. Many firms already use Excel-based workflows that multiple team members understand. Spreadsheet models can be reviewed, audited, and shared across departments.

ChatGPT improves collaboration by helping teams communicate information more efficiently. However, it does not replace established underwriting processes. In most firms, Excel remains the primary collaboration platform for deal analysis.

Winner: Excel

Scalability

As deal volume grows, efficiency becomes increasingly important. A team reviewing 10 deals per month faces different challenges than a team reviewing 100 deals.

ChatGPT can help scale:

  • Document review

  • Initial screening

  • Research

  • Reporting

Excel scales well for modeling, but does not reduce preparation work.

As transaction volume increases, AI often provides greater operational leverage.

Winner: ChatGPT

Learning Curve

Most CRE professionals already know Excel. Universities, certification programs, and employers have relied on spreadsheets for decades. ChatGPT is relatively easy to learn, but effective prompting still requires practice.

For experienced analysts, Excel usually feels more familiar. For newer professionals, ChatGPT may be easier to adopt. Overall, both tools are accessible, but Excel benefits from widespread industry familiarity.

Winner: Tie

Cost

Cost is another important consideration. Excel is typically included within Microsoft 365 subscriptions already used by most firms. ChatGPT requires an additional subscription cost.

However, when measured against labor savings, many teams find the cost relatively small. The real question is not software pricing. The real question is whether time savings justify the investment. For most active acquisition teams, the answer is often yes.

Winner: Depends on workflow

Compliance and Audit Requirements

Institutional investors require transparency.

Investment decisions must often be supported by documented assumptions and verifiable calculations.

Excel provides:

  • Formula visibility

  • Version tracking

  • Auditability

  • Structured review processes

ChatGPT does not provide the same level of financial transparency. For regulated environments and institutional reporting, Excel remains the preferred option.

Winner: Excel

Excel vs ChatGPT Feature Comparison for CRE Underwriting

Excel vs ChatGPT Feature Comparison for CRE Underwriting

Feature Excel ChatGPT Winner
Financial Modeling Excellent Limited Excel
IRR & NPV Analysis Excellent Limited Excel
Sensitivity Analysis Excellent Limited Excel
Document Review Poor Excellent ChatGPT
Rent Roll Analysis Good Excellent ChatGPT
T-12 Review Good Excellent ChatGPT
Market Research Fair Excellent ChatGPT
Investment Memo Writing Limited Excellent ChatGPT
Auditability Excellent Limited Excel
Institutional Acceptance Excellent Limited Excel
Speed for Research Fair Excellent ChatGPT
Speed for Calculations Excellent Fair Excel

Which Tool Wins Overall?

The comparison reveals something important. There is no single winner in the Excel vs ChatGPT for CRE underwriting debate. Each tool solves a different problem.

Excel remains the clear leader for:

  • Financial modeling

  • Cash flow projections

  • Debt analysis

  • Sensitivity testing

  • Investment committee reviews

ChatGPT leads in:

  • Research

  • Document analysis

  • Information extraction

  • Report writing

  • Deal screening

The most effective underwriting teams do not replace Excel with ChatGPT. Instead, they use ChatGPT to reduce manual work and Excel to perform the financial analysis that drives investment decisions.

Before vs After Productivity Comparison

The biggest benefit of combining AI with underwriting is not replacing analysts. It is helping analysts spend more time on decisions and less time on repetitive tasks. To understand the impact, let’s compare a traditional underwriting process with a workflow that combines Excel and ChatGPT.

As more teams look to reduce manual work, many are building an automated underwriting system that combines AI-driven document analysis with traditional Excel modeling.

Traditional Excel-Only Workflow

A conventional underwriting process typically follows these steps:

  1. Receive the offering memorandum.

  2. Review all property documents manually.

  3. Extract rent roll information.

  4. Review T-12 statements.

  5. Gather market research.

  6. Build assumptions.

  7. Populate the underwriting model.

  8. Create an investment memo.

  9. Present findings to decision-makers.

This process works well.

However, much of the time is spent preparing information rather than analyzing it.

Excel Plus ChatGPT Workflow

A modern underwriting workflow looks different.

  1. Upload property documents.

  2. Generate document summaries.

  3. Extract key property data.

  4. Identify risks and missing information.

  5. Build assumptions faster.

  6. Populate Excel model.

  7. Generate draft investment memo.

  8. Review and verify outputs.

  9. Finalize recommendations.

The financial model still lives in Excel.

The difference is that the preparation work becomes significantly faster.

Time Savings Breakdown

The value of combining Excel and ChatGPT becomes clearer when we look at actual workflow improvements. Most underwriting teams do not struggle with building models. They struggle with everything that happens before and after the model.

Document review, data gathering, research, and reporting often consume more time than the financial analysis itself. When ChatGPT handles portions of those tasks, analysts can spend more time evaluating deals and less time processing information.

The result is faster underwriting without sacrificing model quality.

Underwriting Workflow Time Comparison

Task Excel Only Excel + ChatGPT
OM Review 60–90 min 10–20 min
Rent Roll Analysis 45–60 min 10–15 min
T-12 Review 45–60 min 10–15 min
Market Research 2–3 hrs 30–45 min
Data Organization 30–45 min 10–15 min
Investment Memo Draft 1–2 hrs 15–30 min
Initial Deal Screening 30–45 min 5–10 min
Total Time Per Deal 6–9 hrs 2–4 hrs

These estimates vary based on deal complexity. However, the pattern remains consistent. The greatest savings come from reducing manual review and administrative work. Financial modeling still requires human oversight, but the preparation process becomes much more efficient.

For active acquisition teams evaluating dozens of deals each month, these savings can add up quickly. A team reviewing 40 deals per month could potentially save dozens of hours every week.

That time can then be spent on:

  • Better due diligence

  • More market analysis

  • Additional deal sourcing

  • Investor communication

  • Portfolio strategy

This is why many firms are moving beyond the question of Excel vs ChatGPT for CRE underwriting and focusing instead on how to combine both effectively.

Infographic comparing Excel-only and Excel plus ChatGPT underwriting workflows, showing faster deal analysis and reduced processing time.
A visual comparison of traditional Excel-based underwriting and an AI-assisted workflow, showing how ChatGPT helps reduce manual work and accelerate commercial real estate deal analysis.

Real-World CRE Use Cases

The benefits of combining Excel and ChatGPT become easier to understand when viewed through actual commercial real estate scenarios. Different property types create different underwriting challenges.

Some require extensive lease analysis. Others involve operational complexity or large amounts of market data. The following examples show where AI-assisted workflows can provide practical value.

Multifamily Acquisition Analysis

Multifamily underwriting often involves large rent rolls and detailed operating statements.

An acquisition analyst may need to review:

  • Unit mix

  • Occupancy trends

  • Historical collections

  • Operating expenses

  • Renovation opportunities

ChatGPT can quickly summarize rent roll data and highlight potential issues. The analyst can then transfer verified information into an Excel model for detailed projections. This approach reduces preparation time while maintaining model accuracy.

Retail Property Underwriting

Retail properties often involve complex lease structures.

Underwriters may need to evaluate:

  • Anchor tenants

  • Percentage rent clauses

  • Lease expiration schedules

  • Tenant credit quality

  • Co-tenancy provisions

Reviewing these documents manually can be time-intensive. ChatGPT can help summarize lease information and identify clauses that deserve closer attention. Excel remains responsible for forecasting future cash flows and investment returns.

Office Investment Evaluation

Office underwriting often requires a deep understanding of tenant risk.

Analysts must assess:

  • Lease rollover schedules

  • Occupancy trends

  • Tenant concentration

  • Market demand

  • Future leasing assumptions

ChatGPT can organize lease information and summarize market reports. Excel then converts those assumptions into financial projections. Together, the tools create a faster workflow without compromising analytical rigor.

Industrial Property Screening

Industrial properties frequently attract large volumes of investor interest. Acquisition teams may need to evaluate numerous opportunities in a short period.

ChatGPT can assist with:

  • Initial document review

  • Market summaries

  • Tenant analysis

  • Risk identification

This allows teams to eliminate weaker opportunities before investing significant underwriting resources. Excel remains the final evaluation tool once a deal passes initial screening.

Debt and Lending Analysis

Lenders also benefit from AI-assisted workflows.

Loan underwriting requires reviewing:

  • Borrower information

  • Property performance

  • Debt coverage metrics

  • Market conditions

ChatGPT can summarize borrower packages and supporting documentation. Loan officers can then focus on financial analysis, risk assessment, and approval decisions. This improves efficiency while preserving underwriting standards.

Investment Committee Preparation

Many analysts spend substantial time preparing materials for investment committees.

A typical IC package may include:

  • Property overview

  • Market analysis

  • Risk assessment

  • Financial projections

  • Investment recommendation

Creating these reports manually can take several hours. ChatGPT can generate initial drafts that analysts review and refine. This helps teams move opportunities through the approval process more efficiently.

How to Implement Excel and ChatGPT Together in 24 Hours

Many CRE professionals understand the benefits of AI but are unsure where to begin. The good news is that implementation does not require a complete overhaul of existing systems. In most cases, firms can begin improving productivity within a single day.

The goal is simple:

Keep Excel for modeling and use ChatGPT for repetitive information-processing tasks. For a deeper look at how leading firms structure their process, check out our guide on an AI underwriting workflow that breaks down each step from document review to final deal analysis.

Step 1: Identify Bottlenecks

Start by examining your current underwriting process.

Ask yourself:

  • Which tasks consume the most time?

  • Which activities are repetitive?

  • Where do delays typically occur?

For many teams, common bottlenecks include:

  • OM review

  • Rent roll analysis

  • Market research

  • Memo preparation

These are often ideal candidates for AI assistance.

Step 2: Select Repeatable Tasks

Not every task should be delegated to AI.

Focus on activities that follow a predictable process.

Examples include:

  • Summarizing documents

  • Extracting key property information

  • Organizing research

  • Drafting reports

Keep financial calculations inside Excel. This ensures accuracy and auditability.

Step 3: Build Prompt Templates

Consistency matters.

Instead of creating new prompts for every deal, develop reusable templates.

Examples include:

  • OM summary prompts

  • Rent roll review prompts

  • Market analysis prompts

  • Risk assessment prompts

  • Investment memo prompts

Standardized prompts improve output quality and save time.

Step 4: Create Review Procedures

Every AI-generated output should be verified.

Establish review processes that require analysts to:

  • Validate key figures

  • Confirm assumptions

  • Cross-check summaries

  • Review recommendations

AI should support decision-making, not replace professional judgment.

Step 5: Standardize Outputs

Consistency improves efficiency.

Create standard formats for:

  • Deal summaries

  • Risk reports

  • Market analyses

  • Investment recommendations

Standardized outputs make information easier to review and compare.

Step 6: Train Team Members

Even simple AI workflows require basic training.

Team members should understand:

  • Effective prompting

  • Verification procedures

  • Data privacy guidelines

  • Workflow expectations

Training helps ensure adoption across the organization.

Step 7: Measure Results

Track performance after implementation.

Monitor:

  • Time saved per deal

  • Deals reviewed per month

  • Analyst productivity

  • Reporting efficiency

Measuring results helps justify future investments in AI-assisted workflows.

Implementation Checklist

Before launching an AI-assisted underwriting process, make sure you have:

  • Standard prompt library

  • Data review procedures

  • Verification requirements

  • Team training materials

  • Security policies

  • Approved workflows

  • Performance metrics

Firms that follow a structured implementation process typically see better results than those adopting AI without clear guidelines.

Copy-Paste ChatGPT Prompts for CRE Underwriting

One of the biggest reasons CRE professionals get inconsistent results from AI is poor prompting. Many users ask vague questions and receive vague answers. A better approach is to create structured prompts that follow the same process every time.

This improves consistency, accuracy, and efficiency. The following prompts are designed to complement Excel-based underwriting workflows. They help analysts gather information faster while keeping financial modeling inside the spreadsheet.

Rent Roll Review Prompt

Use this prompt when reviewing a rent roll before entering information into your underwriting model.

Prompt:

Act as a senior commercial real estate acquisitions analyst. Review the rent roll below and identify the following:

  • Largest tenants by leased area

  • Lease expirations within the next 12 months

  • Occupancy percentage

  • Tenant concentration risks

  • Unusual rent variations

  • Potential underwriting concerns

Present findings in a clear table and include recommendations for additional due diligence.”

T-12 Analysis Prompt

This prompt helps identify operating trends and potential risks.

Prompt:

“Review the following trailing 12-month operating statement and provide:

  • Revenue trends

  • Expense trends

  • Largest expense categories

  • Unusual operating costs

  • Potential red flags

  • Questions requiring clarification

Summarize findings in bullet-point format suitable for an acquisition team.”

OM Summary Prompt

Offering memorandums often contains dozens of pages of information. This prompt helps create a quick first-pass review.

Prompt:

“Review the attached offering memorandum and create a summary covering:

  • Property overview

  • Location highlights

  • Occupancy statistics

  • Tenant information

  • Financial performance

  • Value-add opportunities

  • Major investment risks

Keep the summary under 500 words and use acquisition analyst language.”

Investment Memo Prompt

Many teams spend significant time preparing investment committee materials. This prompt creates a strong first draft.

Prompt:

“Using the information provided, draft an investment committee summary including:

  • Executive summary

  • Property description

  • Market overview

  • Financial highlights

  • Investment strengths

  • Key risks

  • Recommendation

Write in a professional tone suitable for institutional real estate investors.”

Market Analysis Prompt

Market research can become overwhelming without structure.

Prompt:

“Act as a commercial real estate market analyst. Summarize the following market information and provide:

  • Key demand drivers

  • Employment trends

  • Population trends

  • New supply pipeline

  • Vacancy trends

  • Rent growth outlook

  • Major risks

Provide a concise investment-focused summary.”

Risk Identification Prompt

Every deal has risks.

The goal is to identify them early.

Prompt:

“Review the attached property information and identify:

  • Financial risks

  • Leasing risks

  • Market risks

  • Tenant risks

  • Capital expenditure concerns

  • Due diligence items requiring further investigation

Rank risks by severity and explain why each matters.”

Debt Sizing Prompt

Debt assumptions can significantly impact returns. This prompt helps organize financing discussions.

Prompt:

“Based on the property information below, identify factors that could affect debt sizing and financing terms. Include:

  • Cash flow stability

  • Occupancy considerations

  • Tenant quality

  • Property condition

  • Market conditions

  • Potential lender concerns

Present findings in a lender-focused format.”

Acquisition Recommendation Prompt

Use this prompt before preparing a final investment recommendation.

Prompt:

“Act as an acquisitions director reviewing this opportunity. Based on the information provided:

  • Summarize strengths

  • Summarize weaknesses

  • Highlight major risks

  • Identify missing information

  • Recommend next steps

  • Provide a preliminary investment opinion

Keep the analysis objective and evidence-based.”

What Most CRE Professionals Get Wrong About AI

Artificial intelligence is becoming more common in commercial real estate. However, many professionals still misunderstand how it should be used. As a result, they either expect too much from AI or fail to use it where it can provide the most value.

Understanding these mistakes is important when evaluating Excel vs ChatGPT for CRE underwriting.

Expecting AI to Replace Excel

This is probably the most common misconception. Some people assume ChatGPT can replace underwriting models entirely.

In reality, financial modeling still requires:

  • Structured calculations

  • Sensitivity analysis

  • Auditability

  • Formula transparency

  • Institutional reporting

These remain Excel’s strengths. AI helps support underwriting, but it does not replace the model itself. The most successful teams use both tools together.

Blindly Trusting Outputs

AI can produce impressive answers. However, impressive does not always mean accurate. ChatGPT occasionally generates incorrect information, incomplete conclusions, or unsupported assumptions.

This is why verification remains essential. Every output should be reviewed before it influences an investment decision. Experienced analysts treat AI as an assistant, not a final authority.

Ignoring Verification Processes

Some firms adopt AI without establishing review procedures. This creates unnecessary risk.

A better approach includes:

  • Human review requirements

  • Data validation steps

  • Approval processes

  • Documentation standards

These safeguards help maintain underwriting quality while still benefiting from automation.

Using Generic Prompts

Prompt quality directly affects output quality. A vague request often produces vague results.

For example:

Poor prompt:

“Analyze this property.”

Better prompt:

“Review this rent roll and identify tenant concentration risks, lease rollover exposure, and occupancy concerns.”

Specific prompts create more useful outputs.

Focusing on Tools Instead of Workflows

Many professionals spend too much time comparing software. The more important question is how work gets done. Technology alone does not improve productivity. Well-designed workflows improve productivity.

Instead of asking:

“Which tool is better?”

Ask:

“Which process becomes faster and more accurate with this tool?”

That mindset usually produces better results.

Underestimating Training Requirements

AI is not completely self-explanatory.

Teams still need guidance on:

  • Prompt creation

  • Verification methods

  • Security standards

  • Workflow integration

Organizations that invest in training typically see stronger adoption and better outcomes. The technology may be easy to access, but effective implementation requires planning.

Tools That Actually Work vs Hype

The commercial real estate technology market is crowded. Every year, new AI platforms promise faster underwriting, better forecasting, and automated decision-making. Some deliver real value.

Others generate more marketing excitement than practical results. Understanding the difference helps firms invest their time and money more effectively.

Excel

Excel remains one of the most valuable tools in commercial real estate.

Its strengths include:

  • Financial modeling

  • Cash flow forecasting

  • Debt analysis

  • Sensitivity testing

  • Institutional reporting

Despite all the AI innovation in the market, Excel continues to be the foundation of most underwriting processes.

ChatGPT

ChatGPT provides value in areas where spreadsheets are less effective.

Its strengths include:

  • Document review

  • Research assistance

  • Report drafting

  • Information organization

  • Deal screening

For many teams, it delivers the greatest productivity gains outside the financial model.

Claude

Claude has gained popularity for analyzing long documents.

Many users prefer it when reviewing:

  • Lease agreements

  • Due diligence reports

  • Offering memorandums

  • Market studies

Its ability to process large amounts of information makes it useful during underwriting preparation.

Excel AI Add-Ins

Microsoft continues adding AI functionality to Excel.

These tools can help with:

  • Formula generation

  • Data analysis

  • Spreadsheet assistance

  • Productivity improvements

While promising, most firms still rely on traditional Excel workflows for core underwriting functions.

Purpose-Built CRE AI Platforms

A growing number of companies now offer AI tools specifically for commercial real estate.

Potential benefits include:

  • Property data integration

  • Automated extraction

  • Specialized workflows

  • Industry-specific reporting

However, firms should evaluate these platforms carefully before replacing existing processes.

Practical Value vs Marketing Hype

Practical Value vs Marketing Hype

Tool Type Real Value Hype Level Best Use Case
Excel Very High Low Financial Modeling
ChatGPT High Medium Research & Document Review
Claude High Medium Long Document Analysis
Excel AI Features Moderate Medium Spreadsheet Assistance
CRE AI Platforms Varies High Specialized Workflows
Fully Automated Underwriting Claims Low to Moderate Very High Limited Real-World Use

The strongest takeaway remains consistent throughout the Excel vs ChatGPT for CRE underwriting discussion. The best technology stack is rarely a single tool.

Instead, high-performing CRE teams combine proven financial models with AI-assisted workflows to increase efficiency while maintaining accuracy and control.

Cost Comparison and ROI Analysis

Technology investments should produce measurable business value. That is especially true in commercial real estate, where margins matter, and teams are expected to operate efficiently.

When evaluating Excel vs ChatGPT for CRE underwriting, cost is often one of the first questions decision-makers ask. However, software pricing alone does not tell the whole story. The more important question is whether a tool saves enough time to justify its cost.

Excel Licensing Costs

Most CRE firms already use Microsoft 365. As a result, Excel is typically viewed as an existing business expense rather than a new investment. For many organizations, underwriting models have been built and refined over the years.

This means the direct software cost is relatively low compared to the value generated.

Additional costs may include:

  • Model development

  • Staff training

  • Template maintenance

  • Quality control reviews

However, these costs are usually spread across multiple teams and projects.

ChatGPT Subscription Costs

ChatGPT requires an additional subscription. Compared with salaries, acquisition costs, and software budgets, the expense is relatively small. The real value comes from time savings.

If an analyst saves several hours each week through document review, research assistance, and memo drafting, the return can quickly exceed the subscription cost.

For active acquisition teams, productivity improvements often matter far more than subscription fees.

Analyst Time Savings

Labor is one of the largest expenses in underwriting. Highly skilled analysts spend significant time on tasks that do not directly contribute to investment decisions.

Examples include:

  • Reviewing documents

  • Organizing information

  • Preparing summaries

  • Drafting reports

These activities are necessary, but they can be time-consuming.

When ChatGPT reduces those tasks, analysts can spend more time on:

  • Deal evaluation

  • Market analysis

  • Due diligence

  • Investor communication

This shift often creates the largest return on investment.

Small Team ROI Example

Consider a small acquisitions team consisting of:

  • One acquisitions manager

  • Two analysts

Assume each analyst saves four hours per week through AI-assisted workflows.

That equals:

  • 8 hours saved per week

  • 32 hours saved per month

  • Nearly 400 hours saved annually

Those hours can be redirected toward sourcing and evaluating additional opportunities. For many firms, even one extra successful acquisition can justify the investment many times over.

Mid-Sized CRE Firm ROI Example

Now consider a larger organization with:

  • Five acquisition analysts

  • Multiple markets

  • High transaction volume

If each analyst saves five hours per week:

  • 25 hours saved weekly

  • Over 100 hours saved monthly

  • More than 1,200 hours saved annually

The cumulative productivity impact becomes substantial. More deals can be screened. Reports can be produced faster. Teams can scale without immediately increasing headcount.

Enterprise Adoption Considerations

Large organizations face additional considerations.

These may include:

  • Security requirements

  • Data governance policies

  • Compliance standards

  • Internal approval processes

Enterprise adoption often requires more planning than small-team implementation. However, the potential productivity gains are also larger because improvements can affect dozens of employees simultaneously.

Annual Cost and ROI Comparison

Annual Cost and ROI Comparison

Item Excel ChatGPT Combined Stack
Software Cost Low Low to Moderate Moderate
Financial Modeling Capability Excellent Limited Excellent
Research Efficiency Fair Excellent Excellent
Document Review Speed Fair Excellent Excellent
Reporting Efficiency Moderate Excellent Excellent
Time Savings Potential Moderate High Very High
Overall ROI Potential High High Very High

The numbers make one thing clear. The real opportunity is not choosing between Excel and ChatGPT. The greatest value comes from combining them.

When Excel Is Better Than ChatGPT

Although AI continues to improve, there are many situations where Excel remains the superior tool. These situations usually involve precision, transparency, and financial calculations.

Institutional Acquisitions

Large investment firms often have strict underwriting standards.

Models must be reviewed by:

  • Acquisition teams

  • Investment committees

  • Equity partners

  • Lenders

Excel provides the structure and transparency these organizations require. This is one reason institutional underwriting remains heavily spreadsheet-driven.

Detailed Financial Modeling

Complex real estate transactions involve numerous variables.

Examples include:

  • Preferred equity structures

  • Waterfalls

  • Construction financing

  • Partnership distributions

  • Multi-phase developments

Excel handles these relationships effectively. ChatGPT can assist with explanations and analysis, but it cannot replace a fully customized institutional model.

Audit-Heavy Organizations

Many organizations require complete visibility into calculations.

Reviewers need to understand:

  • How numbers were calculated

  • Which assumptions were used

  • How projections were developed

Excel provides this transparency. Every formula can be reviewed and tested. This level of auditability remains one of Excel’s biggest advantages.

Investment Committee Review Requirements

Investment committees often expect:

  • Detailed models

  • Supporting assumptions

  • Sensitivity analyses

  • Scenario testing

These materials are typically built within Excel. While ChatGPT can help summarize findings, the underlying financial analysis usually remains spreadsheet-based.

Infographic showing key CRE underwriting situations where Excel outperforms AI, including institutional acquisitions, financial modeling, and audit compliance.
A visual overview of the underwriting scenarios where Excel remains the preferred tool, including institutional acquisitions, complex financial modeling, and audit-heavy real estate organizations.

When ChatGPT Is Better Than Excel

There are also situations where ChatGPT clearly outperforms spreadsheets. These tasks generally involve processing information rather than calculating returns.

Early Deal Screening

Acquisition teams often review far more opportunities than they ultimately pursue.

ChatGPT can help identify:

  • Missing information

  • Potential risks

  • Key property details

  • Follow-up questions

This allows analysts to focus their time on the most promising opportunities.

Research and Market Intelligence

Research can consume hours each week.

ChatGPT helps organize:

  • Market trends

  • Economic drivers

  • Property information

  • Industry insights

This creates a faster starting point for underwriting and investment analysis.

Document Summaries

Large commercial real estate transactions generate extensive documentation.

ChatGPT can quickly summarize:

  • Offering memorandums

  • Lease abstracts

  • Market reports

  • Due diligence materials

Instead of searching through hundreds of pages, analysts can focus on reviewing the most relevant information.

Investor Communication

Communicating investment opportunities often requires written content.

Examples include:

  • Executive summaries

  • Investment memos

  • Market updates

  • Portfolio reports

ChatGPT can significantly reduce drafting time while improving consistency.

Repetitive Writing Tasks

Many underwriting activities involve repeating similar explanations.

Examples include:

  • Risk summaries

  • Property descriptions

  • Market commentary

  • Investment recommendations

AI performs these tasks efficiently, allowing analysts to spend more time on higher-value work.

The Future of CRE Underwriting

The future of underwriting is unlikely to be Excel-only or AI-only. Instead, it will combine both. Technology will continue improving, but professional judgment will remain essential. The firms that adapt successfully will focus on enhancing analysts rather than replacing them.

AI-Augmented Analysts

The modern analyst is becoming more productive.

Instead of spending hours organizing information, analysts can focus on:

  • Critical thinking

  • Investment strategy

  • Risk assessment

  • Decision-making

AI handles more of the administrative workload, while people handle the analysis.

Automated Document Extraction

Document review is already becoming faster.

Future systems will likely extract:

  • Lease information

  • Operating data

  • Property characteristics

  • Market insights

With minimal manual effort.

This will shorten underwriting timelines even further.

AI-Powered Model Population

One of the most promising developments is automated model preparation.

Future workflows may allow AI to:

  • Extract property data

  • Organize assumptions

  • Prepare inputs

  • Populate underwriting templates

Analysts will still review the results, but preparation time may decline significantly.

Workflow Automation Across Teams

The biggest gains may come from workflow integration.

Instead of isolated tools, organizations will connect:

  • Research

  • Underwriting

  • Asset management

  • Reporting

  • Investor communications

This could reduce duplicate work and improve efficiency across the investment lifecycle.

Why Excel Is Unlikely to Disappear

Despite advances in AI, Excel continues to offer advantages that are difficult to replace.

These include:

  • Formula transparency

  • Flexibility

  • Industry acceptance

  • Auditability

  • Financial modeling power

For these reasons, Excel is likely to remain a core underwriting tool for years to come.

What Underwriting May Look Like by 2030

By 2030, many underwriting teams may operate differently than they do today.

Analysts could spend less time gathering information and more time evaluating opportunities.

AI may handle:

  • Data extraction

  • Initial screening

  • Report drafting

  • Information organization

Meanwhile, Excel and similar modeling platforms will continue supporting financial analysis and investment decisions.

The future of Excel vs ChatGPT for CRE underwriting is not a competition.

It is a partnership where each tool contributes its unique strengths to create a faster, smarter, and more scalable underwriting process.

Conclusion

The discussion around Excel vs ChatGPT for CRE underwriting often starts with the wrong question. Many professionals ask which tool is better. The more useful question is which tool is better for a specific task. Throughout this comparison, one pattern remains clear.

Excel continues to be the foundation of commercial real estate underwriting. It provides the financial modeling capabilities, transparency, auditability, and flexibility that acquisition teams, lenders, and institutional investors require.

For cash flow forecasting, debt analysis, sensitivity testing, and investment committee reviews, Excel remains the industry standard. At the same time, ChatGPT is helping underwriting teams become more efficient.

It can summarize offering memorandums, review rent rolls, analyze T-12 statements, organize research, identify risks, and draft reports in a fraction of the time required through manual processes. These capabilities do not replace underwriting models.

Instead, they reduce the administrative workload surrounding those models. The most successful firms are not choosing between Excel and ChatGPT. They are combining both.

A practical workflow often looks like this:

  • ChatGPT reviews and summarizes documents.

  • ChatGPT helps organize research and assumptions.

  • Excel performs financial analysis.

  • ChatGPT assists with reporting and communication.

  • Analysts review and verify all outputs.

This approach allows professionals to spend less time gathering information and more time making investment decisions. As AI adoption continues to grow across commercial real estate, firms that learn how to integrate these tools effectively will likely gain a competitive advantage.

The future of Excel vs ChatGPT for CRE underwriting is not about replacement. It is about building a workflow where each tool handles the work it does best.

Join CRE Professionals Using AI the Right Way

Want access to CRE-specific AI workflows, prompt libraries, video tutorials, training programs, and a database of 600+ AI tools?

Join the AI for CRE Collective and learn from professionals already using proven systems instead of guessing what works.

Community

Newsletter

Common Questions About Excel vs ChatGPT for CRE Underwriting

Is ChatGPT replacing Excel in commercial real estate underwriting?

No. ChatGPT is not replacing Excel in commercial real estate underwriting. Excel remains the preferred platform for financial modeling, cash flow projections, sensitivity analysis, and investment committee reporting.

ChatGPT serves a different purpose. It helps analysts process information faster by assisting with:

  • Document review

  • Market research

  • Rent roll summaries

  • T-12 analysis

  • Investment memo drafting

Most CRE firms use Excel as the financial engine and ChatGPT as a productivity tool. Rather than replacing spreadsheets, AI helps reduce the time spent on repetitive tasks surrounding the underwriting process. For the foreseeable future, Excel and AI will likely work together rather than compete directly.

Can ChatGPT build a complete CRE underwriting model?

ChatGPT can assist with building underwriting models, but it should not be relied upon to create a complete institutional-quality model without review.

It can help:

  • Explain formulas

  • Suggest model structures

  • Generate calculation logic

  • Identify underwriting assumptions

However, professional underwriting models require:

  • Accurate formulas

  • Auditability

  • Sensitivity testing

  • Debt calculations

  • Return projections

These functions are still best handled in Excel. Analysts should always verify any AI-generated calculations before using them in investment decisions.

Which is more accurate for CRE underwriting, Excel or ChatGPT?

For financial calculations, Excel is generally more accurate. Excel performs calculations based on formulas that can be reviewed and tested. If the formulas are correct, the results are consistent and transparent.

ChatGPT, on the other hand, generates responses based on patterns in data. While often helpful, it can occasionally produce incorrect information or unsupported conclusions.

A practical approach is:

  • Use Excel for calculations.

  • Use ChatGPT for research and summaries.

  • Verify all AI-generated outputs.

This combination provides both accuracy and efficiency.

How much time can ChatGPT save during underwriting?

The amount of time saved depends on the workflow and property type.

Many CRE professionals report significant reductions in time spent on:

  • Offering memorandum reviews

  • Rent roll analysis

  • Market research

  • Investment memo drafting

  • Initial deal screening

In many cases, tasks that previously required one to three hours can be reduced to 15 to 45 minutes. Teams reviewing a high volume of deals often experience the largest benefits because repetitive tasks occur more frequently. The greatest productivity gains usually come from information processing rather than financial modeling.

Is ChatGPT safe for confidential CRE deal information?

Data security should always be considered before uploading confidential information to any AI platform.

Organizations should review:

  • Company policies

  • Client agreements

  • Privacy requirements

  • Regulatory obligations

Many firms establish guidelines regarding what information can be shared with AI tools.

Best practices include:

  • Removing sensitive information

  • Avoiding confidential identifiers

  • Following internal compliance standards

  • Using approved platforms

Security policies vary by organization, so users should consult their firm’s requirements before using AI with confidential deal data.

What CRE tasks should remain in Excel?

Excel remains the preferred tool for tasks requiring structured financial analysis.

Examples include:

  • Cash flow modeling

  • IRR calculations

  • NPV analysis

  • Debt modeling

  • Waterfall calculations

  • Sensitivity analysis

  • Budget forecasting

These activities depend on transparent formulas and precise calculations. Institutional investors, lenders, and acquisition teams continue to rely on Excel because it provides auditability and flexibility. For detailed underwriting, spreadsheets remain difficult to replace.

What CRE tasks should move to ChatGPT?

ChatGPT is most useful for information-heavy tasks that consume analyst time.

Examples include:

  • Document summaries

  • Market research

  • Risk identification

  • Rent roll reviews

  • T-12 reviews

  • Report drafting

  • Deal screening

These activities involve organizing and interpreting information rather than performing financial calculations. Using AI for these tasks allows analysts to focus more attention on investment decisions and less on administrative work.

Can small CRE firms benefit from ChatGPT?

Yes. Small firms often benefit significantly because they typically operate with limited staff and resources.

AI can help small teams:

  • Review more opportunities

  • Produce reports faster

  • Conduct research efficiently

  • Improve consistency

Instead of hiring additional staff immediately, firms may be able to increase productivity using AI-assisted workflows. For many small organizations, the return on investment can be substantial because even modest time savings have a meaningful impact on operations.

How do institutional investors use AI in underwriting?

Most institutional investors use AI as a supplement rather than a replacement for existing underwriting processes.

Common applications include:

  • Document analysis

  • Market research

  • Data extraction

  • Reporting assistance

  • Workflow automation

Financial modeling generally remains in Excel or specialized underwriting software. Institutional firms often prioritize auditability and transparency, making spreadsheet-based analysis essential even when AI is incorporated into the workflow.

What are the biggest risks of AI-assisted underwriting?

The primary risks include:

  • Inaccurate outputs

  • Hallucinated information

  • Overreliance on automation

  • Inadequate verification

  • Data security concerns

These risks can be managed through strong review processes.

Best practices include:

  • Human oversight

  • Output verification

  • Standardized workflows

  • Clear approval procedures

AI should support underwriting decisions, not replace professional judgment.

Should analysts learn AI if they already know Excel?

Yes. Excel remains one of the most valuable skills in commercial real estate. However, AI literacy is becoming increasingly important.

Analysts who understand both tools can:

  • Work more efficiently

  • Process information faster

  • Improve reporting

  • Review more opportunities

The strongest professionals are often those who combine traditional financial modeling expertise with modern productivity tools. Learning AI does not replace Excel skills. It complements them.

What is the best workflow using Excel and ChatGPT together?

For most acquisition teams, the most effective workflow combines the strengths of both tools.

A common process looks like this:

  1. Use ChatGPT to summarize documents.

  2. Use ChatGPT to organize research.

  3. Extract key assumptions.

  4. Build financial models in Excel.

  5. Verify calculations.

  6. Use ChatGPT to draft reports.

  7. Review all outputs before final decisions.

This approach improves efficiency while maintaining the accuracy and transparency required for commercial real estate underwriting.

Leave a Reply

Your email address will not be published. Required fields are marked *