CRE Due Diligence Playbook: Sophisticated Shops

The baseline piece on property data for CRE due diligence 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; FDIC commercial real estate lending guidance mirrors what equity investors adapt for speed.

Key Takeaways

  • Run DD as four gates: ownership, occupancy, cash flow, market — in that order.
  • Stress-test rent rolls against tenant-signal data, not only seller attestations.
  • Property-tax assessment trajectory belongs in pro-forma, not only trailing P&L.
  • Off-market deals punish shops without independent data-stack discipline.
  • Environmental runs parallel; property data prevents wasted DD hours on dead deals.

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 for CRE due diligence 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 FDIC CRE guidance 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.

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. Below ~$10M deal size, many shops run stages 1–2 only; above ~$25M, full four-stage runs with data cost under 0.05% of equity.

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.

Frequently Asked Questions

At what deal size does this playbook make economic sense?
Data cost is roughly flat; DD hours scale with complexity. Below ~$10M, stages 1–2 often suffice. Above ~$25M, run all four stages — data spend is negligible vs equity.
How does this compare to institutional bank lender DD?
Banks run procedurally similar, more conservative processes under FDIC/OCC guidance. Equity shops trade some procedure for speed; core-plus strategies often mirror bank-like discipline.
Where does environmental DD fit?
Parallel workstream — Phase I in week one, property-data work aligned to environmental timeline. Dirty sites become their own gate.
How do you handle thin off-market data rooms?
Stages 1–2 lean on independent property and mobility reads; stages 3–4 use benchmarks plus limited seller attestation. Off-market rewards shops with data-stack discipline.
What is the upstream data prerequisite?
Read property data for CRE due diligence first — this playbook assumes parcel truth, refresh, and counterparty mapping are already scoped.