NPER(rate, pmt, pv [,fv] [,type])

Returns the number of periods for an investment.

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.
* For an illustrated example refer to the page called Loan Repayments.
* The equivalent VBA function is NPER
* For the Microsoft documentation refer to support.office.com

 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

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.
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%.
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%.
7 - This is checking the answer in 3.
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

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top