You can use PMT to calculate the interest rate in Excel. However, you also need to use NPER, PV, and FV. A typing formula looks like this: =RATE(nper,pmt,pv,[fv]) where: NPER: Total number of time.

Microsoft Excel isn't just for making spreadsheets ... Sleep mode, an... How to Calculate Interest Rate on a Compensating Balance & Installment Loan How to Calculate Interest Rate on a ...