| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding Annual Growth Rate | Excel Worksheet Functions | |||
| annual growth rate from monthly data | Excel Discussion (Misc queries) | |||
| How to: average annual growth | Excel Worksheet Functions | |||
| How to: average annual growth | Excel Worksheet Functions | |||
| Compound Annual Growth Rate | Excel Discussion (Misc queries) | |||
Threaded Mode
