Mortgage payment calculation with different options

divocsolutions

Hello everyone, I put together the following mortgage calculations online.
1. Simple Mortgage Payments Calculator (EMI) - To see monthly payments, interest and capital paid and closing balance
2. Overpayment Mortgage calculator (if your bank allows) - To see overpayment you make goes to reduce the debt, term, etc .
3. Compare two mortgage interest payments (Switching to another bank) - To see the difference in monthly payments after switching to another bank, savings
4. Two Interest Rates Comparison and Redress Payment - This is for the Tracker issue affected people in Ireland
You will be able to see how much mortgage left over at any point of time in future, say after 2 years, savings you will make if you switch to another bank, over-payment savings etc.
Most importantly you can export all the calculations to an Excel file.

Here is the link. Will attach a screenshot later, if possible. please remove spaces.
www. divocsolutions .com / mortgagecalcweb /

Hopefully it will be useful for some to compare and take right mortgage. Please let me know if you have any comments.

Boards Mods, please move this to appropriate section if this is not right group. Thank you.
divocsolutions is online now

coylemj

divocsolutions wrote: »

Most importantly you can export all the calculations to an Excel file.

The common practice in this scenario is to give the user the data in a CSV file. The file your website creates and which the user is offered as a download is an XLSX file - you have to run Excel to open it. And it could contain a malicious macro i.e. a virus.

As this is your first post on boards, extreme caution advised.

divocsolutions

coylemj wrote: »

The common practice in this scenario is to give the user the data in a CSV file. The file your website creates and which the user is offered as a download is an XLSX file - you have to run Excel to open it. And it could contain a malicious macro i.e. a virus.

As this is your first post on boards, extreme caution advised.

Sure, I used OpenXML, so it's ok as of now. I will take your suggestion and make it as a CSV file. Thanks.

divocsolutions

coylemj wrote: »

The common practice in this scenario is to give the user the data in a CSV file.

Hello everyone,
Above mortgage payments calculator has been updated with the following options now.

• Simple Mortgage Payments Calculator (EMI)
• Overpayment Mortgage Calculator (Reduce Mortgage Term)
• Lump Sum Overpayment Mortgage Calculator (Reduce Monthly Payment)
• Compare two mortgage interest payments (Switching to another bank)

Mortgage Payments Calculator - by Divoc Solutions

All the calculations can be downloaded as a CSV or XLSX file. A screenshot is attached. Please check and share your comments. Thank you.

Mortgage payments calc July.JPG

Grassey

Be handy if you could set 2 applicable rates.

So say fixed at A% for X period, then rate reverts to B% for (Term - X)

divocsolutions

Hello, A new option has been added and a couple of changes have been made to the Free Mortgage Payments Calculator by Divoc Solutions.
With this new option, which is for an ongoing mortgage, you can see how much interest or capital has been paid or will be paid at a future date when interest changes. This is mainly useful for people who are coming out of 'variable to fixed' or 'fixed to another fixed', etc.
Let me know if you have any comments, hopefully it's useful for someone.
Please share it with your friends. Thank you.

https://www.divocsolutions.com/mortgagecalcweb/