Provide Income Yield column in Portfolio

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.

Deluxe R49.33., Windows 10 Pro

2
2 votes

New · Last Updated

Comments

  • Jim_Harman
    Jim_Harman SuperUser ✭✭✭✭✭
    "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.
    QWin Premier subscription
  • leishirsute
    leishirsute Member ✭✭✭✭
    edited December 2020
    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

    Deluxe R49.33., Windows 10 Pro

  • Jim_Harman
    Jim_Harman SuperUser ✭✭✭✭✭
    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.

    QWin Premier subscription
  • leishirsute
    leishirsute Member ✭✭✭✭
    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?

    Deluxe R49.33., Windows 10 Pro

  • Jim_Harman
    Jim_Harman SuperUser ✭✭✭✭✭
    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.
    QWin Premier subscription
  • leishirsute
    leishirsute Member ✭✭✭✭
    edited December 2020
    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.


    Deluxe R49.33., Windows 10 Pro

  • Jim_Harman
    Jim_Harman SuperUser ✭✭✭✭✭
    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
    QWin Premier subscription
  • leishirsute
    leishirsute Member ✭✭✭✭
    Not requesting the same thing as estimated income.
    I am looking for a total distribution yield.

    Deluxe R49.33., Windows 10 Pro