SNF Register: nursing home owners, CMS ratings and HUD 232 loans

Searches the 14,000+ CMS-certified nursing homes by name, city or state and returns each match's CCN, name, city, state, certified beds, CMS overall star rating, whether an FHA-insured HUD 232 loan is matched (active, past or none) and its SNF Register page. Use the CCN with get_nursing_home.

One nursing home's SNF Register record by CCN: CMS beds, occupancy, star ratings, staffing hours and turnover, fines, ownership type and chain; the owners and operators it reported to CMS, private equity or REIT flags, changes of ownership; and its matched FHA-insured HUD 232 loans with note rate, balance, maturity and servicer.

A state's (or the US) nursing home roll-up: CMS-certified facilities and beds, median occupancy, star-rating spread, median nurse hours and turnover, for-profit, nonprofit and government counts, chain share, PE and REIT flags, recent ownership changes, Special Focus count, and HUD 232 loan activity. Omit state for the US.

FHA-insured HUD Section 232 loans matched to CMS-certified nursing homes: facility, CCN, HUD project name, program, endorsement date and amount, status, note rate, balance, monthly P&I, maturity and servicer. Filter by state, CCN, name or city, servicer, status, rate range or maturity year; sort by balance, rate, maturity or endorsement.

Ranks the states, DC, PR and GU on one nursing home measure: facilities, beds, median occupancy, nurse or RN hours, staff turnover, for-profit or chain share, PE or REIT owner flags, recent ownership changes, Special Focus count, or HUD 232 activity (active loans, balance, endorsements). Returns value, rank and state page.

Runs the SNF Register sizer: HUD Section 232 loan tests (debt service at 1.45x or 1.11x with MIP, 80%/85% loan to value, cost to refinance, original principal for 223(a)(7)) on your NOI, value, rate and payoff; returns the maximum insurable loan, the binding test, payment, MIP, DSCR and cash to close. Pass a CCN to fill in its active FHA loan.