Fixed Rate Loan Amortization Table (Alternatives to PMT Function)

Hello all,

I am new to VBA so perhaps this is a foolish question. I have created a fixed amortization table using the pmt function with input boxes in vba to return the values. It seems to work well.

I am wondering what some of the alternative methods are for doing the same thing without using the PMT function. I am looking for some of the easier ways to do this. THe fixed amortization table I created has equal annual installments and the payment begins in the first year. If anyone has a link to a detailed guide that would be even better.

Appreciate any help.