Loan Amortization

G

Gus

I am trying to do a loan amortization schedule. However, I have never done
anything like this. Is anyone out there familiar with this?

I would appreciate any help given.

This is the table and the attributes associated with the loan.

tblLoan (Loan_ID,Loan_Amount, Num_Of_Payments_Year, Total_Num_Payments,
Loan_Balance, Maturity_Date, Loan_Approved_Date, Interest_Rate, Term_ Years)


Thank you
 
Top