tag:infinitekind.tenderapp.com,2009-01-14:/discussions/problems/75081-a-spinoff-that-disappearedInfinite Kind: Discussion 2022-02-24T04:40:21Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/495010512021-11-22T16:23:58Z2021-11-22T16:23:58ZA spinoff that disappeared<div><p>Make a "buy" transaction of ONL at zero cost. This assumes that the new company is at zero basis cost.</p>
<p>If not, specify MiscIncome from O for the basis cost and then a buy of ONL at the basis cost.</p>
<p>(Not IK Support)</p></div>sthtag:infinitekind.tenderapp.com,2009-01-14:Comment/495010512021-11-23T18:09:04Z2021-11-23T18:09:04ZA spinoff that disappeared<div><p>It worked in a weird sort of way. I was unable to “buy” 136 shares at $0.00 (it defaults to $100), but I could at $0.01.</p>
<p>I can live with a $1.36 error.</p>
<p>Michael Triplett<br>
Triplett Enterprises Ltd.<br>
<a href="mailto:michael.triplett@mac.com">michael.triplett@mac.com</a> <a href="mailto:michael.triplett@mac.com">michael.triplett@mac.com</a><br>
515.707.3464</p></div>michael.triplett@mac.comtag:infinitekind.tenderapp.com,2009-01-14:Comment/495010512021-11-23T18:10:04Z2021-11-23T18:10:04ZA spinoff that disappeared<div><p>MD hates a price/cost of zero... 0.01 is the workaround</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/495010512021-11-23T21:06:16Z2021-11-23T21:06:16ZA spinoff that disappeared<div><p>You should be able to edit either the per/share price or the total amount as zero. You can correct the error if you leave it like it is by declaring a brokerage fee of negative $1.36.</p></div>sthtag:infinitekind.tenderapp.com,2009-01-14:Comment/495010512021-11-23T21:45:57Z2021-11-23T21:45:57ZA spinoff that disappeared<div><p>I'm a fellow user.</p>
<p>I would question if you 'really' received the new shares at zero cost, which i what a buy at zero cost implies.</p>
<p>The 1,368 shares you had I expect cost something say $X and a simple division gives you the cost per share.</p>
<p>You cannot and should not wipe out this cost.</p>
<p>I think it would be more accurate to say you received $X back and that the 136 shares you now have also cost $X.</p>
<p>Based on this I would look to enter a sales of the shares of 1,368 in O for a total amount of $X and a purchase of 136 ONL for a total cost of $X.</p>
<p>This I believe would give you your correct cost base for ONL.</p>
<p>What is effectively happening is a stock for stock transaction, no money changes hands but the number of shares you own changes, the company the shares are in changes but the total cost remains the same. Moneydance does not have this type of transaction so we need to use Sells and Buys to mimic it.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/495010512021-11-23T21:56:49Z2021-11-23T21:56:49ZA spinoff that disappeared<div><p>@dwg. I agree completely. Each spinoff technically reduces the basis cost of the original company by some percentage. This is reported to the SEC (in the US) and is a fixed number for tax purposes.</p>
<p>Thus the spinoff is misc income from the original stock and then a purchase at that new basis cost for the spinoff corporation. This reduces the basis cost of the original stock by the same percentage..</p></div>sthtag:infinitekind.tenderapp.com,2009-01-14:Comment/495010512021-11-23T22:16:44Z2021-11-23T22:16:44ZA spinoff that disappeared<div><p>I've reread the OP and can see there looks to be a return of capital event (I misread it as a complete takeover) but I'm still not certain.</p>
<p>From a Moneydance point of view this complicates it as there is no RoC transaction type.</p>
<p>I have found I can only maintain MD data at the total level in this case use Average cost basis and maintain lot information separately. To do this I have had to enter sells at zeros cost to drop the total cost basis and then enter a buy in the newly formed company using the return of capital funds.</p>
<p>The company should advise the details of how the spin off worked since RoC ,while it is the usual way, it is not the only way they could fund a spin off - a special dividend is sometimes used (that makes it a whole lot easier).</p>
<p>I've been advocating for quite some time for a RoC action type to be added to Moneydance.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/495010512021-11-23T22:44:17Z2021-11-23T22:44:17ZA spinoff that disappeared<div><p>@dwg, I agree it seems to be an RoC event. It would be nice if there was some way of having MD handle this gracefully. Making a proportional drop in the basis cost of the different lots is not really possible. I had a real mess with a stock that split into 3 new companies and then one reconverted back into the old company after a year. Had to keep some of the tax info outside of MD.</p>
<p>Back in MD 2014, I recall a posting by Sean that he hoped to improve the investment tracking and handling and with more analysis. But seems busy just trying to keep up with banks constantly changing protocols. Sort of a Red Queen situation.</p></div>sthtag:infinitekind.tenderapp.com,2009-01-14:Comment/495010512021-11-23T23:48:49Z2021-11-23T23:48:49ZA spinoff that disappeared<div><p>I've had a number of conversations with Sean on RoC as that is one of my biggest issues as I have these occur every 6 months and legally I have to maintain the information to determine eventual capital gains on a lot basis.</p>
<p>I have found I have to just keep the top level view in Moneydance and maintain the lot information along with the return on a lot basis in a spreadsheet.</p>
<p>Very few programs do RoC. I know Quicken/Reckon is one but I have since found that it cannot handle all cases as needed - Stapled securities being one. Shame is that I can see a way of handling those properly in MD if it had a RoC function.</p>
<p>Going back to Reckon is not an option I would consider :)</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/495010512021-11-25T04:36:04Z2021-11-25T04:36:04ZA spinoff that disappeared<div><p>Agree, it is not an optimal solution now and that having a RoC capability in MD would be a help. Having it change basis cost on a by-lot basis might be tricky but also doable. However it is a lot of work and Sean is barely keeping up with the banks throwing curve balls.</p>
<p>I am not sure of the resolution here to getting more investment features in MD while keeping the main program compatible with the changing financial industry. I still get weird ROI numbers in the reports.</p></div>sth