If you search my blog, you will find dozens of amortization schedules produced by formulas. So why would you need an amortization produced with VBA? Every time you change any inputs, you have recalculate the schedule, while all my other amortizations are automatic.
I created this spreadsheet years ago, just to practice my VBA. Even though my VBA is not very pretty, someone might have a reason to use VBA for their amortizations, or you might just want to see what the VBA looks like.
The input cells are yellow:
Don’t’ forget to click the red “Calculate” button each time you change an input cell. The amortization includes both Servicing and CPR.
A yearly schedule is included to the left of the inputs:
Down load spreadsheet: Mortgage_VBA