Size a student housing loan by the bed
size_loanThe studenthousing.loans by-the-bed loan sizer: from beds, rent per bed, months collected, vacancy, expenses, reserves, value and your own interest rate, returns net operating income and the loan allowed by max LTV, min DSCR and an optional debt yield, the maximum loan (the smallest), which test binds, annual debt service and loan per bed. Presets are Freddie Mac's published student housing LTV/DSCR tiers.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| beds | Yes | Number of beds. | |
| value | Yes | Property value or purchase price, dollars. | |
| preset | No | Freddie Mac student housing tier: freddie_5_7yr = 75% LTV / 1.30x; freddie_over_7yr = 80% / 1.30x; freddie_full_io_5_7yr = 65% / 1.30x, interest only. | freddie_5_7yr |
| min_dscr | No | Minimum debt service coverage, e.g. 1.25. Overrides the preset. | |
| max_ltv_pct | No | Max loan-to-value, percent. Overrides the preset. | |
| vacancy_pct | No | Vacancy, concessions and bad debt, percent of rent. Default 5, Fannie Mae's by-the-bed floor with a T-12 (10 without one). | |
| months_collected | No | Months of rent collected a year: 12 on 12-month leases, less if summer is empty. | |
| interest_rate_pct | Yes | Your own quoted interest rate, percent, e.g. 6.25. | |
| opex_per_bed_year | Yes | Operating expenses per bed per year (taxes, insurance, payroll, utilities, turnover), dollars. | |
| amortization_years | No | Amortization in years, 0 = interest only. Default 30 (0 with the full-IO preset). | |
| min_debt_yield_pct | No | Minimum debt yield, percent. Omit or 0 to skip the test. | |
| rent_per_bed_month | Yes | Rent per bed per month, dollars. | |
| reserves_per_bed_year | No | Replacement reserves per bed per year, dollars. Default 150, Freddie Mac's stated minimum per bed. | |
| other_income_per_bed_month | No | Other income per bed per month (parking, fees, utility bill-backs), dollars. |