NPER

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 (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

 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

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