NPER(rate, pmt, pv [,fv] [,type])
Returns the number of periods for an investment.
|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
|* 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
|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
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top