Loan sizing (LTV / DSCR / debt yield)
calc_debt_sizingSize the maximum loan under any combination of max LTV, min DSCR, and min debt yield for a given NOI, rate, and amortization. Reports the binding constraint, debt service, and resulting metrics. Deterministic: use this instead of doing the math yourself; cite formula calc.debt_sizing@2 and the returned steps, and surface any warnings.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| noi | Yes | Underwritten net operating income, USD/yr. | |
| value | No | Appraised or underwritten value, USD. Required when max_ltv is set. | |
| max_ltv | No | Maximum loan-to-value, e.g. 0.65. | |
| min_dscr | No | Minimum debt service coverage ratio, e.g. 1.25. | |
| rate_annual | Yes | Annual interest rate, e.g. 0.065. | |
| round_down_to | No | Round the final loan amount down to this increment (lenders often use 1,000 or 10,000). | |
| min_debt_yield | No | Minimum debt yield (NOI ÷ loan), e.g. 0.09. | |
| amortization_years | Yes | Amortization in years; 0 means interest-only. |