Thread: Compounded Rate
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bpeltzer bpeltzer is offline
external usenet poster
 
Posts: 171
Default Compounded Rate

=((final_value / initial_value) ^ (1/number_of_years)) - 1
Ex ((12808/10000) ^ (1/3) - 1 = 8.6%

"GatorGirl" wrote:

I need to have a formula which solves what the constant rate of increase per
year was to obtain a figure.

I know the % increase from base yr to end yr was 28.08%. I now need to know
what % (constant) was needed to increase each year to get to the end figure.

Make sense?