Calculates the periodic payment for an annuity investment based on constant-amount periodic payments and a constant interest rate.
Description
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 yet. Stay tuned!