Knowing how much house you can afford is not the same as knowing the largest loan a lender may approve. This workbook-style guide helps you build a safer budget, compare mortgage offers on a like-for-like basis, test rate and cost changes, and identify the figures to update before making an offer or applying for pre-approval.
Overview
A useful affordability estimate answers three separate questions:
- What monthly housing payment fits comfortably within your household budget?
- How much cash can you commit to the down payment and purchase costs without exhausting your reserves?
- Which mortgage structure remains manageable if rates, taxes, insurance, or household expenses change?
A lender’s maximum approval can be a helpful reference point, but it should not automatically become your target price. Lenders assess income, debts, credit history, loan terms, and property details according to their own criteria. Your personal budget must also account for irregular spending, maintenance, savings goals, childcare, transport, and an emergency reserve.
Use the workbook below in two stages. First, calculate a price range from your own cash flow. Then compare mortgage offers using the same assumptions. A mortgage comparison is more meaningful when it includes the payment, upfront fees, ongoing charges, total interest or financing cost where available, and the effect of a future rate change.
How to estimate
1. Start with a sustainable monthly housing budget
Begin with reliable monthly take-home income, or use a conservative income figure if earnings vary. Subtract recurring non-housing commitments, including car or student payments, credit cards, personal loans, childcare, support payments, and other contractual debts. Then allow for essential living costs, savings contributions, and a buffer for variable expenses.
The amount left is not automatically your mortgage budget. Set aside separate allowances for property taxes or similar local charges, home insurance, utilities, maintenance, service charges, and any homeowners’ association or building fees. The remainder is the maximum housing payment your personal budget can support under the assumptions you entered.
For a simple workbook, use this structure:
Monthly housing budget = take-home income − non-housing debts − essential spending − planned savings − financial buffer
2. Convert the payment into an estimated loan
Use a mortgage calculator to estimate the loan amount supported by your target principal-and-interest payment. The result depends on the interest rate, repayment term, payment frequency, and whether the rate is fixed, variable, or subject to a later reset.
For a standard repayment mortgage, the payment is commonly calculated using the loan amount, periodic interest rate, and number of payments. You do not need to perform the formula manually if you use a calculator, but you should record the inputs so another offer can be tested consistently.
Next, add the down payment to the estimated loan amount to create a provisional purchase price. Do not use every available dollar for the down payment. Deduct closing costs, taxes or stamp duty where applicable, lender and legal fees, moving expenses, initial repairs, and the emergency reserve you want to retain after completion.
3. Check the result against debt-to-income measures
Debt-to-income ratio, or DTI, compares recurring monthly debt payments with gross monthly income. A basic version is:
DTI = total monthly debt payments ÷ gross monthly income × 100
Include the proposed housing payment and other recurring debts in the version used for your planning. Lenders may calculate DTI differently, use different income definitions, or apply additional affordability tests. Treat any general ratio as a screening tool rather than a guaranteed approval threshold. Confirm the lender’s current requirements when you seek pre-approval.
Inputs and assumptions
Create one worksheet for your household budget and another for mortgage comparison. Record the date beside every rate, fee, tax estimate, and insurance quote so you know which figures need refreshing.
Affordability worksheet inputs
- Gross monthly income and take-home monthly income
- Income that is variable, seasonal, commissioned, or likely to change
- Existing monthly debt payments
- Essential living costs and planned savings
- Down payment or deposit funds, including money that must remain untouched
- Estimated closing costs, taxes, legal fees, and moving expenses
- Property taxes, insurance, utilities, maintenance, and building charges
- Emergency reserve target after the purchase
Mortgage comparison inputs
- Purchase price and loan amount
- Interest rate, rate type, and period for which it applies
- Repayment term and payment frequency
- Down payment and any mortgage insurance or similar charge
- Arrangement, valuation, legal, broker, and other lender fees
- Discounts, credits, or fees that apply only under specific conditions
- Early repayment, refinancing, or rate-reset assumptions where relevant
Separate one-time costs from recurring costs. A low advertised rate may not produce the lowest overall cost if it comes with substantial fees. Conversely, a higher rate may be worth considering if the fee structure, flexibility, or expected time in the property better matches your plans. Compare the same loan amount and term before judging the offers.
Worked examples
Consider a hypothetical buyer with a take-home income of 5,800 per month. After existing debt payments, essential spending, planned savings, and a financial buffer, the buyer decides that 1,850 per month is the maximum sustainable housing budget.
The buyer estimates 350 per month for property taxes, insurance, maintenance, and building-related costs. That leaves 1,500 per month for principal and interest. These figures are illustrative only; they are not a recommended budget or a current market quote.
The buyer then tests two hypothetical mortgage offers for the same loan amount and repayment term:
- Offer A: a lower rate with 4,000 in upfront lender fees.
- Offer B: a slightly higher rate with 1,000 in upfront lender fees.
First, enter both rates into a mortgage calculator and confirm that the principal-and-interest payment fits within the 1,500 limit. Next, add the difference in fees to the purchase cash requirement. Finally, estimate the fee break-even period:
Fee break-even period = additional upfront fee ÷ monthly payment saving
If Offer A saves 50 per month but costs 3,000 more upfront, its simple fee break-even point is 60 months. That calculation does not account for taxes, changing rates, opportunity cost, or the possibility of moving or refinancing earlier. It simply shows why the intended time in the mortgage matters.
Run a sensitivity table for each offer. Test the payment at the quoted rate, a higher rate, a lower rate, and a change in property-related costs. If a modest change pushes the budget beyond its limit, reduce the target price, increase the cash reserve, choose a different term, or continue comparing loans rather than relying on the most optimistic scenario.
When to recalculate
Affordability is a moving calculation, not a one-time answer. Re-run the workbook before requesting pre-approval, when a lender changes the rate or fees, when your income or debts change, and whenever you consider a different property price. Recalculate after receiving updated tax, insurance, service-charge, or maintenance information for a specific home.
It is also worth revisiting the numbers if the purchase timeline extends. Rates, loan limits, lender criteria, and transaction costs can change, and a pre-approval may have an expiry period or conditions. Check current lender and local requirements instead of carrying old assumptions into a new application.
For a practical next step, save three versions of your workbook: a comfortable budget, a maximum acceptable budget, and a stress-tested budget. Use the comfortable figure for property searching, the maximum only as a boundary, and the stress-tested version to judge whether the mortgage remains manageable if costs rise or income falls temporarily. Keep the mortgage comparison table beside your pre-approval documents, then update it whenever a new offer arrives. For related planning, see the mortgage payment comparison worksheet, the closing costs calculator guide, and the accepted offer to closing timeline.
