Visual Basic Financial Function : Rate

Purpose : The Rate function returns the interest rate of an annuity , given a constant periodic series of cash payments and an unvarying interest rate.

Syntax :
Rate ( dblTotalPeriods , dblPayment , dblPresentValue , [ vFutureValue , [ vWhenDue , [ vGuess ] ] ] )

dblTotalPeriods : Total number of periods
dblPayment : Periodic payment.
dblPresentValue :Starting value of the annuity.
vFutureValue : Value of the annuity when it is complete.
vWhenDue : Number specifying whether the payment are due at the beginning (1) or end (0) of the period
vGuess : Estimate for the rate used as a starting point in the first iteration.

dblRate = Rate ( 360 , 600 , -100000 , 0 , 0.1 ) * 12