Loan Affordability Calculator

What Is Loan Affordability?

Loan affordability calculates the maximum loan amount you can safely borrow based on your income, existing debts, and lender requirements. A $5,000 monthly income doesn't mean you can afford a $3,000 monthly payment — lenders use debt-to-income ratios to ensure borrowers can handle payments plus living expenses.

The 28/36 rule guides most lending decisions: housing costs shouldn't exceed 28% of gross income, and total debt payments (housing + cars + credit cards + student loans) shouldn't exceed 36%. Some lenders allow up to 43% total DTI for qualified borrowers, but this leaves minimal cushion for emergencies.

Real example: A couple earning $8,000 monthly with $500 car payment and $200 student loan payment has $700 existing debt. At 36% DTI limit, total debt can reach $2,880. Remaining for housing: $2,880 - $700 = $2,180. At 6.5% interest on a 30-year mortgage, this supports a $345,000 loan. Borrowing more risks financial stress or loan denial.

The Loan Affordability Formula

Maximum monthly payment based on DTI:

Max Payment = (Monthly Income × DTI Limit) - Existing Debt Payments

Loan amount from monthly payment (mortgage formula):

Loan Amount = PMT × [(1 - (1 + r)⁻ⁿ) / r]

Where:

• PMT = Maximum monthly payment
• r = Monthly interest rate (annual rate ÷ 12)
• n = Total number of payments (years × 12)

This reverses the present value of annuity calculation — instead of finding PV from PMT, we find the maximum PMT first, then calculate what loan that PMT supports.

Worked Calculation Example

Calculate maximum mortgage for a borrower with $6,500 monthly income, $400 existing debt, 36% DTI limit, 6.75% interest rate, 30-year term.

1. Calculate maximum total debt payment: $6,500 × 0.36 = $2,340
2. Subtract existing debt: $2,340 - $400 = $1,940 available for housing
3. Convert annual rate to monthly: 6.75% ÷ 12 = 0.5625% = 0.005625
4. Calculate total payments: 30 × 12 = 360
5. Calculate annuity factor: (1 - 1.005625⁻³⁶⁰) / 0.005625 = (1 - 0.1327) / 0.005625 = 154.28
6. Calculate loan amount: $1,940 × 154.28 = $299,303

This borrower can afford approximately $300,000. Adding property taxes and insurance (typically $400-600/month) would reduce the available payment for principal and interest, lowering the loan amount to ~$250,000.

6 Steps to Calculate Loan Affordability

1. Determine gross monthly income. Use pre-tax income before deductions. For salary: annual ÷ 12. For hourly: hourly × 40 × 52 ÷ 12. Include bonuses (averaged over 2 years), overtime (2-year average), rental income (75% of gross), and self-employment income (2-year average after expenses). A $75,000 salary = $6,250/month.
2. List all existing monthly debt obligations. Include: car loans ($350), student loans ($275), credit card minimums ($150), personal loans ($200), child support ($500). Exclude: utilities, groceries, insurance, entertainment — these aren't debt payments. Total existing debt = $1,475/month. Lenders pull credit reports to verify these amounts.
3. Apply the appropriate DTI ratio. Conventional mortgages: 28% housing, 36% total (can go to 45% with strong credit). FHA loans: 31% housing, 43% total. VA loans: no hard limit, typically 41% total. Jumbo loans: often 36-38% total. For conservative personal budgeting, use 30% total regardless of lender maximums.
4. Calculate maximum housing payment. Max Total Debt = Income × DTI Limit. Max Housing = Max Total Debt - Existing Debt. For $7,000 income at 36% DTI with $800 existing debt: Max Total = $2,520, Max Housing = $2,520 - $800 = $1,720. This $1,720 covers principal, interest, taxes, and insurance (PITI).
5. Estimate taxes and insurance. Property taxes range 0.5-2.5% of home value annually. Homeowners insurance: $800-2,000/year. PMI (if <20% down): 0.5-1% of loan annually. For a $300,000 home: taxes $450/month (1.8% area), insurance $125/month, no PMI with 20% down. Total T&I = $575. Subtract from max housing: $1,720 - $575 = $1,145 for principal and interest.
6. Calculate maximum loan amount. Use the loan formula with P&I payment. At 6.5% for 30 years: Loan = $1,145 × [(1 - 1.005417⁻³⁶⁰) / 0.005417] = $1,145 × 158.21 = $181,150. Add 20% down payment ($45,288) to get maximum home price: $226,438. This is the affordable price range.

5 Examples With Real Numbers

Example 1: First-Time Homebuyer (Single Income)

Teacher earning $52,000 annually, $300/month student loan, 5% down, 6.5% rate, 30-year fixed.

• Monthly Income: $52,000 ÷ 12 = $4,333
• Existing Debt: $300 (student loan)
• Max DTI: 43% (FHA loan)
• Max Total Debt: $4,333 × 0.43 = $1,863
• Max Housing: $1,863 - $300 = $1,563
• Estimated T&I: $350 (taxes + insurance)
• Max P&I: $1,563 - $350 = $1,213
• Loan Amount: $1,213 × 158.21 = $191,900
• With 5% down: $191,900 ÷ 0.95 = $202,000 home price

This buyer can afford a $200K starter home. In high-cost areas, this may require house hacking (renting rooms) or waiting to save more for down payment.

Example 2: Dual-Income Professional Couple

Combined $180,000 income, $1,200 existing debt (2 car payments), 20% down, 6.25% rate.

• Monthly Income: $180,000 ÷ 12 = $15,000
• Existing Debt: $1,200
• Max DTI: 36% (conventional, conservative)
• Max Total Debt: $15,000 × 0.36 = $5,400
• Max Housing: $5,400 - $1,200 = $4,200
• Estimated T&I: $900 (higher-value home)
• Max P&I: $4,200 - $900 = $3,300
• Loan Amount: $3,300 × 156.30 = $515,790
• With 20% down: $515,790 ÷ 0.80 = $644,738 home price

This couple can afford upper-middle-class homes in most markets. Paying down car loans before applying would increase affordability by ~$50,000.

Example 3: Self-Employed Borrower

Business owner with $120,000 average annual income (after expenses), no existing debt, 15% down, 6.75% rate.

• Monthly Income: $120,000 ÷ 12 = $10,000
• Existing Debt: $0
• Max DTI: 36% (self-employed typically face stricter limits)
• Max Total Debt: $10,000 × 0.36 = $3,600
• Max Housing: $3,600 - $0 = $3,600
• Estimated T&I: $700
• Max P&I: $3,600 - $700 = $2,900
• Loan Amount: $2,900 × 154.28 = $447,412
• With 15% down: $447,412 ÷ 0.85 = $526,367 home price

Self-employed borrowers need 2+ years of tax returns showing consistent income. Write-offs reduce qualifying income — a $200K revenue business with $80K deductions only qualifies on $120K.

Example 4: High-Debt Young Professional

$85,000 income, $2,100 monthly debt ($800 student loans, $450 car, $350 credit cards, $500 personal loan), 10% down.

• Monthly Income: $85,000 ÷ 12 = $7,083
• Existing Debt: $2,100
• Max DTI: 43% (maximum conventional)
• Max Total Debt: $7,083 × 0.43 = $3,046
• Max Housing: $3,046 - $2,100 = $946
• Estimated T&I: $400
• Max P&I: $946 - $400 = $546
• Loan Amount: $546 × 154.28 = $84,237
• With 10% down: $84,237 ÷ 0.90 = $93,597 home price

High existing debt crushes affordability. Paying off the $500 personal loan and $350 credit card would free up $850/month, increasing affordability to ~$220,000. Debt payoff before homebuying dramatically expands options.

Example 5: VA Loan (Military)

Veteran with $68,000 income, $400 car payment, no down payment required, 6.25% rate, VA funding fee financed.

• Monthly Income: $68,000 ÷ 12 = $5,667
• Existing Debt: $400
• Max DTI: 41% (VA typical limit)
• Max Total Debt: $5,667 × 0.41 = $2,323
• Max Housing: $2,323 - $400 = $1,923
• Estimated T&I: $450 (no PMI with VA loan)
• Max P&I: $1,923 - $450 = $1,473
• Loan Amount: $1,473 × 156.30 = $230,230
• With 0% down: $230,230 home price

VA loans' zero down payment feature enables homeownership without savings. The funding fee (2.3% for first use) can be financed into the loan. No PMI saves ~$150/month vs. conventional with <20% down.

4 Common Mistakes to Avoid

• Using net income instead of gross income. Lenders use pre-tax income. A $5,000 take-home pay might be $7,000 gross. Calculating affordability on $5,000 understates your capacity by ~30%. Always use gross monthly income for DTI calculations. The lender will verify with pay stubs and W-2s anyway.
• Forgetting to include property taxes and insurance. The loan payment (P&I) isn't the full housing cost. PMI, property taxes, and homeowners insurance add 25-40% to the monthly payment. A $1,500 P&I payment becomes $2,000+ with T&I. Calculate affordability based on total PITI, not just principal and interest.
• Maxing out DTI without emergency buffer. Just because a lender approves 43% DTI doesn't mean it's wise. At 43% DTI, a job loss or medical emergency creates immediate crisis. Conservative budgeting uses 28-32% total DTI, leaving room for savings, emergencies, and lifestyle. A payment you can technically afford may leave you house-poor and miserable.
• Not accounting for rate changes during pre-approval. Pre-approval at 6% becomes unaffordable if rates rise to 7% before closing. The same $2,000 payment supports $375,000 at 6% but only $330,000 at 7% — a $45,000 difference. Lock your rate early or build in a 0.5-1% buffer when calculating affordability. Rate buydowns can help bridge temporary gaps.

5 Professional Tips for Accurate Calculations

1. Pay down debt before applying to improve DTI. Every $100/month of debt eliminated increases mortgage capacity by ~$15,000 at 6.5%. Paying off a $350 car payment 6 months before applying could add $52,000 to your buying power. Focus on high-payment, low-balance debts first for maximum DTI improvement per dollar paid.
2. Consider biweekly payments to reduce total interest. Biweekly payments (half the monthly amount every 2 weeks) make 13 full payments yearly instead of 12. On a $300,000, 30-year, 6.5% mortgage, this saves ~$65,000 in interest and pays off the loan 4 years early. Ensure the extra payment goes to principal, not escrow.
3. Get pre-approved before house hunting. Pre-approval locks in a rate (typically 60-90 days) and confirms your affordability calculation. Sellers take pre-approved buyers seriously. Multiple pre-approvals within 14 days count as one credit inquiry. Use pre-approval to set your maximum budget, then consider buying below max for financial flexibility.
4. Factor in maintenance and upkeep costs. Homes cost 1-4% of value annually in maintenance. A $400,000 home needs $4,000-16,000/year for repairs, replacements, and upkeep. Budget $300-500/month separately from PITI. Older homes cost more to maintain. Condos have HOA fees but lower individual maintenance. Include this in your true affordability calculation.
5. Use the 50% rule for rental properties. For investment properties, lenders use different criteria. The 50% rule assumes half of rental income goes to expenses (vacancy, maintenance, management, taxes, insurance). Net operating income = 50% of rent. DSCR (debt service coverage ratio) should exceed 1.25: NOI must be 125% of mortgage payment. This ensures positive cash flow after all costs.

4 Frequently Asked Questions

Related Calculators

• Present Value of Annuity Calculator — Understand loan amortization math
• Mortgage Payoff Calculator — Calculate early payoff savings
• Credit Card Payoff Calculator — Reduce debt before applying
• Tax Equivalent Yield Calculator — Compare after-tax costs