Calculates the payment on the principal of an investment based on constant-amount periodic payments and a constant interest rate.
81% OFF online library of tutorials for mastering Google Sheets
PPMT()
Description
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.