Combined Dividend Yield Report?

[bluffan]

I'm looking for a way to track my portfiolio's combined dividend yield at any given point in time, as well as to track ex-dividend dates and pay dates for all holdings at once. Is this possible with Fund Manager?

[Mark]

Hi bluffan,

Yes. You can get the dividend yield in a "Custom" report. There is also an "Income Schedule" report, that shows all your scheduled income payments. Scheduled income payments are set for each investment under "Investment Properties... / Income".

[bluffan]

Thanks so much for the lightening-fast response! Would you be willing to post or forward instructions for creating a 'custom' report showing the combined dividend yield for the portfolio? I just tried creating a 'custom' report using the term "expected dividend yield (ending)", which delivered incomplete data and no total yield figure. It makes sense that if you know the price you bought each share for, you could calculate an annualized dividend yield for each component of the portfolio, then compute the annual dividend yield for the entire portfolio. In short, I want a forward-looking estimate of the annual dividend yield of the entire portfolio. Does that make sense?

[Mark]

Hi bluffan,

Sorry, I should have answered more carefully before. I took a closer look, and the dividend yield figures are not available for a portfolio. They are only available for investments or symbols.

I can see making the "Expected Dividend Yield" available for a portfolio, by calculating all the expected dividend yield values for each investment, and then weighting them by value to get the total portfolio expected dividend yield. We'll see about adding this for a future release. Thanks for the feedback.

If you really wanted this figure, you could do it yourself in Excel by creating a Custom report with end value, and expected dividend yield, and then saving the report to a CSV file, and finishing the math in Excel. See "File / Export to CSV..." from within any report. To get the expected dividend yield figure to report non-zero you must have at least one dividend recorded within the last year. Even if you didn't own any shares as of the last dividend date you can still record it at a value of $0, and Fund Manager will prompt you for the distribution per share amount to use in calculations such as this.