| | | Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate. |
| | | The present value is the lump-sum amount that the series of future payments is worth right now. |
| | | The "pmt" typically contains principal and interest but no other fees or taxes. |
| | | The "pmt" cannot change over if the life of the annuity. |
| | | If "fv" is left blank, then 0 is used. |
| | | If "type" is left blank, then 0 is used. |
| | | Example 1 - How long will it take an investment of £1500 to grow to $2000 if the average annual growth rate is 4.3%. |
| | | Example 2 - 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 and my average monthly return is 0.5%. |
| | | Example 3 - 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 and my average monthly return is 0.5%. |
| | | Example 4 - This is checking the above answers by returning the correct interest rate. |
