Hi Morey -
Here's an example for symbol AABFX for 5/31/05 to 6/16/06 If you bought it on 5/31/05, you paid 11.97 per share, the raw price. Then you received 51.8 cents per share in dividends and distributions. On 6/16/06 the price is 12.17. Your total return is 12.17 / 11.97 = 1.017% plus the dividends that come out to .518 / 11.97 = 4.33% for a total of about 6%. To estimate what the total return would have been, you pretend that you bought it at an adjusted price of 11.484 on 5/31. Now your estimated total return is 12.97 / 11.484 = 6% In short, if you use the raw price, you have to add the dividends in manually, if you use the adjusted price you don't. Best regards, Gary Lyben ----- Original Message ----- From: investor0329 To: [email protected] Sent: Sunday, June 18, 2006 6:20 PM Subject: [quotes-plus] question regarding mutual funds and QP I am trying to set up a spreadsheet that contains portfolio info. Let's say that for any given mutual fund ticker, i want to show the past year's worth of price , yield and total return info. I start with X$ number of dollars. One number I need, is the number of shares I could have bought 1 year ago (about 262 trading days ago). To do this, i divide x$ by the price 262 trading days ago. But..to do this, to I use the raw close price, or the price adjusted for yield and splits? I would need to use the price that one would have actually paid for the fund..and not what its value was adjusted for historical yield, right? or maybe i should use the adjusted price and just subtract out the dividends? Of course this can only be done for the current year, right?.. [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Something is new at Yahoo! Groups. Check out the enhanced email design. http://us.click.yahoo.com/rlNZQC/gOaOAA/cosFAA/GHeqlB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/quotes-plus/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
