All right, let's do a little how to segment. For this next section we're going to be doing some manipulation of some financials inside of an Excel spreadsheet. Now, I don't want you to type these things in long hand because different key strokes, you might get some wrong numbers. And I want you to be able to be comfortable with manipulating these things. So what we have to do is we have to import some data into an Excel spreadsheet. I want to show you a fast and easy way to do this, and so you can replicate it. First off I'm going to use Yahoo Finance for this exercise. And I've pulled up Nike stock ticker, NKE. Now, we've been working with balance sheets, income statements and cash flow statements. We're going to be working on balance sheets and income statements going forward. I'm going to pull up their balance sheet here. I've already done this, but I just clicked on Balance Sheet, and I've pulled up their annual balance sheet, it's got 2014, 2013, 2012. Now, I'm going to copy these data and I'm going to import them into Excel. So I mean literally just going to copy and paste. So I'm just highlighting all of the rows of information here down to right here where it says total stock holder equity. And I hit Control C, and then what I'm going to do is I'm going to open up a workbook in Excel. And what I'm going to do is I'm going to paste the information, and so I'm going to right click here and it give's me an option to Paste Special. And I'm going to click on Paste Special right here. And this option give's me ways that I can move this data in and out using HTML or text or Unicode text. I'm going to select the Unicode text here which is the second option. And then I'm going to click OK. Now it's going to give me a warning saying the data you're pasting isn't the same size as your selection, and that's okay. Essentially it's going to paste the information in wherever it can. And it does so, all right? Now what I'm going to do is I'm going to go to these different columns and make them the size that I need. And then here. All right, and so here it is that I've got my my assets and I've got my liabilities here, okay? So now, what I don't have, and I don't have my equity, I want to go back here and get my equity, grab that in, copy and come over here and I want to paste in my equity as well, Paste Special. So I've got my assets, my liability and my equity. And so I've just done a Copy and a Paste, I used the Unicode and Paste Special, and it puts these numbers in in such a way that I can manipulate them. So let me just show you here, I'm going to insert a couple rows here just to show you how I can play around with these data. Like I want to double check to make sure that my total assets are in fact the value of my total current assets along with my long-term assets, okay? So right down here I'm going to say = and then I'm going to add a bunch of stuff. So here's my total current assets, that and then I'm also going to add in my PP&E here and then I'm going to add in my good will here. going to add in my intangibles here, and add in my deferred long term assets right here. And look, the number I got. So if I sum those, equals B9 plus B11 plus B12 plus B13 plus B16, so I'm adding in the values in each one of those cells, I in fact get exactly what this says is my total assets. And if I copy that across, and just do this little highlight over here, and copy it across, lo and behold, the numbers that this balance sheet says are my total assets are exactly the same as what I've summed up as my total assets. So you want to work with the financials, you want to work with them in Excel, you can go to Yahoo Finance, any number of other Internet finance locations, and do a copy and a paste special, using Unicode text. And it takes that information and will import it into your Excel so that you can manipulate it on your own.
