CRE Investment Due Diligence Playbook: What Sophisticated Shops Run

The baseline piece on property data sources for CRE deals covers the data layer. This is the playbook sophisticated shops run from LOI to hard deposit: gated stages, explicit questions, and go/no-go signals, not a longer vendor list. Assets are increasingly available; sequencing separates disciplined firms from hobbyist DD. Real Estate & Property Data anchors stages 1-3; mobility and spend panels extend stage 4. NAIOP research supplies submarket benchmarks; the FDIC's Risk Management Manual of Examination Policies, which includes a section on concentrations in commercial real estate lending, mirrors what equity investors adapt for speed.

What CRE Due Diligence Is and Who Does It

CRE due diligence is the review a buyer or lender runs on a commercial property before committing capital, to find the risks and liabilities tied to the sale. Practitioner guides such as Prophia's overview of the four types of CRE due diligence group the work into financial, legal, physical, and market review. The table maps those four pillars to the four stages in this playbook.

Stage 1. Ownership and Encumbrance Truth

Verify what the seller owns and what claims exist before deep underwriting. Pull property data independently of the seller's title commitment: title still orders, but week-one read kills deals that will not close. Surface chain of title, mortgages, liens, mechanics' liens, and assessment disputes absent from marketing materials. When title takes 30+ days, week-one property truth prevents sunk DD cost.

Stage 1 outputs should land in a single evidence memo with timestamps, not scattered emails. Include assessor parcel ID, recorded owner entities, open mortgage amounts where public, and any tax or assessment appeals flagged in county records. When the seller's marketing name differs from the deed entity, document the mapping before IC sees the deal: confusion here erodes confidence in later stages. Off-market processes skip polished data rooms; independent property pulls become the primary truth source. Cross-read property data sources for CRE deals for field definitions and refresh expectations before you harden stage-gate templates.

Stage 2. Occupancy and Tenant Truth

Test the rent roll. Compare occupancy flags in property files to seller claims; investigate deviations pre-memo. Mobility panels, retail spend, and lease transaction data turn attested rolls into tested reads, 95% occupancy on paper with 40% weekday building presence is not automatically fraud (hybrid work) but must be in the IC narrative. Global mobility supports building-presence tests; retail tenants may need spend panels from competitive benchmarking workflows.

Define tolerance bands for occupancy tests before you see results: otherwise teams debate whether a 12-point gap is material deal by deal. Office assets post-2020 often show lower weekday presence than lease abstracts imply; retail assets should align more tightly unless known remodels disrupted traffic. Document hybrid-work assumptions explicitly when explaining office gaps to lenders. For multi-tenant retail, join tenant rosters to POI polygons and mobility visits by storefront where possible: aggregate building presence hides dead anchors. Stage 2 should produce a one-page variance table: seller claim, independent signal, analyst explanation, and go/no-go recommendation.

Stage 3. Cash-Flow Signal Verification

Start from trailing-12 P&L; layer lease trends on comparables, NAIOP opex benchmarks, and assessment trajectory. Rising assessed value faster than submarket baseline often means higher property tax in year one than seller trailing shows: a common IRR miss. Mirror bank standards from the FDIC's Risk Management Manual of Examination Policies even on equity-only deals when leverage partners are involved.

Stage 3 is where pro-forma honesty separates disciplined shops from optimistic ones. Model property tax as a function of assessment trajectory, not only trailing expense: county reassessment cycles vary by MSA and can move NOI 200-400 bps without a single tenant change. Layer CAM reconciliation patterns from comparable assets when the seller provides incomplete expense history. If leverage is in play, run the same stress assumptions your lender will use before you argue for aggressive proceeds. Keep a versioned assumptions log tied to Real Estate & Property Data pulls so partners can see which tax and comp inputs changed between LOI and hard deposit.

Stage 4. Market and Submarket Positioning

Mobility answers whether worker or consumer traffic trends up or down in the submarket. BLS Business Employment Dynamics surfaces MSA employment shifts; Federal Reserve CRE stress publications provide macro overlay. Origin-destination site selection details mobility mechanics for stage 4. Integrate via real estate industry hub.

Market stage reads should combine supply and demand signals, not only trailing rents. Track permitted units, major employer announcements, and origin-destination shifts into the submarket over twelve- and twenty-four-month windows. A property can look cheap on in-place cap rate while incoming supply and declining daytime population tell a different exit story. Document which macro overlay you used. Fed stress scenarios, local employment, or consumer spend indices: so IC can stress the same variables at approval. When stage 4 contradicts stage 2 occupancy tests, pause for a unified narrative before increasing deposit exposure.

The data behind each gate is covered in property data sources for each stage.

Physical and Environmental Diligence

Physical and environmental work runs beside the four stages rather than inside them, and it needs outside specialists. Two ASTM standards frame most of it.

• Phase I Environmental Site Assessment. ASTM E1527-21 sets out the practice for an environmental site assessment of a parcel of commercial real estate. It must be performed by an environmental professional, and it is designed to help a buyer meet one of the requirements for CERCLA landowner liability protections.
• Property Condition Assessment. ASTM E2018 is a guide for assessing the physical condition of a property's primary improvements through a walk-through survey, document review, and interviews. The resulting report reflects conditions only at the time of the survey, so a long gap before closing is a reason to refresh it.

Diligence Timeline After a Signed PSA

Once the purchase and sale agreement is signed, the diligence clock starts. Practitioner guidance puts a typical diligence period at about a month, with longer periods when documents need more review (Prophia). Rather than hard-coding day counts, sequence the work the way the stages run.

1. Opening days: order title, the Phase I, and the property condition assessment, because they take the longest to come back. Run the independent property-data pull and send the document request list.
2. Middle of the period: test the rent roll against occupancy signals, review leases and estoppels, and rebuild the pro forma with assessment-adjusted taxes.
3. Late period: review third-party reports, reconcile findings against the pro forma, and take a go, renegotiate, or walk recommendation to the investment committee before the deposit goes hard.

Lender View vs Equity Buyer View

Lenders and equity buyers examine the same property for different reasons. A lender underwrites repayment and collateral, so it leans on conservative cash-flow testing in the spirit of the FDIC's Risk Management Manual of Examination Policies and on stress scenarios like those in Federal Reserve stress-test publications. An equity buyer underwrites upside and exit, so it spends more effort on tenant demand, rent growth, and the submarket story, and it moves faster.

CRE Due Diligence Checklist by Pillar

Legal

• Title commitment ordered and chain of title reviewed
• Recorded mortgages, liens, and mechanics' liens identified
• Seller entity matched to the deed owner
• Zoning and permit status confirmed
• Survey reviewed or ordered, with easements noted

Financial

• Rent roll received and compared to occupancy signals
• Leases and estoppel certificates reviewed
• Trailing-12 operating statements reconciled to bank records
• Operating expenses benchmarked to comparable assets
• Property-tax assessment trajectory built into the pro forma
• Lender stress assumptions applied to the pro forma

Physical and environmental

• Property condition assessment ordered
• Phase I environmental site assessment ordered
• Major systems and deferred maintenance costed
• Certificates of occupancy and fire-safety records requested

Market

• Submarket rent and vacancy trend checked against NAIOP benchmarks
• Employment trend checked for the metro
• Supply pipeline and competing projects mapped
• Mobility or foot-traffic trend compared with the rent roll story

Where Shops Typically Skimp (And Regret It)

Three expensive shortcuts: skipping independent encumbrance verification, accepting rent rolls without tenant-signal cross-check, and ignoring assessment trajectory in pro-forma. Each is cheap at DD, costly after close. Our rule of thumb: below about $10M deal size, stages 1-2 are often enough; above about $25M, run all four stages, because data spend is small next to the equity at risk.

When a shortcut saves two days but costs six figures after close, the playbook pays for itself once. Track skip incidents in retrospectives: teams that document which gate was bypassed learn faster than those that blame market conditions generically. Pair skip tracking with Real Estate & Property Data refresh logs so you know whether bad reads came from stale parcels or skipped stages.

Document stage gates in your IC template so velocity-focused teams do not skip occupancy tests under LOI pressure: the playbook only works when checkpoints are mandatory.

Institutionalize the playbook as software-enforced gates, not a PDF on the shared drive. Deal trackers should block stage advancement until evidence files attach: property pull for stage 1, occupancy variance table for stage 2, tax-adjusted pro-forma for stage 3, and submarket mobility summary for stage 4. Partners resist process until one missed encumbrance or tax reassessment costs seven figures: then gates become culture. Train analysts on the upstream property data guide before assigning deal lead roles; the playbook assumes parcel literacy on day one. Revisit gate definitions annually as asset classes shift: office hybrid dynamics and retail media co-tenancy rules evolve faster than legacy checklists.

Share anonymized gate-failure case studies in quarterly training so junior analysts recognize skip patterns before partners do: culture sticks when stories are concrete, not policy-only.