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.

Hello Tugboat00,

The attached workbook will provide you with a fixed rate amortization schedule. You only need to input the loan amount, the annual interest rate and the loan period in years. Click the button and you will create a schedule of payments showing the principal, interest, and balance for each payment.

Here is the VBA macro to generate the amortization schedule. The attached workbook is a working example.

Please Login or Register  to view this content.