NPER |
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 (0). |
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. * For an illustrated example refer to the [[Loan Repayments]] page. * 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. * You can use the FV function to return the future value for a series of equal cash flows at regular intervals. * You can use the PMT function to return the full amount (principal + interest) paid every period on a loan with fixed interest. * You can use the PV function to return the present value of a series of equal cash flows at regular intervals. * You can use the RATE function to return the interest rate for a series of equal cash flows at regular intervals * The equivalent VBA function is VBA.NPER * For the Microsoft documentation refer to support.microsoft.com * For the Google documentation refer to support.google.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 |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top