"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
=(1+10%)^2-1
or
=POWER(1+10%,2)-1
--

Well, yea, I could do something like that but I was hoping there was a
built-in Excel function.

What if I look at my stock value on, say, August 13 instead of June 30? Or,
what if it had risen by 7.8292% instead of 10%? Your approach would require
a lot of additional programming. I'm looking for something more general and
standard.



"Alan Foxmore" wrote in message
...
Hi everyone,

I don't have a financial background so pardon me if the answer is
obvious.

I see Excel is loaded with financial functions and I'm not sure of the
correct one to use in my case.

For simplicity, let's say I have stock that I purchased on January 1 for
$1,000. Now, on June 30 (1/2 through the year) it's worth $1,100. The
stock's value increased by 10%. I would like to know the *annual*
percentage rate that I'm track to earn if the stock maintains its current
rate of growth.

Since my original $1,000 increased by 10% to $1,100 in six months, I see
I am on track to earn 10% every six months so that on December 31 the
stock's value will be $1,210 -- an annual return of 21%.

Can someone tell me the proper function to use?

Thanks.