LibreOffice 25.2 Help
Calculates the Net Present Value of an investment, based on a supplied discount rate, and a series of deposits and withdrawals.
NPV (Rate as Double, Values() as Double)
Double
Saffisnin saffisa hir'ina gatii yerooti.
Values() is an array that represent deposits (positive values) or withdrawals (negative values).
REM ***** BASIC *****
Option VBASupport 1
Sub ExampleNPV
Dim r As Double
Dim pValues(5) as Double
pValues(0) = 100
pValues(1) = 100
pValues(2) = 100
pValues(3) = -300
pValues(4) = 100
pValues(5) = 100
r = 0.06
p = NPV( r, pValues)
Print p ' returns 174,894967305331
End Sub