Use of Excel Financial Formula

Copper Contributor

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%

2 Replies

@M_K_Rahim 

 

You use IPMT and PPMT for Interest and Principle, respectively. As shown on the attached Loan Amortization worksheet.

 

Hello,

Kindly visit the link below to guide

https://exceljet.net/formula/calculate-payment-periods-for-loan