Distribution Yield

by **Ivan** » Wed Jul 06, 2011 4:12 pm

I back enter prices and distributions into FM to look at possible stocks and funds and would like to have FM calculate distribution yield. The Distribution Summary Report appears only to show data for distributions that have been reinvested. Is it possible to get distribution yield for back entered data where I do not own any shares?

Thanks,
Ivan

by **Mark** » Wed Jul 06, 2011 5:37 pm

Hi Ivan,

Yes, but when you enter the distribution you should be prompted for a "Distribution Per Share" amount, since you don't own any shares. This distribution per share amount will be used in the Dividend Yield calculation. If you press the "Help / Help on Report..." command while viewing the Distribution Summary report you can see the equation used for this field.

by **Ivan** » Wed Jul 06, 2011 6:01 pm

Hi Mark,

I must be doing something wrong or misunderstanding. The report works for me for the funds I own, but on the ones where I have back entered data it comes up empty. I have Prices and Distributions/Share entered for the period covered by the report for the back entered funds.

by **Mark** » Wed Jul 06, 2011 6:08 pm

Hi Ivan,

If you look at the distributions in the Data Register under the "Distributions (all)" data type, are they categorized as "Dividends", and do they have a value for "Dist/Shr"?

If this doesn't help, maybe you can email me the investment file, and a date range of the report.

by **Ivan** » Wed Jul 06, 2011 6:36 pm

Hi again Mark,

Yes, they are listed as "Dividends" and have a value for "Dist/Shr". How do I email you the investment file?

by **Mark** » Wed Jul 06, 2011 6:42 pm

You can find the filename under "Investment Properties... / Statistics".

by **Ivan** » Wed Jul 06, 2011 6:52 pm

Hi Mark,

I know how to find the file. What email address do I send it to?

Ivan

by **Mark** » Wed Jul 06, 2011 6:54 pm

Hi Ivan,

I've just sent you an email. You can reply to that.

by **Mark** » Wed Jul 06, 2011 7:01 pm

Hi Ivan,

Is the problem that you aren't seeing the line item? I misunderstood the problem. I thought you were seeing it, but it was reporting as 0. Try turning off the option "Options / Report Preferences... / Distribution Summary / Do Not Display Line Items With No Distributions". It is being automatically hidden since you have 0 received distributions, since you own 0 shares.

by **Ivan** » Wed Jul 06, 2011 10:05 pm

Mark,

Yes, the problem is that I am not seeing any line item. But I turned off the "Do Not Display Line Items With No Distributions" option as you suggest (it was on) and it didn't help. I still have no line showing.

Ivan

by **Mark** » Wed Jul 06, 2011 11:05 pm

Hi Ivan,

Since you don't own any shares, you would either need to turn on "View / Hidden Investments/Portfolios", or set the option under "Options / Report Preferences... / General / Do Not Display Investments With Zero Share Balance" to "Never".

by **Ivan** » Thu Jul 07, 2011 9:00 am

That fixed it.

Thanks Mark

by **Ivan** » Thu Jul 07, 2011 9:37 am

Hi Mark,

One more question on the Distribution Summary Report. I notice that the "Div Yield" gives the yield only for dividends, not Capital Gains, Interest Income, etc. Is there a way to get a "Distribution Yield" that includes all distributions?

by **Mark** » Thu Jul 07, 2011 9:43 am

Hi Ivan,

There isn't any such field as "Distribution Yield". You can get a TWR yield, which includes all distributions, but it also includes pricing changes.

Distribution Yield

Who is online