Visual Basic Financial Function : Pmt

Purpose : The Pmt function to return the total payment amount ( principal and interest ) on an annuity , assuming constant periodic payments and a constant interest rate.

Syntax :
Pmt ( dblInterestRate , intNumberOfPayments , [ vPresentValue , [ vFutureValue , [ vWhenDue ] ] ] )

dblInterestRate : Interest rate.
intNumberOfPayments : Number of Payments.
vPresentValue : Starting value of the 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.

dblTetalPayment = Pmt ( dblRate / 12 , intNumPayment , -dblMortgage , 0 , 0 )