4. Excel PPMT Calculation Example 5. Principal Payment Schedule Table (=PPMT) Expand + What is the Excel PPMT Function? The PPMT Function in Excel returns the periodic principal payments owed on a loan, assuming fixed interest rate pricing and consistent payments. How to Use PPMT Function in ...