Ultimate Home Affordability Calculator & Worksheet

🏠 Ultimate Home Affordability Calculator DTI • PMI/MIP • Cash to Close • Print-ready

Simple for buyers, detailed for pros. Taxes, insurance, HOA, PMI/MIP, and cash to close are all included. Enter your numbers and hit **Calculate** — no pop-ups, clean inline guidance.

0. Choose Your Mode

Calculation Mode

1. Your Financial Snapshot (Monthly)

Monthly Gross Income (before tax)

Other Monthly Debts on Credit (car, cards, student loans, child support)

Front-End Target (Housing ÷ Income) Accepts 28 or 0.28

Back-End DTI Cap (Housing+Debts ÷ Income) Accepts 45 or 0.45

Comfortable Housing Payment ($/mo) P&I + Tax + Ins + HOA + PMI/MIP

Cash Available for Closing ($, optional)

2. Mortgage & Home Details

Loan Type

Annual Interest Rate (APR %)

Loan Term (years)

Credit Bucket (PMI estimate, Conventional)

Down Payment — choose one

Property Tax Rate (% of price, annual)

Insurance Input

Monthly HOA/Condo Fees ($)

Advanced: Closing costs • Credits & DPA • Program fees • Rate buydown • Maintenance

Estimated Closing Costs (% of loan)

Seller/Lender Credits ($)

Down Payment Assistance ($)

Upfront Fee (FHA/VA/USDA) % of loan

Annual MIP/USDA fee (% of loan, FHA/USDA)

Rate Buydown Credit ($)

Maintenance Reserve (% of price, annual)

Defaults: FHA UFMIP 1.75% & MIP 0.55%; VA funding fee varies; USDA upfront ~1% & annual ~0.35% — override as needed.

4. Printable Homebuying Worksheet 📝

Use this to track a specific property.

Property Monthly (PITI + HOA)

1. Monthly Principal & Interest (P&I)$ —

2. Monthly Property Tax (T)$ —

3. Monthly Home Insurance (I)$ —

4. Monthly HOA / Condo Fee (HOA)$ —

5. PMI / MIP (if any)$ —

Total Monthly Housing Payment (PITI + HOA)$ —

Upfront & Closing

6. Down Payment$ —

7. Upfront Fee (FHA/VA/USDA, if financed)$ —

8. Estimated Closing Costs$ —

9. Credits & Assistance (seller credits + DPA)($ —)

Estimated Cash to Close (6 + 8 − 9)$ —

Final Affordability Check

10. Target/Allowed Monthly Payment$ —

11. Actual Monthly Housing (line Total above)$ —

Monthly Difference (10 − 11)—