Value 1 is required, value 2 optional. 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 ...