Mortgage Calculator Excel Template - Free Download | Page 3
4.8,
2773
votes
Please vote for this template if it helps you.
Page 2 of 11
Mortgage Calculator
© www.excel-skills.co.uk
Input Variables
Mortgage Amount 300,000.00
Annual Interest Rate 4.0%
Mortgage Period in Years 25
Additional Monthly Mortgage Repayment 300.00
Annual Interest Rate Sensitivity 5.0%
Average Annual Inflation Rate 3.0%
Calculation Results
Monthly Mortgage Repayment 1,583.51
Total Interest over Mortgage Period 175,053.16
Total Mortgage Repayment over Mortgage Period 475,053.16
Net Disposable Income 1,800
Maximum Mortgage Qualification Amount 341,014.47
Minimum Required Net Disposable Income 1,584
Interest Rate Safety 1.26%
Increased Instalment Repayment Amount 1,883.51
Total Adjusted Interest over Mortgage Period 128,452.54
Adjusted Mortgage Repayment Period (in months) 227.48
Adjusted Mortgage Repayment Period (in years) 18.96
Interest Saving 46,600.61
Present Value of Interest Saving 29,809.41
Monthly Mortgage Repayment @ 4.0% 1,583.51
Monthly Mortgage Repayment @ 5.0% 1,753.77
Monthly Difference 170.26
0
20,000
40,000
60,000
80,000
100,000
120,000
140,000
160,000
180,000
200,000
1 4 7 10 13 16 19 22 25 28
Years
Increased Instalment - Interest Saving
Amortization Increased Instalment
0
50,000
100,000
150,000
200,000
250,000
300,000
350,000
1 4 7 10 13 16 19 22 25 28
Years
Capital Repayment
Capital Repayment
source: dataease.com
