IPmt (MDX)

Returns a number with the interest payment for a given period of an annuity based on periodic, fixed payments and a fixed interest rate.

  • Returned Output: Numeric
  • Library: MDX \ VBA \ Financial
  • Version: 2018.00.000
  • Compatibility: Microsoft MDX Engines only

Syntax

IPmt( <Rate> , <periods> , <Payments> , <Present Value> )
Further Help on Syntax and Examples
  • For more details on using the VBA library in MDX please click here.
  • For more details on the syntax of the VBA function please click here