Thursday, 12 January 2017

66. Half monthly dividend forecast January 2017

Having pulled together a perfectly functioning dividend tracker sheet for the year 2017, I can finally sleep again. Really I have had a few nights of bad sleep just because my brain was fried with Excel and Google Spreadsheets formulas. Lucky for me, I have some real good examples from colleague-bloggers/investors.


Where it is not worth it to reinvent the wheel when good stuff already exists the basic layout I could borrow from the examples. My trading package spits out a few lines of excel when I ask for an export, but this firstly requires processing in order to be able to work in accounting formulas. E.g. the amounts of shares are in the same cells as the share names etc.

Think challenges, but don’t forget real problems.

Let Excel do the stripping of my data. In the meantime I have worked towards a sheet that calculates:
  1. My year overview;
  2. A monthly overview for 2x variables: [ year] and [month] for in case I want to look back on something;
  3. A sheet that provides my half monthly forecast;
  4. A database that keeps track of all of my earnings;
  5. A full historic overview of earnings since I started using this particular investment package.

On top of all of this:

USD Stocks paying dividends this month


Description
Shares in portfolio
Dividends per share (in native currency)
dividends subtotal (in EUR)
Chimera Investment Corp. cash div.
313
$ 0,50
149,01
Dreyfus High Yield Strategies Fund cash div.
190
$ 0,03
5,43
Dynex Capital Inc. cash div.
60
$ 0,21
12,00
ETRACS Monthly Pay 2x Lev Cl-End ETF cash div.
60
$ 0,3709
21,19
Etracs Monthly Pay 2xL WF MLP Ex-Energy cash div.
10
$ 0,0187
0,18
ETRACS Monthly Pay 2xLev Mortg REIT ETN cash div.
145
$ 0,7375
101,82
Five Oaks Investment Corp cash div.
35
$ 0,05
1,67
New York Mortgage Trust Inc. cash div.
206
$ 0,24
47,07
Prospect Capital Corp cash div.
220
$ 0,09
18,85
Realty Income cash div.
10
$ 0,21
2,00
Western Asset Mortgage Capital Corp cash div.
42
$ 0,31
12,40
Forecast:
371,62