Aug 17 2020 01:21 PM
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%
Aug 17 2020 02:09 PM
You use IPMT and PPMT for Interest and Principle, respectively. As shown on the attached Loan Amortization worksheet.
Aug 17 2020 02:12 PM