How much house can I afford? Use this repeatable worksheet to estimate a comfortable home price from your income, debts, down payment, taxes, insurance, HOA costs, reserves, and expected mortgage payment—then compare your result with a lender’s preapproval without treating either number as a guarantee.
Overview
Affordability has two different answers. A lender’s maximum approval reflects an underwriting decision based on documented income, debts, credit history, assets, loan program requirements, and the property. Your comfortable budget is the amount you can pay while still handling utilities, maintenance, savings, transportation, family expenses, and unexpected costs. The second number may be lower, and it is usually the more useful starting point for searching real estate listings.
A mortgage affordability calculator can provide a quick estimate, but the result is only as reliable as its inputs. A payment based on principal and interest alone can make an expensive home appear affordable. Your planning number should include the full monthly housing cost and the cash needed before and after closing.
Use this worksheet before contacting lenders, after receiving a preapproval, and whenever you compare homes in different tax districts or communities. For a broader comparison of ownership costs, see The True Monthly Housing Cost Guide.
How to estimate
Work through the calculation in this order. Keeping the steps separate makes it easier to identify which assumption is driving the result.
- Set a comfortable monthly housing limit. Start with dependable take-home income or a carefully documented gross-income budget. Subtract recurring expenses, savings goals, taxes, transportation, child care, insurance, food, utilities, and a monthly reserve for repairs. The amount left for housing is your personal ceiling, not necessarily the amount a lender will approve.
- List recurring debts. Include student loans, auto loans, credit-card minimums, personal loans, support obligations, and any other required monthly payments. Use the payment shown on current statements rather than an informal estimate. Debt-to-income ratio, or DTI, compares monthly debt obligations with gross monthly income; lenders may calculate it differently depending on the loan and borrower profile.
- Estimate the total monthly housing payment. Include principal and interest, property taxes, homeowners insurance, mortgage insurance if applicable, HOA or condominium dues, and any other required property charge. If taxes or insurance are unknown, use a clearly labeled planning estimate and replace it with a quote or local figure before making an offer.
- Convert the payment into a price range. A mortgage calculator can translate a payment into an approximate loan amount using the interest rate, loan term, and down payment. Test more than one rate rather than relying on a single quote. A small rate change can alter the payment and the price you can support.
- Check the cash requirement. The down payment is only one part of the money needed to buy. Add estimated closing costs, prepaid taxes and insurance, inspection and appraisal expenses, moving costs, immediate repairs, and a reserve you will keep after closing. Review the buyer’s closing-cost worksheet before treating a price as attainable.
Quick home budget worksheet
| Input | Your amount | How to use it |
|---|---|---|
| Gross monthly income | $________ | Use dependable, documentable income. |
| Required monthly debts | $________ | Include minimum or contractual payments. |
| Comfortable housing limit | $________ | Choose a budget that leaves room for non-housing goals. |
| Down payment available | $________ | Do not use funds needed for reserves or moving. |
| Estimated interest rate and term | ____% / ____ years | Compare quotes using the same assumptions. |
| Taxes, insurance, HOA, and mortgage insurance | $________/month | Separate these from principal and interest. |
| Cash reserve after closing | $________ | Keep a defined amount for repairs and surprises. |
Inputs and assumptions
Income: Decide whether the calculation uses one borrower’s income or combined income. If income varies through commissions, overtime, self-employment, or seasonal work, ask the lender what documentation and history may be required. Avoid basing the budget on a raise or bonus that is not yet dependable.
Down payment: A larger down payment can reduce the loan amount and may change mortgage insurance or loan pricing, but it also reduces liquidity. Compare a lower down payment with a larger post-closing reserve instead of assuming that putting every available dollar into the home is best.
Interest rate and term: A rate quote depends on factors such as the borrower, property, loan type, points, and timing. When comparing mortgage quotes, hold the loan amount, term, points, estimated fees, and down payment constant. Ask whether the rate is locked and for how long. Estimates are not guarantees until the lender provides the applicable terms and disclosures.
Taxes and insurance: Property taxes can vary by location and property assessment. Insurance costs can vary by coverage, deductible, property characteristics, and availability. Ask for property-specific estimates when possible. If you are considering a condominium or planned community, verify the current HOA dues and ask about known or anticipated special assessments.
Repairs and reserves: A new home can still require maintenance, appliances, landscaping, or safety updates. Set aside money for routine ownership costs and keep a separate emergency reserve. For seasonal planning after purchase, use a home maintenance calendar.
Loan-program assumptions: Down-payment requirements, mortgage insurance, DTI limits, fees, income rules, and loan limits can differ by program and may change. Treat general calculator outputs as planning figures. Confirm the details with a qualified lender and review the terms for the specific property.
Worked examples
The examples below are illustrative only. They are not rate quotes, approval predictions, or recommendations.
Example 1: Comfortable budget below the approval maximum
Suppose a household decides that its full monthly housing limit is $2,400. It estimates $350 for property taxes, homeowners insurance, HOA dues, and possible mortgage insurance. That leaves about $2,050 for principal and interest. The household then tests several interest-rate scenarios and loan terms in a calculator, rather than converting the full $2,400 into principal and interest.
A lender may approve a higher payment after reviewing the household’s gross income and debts. The buyers can still choose a lower search ceiling because they want room for retirement contributions, travel, child-care changes, and repairs. Their marketplace search should use the comfortable ceiling and then filter individual homes by the estimated total payment.
Example 2: A larger down payment is not automatically a larger budget
Another buyer has $80,000 available but wants to retain $20,000 for moving, immediate work, and an emergency reserve. The usable down payment is therefore $60,000, before accounting for closing costs and prepaid items. If the buyer instead uses the full $80,000, the monthly payment may fall, but the household could have less cash when the first repair or income interruption occurs.
The worksheet should show both scenarios: the payment with the planned reserve and the payment with the larger down payment. Compare the monthly savings with the reduction in liquid cash. This same approach helps when comparing condos, townhomes, and detached homes with different HOA or maintenance costs.
Example 3: Two similarly priced homes can have different budgets
Home A and Home B have similar asking prices, but Home A has higher taxes and insurance while Home B has a substantial HOA fee. Their principal-and-interest payments may look alike, yet their total monthly costs differ. Enter each property separately, including property-specific taxes, insurance, HOA dues, and any mortgage insurance. The more affordable listing is the one that fits the complete budget, not necessarily the one with the lower asking price.
When to recalculate
Revisit your home buying budget whenever a planning input changes. Recalculate when mortgage rates or lender quotes move, your income or required debts change, you adjust the down payment, or you switch loan terms. Repeat the exercise when comparing properties in different municipalities, because taxes, insurance, HOA dues, and local costs can change the monthly result.
Update the worksheet after a lender issues a preapproval and compare the lender’s assumptions with your own. Check the loan amount, interest rate, term, estimated taxes, insurance, mortgage insurance, credits, points, and cash-to-close estimate. A preapproval is useful for understanding borrowing capacity, but it does not replace your personal budget or guarantee final approval.
Before making an offer, run one final property-specific version. Confirm the estimated total payment, cash needed at closing, remaining reserve, and likely near-term repairs. If the numbers feel tight before moving in, lower the target price or revisit the assumptions rather than relying on future income or uncertain costs. For the next step, pair this worksheet with an open house inspection checklist and an offer worksheet so the price, contingencies, and ownership costs are considered together.