Automate loan amortization schedule excel vba

broken image

Sometimes our borrowers do not get the full loan amount at once instead, they get them over a certain period as the milestones are reached. But our loans have a bit specific features. I have found a few Excel VBA samples for automatically generating loan amortizations.

broken image
broken image

At the same time, we are running several reports about our loans, analysis of the loan repayment behavior by the clients, monthly, quarterly and annual forecasts for the next few years. We are thinking of creating a web app, but this is going to take a while. It's actually pretty neat and does the job.

broken image

We already have a loan management program in MS Access. Hello guys, I have been thinking of creating a loan amortization program.

broken image