Name

NPV Function — Microsoft.VisualBasic.Financial

Synopsis

NPV(rate, valuearray(  ) )
rate required; Double

The discount rate over the period, expressed as a decimal

valuearray( ) required; Double

An array of cash flow values

Return Value

A Double specifying the net present value

Description

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

The net present value is the value today of a series of future cash flows discounted at some rate back to the first day of the investment period.

Get VB.NET Language Pocket Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial