Build a Home Affordability Budget from Your Income, Debts and Savings

Get a comfortable and stretch home price, a line-by-line monthly cost table with taxes, insurance, PMI and maintenance, and a stress test at higher rates.

You getSnapshot, monthly cost table and stress-test table

Prompt

Prompt
Act as a budgeting coach who helps first-time buyers set a safe home price.

Before doing any math, ask me these four questions in one message, then wait for my answers:
1. Gross monthly household income and monthly take-home pay?
2. Monthly debt payments (car, student loans, card minimums, other)?
3. Savings available, and how much I want to keep as an emergency fund?
4. Where I'm buying, and the mortgage rate I've been quoted (or 'not sure')?

Rules:
- Keep total housing cost at or under 28% of gross income and all debts at or under 36%; show both percentages for each price.
- Include principal and interest, property tax, homeowners insurance, PMI if the down payment is under 20%, HOA if typical for the area, and maintenance at 1% of price per year.
- Label every estimate (tax rate, insurance, PMI, closing costs at 3%) as an assumption to verify locally.
- Stress-test the comfortable price at my rate plus 1 and plus 2 points.
- Show the math in plain numbers and define any term the first time you use it.

Output format:
1. Snapshot: comfortable price, stretch price, cash needed at closing.
2. Monthly cost table: line item | comfortable | stretch.
3. Stress-test table: rate | monthly total | % of gross income.
4. Assumptions to verify.
5. Three next steps.

End with one line: this is not financial advice; confirm numbers with a licensed lender or financial advisor before making an offer.

Example output

At a glanceComfortable vs stretch home price, monthly costs30-year fixed at 6.75% for a Columbus, Ohio couple
ItemComfortable ($300k)Stretch ($340k)
Down payment$51,000 (17%)$49,800 (14.6%)
Loan amount$249,000$290,200
Principal & interest$1,615$1,882
PMI$104$121
Total monthly$2,469$2,853
% of take-home34.8%40.2%

Example for: a couple in Columbus, Ohio earning $9,500/month gross ($7,100 take-home), $450/month in debts, $78,000 saved, keeping $18,000 for emergencies, quoted 6.75%.

1. Snapshot

  • Comfortable price: $300,000 (housing 26.0% of gross, all debts 30.7%)
  • Stretch price: $340,000 (housing 30.0%, all debts 34.8%)
  • Cash needed at closing: $60,000 at either price, leaving your $18,000 emergency fund untouched

2. Monthly Cost Table (30-year fixed, 6.75%)

Line itemComfortable ($300k)Stretch ($340k)
Down payment$51,000 (17%)$49,800 (14.6%)
Loan amount$249,000$290,200
Principal & interest$1,615$1,882
Property tax (1.5%/yr)$375$425
Homeowners insurance$125$142
PMI (0.5% of loan/yr)$104$121
HOA$0$0
Maintenance (1%/yr)$250$283
Total monthly$2,469$2,853
% of take-home34.8%40.2%

PMI = private mortgage insurance, charged when you put down less than 20%. It usually drops off once you reach 20% equity.

3. Stress Test (comfortable price)

RateMonthly total% of gross income
6.75%$2,46926.0%
7.75%$2,63827.8%
8.75%$2,81329.6%

Even at 8.75%, the comfortable price stays near the 28% line. The stretch price at 8.75% would hit about $3,200/month (33.7%), which is too tight.

4. Assumptions to Verify

  • Franklin County tax rate of 1.5%; check the auditor's site for specific addresses.
  • Insurance of $1,500–$1,700/year; get two real quotes.
  • Closing costs at 3% of price; ask your lender for a Loan Estimate.
  • PMI rate depends on your credit score.

5. Next Steps

  1. Get pre-approved with two lenders and compare Loan Estimates line by line.
  2. Set your search filter at $300,000 and treat anything above $320,000 as a stretch.
  3. Ask about putting $9,000 more down later to remove PMI sooner.

This is not financial advice; confirm numbers with a licensed lender or financial advisor before making an offer.

Written by AI from this prompt. Your results will vary.

Tips and common edits

Why this works

  • Asking four questions first means the budget uses your real income, debts and cash instead of generic averages.
  • The 28/36 rule plus a 1% maintenance line keeps the result conservative and shows costs most online calculators skip.
  • The +1 and +2 point stress test shows whether the payment still works if rates rise before you lock.

Use before talking to a lender or touring homes. Have your gross and take-home pay, debt payments, savings total and any quoted rate ready. Works in ChatGPT, Claude or Gemini.

Common edits

  • Swap the 28/36 limits for 25% of take-home pay if you want a stricter, more cautious budget.
  • Add a 15-year mortgage column to compare payments and total interest.

Prompt details

By
Prompts-GPT editors
Published

Did this prompt work?

Keep exploring

More in Real Estate