Table of Contents

Search

  1. Preface
  2. The Transformation Language
  3. Constants
  4. Operators
  5. Variables
  6. Dates
  7. Functions
  8. Creating Custom Functions
  9. Custom Function API Reference

Transformation Language Reference

Transformation Language Reference

NPER

NPER

Returns the number of periods for an investment based on a constant interest rate and periodic, constant payments.

Syntax

NPER(
rate, present value, payment
[,
future value, type
] )
The following table describes the arguments for this command:
Argument
Required/
Optional
Description
rate
Required
Numeric. Interest rate earned in each period. Expressed as a decimal number. Divide the rate by 100 to express it as a decimal number.
present value
Required
Numeric. Lump-sum amount a series of future payments is worth.
payment
Required
Numeric. Payment amount due per period. Must be a negative number.
future value
Optional
Numeric. Cash balance you want to attain after the last payment is made. If you omit this value, NPER uses 0.
type
Optional
Boolean. Timing of the payment. Enter 1 if payment is at the beginning of period. Enter 0 if payment is at the end of period. Default is 0. If you enter a value other than 0 or 1, the
PowerCenter Integration Service
treats the value as 1.

Return Value

Numeric.

Example

The present value of an investment is $500. Each payment is $2000 and the future value of the investment is $20,000. The following expression returns 9 as the number of periods for which you need to make the payments:
NPER ( 0.015, -500, -2000, 20000, TRUE )

Notes

To calculate interest rate earned in each period, divide the annual rate by the number of payments made in an year. For example, if you make monthly payments at an annual interest rate of 15 percent, the value of the Rate argument is 15% divided by 12. If you make annual payments, the value of the Rate argument is 15%.
The payment value and present value are negative because these are amounts that you pay.