WorksheetFunction.Ppmt (Excel)

Returns the payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate.

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

Ppmt (Arg1, Arg2, ..., Arg6)


Dim dblArg1 As Double: dblArg1 = 
Dim dblArg2 As Double: dblArg2 = 
Dim dblArg3 As Double: dblArg3 = 
Dim dblArg4 As Double: dblArg4 = 
Dim dblPpmt As Double
dblPpmt = WorksheetFunction.Ppmt(Arg1:=dblArg1, Arg2:=dblArg2, Arg3:=dblArg3, Arg4:=dblArg4)

Arguments

Arg1, Arg2, ..., Arg6

Arg1 (Double) - Rate - the interest rate per period.

Arg2 (Double) - Per - the period and must be in the range 1 to nper.

Arg3 (Double) - Nper - the total number of payment periods in an annuity.

Arg4 (Double) - Pv - the present value—the total amount that a series of future payments is worth now.

Arg5 - 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

Arg6 - Type - the number 0 or 1 and indicates when payments are due