Join Early Retirement Today
Reply
 
Thread Tools Display Modes
Dividend & Interest Calculation - how to
Old 09-27-2016, 11:27 AM   #1
Recycles dryer sheets
 
Join Date: Apr 2012
Posts: 184
Dividend & Interest Calculation - how to

So this may seem simplistic ... I'm REing in the next couple of months and need to change my holdings so that dividends and interest are no longer reinvested, but distributed to me as part of our income. I've never done this and I'm not sure how to calculate what that income 'might' be to help in projecting income sources starting next year. I understand that future dividends/interest may not be the same as current rates.

I have VG Total Stock Market Index Fund, so do I just take the number of shares and multiply by the dividend distribution for that quarter? This should be what I could have available as income ... right?

Bond funds: Value of the investment multiplied by the rate of return? Is interest available yearly, or as needed during the year based on performance to date?

I feel a bit like an idiot for asking ...
Steelart99 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-27-2016, 11:37 AM   #2
Thinks s/he gets paid by the post
 
Join Date: Jan 2014
Posts: 1,760
I've got a small Vanguard IRA rollover. If you go to "my accounts" then "transaction history" all your account activity is listed. You can break out dividends and interest only, too. Goes back 10 years if you want. Is that what you mean?
splitwdw is offline   Reply With Quote
Old 09-27-2016, 11:47 AM   #3
Thinks s/he gets paid by the post
MooreBonds's Avatar
 
Join Date: Aug 2004
Location: St. Louis
Posts: 2,179
Quote:
Originally Posted by Steelart99 View Post
So this may seem simplistic ... I'm REing in the next couple of months and need to change my holdings so that dividends and interest are no longer reinvested, but distributed to me as part of our income. I've never done this and I'm not sure how to calculate what that income 'might' be to help in projecting income sources starting next year. I understand that future dividends/interest may not be the same as current rates.

I have VG Total Stock Market Index Fund, so do I just take the number of shares and multiply by the dividend distribution for that quarter? This should be what I could have available as income ... right?

Bond funds: Value of the investment multiplied by the rate of return? Is interest available yearly, or as needed during the year based on performance to date?
You have to be careful when dealing with ETFs/CEFs - they dont' always distribute the same each quarter! Not only are there sometimes end-of-year distributions of capital gains, but even the March/June/Sept quarters can vary in distribution, based on the specific fund's policy, and the companies in their indexes (for example, in Europe, it's common to have just 2 distributions a year by many companies).

I love my spreadsheets and have tons of them, so I maintain my portfolio and update the current dividends every 4-6 months. If you don't have a ton of positions, and if you truly want an accurate take on what is 'likely regular dividend' versus capital gain distributions, look at each fund's tax composition. Those qualified dividends will likely be recurring each year, and slowly growing.

However, keep in mind that ETFs distributing short-term capital gains tag them as "non-qualified dividends", so just simply taking the fund's annual dividend distribution may not be accurate, since short-term capital gains are not nearly as 'regular' as regular quarterly/semi-annual dividends. So in a fund's tax summary, I'd suggest looking for last year's qualified dividend total for the year, and then using that as your expectation for each year.

Even looking at a site like Yahoo or even Vanguard's page for that fund is oftentimes not enough, since they usually don't break it down to that degree. You'd have to look at each sponsor's annual tax summary, which lists each fund they have. So while it might take a tiny bit of searching for a few sponsors, once you have that .pdf, it's not much effort to hit "Control-F" to search for the fund's symbol, then see what it's qualified dividends were for 2015.

And with Bond funds - be wary of return-of-capital distributions. If their income isn't enough to sustain the dividend and they are relying on return of capital, your distribution may be under pressure and may be cut in the future.
__________________
Dryer sheets Schmyer sheets
MooreBonds is offline   Reply With Quote
Old 09-27-2016, 11:48 AM   #4
Recycles dryer sheets
 
Join Date: Apr 2012
Posts: 184
Quote:
Originally Posted by splitwdw View Post
I've got a small Vanguard IRA rollover. If you go to "my accounts" then "transaction history" all your account activity is listed. You can break out dividends and interest only, too. Goes back 10 years if you want. Is that what you mean?
Actually, I was just looking for inputs needed to make the calculation for projected future income from dividends and interest. So, yes you are correct; I see the same info that you pointed out ... which does answer the question I had about dividends. I'm still not sure about the interest income. Thanks
Steelart99 is offline   Reply With Quote
Old 09-27-2016, 11:52 AM   #5
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: Jun 2005
Posts: 10,252
For mutual funds, you can just look at the fund web site for the most recent distributions per share and do the calculations. That goes for equity funds like VTSAX/ VTSMX and for bond funds like VBTLX / VBMFX.

Perhaps the only gotcha is that many (but not all) bond funds pay dividends every month while many (but not all) stock funds pay dividends every quarter.

I have found that the December distributions are usually higher than the other months because sometimes there are year-end capital gains.

BTW, you don't need to use the fund web site to get this info. Your browser probably has a search function attached to it such as google, so you can type in something like "VTSAX dividends" and see that one of the top hits will show the dividend.

As already noted, your statements (or your online account) will show the dividends paid, too, whether reinvested or sent to your checking account.

I don't use the "yield" from a bond fund, but look at ACTUAL monthly per share payments. You can see how they vary and are not constant.
LOL! is offline   Reply With Quote
Old 09-27-2016, 11:54 AM   #6
Recycles dryer sheets
 
Join Date: Apr 2012
Posts: 184
Quote:
Originally Posted by MooreBonds View Post
You have to be careful when dealing with ETFs/CEFs - they dont' always distribute the same each quarter! Not only are there sometimes end-of-year distributions of capital gains, but even the March/June/Sept quarters can vary in distribution, based on the specific fund's policy, and the companies in their indexes (for example, in Europe, it's common to have just 2 distributions a year by many companies).

I love my spreadsheets and have tons of them, so I maintain my portfolio and update the current dividends every 4-6 months. If you don't have a ton of positions, and if you truly want an accurate take on what is 'likely regular dividend' versus capital gain distributions, look at each fund's tax composition. Those qualified dividends will likely be recurring each year, and slowly growing.

However, keep in mind that ETFs distributing short-term capital gains tag them as "non-qualified dividends", so just simply taking the fund's annual dividend distribution may not be accurate, since short-term capital gains are not nearly as 'regular' as regular quarterly/semi-annual dividends. So in a fund's tax summary, I'd suggest looking for last year's qualified dividend total for the year, and then using that as your expectation for each year.

Even looking at a site like Yahoo or even Vanguard's page for that fund is oftentimes not enough, since they usually don't break it down to that degree. You'd have to look at each sponsor's annual tax summary, which lists each fund they have. So while it might take a tiny bit of searching for a few sponsors, once you have that .pdf, it's not much effort to hit "Control-F" to search for the fund's symbol, then see what it's qualified dividends were for 2015.

And with Bond funds - be wary of return-of-capital distributions. If their income isn't enough to sustain the dividend and they are relying on return of capital, your distribution may be under pressure and may be cut in the future.

WHAT!!! I'm not the only one with tons of spreadsheets!!!

I've not been tracking the various dividend / interest distributions, just letting them roll over as reinvestments. So, your point is taken that I just need to lay out the funds and the various dividends (qualified and non-qualified), interest and CGs. Should provide a reasonable projection of future income assuming I grab the right info.

Thanks
Steelart99 is offline   Reply With Quote
Old 09-27-2016, 11:58 AM   #7
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: Jun 2005
Posts: 10,252
I don't do spreadsheets, but I have the free MS Money that can generate reports over any time period for distributions paid to me. Easier than a spreadsheet and much more versatile.
LOL! is offline   Reply With Quote
Old 09-27-2016, 02:42 PM   #8
Recycles dryer sheets
 
Join Date: Apr 2012
Posts: 184
Quote:
Originally Posted by LOL! View Post
I don't do spreadsheets, but I have the free MS Money that can generate reports over any time period for distributions paid to me. Easier than a spreadsheet and much more versatile.
I've never used MS Money ... gonna have to go find my free copy
Steelart99 is offline   Reply With Quote
Old 09-27-2016, 05:38 PM   #9
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
pb4uski's Avatar
 
Join Date: Nov 2010
Location: Sarasota, FL & Vermont
Posts: 36,204
Why not just look at what they distributed in 2015 or for the last 12 months as a reasonable approximation? Should be able to get it from your brokerage statements or tax return. Only difference is that you'll now be taking them in cash rather than reinvesting.
__________________
If something cannot endure laughter.... it cannot endure.
Patience is the art of concealing your impatience.
Slow and steady wins the race.

Retired Jan 2012 at age 56
pb4uski is offline   Reply With Quote
Old 09-27-2016, 05:47 PM   #10
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
Sunset's Avatar
 
Join Date: Jul 2014
Location: Spending the Kids Inheritance and living in Chicago
Posts: 16,973
Quote:
Originally Posted by pb4uski View Post
Why not just look at what they distributed in 2015 or for the last 12 months as a reasonable approximation? Should be able to get it from your brokerage statements or tax return. Only difference is that you'll now be taking them in cash rather than reinvesting.

+1
Especially since the economic situation of the companies/country will be different than right now, so all you are going to get is an approximation.
Sunset is offline   Reply With Quote
Old 09-27-2016, 10:23 PM   #11
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: Nov 2009
Posts: 6,679
The mutual fund company's website will have monthly dividends per share going back a few months. However, you can call them up, as I did years ago when I was building a longer history, to get several years of monthly dividends per share. I have found that the daily price (NAV) of a bond fund doesn't matter much when predicting future dividend income, only the monthly DPS and the number of shares I own. I have been doing this since I ERed 8 years ago.
__________________
Retired in late 2008 at age 45. Cashed in company stock, bought a lot of shares in a big bond fund and am living nicely off its dividends. IRA, SS, and a pension await me at age 60 and later. No kids, no debts.

"I want my money working for me instead of me working for my money!"
scrabbler1 is offline   Reply With Quote
Old 09-27-2016, 10:58 PM   #12
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: May 2005
Posts: 17,194
I do not know about others, but in Vanguard you can go to My Accounts - Dividends and Capital Gains...

It lists all for YTD and last year when you make the selection... and below it gives the amounts by account....



What I did was change my investment options to have all of them invested in my ST bond fund.... and I just take money out of that for spending... at times it gets low and I sell a fund to fill it back up...
Texas Proud is offline   Reply With Quote
Old 09-28-2016, 03:44 AM   #13
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: Jul 2005
Posts: 6,098
our fund distributions run between 29k and 69k in any given year . we do not live off that flow directly . we accumulate it in a bucket for the following years spending .

when the fund distributions vary so much it becomes a hassle to make up shortfalls on the fly . we find we are better off keeping the current year funded in cash and fill up the 2nd year where we have time to think about how we want to fill short falls
mathjak107 is offline   Reply With Quote
Old 09-28-2016, 04:09 AM   #14
Recycles dryer sheets
 
Join Date: Dec 2012
Posts: 335
I like this dividend calculator. Divicalc - a dead simple dividend and return calculator.
davismills is offline   Reply With Quote
Old 09-28-2016, 04:24 AM   #15
Recycles dryer sheets
 
Join Date: Apr 2012
Posts: 184
Quote:
Originally Posted by davismills View Post
I like this calculator! Thanks
Steelart99 is offline   Reply With Quote
Old 09-28-2016, 04:26 AM   #16
Recycles dryer sheets
 
Join Date: Apr 2012
Posts: 184
Quote:
Originally Posted by scrabbler1 View Post
The mutual fund company's website will have monthly dividends per share going back a few months. However, you can call them up, as I did years ago when I was building a longer history, to get several years of monthly dividends per share. I have found that the daily price (NAV) of a bond fund doesn't matter much when predicting future dividend income, only the monthly DPS and the number of shares I own. I have been doing this since I ERed 8 years ago.

I could get the performance from my VG accounts, but I have company 401K funds that don't provide the dividend performance on-line and there is no fund 'symbol' to look up. It seems like I may have to ping them directly to try to get the past performance. Thanks
Steelart99 is offline   Reply With Quote
Old 10-02-2016, 03:44 PM   #17
Thinks s/he gets paid by the post
MooreBonds's Avatar
 
Join Date: Aug 2004
Location: St. Louis
Posts: 2,179
Quote:
Originally Posted by Steelart99 View Post
I could get the performance from my VG accounts, but I have company 401K funds that don't provide the dividend performance on-line and there is no fund 'symbol' to look up. It seems like I may have to ping them directly to try to get the past performance. Thanks
Since you are a fellow spreadsheet addict, you should be willing to consider this work-around: look at the top-10 holdings (or top 20/30 holdings) of those 401k funds, if they constitute, say, 30%-60% of the fund. If it's a hugely diversified fund, it may not be possible, but if just 10-30 stocks make up a majority of the assets, simply make your own estimate of the annual recurring dividends by entering those 10-30 symbols into a spreadsheet, and compute your own estimate of the annual distributions based on the top 10-30 symbols' annual distributions...which should approximate a good % of the total fund. Then, just apply a reasonable, conservative estimate of yield of the remaining % holdings in that 401k fund (I'd assume maybe a 1%-1.5% average yield of the remaining stocks, as long as it's not something like a tech fund or some other sector that doesn't pay a high average level of dividends).
__________________
Dryer sheets Schmyer sheets
MooreBonds is offline   Reply With Quote
Old 10-02-2016, 04:55 PM   #18
Recycles dryer sheets
 
Join Date: Apr 2012
Posts: 184
Quote:
Originally Posted by MooreBonds View Post
Since you are a fellow spreadsheet addict, you should be willing to consider this work-around: look at the top-10 holdings (or top 20/30 holdings) of those 401k funds, if they constitute, say, 30%-60% of the fund. If it's a hugely diversified fund, it may not be possible, but if just 10-30 stocks make up a majority of the assets, simply make your own estimate of the annual recurring dividends by entering those 10-30 symbols into a spreadsheet, and compute your own estimate of the annual distributions based on the top 10-30 symbols' annual distributions...which should approximate a good % of the total fund. Then, just apply a reasonable, conservative estimate of yield of the remaining % holdings in that 401k fund (I'd assume maybe a 1%-1.5% average yield of the remaining stocks, as long as it's not something like a tech fund or some other sector that doesn't pay a high average level of dividends).

Hmmmm... that sounds like a good plan! Thanks
Steelart99 is offline   Reply With Quote
Old 10-03-2016, 03:34 AM   #19
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
target2019's Avatar
 
Join Date: Dec 2008
Location: On a hill in the Pine Barrens
Posts: 9,669
Quote:
Originally Posted by Steelart99 View Post
I could get the performance from my VG accounts, but I have company 401K funds that don't provide the dividend performance on-line and there is no fund 'symbol' to look up. It seems like I may have to ping them directly to try to get the past performance. Thanks
The 401k funds may not distribute dividends directly. At least mine don't.

You can use a proxy symbol for the investment, and look that up on Divicalc, etc. Then estimate the yearly dividend, and withdraw a similar amount.
target2019 is offline   Reply With Quote
Old 10-03-2016, 06:58 AM   #20
Thinks s/he gets paid by the post
RetireAge50's Avatar
 
Join Date: Aug 2013
Posts: 1,659
Why not just let them continue to be reinvested and then just withdraw as needed (but selling shares)?
RetireAge50 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
Noticed more people holding signs "need work or food" rayinpenn Other topics 3 05-03-2015 02:51 PM
Mortgages: Interest Calculation/Recalculation catccc FIRE and Money 52 10-02-2012 12:18 PM
Trouble understanding I Bond interest calculation Tom52 FIRE and Money 2 07-09-2011 03:53 PM
Ultimate Dividend Playbook; Dividend Harvest Portfolio FUEGO FIRE and Money 22 08-12-2008 11:16 AM
iBond Interest Calculation - help! Maurice FIRE and Money 2 12-07-2007 02:39 PM

» Quick Links

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