Visual Basic Financial Function : PPmt

Purpose : The PPmt function returns the amount of principal payment for an annuity, assuming constant periodic payments and an unvarying interest tare.

Syntax :
PPmt ( dblInterestRate , intwhichperiod , intTotalPeriods , vPresentValuse [ , vFutureValue , [ vWhenDue ] ] )

dblInterestRate : Interest Rate.
intwhichperiod : Sequential number representing current period.
intTotalPeriods : Total number of periods.
vPresentValuse : Starting value of then annuity.
vFutureValue : Value of the annuity when it is complete.
vWhenDue : Number specifying whether the payments are due at the beginning (1 ) or end (0 ) of the period.

dblPrincipal = PPmt ( dblRate / 12 , intPeriod , 360 , dblMortageAmount , 0 , 0 )