Free PMT Formula Generator

Calculates the payment for a loan based on constant payments and a constant interest rate.

Generated Formula
=PMT(rate, nper, pv)

Learning Resources

Want to master Excel? Check out this Top-Rated Course.

Related Formulas

SUMIFCOUNTIFSUMIFSCOUNTIFSAVERAGEIF

Want to become an Excel Pro?

Stop searching for formulas. Master Excel in 30 days with this top-rated course.

Learn More