Using Excel to Calculate Mortgage Qualification Amounts

The attached spreadsheet shows how to use an Excel spreadsheet to calculate the amount of mortgage a person with student or consumer debt might qualify for.   One scenario estimates the impact of increasing maturity of student loan from 10 years to 20 years on increase in potential mortgage and cost to student borrower.

Examples of solving for mortgage qualification amounts in Excel.

qualification-for-house-by-student-borrower (3)