Just last week I introduced my 2014 Dividend Calendar, a new spreadsheet and page shared to show in a snapshot the dividends I’ve earned, and the dividends I am projecting to earn for the calendar year. It will be rolled forward each year and allow me a nice visual snapshot of each year’s activity, from purchases to dividend increases, and even when I sell a position. Be sure to go check it out and let me know what you think. After loving that little project, I decided to revamp my dividend growth portfolio with Google Docs in a similar manner, as I was getting tired of manually updating tables. Plus, as my portfolio grows, it is harder and harder to see in a snapshot what my portfolio looks like when you have to scroll for days. Just not an effective use of my screen or yours!
The Dividend Growth Portfolio… Revamped
When designing the new dividend growth portfolio spreadsheet, I knew I wanted to present the information in a quick and easy method to allow people to see my investments and what accounts each is held. As I continue to build my no-cost portfolio with Loyal3, being able to show that subset on its own is important. Likewise, knowing which accounts are taxable and easily accessible for early retirement versus those which are tax-deferred is another distinction I find important. All of those details have been taken into consideration and the end result is as follows.
Tab One: ‘DG Holdings’ – Positions, Weights, and Values
The first tab on the spreadsheet, ‘DG Holdings’, is where you can find all of my positions, organized by the account in which they are held. As you can see in the picture above, the following information is included under the headers shown above.
- Overall cost basis, inclusive of reinvestments and additional purchases of a position
- Fair market value (FMV), pulled from Google Finance
- The relative weight of each position, portfolio and account type in relation to my overall portfolio’s value across all accounts
- Gain/Loss of my positions in both dollars and as a percentage of the cost basis
Tab Two: ‘DG Forward Dividends’ – Dividend, Current Yield and Yield on Cost
The second tab on the spreadsheet, ‘DG Forward Dividends’, is designed to show my forward 12-month dividends by position, account, and tax type. Using the same organization as the first tab, the second tab includes all of the information shown in the headers above.
- Dividend Payment is the dividend paid by each position per period. Some of my positions are monthly and the rest are quarterly
- The annual dividend is the projected forward 12-month dividends annualized based on the number of shares and current dividend rate.
- Current yield is the forward 12-month dividends divided by the fair market value of each position. This shows my yield if I were to invest an equal amount of money to my current value at today’s prices.
- Yield on Cost (YOC) is an important metric in the dividend growth community that will grow over time as each position increases their dividends paid.
With that in mind, be sure to jump over to dividend growth portfolio page and check out the new spreadsheet. I will be keeping this spreadsheet updated throughout a month much like my dividend calendar.
Given my latest addition to my online portfolio tracking, what are your thoughts? Do you like this layout better than what I had previously? Let me know!
Flickr: Mark Stevens