 Hey there, Chad Bonder here for High University Libraries. In this video I will show you how to use Mergent Online to get industry averages and industry ratios across a list of competitors or companies that you select. So here you go. So we'll begin at Mergent here just by searching for a company within our industry. So in this case I'm looking for Time Warner Cable. So we'll just search by ticker there, click on the company, and you get all kinds of financial information in here. You'll notice there are under company financials, there are ratios and things like that, but that will just be only for one company there. So if you want to compare multiple companies, the way you can do this is go under competitors here. And you'll get a nice list of competitors according to Mergent. Now, some of these companies you may say, well, I don't really want to compare those. So if you don't want General Electric, for example, you can get rid of that one and get rid of Disney, maybe get rid of Time Warner Incorporated, get rid of some of the companies that don't really make sense being in there. This list is based largely on NAICS code and sub-industry codes and things like that. So some of the things may be kind of assigned arbitrarily, so you might want to go through and delete some things in there. And you'll notice if we go through our list here, like Direct TV is not in there, so we want to add Direct TV, we can just go under and type in Direct TV, or we can go under and type in DTV and get the company there, click the company, click Add, and it will appear in our list there. So you can do that for whatever kind of companies you want to do. And once you do that, you'll go over here and see there's a link here to add all to our company analysis list. So we do that, and now we have 17 companies in our list here. And so if you want to go back and add more, you can go back and continue to add companies here. So the industry that we're defining is kind of relative to the companies that we are selecting, so we are kind of identifying, in addition to what Merchant has identified, companies that are in our industry here. So the ratios that we create in our next report may be slightly different than other places have, simply because they may have used other companies to compare. So bear that in mind. And in your citations, you probably want to say these are the companies that I'm using to make my industry analysis here. So we'll click on Add All Companies to our company analysis list, and then we'll click on our company analysis list. Now here's an important step here. Before you go and add companies over here, you want to click on the company comparison report here on the left side. And that will give us a different screen here. And I'm just going to go ahead and add all companies here. You can X out of the ones you don't want. I'm going to go and click Add All Those over there. And then we'll go down. You see there's financial information. We're going to go into ratios here. And basically you can just go in and just add whatever ratios you want to over here on the side here. So typically things like quick and operating margin and net profit margin, those are usually return on assets, return on equity, things like that. Return on investment. OK, so as we do that, you'll see our list fills up over here. Now I'm just going to do latest. If you wanted to do multiple years, you could actually go down and actually hit the Control key or Shift key, or rather, and select all. I'm just going to do latest for the sake of time. To get the industry average or the average across the peers that you've selected here, you want to click this box right here. And then if you scroll down the very bottom, there is a link to Creator Report. And this is actually outside of my video frame here. Let me move this over a little bit. There's a link to Creator Report. You can create a report down in the bottom right. So what you want to do is actually select your format. You can select an Excel document. I'm just going to do HTML to kind of show you what this looks like on the screen. And then click Create Report. And this will open our report in the new window. And here is the data for those companies there with the peer average. And they call it peer average, not industry average, because we are comparing the pre-selected peers that we want to select there. And then there is the data that we have available for those companies. You want to, you can actually sort on the column just by clicking on the column, and that sort of thing. So you'll notice some of these companies are no longer active. If you wanted to, you can go back and redo the search and delete those as well. So that's how you find ratios, industry ratios, and peer ratios for companies using Mergent Online. Hopefully this video helps you. Should you need more help, look for the contact link on the business blog. I'd be glad to help you any way I can. Take care and best of luck with your research.