ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to calculate a value with a percentage growth over 22 years (https://www.excelbanter.com/excel-discussion-misc-queries/203892-how-calculate-value-percentage-growth-over-22-years.html)

Mike

how to calculate a value with a percentage growth over 22 years
 
i need formula for excel

Mike H

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


David Biddulph[_2_]

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