Before we dwell into the program code, we need to know some
financial concepts. The term loan amortization means the computation of
the amount of equal periodic payments necessary to provide lender with a
specific interest return and repay the loan principal over a specified period.
The loan amortization process involves finding the future payments whose present
value at the load interest rate equal the amount of initial principal borrowed. Lenders
use a loan amortization schedule to determine these payment amounts and the
allocation of each payment to interest and principal.
The formula to calculate periodic payment is
where PVIFAn is known as
present value interest factor for an annuity . The formula to compute
PVIFAn =1/i - 1/i(1+i)n
where n is the number of payments. Normally you can check up a financial
table for the value of PVIFAn and then calculate
the payments manually. You can also use a financial calculator to compute
the values. However, if you already know how to write program in VB, why not create
your very own financial calculator.
To calculate the payments for interest, you can multiply the
initial principal with the interest rate, then use periodic payment to minus
payment for interest. To calculate the balance at the end of a period, we use