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.

Calculate the weighted average of interest rates in Microsoft Excel to compute the most accurate average interest rate among a group of lenders who received different rates. When you take a ...

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 ...