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.
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