WorksheetFunction.Pmt (Excel)

Calculates the payment for a loan based on constant payments and a constant interest rate.

For a more complete description of the arguments in Pmt, see the Pv function. The following table describes the values that can be used for Arg5.

Pmt (Arg1, Arg2, ..., Arg5)

Dim dblArg1 As Double: dblArg1 = 
Dim dblArg2 As Double: dblArg2 = 
Dim dblArg3 As Double: dblArg3 = 
Dim dblPmt As Double
dblPmt = WorksheetFunction.Pmt(Arg1:=dblArg1, Arg2:=dblArg2, Arg3:=dblArg3)

Arguments

Arg1 (Double) - Rate - the interest rate for the loan.

Arg2 (Double) - Nper - the total number of payments for the loan.

Arg3 (Double) - Pv - the present value, or the total amount that a series of future payments is worth now; also known as the principal.

Arg4 - Fv - the future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (zero), that is, the future value of a loan is 0

Arg5 - Type - the number 0 (zero) or 1; indicates when payments are due