### PPmt

Basic and Crystal syntax.

##### Overloads

- PPmt (rate, period, nPeriods, presentValue)
- PPmt (rate, period, nPeriods, presentValue, futureValue)
- PPmt (rate, period, nPeriods, presentValue, futureValue, type)

##### Arguments

- rate is a Number that specifies the interest rate per period.
- period is a Number that specifies the payment period in the range 1 through nPeriods.
- nPeriods is a positive Number that specifies the total number of payment periods in the annuity. The units used for specifying rate, period and nPeriods must be consistent. For example, if nPeriods is the number of periods in months, then rate is a monthly interest rate and period specifies a month.
- presentValue is a Number or Currency that specifies the present value, or value today, of a series of future payments or receipts.
- futureValue is an optional Number or Currency that specifies the future value or cash balance you want after you've made the final payment. If omitted, 0 is assumed.
- type is an optional Number that specifies when payments are due. Specify 0 if payments are due at the end of the payment period, and 1 if payments are due at the beginning of the period. If omitted, 0 is assumed.

##### Returns

Number value

##### Action

PPmt returns a Number specifying the principal payment for a given period of an annuity based on periodic, fixed payments and a fixed interest rate.

##### Examples

The following examples are applicable to both Basic and Crystal syntax:

Suppose that you want to take out a $250,000 loan payable monthly over 15 years at an annual interest rate of 7 percent. The following formula returns the amount of principal that you pay in your first loan payment. Note that the monthly interest rate is 0.07 / 12 and the number of months of the loan is 15 * 12.

`PPmt (0.07 / 12, 1, 15 * 12, 250000)`

Returns the Number value -788.74 (rounded to 2 decimals). The value is negative because it represents a payment out from you whereas the loan amount of $250,000 is positive because it represents a payment in to you.

The following formula returns the amount of principal that you pay in your 121st payment (after 10 years of payments):

`PPmt (0.07 / 12, 10*12 + 1, 15 * 12, 250000)`

Returns -1585.09 (rounded to 2 decimals). You've made progress on the loan and are paying off more of the principal per payment. This is because less interest can accrue each month since more of the loan is paid off so that your fixed monthly payment is applied more to the principal.

The following Basic syntax formula returns the amount of the loan that has been paid off after 10 years by summing up the principal payments made for the first 120 monthly payment:

Rem Basic syntax
Dim total, i
total = 0
For i = 1 To 10 * 12
total = total + PPmt (0.07 / 12, i, 15 * 12, 250000)
Next i
formula = total

Returns -136518.45 (rounded to 2 decimals). So you have paid off $136,518.45 of the loan and still owe $113,481.55 after the 120th payment.

Another way to calculate the amount you still owe after 10 years is to use 2 financial functions:

Rem Basic syntax
Dim payment
payment = Pmt (0.07 / 12, 15 * 12, 250000)
formula = FV (0.07 / 12, 10 * 12, payment, 250000)

Returns -113481.55 (rounded to 2 decimals). So you still owe $113, 481.55 after 10 years of payments.

##### Comment

This function is designed to work like the Visual Basic function of the same name.

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com