How Much House Can You Really Afford? A Mortgage Affordability Workbook

How Much House Can You Really Afford? A Mortgage Affordability Workbook

Lenders will tell you the maximum mortgage you qualify for. That is not the same as what you can comfortably afford. This article functions as a structured workbook: you can plug in your own numbers, compare scenarios, and see how different down payments, rates, and taxes change your monthly budget.

Why Affordability Is More Than a Pre‑Approval Number


Step 1: Map Your Monthly Budget

Write down your after-tax monthly take-home pay and essential expenses.

Example Household

  • Net income: $7,200/month (after tax and deductions)

Essential non-housing expenses:

  • Groceries: $800
  • Transportation (fuel, transit, maintenance): $450
  • Childcare: $900
  • Health insurance and medical: $350
  • Minimum debt payments (credit cards, car loan, student loans): $650
  • Utilities & phone/internet: $350
  • Other essentials: $300

Total essentials: $3,800

Net income minus essentials:

  • $7,200 − $3,800 = $3,400 available for housing + savings + discretionary.

Decide how much to reserve for long-term savings and buffer.

Example:

  • Target savings & buffer: $700/month

Remaining for housing:

  • $3,400 − $700 = $2,700/month

This is your real-world housing budget, even if the bank would approve more.


Step 2: Translate Budget to Loan Amount

Your total housing payment includes:

  • Principal & interest (P&I)
  • Property tax
  • Homeowners insurance
  • HOA dues (if any)
  • Mortgage insurance (PMI or FHA MIP, if applicable)

Working Backwards: A Sample Scenario

Budget for housing: $2,700/month.

Estimate taxes, insurance, HOA, and PMI for your area. For illustration:

  • Property tax: $4,800/year → $400/month
  • Insurance: $1,200/year → $100/month
  • HOA: $75/month
  • PMI (if <20% down): estimate $120/month

Non-P&I total: $400 + $100 + $75 + $120 = $695/month

Maximum P&I:

  • $2,700 − $695 = $2,005/month

Now estimate the loan you can support with a $2,005/month P&I payment at current interest rates.

Assume a 30-year fixed at 6.25%.

Using a mortgage calculator, a P&I of about $2,005/month corresponds to a loan around $325,000–$330,000.

We will use $328,000 as a working figure.


Step 3: Add Your Down Payment to Estimate Home Price

Suppose you have $60,000 available for down payment and closing costs, but you want to keep $10,000 in cash reserve. That leaves $50,000 for down payment and closing.

Approximate closing costs: 3% of purchase price.

We need to solve for purchase price, knowing:

  • Down payment + closing ≈ $50,000
  • Loan ≈ $328,000

Let P be the purchase price.

  • Loan ≈ P − Down payment
  • Closing costs ≈ 0.03 × P
  • Down payment ≈ P − 328,000

Total cash needed:

  • Down payment + closing = (P − 328,000) + 0.03P = $50,000
  • 1.03P − 328,000 = 50,000
  • 1.03P = 378,000
  • P ≈ 378,000 / 1.03 ≈ $367,000

Check the components:

  • Purchase price: ≈ $367,000
  • Closing costs (3%): ≈ $11,000
  • Down payment: 367,000 − 328,000 = ≈ $39,000
  • Total cash: 39,000 + 11,000 = $50,000

Down payment percentage:

  • 39,000 ÷ 367,000 ≈ 10.6% down

This structure keeps you within:

  • Your $2,700/month budget, and
  • Your $50,000 cash limit.

Step 4: Compare Alternative Scenarios Side by Side

Scenario A: 10.6% Down (~$367,000 Home)

  • Purchase price: $367,000
  • Down payment: $39,000
  • Loan: $328,000 at 6.25% (30-year)

Approximate monthly payments:

  • P&I: ≈ $2,005
  • Taxes: $400
  • Insurance: $100
  • HOA: $75
  • PMI: $120
  • Total ≈ $2,700/month

Cash at closing: $50,000, reserves: $10,000.

Scenario B: Smaller Home and Lower PMI

What if you choose a smaller home at $340,000 to reduce your monthly payment and PMI?

Assume same loan terms and costs proportionally.

  • Purchase price: $340,000
  • Closing costs (3%): $10,200

If you still allocate $50,000 to down + closing:

  • Down payment: $50,000 − $10,200 = $39,800
  • Loan: 340,000 − 39,800 = $300,200

Monthly P&I at 6.25% for $300,200:

  • P&I ≈ $1,835/month

New PMI (since LTV is lower): assume $95/month

New taxes (proportional): 340,000/367,000 × 400 ≈ $370/month

Total:

  • P&I: $1,835
  • Taxes: $370
  • Insurance: ~$95 (slightly lower)
  • HOA: $75
  • PMI: $95
  • Total ≈ $1,835 + 370 + 95 + 75 + 95 = $2,470/month

This frees roughly $230/month in your budget for extra savings, upgrades, or cushion.

Scenario C: Higher Price, 5% Down

If you stretch to a $400,000 home with 5% down:

  • Purchase price: $400,000
  • Down payment (5%): $20,000
  • Closing costs (3%): $12,000
  • Cash needed: $32,000 (leaves you more cash reserves)
  • Loan: $380,000

Monthly P&I at 6.25%:

  • P&I ≈ $2,323/month

Taxes, insurance (scaled up), and PMI (higher rate, say $165/month) might bring total to:

  • Taxes: ≈ $435
  • Insurance: ≈ $110
  • HOA: $75
  • PMI: ≈ $165

Total housing cost:

  • $2,323 + 435 + 110 + 75 + 165 ≈ $3,108/month

This exceeds your preferred $2,700 by about $400/month. You would gain more house, but at the cost of a tighter budget.


Step 5: Evaluating Trade‑Offs

Use the side-by-side comparison:

ScenarioHome PriceDown %Est. Total MonthlyCash at ClosingNotes
A$367,00010.6%≈ $2,700$50,000Matches budget, modest PMI
B$340,000~11.7%≈ $2,470$50,000Extra cushion, lower risk
C$400,0005%≈ $3,108$32,000Bigger home, tighter cash flow

Questions to ask yourself:

  • Do I prioritize monthly stability or maximum space/location?
  • How secure is my income over the next 5–10 years?
  • How important is keeping larger cash reserves vs. minimizing monthly payments?

Step 6: Key Terms for Affordability Planning

  • Front-End DTI: Housing costs ÷ gross monthly income.
  • Back-End DTI: (Housing costs + other debt) ÷ gross monthly income.
  • LTV (Loan-to-Value): Loan amount ÷ home value; affects PMI and interest rates.
  • Reserves: Months of mortgage payments you have in savings after closing.

Affordability Checklist

Before Talking to Lenders

  • [ ] Calculate your monthly after-tax income.
  • [ ] List all essential non-housing expenses.
  • [ ] Decide on a target monthly housing budget.
  • [ ] Determine how much cash you can commit to down payment and closing while keeping 3–6 months of expenses in reserve.

While Running Scenarios

  • [ ] Use realistic property tax and insurance estimates for your area.
  • [ ] Include HOA and PMI (if <20% down) in every calculation.
  • [ ] Test at least three scenarios: conservative, middle, stretch.
  • [ ] Stress-test your budget: what if an unexpected $300/month expense appears?

Before Making an Offer

  • [ ] Confirm numbers with a lender using a Loan Estimate.
  • [ ] Check how interest rate changes of ±0.5% affect your payment.
  • [ ] Verify that you will still have adequate emergency savings after closing.

Common Affordability Mistakes

  1. Using only lender approval limits and ignoring real budget constraints.
  2. Underestimating variable expenses, such as utilities in a larger home.
  3. Ignoring future goals (retirement, education, travel) that require ongoing savings.
  4. Not stress-testing for job changes, interest rate fluctuations (ARMs), or unexpected repairs.

Closing Thought

Affordability is personal. A carefully structured mortgage that fits comfortably within your broader financial plan is more sustainable than stretching for the maximum house. Use this workbook-style approach—budget first, numbers second, house third—to anchor your decision.

End of article More in Mortgages