Trying to come up with a formula to show the annualized percentage rate
of an investment. Ie: Value is up 10% over a 30 day period, what would
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 ;)


--
Sat-Geek
------------------------------------------------------------------------
Sat-Geek's Profile: http://www.excelforum.com/member.php...o&userid=37091
View this thread: http://www.excelforum.com/showthread...hreadid=568196