Formula for Annualized percentage

[Sat-Geek]

Trying to come up with a formula to show the annualized percentage rat
of an investment. Ie: Value is up 10% over a 30 day period, what woul
the annual percentage be if it continued to increase at the same rate?

A1=Date acquired
B1=Date sold or present date
C1=% increase (decrease) during period
D1=Annualized percentage

Any help or suggestions would be greatly appreciated

Thanks
Sat-Geek ;

 

[Excelenator]

I think what you are looking for is this


Code

 

[Sat-Geek]

Thanks for your input. I tried your suggestion and it returned a date
(1/13/00)

I used =365/(B1-A1)*(C1) with the cells corrected to the actual data
cells, in this case: =365/(F5-C5)*(I5)

F5=8/3/06
C5=7/31/06
I5=11.31% (return from another formula)

Did I do somnething wrong?

Thanks
Sat-Geek

 

[Excelenator]

Format the resulting cell as a percentage

 

[Sat-Geek]

Well Da!!

That fixed it! 1376.22% !!

A few years like that and I'm ready to retire!!

Thanks a lot

Sat-Geek

 

[Don]

Sat-Geek

You seem to be happy with the results, however if you are using your example
of 10% over 30 days , the coumpound annual rate is more like:

318.868%

=((1+((1+A3)^(1/(A2-A1))-1))^365)

Don

 

[Don]

Opps!!

Should be:


=((1+((1+C1)^(1/(A2-A1))-1))^365)


=318.868
Don

 

[Sat-Geek]

Those numbers were hypothetical and the actual yield is 1376.22%
annually. Of course I can not expect it to continue at that rate but I
can dream can't I?

Sat-Geek