## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

No credit card required

PPmt Function

## Class

Microsoft.VisualBasic.Financial

## Syntax

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

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

See the example for the IPmt Function entry.

## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

No credit card required