Finally, I was able to finish my DGI (dividend growth investment) portfolio tracker in Google spreadsheet.
There are many other fellow investors out there who use Excel or Google Spreadsheet to track their portfolios and when I browsed the internet to find inspiration and knowledge on how to automate my portfolio tracker so I can analyze my portfolio without having it updating manually I came across many great web sites and blogs.
I consider myself a spreadsheet geek who loves to create a plenty of spreadsheet to gain all sorts of possible point of views to see the portfolio from different angles. Of course, in the past I overdone that and since many of my tracking spreadsheets required manual update soon it became tedious and boring work.
So I scratched it all and decided to start over.
I found a great inspiration out there in the blogosphere. A great source of all sorts of spreadsheets to track and analyze your dividend portfolio comes from Scott and his Two Investing blog. He says that he got an inspiration from my calendar page but for sure, he uplifted those spreadsheets into perfection. Definitely, you must check his spreadsheets out.
I also found a good inspiration at No More Waffles and his spreadsheets, I liked the currency tracker since the investor is from Belgium and thus invest in different currencies. I liked his sector charts as they ended up really better indicating what sector goes over the roof in your portfolio and which sectors are underinvested. If you use a pie, you end up with a nice colored circle, but that won’t help much in my opinion.
And of course a good resource to creating my spreadsheet was The Dividend Meter with a pretty cool way of visualizing your dividend progress.
But what inspired me the most was a discussion with a dividend investing blogger about his model portfolio and how the stocks in that portfolio would do in the future. The discussion went on about to see what the entire portfolio would do.
And because I am an old man and I forget everything I now do not remember who that blogger was and what actually we were talking about in details. But one thing inspired me, and it was an idea of creating metrics so you can evaluate the entire portfolio and based on that you can predict the future size of that portfolio and what dividends you would probably receive.
So I created my spreadsheet as shown above this post.
What’s exciting here is that all data which are in yellowish cells are automatically updated. Only the blue cells are those I have to insert manually and I am fine with that. It is only the number of line (also showing how many individual stocks I hold), stock symbol, quantity and trade price. These numbers need to be uploaded from my broker’s account manually and I am OK with that as of now. Everything else uses formulas from either Google finance or Yahoo.
What I consider great with this spreadsheet is that now I can see what my entire portfolio does as far as dividend income and dividend growth!
As you can see, my entire portfolio yield on cost (YOC) is 7.23% and my entire portfolio dividend growth is 7.73%.
Of course, all this will change since for example my KMI dividend yield hasn’t been updated yet to the new cut dividend, same goes with LGCY distribution suspension, but that is OK as I have enough data to calculate my portfolio future.
I can now use the existing data and once the new data come in (once Yahoo updates them) I will be able to recalculate the new portfolio future.
And what is my portfolio future?
Here is my future YOC and Income if I reinvest dividends (with no further contributions):
|Year||Income||Yield on Cost||Holdings Value|
As you can see, if you start investing as early as you can, even small money, your account will grow into a big money making machine and you will be literally able to retire in 20 years.
It is not the value of your portfolio but income it can generate. My portfolio, unless something disastrous happens, will be able to grow my yield to the original cost to a whopping 435.77% in 20 years!
Today, I started with $17,592.38 portfolio and I will end up with $334,325.58 for a total gain of a whopping 1,800.40%. Over 20 years of my portfolio life that will make my average annual gain 90.02%.
Of course, this doesn’t take into account any future contributions which will increase all numbers faster. Let’s see how this portfolio will do over time. At least, today I have created a baseline to my portfolio.