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 item | What to enter |
|---|---|
| Principal and interest | The lender’s payment estimate for the proposed loan, rate, and term |
| Property taxes | The current or estimated annual bill divided by 12 |
| Insurance | The best available quote or a clearly marked planning estimate |
| Mortgage insurance | Include it if the loan structure requires it |
| Service or association charges | Use the current charge and check how often it may be reviewed |
| Utilities | Estimate electricity, gas, water, waste, and other property-specific costs |
| Maintenance reserve | A 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
| Cost | Home A | Home 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:
- Fill in the worksheet using the latest written figures available.
- Separate confirmed costs from estimates and mark the date of each estimate.
- Run a higher-rate, higher-repair, and lower-income scenario.
- Compare total monthly cost and cash remaining for at least two properties or offer structures.
- 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.