The PMT function in Excel is a financial function used to calculates the payment of a loan based on payments and interest rates. The formula for the PMT function is PMT(rate,nper,pv,[fv], [type]).

Learn how to use the powerful Excel PMT Function to help you manage your loan payments and easily calculate detailed loan repayment schedules. Skip to main content; Skip to secondary menu; ...

On the Excel screen, this function can be found using the command fx and under the category ‘Financial’. Periodic investments Here’s an example of how PMT can be used.

The PMT function is designed to calculate the periodic payment for a loan (assuming constant payments and interest rates). It's a fundamental tool for financial calculations in Excel.

Learn what present value (PV) and future value (FV) are and how to calculate present value in Excel given the future value, interest rate, and period.