Can anyone tell me how Quicken calculates RtrnCap?
I am not able to duplicate the results that Quicken produces. I have many occasions when I need to do a return of capital and it affects multiple lots (e.g., dividend reinvestment). I can do the calculation in a spreadsheet, and the overall result for all lots is the same, but I don't get the same per-lot reduction in cost basis that Quicken gets. I think one needs to reduce each individual lot by the same ratio. In my case today, this is the percentage of the basis that remains after a spinoff or merger. The ratio is based on the closing price of the two companies involved. But Quicken appears to use a variable ratio and I can't tell where it originates. Does anyone know the details of how Quicken applies the reduction across multiple lots?