Dynamic Amortization Table With VBA

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!

About the author


Hi, I'm Frank. I have a passion for coding and extend it primarily within the realm of Finance.

View all posts

1 Comment

Leave a Reply

Your email address will not be published. Required fields are marked *