Spreadsheet (?) to determine controlled group

[BG5150]

Does anyone have a spreadsheet or similar type app that will determine if two (or more) companies are in controlled group situations? Something where you plug in the different ownerships for different companies and the program will tell which co's are in a controlled group.

[stephen]

The Technical Answer Group has a very nice spreadsheet for such a purpose. Perhaps you are a subscriber?

[BG5150]

I just found out we do have access to TAG (yay!). I sent them over a request today. (crosses fingers)

[BG5150]

Does anybody have a decent spreadsheet I can use?  I no longer have access to TAG.

[Tom Poje]

I'll try sending a file direct to you.

[EBECatty]

I've seen a few before, but was concerned they weren't comprehensive. I can't seem to pull them up now. They asked about family relationships for attribution, but didn't consider some of the more complex rules like excluded stock. I would be wary of relying solely on a spreadsheet unless it takes all the rules into account (or you use it only as a starting point). Also I don't think they accounted for the affiliated service group rules. Too many variables in my opinion, unless you are using it only for an initial assessment that's going to be vetted afterward. Or maybe you all have access to better versions?

[Mike Preston]

I think mine (which I think originated with Tom) handles Brother-Sister CG only and is limited to 5 companies and 7 owners.  Send me a PM if you can't find it and I'll see if I can find it.

[BG5150]

I got one from Tom.  It was the one I was looking for.  I will save it at home, too, so if and when I change jobs I won't have to ask for it again.  It's 5 owners and 4 companies, but it does what I need it to do for now.

 

Thanks, all.

[Tom Poje]

Austin let me bill him for the spreadsheet:

[Belgarath]

A bargain at twice the price!!

[BG5150]

Tom,

Can you resend the spreadsheet to me?  I've changed jobs and the file stayed at my old job.

[Tom Poje]

Dr. Evil said I need to charge you  as much as Belgareth suggested

[jeanh]

Would you mind sending me the spreadsheet for a controlled group- thanks

 

[cheersmate]

On 5/8/2017 at 4:06 AM, Mike Preston said:

I think mine (which I think originated with Tom) handles Brother-Sister CG only and is limited to 5 companies and 7 owners.  Send me a PM if you can't find it and I'll see if I can find it.

Mike, can you please send me the spreadsheet?  I would appreciate it very much.

 

[Phil]

Would anyone be able to send me a copy of this spreadsheet?

[Peter Gulia]

Imagine a software publisher offers a tool to show the presence or absence of all potential IRC § 414(b)-(c)-(m)-(n)-(o) relationships (or a limited set of them as the user specifies).

The software would allow a user to fill-in factual information, without needing to know the tax-law rules to be applied to that information. It would have context-sensitive definitions and guidance to help a user fill-in the needed factual information.

The software package would generate a report a user may furnish to its client. The report would show the presence or absence of each § 414(b)-(c)-(m)-(n)-(o) relationship, with some explanation of why the relationship is present or absent. The report would include disclaimers and warnings to limit the user’s liability to its client. Each user could take that default text, edit it, add warnings, or replace the set with the user’s custom text.

The report would speak in the TPA’s or other user’s voice, and could show the user’s name and logo, and specify the relationship manager or other contact.

BenefitsLink neighbors, if a software tool like this were available (from a reputable and reliable software publisher, ideally one you already use), would you buy it?

[david rigby]

13 minutes ago, Peter Gulia said:

BenefitsLink neighbors, if a software tool like this were available (from a reputable and reliable software publisher, ideally one you already use), would you buy it?

Authorship is paramount in the decision process.  Tom Poje? yes.  Mike Preston? yes.  Peter Gulia? yes.  Gary Lesser? yes.  Others? maybe.

[Peter Gulia]

david rigby, thank you for your point that one considers the source's qualities.

And thank you for your vote of confidence. But I have no appetite to be a designer of a software tool of the kind I imagined.

If the lead designer and specifier were Derrin Watson, would you buy the software tool?

[C. B. Zeller]

23 minutes ago, david rigby said:

Authorship is paramount in the decision process.  Tom Poje? yes.  Mike Preston? yes.  Peter Gulia? yes.  Gary Lesser? yes.  Others? maybe.

Or better yet, if the tool were open source and its code could be examined and vetted by a range of industry professionals.

[aleallie]

Bumping this to see if some one could send me this spreadsheet? BG5150 doesn't have it anymore - maybe some one has a spreadsheet they could share?

Would appreciate it very much. I no longer have access to mine.

[thepensionmaven]

Email me - steve@thepensionmaven.com

I have several I have collected over the years.  I'm looking for one for ASGs and just don't have the time to make one.

[C. B. Zeller]

ASG determination is highly fact-dependent and needs to consider things that don't fit nicely into a spreadsheet.

I find the flow charts on pages 45-46 of this document to be very helpful in analyzing potential ASG scenarios. https://www.irs.gov/pub/irs-tege/epchd704.pdf

[Tom Poje]

this was the spreadsheet from many moon agos

controlledgroup.xlsx