Visual Basic Financial Function : IPmt

Purpose : The IPmt function returns the interest portion of a payment on an annuity, given constant payments and a constant interest rate.

Syntax :
IPmt ( dblRate , dblCurrentPeriod , dblNumberTotalPeriods , [ vPresentValue , [ vFunctionValue , [ vWhenDue ] ] ] )

dblRate : Effective interest rate of the annuity.
dblCurrentPeriod :Sequential number representing the current period
dblNumberTotalPeriods : Number of Payments
vFunctionValue :Value of the annuity when it is complete.
vWhenDue : Number specifying whether the payments are due at the beginning(1) or end of the period (0)

interest = IPmt ( dblRate / 12 , dblThisMonth , 360 , vLonaAmount , 0 , 0 )