Click to Download Workbook: Dynamic Amortization Schedule
This workbook dynamically creates a loan amortization table with a few different options. The user has the ability to select an interest-only loan, make additional principal payments, and select different frequency compounding intervals on top of the basic amortization table inputs. Generally speaking, an amortization table is a table of periodic loan payments including both interest and principal. Typically, a table can be generated with a user inputting the loan life, interest rate, and principal amount of the loan. This would be a bare-bones amortization table. The intent of this project was to make the table generation dynamic so the user would have more options in order to generate a table over different time spans and interest rates.
Enjoy and share!