affordable_price
Read-only
What's the most this buyer can afford? The reverse of affordability — 'what price
can I afford?' instead of 'can I afford this specific home?'. Solves for the maximum
home price under standard lender limits: a front-end DTI cap (default 28% = housing /
gross income) and a back-end cap (default 36% = housing + other debts / gross income).
If liquid_savings is given, also caps by the cash available for down payment + closing
and reports which limit binds. Returns the affordable price, the PITI and DTIs at that
price, and the cash to close. Pass address to ground property tax + insurance in the
ZIP's real rates.
This is a lender-limit ceiling, not a comfort recommendation — feed the result into
`affordability` (or buy_vs_rent) to check monthly slack and whether buying pencils.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| address | No | Full US street address, or a bare 5-digit ZIP. Pass it whenever it is known: it grounds property tax, insurance and the appreciation forecast in that ZIP's real figures instead of national defaults. | |
| fixed_rate | No | Mortgage interest rate as an annual PERCENT: 6.75 means 6.75%. Not a decimal (not 0.0675). | |
| hoa_monthly | No | HOA or condo fee in US dollars per month. 0 for most single-family homes. | |
| annual_income | Yes | Gross household income before tax, in whole US dollars per year, e.g. 140000. | |
| monthly_debts | No | Recurring DEBT obligations a lender counts, in dollars per month: car payment, student loan, minimum credit-card payment. This feeds DTI. Do NOT put groceries, utilities or childcare here. | |
| insurance_rate | No | Annual homeowners insurance as a PERCENT of home value: 0.45 means 0.45%/yr. Leave unset to use the regional default. | |
| liquid_savings | No | Cash available for down payment and closing costs, in US dollars. Supplying it adds the post-closing cash cushion and the cash-limited price check. | |
| back_end_dti_pct | No | Back-end DTI cap as a PERCENT: housing plus other debts, divided by gross income. The lender standard is 36. Only change it if the user names a different limit. | |
| down_payment_pct | No | Down payment as a PERCENT of price: 20 means 20%. Not a fraction (not 0.20). | |
| front_end_dti_pct | No | Front-end DTI cap as a PERCENT: housing cost divided by gross income. The lender standard is 28. Only change it if the user names a different limit. | |
| property_tax_rate | No | Annual property tax as a PERCENT of home value: 0.55 means 0.55%/yr. Leave unset to use the ZIP's real rate when `address` is given. |