How To Use in Sheets
PPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning])
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 yet. Stay tuned!