NPV

Returns a number with the net present value of an investment based on a series of periodic cash flows (payments and receipts) and a discount rate.

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

Syntax

NPV( <Rate> , <Numeric List> )

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