Scott’s Portfolio

I’ve included my current and up-to-date portfolio below. If you scroll to the bottom of the spreadsheet you will see a number of tabs. These have more detailed information showing monthly/yearly dividend information, a dividend calendar, and a transactions sheet, among other things.

To use a similar spreadsheet for your own blog, please visit the information page here.

Please visit my option’s page to see currently open options positions.

Total 2015 Dividends

  • $4,303.67 or $358.64/month
  • Dividend Growth Year-Over-Year: 82.5%
  • Total 2014 Dividends

  • $2,357.66 or $196.47/month
  • Dividend Growth Year-Over-Year: 108.3%
  • Weighted-Dividend Average (as of 12/31/2014): 2.83%
  • Yield-on-cost (as of 12/31/2013): 4.27%
  • Total 2013 Dividends

  • $1132.01 or $94.33/month
  • Dividend Growth Year-Over-Year: 74.3%
  • Weighted-Dividend Average (as of 12/31/2013): 2.81%
  • Total 2012 Dividends

  • $649.30 or $54.11/month
  • Dividend Growth Year-Over-Year: 71.26%
  • Weighted-Dividend Average (as of 1/2/2013): 2.77%
  • Total 2011 Dividends

  • $379.14 or $31.60/month
  • Dividend Growth Year-Over-Year: NA
  • 9 Responses

    1. Mike says:

      Nice! Thanks for sharing Scott! Excellent website!

    2. David says:

      Great spreadsheet. I have a question: why are you including income from dividends in your XIRR calculations? I’d understood that XIRR should only capture flows in or out of the portfolio, and not those that are generated within the portfolio (such as a dividend). Grateful for your thoughts.

      • scott says:

        Hey David, Dividends technically are distributed as cash and then I choose to reinvest them back into the company it came from. If I receive a $100 dividend, that would be the same as transferring $100 from my checking account into my brokerage account. So, I include only the dividends that I reinvest in the XIRR calculation. If I take the dividends and hold them as cash, it wouldn’t be incorporated into the calculation until used to purchase more stock. Thanks for visiting! Scott

    3. David says:

      Thanks for your reply! I’m still getting my head around XIRR. But, if you are treating reinvested dividends in your XIRR calculation as new inflows, shouldn’t you also record them as withdrawals too? Otherwise your calculated returns risk being lower given you haven’t “scored” the fact that your investments have generated dividend income.

      As I say I am still working out how to apply XIRR – I ask since I’ve been using lots of elements from your spreadsheet, esp. the XIRR formula.

      • scott says:

        Hey David,

        I’ve reviewed a few sites, including an excellent post on The White Coat Investor specifically regarding XIRR and dividends, it does appear that you are correct in that dividends should not be recorded unless withdrawn as cash. The value of the dividend is factored in already with the value of the stock.

        I’ll have to take a look at my implementation of the XIRR formula and make sure that I’m doing it correctly.

        Thanks for bringing this to my attention!

    4. Stalflare says:

      Ciao Scott,
      Just stumbled onto your page via a common contact (Option Hunting), I was wondering if I could be added to your blogroll (I am about to add your pages). I am impressed with the resources that you are pulling here, especially the spreadsheet work is stunning. Of course returns on the strategy too. We trade in a similar way (options and dividends) so from today you’ve got a new follower!
      Ciao ciao
      Stal

      • scott says:

        Ciao Stal, thanks for commenting! I’m definitely interested in following bloggers that invest for dividends and options. I’ll be get back home later this evening and I’ll add your site to my blogroll then.

        Scott

    5. All i have to say is WOW AAPL! Sounds like you have been holding on to that for a few years and reaped the benefits of some stock splits. A 46% YOC is amazing. Great looking portfolio. Keep up the good work.
      Dividend Daze recently posted…Checklist for Year EndMy Profile

    Leave a Reply

    Your email address will not be published. Required fields are marked *

    CommentLuv badge