View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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