Calculate the fixed monthly payment for a loan with PMT.
Copy this formula
=PMT(rate/12, nper, -principal)PMT needs the periodic rate (annual rate ÷ 12), the number of payments (years × 12), and the loan amount. Enter the principal as negative so the payment comes out positive.
=PMT(6%/12, 30*12, -300000)→$1,798.65Monthly payment on a $300k, 30-year, 6% loan.
PMT returns the opposite sign of the principal. Enter the loan as a negative number (or negate the result) for a positive payment.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.