All Online Financial Tools

Please read disclaimer regarding the resources on this webpage and web server, located HERE.

This page is a storage area for real estate finance calculators, templates and spreadsheets made in 2001. Most require Microsoft Office 2000 or newer, for they make use of the Microsoft feature 'Office Web Components.'

Microsoft Excel Spreadsheets

MS Excel is required to run these spreadsheets on your computer. To download file for future use, right click on spreadsheet and choose 'save as' from the menu.

**Current interest rates**

Amortization Calculators and Financial Tools: CHOOSE A or B

A: This gem produces ready to print results with accompanying color graphs on a new white page.

Mortgage Calculator

Principal Loan Balance:
Annual Interest Rate (%):
Mortgage Length in Years:
Starting Month:
Starting Year:
Canadian:

A-2: Enter data, press calculate, and payment immediately appears as the label on the calculate button- no print option available.

Enter information regarding your loan in the calculator above. Things to keep in mind:

Principal Amount of Loan - Enter the beginning balance of the loan. For mortgage loans, this is usually determined by adding the home purchase price and closing costs, then deducting the down payment.
Annual Interest Rate - This calculator requires an interest rate between 1.0% and 50%. You may enter any increments above 1.0% -- for instance, 8.125% would be valid to enter.
Term of Loan - Must be at least 1 year. Enter increments of whole years using a decimal point. For instance, you would enter 1 ½ years as 1.5 years.
Monthly Loan Payment will be calculated after you enter information and click on the "Calculate" button.

B: All of the following financial worksheets are Microsoft Web Components and will not work in Netscape Navigator, Mozilla or Firefox. In order for these 'spreadsheets' to work in your browser, Internet Explorer 5 plus one Microsoft Office post 2000 product must be installed on your computer. Common examples are MS Office 2000-2003, Office XP, Word, Excel, Powerpoint, and Frontpage.

Fill in the variables and these internet 'spreadsheets' will immediately calculate results in real time. Hit refresh to clear and reset all spreadsheets. Interest rates are fixed and cannot be changed. These spreadsheets are available for individual download here.

Simple amortization

Amortization with taxes and insurance expenses

Adds rental income and rental expenses

For One family home or Condo

Multifamily 2-4 units