If you're working with loans, mortgages, or installment plans, Excel’s PPMT function helps break down your payments and show how much of each one goes toward the principal—not just the total payment. Let's explore how it works step by step, from the basics to more advanced, real-world uses. The PPMT function calculates the principal portion of a loan payment for a given period, based on constant interest and fixed payments.