Home » Posts

PMT Function

The Excel PMT function is a financial function that returns the periodic payment for a loan. You can use the PMT function to figure out payments for a loan, given the loan amount, number of periods, and interest rate.

April 14, 2025 · 1 min · 6 words · Kelly Hall

The RATE function calculates by iteration.

Excel formula: Estimate mortgage payment

Excel formula: Calculate payment for a loan

Excel formula: Mortgage payment schedule

Excel formula: Calculate periods for annuity

Excel formula: Payment for annuity

Excel FV function

Excel PV function

Excel RATE function

Excel NPER function

Excel PMT function

Excel PPMT function

Excel IPMT function

Excel CUMPRINC function

Excel CUMIPMT function