6. Functions : Finance Library Functions : NPER Function : Example—NPER function:
 
Share this page                  
Example—NPER function:
/*  Calculate the number of periods needed to repay a
**  loan of $10,000, interest rate = 7% per year and
**  payments of $200 per month. Payment will have to
**  be entered as negative since it is outflow.
*/
numbPeriods = nper(pv = 10000, i = .07/12, pmt = -200);