What Formula should I use to obtain payments on a loan:
Loan value $1000
Monthly Payments : Loan repayment and interest
Maturity : 5-years
Interest rate :5%
You use IPMT and PPMT for Interest and Principle, respectively. As shown on the attached Loan Amortization worksheet.