Financial Ratio Calculator
Financial Ratio Calculator
MORTGAGE

Home Affordability Calculator

Determine the maximum home purchase price and loan amount you can qualify for based on monthly household income, existing monthly debt obligations, and down payment savings.

Financial Calculator
Input Parameters
Click Calculate when ready
e.g. Rs 1,50,000
Rs
e.g. Rs 15,000
Rs
e.g. Rs 10,00,000
Rs
%
yrs
Calculation Results
Enter your values and click Calculate.

Provide the input parameters on the left to compute the official financial result and metrics.

DECISION MODELINGSENSITIVITY ANALYSIS

Sensitivity Analysis

Evaluate how variations in key operational drivers impact Maximum Affordable Home Price.

Varying Mortgage Interest Rate
Calculate the base model above to view scenario sensitivity rows.

Formula & Methodology

Max Home Price = Max Loan Amount + Down Payment
Gross Income
Monthly Household Income

Total monthly take-home salary or business earnings.

Other Debts
Existing Monthly Debts

Existing car loan, personal loan, or credit card EMIs.

Down Payment
Cash Available for Down Payment

Liquid savings allocated toward purchase.

Practical Worked Example

A family with Rs 1,50,000 monthly income, Rs 15,000 in car loan EMIs, and Rs 10,00,000 down payment savings evaluates home affordability at 8.5% for 20 years.

01.Max total EMI limit (45%) = Rs 67,500.
02.Available housing EMI = Rs 67,500 − Rs 15,000 = Rs 52,500 / month.
03.Max eligible 20-year loan at 8.5% = Rs 59,40,000.
04.Total Affordable House Price = Rs 59,40,000 + Rs 10,00,000 = Rs 69,40,000.
Rs 69,40,000 Home BudgetPaying off existing car loans before applying for a mortgage increases home purchasing power by over Rs 15 Lakhs.

Interpretation & Industry Benchmarks

Lenders evaluate debt-to-income (DTI) or Fixed Obligation to Income Ratio (FOIR) to prevent borrower default.

Housing EMI < 35% of IncomeComfortable Budget

Leaves generous cushion for savings and lifestyle expenses.

Housing EMI 40–50% of IncomeUpper Limit

Stretches household finances during unexpected emergencies.

Industry Nuance: In addition to purchase price, budget 6%–8% for stamp duty, registration fees, and brokerage costs.

Analytical Limitations

  • Actual lender loan sanction depends on credit score (CIBIL / FICO) and property title verification.

Frequently Asked Questions

What is FOIR / DTI?

Fixed Obligation to Income Ratio (FOIR) measures the percentage of your gross monthly income committed to paying debt installments.