Knowing how much house you can afford is about more than qualifying for a mortgage. This worksheet helps you build a safer price range by combining income, existing debt, the down payment, mortgage costs, taxes, insurance, maintenance, closing costs, emergency savings, and the lifestyle expenses you do not want to sacrifice.
Overview
A lender’s maximum approval amount is not necessarily a comfortable home-buying budget. Approval decisions generally focus on whether you can meet the loan’s required payments, while your personal budget must also account for repairs, savings, transport, utilities, childcare, travel, and other priorities.
Use this guide as a repeatable home affordability calculator. The result is not a loan offer or financial advice; it is a planning range that you can update when mortgage rates, income, debts, taxes, insurance, or household plans change.
Start with three figures:
- Target monthly housing cost: the amount you can spend without putting essential goals at risk.
- Available cash: funds for the down payment, closing costs, moving expenses, immediate work, and emergency reserves.
- Maximum purchase price: the home price that fits both the monthly and upfront limits.
For a broader view of recurring expenses, see How to Calculate the True Cost of Homeownership. It is useful to consider this affordability worksheet alongside a mortgage comparison rather than relying on one advertised payment.
How to estimate
Step 1: Calculate dependable monthly income. Use regular, after-tax income that you reasonably expect to continue. If income varies, use a conservative average rather than an unusually strong month. For a joint purchase, agree on whether both incomes will be included and how you would manage the payment if one income temporarily changed.
Step 2: List existing monthly commitments. Include credit cards, personal loans, student loans, vehicle finance, support payments, subscriptions you intend to keep, and any other recurring obligation. Do not leave out debts simply because they will be paid off soon; instead, create a separate version of the worksheet showing the budget after repayment.
Step 3: Set a personal housing limit. Decide what portion of monthly income can go toward the full cost of owning a home. A lender’s debt-to-income calculation can be a useful reference, but it should not replace your own spending plan. Subtract the monthly amount you need for savings, retirement, childcare, transportation, food, health costs, and discretionary spending before setting the housing limit.
Step 4: Build the full monthly housing payment. A monthly mortgage payment calculator should include:
- Principal and interest
- Property taxes or equivalent local charges
- Home insurance
- Mortgage insurance, if applicable
- Condominium, association, or shared-building fees
- A maintenance and repair allowance
The amount available for principal and interest is:
Maximum principal-and-interest payment = target monthly housing cost − taxes − insurance − fees − mortgage insurance − maintenance allowance
If the result is small or negative, the purchase price is too high for the selected budget, even if a lender might approve it.
Step 5: Convert the payment into a price range. Enter the principal-and-interest limit, loan term, interest rate, and down payment into a mortgage calculator. Test more than one rate and avoid treating the lowest advertised rate as guaranteed. For a fixed versus variable mortgage decision, model how the payment could change if the rate moves, using assumptions that are clear and conservative.
Inputs and assumptions
Income, debts, and cash reserves
Record gross income if you are comparing your estimate with a lender’s ratio, but build your household budget using take-home pay. Include irregular but predictable costs by converting them into monthly amounts. For example, an annual insurance bill or school expense can be divided by twelve so it does not disappear from the monthly plan.
Your available cash should not be treated as one large down payment. Separate it into:
- Down payment
- Closing costs and local transfer charges
- Inspection, valuation, legal, or administrative costs where applicable
- Moving and initial setup
- Immediate repairs, furnishings, and safety work
- Emergency savings remaining after completion
Use a local closing costs calculator, stamp duty calculator, or equivalent tool for jurisdiction-specific charges. Rules and fees vary by location and transaction, so confirm estimates before making an offer.
Maintenance and replacement planning
Maintenance is not optional just because a home is newly built or recently renovated. Set aside a monthly amount for routine work, seasonal servicing, and larger replacements. A home with an older roof, heating system, plumbing installation, or windows may require a larger reserve than a newer property, even when the mortgage payment is identical.
Review the guide to budgeting for home repairs and the replacement timelines for major home systems before finalizing your estimate. These costs affect affordability because a low purchase price can still produce a high ownership burden.
Home price is not the same as total cost
Two homes with the same purchase price can have very different monthly costs. Compare property taxes by area, insurance requirements, association fees, commuting costs, utility needs, and likely maintenance. During viewings, use a home inspection checklist to identify visible concerns, then adjust your repair reserve when more information becomes available.
Worked examples
Assume a household has a dependable monthly take-home income of $6,000 and decides that its total housing budget should not exceed $2,100. This is a personal planning assumption, not a universal affordability rule.
The household estimates:
- Property taxes: $300 per month
- Home insurance: $120 per month
- Association fee: $80 per month
- Maintenance reserve: $250 per month
- Mortgage insurance: $50 per month
The amount available for principal and interest is:
$2,100 − $300 − $120 − $80 − $250 − $50 = $1,300 per month
The household can now enter $1,300 as the principal-and-interest limit in a mortgage calculator and test the expected loan term, interest rate, and down payment. The resulting purchase price is only a starting point. The household should also test a higher rate, a lower down payment, and a scenario in which taxes or insurance rise.
For a second scenario, suppose the same household finds a home with no association fee but expects higher maintenance because of the property’s age. If the maintenance reserve increases by $150 and the fee disappears, the monthly limit changes by only $70 overall. This illustrates why comparing homes by price alone can be misleading: removing one cost does not automatically make a property more affordable.
Finally, suppose the household has enough cash for a large down payment but would have almost no emergency reserve afterward. The purchase may reduce the mortgage payment while increasing financial vulnerability. A safer price may preserve cash for repairs, job changes, medical expenses, and other unexpected needs.
When to recalculate
Revisit your affordability worksheet whenever a major input changes. Recalculate after a mortgage rate change, a job or income change, a new loan, a large change in savings, or a shift in household responsibilities. Update the estimate when property taxes, insurance, association fees, or expected maintenance become clearer for a specific home.
Run the worksheet at these practical checkpoints:
- Before speaking with lenders, so you know your preferred budget rather than only your maximum approval.
- Before making an offer, using the actual tax, insurance, fee, and inspection information available.
- Before choosing between fixed and variable financing, using several rate scenarios.
- Before closing, confirming that the down payment and transaction costs will not eliminate your emergency reserve.
- After moving in, replacing estimates with real utility, insurance, maintenance, and repair costs.
Keep a simple copy of the worksheet and label each version with the date and assumptions. Pair it with the first-time home buyer checklist for the buying process, then use the annual home maintenance schedule once you own the property. The most useful answer to “how much house can I afford?” is not a single maximum number. It is a price range that still works when ordinary ownership costs and reasonable surprises are included.
