Excel VBA: A Macro to Generate Yearly Loan Schedule Report with Aggregated Monthly Re-Payments

Опубликовано: 15 Октябрь 2024
на канале: Mike YU (BI&Analytics)
445
4

In this video, to provide users with a summarized yearly loan schedule report, I guide viewers in creating a new VBA macro based on modifying my previous Video demonstrated VBA macro for monthly loan schedule report which reveals interest and principal payments over the long term. The process involves two vertical VBA project windows and adjusting variables, calculations, and formatting. The updated procedure is offering an aggregated yearly report for different loan terms. A URL link to the VBA codes is provided in the video description for further assistance.


References:

The URL link to the VBA codes:
https://mikeyubianalytics.blogspot.co...