How much house can I afford? The answer is not simply the largest mortgage a lender will approve. This home-buying budget worksheet helps you estimate a sustainable monthly housing cost by including principal, interest, taxes, insurance, maintenance, utilities, fees, existing debts, changing income, the down payment, closing costs, and the emergency reserve you want to keep after purchase.
Overview
A realistic home affordability calculation starts with your household cash flow, not a target property price. A mortgage payment may look manageable when it includes only principal and interest, but ownership also brings recurring and occasional costs. Your budget should leave room for food, transportation, health costs, childcare, debt payments, savings, repairs, and normal changes in household spending.
Use this worksheet to find a maximum comfortable monthly housing cost. Then work backward to compare home prices under different down payments and interest-rate assumptions. Treat the result as a planning estimate rather than a lending decision. A lender may assess your income, credit history, debts, assets, and loan terms differently from your personal budget.
Before comparing properties, decide on three limits:
- Monthly housing limit: the amount your household can spend on all recurring home costs while continuing essential savings and debt payments.
- Cash-to-close limit: the amount available for the down payment, closing costs, moving expenses, initial repairs, and other purchase-day needs.
- Post-purchase reserve: the emergency savings you want to keep after closing rather than using every available dollar to buy the home.
Keeping these limits separate helps prevent a common mistake: choosing a monthly payment that appears affordable but requires an unsafe upfront cash contribution or leaves no room for unexpected costs.
How to estimate your affordable home price
Follow this workflow before requesting detailed loan estimates or making an offer.
- Start with reliable take-home income. Use recurring after-tax income that you reasonably expect to continue. If income varies, use a conservative month or an average that does not depend on bonuses, overtime, or irregular payments.
- List non-housing obligations. Include credit-card payments, student or personal loans, auto finance, child support, insurance, subscriptions, and any other recurring commitment. Do not omit payments simply because they are scheduled to end soon unless you have a clear plan for the transition.
- Build a complete household budget. Review several months of bank and card activity. Separate essential costs from flexible spending, and add sinking funds for annual bills, travel, school costs, vehicle repairs, and medical expenses.
- Choose a sustainable housing limit. Subtract non-housing spending, planned savings, debt payments, and a buffer for irregular costs from take-home income. The remainder is not automatically your housing budget; retain room for income changes and rising ownership costs.
- Calculate the full monthly housing cost. Add principal and interest to property taxes, homeowners insurance, mortgage insurance if applicable, homeowners association or building fees, maintenance, utilities, and any other property-specific charge.
- Test the purchase under less favorable assumptions. Recalculate with a higher interest rate, a larger insurance or tax estimate, a lower income, or a period of reduced work. If the budget fails under a reasonable stress test, reduce the target price or increase the cash reserve.
- Check the cash requirement. Confirm that the down payment and closing costs do not consume the emergency fund. Add moving costs, immediate furnishings, inspections, repairs, and prepaid items where relevant.
A mortgage or loan repayment calculator can estimate principal and interest, but it cannot decide whether the resulting payment fits your family budget. Use the calculator as one line in a broader worksheet.
Inputs and assumptions for a housing budget worksheet
Copy the categories below into a spreadsheet or budget planner. Enter monthly amounts where possible, converting annual costs by dividing them by 12.
| Category | What to enter | Why it matters |
|---|---|---|
| Take-home income | Reliable monthly household income | Shows what is actually available for bills and savings |
| Principal and interest | Loan amount, rate, and term estimate | Forms the core mortgage payment |
| Property taxes | Annual estimate divided by 12 | Taxes can materially change the monthly cost between locations |
| Homeowners insurance | Monthly or annual premium estimate | Coverage and premiums vary by property and location |
| Mortgage insurance | Include if required by the loan structure | May add to the payment until loan conditions change |
| Maintenance reserve | Your planned monthly repair and replacement fund | Roofs, appliances, systems, and exterior work are not monthly bills but still need funding |
| Utilities | Electricity, gas, water, trash, and internet | Costs can differ substantially from a rental or previous home |
| Association or building fees | Current recurring fee plus a review of possible increases | Fees may cover shared services but remain part of ownership cost |
| Other debts | Minimum required payments | These reduce the income available for housing |
| Emergency reserve | Cash to retain after closing | Protects against job disruption, repairs, and other surprises |
For the mortgage estimate, record the purchase price, down payment, loan amount, interest rate, repayment term, and whether the rate is fixed or adjustable. Also note assumptions that are easy to overlook, such as lender credits, points, escrowed taxes and insurance, or a temporary introductory rate. A low initial payment is not a complete affordability measure if it can change later.
Closing costs should be estimated separately from the down payment. The amount depends on the loan, location, transaction, and services selected, so use a current lender or settlement estimate rather than a universal percentage. Ask which items are one-time costs and which will recur through an escrow account or monthly bill.
Worked examples
Assume a household has $7,000 in reliable monthly take-home income. Its non-housing spending, including debt payments and planned savings, totals $4,800 per month. The household chooses to retain $500 as a general cash-flow buffer, leaving a planning ceiling of $1,700 for total monthly housing costs.
That $1,700 must cover more than principal and interest. One planning comparison might look like this:
| Housing cost | Scenario A | Scenario B |
|---|---|---|
| Principal and interest | $1,150 | $1,300 |
| Property taxes | $220 | $220 |
| Insurance | $110 | $110 |
| Mortgage insurance or similar loan cost | $80 | $0 |
| Maintenance reserve | $100 | $100 |
| Utilities | $140 | $140 |
| Association or other fees | $0 | $100 |
| Total monthly housing cost | $1,800 | $1,970 |
Both scenarios exceed the household’s $1,700 planning ceiling, even though the principal-and-interest figures alone may look manageable. The household could test a lower purchase price, a larger down payment, a property with lower taxes or fees, or a different interest-rate assumption. It should not solve the gap by removing maintenance or emergency savings from the worksheet.
Next, stress-test the preferred option. Ask what happens if one income falls temporarily, insurance rises, utilities are higher than expected, or a loan payment changes after an introductory period. The goal is not to predict every expense precisely; it is to identify whether the budget has enough margin to absorb ordinary uncertainty.
When to recalculate your home affordability
Revisit this worksheet whenever a major input changes. Recalculate before contacting lenders again if mortgage rates move materially, your down payment changes, or a lender presents different terms. Compare the full payment, not only the advertised rate or principal-and-interest line.
Run the numbers again after a pay raise, job change, reduced work schedule, new child, change in childcare costs, new loan, credit-card balance increase, or significant change in insurance or property taxes. A larger household or a move to a different location can also change utilities, transportation, taxes, fees, and maintenance needs.
Use the following final checklist before treating a home price as affordable:
- Have you included principal, interest, taxes, insurance, maintenance, utilities, and fees?
- Can you continue debt payments, essential savings, and planned sinking funds?
- Will the down payment and closing costs leave a meaningful emergency reserve?
- Does the budget work if income is temporarily lower or a recurring cost is higher?
- Have you compared the current loan estimate with the assumptions in your worksheet?
Keep a saved copy of the worksheet and date each version. Re-running it when income, debts, rates, household needs, or target locations change gives you a clearer basis for deciding how much house you can afford. For related planning, review a guide to emergency funds, audit recurring expenses with the household bill checklist, and use a debt payoff method before adding a large new obligation.