Income by Security report - show basis of each security and compute % by that [Edited]

Options
wtsmith71
wtsmith71 Member
edited March 23 in Reports

It would be more meaningful if the report would show the basis of each security (the amount invested in it) instead of (or in addition to) its current market value. Then compute the % income using the basis instead of the current market value. This would make it a much more meaningful tool for the purpose of evaluating the actual income-generating performance of the income-focused components of a buy-and-hold-oriented portfolio.

To elaborate: when you have allocated a certain percentage of your portfolio to long term income generation (and safety) then what you are interested in, for purposes of periodically reviewing and making adjustments, is how those securities have performed in terms of generating income as a percentage of what you allocated to them (and what you are not so interested in, is how they have performed from a market value/price perspective).

And to that end it would also be useful if, for the time period selected for the report, it could show not only the income but also the applicable basis for any securities that were fully or partially sold some time during that reporting period. For example, suppose I run the report for a period of one year and during that year I had sold one half of my holdings in a particular security. The result (in the current design of the report) is to show the total income the security generated during the period, and the market value of my holdings of the security at the end of the reporting period, thus (incorrectly) inflating by more-or-less 2x, the reported income percentage. If the percentage was computed on the basis of the investment instead of on the market value, it would be accurate. (The same issue arises in reverse when holdings of a particular security are increased, rather than decreased as just described.)

1
1 votes

Reviewed · Last Updated