Microsoft Office Development and Consultancy 
Home    VBA    C#    Excel    Word    PowerPoint    Outlook    Tools    Newsletter    Contact 
Excel > Functions > Financial > NPER 
NPER(rate, pmt, pv [,fv] [,type]) 
Returns the number of compounding periods for a series of equal cash flows at regular intervals. 
rate  The fixed interest rate per period.  
pmt  The payment made each period.  
pv  The present value.  
fv  (Optional) The future value (or cash balance) after all the payments.  
type  (Optional) The number indicating when the payments are due: 0 = the end of the period (default) 1 = the start of the period 
REMARKS 
EXAMPLES 

Functions  N  Index  N  Office Online 2013  2010  2007  2003 
© Better Solutions Limited 26Mar2014  Top 