ProfessionalExcel.com In the office, Excel is a way of life… not just a tool

Mortgage Analyser

The Mortgage Analyser is a Microsoft Excel spreadsheet tool for analysing the detailed payment breakdown of a mortgage. It helps answer questions like:

  • What will my monthly payments be?
  • What will happen if interest rates change?
  • What's the 'real' cost of re-mortgaging, including early repayment charges if you are still on a fixed rate?
  • What might happen at the end of a fixed interest rate period?
  • What affect does an interest only period have on repayments?
  • How much capital have I accumulated? (assuming no change in property value)
  • What are the benefits of making overpayments? (i.e. paying off the mortgage sooner and saving interest)
Mortgage Analyser screenshot

Mortgage Analyser screenshot

Mortgage Analyser 3.1
Mortgage Analyser 3.1
Mortgage-Analyser-3.1.xlsx
Version: 3.1
218.8 KiB
1287 Downloads
Details...
Mortgage Analyser 2.0
Mortgage Analyser 2.0
Mortgage-Analyser-2.0.xlsx
Version: 2.0
136.9 KiB
1084 Downloads
Details...
Mortgage Analyser 1.0
Mortgage Analyser 1.0
Mortgage-Analyser-1.0.xlsx
Version: 1.0 (Excel 2007)
96.5 KiB
881 Downloads
Details...
Mortgage Analyser 1.0
Mortgage Analyser 1.0
Mortgage-Analyser-1.0.xls
Version: 1.0 (Excel 2003)
137.0 KiB
594 Downloads
Details...
Comments (0) Trackbacks (0)

No comments yet.


Leave a comment

Trackbacks are disabled.