ExcelBanter - Average annual GROWTH

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Average annual GROWTH (https://www.excelbanter.com/excel-worksheet-functions/155229-average-annual-growth.html)

Average annual GROWTH

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

Duke Carey

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

Fred Smith

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

All times are GMT +1. The time now is 06:55 PM.