This Final Calc worksheet is comprised of 3 sheets:

     Mortgage Tables     - monthly payment lookup table with
                           interest rate (6-8.75%) vs principle  
                           ($54,000-$160,000) with adjustable amortization
                           period.

     Mortgage Calculator - simple payment calculator - enter amount to
                           finance, amortization period & interest  
     
     Mortgage Evaluation - shows where all the money is going (i.e.
                           principle & interest for each payment &
                           affect of extra payments on amortization)

Use alt-s to toggle between sheets (or Project/Sheet/View from the menu).
     
The formulae are customized for Canadian mortgages although should be
adaptable for other countries.  Solutions are accurate to within 1 cent
when compared to mortgage tables obtained from my bank.

All sheets should be self explanatory although some notes are
included for interest rate calculation.

Use or modify these sheets at will - just send me an email if you have
suggestions, find bugs or if you have any questions.

Also check out my homepage for other Amiga software I have written.  Its
all free! 

Brian Savage 
Dartmouth, Nova Scotia 
Canada

email:    mailto:bsavage@accesscable.net
homepage: http://homepage.accesscable.net/~bsavage

PERMISSION  UID  GID    PACKED    SIZE  RATIO METHOD CRC     STAMP     NAME
---------- ----------- ------- ------- ------ ---------- ------------ ----------
[generic]                  733    2171  33.8% -lh5- f75f Jun 14  1999 Canadian_Interest.readme
[generic]                24532  107236  22.9% -lh5- f904 Jun 10  1999 Canadian_Mortgage.sheet
[generic]                  736    1571  46.8% -lh5- 6221 Jun 14  1999 CanMortgage.readme
---------- ----------- ------- ------- ------ ---------- ------------ ----------
 Total         3 files   26001  110978  23.4%            Jun 14  1999