How to link to our Calculator.

This is a Loan Calculator with some extra features built in.

If you want to keep this window open, and open the Calculator at the same time, hold the Shift key down on your Keyboard when you click on one of the above links.

Continue to the Calculator

  1. You will need Microsoft Excel 97 or later installed on your computer; however some early versions of Excel 97 may not work properly.

If you do not know the version of Excel you have on the computer do the following;

  • Start Excel

  • Click on Help on the top Menu in Excel

  • On the drop down menu, click on About Excel

  • On the popup window the top line should have the version of Excel on your computer.

  • Click on OK

  1. In Excel 2000 or later you need to have the Security Level set to Medium or Low.  If you are not sure about your settings do the following;

If you know your version of Excel you can set the security settings automatically by following the instructions below or set it manually.

  • Make sure Excel is closed before continuing.

  • Click on the link that corresponds with your version of Excel.

2000 (aka 09)     2002 (aka XP or 10)    2003 (aka 11)

  • A File Download - Security Window will pop-up

  • Click on the Run button

  • A popup window will ask you to confirm that you want to add the information to the registry.

  • Click Yes.

  • Another popup window will confirm that the registry was updated successfully.

  • Click OK.

You are now ready to use the calculator.

If the calculator does not work properly after setting the Security Settings automatically, close Excel, then

Set the security settings manually

  • Start Excel

  • Click on Tools on the Menu bar.

  • On the drop-down menu go to Macro then on the pop-out menu click on Security.

  • Click on the Security Level tab if it is not already selected.

  • If the Security Level is set at High, select either Medium or Low.  However I would suggest you select Medium.  It is much safer than Low.  Then you will have the option to enable Macros when needed.

  • Click on OK once your selection has been made and Close Excel.

IF YOU CLICK ON THE LINK TO THE CALCULATOR WITH THE SECURITY SETTINGS ON HIGH, THE PROGRAM WILL NOT WORK.

  1. To start the program, click on the Calculator link.

  • If you get a File Download window, click on the Open button.

  • If you have your Security Level set to Medium, a Microsoft Excel window will pop-up, click on the Enable Macros button.

  1. If you start the calculator from a dial-up phone, it will be slow loading and may take several minutes to start.

Continue to the Calculator