![]() |
how to calculate a value with a percentage growth over 22 years
i need formula for excel
|
how to calculate a value with a percentage growth over 22 years
Try this
=FV(0.05, 22, 0,-1000) Where 0.05 is the intereset rate 22 is the number of years 1000 is the starting capital (Note the minus sign) Mike "mike" wrote: i need formula for excel |
how to calculate a value with a percentage growth over 22 years
If your growth rate is in cell A3 and it is compounded annually, and the
original value is in A2, the answer is =A2*(1+A3)^22 Next time, please remember to ask your question in the body of the message, not in the subject line. -- David Biddulph "mike" wrote in message ... i need formula for excel |
All times are GMT +1. The time now is 01:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com