Revenue mix by country
I'm trying to figure out revenues by country for a few public companies -- to get a sense of how much US / No US exposure there is.. any thoughts on how to go about this quickly?
thanks!
Trending Content
| +76 | GF doesn’t care about her looks | 49 | 4h | |
| +44 | Affair with my Associate… In Desperate Need for Advice | 22 | 14h | |
| +39 | Insurance as High Finance? | 10 | 1d | |
| +37 | 400k/year in HVAC sales? | 26 | 16h | |
| +34 | How to sound more eloquent? | 12 | 25m | |
| +33 | Would you rather live alone in an outer borough or with roommates in Manhattan? | 23 | 1d | |
| +31 | Framed Photo of CEO on desk. | 16 | 2d | |
| +26 | Why do people listen to Jim Cramer Investing Advice? | 9 | 9h | |
| +24 | BO -> ??? | 14 | 5d | |
| +22 | When do you plan to buy your first house and how much do you expect to spend? | 24 | 1d |
Career Resources
If you have FactSet or Bloomberg, for certain companies this information will be easily available.
Alternatively, just open up the 10-k and ctrl+F for the word "segment" or "country" - companies will often (but not always) include a table summarizing operating data for each major reporting segment. Sometimes the segments will be split by country, other times by business unit, sometimes companies will break out both.
Thanks...do you know where in Bloomberg I can find this?
I just ask my analyst or bankers to pull stuff for me so am a bit rusty nowadays... but I believe the function was "FA" (for Financial Analysis) - others can correct me if I'm wrong. But for example try typing in "AAPL Equity FA" and it should pull up the interface where you can browse through the available financial data.
You can also open up the Bloomberg add-in within Excel, and somewhere in the tool bar there is a list of templates. Some of these templates allow you to easily pull data from the FA and other functions, so you could easily generate a table with 20 companies and compare metrics across them.
This works. I'd definitely check 10-k and investor presentations first though. While bloomberg and factset can be helpful, they are often not 100% accurate, so we always start with company filings and IP's first from my experience. Depends on how reliant you are on the numbers being accurate.
I've become convinced that these metrics should be taken as directional orders of magnitude and nothing more, and Bloomberg data does the job just fine. I don't think an analyst does the job any more accurately because of the intricacies of financial statements that are missed 99% of the time.
I'll give you an example: some companies have foreign subsidiaries that house their foreign operations. The reporting company consolidates the financials for the foreign sub, so you see gross (100%) numbers. However, often times there is a local investor participating for 20% or something of that foreign sub. This minority interest gets consolidated at book value on the balance sheet, but it may not show up at all in the segment reporting (and often times when it does, it's consolidated with other items into a intercompany eliminations line so you don't know which segment to adjust). An experienced analyst/associate can take the time to understand this and treat it properly after digging through a few notes on the financial statements. But to get it right can double or triple the time it takes to generate the comps, and chances are it's just not worth the trouble given the 20 other things you have to do that night.
As an associate or VP, it is extremely impractical to check over this type of detail in the work, unless it's live M&A and your analyst is modeling the transaction or putting together a comps table that will be used in a fairness opinion, etc. For a standard comps table in a pitchbook though, these types of small oversights in accounting detail (and there are dozens more possibilities) don't get noticed, which that means the table isn't that important. If the table isn't that important, then just use Bloomberg and blame them if something is fucked up. Everybody goes home happy that way.
Expedita repudiandae molestiae at harum laudantium velit. Aut temporibus labore aut praesentium temporibus. Iste eum qui ut qui cum. Deleniti tenetur sint eveniet sit tenetur aliquid.
Vitae ut corrupti quam et hic et ut. Ex exercitationem unde architecto velit vel. Repudiandae et repellendus non rerum amet aut dolorum.
Sapiente accusamus velit voluptas ut. Deleniti et cupiditate non qui magni assumenda odit. Esse et laudantium aliquid aut alias. Quod saepe ex voluptas et voluptatum. Quisquam fuga animi amet magnam nemo repudiandae velit neque. Consequatur rerum nemo et officia quaerat fugiat.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...