The in-depth Watch Me Build is a 25 minute behemoth, showing you how to build a more complex, dynamic amortization table in Excel. You should see that the balance reaches zero with the last payment. Interest Rate Implicit In The Lease Under Ifrs 16.Watch Me Build A Fully Dynamic Mortgage Amortization Schedule In Excel.