So in this course, we not only learn how to create the financial statements, but also how to analyze them. One of the main ways that investors, creditors or even the company itself analyzes the financial statements is through a horizontal analysis. Let's check it out. So horizontal analysis, well, what it does, it's going to evaluate percentage changes in account balances from one year to the next. Alright, so we're going to go through different accounts; we could go through our cash account and see a percentage change between one year and the previous percent, okay? So all it is, is we're going to be computing the percentage change between the two years balances in the account, alright? So there's a two-step process here. The first thing we have to do is we have to compute the dollar amount of the change. Okay? The dollar amount of the change because that's the first part of the percentage change and then we have to take that dollar amount of change and we're going to divide it by the base period amount, okay?

So here we have the formula for percentage change. It's the current year amount minus the previous year amount, so that numerator right there, the numerator is the dollar change. Okay? This year's amount minus the previous year's amount, that's the dollar amount of the change and then we divide it by the previous year's amount just like in step two. current year amount - previous year amountprevious year amount*100.

So I have an easier way that I like to remember this; this is like the formal definition of a percentage change. This is the way I like to think of it. I just think new minus old divided by old, okay? We've got our new number minus the old number divided by the old number. We've got previous year amount in both cases. It's the same number. So new minus old over old new - oldold. That's the way I think of it. It's easier to remember than all those words. Cool?

So let me go through an example with you of how we compute percentage changes and then you guys can go ahead and try and do a horizontal analysis yourself. Alright? So we've got some company here that had net sales, cost of goods sold, and gross profit and it's asking us to compute the percentage change for each of them. So let me get out a calculator because this is not something I can do in my head and let's go ahead and go through our process. Remember, we've got new minus old and that's going to be this first step. New minus old and then the second step is divided by old. Okay? And that'll get us to the percentage change. Alright? So let's go ahead and do this. Let's start with our net sales and that was 65455 that was new, right? 2018 is the new, 2017 is the old. Alright? So we're trying to find the percentage change. How much did it change from 2017 to 2018? Well, let's find the dollar amount first. 65455 minus 58081, 7374, right? So there we go, we've got our dollar amount of the change, so there was an increase there, right? We also want to pay attention to the direction, did it go up or down? So that was an increase of 7374, and now let's go ahead and find our percentage change. So we got to divide it by which number are we going to divide by here? The 2017 number, right? The old number. So 58081, and that's going to be 0.1269, so remember we want to change it to a decimal, so you got to move the decimal place 2 places over and we're going to get a percentage change of 12.7%. I'm going to round it to just 1 decimal there, 12.7%.

Alright, so that's good information, right? Now an investor can say, wow, net sales have increased by 12.7%. That sounds pretty good, right? So let's go ahead and see our cost of goods sold. Let's see how cost of goods sold was affected as well. So we've got 54912 minus 45377, okay? So our cost of goods sold has also gone up. Our cost of goods sold went up by 9535, right? That was the dollar amount of the change and now let's go ahead and find the percentage change, right? How do we find the percentage change? We divide by the old, right? New minus old divided by old and I don't even clear my calculator, right? I leave that dollar amount change right there and I write it down and then I just divide 45377. So you just do it all in one step. So there we go. 9535 divided by 45377, it's going to give us a percentage change of 21.0%. So that was an increase as well. Is pretty good information too, right? Because now the investors say, hey, net sales went up by 12%. That's great. But now look at this. The cost of goods sold went up by 21%, right? That doesn't sound as good, right? They were able to increase their sales, but their costs went up even more than the sales went up, right? So at first glance, the net sales increase is like, hey, this is good, but it actually ended up that they made less in gross profit, right? Remember, gross profit is just net sales minus cost of goods sold, right? Gross profit is that first subtotal that we show on a multi-step income statement. So let's go ahead and calculate our gross profit, right? They didn't give it to us in the problem, but we can just figure it out right here by just subtracting the two numbers. So 65455 minus 54912. Well, that's going to be 10,543, right? So our gross profit in 2018 was $10,543, and how about in 2017? 58081 minus 45377. That was 12,704. So look at that, in 2017, we actually had more gross profit than in 2018, right? Even though we had less in sales, we were more efficient I guess, maybe we were getting better deals from our suppliers, maybe when we increase those sales, we couldn't get as good of a price for some reason, it was a rare thing we were trying to pick up and we had to pay more, whatever it is, our gross profit decreased, since 2017. So let's go ahead and finish up this problem and do our dollar amount of the change and our percentage change. So 10,543 minus 12,704. Well, that gives us a negative and I signify the negative by putting it in parentheses 2,161, right? So it's a negative 2,161, and you would have got the same number if you had subtracted down. The 7374 minus the 9535, whoops. 7374 minus 9535, well, it would have given you that same 2,161.

Alright, so let's get our last percentage change here. So how we calculate that? It's going to be the 2161, the negative 2161 divided by the old gross profit of 12,704, and it gives us a negative 17%, right? Negative 17.0%. I'm rounding to 1 decimal. So there we go. We see that our gross profit decreased by 17%. That's really good information for an investor, a creditor, and even the company itself, right? They're getting really good information by checking these percentages. Alright? So let's go ahead and pause here and now you guys try a horizontal analysis on an entire balance sheet, right? We can use horizontal analysis on income statements, balance sheets, on any kind of account here, alright? So let's go ahead and pause and you guys try this one.