Size a CMBS loan
size_cmbs_loanMaximum CMBS loan on a property under the three sizing tests lenders apply, and which one binds: loan to value x value, NOI / (DSCR x annual debt constant at the rate and amortization, or the rate if interest-only), and NOI / debt yield. Limits you omit default to what recent CMBS loans stayed within (90th percentile LTV, 10th percentile DSCR and debt yield, by property type), and the rate to the 90-day median.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| noi | Yes | Underwritten net operating income (or net cash flow) per year in dollars, e.g. 1800000. | |
| min_dscr | No | Minimum debt service coverage ratio, e.g. 1.30. | |
| rate_pct | No | Note rate in percent, e.g. 6.5. Default: the 90-day median CMBS rate for the property type. | |
| max_ltv_pct | No | Maximum loan to value in percent, e.g. 65. | |
| interest_only | No | true = interest-only for the full term (most recent CMBS loans). Default true. | |
| property_type | No | Property type: multifamily, retail, office, hotel, self-storage, industrial, mixed-use, mobile-home-park, co-op, healthcare. Omit for all types. | |
| property_value | Yes | Appraised value or purchase price in dollars, e.g. 25000000. | |
| amortization_years | No | Amortization schedule in years. Required when interest_only is false. | |
| min_debt_yield_pct | No | Minimum debt yield in percent, e.g. 8.5. |