Question: what is the excel formula for loan payment?
Answer: =PMT(17%/12,2*12,5400) For example, in this formula the 17% annual interest rate is divided by 12, the number of months in a year. The NPER argument of 2*12 is the total number of payment periods for the loan. The PV or present value argument is 5400.