PPMT Function

Originally published at: How to use the PPMT Function in Excel - Excelbuddy.com

The PPMT Function in Excel is used to calculate the principle of a given loan payment. If all you a trying to determine is the principle of a loan, this is the function to use. You are able to determine the principle for the first period, last period, or any specified period in between. Syntax:…

Looking at a dynamic approach next.