Bedcount MCP

{
  "type": "object",
  "properties": {
    "name": {
      "type": "string",
      "maxLength": 120,
      "minLength": 2,
      "description": "Campus name or distinctive words from it, e.g. \"University of Florida\" or \"texas austin\"."
    },
    "state": {
      "type": "string",
      "pattern": "^[A-Za-z]{2}$",
      "description": "Two-letter state code to narrow a name match, e.g. TX."
    },
    "unitid": {
      "type": "string",
      "pattern": "^\\d{6}$",
      "description": "Six-digit IPEDS UNITID, e.g. 228778. Overrides name."
    }
  },
  "additionalProperties": false
}

{
  "title": "Student housing data for one campus",
  "readOnlyHint": true,
  "openWorldHint": false,
  "idempotentHint": true,
  "destructiveHint": false
}

{
  "type": "object",
  "properties": {
    "city": {
      "type": "string",
      "maxLength": 60,
      "minLength": 2,
      "description": "City name, e.g. \"Austin\"."
    },
    "name": {
      "type": "string",
      "maxLength": 120,
      "minLength": 2,
      "description": "Words from the campus name, e.g. \"state university\"."
    },
    "sort": {
      "enum": [
        "bed_gap",
        "fulltime_enrollment",
        "total_enrollment",
        "beds_per_100",
        "college_beds",
        "housing_charge"
      ],
      "type": "string",
      "default": "bed_gap",
      "description": "Ranking field."
    },
    "limit": {
      "type": "integer",
      "default": 10,
      "maximum": 25,
      "minimum": 1,
      "description": "Rows to return (max 25)."
    },
    "order": {
      "enum": [
        "desc",
        "asc"
      ],
      "type": "string",
      "default": "desc",
      "description": "desc = largest first."
    },
    "state": {
      "type": "string",
      "pattern": "^[A-Za-z]{2}$",
      "description": "Two-letter state code, e.g. TX."
    },
    "offset": {
      "type": "integer",
      "default": 0,
      "maximum": 1000,
      "minimum": 0,
      "description": "Rows to skip, for paging."
    },
    "sector": {
      "enum": [
        "Public",
        "Private nonprofit",
        "Private for-profit"
      ],
      "type": "string",
      "description": "Control of the institution."
    },
    "min_fulltime": {
      "type": "integer",
      "maximum": 200000,
      "minimum": 0,
      "description": "Minimum full-time students, fall 2024."
    },
    "offers_housing": {
      "type": "boolean",
      "description": "true = only colleges that provide housing; false = only those that provide none."
    },
    "fannie_campus_size_test": {
      "type": "boolean",
      "description": "true = only campuses with 10,000+ students, majority full-time (Fannie Mae Dedicated Student Housing campus-size test)."
    }
  },
  "additionalProperties": false
}

{
  "title": "Find and rank campuses by students and beds",
  "readOnlyHint": true,
  "openWorldHint": false,
  "idempotentHint": true,
  "destructiveHint": false
}

{
  "type": "object",
  "required": [
    "beds",
    "rent_per_bed_month",
    "opex_per_bed_year",
    "value",
    "interest_rate_pct"
  ],
  "properties": {
    "beds": {
      "type": "integer",
      "maximum": 100000,
      "minimum": 1,
      "description": "Number of beds."
    },
    "value": {
      "type": "number",
      "maximum": 10000000000,
      "minimum": 1,
      "description": "Property value or purchase price, dollars."
    },
    "preset": {
      "enum": [
        "freddie_5_7yr",
        "freddie_over_7yr",
        "freddie_full_io_5_7yr"
      ],
      "type": "string",
      "default": "freddie_5_7yr",
      "description": "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."
    },
    "min_dscr": {
      "type": "number",
      "maximum": 3,
      "minimum": 1,
      "description": "Minimum debt service coverage, e.g. 1.25. Overrides the preset."
    },
    "max_ltv_pct": {
      "type": "number",
      "maximum": 100,
      "minimum": 0,
      "description": "Max loan-to-value, percent. Overrides the preset."
    },
    "vacancy_pct": {
      "type": "number",
      "default": 5,
      "maximum": 100,
      "minimum": 0,
      "description": "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": {
      "type": "number",
      "default": 12,
      "maximum": 12,
      "minimum": 1,
      "description": "Months of rent collected a year: 12 on 12-month leases, less if summer is empty."
    },
    "interest_rate_pct": {
      "type": "number",
      "maximum": 20,
      "minimum": 0.01,
      "description": "Your own quoted interest rate, percent, e.g. 6.25."
    },
    "opex_per_bed_year": {
      "type": "number",
      "maximum": 100000,
      "minimum": 0,
      "description": "Operating expenses per bed per year (taxes, insurance, payroll, utilities, turnover), dollars."
    },
    "amortization_years": {
      "type": "integer",
      "maximum": 40,
      "minimum": 0,
      "description": "Amortization in years, 0 = interest only. Default 30 (0 with the full-IO preset)."
    },
    "min_debt_yield_pct": {
      "type": "number",
      "maximum": 30,
      "minimum": 0,
      "description": "Minimum debt yield, percent. Omit or 0 to skip the test."
    },
    "rent_per_bed_month": {
      "type": "number",
      "maximum": 20000,
      "minimum": 0,
      "description": "Rent per bed per month, dollars."
    },
    "reserves_per_bed_year": {
      "type": "number",
      "default": 150,
      "maximum": 10000,
      "minimum": 0,
      "description": "Replacement reserves per bed per year, dollars. Default 150, Freddie Mac's stated minimum per bed."
    },
    "other_income_per_bed_month": {
      "type": "number",
      "default": 0,
      "maximum": 5000,
      "minimum": 0,
      "description": "Other income per bed per month (parking, fees, utility bill-backs), dollars."
    }
  },
  "additionalProperties": false
}

{
  "title": "Size a student housing loan by the bed",
  "readOnlyHint": true,
  "openWorldHint": false,
  "idempotentHint": true,
  "destructiveHint": false
}