Interactive tool
Multifamily Portfolio Analyzer
Roll up NOI, DSCR, LTV, debt yield, and break-even occupancy across your 5+ unit portfolio.
Last updated:
Quick answer
Multifamily Portfolio Analyzer
Roll up NOI, DSCR, LTV, debt yield, and break-even occupancy across your 5+ unit portfolio.
Portfolio inputs
Enter your portfolio
Roll up rent, occupancy, expenses, debt, and value.
All properties
Weighted avg
Typical 90–95%
Laundry, fees, parking
Tax + ins + mgmt + maint
All loans P&I
Market or as-stabilized
Current UPB
Results
Portfolio DSCR
1.64x — 1.35x+ (strong)
Strong coverage — headroom for rate or vacancy stress.
- Gross scheduled rent
- $835,200
- Effective gross income
- $794,736
- NOI
- $509,736
- Cash flow after debt
- $199,736
- Cap rate
- 8.22%
- LTV
- 62.9%
- Debt yield
- 13.07%
- NOI / unit
- $10,620
- Value / unit
- $129,167
- Break-even occupancy
- 69.1%
- Equity
- $2,300,000
Send your roll-up for a lender-fit review.
Portfolio DSCR = NOI ÷ Annual debt service. LTV = Loan ÷ Value. Use this roll-up to spot the binding constraint across your 5+ unit holdings before requesting agency, bank, or bridge quotes. Stress occupancy and rate — portfolio DSCR can mask a weak property.
Related Resources
Hand-picked next steps — go deeper on this topic, compare alternatives, or run the numbers.
-
Guide
Multifamily Underwriting Basics for 5+ Unit Deals
Comprehensive underwriting framework for US commercial multifamily acquisitions and refinances on 5+ unit properties.
-
Guide
Debt Yield and LTV: A Practical Framework
Practical debt yield and LTV framework for multifamily sponsors balancing proceeds, resilience, and refinance risk.
-
Guide
Commercial DSCR Loan Guide for Multifamily
Commercial DSCR loan guide for US multifamily (5+ units)—how lenders calculate DSCR, thresholds by product, and improvement strategies for apartment financing.
-
Loan type
Fannie Mae Multifamily Loan — Agency Stabilized
Fannie Mae multifamily loan execution for stabilized US apartment buildings (5+ units)—agency underwriting, DSCR, debt yield, and fit vs bridge or CMBS.
-
Loan type
Bank Balance-Sheet Multifamily Loan
Execution framework for Bank Balance-Sheet Multifamily Loan in US commercial multifamily financing, including fit, constraints, and risk controls.
-
Loan type
Bridge Loan for Value-Add Multifamily
Execution framework for Bridge Loan for Value-Add Multifamily in US commercial multifamily financing, including fit, constraints, and risk controls.
How this portfolio analyzer works
Aggregate your holdings before you request quotes. This calculator uses the commercial multifamily stack:
- Gross scheduled rent = Units × Avg rent × 12
- Effective gross income = Gross × Occupancy + Other income
- NOI = EGI − Annual OpEx
- DSCR = NOI ÷ Annual debt service
- LTV = Total loan balance ÷ Portfolio value
- Debt yield = NOI ÷ Loan balance
Portfolio metrics are useful for supplemental loans, cross-collateral discussions, and hold vs recycle decisions — but lenders still underwrite property-level DSCR and debt yield. Pair this roll-up with our Cap Rate & NOI, Commercial DSCR, and Debt Yield calculators for asset-level context.
Worked example: 48-unit Sun Belt portfolio
48 units at $1,450/mo avg rent, 93% occupancy, $18,000 other income, $285,000 OpEx, $310,000 debt service, value $6.2M, loan $3.9M.
- Gross scheduled: 48 × $1,450 × 12 = $835,200
- EGI: $835,200 × 93% + $18,000 ≈ $794,736
- NOI: $794,736 − $285,000 = $509,736
- DSCR: $509,736 ÷ $310,000 ≈ 1.64x (strong)
- LTV: $3.9M ÷ $6.2M ≈ 62.9% · Debt yield ≈ 13.1%
See structure trade-offs in agency vs bridge and our underwriting basics guide. When ready, send the roll-up for a free deal review.