Knowing how much house you can afford is about more than finding a mortgage payment that fits your income. A realistic budget also accounts for existing debts, the down payment, interest rate, property taxes, homeowners insurance, mortgage insurance, HOA dues, maintenance, utilities, and cash needed at closing. This guide provides a repeatable home affordability worksheet, explains the assumptions behind it, and shows how to revisit the estimate when your finances or the market change.
Overview
A home affordability calculator is useful for narrowing a search, but its result is only as reliable as the information entered. Lenders may approve a payment that feels uncomfortable once you include irregular expenses, savings goals, childcare, transportation, or planned repairs. Your personal budget should therefore set a practical ceiling, while a lender’s assessment helps establish what financing may be available.
Start with two limits:
- Monthly housing limit: the amount you can consistently spend on the home without weakening other priorities.
- Cash-to-close limit: the amount you can use for the down payment, closing costs, prepaid items, moving expenses, and an emergency reserve.
The lower of these two limits should guide your home search. A property may have an attractive list price but still be unaffordable if its taxes, insurance, HOA fees, or repair needs are high. The same principle applies when comparing condos, townhomes, and single-family homes; their ongoing costs can differ substantially. For a broader comparison, see condo vs. townhouse vs. single-family home costs.
How to estimate
Use the following five-step process before browsing homes for sale.
1. Calculate dependable monthly income
Use income that is reasonably predictable. For a household with more than one income, consider whether both incomes are likely to continue through the expected ownership period. If income varies, use a conservative average rather than the best month or year. Convert annual income to a monthly figure by dividing by 12, and use either gross income for a lender-style estimate or take-home income for a household-budget estimate. Label which figure you use so you do not compare unlike calculations.
2. List recurring debts and commitments
Include car loans, student loans, credit-card minimums, personal loans, support obligations, and any other regular debt payments. Do not omit a debt simply because its balance is relatively small. The monthly payment affects both your debt-to-income ratio and the money available for everyday life.
3. Set a housing-payment ceiling
Choose a payment that works alongside your complete budget, not just a percentage borrowed from a general rule. A useful starting formula is:
Maximum housing budget = dependable monthly income − recurring debts − essential living costs − savings and financial goals − flexibility buffer
The flexibility buffer covers expenses that are not perfectly predictable, such as medical bills, travel, gifts, car repairs, or higher utility usage. If the result leaves little room for these costs, reduce the target before looking at properties.
4. Convert the housing budget into a purchase price
First reserve part of the monthly housing budget for costs other than the mortgage principal and interest:
Principal and interest allowance = housing budget − property taxes − homeowners insurance − mortgage insurance − HOA dues − planned maintenance
Then use a mortgage calculator or lender quote to test purchase prices at several interest rates and loan terms. The amount borrowed is generally the purchase price minus the down payment, but the exact loan structure can include other requirements or costs. Treat the result as an estimate until you receive a formal loan estimate.
5. Check the cash requirement
Your available cash must cover more than the down payment. Set aside money for closing costs, prepaid taxes and insurance, inspections, appraisal-related expenses, moving, immediate repairs, and an emergency reserve. For a more detailed planning tool, use the closing costs calculator guide. Do not use every dollar in savings just to reach a target down payment.
Inputs and assumptions
Record each input in a worksheet that you can update. Use a range where the final figure is uncertain.
| Input | What to record | Why it matters |
|---|---|---|
| Monthly income | Gross and take-home income | Shows both a lender-style view and a household-budget view |
| Monthly debts | Required payments on all debts | Reduces available borrowing capacity |
| Down payment | Amount available without exhausting reserves | Changes the loan amount and cash needed at closing |
| Interest rate | At least two reasonable rate scenarios | Small changes can affect the payment and price you can support |
| Loan term | For example, a shorter or longer repayment period | Changes the payment and total interest cost |
| Taxes and insurance | Property-specific estimates when available | These costs are part of the monthly housing obligation |
| HOA dues | Monthly fee plus known special assessments | Fees can materially change affordability |
| Maintenance | A monthly reserve based on the property’s age and condition | Helps prepare for repairs and replacements |
| Closing and moving costs | Cash required before and immediately after purchase | Prevents a budget shortfall at move-in |
Taxes, insurance, and HOA costs should be checked for each property rather than copied from a previous estimate. A home in a different municipality may have different taxes, while an older property may justify a larger maintenance reserve. If you are considering a lower-priced property, review the risks described in how to find cheap houses for sale without costly surprises.
Also distinguish between a recurring cost and a one-time cost. Mortgage principal, interest, taxes, insurance, HOA dues, and routine maintenance belong in the monthly budget. The down payment, closing costs, inspection, moving, and initial furnishing are usually cash-to-close or move-in costs. Keeping these categories separate makes the estimate easier to audit.
Worked examples
The following examples use invented assumptions for illustration, not current market quotes or lending standards.
Example 1: Converting a monthly budget into a price range
Suppose a household has $9,000 in dependable monthly take-home income. It pays $1,200 in recurring debt, budgets $4,200 for essential living costs, directs $1,000 toward savings goals, and keeps a $400 flexibility buffer. The household’s initial housing budget would be:
$9,000 − $1,200 − $4,200 − $1,000 − $400 = $2,200 per month
Assume the household reserves $500 of that amount for property taxes, insurance, HOA dues, mortgage insurance, and maintenance. The estimated principal-and-interest allowance is therefore $1,700 per month. The household can now test a range of purchase prices using its planned down payment, loan term, and several interest-rate assumptions. If the payment only works at the most favorable rate, the target is fragile and should be reduced.
Example 2: Checking the cash-to-close limit
Assume the same household has $85,000 in liquid savings. It decides to retain $25,000 as an emergency reserve and $5,000 for moving and immediate setup. That leaves $55,000 for the down payment and purchase-related cash costs. If estimated closing and prepaid costs are $15,000, the maximum planned down payment is $40,000, before allowing for any property-specific inspection or repair needs.
This example shows why a monthly-payment estimate is not enough. A household might qualify for a higher purchase price but lack the cash needed to complete the transaction safely. It could respond by lowering the target price, increasing the time spent saving, exploring eligible assistance with qualified professionals, or reconsidering the type and location of property. Monthly costs can also be compared with renting by reviewing houses for rent versus apartments.
When to recalculate
Affordability is a moving estimate, so revisit the worksheet whenever a major input changes. Recalculate when mortgage rates or loan terms change, when the down payment grows, when income or employment changes, or when you take on or pay off a debt. Update the estimate after choosing a specific property, because its taxes, insurance, HOA dues, condition, and utility costs may differ from the assumptions used during an initial search.
Recalculate before making an offer if the purchase price changes, the seller offers a credit, you plan to buy points, or the inspection identifies repairs. Recheck the cash-to-close figure after receiving a loan estimate and again before closing. If your budget depends on overtime, bonuses, a future raise, or a hoped-for refinance, run a second version that excludes that uncertain income or benefit.
For a practical next step, create three worksheet versions: a comfortable target, a cautious lower target, and a maximum scenario. Enter the same debts and living costs in each version, then change only the purchase price, rate, down payment, and property-specific costs. Search listings within the comfortable range first, use the lower range when market conditions or costs are uncertain, and treat the maximum scenario as a limit rather than a goal. Update the worksheet whenever your numbers change so your home search remains aligned with the life you want to afford after moving in.
