81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199



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

How To Use in Sheets

PPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning])

External Links

Google Sheets PPMT Function | Calculate Principal Component of Loan | Google Sheets Function

Use the Google Sheets PPMT function to calculate the principal part of a loan, for a specific month, if the same amount is repaid every month, for a fixed interest rate, for the entire tenure of the loan. For example, you can use PPMT to find out the principal amount remaining in the 11th month on a one-year loan.

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.