iamhanzome
New Member
- Joined
- Dec 21, 2021
- Messages
- 1
- Office Version
- 2016
- Platform
- Windows
Hi,
Today, i attended a training and just got introduced to the world of VBA. So i am literally a newbie (1 Day old in VBA). I realized that understanding VBA can help tremendously on making my work more efficient. At the same time, we were asked by our instructor to register for VBA forums and ask questions that are relevant in our work.
So here's what came to my mind as a subject to ask- Loan Amortization. Can you help me or provide suggestion how i can build a loan amortization schedule with below input. I know there are so many loan calculator available online but i want to try to create one as part of my learning.
Principal: $ 50M
Interest rate: 3.5% p.a.
Term: 10 years
Payment Option: Fixed Monthly amortization with repayment of principal and interest
Other options: 1) Can make unscheduled payment when there is cash surplus 2) I have a target fixed monthly payment, calculate what will be the term of the loan
Thank you in advance!
Today, i attended a training and just got introduced to the world of VBA. So i am literally a newbie (1 Day old in VBA). I realized that understanding VBA can help tremendously on making my work more efficient. At the same time, we were asked by our instructor to register for VBA forums and ask questions that are relevant in our work.
So here's what came to my mind as a subject to ask- Loan Amortization. Can you help me or provide suggestion how i can build a loan amortization schedule with below input. I know there are so many loan calculator available online but i want to try to create one as part of my learning.
Principal: $ 50M
Interest rate: 3.5% p.a.
Term: 10 years
Payment Option: Fixed Monthly amortization with repayment of principal and interest
Other options: 1) Can make unscheduled payment when there is cash surplus 2) I have a target fixed monthly payment, calculate what will be the term of the loan
Thank you in advance!