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.

 rateThe fixed interest rate per period.
 pmtThe payment made each period.
 pvThe 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
 
  • This function allows you to calculate the length of time it will take to arrive at a particular value in the future.
  •  
  • A negative number represents any cash you pay out.
  •  
  • A positive number represents any cash you receive (start with or end with).
  •  
  • The "rate" can be entered with a percentage sign or as a decimal.
  •  
  • If "fv" is left blank, then 0 is used.
  •  
  • The "pmt" must be greater than the "rate" * "pv". If not then #NUM! is returned.
  •  
  • The "pv" is the present value of
  •  
  • If "type" = 0, then payments are made in arrears.
  •  
  • If "type" is left blank, then 0 is used.
  •  
  • Example 1, 2, 3 & 4 - How many years will it take an investment of £1,500 to grow to £2,000 if the average annual growth rate is 4.3% and payments are at the end of each period.
  •  
  • Example 5 - How many years will it take for me to save £60,000 if my bank account is currently £5,000 and I deposit £750 every month with monthly interest of 0.5%.
  •  
  • Example 6 - How many months will it take for me to save £60,000 if my bank account is currently £5,000 and I deposit £750 every month with monthly interest of 0.5%.
  •  
  • Example 7 - This is checking the answer in Example 3.
  •  
  • Example 8 - How many months will it take me to pay off my mortgage of £150,000 if the interest rate is 6% and I pay off £1000 a month

  •  EXAMPLES
     
     A
    1=NPER(4.3%,,-1500,2000) = 6.83 years
    2=NPER(4.3%,0,-1500,2000) = 6.83 years
    3=NPER(4.3%,0,-1500,2000,0) = 6.83 years
    4=NPER(4.3%,0,-1500,2000,1) = 6.83 years
    5=NPER(0.5%,-750,5000,60000) = 74.26 years
    6=NPER(0.5%,-750,5000,60000)*12 = 891.12 months
    7=RATE(74.26,-750,5000,60000) = 0.5%
    8=NPER(6%/12,-1000,150000) = 277.95
     

     Functions - N | Index - N | Office Online 2013 | 2010 | 2007 | 2003 

     © Better Solutions Limited 26-Mar-2014Top