Calculate the periodic payment for a loan with a constant rate.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
PMT(rate, nper, pv, [fv], [type])PMT returns the fixed payment per period for a loan, given the interest rate, number of periods, and present value (loan amount). Remember to match rate and nper to the same period (e.g. monthly rate = annual/12).
=PMT(0.05/12, 360, 300000)Result: -1,610.46
Monthly payment on a $300k, 30-yr, 5% loan (negative = outflow).
It follows cash-flow sign convention — payments are outflows. Wrap in ABS() or negate pv for a positive figure.