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

NPER( rate, present value, payment [, future value, type] )

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. Must be greater than or equal to 0. |

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, Data Integration treats the value as 1. |

Numeric.

The present value of an investment is $2,000. Each payment is $500 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.01, -2000, -500, 20000, TRUE )

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.

© Copyright Informatica LLC 2007, 2021