VB .NET Language in a Nutshell

Name

PPmt Function

Class

Microsoft.VisualBasic.Financial

Syntax

PPmt(rate, per, nper, pv[, fv[, due]])

rate

Use: Required

Data Type: Double

The interest rate per period.

per

Use: Required

Data Type: Double

The period for which a payment is to be computed.

nper

Use: Required

Data Type: Double

The total number of payment periods.

pv

Use: Required

Data Type: Double

The present value of a series of future payments.

fv

Use: Optional

Data Type: Object

The future value or cash balance after the final payment. If omitted, the default value is 0.

due

Use: Optional

Data Type: 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.

Return Value

A Double representing the principal paid in a given payment

Description

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.

Rules at a Glance

• 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.

Example