| | | This function allows you to calculate the length of time it will take to arrive at a particular value in the future. |
| | | Any cash you pay out is represented by a negative number. |
| | | Any cash you receive (start with or end with) is represented by a positive number. |
| | | The "rate" can be entered with a percentage sign or as a decimal. |
| | | If "fv" is left blank, then 0 is used. |
| | | 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 - 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%. |
| | | Example 3 - 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 4 - 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 5 - This is checking the answer in Example 3. |
