Investment Performance Report: Gains not based on cost basis

Voytek

Hi, is there a way to generate an investment performance report that calculates gain based on money put in and not on cost basis? The raw gain numbers shown in Account Overview use cost basis as a basis for the performance, but that is not always desired. Dividend reinvestment affect the cost basis, so the default report hides the value of the dividend gains. As an example, if I initially invest $1000 and then reinvest $100 in dividend (for simplicity's sake assume the same price per share), the value and cost basis of the fund is $1100. Quicken will show 0% gain. But really there is 10% gain based on the fact that I only put in $1000.

Jim_Harman

@ftcnative, 

Unfortunately Quicken does not have a report that does exactly what you are looking for.

You might be able to export the data from the Investment Performance Report to Excel and manipulate the data to get what you want. You would have to remove the employer contributions and analyze the report data with Excel's XIRR function. 

The after tax gains are more complicated, because for a complete analysis you would have to consider both the taxes you don't pay when you contribute to the account and those you do pay when you withdraw the money.

Sherlock

I suggest you consider using the Investment Performance report: select Reports > Investing > Investment Performance

ftcnative

I'm also interested in same - That report is not it. I want how much I (personally NOT what my employer) contributed INTO an account. And the rate of return in the WHOLE account. Also, want to add in the "gains" due to not paying income tax on that allotment (would be incremental tax bracket for the YEAR).

Jim_Harman

@ftcnative, 

Unfortunately Quicken does not have a report that does exactly what you are looking for.

You might be able to export the data from the Investment Performance Report to Excel and manipulate the data to get what you want. You would have to remove the employer contributions and analyze the report data with Excel's XIRR function. 

The after tax gains are more complicated, because for a complete analysis you would have to consider both the taxes you don't pay when you contribute to the account and those you do pay when you withdraw the money.