Size a hotel or motel loan
size_hotel_loanRuns the motel.loans hotel loan sizer on your numbers: RevPAR, rooms and total revenue, each expense line, NOI, annual debt service, DSCR, the largest loan the cash flow supports at the lender's minimum DSCR, the loan-to-price cap, which one binds, cap rate, price per key and breakeven occupancy. Pick a brand to fill franchise fees from its FDD and a program (SBA 7(a), SBA 504, conventional) to fill rate, amortization and loan-to-price as the calculator does.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"rooms": "<rooms>",
"adr": "<adr>",
"occupancy_pct": "<occupancy_pct>",
"price": "<price>"
},
"name": "size_hotel_loan"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| adr | Yes | Average daily rate in dollars, e.g. 89. | |
| loan | No | Loan requested in dollars. Default: price times the maximum loan-to-price. | |
| brand | No | Franchise brand name or slug (e.g. "Super 8", "comfort-inn") to fill franchise fees from its FDD. Omit for an independent with no franchise fees. | |
| price | Yes | Purchase price or value in dollars, e.g. 3200000. | |
| rooms | Yes | Rooms (keys), e.g. 64. | |
| program | No | Fills rate, amortization and maximum loan-to-price the way the calculator's program buttons do. Default sba_7a. | sba_7a |
| opex_pct | No | Operating costs as a percent of total revenue, excluding franchise fees, management, taxes, insurance and reserve. Default 56 (the calculator example; use the trailing-12 P&L). | |
| rate_pct | No | Interest rate, percent. Overrides the program rate. | |
| insurance | No | Insurance, dollars a year. Default 0: pass the real figure or NOI is overstated. | |
| dscr_target | No | Lender's minimum debt service coverage, e.g. 1.25. Default 1.25 (SBA 7(a) hotel acquisition). | |
| max_ltv_pct | No | Lender's maximum loan to price or value, percent. Overrides the program. | |
| reserve_pct | No | FF&E reserve as a percent of total revenue. Default 4. | |
| occupancy_pct | Yes | Occupancy, percent, e.g. 62. | |
| management_pct | No | Management fee as a percent of total revenue. Default 0 (owner-operated). | |
| property_taxes | No | Property taxes, dollars a year. Default 0: pass the real figure or NOI is overstated. | |
| franchise_fee_pct | No | Franchise fees as a percent of rooms revenue. Overrides the brand. | |
| other_revenue_pct | No | Other revenue as a percent of rooms revenue (vending, pet fees, meeting room). Default 2. | |
| amortization_years | No | Amortization in years. Overrides the program term. | |
| franchise_fee_per_room_month | No | Franchise fees per room per month in dollars. Overrides the brand. |