CanMortgage

Short:        Final Calc Canadian Mortgage Evaluation
Author:       bsavage@accesscable.net (Brian Savage)
Uploader:     bsavage accesscable net (Brian Savage)
Type:         biz/spread
Requires:     Final Calc
Architecture: generic

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