PV

Returns a number with the present value of an annuity based on periodic, fixed payments to be paid in the future and a fixed interest rate.

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

Syntax

PV( <Rate> , <periods> , <Payments> )

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