Thread: Average annual GROWTH
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey Duke Carey is offline
external usenet poster
  
Posts: 1,081
Default Average annual GROWTH
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

Reply With QuoteReply With Quote