Formula for Annualized percentage
 

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

Formula for Annualized percentage
 

I think what you are looking for is this


Code:
--------------------
=365/(B1-A1)*(C1)
--------------------


If your dates are actual dates in excel there is no need for datevalue.


--
Excelenator


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

Formula for Annualized percentage
 

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


--
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

Formula for Annualized percentage
 

Format the resulting cell as a percentage.


--
Excelenator


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

Formula for Annualized percentage
 

:) Well Da!!

That fixed it! 1376.22% !!

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

Thanks a lot

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

Formula for Annualized percentage
 

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






"Sat-Geek" wrote in
message ...

:) Well Da!!

That fixed it! 1376.22% !!

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

Thanks a lot

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

Formula for Annualized percentage
 

Opps!!

Should be:


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


=318.868
Don

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






"Sat-Geek" wrote
in message ...

:) Well Da!!

That fixed it! 1376.22% !!

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

Thanks a lot

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

Formula for Annualized percentage
 

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


--
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