81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199



Calculates the periodic payment for an annuity investment based on constant-amount periodic payments and a constant interest rate.

How To Use in Sheets

PMT(rate, number_of_periods, present_value, [future_value], [end_or_beginning])

External Links

Make an Amortization Table in Google Sheets

This video shows how to construct an amortization table in Google Sheets using fills and the PMT function.

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.