Knowing how much house you can afford requires more than multiplying your income by a loan amount. This home-buying budget worksheet helps you estimate a sustainable monthly home payment by combining principal and interest, property taxes, insurance, HOA dues, maintenance, existing debt, down payment funds, and cash reserves.
Overview
A home affordability estimate should answer two separate questions: what a lender may approve and what your household budget can comfortably support. Those figures are not always the same. A lender evaluates income, credit, assets, debts, and its own underwriting standards. Your household budget must also account for irregular expenses, savings goals, job stability, and the cost of maintaining a home.
Start with the complete monthly home cost rather than focusing only on the advertised mortgage payment. A useful estimate includes:
- Principal and interest on the mortgage
- Property taxes
- Homeowners insurance
- Mortgage insurance, if applicable
- Homeowners association or other community fees
- A maintenance and repair allowance
- Any additional property-specific costs, such as flood insurance or shared maintenance
Then add your existing monthly debt payments and compare the total with gross monthly income. This produces a practical debt-to-income ratio mortgage lenders may also review, but it should be treated as a planning measure rather than an approval guarantee. For a broader household view, pair this worksheet with a monthly budget planner before deciding on a price range.
How to estimate
Use the following five-step process to build a repeatable home affordability calculator in a spreadsheet or budgeting app.
- Calculate gross monthly income. Use dependable income before taxes and deductions. If income varies, use a conservative average based on a period that reflects normal earnings rather than an unusually strong month.
- List existing monthly debt payments. Include required payments for credit cards, student loans, auto loans, personal loans, and other financed obligations. Do not use the balance alone; the monthly payment is the figure needed for the ratio.
- Set a housing-cost limit. Choose a payment that leaves room for food, utilities, transportation, insurance, savings, childcare, repairs, and discretionary spending. A lender’s maximum is not automatically a good household target.
- Estimate the full monthly home payment. Add principal and interest to taxes, insurance, mortgage insurance, HOA fees, and maintenance. If a cost is unknown, use a clearly labeled planning estimate and replace it when you have a property-specific figure.
- Test the cash required at closing. Compare the down payment and expected purchase costs with your available cash. Keep a separate reserve for emergencies and early homeownership expenses instead of using every dollar for the purchase.
A simple affordability formula is:
Available monthly housing budget = chosen total-debt limit − existing monthly debt payments
For example, if you choose a planning limit equal to 35% of gross monthly income, the calculation is gross monthly income multiplied by 0.35, minus required non-housing debt payments. The percentage is an assumption for testing scenarios, not a universal rule. Try a lower and higher limit to see how sensitive your purchase range is.
To estimate principal and interest, use a mortgage calculator with the loan amount, interest rate, and term. The loan amount is generally the purchase price minus the down payment, adjusted for any financed costs. Do not confuse principal and interest with the complete monthly home payment.
Inputs and assumptions
Record each input separately so you can update one assumption without rebuilding the entire worksheet.
| Input | What to enter | Why it matters |
|---|---|---|
| Gross monthly income | Reliable pre-tax household income | Sets the starting point for affordability ratios |
| Existing debt payments | Required monthly payments | Reduces the amount available for housing |
| Home price | Purchase price being tested | Determines the loan size and cash requirement |
| Down payment | Dollar amount or percentage | Changes the loan amount and available reserves |
| Interest rate and term | Scenario assumptions or loan estimates | Drive principal-and-interest costs |
| Taxes and insurance | Property-specific estimates when available | Can vary substantially by location and property |
| HOA and mortgage insurance | Monthly fees, if applicable | Raises the recurring housing cost |
| Maintenance allowance | A monthly amount reserved for repairs | Prevents the budget from ignoring ownership costs |
| Cash reserves | Funds remaining after purchase | Protects against emergencies and early repairs |
Utilities are often excluded from the mortgage payment but should remain in your household budget. The same is true of commuting changes, furnishing, moving costs, and periodic assessments. If you are already carrying expensive debt, compare the purchase scenario with a debt payoff calculator before committing to a larger payment.
Worked examples
Consider an illustrative household with gross monthly income of $8,000, existing required debt payments of $700, and a planning limit of 35% of gross income. The household’s total monthly debt-and-housing target would be $2,800. After subtracting $700 of existing debt, the target for all housing costs is $2,100.
Now test a home priced at $400,000 with a $80,000 down payment. For illustration only, assume a $320,000 fixed-rate mortgage with a 30-year term and a 6.5% interest rate. Under those assumptions, principal and interest would be approximately $2,023 per month. Suppose the worksheet also uses these clearly labeled estimates: $400 for property taxes, $150 for homeowners insurance, $100 for HOA dues, and $250 for maintenance. The estimated total becomes approximately $2,923 per month before any mortgage insurance or special property costs.
That result is above the household’s $2,100 planning target. The next step is not automatically to stretch the budget. Test alternatives:
- Lower the home price while keeping the same down payment percentage.
- Increase the down payment only if doing so leaves adequate emergency reserves.
- Reduce existing debt before buying and recalculate the available housing budget.
- Compare properties with different taxes, insurance, HOA fees, or maintenance needs.
- Run a higher-rate scenario to see whether the purchase remains manageable.
The example demonstrates why a headline loan amount can be misleading. A property with the same price may have a different total cost because taxes, insurance, fees, and maintenance vary. For a household with variable income, run the worksheet using a conservative income case as well as the expected case. A home that works only under the best income assumption may not be affordable in practice.
When to recalculate
Revisit your home-buying budget whenever a major input changes. Recalculate after mortgage rates move, your expected down payment changes, property taxes or insurance estimates are updated, an HOA fee is disclosed, or a lender provides different loan terms. Also update the worksheet after taking on or paying off a car loan, credit card balance, student loan, or other debt.
Before making an offer, replace broad assumptions with property-specific figures where possible. Confirm the estimated tax bill, insurance quote, HOA documents and dues, loan estimate, and any required mortgage insurance. Treat closing costs, prepaid items, moving expenses, and immediate repairs as separate cash needs rather than hiding them inside the down payment.
Finally, compare the proposed payment with your actual budget by paycheck. Set aside the projected housing amount for several pay cycles if you are still renting. This practical test can reveal whether the payment leaves enough cash for bills and savings. If the purchase would eliminate your emergency cushion, review an emergency fund calculator and adjust the price, down payment, or timeline. The most useful answer to “How much house can I afford?” is the price that fits both the loan analysis and the household’s complete financial plan.
