VB .NET Language in a Nutshell

Name

IPmt Function

Class

Microsoft.VisualBasic.Financial

Syntax

IPmt(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: Double

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. DueDate.EndOfPeriod (or 0) indicates that payments are due at the end of the payment period; DueDate.BegOfPeriod (or 1) indicates that payments are due at the beginning of the period. If omitted, the default value is DueDate.EndOfPeriod.

Return Value

A Double representing the interest payment

Description

Computes the interest payment 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.

Example

The ComputeSchedule function accepts a loan amount, an annual percentage rate, and a number of payment periods. It uses the Pmt function to calculate ...