Provide Income Yield column in Portfolio

leishirsute

Quicken provides an Income and Income % column but it would be good to have an "annual" Income Yield column.  Quicken provides a dividend yield column but that doesn't include all income such as capital gains distributions or bond interest.

Jim_Harman

"Yield" does not normally include other distributions like capital gains. It sounds like you are looking for total distributions.

You might want to try the Investment Income report.

leishirsute

Investment Income Report does not give yield.
The Investment Performance report gives Avg. Annual Return but that includes share value as well as distributions.
Maybe the request should be for a Total Distribution Avg. Annual Yield

Jim_Harman

The Avg. Annual Return is the Internal Rate of Return (IRR), which has a well defined method of calculation.

I assume this Avg. Annual Yield would also be expressed as a percentage.  How do you think it should be calculated if it does not include changes in the share price and presumably not purchases or sales?

You  *might* be able to remove the impact of share price changes by temporarily setting the ending share price the same as the beginning price, and then using the Investment Performance report.

leishirsute

I am seeking the  value of (all distributions (income) / investment market value) in order to get a sense of the estimated income rate from an investment.
How is that accomplished in Quicken without having to change share price of each investment?

Jim_Harman

Personally I would not count capital gains distributions as income.

I don't think an actively managed mutual fund that throws off a lot of capital gains distributions is better than an index fund, which typically does very little trading and thus retains its capital gains. With the index fund, you only pay capital gains when you sell.

Also if you bought or sold shares during the year, distributions / market value would give a distorted view of your "income rate"

That said, you can get the total distributions by account or by security from the investment income report. You can divide that by the market value from the Account Balances report to get the number you are looking for.

Another approach using the Portfolio views is for each of your securities, go to the Security Detail view > Edit details > other info and enter your estimate of the annual distributions per share, including CG distributions if you want. This sounds tedious but it is not bad if you don't have too many securities.  This will populate the Estimated income and Yield on Investment (estimated) columns. 

Note that the Yield on Investment is Estimated Income / Amount Invested. You should study Quicken's definition of Amount Invested and the related discussions on this forum to see if this is what you want.

leishirsute

Thanks for the suggestions.  I was hoping to have the program estimate for me rather than have to do estimate for the program.
For me in retirement, capital gains distributions, dividends and interest are all income.  All are considered to be income for tax purposes as well.

Jim_Harman

If you would like to see Quicken make improvements in the Estimated Income, please review, comment, and vote on the produce idea here
https://community.quicken.com/discussion/7878263/why-doesnt-q-calculate-estimated-income

leishirsute

Not requesting the same thing as estimated income.
I am looking for a total distribution yield.