CRE Calculators

Apartment Building Mortgage Calculator

Size multifamily commercial mortgages across Agency (Fannie Mae / Freddie Mac), Commercial Bank, and HUD 223(f) debt programs. Dual-test maximum loan amounts by LTV and DSCR, evaluate debt service, and project post-financing cash flow.

Select Multifamily Loan Program

Apartment Property Operations & Income

$
$
Calculated OpEx: $92,000 | NOI: $227,200

Commercial Mortgage Underwriting Terms

Maximum Sized Mortgage$2,100,000
Constrained by LTV
Max Loan by LTV (75%)$2,100,000
Max Loan by DSCR (1.25x)$2,243,262
Monthly Debt Service:$14,179
Annual Debt Service:$170,152
Required Down Payment:$700,000 (25.0%)
Pre-Tax Net Cash Flow:$57,048 / yr
Cash-on-Cash Return:on down payment (or 7.55% with 2% closing costs / reserves)
8.15%
Debt Yield:10.82%

Multifamily Debt Program Comparison

ProgramMax LoanMonthly P&ICoC Return
Agency (80% / 30y)$2,240,000$13,79211.02%
Bank (75% / 25y)$2,100,000$14,1798.15%
HUD 223(f) (85% / 35y)$2,380,000$13,33216.00%

How Apartment Building Commercial Mortgages Are Sized

Commercial apartment building mortgages (5+ residential units) differ fundamentally from 1–4 unit residential home loans. Rather than evaluating borrower personal W-2 income, commercial multifamily lenders underwrite the property itself through two governing mathematical constraints: 1. Loan-to-Value (LTV) Constraint: Limits the loan principal as a maximum percentage of the property appraised value or purchase price (typically 75% for commercial banks, 80% for Fannie/Freddie Agency, up to 85% for HUD 223(f)). 2. Debt Service Coverage Ratio (DSCR) Constraint: Ensures the property Net Operating Income (NOI) exceeds the required annual principal and interest debt service by a minimum safety factor (typically 1.25x for Agency and banks, 1.176x for HUD). The actual loan proceeds sized by the lender will ALWAYS be the lower (binding) of these two constraints. In low-cap-rate or higher-interest-rate environments, DSCR almost always constrains loan sizing below the theoretical max LTV.

The Sizing Formulas

[1. Maximum Loan by LTV] Max Loan_LTV = Purchase Price × Max LTV % [2. Maximum Allowable Annual Debt Service by DSCR] Max ADS_DSCR = Net Operating Income (NOI) / Minimum DSCR Requirement [3. Maximum Loan by DSCR] Max Loan_DSCR = Max ADS_DSCR / Annual Loan Constant where Annual Loan Constant = 12 × [ r(1 + r)^n ] / [ (1 + r)^n − 1 ] [4. Governing Sized Mortgage Proceeds] Sized Mortgage = min( Max Loan_LTV, Max Loan_DSCR )
Purchase Price:Acquisition price or independent as-is appraisal value ($)
NOI:Net Operating Income: Effective Gross Income minus Operating Expenses
DSCR Benchmark:Minimum coverage ratio (e.g., 1.25x for Agency/Banks, 1.176x for HUD)
Loan Constant:Annualized percentage payment of principal and interest per dollar of loan

Canonical 24-Unit Multifamily Property Case Study ($2.8M Valuation, $227,200 NOI)

Using our canonical 24-unit apartment building example ($2,800,000 purchase price, $336,000 GPI, 5% vacancy ($16,800), $92,000 OpEx, resulting in an 8.11% Cap Rate and $227,200 NOI): • Commercial Bank Program (75% LTV, 1.25x DSCR, 6.50% interest, 25-yr amort): - Max Loan by LTV (75%): $2,100,000 - Max Allowable Debt Service for 1.25x DSCR: $227,200 / 1.25 = $181,760 / year - Max Loan by DSCR: $2,243,243 - Sized Mortgage: $2,100,000 (Constrained by LTV) - Monthly Payment: $14,179 ($170,152 annual debt service) - Actual Sized DSCR: 1.34x (Cushion above 1.25x requirement) - Pre-Tax Cash Flow: $57,048 / year - Leveraged Cash-on-Cash Return: 8.15% on $700,000 down payment (or 7.55% on $756,000 total initial cash invested including 2% closing costs / working reserves) • Agency Fannie Mae / Freddie Mac Program (80% LTV, 1.25x DSCR, 6.25% interest, 30-yr amort): - Max Loan by LTV (80%): $2,240,000 - Max Loan by DSCR: $2,460,788 - Sized Mortgage: $2,240,000 (Constrained by LTV) - Monthly Payment: $13,791 ($165,492 annual debt service) - Pre-Tax Cash Flow: $61,708 / year (11.02% Cash-on-Cash on $560,000 down payment) *Note: This is a standardized educational underwriting case study for illustrative comparison only.*

Frequently Asked Questions About Apartment Mortgages

What is considered an apartment building for commercial mortgage financing?

In commercial real estate finance, any residential property with 5 or more self-contained living units is legally classified as commercial multifamily. Properties with 1 to 4 units fall under residential consumer mortgage guidelines (Fannie Mae / Freddie Mac residential conforming loans). Commercial multifamily loans are underwritten primarily to the cash flow (NOI) of the property rather than personal debt-to-income (DTI) ratios.

Why do commercial lenders test both LTV and DSCR when sizing multifamily loans?

LTV protects the lender against property market depreciation by requiring borrower equity cushion. DSCR protects against default by ensuring rental income reliably covers mortgage payments. The lower of the two limits determines the actual loan amount. When interest rates rise, DSCR almost always becomes the binding bottleneck.

What are the main differences between Agency (Fannie/Freddie) and Commercial Bank apartment loans?

Agency loans (Fannie Mae DUS / Freddie Mac Optigo) offer non-recourse financing, 30-year amortization, up to 80% LTV, and competitive fixed rates for 5–12 years, but carry stricter prepayment penalties (Yield Maintenance or Defeasance). Commercial banks offer balance-sheet portfolio loans with flexible step-down prepay penalties, but typically require recourse guarantees, 20–25 year amortization, and maximum 70–75% LTV.

What is HUD / FHA 223(f) multifamily financing?

HUD 223(f) is a government-insured loan program for the acquisition or refinancing of existing multifamily properties with 5+ units. It offers the industry highest leverage (up to 85% LTV), lowest DSCR (1.176x), longest fully amortizing term (up to 35 years with no balloon payment), and non-recourse terms, in exchange for higher upfront closing costs, annual MIP (Mortgage Insurance Premium), and longer closing timelines (4–6 months).

Related Calculators