Nobody is this forum has actually covered these new rules off with much detail as of yet so here's the highlights. What is rarely covered is the fact that two sets of rules were issued not just those that effect insured mortgages. OSFI also issued residential mortgage lending guidelines...
I googled how to setup a mortgage amortization schedule in excel.
I wanted to replicate the mortgage schedule that my bank gave us when we entered into the mortgage based on the following facts:
Amort period: 25 years
Locked in: 5 years
Start date: July 16, 2007...