Thread: Compounded Rate
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Compounded Rate

=(1+28.08%)^(1/n)
where n is the number of years to give 28.08%
--
David Biddulph

"GatorGirl" wrote in message
...
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?