Find country where a foreign firm conducts its business
Posted: 16 November 2015 03:39 AM   [ Ignore ]
Newbie
Rank
Total Posts:  3
Joined  2015-11-16

Hi guys,

I am looking for some data of foreign firms listed in US. I want to find specific country where a foreign firm conducts its business. I found that there is FIC and LOC in Compustat. But when I downloaded the data, I found so many of them are incorporated or headquartered in Bermuda. I think that’s because many companies registered in Bermuda for tax reasons but they actually do not conduct business there.

I noticed that there is bus_state_region item in audit analytics. But for foreign firms, it just says “foreign” but does not say specific foreign country.

So I am wondering where I can find country where a foreign firm conducts its business.

Best regards and many thanks!:-)

Profile
 
 
Posted: 17 November 2015 11:18 AM   [ Ignore ]   [ # 1 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

hi Lucy9383,

‘LOC’ in Compustat Company (https://wrds-web.wharton.upenn.edu/wrds/tools/variable.cfm?library_id=129&file_id=65822)  as you mention is probably the best variable I can think of.

Segment information may give a geographical breakdown, but that won’t be available for all firms. Another thing to look at, but that is not in databases, is the list of subsidiaries that are in the 10-K (Exhibit 21). Foreign subsidiaries includes the country, but there is no breakdown on the sales/etc by subsidiary (so it will be hard to say how much activities are in each country).

In short: I don’t know smile

Best Regards,

Joost

 Signature 

To reply/post new questions: Please use the group WRDS/SAS on Google Groups! http://groups.google.com/d/forum/wrdssas

Profile
 
 
Posted: 19 November 2015 07:55 AM   [ Ignore ]   [ # 2 ]
Newbie
Rank
Total Posts:  3
Joined  2015-11-16

Thanks a lot!

Joost Impink - 17 November 2015 11:18 AM

hi Lucy9383,

‘LOC’ in Compustat Company (https://wrds-web.wharton.upenn.edu/wrds/tools/variable.cfm?library_id=129&file_id=65822)  as you mention is probably the best variable I can think of.

Segment information may give a geographical breakdown, but that won’t be available for all firms. Another thing to look at, but that is not in databases, is the list of subsidiaries that are in the 10-K (Exhibit 21). Foreign subsidiaries includes the country, but there is no breakdown on the sales/etc by subsidiary (so it will be hard to say how much activities are in each country).

In short: I don’t know smile

Best Regards,

Joost

Profile
 
 
   
 
 
‹‹ Exchange Codes      Calculating Tobin’s Q ››