NPER (PQL - xl)

This function returns the number of periods for an investment based on a present value, future value, periodic payments, and a specified interest rate

  • Library: PQL \ Spreadsheet \ Financial
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
  • Solve: This function can be used with the Solve plug-in: both as part of the objective function and constraint functions

Syntax

NPER(rate, pmt, pv, OPTIONAL fv, OPTIONAL type)

Function Arguments

Name

Description

Type

Optional

rate

Interest rate expressed as percentage (per period)

Number

pmt

Payment made each period; cannot change over life of the annuity

Number

pv

Present value

Number

fv

Future value; if omitted, the calculation uses zero (0)

Number

Y

type

Indicates when payments are due; at the end (0) or beginning (1) of the period; if omitted, the calculation uses the end (0)

Number

Y

Comments

This function is the same as the Microsoft Excel 'NPER' function - using the same inputs, logic and outputs.