Value an apartment building at today's loan rates
value_at_rateRuns the Worth Sheet valuation worksheet for a 5+ unit apartment building: from a rent roll and a year of expenses (or a known NOI) it returns NOI, expense ratio, value across your cap rate range, the price a financed buyer can carry at the latest 10-year Treasury plus a lender spread (80% LTV, 1.25x DSCR by default), per-unit value, and the refinance loan the income supports against your balance. An estimate from your numbers, not an appraisal.
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": {
"cap_rate_low_pct": "<cap_rate_low_pct>",
"cap_rate_high_pct": "<cap_rate_high_pct>"
},
"name": "value_at_rate"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| dscr | No | Min debt service coverage, times. Default 1.25 (both agencies' term sheets). | |
| units | No | Number of units, for per-unit value when you give noi_annual. | |
| ltv_pct | No | Max loan-to-value, percent. Default 80 (Fannie Mae and Freddie Mac conventional term sheets). | |
| unit_mix | No | Rent roll by unit type, e.g. [{"units":12,"monthly_rent":1250},{"units":16,"monthly_rent":1500}]. Give this or noi_annual. | |
| 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 | No | Net operating income per year in US dollars, if you already know it. Give this or unit_mix (not both). | |
| spread_pct | No | Lender spread over the 10-year, percent. Default 1.75, the worksheet's placeholder (not a quote). | |
| vacancy_pct | No | Vacancy and bad debt, percent of gross. Default 5. | |
| loan_balance | No | Your current loan balance, US dollars, to compare against the refinance loan. Optional. | |
| 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. | |
| management_pct | No | Management, percent of collected income; charge it even if self-managed. Default 5. | |
| payroll_annual | No | Payroll per year, US dollars. Default 0. | |
| cap_rate_low_pct | Yes | Low end of the cap rate range brokers quote for similar buildings, percent, e.g. 5.5. No government source publishes cap rates. | |
| insurance_annual | No | Insurance per year, US dollars. Default 0. | |
| utilities_annual | No | Owner-paid utilities per year, US dollars. Default 0. | |
| cap_rate_high_pct | Yes | High end of the cap rate range, percent, e.g. 7. | |
| reserves_per_unit | No | Replacement reserves per unit per year, US dollars. Default 300. | |
| treasury_10yr_pct | No | 10-year Treasury yield to use, percent. Default: the latest daily par yield the site has (U.S. Treasury). | |
| admin_other_annual | No | Admin, legal and other expenses per year, US dollars. Put any lump-sum expense total (excluding property taxes) here. Default 0. | |
| amortization_years | No | Amortization in years. Default 30. | |
| other_income_monthly | No | Other income per month (laundry, parking, fees), US dollars. Default 0. | |
| property_taxes_annual | No | Property taxes per year, US dollars. Default 0. With noi_annual, needed only for tax_reset. | |
| repairs_maintenance_annual | No | Repairs, maintenance and turnover per year, US dollars. Default 0. |