Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for Annualized percentage
:) Well Da!! That fixed it! 1376.22% !! A few years like that and I'm ready to retire!! 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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!! 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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!! 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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a formula by percentage within a formula? | Excel Worksheet Functions | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
formula percentage problem | New Users to Excel | |||
How do I formula a percentage with text values in the data field | Excel Worksheet Functions | |||
Percentage Formula | Excel Worksheet Functions |