How Much House Can I Afford? A Budgeting Worksheet for Income, Debt, and Closing Costs

Overview

Home affordability has two different meanings. A lender may determine the loan amount you qualify for based on income, credit, assets, debt, and its underwriting standards. Your personal budget asks a broader question: Can you make the full housing payment while still saving, handling ordinary expenses, and absorbing an unexpected bill?

The lower of those two figures should guide your search. A preapproval is useful for understanding borrowing capacity, but it is not a recommendation to spend the maximum. Your estimate should include costs that may not appear in a basic mortgage calculator, such as repairs, utilities, HOA charges, mortgage insurance, and the cash needed at closing.

A simple affordability worksheet has four outputs:

• Maximum comfortable monthly housing budget: the amount your household can dedicate without crowding out other priorities.
• Estimated loan payment: the principal and interest payment for a selected price, down payment, and rate.
• Cash needed before closing: the down payment, closing costs, prepaid items, and reserve you want to keep.
• Affordability range: a purchase-price range that leaves room for uncertainty instead of producing one misleading number.

How to estimate

Start with a monthly cash-flow view rather than a home-price target. Use dependable gross income for lender-style analysis, but use take-home income to test whether the payment fits your actual life.

1. Record stable monthly income. Include salary and other income you reasonably expect to continue. For variable pay, consider using a conservative average only when the income is well documented and not essential to a fragile budget.
2. List existing monthly debt. Include student loans, auto loans, credit-card minimums, personal loans, child support, and other required payments. Do not count ordinary spending twice: groceries and utilities belong in the living-expense section, not the debt section.
3. Set a housing-payment ceiling. Choose an amount that works alongside retirement contributions, emergency savings, transportation, health costs, and other goals. A debt-to-income ratio can be a lender reference, but it should not replace your own cash-flow test. Lenders use different definitions and limits.
4. Estimate the complete monthly housing cost. Add principal and interest, property taxes, homeowners insurance, mortgage insurance if applicable, HOA or condominium fees, and a maintenance allowance.
5. Convert the monthly budget into a purchase price. Use a mortgage calculator with the assumed loan term and interest rate. Adjust the down payment and price until the complete monthly cost stays below your ceiling.
6. Check the upfront cash requirement. Confirm that the down payment, closing costs, prepaid taxes and insurance, moving expenses, and emergency reserve can be funded without draining all liquid savings.

The core calculation is:

Monthly housing cost = principal and interest + property taxes + homeowners insurance + mortgage insurance + HOA fees + maintenance allowance.

To estimate the loan amount, subtract the down payment from the purchase price. A calculator can then estimate principal and interest from the loan amount, interest rate, and term. Treat the result as an estimate: the final payment can depend on the property, loan structure, taxes, insurance, and lender terms.

Inputs and assumptions

Fill in this home-buying budget worksheet before looking at a specific property:

• Gross monthly income: $__________
• Monthly take-home income: $__________
• Required monthly debt payments: $__________
• Other essential monthly spending: $__________
• Monthly savings and investment commitments: $__________
• Target monthly housing budget: $__________
• Down payment available: $__________
• Cash reserved for closing and prepaid costs: $__________
• Emergency reserve retained after closing: $__________
• Assumed mortgage rate and term: __________
• Estimated annual property taxes: $__________
• Estimated annual homeowners insurance: $__________
• Monthly HOA or condominium fee: $__________
• Monthly maintenance allowance: $__________

Use local estimates for taxes, insurance, and HOA fees rather than copying a national assumption. Insurance can vary by property characteristics and location, while taxes may differ between neighborhoods or change after a purchase. Ask for a property-specific insurance estimate when possible.

Closing costs and prepaid items should be treated separately from the down payment. The amount varies by transaction, lender, location, and services selected, so request a detailed estimate and update the worksheet when you receive one. Also budget for immediate costs such as moving, basic furnishings, maintenance supplies, and repairs.

An emergency reserve is not an amount to spend on the house. It is cash that remains available after closing for income disruption, medical costs, repairs, or other surprises. If the purchase would leave you with little liquid cash, consider reducing the price, increasing the time available to save, or postponing the purchase.

Worked examples

The following figures are illustrative assumptions, not a market quote or a borrowing recommendation.

Example 1: Testing a proposed monthly payment

Suppose a household chooses a target housing budget of $2,600 per month. Its estimate includes:

• Principal and interest: $1,850
• Property taxes: $350
• Homeowners insurance: $150
• HOA fee: $100
• Maintenance allowance: $150

The complete estimated housing cost is $2,600. If mortgage insurance applies, it must be added to the calculation; the household would then need to lower the loan amount or find room elsewhere in the budget. The same test should be run with a higher-rate assumption to see whether the purchase remains manageable if financing conditions change before closing.

Example 2: Checking the cash required

Assume a buyer is considering a $360,000 home with a $72,000 down payment. The buyer also estimates $11,000 for closing and prepaid costs, $4,000 for moving and initial purchases, and wants to retain $25,000 as an emergency reserve.

The cash target is:

$72,000 + $11,000 + $4,000 + $25,000 = $112,000.

If available liquid cash is less than that amount, the buyer should not automatically solve the gap by reducing the emergency reserve. Recheck the price, down payment, closing-cost estimate, and timing. A lower purchase price can reduce both the loan payment and the cash needed at closing, although the exact effect depends on the financing structure.

For a second opinion, compare your worksheet with a mortgage budget worksheet and track how the purchase would affect your broader net worth plan.

When to recalculate

Revisit your home affordability estimate whenever a major input changes. Recalculate when mortgage rates move materially, your income or employment changes, you take on or repay debt, the down payment changes, or a lender provides new loan terms. Also update the worksheet when you compare a different neighborhood, receive a property-specific insurance quote, learn the actual HOA fee, or obtain a more precise tax estimate.

Before making an offer, run at least three scenarios: your expected rate and costs, a less favorable rate or insurance estimate, and a lower purchase price. Then complete these practical checks:

1. Confirm the full monthly payment, not only principal and interest.
2. Verify that required debt payments and essential spending remain covered.
3. Keep a defined emergency reserve after closing.
4. Separate cash for the down payment from cash needed for closing and moving.
5. Compare the result with a lender’s preapproval without treating the preapproval as a budget.
6. Save the worksheet and update it before each serious home search or offer.

A home is affordable when its full cost fits your financial plan in ordinary months and leaves flexibility for difficult ones. The worksheet is most useful when it produces a range you can live with, not the largest loan a formula can justify.