Closed sreenivasmrpivot closed 8 months ago
hickeng
commented
8 months ago I'm not sure what you're asking for here? A cell in which you can manually enter this information so it's visible as a contrast to the existing STG/LTG values that are shown?
The values in the 1099B are incorrect for many people. Is the intent to illustrate that fact in some fashion?
sreenivasmrpivot
commented
8 months ago @hickeng I am not sure where to find the LTG/STG from VMW to BCOM conversion, based on cost basis.
If I understand correctly, LTG/STG from this transaction is probably independent of our W2 and should be seen in the workbook somewhere. Can you kindly point me to the cells where is can find the total LTG/STG from this conversion?
hickeng
commented
8 months ago It's one of the main sections on the Summary tab
The Dollars line, colour-coded blue (Immediately Relevant) is the capital gain you're forced to realize from the merger.
The Post-merger sale , colour-coded green (Relevant on future sale) is the gain, based on the value configured in Summary!M28, that you'll realize if selling all AVGO received through the merger.
Taxable income is the Ordinary Income part of selling ESPP. That's not incurred on a section 356 merger so there's no immediate impact.
is probably independent of our W2 The W2 values are only used to calculate the Tax Estimate. The LTG/STG feed into that estimate but are independent of it.
hickeng
commented
8 months ago Closing for now. If there's specific info that's not present there that you're looking for, feel free to reopen with additional details.
It would be great to include (Total Short Term and Total Long Term Gain/Loss) from 099-CONS MSSB LLC in the workbook Summary Page. This will be very helpful to have discussions with CPA and also understand the net impact of VMW to AVGO move on Long / Short Term Gains / Losses. This could also help in identifying how the Long / Short Term Gains / Loses taken elsewhere like Robinhood might help the individual offset the gains here.