The PPMT and IPMT functions use the same syntax.

Name: The PPMT and IPMT functions use the same syntax.
Brand: Quizplus
Rating: 4.8 (54 reviews)

Question

Quizplus · Accepted Answer

Both the PPMT and IPMT functions use the same syntax, which includes the arguments for the rate, number of periods, present value, and optional future value and type arguments. The only difference between the two functions is that PPMT calculates the principal payment for a given period, while IPMT calculates the interest payment for a given period.

The PPMT and IPMT Functions Use the Same Syntax