This code shows how to calculate loan payments and amortized payments over a fixed amount of time. It allows the user to include an additional payment, either as a fixed amount of extra principal, or as a fixed payment over the P+I)
It is based on an old VB 3.0 example, but improved to include the extra payment capability. It also calculates how much money is saved with the extra payment included.
Original Author: Kevin
Assumptions
I also have an Excel spreadsheet which performs the same calculations, but lets you include a different amount of extra payment each month.
Attachments
| File | Uploaded | Size |
|---|---|---|
| CODE_UPLOAD140.zip | 9/3/2020 3:45:00 PM | 6405 |