AI for CRE & Multifamily Underwriting: NOI, DSCR, Agency Debt Sizing

CRE and Multifamily Underwriting in Minutes, Not Days

Commercial real estate and multifamily underwriting involve detailed cash flow projections, debt service calculations, and multi-tiered capital stack analysis. FinSkilz's real estate MCP server gives Claude the ability to run these calculations with precision — turning hours of spreadsheet work into a conversation. Can AI help with multifamily underwriting specifically? Yes — the sections below cover the parts of multifamily underwriting that differ from generic CRE: T-12 trailing financial analysis, agency debt sizing under Fannie Mae/Freddie Mac grids, and value-add renovation ROI.

Multifamily Underwriting

Multifamily underwriting runs on a different set of conventions than office or retail — trailing financials rather than in-place leases, agency debt programs with their own DSCR/LTV grids, and a renovation-ROI case for value-add deals.

T-12 Trailing Financial Analysis

• "Analyze this T-12 trailing financial statement for a 180-unit multifamily property: gross potential rent $2.4M, loss to lease $95K, vacancy loss $168K, concessions $42K, bad debt $31K, other income (parking, pet fees, RUBS) $118K, total operating expenses $980K including a $162K management fee (6.75% of EGI) and $54K replacement reserve ($300/unit). Normalize the T-12 to a stabilized NOI: flag any below-market management fee or reserve allowance that a lender would re-underwrite to market, and recompute NOI at a market-standard 3% management fee and $350/unit reserve."
• "Compare T-3, T-6, and T-12 annualized NOI for a property with rising rents: T-3 annualized NOI $1.42M, T-6 annualized NOI $1.35M, T-12 NOI $1.21M. What does the trend imply about in-place rent growth, and which trailing period should the lender use for debt sizing given this trajectory?"

Agency Debt Sizing (Fannie Mae / Freddie Mac)

Fannie Mae and Freddie Mac multifamily programs size the loan off the more restrictive of a minimum DSCR and a maximum LTV, applied to underwritten NOI — not just whichever constraint a sponsor prefers:

• "Size a Freddie Mac conventional multifamily loan: underwritten NOI $1.85M, appraised value $28M, program minimum DSCR 1.25x, maximum LTV 75%, loan rate 5.85%, 30-year amortization. Calculate the maximum loan amount under the DSCR constraint and under the LTV constraint separately, then confirm which one governs. Show the resulting debt yield."
• "This property qualifies for Freddie Mac's green/moderate-rehab program with a reduced minimum DSCR of 1.20x instead of the standard 1.25x. Underwritten NOI is $1.6M at a 5.70% rate, 30-year amortization. How much additional loan proceeds does the lower DSCR requirement unlock versus the standard 1.25x program, holding the LTV constraint at 80%?"

Value-Add Renovation ROI

• "Model a value-add renovation program for a 150-unit property: 100 classic units at $1,650/month, renovating to premium finish at $1,950/month ($300 rent premium) at a cost of $9,500/unit including downtime. Renovating 8 units/month. Calculate: (1) total renovation capex, (2) incremental annual NOI once all units are renovated (assume 95% occupancy on renovated units), (3) yield on cost of the renovation capital, (4) months to recover renovation capex from the incremental NOI alone."

Core CRE Underwriting Tasks

NOI and Cap Rate Analysis

• "Underwrite this office property: 50,000 sq ft, current rent $45/sf, 90% occupancy, OpEx $18/sf, 5% vacancy allowance. What's the stabilized NOI and value at a 6.5% cap rate?"
• "The seller is asking $12M for a 20,000 sf retail center with $820K NOI. What is the implied cap rate? What's our target price at a 7.5% cap?"

DSCR and Loan Sizing

Debt service coverage ratio (DSCR) determines how much debt a property can support:

• "With $820K NOI, size a 10-year fixed-rate loan at 6.25% interest, 25-year amortization, 1.25x DSCR minimum. What's the maximum loan amount?"
• "A lender requires 1.30x DSCR on a 70% LTV loan. Does this property qualify? NOI: $680K, Purchase: $9.5M."

Multi-Year Cash Flow Projections

• "Project 10-year cash flows for a multifamily property: 120 units, current rents $1,800/unit, 95% occupancy, 3% annual rent growth, 2% expense growth. Show NOI, cash-on-cash return, and equity multiple."
• "Run a hold period analysis with 5-year and 7-year exit scenarios at cap rates of 5.5% and 6.5%."

Joint Venture Waterfall Modeling

JV structures with preferred returns and carried interest require precise waterfall calculations:

• "Model a JV waterfall: 90/10 LP/GP split, 8% preferred return, 20% GP promote above the pref. Total equity: $5M, hold period returns: [paste annual distributions and sale proceeds]."
• "We have a 3-tier waterfall: 8% pref, then 80/20, then 70/30 above 15% IRR. What are LP and GP returns at a $2.8M total distribution?"

Lease Abstraction

Claude can extract key lease terms from commercial lease documents:

• Base rent, rent escalations, and lease expiry by tenant
• Renewal options, termination rights, and ROFO/ROFR provisions
• Tenant improvement allowances and landlord obligations
• CAM (Common Area Maintenance) expense caps and exclusions

"Here is the lease for Suite 201. Extract: tenant name, lease term, base rent schedule, renewal options, and any co-tenancy or kick-out clauses."

Setting Up the Real Estate Server

{
  "mcpServers": {
    "claudefinlab-realestate": {
      "url": "https://claudefinancelab.com/realestate/sse",
      "headers": { "Authorization": "Bearer YOUR_API_KEY" }
    }
  }
}

Related Skills

• CRE Underwriting Engine — NOI, DSCR, 10-year projections
• JV Waterfall Calculator — preferred return, promote tiers
• Bridge Loan Sizer — construction and bridge financing
• Cap Rate Comparables Analyzer — market benchmarking

Frequently Asked Questions

Can AI help with multifamily underwriting?

Yes. Claude can analyze T-12 trailing financials to normalize NOI, model agency debt sizing under Fannie Mae and Freddie Mac DSCR/LTV grids, project unit-by-unit rent roll and renovation ROI for value-add deals, and run multi-year cash flow projections with sale-proceeds sensitivity. It does not replace a lender's or buyer's underwriting judgment on physical condition, market comps, or sponsor track record — it removes the hours of spreadsheet work in building the financial case before that judgment is applied.

What is CRE underwriting AI?

CRE underwriting AI uses a large language model to process the financial analysis in commercial real estate underwriting — NOI and cap rate calculations, DSCR-based loan sizing, multi-year cash flow projections, joint venture waterfall modeling, and lease abstraction — from plain-language prompts instead of manual spreadsheet modeling. It handles the calculation and documentation layer; a human underwriter still makes the investment or lending decision.

How does agency debt sizing differ for multifamily properties?

Fannie Mae and Freddie Mac multifamily loan programs size debt off minimum DSCR (typically 1.25x for standard loans, lower for some affordable/green programs) and maximum LTV (typically 75-80%), applying the more restrictive of the two constraints to the trailing-12-month or in-place NOI, often with specific underwriting haircuts for concessions, bad debt, and management fees that differ from generic CRE loan sizing conventions.