How Much House Can I Afford? A Buyer’s Monthly Budget and Offer Comparison Worksheet
home affordabilitymortgage budgetbuyer worksheetclosing costsoffer comparison

How Much House Can I Afford? A Buyer’s Monthly Budget and Offer Comparison Worksheet

SSellMyHouse.live Editorial Team
2026-11-16
5 min read

Use this home-buying worksheet to estimate total monthly costs, upfront cash, offer differences, and affordability under changing conditions.

Knowing how much house you can afford means looking beyond the listing price. This worksheet helps you estimate the full monthly cost of ownership, account for upfront cash needs, compare properties consistently, and stress-test your budget before making an offer.

Overview

A mortgage payment is only one part of a home-buying budget. Your realistic cost may also include property taxes, buildings or homeowners insurance, mortgage insurance, service charges, utilities, routine maintenance, and an allowance for larger repairs. You may also need cash for a deposit, lender and legal fees, inspections, moving costs, and prepaid items.

The central question is not simply, “What loan amount might I qualify for?” It is, “What monthly payment and upfront cost can I manage while keeping room for ordinary life and unexpected expenses?” A lender’s maximum approval can be useful information, but it should not automatically become your target purchase price.

Use the worksheet below for every serious property, lender quote, rate change, or revised offer. Keeping the same categories for each home makes comparisons more useful than judging properties by asking price alone.

How to estimate

Start with two limits: your maximum comfortable monthly housing budget and the cash you can safely use at closing. Set these limits before comparing homes so that a desirable property does not quietly change your assumptions.

Step 1: Set a monthly housing ceiling

Begin with reliable monthly take-home income. Subtract recurring non-housing commitments, such as car finance, student loans, credit-card payments, childcare, support payments, and essential living costs. Then reserve money for savings, emergencies, and goals. The remaining amount is not automatically your housing budget, but it gives you a useful starting point.

Consider both a conservative budget and a maximum budget:

  • Comfortable budget: the payment you could maintain while continuing normal saving and spending.
  • Maximum workable budget: a higher limit that may be possible but would require closer monitoring or fewer financial choices.

Step 2: Estimate the full monthly cost

For each property, add the following:

Monthly itemWhat to enter
Principal and interestThe lender’s payment estimate for the proposed loan, rate, and term
Property taxesThe current or estimated annual bill divided by 12
InsuranceThe best available quote or a clearly marked planning estimate
Mortgage insuranceInclude it if the loan structure requires it
Service or association chargesUse the current charge and check how often it may be reviewed
UtilitiesEstimate electricity, gas, water, waste, and other property-specific costs
Maintenance reserveA monthly amount for routine upkeep and future repairs

Total monthly housing cost = principal and interest + taxes + insurance + mortgage insurance + service charges + utilities + maintenance reserve.

Step 3: Check the cash required

Estimate the deposit or down payment, lender fees, legal or conveyancing fees, valuation and inspection costs, taxes or transfer charges where applicable, prepaid insurance or tax amounts, moving costs, and immediate repairs or furnishings. Subtract these costs from available savings. Keep an emergency reserve separate rather than using every available dollar to complete the purchase.

Inputs and assumptions

Write down the source and date for every important input. Tax bills, insurance quotes, service charges, lender rates, and local transaction costs can change. If a figure is unavailable, label it as an estimate instead of treating it as confirmed.

Reusable home-buying budget worksheet

  • Purchase price: __________
  • Deposit or down payment: __________
  • Estimated loan amount: __________
  • Interest rate and loan term: __________
  • Principal and interest: __________ per month
  • Property taxes: __________ per month
  • Insurance: __________ per month
  • Mortgage insurance: __________ per month
  • Service or association charges: __________ per month
  • Utilities: __________ per month
  • Maintenance reserve: __________ per month
  • Total monthly housing cost: __________
  • Estimated closing and moving costs: __________
  • Cash remaining after completion: __________

Ask the lender or adviser which costs are included in the quoted mortgage payment and which are not. Confirm whether the rate is fixed, variable, or subject to a future change, and ask what happens to the payment under a higher-rate scenario. Also check whether taxes, insurance, or service charges are paid directly by you or collected as part of another payment arrangement.

Affordability guidance and lending assessments vary by location, lender, income type, loan product, and personal circumstances. Use this worksheet for planning, then verify the final numbers with qualified local professionals before committing.

Worked examples

These figures are illustrative only. They are not a current rate, tax, insurance, or closing-cost quote.

Example A: comparing two similar homes

CostHome AHome B
Principal and interest$1,900$1,780
Taxes$300$430
Insurance$130$145
Service charge$0$210
Utilities$260$250
Maintenance reserve$250$180
Total$2,840$2,995

Home B has the lower estimated mortgage payment, but its taxes and service charge make its total monthly cost higher in this example. The comparison also reveals why listing price alone is an incomplete affordability measure.

Example B: testing an offer

Suppose your comfortable monthly ceiling is $2,700, while your maximum workable ceiling is $3,000. A property appears to cost $2,760 using the initial assumptions. Before offering, test at least three changes: a higher interest rate at the next available review or refinancing point, a repair reserve that is larger than planned, and a temporary reduction in household income. If the payment rises above your maximum workable ceiling under a reasonable stress test, consider a lower offer, a larger deposit only if it does not weaken your emergency reserve, or a different property.

When comparing offers, include more than price. Record the deposit, financing terms, inspection conditions, requested credits, expected completion date, and estimated net cash required. A lower price with manageable conditions may be more sustainable than a higher price that depends on every assumption going perfectly.

When to recalculate

Revisit the worksheet whenever an input changes, not just when you begin looking. Recalculate after receiving a new lender quote, changing the deposit, considering a different loan term, or comparing a counteroffer. Repeat the exercise when property taxes, insurance, service charges, or estimated utilities become clearer.

Also recalculate after a change in income, employment, household size, debt, childcare, transportation costs, or planned moving expenses. If a property inspection identifies major work, add the likely payment, cash cost, or maintenance reserve before deciding whether the home remains affordable.

For a practical final check, complete these five actions:

  1. Fill in the worksheet using the latest written figures available.
  2. Separate confirmed costs from estimates and mark the date of each estimate.
  3. Run a higher-rate, higher-repair, and lower-income scenario.
  4. Compare total monthly cost and cash remaining for at least two properties or offer structures.
  5. Verify the final loan, tax, insurance, and transaction figures before signing or committing funds.

A sound home-buying budget is not a one-time calculation. It is a repeatable decision tool that helps you compare homes, respond to changing terms, and protect room in your finances after the purchase.

Related Topics

#home affordability#mortgage budget#buyer worksheet#closing costs#offer comparison
S

SellMyHouse.live Editorial Team

Real Estate Editor

Senior editor and content strategist. Writing about technology, design, and the future of digital media. Follow along for deep dives into the industry's moving parts.