affordability
Read-only
Can this buyer afford this home? Returns the monthly PITI payment, front-end and back-end debt-to-income ratios (what a lender qualifies on), the income needed at a 28% front-end ratio, estimated after-tax money left over each month, the cash cushion left after closing, and a plain Comfortable / Qualifiable-tight / Stretch verdict.
monthly_debts = recurring debt obligations a lender counts (car, student loan, minimum
credit-card) — NOT living costs; this feeds DTI. monthly_expenses = living costs (food,
utilities, childcare) used ONLY for the 'left over each month' life check, never DTI.
Pass `address` to ground property tax + insurance in the ZIP's real rates. Pass
`liquid_savings` to get the post-closing cash cushion (months of payment covered).
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). | |
| home_price | Yes | Purchase price in whole US dollars, e.g. 650000 (not 650 or 650k). | |
| 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. | |
| down_payment_pct | No | Down payment as a PERCENT of price: 20 means 20%. Not a fraction (not 0.20). | |
| monthly_expenses | No | Ordinary living costs in US dollars per month — food, utilities, childcare. Used ONLY for the 'left over each month' life check and NEVER for DTI. Keep these separate from `monthly_debts`, which is the lender-visible figure. | |
| marginal_tax_rate | No | Marginal federal income tax rate as a PERCENT: 24 means 24%. Used only to estimate after-tax take-home for the monthly-slack figure. | |
| 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. |