Cash Flow Portal logo
Cash Flow Portal logo
Products
Solutions
Resources
About
Commercial real estate underwriting guide

Commercial real estate underwriting, from first look to deal decision

Learn how CRE teams review documents, forecast NOI, model debt, compare scenarios, analyze investor returns, and use AI underwriting software to move faster without losing control of the source data.

Underwriting workspace

Broker packet uploadedRent roll + T-12 + OM
Parsed source dataReady for review
Active scenariosBase upside
Waterfalls7% pref, 80/20 split
Deal exportsReady to share
Projected NOI$1.84M
Exit cap5.75%
DSCR1.42
Equity multiple2.1x
Definition

What is commercial real estate underwriting?

Commercial real estate underwriting is the decision process behind an acquisition, refinance, development, or capital raise. In an AI underwriting software workflow, teams turn imperfect property information into a defensible view of risk, returns, financing, and whether the deal should advance.

The underwriting question

Does the property, purchase price, debt structure, business plan, and exit assumption create enough risk-adjusted return for the sponsor, investors, and lenders involved?

The modern workflow

Instead of moving between PDFs, Excel models, chat prompts, and email, teams can keep parsed source data, assumptions, AI assistant context, scenarios, waterfalls, and exports in one underwriting workspace.

Decision quality

Why commercial real estate underwriting matters?

CRE deals are high-stakes decisions. A small mistake in a rent roll, expense classification, tax reassessment, loan term, exit cap rate, or waterfall assumption can change whether a deal still works after diligence.

Sponsors and acquisition teams

Underwriting helps teams decide whether to spend more time on a deal, submit an offer, raise capital, or pass before diligence time gets expensive.

Lenders

Lenders use the underwriting package to evaluate whether the property's income, leverage, reserves, and downside cushion can support the proposed loan.

Investors and partners

Investors need to understand why the investment case makes sense, which assumptions drive returns, and what risks could change the outcome.

Process

The commercial real estate underwriting process

Strong underwriting is not one spreadsheet tab. It is a sequence of source-data review, modeling decisions, risk tests, and communication artifacts.

01

Collect the deal packet

Gather the rent roll, T-12, offering memorandum, debt quote, capex plan, market comps, tax information, insurance estimates, lease data, and diligence files.

02

Normalize source data

Review occupancy, lease dates, in-place rent, market rent, concessions, historical income, expenses, missing rows, and which source numbers should flow into the pro forma.

03

Forecast property performance

Build the pro forma around rent growth, vacancy, concessions, other income, taxes, insurance, payroll, repairs, utilities, management fees, reserves, and CapEx.

04

Model debt and capital needs

Add purchase price, loan amount, interest rate, amortization, interest-only periods, refinance assumptions, reserves, lender fees, and capital-stack decisions.

05

Test returns and downside cases

Compare IRR, equity multiple, cash-on-cash return, debt yield, DSCR, cap rate, yield on cost, sale proceeds, waterfalls, and downside sensitivities.

06

Package the investment decision

Share reports, lender exports, partner updates, pitch deck sections, investor summaries, and the assumptions behind the go or no-go decision.

Metrics

Key CRE underwriting metrics teams pressure-test

The exact model depends on asset type and strategy, but these metrics show up in most commercial real estate underwriting discussions.

NOI

Net operating income is the property-level income left after operating expenses, before debt service and capital events. It anchors valuation, cap rate, DSCR, and many return calculations.

Cap rate

Capitalization rate compares NOI to purchase price or valuation. A low cap rate can reflect stronger markets or lower risk, while a high cap rate may reflect higher yield or operational risk.

DSCR

Debt service coverage ratio measures whether projected income can support the proposed debt payments. Tight DSCR leaves less room for income, expense, or interest-rate surprises.

LTV

Loan-to-value compares loan amount to property value. Higher leverage can improve returns when a deal performs, but it reduces the margin for error.

IRR

Internal rate of return estimates time-weighted investor returns across acquisition, operations, distributions, refinance events, and exit.

Equity multiple

Equity multiple shows total cash returned relative to invested equity, making it easier to compare hold-period outcomes.

Cash-on-cash return

Cash-on-cash return compares annual cash flow to invested equity, helping teams understand current income yield during the hold period.

Debt yield

Debt yield compares NOI to loan amount. Lenders use it as another way to evaluate credit risk without relying only on property value.

Yield on cost

Yield on cost compares stabilized NOI to total project cost, making it useful for renovation, development, and value-add business plans.

Sensitivity

Sensitivity analysis pressure-tests purchase price, exit cap, rent growth, expense growth, renovation timing, debt terms, and waterfall assumptions.

Modern underwriting stack

Where AI underwriting software fits

The best use of AI is not a magic answer. It is faster document intake, visible source-data review, cleaner model setup, and context-aware help while the team still owns the investment call.

Excel, generic AI, or underwriting software

Why a connected workflow matters

Excel is flexible and familiar, and generic AI can help with quick explanations or summaries. The harder problem is keeping source data, assumptions, scenario changes, approvals, and exports aligned as the deal changes.

Spreadsheet and generic AI workflow

  • Source data is retyped or copied from PDFs into tabs.
  • Chat answers are separated from the model and documents.
  • Scenario files drift as reviewers request changes.
  • Waterfalls, feeder funds, and exports often become separate workbooks.

Cash Flow Portal workflow

  • AI parsing turns rent rolls, T-12s, and OMs into editable source data.
  • The model, AI assistant, scenarios, and diligence context live on the same deal.
  • Sensitivity analysis and metric-basis views support faster downside review.
  • Reports, pitch materials, waterfalls, and feeder-fund outputs stay tied to the model.
Checklist

Commercial real estate underwriting checklist

Before relying on a model, review the source data, assumptions, financing, downside cases, and outputs that drive the investment decision.

01Source trail
02Operating case
03Risk test
04Decision package
Source trail

Confirm the data that enters the model

  • Confirm the latest rent roll and T-12 are loaded and reviewed.
  • Check whether expense classifications match your team's assumptions.
  • Separate seller pro forma assumptions from buyer underwriting assumptions.
Operating case

Review the assumptions that move NOI

  • Review vacancy, concessions, bad debt, and loss-to-lease.
  • Validate tax, insurance, payroll, repairs, utilities, and management fee assumptions.
Risk test

Pressure-test capital, debt, and downside cases

  • Confirm debt terms, interest-only periods, amortization, reserves, and refinance assumptions.
  • Run sensitivity analysis on exit cap rate, rent growth, expense growth, and debt terms.
  • Review waterfall, fee, and feeder-fund assumptions if the capital structure is complex.
Decision package

Tie the outputs back to the active scenario

  • Make sure exports and investment materials match the active scenario.
  • Keep a clear record of who reviewed source data and when assumptions changed.
FAQ

Commercial real estate underwriting questions

Quick answers for teams comparing documents, metrics, AI help, and underwriting software before they trust a model.

01

What is commercial real estate underwriting?

Commercial real estate underwriting is the process of reviewing a property, documents, assumptions, debt, risks, and projected returns to decide whether a deal is worth pursuing.

02

What documents are used in CRE underwriting?

Most teams start with a rent roll, trailing 12-month operating statement, offering memorandum, lease data, debt terms, capex plan, market comps, tax information, insurance estimates, and diligence files.

03

What is the most important metric in CRE underwriting?

NOI is usually the starting point because it affects valuation, cap rate, DSCR, and return projections. It is not enough by itself, so teams also evaluate income, expenses, debt, capital structure, exit assumptions, and sensitivity cases together.

04

Can AI underwrite commercial real estate deals?

AI can speed up document parsing, source-data review, classification, question answering, and scenario setup. It should not make the investment decision on its own; the best AI underwriting workflows keep humans in control and make assumptions easier to review.

05

Why use underwriting software instead of Excel?

Excel is flexible, but underwriting software helps keep source data, scenarios, permissions, AI context, exports, and collaboration tied to the same deal record.

Trusted and recognized

Best estimated return on investment in Summer 2024Best meets requirements in Summer 2024Best results in total in Summer 2024Best usability in Summer 2024Users most likely to recommend in Summer 2024Fastest implementation and go-live time in Summer 2024Easiest admin in Summer 2024Easiest to set up in Summer 2024Easiest to use in Summer 2024Highest user adoption in Summer 2024Leader in Summer 2024Best support and quality of support in Summer 2024
System and Organization Controls (SOC) for Service Organizations
G2
Five star ratings
G2- out of 5
Capterra
Five star ratings
Capterra- out of 5
Backed by Y Combinator
Ready to get started?
Expand your deal pipeline with AI-powered underwriting.
Flexible pricing
Plans for new and established GPs.
See pricing
Generate new leads
The only purpose-built CRM that generates new leads.
New leads
Footer background texture