How loan rates move what a buyer can pay
rate_sensitivityFor an apartment building's net operating income, the price a financed buyer can carry and the income-limited loan size at a ladder of 10-year Treasury levels around today's (default -100 to +100 bp), at 80% LTV and 1.25x DSCR by default. Answers "what is my building worth to a buyer if rates drop half a point?".
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| dscr | No | Min debt service coverage, times. Default 1.25 (both agencies' term sheets). | |
| ltv_pct | No | Max loan-to-value, percent. Default 80 (Fannie Mae and Freddie Mac conventional term sheets). | |
| shifts_bp | No | Moves in the 10-year to test, in basis points. Default [-100,-50,-25,0,25,50,100]. | |
| tax_reset | No | True if a sale resets the property tax bill to a share of the price; value is then solved with taxes at tax_rate_pct of price. | |
| noi_annual | Yes | Net operating income per year in US dollars, e.g. 300000. | |
| spread_pct | No | Lender spread over the 10-year, percent. Default 1.75, the worksheet's placeholder (not a quote). | |
| tax_rate_pct | No | Tax rate on the new value, percent of price (county millage as a percent). Default 1.5. Used only when tax_reset is true. | |
| treasury_10yr_pct | No | 10-year Treasury yield to use, percent. Default: the latest daily par yield the site has (U.S. Treasury). | |
| amortization_years | No | Amortization in years. Default 30. | |
| property_taxes_annual | No | Current property taxes inside that NOI, US dollars. Needed only with tax_reset. |