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.