Module 48: PMT Function

48.1 PMT Function PMT is one of the more important financial functions you will use in Excel. The PMT function in Excel can be used to calculate the payments for a loan if it has constant payments and a constant interest rate. The formula is written as: =PMT(rate, per, nper, pv, [fv], [type]) Rate - This is the interest rate. Nper - This is the total number of payments to make. Pv - This is the present value. Fv - This is an optional argument. It is the future va...

Lessons

Find out how we can help train your staff

Or buy an individual course