The PPMT function in Excel returns the payment on the principal for an investment for a given period. The formula for the PPMT function is PPMT(rate, per,nper, pv,[fv], [type]) . The Syntax for ...