How Much House Can I Afford? A Mortgage Budget Worksheet Beyond the 28% Rule
mortgage planninghome affordabilityhome buyinghousing budgetdown payment

How Much House Can I Afford? A Mortgage Budget Worksheet Beyond the 28% Rule

SSmart Budget Hub Editorial Team
2026-11-15
6 min read

Use a practical mortgage worksheet to compare home prices, total monthly costs, cash to close, and a safer housing payment beyond the 28% rule.

How much house can I afford? Use this mortgage budget worksheet to estimate a safer monthly housing payment, compare purchase prices, and account for costs that a simple percentage rule can miss.

Overview

A lender may tell you the largest mortgage payment you qualify for, but qualification is not the same as comfort. Your personal home-buying budget also needs to leave room for utilities, repairs, savings, transportation, debt payments, taxes, and ordinary household spending.

The commonly cited 28% rule says to keep a specified portion of gross monthly income for housing costs. It can be a useful starting point, but it is not a complete affordability test. It may not reflect irregular income, childcare, student loans, credit card balances, property condition, homeowners association dues, or your goal of building an emergency fund. A better approach is to calculate both a percentage-based limit and a cash-flow-based limit, then use the lower of the two as a planning ceiling.

Your monthly housing cost should be broader than principal and interest. For a realistic comparison, include:

  • Mortgage principal and interest
  • Property taxes
  • Homeowners insurance
  • Mortgage insurance, if applicable
  • Homeowners association or condominium dues
  • A maintenance and replacement reserve
  • Utilities that would be higher than in your current home

For credit-related preparation, review your credit reports and understand which debts appear in your monthly obligations. The credit report review and dispute checklist can help you check for errors before applying.

How to estimate your affordable home price

Start with a monthly budget rather than a target listing price. The basic calculation is:

Maximum comfortable housing cost = dependable monthly income − non-housing spending − planned savings − financial cushion

“Dependable income” means income you reasonably expect to continue. For variable pay, commissions, bonuses, freelance work, or investment income, use a conservative amount or exclude it until you have a documented history and a plan for weaker months.

Next, calculate the non-mortgage portion of the housing payment:

Non-mortgage housing costs = taxes + insurance + mortgage insurance + HOA dues + maintenance reserve

Subtract that total from your maximum comfortable housing cost. The remainder is the principal-and-interest payment you can test in a mortgage calculator or spreadsheet.

To compare homes, build a small table using the same assumptions:

Purchase priceDown paymentLoan amountPrincipal and interestOther housing costsTotal monthly housing cost
$250,000Enter amountPrice minus down paymentUse your assumed rate and termTaxes, insurance, dues, reservesAdd columns four and five
$300,000Enter amountPrice minus down paymentUse the same assumptionsUpdate price-based costsAdd columns four and five
$350,000Enter amountPrice minus down paymentUse the same assumptionsUpdate price-based costsAdd columns four and five

Do not compare only the loan payment. Two homes with the same price can have different taxes, insurance, HOA dues, utility needs, and repair risk. A lower purchase price is not automatically cheaper if it requires immediate work or has unusually high recurring costs.

Inputs and assumptions for your worksheet

Income and monthly cash flow

Record gross monthly income for a ratio-based estimate, then create a separate take-home-pay budget for real-life affordability. List required expenses such as food, transportation, childcare, healthcare, insurance, subscriptions, and existing debt payments. Include annual or irregular bills by dividing their expected yearly cost by twelve.

Leave space for savings goals. A home payment that consumes every available dollar can make a buyer vulnerable to a broken appliance, job interruption, insurance change, or other unplanned cost. If you are still building emergency savings, use a more conservative payment limit. The emergency fund guide provides a framework for organizing that reserve.

Down payment and cash to close

A down payment is only one part of the cash needed to buy. Your worksheet should separately track:

  • Down payment
  • Closing costs and prepaid items
  • Inspection, appraisal, moving, and setup costs
  • Immediate repairs or furnishings
  • Cash remaining after closing

Do not assume that putting every available dollar into the down payment is the best choice. Compare the effect on the monthly payment with the value of retaining an emergency reserve. A larger down payment may reduce the loan balance or mortgage insurance, while a smaller one may preserve liquidity. The right trade-off depends on the loan terms and your broader budget.

Loan assumptions

Write down the assumed interest rate, loan term, loan type, and down payment before comparing properties. The interest rate used for planning may differ from the rate available when you apply, and the rate may depend on credit history, loan features, lender requirements, and market conditions.

Use the annual percentage rate when comparing the broader borrowing cost, not just the interest rate. APR may incorporate certain loan charges, but it does not replace a full review of the estimate and closing documents. For background, see APR versus interest rate.

Property-specific costs

Use the actual property tax estimate, insurance quote, and HOA information when available. If you are still browsing, enter clearly labeled estimates and test a low, middle, and high scenario. Maintenance should be treated as a planning reserve rather than an exact bill; older, larger, or more complex homes may require a different reserve than newer or smaller properties.

Worked examples

Consider an illustrative household with $8,000 in dependable gross monthly income. Suppose the household chooses a planning limit of $2,000 for total housing costs after reviewing its take-home budget, existing debts, savings goals, and expected lifestyle expenses. This is an example assumption, not a recommended limit for every household.

Assume the estimated non-mortgage housing costs are $650 per month:

  • Property taxes: $250
  • Homeowners insurance: $120
  • HOA dues: $100
  • Maintenance reserve: $180

The available principal-and-interest payment is therefore:

$2,000 − $650 = $1,350 per month

The buyer can now test different home prices using the same assumed rate, term, and down-payment percentage. If a $300,000 home produces a principal-and-interest payment of $1,280 under the chosen assumptions, its estimated total housing cost is $1,930. If a $350,000 home produces a payment of $1,520, its estimated total is $2,170 before considering any change in taxes, insurance, or dues. The first example fits the stated planning limit; the second exceeds it.

Next, run a stress test. Increase the assumed insurance cost, add a higher maintenance reserve, or test a rate that is less favorable than your first estimate. Also subtract existing debt payments separately when reviewing the full household budget. If the home works only under optimistic assumptions, reduce the purchase-price target or delay the purchase while you improve cash reserves, lower debt, or increase the down payment.

When to recalculate

Revisit this mortgage affordability worksheet whenever a key input changes. Recalculate after a change in income, employment, recurring debt, down-payment savings, interest-rate assumptions, property taxes, insurance, HOA dues, or the target location. A move from renting to owning can also change utilities, commuting costs, maintenance responsibilities, and insurance needs.

Before making an offer, replace placeholders with property-specific information wherever possible. Ask for current tax details, review HOA fees and restrictions, obtain an insurance estimate, and confirm what is included in the payment. Then compare three versions: a comfortable case, a conservative case, and a maximum qualification case. Treat the maximum qualification case as a boundary to understand, not as a spending target.

Finally, update the worksheet at major financial checkpoints. If you are paying down credit cards, compare the effect on monthly cash flow using a personalized debt payoff plan. If your credit profile changes, check your reports and review how new applications may affect your borrowing options. A home budget is strongest when it protects both the purchase and the rest of your financial plan.

Related Topics

#mortgage planning#home affordability#home buying#housing budget#down payment
S

Smart Budget Hub Editorial Team

Personal Finance Editors

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.