Hello, I'm Professor Brian Bushee, welcome back. In this video, we're gonna continue our ratio analysis of Plainview Technology. We've got a lot of ratios to get through, so let's get started. Let's start by bringing back up the DuPont ratio analysis slide. I've added a couple boxes to what we had last time. Below Return on Sales we have some additional ratios that will let us drill down into profitability, things like Gross Margin and various Expense Ratios. And below Asset Turnover, we can look at turnover ratios for individual assets like receivables and inventory and liabilities like accounts payable. We're gonna start by looking at the Profit Margin Ratios to try to figure out what are the drivers of Plainview's profitability. Most of these ratios are gonna come straight from the Common Size income statement. We're gonna look at Gross Margin, which is Sales minus Cost of Goods Sold, divided by Sales. Which gives us a sense of the markup of the selling price over cost. We'll look at selling general and administrative expenses to sales, so SG&A expense to sales, to get a sense for how much operating expenses are as a percent of sales. The combination of those two as Operating Margin, which is Operating Income over Sales, then we'll also look at the ratio of Interest Expense-to-Sales and something called the Effective Tax Rate, which is Income Taxes divided by Pre-tax Income. >> Yes, yes. We already saw all of these ratios on the Common Size income statement. Will the entire video be this repetitious? >> No, the whole video won't be repetitive and it won't be repetitive either. But these are the ratios from the Common Size we looked at before. We need to look at them again, because to understand drivers of return on sales. We need to divide the various items on the income statement by sales as well. >> Here are the Profit Margin Ratios for Plainview. I have repeated all of the definitions at the bottom. I'm gonna put up the pause sign. Why don't you take a look at the ratios and see what kind of things jump out at you? >> One thing that leaps out at me is the steady increase in Gross Margin over the period. Does anyone have any theories for what could explain this increase in Gross Margin? >> Maybe the shifts to customize products and to customers in new industries allow Plainview to charge a higher price. >> And it would certainly help that one large customer does not have monopsony power over Plainview. Ironically, Plainview is probably afraid to charge the Defense Contractor a high price for fear of losing the business. >> No, you have it all wrong. It is the shift to automation and the new technology that allowed Plainview to reduce its manufacturing costs, leading to a larger gross profit. >> All excellent theories. It could be that Plainview's able to charge a higher price for roughly the same cost, and maybe that's by moving into new industries or providing the customized products, or by getting rid of the monopsony relationship. A monopsony is the opposite of a monopoly, where the customer has all the power, instead of the supplier. Or it could be something on the cost side, where Plainview's able to reduce cost, but charge around the same price. So maybe it's the automation that's doing that, or it's the new technologies. We're gonna have to look at a lot more ratios to try to get more evidence on which of these theories is correct. Let's look at the rest of the ratios. The ratio of selling general administrative expenses to sales is completely flat over the period. So as Plainview has grown substantially, it's managed to keep its SG&A expenses in line and not have them grow faster than sales as a whole. Then if we look at Interest Expense and Effective Tax Rate, there's not much going on. Interest Expense is pretty flat, and other than a blip a couple years ago, Effective Tax Rate hasn't changed that much either. >> Could it not be the case that a flat rate in SG&A would be bad news? If there were economies of scale we might expect the SG&A ratio to go down. >> That's an excellent point, Elizabeth. Usually when we look at a ratio and see that not much has changed, we assume that not much has changed. But it could be the fact that Plainview should have gotten some economies of scale. For instance, they're able to grow their sales volume faster than they grow their sales force. Or maybe they automated their accounts receivable collection so that they were able to reduce their SG&A costs as they grew. But lacking such information, we have to assume that this is just a flat trend. And it's at least good news that Plainview's SG&A hasn't grown faster than its sales. So our Profit Margin Analysis tells us that gross margin was the big driver of Plainview's success. Now we have to think about what are some possible explanations for this improvement in gross margin? Was Plainview able to reduce production costs while maintaining sales price? So we'd have the question of did Plainview further automate its production? Or were they able to raise the selling price while keeping cost constant? So we have the question, did the entry into new markets, the customized products, allow a higher markup? Or maybe it's a combination of both. There are no more ratios in the income statement that would allow us to drill down even further. So, at this point we're gonna have search for confirming or a disconfirming evidence of these explanations elsewhere in the financial statements and the ratios. And of course, if we were the analyst on the call, we could actually ask management very specific questions about what the source of their improvement in gross margin was. >> That's it? Can't the ratios tell us more? I still don't know the answer to how they made their sales more profitable. >> I can't promise that we'll ever know for sure just by looking at the ratios. Remember, ratios allow us to ask better questions, not necessarily give us the answers. But I do have some more ratios we can look at. One place to look for further information on how Plainview's doing, is to do a detailed Asset Turnover Analysis. Although Plainview's Asset Turnover ratio was steady over the period, looking at the detailed components of the ratio may give us more insight into what happened with Plainview's turn-around. For example, when there's dramatic increases in sales, like Plainview had, you often see lower inventory levels. So production can barely keep up with sales. And higher Accounts Receivable levels because the company has to extend credit to riskier customers to fuel its sales growth. And if you remember on the statements we saw all this weird stuff going on with Accounts Receivable and inventory over the period. So let's define the Asset Turnover Ratios. Basically, what these ratios are gonna tell us is how many times during a year a company cycles through its accounts. For example, Inventory Turnover of 8 would meant that it builds and sells Inventory 8 times during the year on average. So we're gonna look at Accounts Receivable Turnover, which is Sales divided by Average Accounts Receivable. Inventory Turnover, which is Cost of Goods Sold divided by Average Inventory. Accounts Payable Turnover, which is Purchases over Average Accounts Payable. Purchases, we're trying to get out the purchase of new raw materials, so we calculate that as the difference between ending and beginning inventory, plus COGS. And then Fixed Asset Turnover is Sales divided by Average Property, Plant and Equipment. Here are the Asset Turnover ratios for Plainview, along with the definitions at the bottom. I'm gonna put up the pause sign so you can take a look and see what these ratios are telling you. >> I do not find these turnover ratios very intuitive. I mean, Accounts Receivable turns over six times, what's that? That's about 60 days on average. Could we think about it that way? >> Yeah, I've never found these turnover ratios that intuitive either, so I'm gonna recast them in a way that is more intuitive to me, and hopefully will be more intuitive to you a s well. So now we're gonna look at the same ratios from a different perspective. We're gonna turn them into what are called Days Outstanding Ratios. These ratios will help answer the question, how many days on average are given accounts outstanding? For example, if you saw a Days Inventory of 45, it means that it takes 45 days on average from the time we start building the Inventory until we sell it. So the Days Receivable Outstanding Ratio, or Days Sales Outstanding Ratio, which is often called DSO, so if you've heard the term DSO, it's referring to this ratio. It's just 365 divided by the A/R Turnover. So, 365 being the number of days in the year. And in fact, that's how the Days Inventory and Days Payable Ratios work as well. We just take the Turnover Ratio and divide it into 365. But, by putting these ratios in days, we can come up with a new ratio called the Net Trade Cycle. This is the Days Receivable plus the Days Inventory minus the Days Payable. The Net Trade Cycle represents the gap between cash outflows, which are the Days Payable, and cash inflows, which come from the Days Receivable that we need to bridge with short-term financing. So, in other words, the bigger the Net Trade Cycle, the more borrowing you have to do. I'll talk about this ratio more in the context of Plainview. Speaking of Plainview, here are the Days Ratios for Plainview. These are the ones we're gonna talk about in detail. So why don't you pause the video, and take a look at them. Let's start on the top line with Days Receivable. So Days Receivable for Plainview has gone down from 60 to 44 over this period. Now the 44 means that from the time Plainview makes the sale, it's 44 days until they collect the cash. So they're collecting their cash 16 days more quickly over this period. Is that good news or bad news? Well, it depends. Remember ratios on their own are not good news or bad news. But instead, we wanna figure out what activity drove the change in the ratio, and is that activity good news or bad news. For example, this could be good news if Plainview put in new collection efforts, and as a result they get paid more quickly. It could be bad news if they've been restricting their sales to customers that pay more quickly. And as a result, having been giving up a lot of sales growth and profitability. But let me ask you guys. What do you think caused this? >> Clearly, it is the loss of the Defense Contractor that allowed Plainview to collect more quickly. Such a large customer can practically dictate its payment terms. >> Maybe Plainview offered discounts for customers that paid more quickly. Or, it was the improvement in the economy. After the financial crisis ended, customers had better financial health and were better able to pay on time. >> Those are all excellent theories. Let's look at them one by one. Elizabeth suggested it was losing the Defense Contractor that allowed us to collect more quickly. And certainly, if one big customer has power over us and refuses to pay more quickly, it's gonna hurt our Days Receivable. Once that customer leaves and we can choose other customers, we can choose customers that pay more quickly. Plus, Plainview moved into new industries. And one more thing we could look at is, maybe the companies in those industries just tend to pay more quickly. Eric suggests that maybe they're offering discounts for more quick payments. The problem with that theory is that if we were offering discounts, it would cut into our selling price and cut into our gross margin, but we see that Plainview actually had an increase in gross margin. Dave suggested it's the economy as a whole. Well, we can check on that one as well. Why don't we bring up three of Plainview's competitors. Because if it's the economy, this improvement in collections should be shared by everyone in the economy. And as we can see, that's not the case. Only Plainview had an improvement in Days Receivable. Their competitors did not. So, the most likely theory is that it's the fact that we got rid of the Defense Contractor, and moved into the new industries with new customers that's now allowing us to collect 16 days more quickly. Next, let's look at Days Inventory. Days Inventory has increased from 81 days to 105 days. Which means from the first point that Plainview gets raw materials, it's a 105 days before the finished inventory leaves the warehouse to go to the customers. So Plainview's having to hold inventory 24 days longer. Is that good news or bad news? Well, I guess it depends on what it reflects. It would be bad news if the inventory wasn't selling. But that's probably not the case for Plainview, given their growth in sales. It could be good news if they're ramping up their inventory production in advance of future sales. But, what do you guys think is the explanation? >> I think it was a shift to customization. It takes longer to produce inventory when it is made in customized, small batches. >> Yes, that would make sense with the higher gross margin. Plainview can charge more for a product because it is customized and takes longer to produce. >> But, it is peculiar that Plainview holds inventory longer when its sales are growing so much. >> I really like Eric's customization explanation for the increase in Days Inventory. If you make customized products, they're gonna take longer to make. You have to make smaller batches. Set up the machine for each batch. Bring in different raw materials. And you're just gonna have inventory longer. But as long as you're getting paid for that, you should see the Gross Margin increase, which is what we see with Plainview. Elizabeth raises an excellent point, that it's strange to see Days Inventory go up, when sales growth is also going up quite a bit. What could explain that is the two new factories. So maybe Plainview sales are not at a level that can support the two new factories to run around the clock, but we wanna run them at capacity. So, maybe Plainview's over-producing a little bit of inventory now in anticipation of future sales. Now let's look at the Days Payable ratio. That's gone down from 55 days to 33 days, which means that from the point Plainview gets raw materials from its suppliers, it's 33 days until they send them a check to pay them what they owe them. So Plainview is paying its suppliers 22 days more quickly than it did before. What could explain that? >> No doubt. Collect the cash faster from customers. Pay suppliers more quickly. >> If buying view pays suppliers more quickly, it might get to take advantage of discounts, which would reduce inventory costs and improve Gross Margin. Hey, this is fun. >> Yeah, this is fun. So maybe it is a simple matter that if you collect cash more quickly, you can pay your suppliers more quickly. And in doing so, you can take advantage of discounts, as Eric pointed out. And if you take advantage of discounts, your raw materials cost less, which means your cost of it sold is lower and your gross margin is higher. So why doesn't everybody always take advantage of discounts? Well, there's a cost to it, and that's what we're gonna look at in this next ratio, the Net Trade Cycle. The Net Trade Cycle is basically a measure of the number of days that you have to borrow from a bank to meet a short-term cash shortfall. So the Net Trade Cycle is Days Inventory plus Days Receivable. So that's basically the number of days from when you first get raw materials, to when you make the sale and then collect the cash. So in Plainview's case, it's 105 days inventory, 44 days receivable, 149 days from when you get the raw materials to when you collect cash. Then we subtract the Days Payable, which is the number of days that you have until you have to pay cash to your supplier. That's only 33 days. So, 149 minus 33 creates a gap of 116 days. That 116 days is the number of days Plainview has to go to a bank to borrow money. And note that Plainview is borrowing 30 days more now, than they were a few years ago. Is this good news or bad news? >> This is very odd. Why would Plainview pay it's suppliers more quickly when it would have to turn around and borrow more money from the bank? >> Yeah, the only way this would make sense for Plainview, is if the discounts that they get by paying their suppliers earlier are greater than the extra interest that they pay from borrowing from the bank longer. And that's probably the case for Plainview. We saw earlier that their interest expense as a percent of sales has been fairly flat over time. Indicating that they're able to borrow more, without having it negatively affect their interest rate or their interest expense. So, all in all this seems to be a good thing for Plainview, where by taking advantage of the discounts, they're able to reduce their costs and increase their gross margin. >> So what are the overall conclusions that we can draw from this DuPont Ratio Analysis? It seems that for Plainview, the entry into new markets has produced higher-margin sales with faster collections. And those faster collections are potentially allowing them to take advantage of discounts. But there are much longer production times and have to hold much more inventory. There's still a couple puzzles out there. How are they able to do this with 40% in higher sales growth? And why is their cash flow from operations so volatile? Or as we said before, squirrely. So at this point, we have a pretty good idea of what's going on with Plainview, but it's only a pretty good idea. We don't know specifics, but we're at a point now where the ratio analysis will allow us to ask much better, much more specific questions to try to get to the bottom of what's going on with the company. >> So, can you tell us what happened? No, I'm not gonna tell you what happened, because if this was real life, you would do the ratio analysis without knowing what was gonna happen in the company's future. The ratio analysis is not about the outcome, it's about the journey. It's about using a systematic approach to looking at ratios to try to figure out what may be working or not working for the company. But, also to generate a good set of questions that you would then follow-up and do more research, or try to contact the company to find out the answers. So I'm gonna leave you hanging and not tell you what ended up happening to Plainview. So we just have one more video to do on Plainview Technology. We haven't looked at any of the liquidity ratios yet, so in the next video we'll introduce liquidity ratios and take a look at those ratios for Plainview. I'll see you then. >> See you next video.
