What Is a Due Diligence Report?
A due diligence report is the formal document that summarizes the findings of a due diligence investigation. In commercial real estate, it is the deliverable that tells an acquisitions team — and ultimately the investment committee — whether a property is worth acquiring, what the risks are, and what they should expect after closing.
The due diligence report compiles analysis across multiple areas — financial performance, lease terms, tenant quality, legal standing, environmental condition, physical state, and operational efficiency — into a single, structured document that drives the investment decision.
A well-prepared due diligence report does three things:
- Confirms the investment thesis — Validates (or contradicts) the assumptions behind the deal
- Identifies risks — Surfaces issues that could affect value, cash flow, or operational performance
- Provides a basis for negotiation — Documents findings that may justify price adjustments, repair credits, or deal term modifications
Who Prepares a Due Diligence Report?
Due diligence reports are prepared by different parties depending on the organization’s structure and resources.
| Who | When | Typical Cost |
|---|---|---|
| Internal acquisitions team | Mid-market and institutional buyers with in-house DD capability | Staff time only |
| Due diligence consulting firm | When internal expertise is limited or the deal requires independent review | $15,000–$50,000+ per deal |
| Legal counsel | For legal-specific DD components (title, litigation, regulatory) | Hourly billing ($300–$600/hr) |
| AI due diligence platform | When speed and consistency are priorities | Subscription or per-deal pricing |
| Hybrid approach | Most common — AI or internal team handles document analysis; consultants cover specialized areas | Varies |
Increasingly, CRE acquisitions teams use AI due diligence platforms to generate the initial report, then layer in human judgment for strategic interpretation. This approach delivers the best combination of speed, coverage, and insight.
What a Due Diligence Report Contains
A comprehensive CRE due diligence report covers the following sections. The depth of each section varies based on property type, deal size, and the acquirer’s requirements.
1. Executive Summary
The executive summary is the most-read section. It should answer the core question: Should we acquire this property?
Include:
- Property overview (name, location, type, size, occupancy)
- Acquisition price and key financial metrics (cap rate, price per unit/SF)
- Investment thesis summary
- Top 3–5 key findings (positive and negative)
- Key risks identified
- Recommendation (proceed, proceed with conditions, or pass)
Length: 1–2 pages. Senior decision-makers often read only this section, so it must stand alone.
2. Property Overview
Include:
- Legal description and address
- Property type and building class
- Year built, renovations, total square footage
- Unit count and mix (if multifamily)
- Site description, parking, access
- Zoning and entitlements
- Current ownership and management
3. Financial Analysis
The financial section verifies the seller’s reported numbers and identifies trends.
Include:
- Multi-year operating statement analysis (3–5 years of historical T-12s)
- Revenue analysis — rent collections, vacancy/credit loss, other income
- Expense analysis — controllable vs. uncontrollable, year-over-year trends
- NOI calculation and trend
- Comparison to underwriting assumptions
- Variance analysis — where actuals differ from the seller’s pro forma
- Below-the-line items — debt service, capital reserves, TI/LC
Red flags to highlight:
- Revenue growth that exceeds market fundamentals
- Expense categories with unusual spikes or drops
- Management fees that seem artificially low
- Deferred maintenance masked by low repair costs
- Missing or incomplete financial data periods
4. Rent Roll and Lease Analysis
This section verifies the income stream by analyzing every lease.
Include:
- Current rent roll with all tenants, suite numbers, square footage, rent per SF
- Lease expiration schedule and rollover risk analysis
- Weighted average lease term (WALT)
- Rent escalation schedule for every lease
- Lease structure breakdown (NNN, modified gross, full service)
- Expense reimbursement structures and CAM provisions
- Options inventory — renewal, termination, expansion, contraction, purchase
- Percentage rent and breakpoint analysis (retail)
- Tenant improvement allowances outstanding
- Free rent or abatement periods remaining
For detailed guidance on extracting this data, see how lease abstraction works.
5. Tenant Credit Analysis
Understanding whether tenants can pay rent is as important as understanding what they owe.
Include:
- Tenant credit scores or ratings
- Default probability for each major tenant
- Concentration risk — percentage of revenue from top tenants
- Industry diversification analysis
- Tenant financial health indicators
- Public vs. private tenant considerations
- Guarantor analysis where applicable
DDee.ai is the only platform that provides tenant-specific default probability scoring as a standard part of the due diligence report.
6. Legal Review
Include:
- Title review and exceptions
- Survey issues
- Pending or threatened litigation
- Liens, judgments, and encumbrances
- Regulatory compliance status
- Violation history
- HOA/REA/CC&R review (if applicable)
- SNDA status
- Estoppel certificate review and discrepancies
- Ground lease terms (if applicable)
7. Environmental Assessment
Include:
- Phase I Environmental Site Assessment summary
- Phase II findings (if applicable)
- Recognized Environmental Conditions (RECs)
- Historical use and potential contamination risk
- Regulatory database findings
- Remediation status and cost estimates
- Environmental insurance recommendations
8. Physical Condition and CapEx
Include:
- Property condition report summary
- Major building systems assessment (roof, HVAC, electrical, plumbing, elevators)
- Deferred maintenance inventory
- CapEx requirements and timeline
- Remaining useful life estimates for major components
- ADA compliance status
- Seismic assessment (where applicable)
- Estimated capital budget for years 1–5 and 6–10
9. Operations Review
Include:
- Current management company and contract terms
- Staffing levels and costs
- Vendor contracts and terms
- Utility costs and efficiency opportunities
- Insurance coverage adequacy
- Security, janitorial, landscaping contracts
- Operational efficiency benchmarking against comparable properties
10. Risk Assessment
Include:
- Summary of all identified risks categorized by severity (critical, moderate, minor)
- Financial impact estimates for each significant risk
- Mitigation strategies
- Items requiring further investigation
- Deal structure adjustments recommended (price reductions, escrows, representations)
11. Appendices
Include:
- Detailed lease abstracts
- Operating statement spreadsheets
- Tenant credit reports
- Environmental report excerpts
- Legal summaries
- Property condition report excerpts
- Supporting documentation for key findings
Free Due Diligence Report Template
Use this template structure for your next CRE acquisition. Each section includes the key data points to capture.
Template Section 1: Executive Summary
- Property name, address, type
- Acquisition price, cap rate, price per SF/unit
- Investment thesis (2–3 sentences)
- Occupancy rate and WALT
- Top 5 findings (mix of positive and negative)
- Key risks with severity rating
- Recommendation: Proceed / Proceed with conditions / Pass
Template Section 2: Property Overview
- Legal description
- Building specifications (year built, SF, units, stories, parking ratio)
- Zoning designation and permitted uses
- Recent capital improvements
- Site plan and floor plan references
Template Section 3: Financial Analysis
- 3–5 year operating statement comparison table
- Revenue breakdown by category
- Expense breakdown by category
- NOI trend analysis
- Variance vs. pro forma
- Below-the-line items summary
Template Section 4: Rent Roll and Lease Summary
- Complete rent roll table (tenant, suite, SF, rent/SF, lease dates, options)
- Lease expiration schedule chart
- WALT calculation
- Escalation schedule summary
- Options inventory table
- Expense reimbursement structure summary
Template Section 5: Tenant Credit
- Tenant credit score/rating table
- Default probability for each tenant
- Revenue concentration analysis
- Industry diversification breakdown
Template Section 6: Legal Summary
- Title exceptions list
- Litigation summary
- Lien/judgment search results
- Regulatory compliance status
Template Section 7: Environmental
- Phase I summary and findings
- REC inventory (if any)
- Remediation requirements and cost estimates
Template Section 8: Physical Condition and CapEx
- Building systems condition table
- CapEx budget (Year 1–5 and Year 6–10)
- Deferred maintenance items
- Remaining useful life estimates
Template Section 9: Operations
- Management contract summary
- Vendor contract inventory
- Staffing and payroll summary
- Utility cost benchmarking
Template Section 10: Risk Matrix
- Risk item / Severity / Financial Impact / Mitigation
Want this template pre-populated with your deal data? DDee.ai auto-generates DD reports that follow this structure — with every section filled in from your actual deal documents.
How to Write an Effective Due Diligence Report
Lead with Findings, Not Process
Investment committee members and senior decision-makers do not want to read about your methodology. They want to know what you found. Lead every section with the key findings, then provide supporting data.
Instead of: “We reviewed 47 leases across the property and analyzed each for key terms…” Write: “Three leases representing 22% of revenue have below-market escalations that will result in $180,000 less income than the pro forma assumes over the hold period.”
Quantify Every Risk
A due diligence report that says “the roof needs attention” is not actionable. One that says “the roof has an estimated remaining useful life of 3 years with a replacement cost of $450,000” gives decision-makers what they need.
For every risk identified, include:
- What the issue is (specific and factual)
- How much it could cost (estimated financial impact)
- When it will likely materialize (timeline)
- What to do about it (mitigation or deal structure adjustment)
Cite Your Sources
Every finding should trace back to a source document. This makes the report defensible and allows reviewers to verify your analysis. Good source citation looks like:
“Tenant XYZ’s lease (Suite 200, dated 03/15/2022, Section 4.2) provides for annual CPI escalations capped at 2%, compared to the pro forma assumption of 3% fixed increases.”
DDee.ai’s automated red flag detection includes page-level citations for every finding, creating an automatically verifiable audit trail.
Use Tables and Visual Summaries
Dense narrative paragraphs are hard to scan. Use tables for comparison data, charts for trends, and summary boxes for key takeaways. Your readers are reviewing multiple deals — make it easy for them to find what matters.
Include a Clear Recommendation
The report should conclude with a clear recommendation, not just a data dump. State whether you recommend proceeding, proceeding with specific conditions (price adjustment, escrow, repair credits), or passing on the deal. Support the recommendation with the top 3–5 findings that drive it.
How DDee.ai Auto-Generates Due Diligence Reports
DDee.ai transforms the DD report from a weeks-long manual effort into an automated output. Here is how DDee.ai’s report maps to the template structure above.
| Template Section | DDee.ai Module | Automated? |
|---|---|---|
| Executive Summary | IC Reporting | Yes — AI-generated summary with key metrics |
| Financial Analysis | Financial Analysis | Yes — multi-year consolidation with trends |
| Rent Roll & Lease Summary | Lease Abstraction | Yes — every lease abstracted with key terms |
| Tenant Credit | Tenant Credit Scoring | Yes — scores and default probability |
| Legal Summary | Legal Screening | Yes — litigation, liens, regulatory |
| Environmental | Environmental | Yes — Phase I analysis and risk flagging |
| Physical Condition / CapEx | CapEx Summary | Yes — from property condition reports |
| Operations | Operations | Yes — management and operational analysis |
| Risk Assessment | Red Flag Detection | Yes — with citations to source documents |
What DDee.ai produces in under 1 hour matches the structure that consulting firms deliver in 2–6 weeks.
The difference is not just speed — it is coverage. DDee.ai reads every page of every document. Manual DD reports often rely on sample-based review due to time pressure, which means risks buried in the 47th lease may never make it into the report.
For a deeper comparison, see DDee.ai vs. hiring a due diligence consultant.
Due Diligence Report Examples by Property Type
Office Property DD Report Focus Areas
- Lease rollover concentration and WALT
- Tenant credit quality (especially with remote work trends)
- Operating expense ratio benchmarking
- TI/LC obligations for upcoming renewals
- Below-grade parking and building systems condition
Retail Property DD Report Focus Areas
- Co-tenancy and kick-out clauses
- Percentage rent and sales breakpoint analysis
- Anchor tenant credit and default risk
- Exclusive use provisions and conflicts
- Pad site lease terms and ground lease structures
Industrial Property DD Report Focus Areas
- Clear height, column spacing, loading dock specifications
- Environmental history (especially manufacturing tenants)
- Tenant improvement and modification reversibility
- Property tax reassessment exposure
- Utility infrastructure capacity
Multifamily DD Report Focus Areas
- Unit mix and renovation status
- Rent comparables and mark-to-market analysis
- Tenant turnover rates and concession history
- Utility reimbursement structures (RUBS, sub-metering)
- Capital improvement program and remaining budget
Frequently Asked Questions
What is the difference between a due diligence report and a property condition report?
A property condition report (PCR) assesses the physical state of a building — roof condition, HVAC systems, structural integrity, ADA compliance, and estimated remaining useful life of major components. It is one input into the broader due diligence report. A due diligence report covers everything: financial performance, lease terms, tenant credit, legal standing, environmental condition, physical state, and operational efficiency. The PCR feeds into the CapEx and physical condition sections of the DD report.
How long should a due diligence report be?
A typical CRE due diligence report ranges from 30 to 100+ pages, depending on property complexity. The executive summary should be 1–2 pages. Each subsequent section adds detail proportional to its complexity — a 50-tenant office property will have a much longer lease analysis section than a single-tenant NNN industrial building. Focus on completeness and clarity rather than page count. DDee.ai’s auto-generated reports scale naturally based on the number of documents and complexity of the deal.
Who reads the due diligence report?
The primary audience is the investment committee or decision-makers who approve the acquisition. Secondary readers include legal counsel, lenders (for loan underwriting), asset management (for post-closing planning), and in some cases insurance underwriters. Write the executive summary for senior decision-makers who have limited time. Write the detailed sections for analysts and specialists who need to verify specific findings.
When in the acquisition process is the DD report prepared?
The due diligence report is typically prepared during the due diligence period specified in the purchase and sale agreement — usually 30–60 days after the contract is executed. Some acquirers prepare preliminary DD reports during the letter of intent (LOI) stage to inform bidding strategy. With AI tools like DDee.ai producing reports in under 1 hour, teams can now generate preliminary DD at the LOI stage and comprehensive DD once under contract, without the cost of multiple consulting engagements.
Can I use DDee.ai’s report for my investment committee presentation?
Yes. DDee.ai’s IC Reporting module generates investment committee-ready summaries with key metrics, risk assessments, and structured findings. Many teams use DDee.ai’s output as the foundation for their IC memo, adding their own strategic commentary, market context, and investment thesis. The report format is designed to be presented directly or adapted to your organization’s IC template.
What is the most common mistake in due diligence reports?
The most common mistake is presenting data without interpretation. A DD report that lists every lease term but does not highlight which ones create risk is not useful. Every section should answer “so what?” — what does this data mean for the investment decision? The second most common mistake is incomplete coverage — missing documents, skipped leases, or unreviewed financial periods that leave gaps in the analysis. DDee.ai addresses both issues by providing AI-interpreted findings with risk flags and analyzing every page of every document.
How much does it cost to prepare a due diligence report?
Costs range widely depending on the approach. Internal preparation costs staff time but no direct fees. Consulting firms charge $15,000–$50,000+ per engagement. AI platforms like DDee.ai offer subscription or per-deal pricing that represents a fraction of consulting costs. For a detailed cost comparison, see our guide on due diligence consulting vs. software.
Generate Your Due Diligence Report in Under 1 Hour
Stop spending weeks compiling DD reports manually. DDee.ai analyzes your deal documents across nine modules and delivers a complete, citation-backed due diligence report — ready for your investment committee.