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