Join Early Retirement Today
Reply
 
Thread Tools Display Modes
Figuring total returns vs. price change only?
Old 09-21-2008, 01:42 PM   #1
Recycles dryer sheets
Gardnr's Avatar
 
Join Date: Jul 2008
Location: ENE MO - near STL
Posts: 424
Figuring total returns vs. price change only?

Splitting off from another thread:


Quote:
Originally Posted by cute fuzzy bunny View Post
Quote:
Quote:
Originally Posted by Art G
BTW, you might want to consider adding in reinvested dividends into your charts. That's probably what screwed up your numbers. I'd bet a nickel you already knew that though.
You're right, I did. But the dividends are included. Everything is in there, except the American Funds front end loads of 5.75%.
CFB

Help me out here with something I've been trying to figure out. How do I find out and compare the total returns for different stocks/funds in chart form or otherwise? It's tough to compare apples to apples without figuring in reinvested dividends (and cap gains for funds).

Don't the charts just graph prices? Or can you configure them to somehow figure in divs and cap gains?

This can really lead to misunderstandings when comparing performance, especially between high yielding div stocks vs. growth stocks (or funds).

Thanks
Gardnr is offline   Reply With Quote
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!

Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that Early-Retirement.org is a great community to join. Best of all it's totally FREE!

You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!

Old 09-21-2008, 03:43 PM   #2
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
dex's Avatar
 
Join Date: Oct 2003
Posts: 5,105
Don't rely on this answer - let's see what others have to say.
My guess is that the dividends and cap gains are factored in by the market and included in the price.
After the date of record the price goes down to reflect the dividend/cap gain.
If for example, the company declares a special dividend of $x the price of the stock will rise to current price + $X dividend. After the date of record the price of the stock will decrease by the dividend amount.
__________________
Sometimes death is not as tragic as not knowing how to live. This man knew how to live--and how to make others glad they were living. - Jack Benny at Nat King Cole's funeral
dex is offline   Reply With Quote
Old 09-21-2008, 04:32 PM   #3
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
cute fuzzy bunny's Avatar
 
Join Date: Dec 2003
Location: Losing my whump
Posts: 22,708
Quote:
Originally Posted by dex View Post
Don't rely on this answer - let's see what others have to say.
I'll take that in a nice way. As soon as I figure out how.

The microsoft chart tool offers both a price chart and a "value of 10,000 invested" chart.

The latter includes expenses, reinvested dividends, etc.

As to whether its accurate or not, who knows?

For the particular chart I put together comparing TSM with AMCAP, TSM has a current yield of ~2% while AMCAP is around 1%.

So even if the chart excluded reinvested dividends (which would make it a rather pointless option) I dont think AMCAP would have made up any ground by having half the dividend. That whole "but we make it up on the volume" thing really doesnt work.

Maybe some of the other funds have dividends higher than 2%, in which case I'd suggest comparing them with one (or more) of the value indexes...since that style seems to better match the investing philosophy at American.

I can tell you one thing...changing from the price to value invested charts makes a huge difference in the numbers...
__________________
Be fearful when others are greedy, and greedy when others are fearful. Just another form of "buy low, sell high" for those who have trouble with things. This rule is not universal. Do not buy a 1973 Pinto because everyone else is afraid of it.
cute fuzzy bunny is offline   Reply With Quote
Old 09-21-2008, 04:33 PM   #4
Full time employment: Posting here.
lemming's Avatar
 
Join Date: May 2008
Posts: 597
Vanguard has a chart that shows a hypothetical $10,000 invested for 10years to show a
funds history. I believe that assumes reinvesting all dividends.
I just did a couple of funds including their MMF . That fund should show a straight line over time if it only included share value.
lemming is online now   Reply With Quote
Old 09-21-2008, 04:39 PM   #5
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: Sep 2005
Location: Northern IL
Posts: 26,824
One way that I know of, is to go to the Yahoo 'historical prices' - they have a column labeled 'adjusted prices'. It adjusts for splits and dividends. As you go back in time, if there was a $1 payout, they drop the NAV to reflect that.

Dex is correct in that the fund/stock price goes lower based on a payout, but the graph will show that, making it look like you lost the money - but you got it. It just isn't on the chart. Yes, it goes up/down, but look at it this way - a $100 NAV stock pays a $5 div each year. 10 years later, if the stock is still $100 - the chart would show flat performance. But, you gained $50 over the years (plus interest if you took it out, or $50 more shares owned and added div payout if re-invested).

I've posted the same Q as Gardnr a couple times over the years, on a couple forums - never got a good source for charts that do this (splits, may show divs, but not reinvested). I agree, it makes just looking at a chart pretty meaningless when one investment has very small payouts, and another has large payouts.

-ERD50
ERD50 is offline   Reply With Quote
Old 09-21-2008, 04:40 PM   #6
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: Sep 2005
Location: Northern IL
Posts: 26,824
Quote:
Originally Posted by lemming View Post
Vanguard has a chart that shows a hypothetical $10,000 invested for 10years to show a
funds history. I believe that assumes reinvesting all dividends.
I just did a couple of funds including their MMF . That fund should show a straight line over time if it only included share value.
Yes, the '$10,000 invested' is what you want - but can you compare stocks and ETFs with that, or just some select funds?

- ERD50
ERD50 is offline   Reply With Quote
Old 09-21-2008, 04:46 PM   #7
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
cute fuzzy bunny's Avatar
 
Join Date: Dec 2003
Location: Losing my whump
Posts: 22,708
Hmm, quick test. I did a price and investment chart on VTSMX and on the price chart it shows a ~35% value change over ten years and ~50% investment change. So obviously its incorporating dividends.

Looking at vanguards numbers from their web site, they're saying ~3.5% price change per year over the last ten years and a little over 5% total return. So it seems pretty accurate for that particular fund.
__________________
Be fearful when others are greedy, and greedy when others are fearful. Just another form of "buy low, sell high" for those who have trouble with things. This rule is not universal. Do not buy a 1973 Pinto because everyone else is afraid of it.
cute fuzzy bunny is offline   Reply With Quote
Old 09-21-2008, 04:46 PM   #8
Dryer sheet wannabe
Bails's Avatar
 
Join Date: Sep 2008
Location: Wollongong, Australia
Posts: 20
I am in a different country , but we do have a lot of managed funds. One thing I am certain of is it is very hard to analyze managed funds from their data. For example in Australia, the funds record yield based on returns being reinvested, however if you were invested in the fund you would still have to pay tax, even if the funds were reinvested. Another feature of managed funds in Australia, it the fund incurs capital gains within the fund, this is not taken into account, as an investor you pay, but the funds doesn't take this into account.

For me the only true way to wealth is buying securities directly, this means you sell when you want to, always know what the tax is, and always know what you own.

just a couple of observations for thought.
Bails is offline   Reply With Quote
Old 09-21-2008, 09:47 PM   #9
Recycles dryer sheets
Gardnr's Avatar
 
Join Date: Jul 2008
Location: ENE MO - near STL
Posts: 424
Quote:
Originally Posted by cute fuzzy bunny View Post
The microsoft chart tool offers both a price chart and a "value of 10,000 invested" chart.

The latter includes expenses, reinvested dividends, etc.

As to whether its accurate or not, who knows?
I went back there and looked for that feature and I'll be damned but I can't find it anywhere. Help me out with a pointer.

Laclede Group Inc (LG) - Stock chart, Index chart - MSN Money

Am I at the same place you're referring to?


Quote:
For the particular chart I put together comparing TSM with AMCAP, TSM has a current yield of ~2% while AMCAP is around 1%.

So even if the chart excluded reinvested dividends (which would make it a rather pointless option) I dont think AMCAP would have made up any ground by having half the dividend. That whole "but we make it up on the volume" thing really doesnt work.
Hey, you don't have to convince me. I'm a VG devotee.
Gardnr is offline   Reply With Quote
Old 09-21-2008, 09:52 PM   #10
Recycles dryer sheets
Gardnr's Avatar
 
Join Date: Jul 2008
Location: ENE MO - near STL
Posts: 424
Quote:
Originally Posted by ERD50 View Post
One way that I know of, is to go to the Yahoo 'historical prices' - they have a column labeled 'adjusted prices'. It adjusts for splits and dividends. As you go back in time, if there was a $1 payout, they drop the NAV to reflect that.
Yeah, I've seen that. But there's no easy way to graph that data, that I know of anyway.

Quote:
I've posted the same Q as Gardnr a couple times over the years, on a couple forums - never got a good source for charts that do this (splits, may show divs, but not reinvested). I agree, it makes just looking at a chart pretty meaningless when one investment has very small payouts, and another has large payouts.

-ERD50
Pretty aggravating, isn't it? I've just got to think there's a good answer out there somewhere for comparing total returns for a selectable date range.
Gardnr is offline   Reply With Quote
Old 09-22-2008, 08:32 PM   #11
Recycles dryer sheets
Gardnr's Avatar
 
Join Date: Jul 2008
Location: ENE MO - near STL
Posts: 424
Quote:
Originally Posted by Gardnr View Post
I went back there and looked for that feature and I'll be damned but I can't find it anywhere. Help me out with a pointer.

Laclede Group Inc (LG) - Stock chart, Index chart - MSN Money

Am I at the same place you're referring to?
Hey CFB or anybody. Don't let this die. I need to learn!

Thanks
Gardnr is offline   Reply With Quote
Old 09-22-2008, 08:37 PM   #12
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
cute fuzzy bunny's Avatar
 
Join Date: Dec 2003
Location: Losing my whump
Posts: 22,708
Ah, I think the trouble you're having is that you need to use internet exploder and download the 'chart toolbox' to get the cool charts.

Go here and follow the instructions.

Screener -- Promotion - MSN Money

I keep forgetting that this is something I always put on my computer when its new...

Once you have the toolbox installed, go to Personal Finance and Investing - MSN Money, stick in a ticker, click on 'historic charts' (or whatever the chart thing says on the left side under the quotes and snapshots) and the activex control for charting will pop up. You can then drop down options for the different types of charts, the time periods, etc, and then you can add other symbols to compare on the chart.
__________________
Be fearful when others are greedy, and greedy when others are fearful. Just another form of "buy low, sell high" for those who have trouble with things. This rule is not universal. Do not buy a 1973 Pinto because everyone else is afraid of it.
cute fuzzy bunny is offline   Reply With Quote
Old 09-22-2008, 10:35 PM   #13
Recycles dryer sheets
Gardnr's Avatar
 
Join Date: Jul 2008
Location: ENE MO - near STL
Posts: 424
Quote:
Originally Posted by cute fuzzy bunny View Post
Ah, I think the trouble you're having is that you need to use internet exploder and download the 'chart toolbox' to get the cool charts.

Go here and follow the instructions.

Screener -- Promotion - MSN Money

I keep forgetting that this is something I always put on my computer when its new...

Once you have the toolbox installed, go to Personal Finance and Investing - MSN Money, stick in a ticker, click on 'historic charts' (or whatever the chart thing says on the left side under the quotes and snapshots) and the activex control for charting will pop up. You can then drop down options for the different types of charts, the time periods, etc, and then you can add other symbols to compare on the chart.
Ah, I see. I usually use Firefox but I guess I can break out the IE.

Thanks so much kind sir. I'll give it a go.
Gardnr is offline   Reply With Quote
Old 09-24-2008, 09:27 AM   #14
Recycles dryer sheets
Canadian Grunt's Avatar
 
Join Date: May 2007
Location: Edmonton
Posts: 197
Quote:
Originally Posted by Gardnr View Post
Hey CFB or anybody. Don't let this die. I need to learn!

Thanks


I have a finance degree so I will attempt to explain rate of return and give some insight. There are several different formulas used for determining rate of return depending on the activity within the portfolio. This is the simplest formula to determine a return over one year. There is another if there are withdrawals.

Determining the static rate of return (average annual return or arithmetic mean) for a stock over 1 year:

((Return-Capital) / Capital)) x 100 = Rate of Return

Example ((110-100) /100)) x 100 = 10%


Now here is where you need to add some detail to your capital and return

Capital (initial cost): include your cost of transaction to buy and any load fees for mutual funds.

Return (end value): include dividends and subtract cost of sale if applicable.

If you make multiple deposits add all the deposits minus transaction fees for each deposit. There is actually a time value component but I wouldn’t worry about it for determining your return as you are seeking actual returns verses arithmetic returns which are different.
__________________
it's the journey that matters
Canadian Grunt is offline   Reply With Quote
Old 09-24-2008, 09:56 AM   #15
Recycles dryer sheets
Canadian Grunt's Avatar
 
Join Date: May 2007
Location: Edmonton
Posts: 197
If you want the Geometric mean (compound return) use this formula.



(capital/ return) ^ (1/n) -1

whereas ^ = power

n = number of years

Example: (investment with no growth over 2 years for simplicity)

(100/100) ^ (1/2) -1

(100/100) ^ .5 -1 = 0%

Remember do the calculations in brackets first, then multiply to the power (you need a financial calculator), and subtract 1.

Again for simplicity sake add cost of purchases over time to capital and add dividends to the return value.

I determine my returns by hand but you can set up a spread sheet for the formula above.
__________________
it's the journey that matters
Canadian Grunt is offline   Reply With Quote
Old 09-24-2008, 11:12 AM   #16
Thinks s/he gets paid by the post
jIMOh's Avatar
 
Join Date: Apr 2007
Location: west bloomfield MI
Posts: 2,223
Quote:
Originally Posted by Canadian Grunt View Post
I have a finance degree so I will attempt to explain rate of return and give some insight. There are several different formulas used for determining rate of return depending on the activity within the portfolio. This is the simplest formula to determine a return over one year. There is another if there are withdrawals.

Determining the static rate of return (average annual return or arithmetic mean) for a stock over 1 year:

((Return-Capital) / Capital)) x 100 = Rate of Return

Example ((110-100) /100)) x 100 = 10%


Now here is where you need to add some detail to your capital and return

Capital (initial cost): include your cost of transaction to buy and any load fees for mutual funds.

Return (end value): include dividends and subtract cost of sale if applicable.

If you make multiple deposits add all the deposits minus transaction fees for each deposit. There is actually a time value component but I wouldn’t worry about it for determining your return as you are seeking actual returns verses arithmetic returns which are different.
This is a good post with solid information.

I was dealing with this issue yesterday. One piece of advice is to measure your own annual return to verify you are tracking with your investments. I have numerous funds which pay dividends 4X per year, so making sure I know my end of year internal rate of return for those accounts is important to me.

A second question I have- is it worth knowing 3 yr, 5 yr and 10 yr trailing returns? Is the annual return calculation (end value-deposits/beginning value+withdraws) the same for 1 yr, 3 yr, 5yr and 10 yr periods?

Thx
__________________
Light travels faster than sound. That is why some people appear bright until you hear them speak. One person's stupidity is another person's job security.
jIMOh is offline   Reply With Quote
Old 09-24-2008, 12:16 PM   #17
Recycles dryer sheets
Canadian Grunt's Avatar
 
Join Date: May 2007
Location: Edmonton
Posts: 197
Quote:
Originally Posted by jIMOh View Post
This is a good post with solid information.

I was dealing with this issue yesterday. One piece of advice is to measure your own annual return to verify you are tracking with your investments. I have numerous funds which pay dividends 4X per year, so making sure I know my end of year internal rate of return for those accounts is important to me.

A second question I have- is it worth knowing 3 yr, 5 yr and 10 yr trailing returns? Is the annual return calculation (end value-deposits/beginning value+withdraws) the same for 1 yr, 3 yr, 5yr and 10 yr periods?

Thx

You require the one year static (annual return) return to compare apples to apples.

Example:

Isolate by asset allocation a the returns for a specific sector or an asset class in the portfolio. Don’t make the mistake of comparing financials (insurance stocks with bank stocks) with commodities (or mining stocks with oil stocks).

This is where the relevance comes in.

Using the annual return you can compare the returns within a sector so you can evaluate the overall performance of each stock relative to another in the sector (apples to apples).


You require geometric mean (annualized return or compound interest rate) to discover if your asset class and portfolio are meeting your expected return over a 3, 5, or 10 year time horizon. Note the term expected return; you can get this by examining historical returns for specific asset classes, sectors, and portfolios (depending on your asset mix), and by comparing with asset class information over the same time period.

A static one year return is not relevant for evaluating a portfolio or asset class return as you require at least 3 years of returns to compare historical rates of return, but 5 years is generally the minimum reliable timeframe.


Example:

Assuming a static dividend yield of 5% per year on a $100.00 investment over 4 years you would have year end capital as follows:

yr1) $105.00, yr2) $110.25, yr3) $115.76, yr4) $121.55

The four year compound return for a $21.55 profit is 5.4%

Note this is different from the 5% dividend yield.


All this assumes there is no capital appreciation for simplicity.
__________________
it's the journey that matters
Canadian Grunt is offline   Reply With Quote
Old 09-24-2008, 12:30 PM   #18
Thinks s/he gets paid by the post
jIMOh's Avatar
 
Join Date: Apr 2007
Location: west bloomfield MI
Posts: 2,223
Quote:
Originally Posted by Canadian Grunt View Post



Example:

Assuming a static dividend yield of 5% per year on a $100.00 investment over 4 years you would have year end capital as follows:

yr1) $105.00, yr2) $110.25, yr3) $115.76, yr4) $121.55

The four year compound return for a $21.55 profit is 5.4%

Note this is different from the 5% dividend yield.

What is the math which is $21.55=5.4% (average?) annual return?

Most of the comparisons I make are rate of return in Roth IRA year over year, 401k year over year, rollover year over year. Each of them has a similar allocation (no bonds in Roth, other allocations are similar). Most of my analysis is more macro/ big picture- is the allocation in each account giving me the year over year return I expect.

If I see one account with a 6% return one year, then 1% the next then 5% the next, and I am comparing that to another account which is 10%, -3% and 6% in same years, I need a way to analyze the average performance.

thx
__________________
Light travels faster than sound. That is why some people appear bright until you hear them speak. One person's stupidity is another person's job security.
jIMOh is offline   Reply With Quote
Old 09-24-2008, 01:07 PM   #19
Recycles dryer sheets
Canadian Grunt's Avatar
 
Join Date: May 2007
Location: Edmonton
Posts: 197
Quote:
Originally Posted by jIMOh View Post
What is the math which is $21.55=5.4% (average?) annual return?

Most of the comparisons I make are rate of return in Roth IRA year over year, 401k year over year, rollover year over year. Each of them has a similar allocation (no bonds in Roth, other allocations are similar). Most of my analysis is more macro/ big picture- is the allocation in each account giving me the year over year return I expect.

If I see one account with a 6% return one year, then 1% the next then 5% the next, and I am comparing that to another account which is 10%, -3% and 6% in same years, I need a way to analyze the average performance.

thx

Formula below.

(capital/return) ^ (1/n) -1


You need to examine your portfolio start numbers and end numbers and use the formulas above to determine your own rate of return.

If you are using ETF's or Mutual Fund published returns you likely will not receive the same rate of return as they advertise. Check it out.

The reason, they calculate their returns from a specific date to a specific date. If you invest during the middle and the fund or ETF goes up before or goes down after your investment date your rate of return will be significantly different.

This is the fundamental mistake most investors make so you need to determine your own rate of return independent of the rates published by funds.

As for accounts, you don't compare accounts. Find a return standard (comparable) such as the average return of a 50/50 portfolio of bonds and stocks or the S&P 500, Dow Jones Average etc. The information is out there for free if you look on the internet or you can ask your fund provider to provide comparables. Just make sure the comparables are relavent.
__________________
it's the journey that matters
Canadian Grunt is offline   Reply With Quote
Old 09-24-2008, 08:34 PM   #20
Recycles dryer sheets
Gardnr's Avatar
 
Join Date: Jul 2008
Location: ENE MO - near STL
Posts: 424
Quote:
Originally Posted by Canadian Grunt View Post
I have a finance degree so I will attempt to explain rate of return and give some insight. There are several different formulas used for determining rate of return depending on the activity within the portfolio. This is the simplest formula to determine a return over one year. There is another if there are withdrawals.

Determining the static rate of return (average annual return or arithmetic mean) for a stock over 1 year:

((Return-Capital) / Capital)) x 100 = Rate of Return

Example ((110-100) /100)) x 100 = 10%


Now here is where you need to add some detail to your capital and return

Capital (initial cost): include your cost of transaction to buy and any load fees for mutual funds.

Return (end value): include dividends and subtract cost of sale if applicable.

If you make multiple deposits add all the deposits minus transaction fees for each deposit. There is actually a time value component but I wouldn’t worry about it for determining your return as you are seeking actual returns verses arithmetic returns which are different.
I appreciate all this but I understand the difference between total return and price change. I was just trying to find out/figure out where to find good stock/fund charts that reflect total return vs. just price change.

I use the XIRR function in Excel to track annualized returns and an ROI formula to track YTD returns.

Thanks anyway!
Gardnr is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Total Bond Mkt Index vs PIMCO Total Return Inst/Stable Value Dude FIRE and Money 7 04-03-2008 12:11 AM
need help figuring out what to do? bosco Other topics 4 02-14-2008 09:30 PM
Figuring overall portfolio expense? hogtied FIRE and Money 3 01-07-2008 09:41 PM
figuring out that pesky SS number spncity FIRECalc support 3 03-04-2007 04:06 PM
Investors' actual returns versus total returns JohnEyles FIRE and Money 0 11-14-2006 12:20 AM

» Quick Links

 
All times are GMT -6. The time now is 03:54 PM.
 
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2024, vBulletin Solutions, Inc.