Dynamic Mortgage Amortization Table v1.11
- File used in video tutorial on building an amortization table in Excel
- Version 1.1 uploaded 8/27/2016
- Corrects an error where payoff amount wasn’t being correctly calculated when including curtailment payments
- Removed decimal points
Frequently Asked Questions about the Dynamic Mortgage Amortization Table v1.11
What is the Dynamic Mortgage Amortization Table v1.11 used for?
This Excel file helps users build a dynamic mortgage amortization schedule. It calculates monthly loan payments, interest, principal, and remaining balance—including optional curtailment payments.
What corrections were made in version 1.11?
Version 1.11 fixed an error where the loan payoff amount was not being accurately calculated when curtailment payments were included. Decimal points were also removed for improved clarity.
How is this table different from a basic amortization table?
Unlike a static table, this version is dynamic—users can input different terms, rates, and optional curtailments, and the table automatically recalculates results accordingly.
How many times has this file been downloaded?
As of the latest data, the Dynamic Mortgage Amortization Table v1.11 has been downloaded 4,644 times.
Where can I view the accompanying tutorial video?
The video tutorial demonstrating how to build and use this amortization table is available on the Adventures in CRE website and their YouTube channel.