 Hey there, Chad Bonser here for High University Libraries. If you're comparing companies in the wine market, you'll want to compare company financials, operating revenues, net income, things like that across all the companies that you possibly can. Mergent Online is a database that will allow you to compare U.S. companies and companies abroad in international markets in a variety of ways. This video shows you how to find those companies and how to compare them with Mergent Online, so here you go. So let's say you've done some Googling and you've found this big company that's Williamette Valley Vineyard Incorporated out of Oregon in the United States, and you've done as your friendly librarian has said to do and say, go look for company information in Mergent Online for that company. So you've done that, you've gone and found this company, and what you find here is lots of good information, business summary, financials, all this kind of good stuff. And you say, well I actually want to look at competitors for this company, so you click on competitors here. Now what this will give you is a list of competitors according to the database, and you'll see it there's some things in here like Boston Beer Company, there's some of these are like warehouses and things like that, so this isn't really a great competitor list. So what you can do to create your own list of competitors if you're not satisfied with this list is to go up here and use these industry codes here. And so I want to choose this NAICS code with this 312-130. I'm just going to copy that guy right there. And we're going to go back and do a search here in Mergent Online. Okay, so what you're able to do is go over here and search for primary NAICS code. And we can plug that NAICS code right in there, and we'll just leave it because I'm looking for global companies, so I'm not going to choose a country or an exchange or an index or anything like that. And we're going to do search. Now the problem with this, this way of searching is that it finds a whole lot of companies. Here we have 110 public companies, so we're like cool, let's look at that. So we click there, and unfortunately there's no real way other than to sort this to filter out the inactive companies. I really don't want those inactive companies, okay? So what we have to do instead is go back to our search screen here, and instead of using this search, we're going to use the advanced search. Now what this will allow us to do is basically to deselect this inactive company database here and only get active companies. So we're going to do that, and then we're going to click on industry codes here. And we're going to do primary NAICS code. You can do any NAICS, but that might be if there's a holding company who has holdings in wine, they might have a NAICS code for that. I want to get companies who are primarily engaged in wine production. So that's what we're doing primary NAICS code. So we'll do that, add our NAICS code, click submit here, and see now it finds 69 companies, which is a lot better than 110. So we don't have to deselect a bunch of things. So we click over here and click view, and it's going to go give us our list of companies here. Okay? So what we can do now is there's this thing over here under emergent tools called a company analysis list. And you'll see there's nothing there right now, but what we can do is up here in the top left, we can add all companies to our company analysis list. And when we do that, we have 69 companies over here. And so now we can click on this company analysis list. And this gives us a couple of options here. Let me shrink this down so I'll actually fit on our page here. So this gives us a couple options. The default selection is this multiple company report. Now if we select that, it's going to give us a big long PDF of all these companies. And I don't really want that I want tables comparing the companies. And so to do that, we're going to do this company comparison report right here. So we click that. And what countries we want or companies we want over there, we just click the add button here. And we scroll down and let's say we want things like Oh, let's say we want to know how big the company is, we'll do a number of employees, we'll add that guy over there. And then we'll scroll down, let's do some financial information here. Now because we're dealing a lot with international companies, we may not have all the same information available, depending on what's reported there. So we'll just do a few items here to see what what actually we can find. And we will do total revenue there. Okay, and then we can go into ratios and maybe do let's do net profit margin. Okay. Now before we click, I create report down here, we can choose the years we want. If you wanted to, you can hold the select button down or the shift key down and actually click and get all the available data that's here. I'm just going to do the latest and I'm also included an average which will give us an average of all the companies there in the header for us. So now we can go down and choose select a format. I'm just going to do HTML if you want to you can download to excel if you like. So we'll do HTML. And then we'll create a report. So for the companies we selected, here is the list of information that we have for for a number of employees, the advertising spent, you can see probably mostly are just US brands are reporting that net income. And you'll notice this is actually all results are stated in US dollars. So you are comparing apples to apples here, we get net profit margin, things like that. So a great way to kind of compare you can also sort this you want to see, you know, who's the let's do the other way, who's on top as far as the largest companies in the world who produce wine, and that sort of thing. So a great way to get good international and US market information for companies in the wine and wine, winery industry. Hopefully this video helps you understand how to use merchant online to compare companies in the wine market. Should you need more help, look for the contact link on the business blog, be glad to help you anyway can take care and have a great day.