Bespoke Microsoft Office Development 
Consultancy    Excel    Word    PowerPoint    Outlook    VBA    Tools    Newsletter 
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 31Aug2014  Top 