PV
Basic Overview
AVAILABLE SINCE 5.3.1
Description (Present Value)  Calculates the present value of a certain sum in the future. It is based on an interest rate, a number of recurring payments in the future, the amount of payment per period, the future value and either ordinary annuity or annuity due (type) indicating whether payments are due at the beginning or the end of period. 
Signature  PV('Rate', 'Nper', 'Pmt' [, 'Fv' , "Type"]) 
Parameters 

Notes 

Limitations 

Positive Costs/Payments
In case the costs/payments are entered as a positive number within your model, this function needs to be multiplied by (1).
Example
Rate (Interest Rate)  0.03 
Nper (Number of Periods)  5 
Pmt (Payment per Period)  500 
Fv (Future Value)  0 
Type Payment at Beginning of Period (Annuity Due) = 1 Payment at End of Period (Ordinary Annuity) = 0  0 
Valsight Formula  PV(Rate, Nper, Pmt, Fv, 0) 
Result  2,289.85 
Contact
You may contact the Valsight Customer Support via:
+49 30 46799042
Availability: MonFri *, 9 AM to 5 PM (Berlin, Germany) .
_{*Except Public holidays in Berlin, Germany.}