PPmt Function
Microsoft.VisualBasic.Financial
PPmt(rate
,per
,nper
,pv
[,fv
[,due
]])
rate
(required; Double)The interest rate per period.
per
(required; Double)The period for which a payment is to be computed.
nper
(required; Double)The total number of payment periods.
pv
(required; Double)The present value of a series of future payments.
fv
(optional; Object)The future value or cash balance after the final payment. If omitted, the default value is 0.
due
(optional; DueDate
enumeration)A value indicating when payments are due. It can be either
DueDate.
EndOfPeriod
(or 0),
for payments due at the end of the period, or
DueDate.BegOfPeriod
(or 1), for payments due at
the beginning of the period. The default value is
DueDate.EndOfPeriod
.
A Double representing the principal paid in a given payment
Computes the payment of principal for a given period of an annuity, based on periodic, fixed payments and a fixed interest rate. An annuity is a series of fixed cash payments made over a period of time. It can be either a loan payment or an investment.
The value of per
can range from 1 to
nper
.
If pv
and fv
represent liabilities, their value is negative; if they represent
assets, their value is positive.
If fv
is omitted, its default value of 0
is used.
If due
is omitted, the default value of 0
(reflecting payments at the beginning of each period) is used.
See the example for the IPmt Function entry.
No credit card required