View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith Fred Smith is offline
external usenet poster
 
Posts: 623
Default Average annual GROWTH

Also, if you're required to use a function, it's Rate.

--
Regards,
Fred


"Duke Carey" wrote in message
...
Sounds suspiciously like homework.

Avg annual growth rate = ((FV/PV) ^ (1/# periods)) -1

format as a percent

"BA" wrote:

Can anyone tell me how i would calcualte the average annual growth if i have
9 as the number of periods PV= 935,686 FV= 7,494,992.
the answer is 1.297045258