Size a conduit loan
size_conduit_loanMaximum CMBS conduit loan for a property from its NOI and value: runs the coverage (DSCR), loan-to-value and debt yield tests and says which one binds, with debt service and the resulting ratios. Defaults are the edge of what last year's conduit loans of that property type were underwritten to, and the median coupon for the term; any of them can be overridden.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| noi | Yes | Annual net operating income in US dollars, e.g. 2000000. | |
| term | No | Loan term in years; sets the default rate to that term's median coupon. Default 10. | |
| value | No | Appraised value in US dollars, e.g. 31000000. Omit to skip the loan-to-value test. | |
| min_dscr | No | Minimum debt service coverage, e.g. 1.25. Default: the property type's 10th percentile. | |
| rate_pct | No | Interest rate in percent, e.g. 6.25. Default: the median coupon for the term. | |
| max_ltv_pct | No | Maximum loan-to-value in percent, e.g. 65. Default: the property type's 90th percentile. | |
| property_type | No | Property type whose underwriting edge sets the default limits ("lodging" is hotel). Default all. | all |
| amortization_years | No | 0 for interest only for the full term (most conduit loans), or 25 or 30. | |
| min_debt_yield_pct | No | Minimum debt yield in percent, e.g. 9. Default: the property type's 10th percentile. |