How much house can I afford? This reusable mortgage budget worksheet helps you answer that question by combining principal, interest, taxes, insurance, mortgage insurance, HOA fees, maintenance, closing costs, and emergency reserves. Use your own income and quotes, then recalculate when rates, property costs, or household finances change.
Overview
A mortgage affordability calculator can show a monthly payment, but a responsible home-buying budget needs to go further. The amount a lender is willing to approve is not necessarily the amount that fits comfortably in your life. Your budget should leave room for utilities, transportation, food, savings, repairs, taxes, and unexpected expenses after the housing payment is made.
Start with two separate limits:
- Payment limit: the maximum monthly housing cost you can carry while preserving your other priorities.
- Cash limit: the amount you can use for the down payment, closing costs, moving expenses, immediate repairs, and reserves without draining your savings.
Use the lower result as your working home price. A listing may appear affordable based on principal and interest alone while becoming uncomfortable after property taxes, insurance, HOA dues, maintenance, and mortgage insurance are included.
It can also help to track the effect of a purchase on your wider balance sheet. A net worth tracker can show how the down payment, home equity, mortgage balance, and remaining cash change over time.
How to estimate
Build the worksheet in five steps. Keep the assumptions visible so you can change one input without rebuilding the entire estimate.
- Calculate reliable gross monthly income. Use income you reasonably expect to continue. For variable pay, consider using a conservative average rather than the strongest recent month. If two people are buying, agree on what happens if one income falls or disappears.
- List recurring monthly debts. Include car loans, student loans, credit-card minimums, personal loans, alimony or support obligations, and any other required payments. Do not omit a debt simply because it will be paid off soon unless that payoff is certain and included in your cash plan.
- Choose a personal housing-payment ceiling. You may compare several percentages of gross monthly income as planning scenarios, but there is no universal percentage that works for every household. A family with high childcare costs or unstable income may need a lower ceiling than a household with few obligations.
- Estimate the complete monthly housing cost. Add principal and interest to property taxes, homeowners insurance, mortgage insurance, HOA or condominium fees, and a maintenance allowance.
- Convert the payment into a home-price range. Test different down payments, loan terms, and interest-rate assumptions. Then check whether the required upfront cash still leaves an emergency reserve.
The core worksheet is:
Total monthly housing cost = principal + interest + property taxes + homeowners insurance + mortgage insurance + HOA fees + maintenance allowance.
For principal and interest, a calculator can use the loan amount, annual interest rate, loan term, and payment frequency. The loan amount is generally the purchase price minus the down payment, subject to the loan program and lender’s rules. Treat the result as an estimate until a lender provides a formal quote.
Inputs and assumptions
Accuracy depends less on a complicated formula than on using realistic inputs. Create a worksheet with these fields:
- Gross monthly income: employment, business, rental, or other income that is appropriate to include in your planning.
- Existing monthly debt: required payments, not just balances.
- Purchase price and down payment: test both a percentage and a fixed dollar amount.
- Interest rate and term: use the rate you are evaluating, and run a higher-rate scenario to test resilience.
- Property taxes: use the tax estimate for the specific property or a local estimate. Taxes can differ substantially between locations and properties.
- Homeowners insurance: use a quote when possible. Coverage, location, deductible, age, and property features can affect the premium.
- Mortgage insurance: include the lender’s estimate when applicable. Do not assume it will be zero without confirming the loan structure.
- HOA or condominium fees: check current dues and ask whether special assessments or planned increases are possible.
- Maintenance: set aside a monthly amount even if the home is new. The right allowance depends on the property’s age, systems, size, and your ability to handle repairs.
- Cash reserves: subtract the down payment, closing costs, prepaid items, moving expenses, and immediate repairs from available savings. The amount left should support your emergency plan.
Keep one-time costs separate from monthly costs. Closing costs, lender fees, inspections, prepaid insurance, property-tax adjustments, moving expenses, and furnishing costs do not belong in the monthly payment, but they can determine whether the purchase is affordable.
Also compare the purchase with your other goals. A larger payment may reduce contributions to retirement or taxable investments. If you are weighing that trade-off, an asset allocation calculator can help you review the cash and investment mix that remains after buying.
Worked examples
These examples use hypothetical inputs for illustration only. Replace every figure with your income, local costs, lender quote, and planned reserves.
Example 1: testing a purchase price
Suppose a household earns $9,000 per month before taxes and has $500 in required monthly debt payments. The household chooses an initial personal housing ceiling of $2,250 per month. That is a planning choice, not a lender rule.
For a hypothetical $300,000 home, assume a 20% down payment and a $240,000 loan. Using an illustrative fixed rate and term, the principal-and-interest estimate is entered as $1,516 per month. The household then adds assumed costs of $250 for property taxes, $100 for insurance, $75 for HOA dues, and $250 for maintenance. The estimated total is:
$1,516 + $250 + $100 + $75 + $250 = $2,191 per month.
This fits below the chosen $2,250 ceiling by $59, but the margin is narrow. The household should test higher taxes, a higher insurance quote, a repair, or a rate change before treating the price as comfortable. It must also confirm that the down payment and closing costs do not consume its emergency reserve.
Example 2: comparing a larger down payment
Now assume the same household considers a $300,000 home with a smaller down payment. The loan balance rises, increasing principal and interest. Mortgage insurance may also apply depending on the loan structure. Even if the purchase price has not changed, the complete monthly cost can move above the household’s ceiling.
The useful comparison is not simply “How much does the payment fall?” It is “How much cash is committed upfront, how much monthly flexibility is created, and how much reserve remains?” A larger down payment can reduce borrowing, but it may leave too little liquid cash for repairs or income disruption. A smaller down payment can preserve cash while increasing the monthly payment and possibly adding mortgage insurance.
Run both cases through the same worksheet. For interest-rate comparisons, you can pair the mortgage estimate with an inflation calculator to consider how future costs may affect your broader household budget, without assuming that inflation will offset a payment increase.
When to recalculate
Revisit your home-buying budget whenever a major input changes. At minimum, update it before making an offer and again before locking in financing.
- Mortgage rates move: Recalculate principal and interest using the rate and loan terms you can actually obtain, not an outdated illustration.
- Income or employment changes: Update the worksheet after a job change, reduction in variable pay, new business income, or change from one income to two.
- Debt changes: Add new loans, remove debts that are genuinely paid off, and account for payments that may begin after closing.
- Property costs change: Refresh taxes, insurance, HOA dues, mortgage insurance, and maintenance assumptions when you move from a general search to a specific property.
- Your cash position changes: Recalculate after a large purchase, bonus, inheritance, investment sale, or emergency expense.
- You refinance or modify the loan: Compare the new payment and upfront costs with the old loan, and avoid judging a refinance by the rate alone.
Before shopping seriously, save three versions of the worksheet: a target case, a cautious case with higher costs or rates, and a cash-preservation case with a different down payment. If the purchase only works in the most favorable version, reduce the price range or wait for stronger financial flexibility.
The best answer to “How much house can I afford?” is therefore a range supported by repeatable assumptions, not a single number from a lender or online calculator. Keep the worksheet with your budget, refresh it when market conditions or household finances change, and use the result to guide your search rather than justify a maximum.
