Monday, September 13, 2010

Visual Basic Financial Function : PV

Purpose : This PV function to derive the present value of an annuity, assuming a constant stream of periodic payments and an unvarying interest rate.

Syntax :
PV ( dblInterestRate , intTotalPeriods , dblPayment , [ vFutureValue , [ vWhenDue ] ] )

dblInterestRate : Interest rate
intTotalPeriods : Total number of payment.
dblPayment : Amount of payment.
vFutureValue : Value of the annuity when it is complete.
vWhenDue : number specifyng whether the payments are due at the deginning (1) or end (0) of the period.

dblPresentValue = PV ( dblRate , 360 , dblPayout , 0 , 0 )

No comments:

Post a Comment