> >
Commercial Mortgage Underwriting

Commercial DSCR Loan Underwriting Sizer

Calculate Maximum Allowable Loan Proceeds, minimum required Net Operating Income (NOI), debt yield constraints, and loan-to-value (LTV) limits for retail, industrial, and multifamily assets.

Property Income & Loan Terms

Loan Proceeds & Lender Underwriting

Maximum Allowable Loan Proceeds
Constrained by 1.25x DSCR debt service
$2,790,000
Maximum Annual Debt Service
NOI / DSCR target limit
$228,000/yr
Resulting LTV & Debt Yield
Lender risk profile parameters
66.4% LTV
10.2% Debt Yield
Commercial lenders sizing loans take the minimum of three constraints: DSCR (1.25x), Debt Yield (minimum 9.5%), and Maximum LTV (typically 70%-75%).
Lender Ready Need an official bank underwriting spreadsheet?

Download the unlocked 10-Year CRE Pro Forma, Debt Yield & Waterfall Model (.xlsx).

Unlock Excel Model • $29