What's included
This Excel template contains 88 due diligence line items organized across 9 categories, covering every major area of a multifamily acquisition. Each item includes a status dropdown (Not Started, In Progress, Complete, N/A), an assignee field, a notes column, and a due date. A progress bar at the top of the checklist auto-calculates completion percentage so you can see exactly where your team stands at any point during the DD period.
The template is designed for teams acquiring apartment buildings, student housing, and workforce housing assets. It works for both individual property acquisitions and portfolio transactions.
Categories covered
Financial Underwriting
Verify trailing financials, validate operating expense assumptions, reconcile T-12 statements, and confirm the seller's proforma against your own underwriting model.
Rent Roll and Leasing
Audit the current rent roll, review lease terms and expiration schedules, verify concessions, and confirm tenant payment history against bank deposits.
Physical and Property Condition
Coordinate property condition assessments, review capital expenditure reports, inspect major building systems (HVAC, roofing, plumbing, electrical), and document deferred maintenance.
Environmental
Order and review Phase I ESA reports, evaluate the need for Phase II testing, and confirm compliance with local environmental regulations including lead paint and asbestos disclosures.
Legal and Title
Review title commitments, survey exceptions, existing encumbrances, zoning compliance, and any pending or threatened litigation involving the property.
Market and Comparable Analysis
Validate market rents using comparable properties, review recent sales comps in the submarket, and assess supply pipeline for competing developments.
Insurance and Risk
Obtain insurance quotes, review the property's claims history, evaluate flood zone status, and confirm adequate coverage levels for the acquisition.
Operations and Management
Review existing property management agreements, evaluate staffing levels, assess vendor contracts, and plan the transition to your management team if applicable.
Closing and Transfer
Track closing document preparation, tenant notification requirements, utility transfers, security deposit reconciliation, and post-close integration steps.
How to use this checklist
Start by filling in the property details at the top of the spreadsheet: property name, address, unit count, and the DD expiration date. Then assign each checklist item to a team member and set target completion dates. As your team works through each item, update the status dropdown. The progress bar updates automatically so you always know how much remains.
For teams using MotionCRE, this checklist maps directly to the task management system inside each deal workspace, where you can track due diligence alongside documents, contacts, and financing details in one place.
When to start due diligence
Begin due diligence on day one of the inspection period. Most multifamily PSAs allow 30 to 60 days, but the work fills whatever time you give it. Order third-party reports (Phase I, PCA, survey) immediately since these have the longest lead times. Financial and rent roll analysis should start in the first week. Legal and title review can run in parallel.
Build in buffer time before the DD expiration date. Discovering a material issue on day 29 of a 30-day period leaves no room to negotiate or walk away cleanly.
For office and retail acquisitions, see our commercial due diligence checklist. To track documents collected during the DD process, use the deal room document checklist. And when you reach closing, the CRE closing checklist picks up where this one ends.
Frequently asked questions
What should be on a multifamily due diligence checklist?
A thorough multifamily due diligence checklist should cover financial underwriting, rent roll and leasing analysis, physical property condition, environmental assessments, legal and title review, market and comparable analysis, insurance and risk evaluation, operations and management review, and closing and transfer items. Each category should include specific line items with assigned owners and status tracking.
How long does multifamily due diligence take?
Most multifamily acquisitions allow 30 to 60 days for due diligence, depending on deal complexity and the purchase and sale agreement. Larger portfolios or properties with deferred maintenance, environmental concerns, or complex tenant situations may require extensions. Start working through your checklist on day one to avoid last-minute surprises.
What are the most commonly missed due diligence items?
Environmental phase assessments, tenant estoppel certificates, and utility expense verification are among the most frequently overlooked items. Teams also commonly underestimate the time required for a thorough CAM reconciliation and often skip verifying insurance claim history. A structured checklist helps ensure nothing falls through during the process.
Download this template
Enter your details below to download.
Excel format · No account required