Investment Performance Report with "No Security (includes Cash)" selected

q_lurker

This report is fundamentally the most flexible tool for determining Average Annual Return values within Quicken. For some unknown reason, the current programming takes some odd paths when two settings are used together:

1. The selection of securities includes the "No Security (includes Cash)" selection, and
2. The report is subtotaled by any of:
   1. Security,
   2. Security Type,
   3. Investing Goal
   4. Asset Class, or
   5. Option Group.

This odd behavior is further discussed here. The consequence is that the Total IRR on the graphical part of the report is incorrect.

Including the security = "No Security (includes Cash)" is a common selection, the default selection, and necessary to determine an average annual return on a complete portfolio including the cash component of the portfolio. When the report information is subtotaled, the cash component is not reported and the associated Total IRR value is then wrongly computed.

In my opinion, the subtotaled versions should treat cash as follows:

• SUBTOTAL BY ………. INCLUDE As
• None ……………………….. No change necessary, cash is included
• Account ……………….. No change necessary, cash is included
• Time (MQY) ……….. No change necessary, cash is included
• Security ……………….. No Security
• Security Type …… No Type (The report already presents a "No Type" section but does not include the cash values)
• Investing Goal … No Goal (The report already presents a "No Goal" section but does not include the cash values)
• Asset Class ………. No Asset Class (The report already presents a "No Asset Class" section but does not include the cash values)
• Option Grp ……….. No Option Group (The report already presents a "No Option Group" section but does not include the cash values)

From that expanded inclusiveness, the TOTAL IRR value would be computed and should be consistent with the non-subtotaled result.

Edit 9/3/23 I meant to add — It would also be beneficial to the user for the table portion of the report to also present the Total IRR value. The complete detail would not need to be repeated, only the calculated Average Annual Return. The characterization that subtotaling is being done implies that the total should still be there. It is clear (I believe) that the Total is not the sum of the individual portions.

Jim_Harman

Thank you for the thorough analysis, @q_lurker.

This is definitely a shortcoming of the current Investment Performance Report.

Note that the Avg. Annual Return (%) columns in the Investing > Portfolio views correctly include Cash in the total at the bottom regardless of the Subtotal by: option selected.