Related Topics:

Spreadsheet Mathematical Functions

Function Wizard Functions

NPER

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

Syntax: NPER(Rate, Pmt, PV [FV], [Type])

Set Type equal to If payments are due
0 or omitted At the end of the period
1 At the beginning of the period

 

Example:

 

© 1992-2013. ReliaSoft Corporation. ALL RIGHTS RESERVED.