Expected annual income

[crawfordn]

Hi Mark,
I've noticed that the expected annual yield feature has a little trouble identifying and annualizing income (dividends and interest). It might make sense at some point to add a field in the security file (that is updateable for all holdings with the same symbol) for annual income per unit. This would allow reports with per holding annual income projections, with totals as well.

[Mark]

Hi crawfordn,

Which 'expected annual yield' feature are you seeing problems with? Is this some field in a report?

[crawfordn]

I was playing with "expected dividend yield (ending)" in a custom report, and it seemed to pick up most distributions and annualize them. It also clearly doesn't reflect future dividends of a holding that was recently purchased and hasn't paid yet. What I'd like to be able to report is just a $ figure for projected annual income, both per share and per holding. Thanks, Rick

[Mark]

Hi Rick,

Ah, yes (I forgot about that field...). Yes, that field won't work if you don't have any distributions recorded yet, or only 1 and the distributions aren't quarterly. I can see why you'd want a way to just specify this. FYI, here is the way that custom field is calculated:

Code: Select all

Annualized dividend yield expected to be earned in the future.  Calculation is based on the ending share price, the last received dividend amount, and frequency of prior dividends.  Possible frequencies are 1 year, semi-annually, quarterly, or monthly.  Defaults to quarterly if only a single dividend is recorded.  The value is a percentage.