Good day, and welcome to The Home Depot Quarter 4 2017 Earnings Call. Today's conference is being recorded. At this time, I would like to turn the conference over to Ms. Diane Dayhoff, Vice President, Investor Relations. Please go ahead, ma'am.
Thank you, Abby, and good morning to everyone. Joining us on our call today are Craig Meniere, Chairman, CEO and President Ted Decker, EVP of Merchandising and Carol Tomei, Chief Financial Officer and Executive Vice President, Corporate Services. Following our prepared remarks, the call will be open for analyst questions. Questions will be limited to analysts and investors. If we are unable to get to your question during the call, please call our Investor Relations department at 770-384-2387.
Now before I turn the call over to Craig, let me remind you that today's press release and the presentations made by our executives include forward looking statements as defined in the Private Securities Litigation Reform Act of 1995. These statements are subject to risks and uncertainties that could cause actual results and in our filings with the Securities and Exchange Commission. Today's presentations also will include certain non GAAP measures. Reconciliation of these measures is provided on our website. Now let me turn the call over to Craig.
Thank you, Diane, and good morning, everyone. Before I start, I'd like to recognize Diane Dayhoff. This is Diane's last earnings call, and I want to Thanks, Diane, for all her amazing contributions to the company in her nearly 15 years. And so Diane, we wish you all the best in retirement.
Thank you.
Fiscal 2017 was another record year for our business, and we achieved the highest sales and net earnings in company history. Fiscal 2017 sales grew $6,300,000,000 to $100,900,000,000 and an increase of 6.7 percent from 2016. While diluted earnings per share grew 13% to $7.29 Sales for the Q4 were $23,900,000,000 up 7.5% from last year. Comp sales were also up 7.5% from last year and our U. S.
Stores had a positive comp of 7.2%. Diluted earnings per share were $1.52 in the 4th quarter. We continue to see broad based growth across the stores and our geographies. All 3 of our U. S.
Divisions posted positive comps in the 4th quarter, but we did see more variability in regional performance than we have and several quarters due to weather. Internationally, both Mexico and Canada posted another quarter of positive comps in local currency. While sales did benefit from hurricane recovery efforts, we also had hurricane related expenses. Our merchants, store teams, Supplier partners and supply chain teams did an outstanding job delivering value and service to our customers Throughout the quarter, both in stores and online. As Ted will detail, both ticket and transactions grew in the quarter, And we saw growth in both pro and DIY categories.
Pro sales once again outpaced DIY sales in the quarter As the work that we are doing to enhance service capabilities for our pros continue to resonate. We are pleased With the growth of sales to our DIY customers who also gave us a likelihood to shop again score of 86%, up almost 150 basis points from last year. Our interconnected business made great strides in 2017 as the team We implemented a new e commerce platform, enhanced our search and mobile functionality, increased checkout Speed and expanded chat functionality to improve the customer experience with our online contact centers. We continue to invest in our digital properties and it has increased traffic and conversion. Versus prior year, Our online sales grew 21% in the 4th quarter and 21.5% in fiscal 2017, now representing 6.7 percent of our total sales.
While we are seeing significant growth in our online sales, These online shoppers see the relevance of our stores as approximately 46% of our online U. S. Orders are picked up in our stores, a testament to the power of our interconnected retail strategy. We have talked a lot about the progress we have made in building our up stream supply chain network over the past several years. We've also told you about the $1,200,000,000 investment we plan to make over the next 5 years to leverage the capabilities and competitive advantages that we have in our upstream network, while significantly improving our downstream proficiencies to leverage our scale in convenient locations.
This year, we will pilot the local flatbed DFCs and Market Delivery Operations. But I want to remind you that this investment in One Home Depot Supply Chain is a 5 year journey where the financial benefits won't be realized until the initiative is complete. These investments are critical to meet the evolving needs of our customers We are committed to creating the fastest, most efficient delivery network for home improvement products. Well, we are not an organization that rests on our loyals of previous accomplishments. I don't want to miss this opportunity to applaud each and every one of our associates for the incredible work that has brought us to this point in our company's history.
As I mentioned, fiscal 2017 was a record sales and earnings year on the heels of a record fiscal 2016. In 2017, our associates and suppliers We also welcome 2 new teams to The Home Depot family through the acquisitions of Compact Power and the company store. All of this was accomplished during a time marked by a high degree of change in our business as we respond to the rapidly evolving retail environment. As they always do, our associates continue to adapt to these changes while consistently delivering outstanding customer service. Today, our Board announced a 15.7% increase in our quarterly dividend to $1.03 per share.
We remain committed to maintaining disciplined capital allocation to create value for our shareholders. Turning to 2018 and beyond, I'm very excited about the opportunities that are ahead of us. Kara will take you through the details, We expect 2018 to be another year of growth with expected sales growth of approximately 6.5% and diluted earnings per share of approximately $9.31 At our investor conference in December, we outlined our 3 year financial Today, we are reaffirming our investment strategy and our 2020 targets to grow sales as high as $120,000,000,000 With operating margin as high as 15% and we are updating our return on invested capital target to now more than 40%. One of the areas that we're investing in is our associates. And in the Q4, we did just that.
We recognized associates through Success Sharing, our profit sharing program for our hourly associates. For the second half of the year, 99% of our stores qualified for success sharing. Beyond success sharing, we were pleased to be able to pay out an incremental one Time bonus to our Ollie associates in light of tax reform. Together, this was an investment in our associates of more than $240,000,000 in the back half of the year. I want to close by thanking All of our associates for their hard work and dedication to our customers in the Q4 and throughout the year.
We look forward to continuing this momentum in 2018. And with that, let me turn the call over to Ted. Thanks, Craig, and good morning, everyone. We had a strong Q4 as sales exceeded our expectations. We saw strength across the store led by our pro customer and our online sales continued their double digit growth.
Looking at our departments, lumber, electrical and tools had double digit comps in the quarter. Appliances, plumbing and building materials were also above the company's average comp. Decor, flooring, millwork, Paint, indoor garden, hardware, outdoor garden and kitchen and bath were positive but below the company average. Lighting recorded a low single digit negative comp, primarily due to LED price deflation. In the Q4, we saw growth in both ticket and transactions.
Comp average ticket increased 5.5% and comp transactions increased 1.9%. Commodity price inflation in lumber, building materials and copper positively impacted average ticket growth by approximately 105 basis points. Foreign exchange rates also positively impacted average ticket growth by approximately 42 basis points. Big ticket sales in the 4th quarter were transactions over $900 which represent approximately 22% of our U. S.
Sales, were up 9.8%. The increase in big ticket sales was driven in part by strength in vinyl plank flooring, fencing and appliances. Transactions for tickets under $50 which make up approximately 16% of our U. S. Sales, grew by 0.8% in the quarter.
In the Q4, we saw strong sales with both our DIY and pro customers. Sales to our professional customers doubled digits in the quarter. Pro heavy categories such as lumber, pressure treated decking, insulation and gypsum All had double digit growth during the quarter with solid unit productivity. Our paint initiatives continue to gain traction as we saw strong sales to both our pro and DIY customers throughout the quarter. Turning to our DIY customers, We saw a terrific response to our events throughout the quarter.
Traffic was strong both in store and online during our Black Friday Give Center and Holiday Events. During the quarter, our DIY customers drove strong comps in power tools, hand tools, Rugs, Appliances and Decorative Holiday. We also continue to see strength in storm related categories in the quarter with double digit comps in generators, wetdryvacs and portable heating. As part of our focus on balancing the art and science Retail. We continue to refine and localize our assortments.
Recent example is with our hardscapes category, which includes pavers, wall block and Landscape Rock. We are leveraging the power of our clustering and space optimization tools to assign assortments and facings at a local store level. As a result, we have been able to optimize on shelf inventory levels to provide job lot quantities for our customers, minimize shelf maintenance for our store associates and maintain a meaningful and innovative assortment. Initial results in warm weather markets have been strong. Now let me turn our attention to the Q1.
Product innovation and speed to market allow The Home Depot to maintain its position as the number one retailer in product authority in home improvement. To that end, our merchants are constantly collaborating with our suppliers to deliver new products exclusively to The Home Depot. For example, we have recently updated our assortment of Klein tools for professional electricians. This includes the new 9 inches Journeyman Diagonal Cutting Pliers that provide 57% more cutting surface and a new magnetizer tool that is great when needing to magnetize the screwdriver or bit. The addition of these new products to our existing assortment Big box exclusive client tools keeps us winning with the electrician.
With spring quickly approaching, We are gearing up to fulfill the needs of our customers as they complete their outdoor projects and get ready to enjoy the warm weather. In addition to our annual spring Black Friday event, we are excited about our new patio set offerings, which provide customers great value across a wide selection to fit New this year as part of our exclusive Hampton Bay collection, we are offering CushionGuard technology, which guarantees water repellency as well as protection from fading and stains. This gives our customers peace of mind and reassurance that they are purchasing quality material at an everyday low price. With that, I'd like to turn the call over to Carol.
Thank you, Ted, and good morning, everyone. In the 4th quarter, total sales were $23,900,000,000 an increase of 7.5 percent Versus last year, a weaker U. S. Dollar positively impacted total sales growth 4.5%. Additionally, We estimate that hurricane related sales positively impacted total company sales growth in the quarter by 1.7% for $380,000,000 Our total company comps or same store sales were positive 7.5% for the quarter with positive comps of 8.3 percent in November, 11.5% in December and 3.1% in January.
Comps for U. S. Stores were positive 7.2% for the quarter with positive comps of 8.2% in November, 11.4% in December and 2.5% in January. Our monthly comps were distorted by the timing of Christmas. This year, the Christmas holiday fell in our fiscal January rather than December.
Adjusting for this timing shift, Our total company comps would have been 8.3% in November, 8.5% in and 5.8 percent in January. For fiscal 2017, our sales increased 6.7% to $100,900,000,000 and total company comp sales were positive 6.8%. Comps for U. S. Stores were positive 6.9%.
During the year, foreign exchange rates positively impacted total sales growth by approximately $67,000,000 or 0.1%. In the 4th quarter, Our gross margin was 33.9%, a decline of 12 basis points from last year. We attribute the modest Decline in our gross margin, primarily the lower margin hurricane related sales. For the year, We experienced 11 basis points of gross margin contraction in line with our plan. In the 4th quarter, Operating expense as a percent of sales decreased by 30 basis points to 20.5%.
Our expense leverage was driven primarily by our strong sales performance. During the quarter, we had a few expenses that we did not plan. First, as a result of the one time cash bonus stemming from tax reform, $117,000,000 of incremental expense and we incurred approximately $66,000,000 of hurricane related expenses. Fiscal 2017 operating expense as a percent of sales was 19.5%, a decrease of 47 basis points from last year. For the year, our expenses grew at approximately 63% of our sales growth rate.
Ignoring hurricane related sales and expenses and backing out the one time bonus, our expenses grew at approximately 45% of our sales growth rate in fiscal 2017. Our operating margin for the Q4 was 13.4% and for the year was 14.6%. Interest and other expense for the Q4 grew by $11,000,000 In the Q4, our effective tax rate was 39.6% compared to 35.2% in the Q4 of fiscal 20 In the Q4, we recorded a net tax expense of approximately $127,000,000 resulting from tax reform. While this is a provisional charge, it was slightly better than our initial estimate. Our diluted earnings per share for the Q4 were $1.52 an increase of 5.6% from last year.
For the year, diluted earnings per share were $7.29 an increase of 13% compared to fiscal 2016. Our 4th quarter and fiscal 2017 diluted earnings per share were negatively impacted by approximately $0.17 due to the one time bonus and net tax expense previously mentioned. Now moving on to some additional highlights. During the fiscal year, we opened 6 new stores, including 3 in the U. S.
And 3 in Mexico for an ending store count of 2,284. Selling square footage at the end of the year was 237,000,000 square feet. For the fiscal year, total sales per square foot increased 6.7 percent to $4.17 the highest level since fiscal 1999. At the end of the quarter, merchandise inventories were $12,700,000,000 up $199,000,000 from last year. Inventory turns were 5.1x, up from 4.9x last year.
Moving on to capital allocation. In fiscal 2017, we generated approximately $12,300,000,000 of cash from the business and used that cash as well as proceeds from $3,300,000,000 of both short and long term debt issuances to invest in the business, We purchased our shares and paid dividends to our shareholders. During the year, we invested approximately $2,300,000,000 back into through capital expenditures and acquisitions. Further, we repurchased approximately $8,000,000,000 or about 49,500,000 of our outstanding shares, including roughly $2,100,000,000 or 11,500,000 shares in the 4th quarter. Finally, during the year, we paid $4,200,000,000 in dividends.
Today's press release includes our guidance for fiscal 2018, and I want to take a few moments to comment on the highlights. Remember that we got off of GAAP, so fiscal 2018 guidance will launch from our reported results for fiscal 2017. There are a few things to keep in mind when thinking about our fiscal 2018 will include a 53rd week. So the Q4 of fiscal 2018 will consist of 14 weeks. We will continue to report comps on a 52 week basis, but we will base our overall guidance on 53 weeks.
2nd, beginning in the Q1 of fiscal 2018, we will adopt ASU 20 fourteen-nine, which addresses revenue recognition. This accounting standard will not have a material impact on our sales or our operating margin guidance, But it will change the geography of certain items on our income statements. Our guidance today does not incorporate this new standard. We will give you a more detailed update during our Q1 conference call in May. Finally, our guidance incorporates investment plans we laid out in December and the impact of tax reform.
So with that, let's zoom out and look at the macro environment. The U. S. Economy is strong and tax reform is net positive for the housing industry. We expect higher job growth, Higher income growth and yes, higher mortgage rates.
But with that comes higher home price appreciation and rising housing demand, which should drive home improvement spending. For fiscal 2018, we expect sales to grow approximately 6.5% with the extra week adding approximately $1,600,000,000 in sales. During fiscal 2018, We expect total company comp sales of approximately 5%, and we're planning to open 3 new stores. For fiscal 2018, we are projecting our gross margin rate to be about the same as it was in fiscal 2017, reflecting for the most part the benefit of the extra week. As we discussed during our December investor conference, We have a number of investments planned, which will cause our expense growth factor to be higher than what it's been in the past.
Further, with tax reform, we have elected to pull some of the investments forward into fiscal 2018. We expect our 2018 operating expenses to grow a little more than 100% of our sales growth rate. For the year, we expect that our operating margin will be approximately 14.5 percent with the extra week adding approximately $300,000,000 in operating profit. For fiscal 2018, incorporating tax reform, We estimate our effective tax rate to be approximately 26%. We expect fiscal 2018 diluted earnings per share to grow approximately 28 percent to $9.31 with the 53rd week contributing approximately $0.19 Our earnings per share guidance includes our plan to repurchase approximately $4,000,000,000 of outstanding shares during the year.
For the year, we project cash flow from the business of roughly $14,100,000,000 which includes about $1,800,000,000 of cash resulting from tax reform. We will invest $2,500,000,000 of this cash back into the business in support of the strategic initiatives we outlined at our investor conference. We will also use this cash to pay $4,800,000,000 of dividends. As Craig mentioned, we just announced a 15.7% increase in our quarterly dividend, which equates to an annual dividend of $4.12 in line with our targeted dividend payout ratio of 55 percent of earnings. Finally, we will repurchase $4,000,000,000 of outstanding shares.
Note that this is a preliminary share repurchase target and may be adjusted throughout the year. At our investor conference in December, we shared with you our long term financial targets and our strategy to create 1 Home Depot. Over the next 3 years, we will nearly double our investments into the business to enhance the customer experience, Invest for the future and create value. Today, we are reaffirming and updating our long term targets. By fiscal 2020, we are aiming to grow our sales to a range of $115,000,000,000 to $120,000,000,000 With an operating margin of 14.4% to 15%, reflecting the impact of tax reform and a resulting higher net operating profit after tax.
We now believe our return on invested capital in fiscal 2020 will be more than 40%. So we thank you for your participation in today's call. And Abby, we are now ready for questions.
Thank you. We will take our first question from Simeon Gutman with Morgan Stanley, please go ahead.
Thanks. Good morning, everyone, and congratulations, Diane. My first question is on the top line in the 4th quarter. You're recycling 2 warm winters, and I realize the hurricane was some benefit in the quarter. But if you look at the underlying run rate of the business, Is there anything to glean like the business the fact that some of these categories are still hanging in despite you've had more normalized weather, Does that mean we should see an even stronger spring when we get there?
I think overall, we're first of all very pleased with the Performance in the quarter, both across categories as well as geographies. To your point, we definitely had benefit from Hurricane recovery sales partially offset by actually a real winner in January this year. Carol, you might want to share just how we've made up the Q4.
Yes. So we were really pleased with the results in the Q4. Clearly, the Our team sales were higher than what we had included in our guidance at the end of the 3rd quarter. So we were pleased with that. But the business, just the underlying business was very strong.
As Craig pointed out, we had winter. And if you look at the month of January alone and the comps across our divisions, The comp in the Western division and the Southern division in the month of January was higher than the comp for the company for the quarter. Now in the North where we had real winter and I think you experienced that winter, our comp was low single digit as you expected. So what does that mean? You should have a pretty good spring, I would think, when you have a normal winter.
Okay. And then my second question, looking at The housing market in total and then maybe looking at the market color that you guys have. In more mature markets where the housing market It's already recovered. Can you talk about any trends, good or bad? And then alternatively, in less mature recovery markets, anything that you're seeing that's encouraging about
Yes. So as Craig mentioned, if you look at the variability in our regions, the Spread was a bit wider than we've seen in the past several quarters, but that's because of the hurricane related sales where we had High, high double digit comps. So if you ignore the hurricane related sales, you actually see the variability tight And that's actually because the economic environment in the cities that have recovered is robust And there is a housing shortage. So let's take a look at San Francisco, for example. San Francisco is very robust.
The month of supply in San Francisco are close to 1, so we continue to see strong growth there. And areas of the countries that Haven't fully recovered. Well, good news there too. So housing as an asset class across the country continues to look very good.
I'll take one other comment on that. If you look at a market like Dallas, which has had tremendous growth in Home value appreciations, the affordability index is still terrific. So we're looking at housing continuing to be a tailwind for
Okay. Thank you very much.
We will take our Question from Brian Nagel with Oppenheimer. Please go ahead.
Hi, good morning. Nice quarter.
Thank you.
Congratulations, Diane. So I'd like to just follow-up quickly on Simeon's question on hurricane. So if
we look at the cadence of the business over
the last couple of quarters, it seems like you actually got a bigger benefit from the hurricanes here in the Q4, which was a little surprising to us. Any new insights and as you're watching these sales come through As to how long these benefits could persist into 2018?
Yes.
So overall, The Q4 was almost comparable to the Q3 in terms of total benefit, which as Carol mentioned, 4th quarter was slightly Stronger than what we had anticipated. When we look at the go forward in the business for 2018, We expect the sales from hurricanes to be somewhat comparable to what we experienced in 2017 overall and most of that coming in the first half of the year.
Right. So just to put the numbers behind that, we had we believe we had $662,000,000 of hurricane related sales in the back half of twenty 17. And we expect to have that same number of sales in 2018. The difference of course is that the 20 2018 sales will be a little bit more profitable than what we experienced in 2017. In fact, when you add it all up, we lost money on those sales.
We lost $11,000,000 on those sales in 2017. We expect to spend a little bit of money on those sales in 2018.
Got it. Then my follow-up question, Carol, you mentioned in your prepared comments just the, I guess, the pull forward a bit in the cadence of investments that you laid out in the Analyst Day, Now the tax legislation was passed. Any more color on specifically what investments you're pulling forward earlier? And then how should we think about With that, the potential return on those investments.
Yes, happy to. So let me just give you a breakdown of our expense growth factor guidance for 2018. Our core expenses will grow at about 45% of our sales growth next year. We add to that then about 10% related to acquisitions. As we've talked in the past, our acquisitions I have more variable expenses than our core.
So when you add up core and acquisitions, expenses growing at 55% of our sales growth. Then the investments that we're making add another 46 plus, so that our expenses will be a little more than 100% of our sales and 2018. What are we pulling forward? Well, if you remember the pie chart that we shared with you at our Investor Day and we showed Buckets of expense. 1 of the buckets of expense was a bucket called other.
And in that bucket called other were People expenses. So we are pulling forward some of those people expenses because those are easy things to do. Some of the other investments that we're making, it takes time. Like we've talked to you about supply chain as an example, our supply chain initiative is actually a 5 year initiative.
Thank you.
Our next question comes from Mike Baker with Deutsche Bank. Please go ahead.
Hi, thanks.
Two questions. 1, can you explain the calendar shift in a little bit more detail, December versus January? How does Christmas end up in January? And then I guess related to that, even when you make that adjustment, January does seem to have been A little bit softer, but is that just the winter weather?
Yes. So Michael, it's just our accounting convention. We have a 4, 4, 5 close And it's just when Christmas Day falls and Christmas this year was a Sunday or Monday, anyway, it just fell into another month. So it's just calendar. That's all it is.
In terms of our January comp, yes, even on an adjusted basis, it was lower than the previous 2 months, but we had a winner In January, as I mentioned, our Western division, our Southern division in the month of January comps higher than the company average for the quarter.
One follow-up, rates doesn't seem like it's an issue yet, but I think in the past you've given some color Where is that sort of break point where we start to become worried about rates either measured on a 10 year bond or 30 year fixed mortgage or however you look at it?
Yes. So, 30 year rates today are 4.2%. The consensus estimate for 2018 is 4.3%. I've seen a high estimate out there of 4.6%. But to just put it into perspective, our math suggests that for every 25 basis Mortgage rate increase is $40 of additional mortgage interest per month.
So we don't see any concern with the rising interest rate over the next several years actually. Remember that historical 30 net mortgages 5.6%. And as Craig commented, the affordability index, broadly speaking, is still very good at over 155%.
Okay, very good. Appreciate the color. Thank you.
Thank you.
Our next question comes from Michael Lasser with UBS. Please go ahead.
Good morning. Thanks a lot for taking my question and congratulations, Diane. As we look out over the course, Should we expect to see the composition of your same store sales change at all, particularly as you make more ecom investments And your ecom mix just comprises a bigger percentage of the total or as you've said in the past, Can we expect half coming from ticket and half coming from traffic?
Yes. We still look at it On a split of roughly fifty-fifty over time coming from ticket and traffic overall. From departments, we still have opportunity in larger ticket building materials, special orbit kitchens, Lumber, while lumber is certainly run up in price, the project Still growing and we still have significant opportunities. So from a department perspective, we'd see more Continued growth in those departments.
And Ted, is there anything to read into about the performance of the lighting category? The price deflation in LED has been happening for a long time. Could it be now that the category has just reached either a maturity point We're now starting to shift more online.
Yes. We see the price deflation continuing into 2018, and we Plan for meaningful deflation to continue throughout 2018.
There's some good news with price deflation, because we are relamping our And it was a good thing that we waited for this investment because the cost curve is coming down. So, glad to have a little here.
Thank you so
much. Yes.
Our next question comes from Seth Sigman with Credit Suisse. Please go ahead.
Thanks a lot and good morning and nice quarter. And of course, Diane, congrats. I just want to follow-up on the gross margin outlook for flattish in 2018. I'm wondering if you can reconcile that with the longer term guidance that calls for, I think it was a decline of 40 basis points over the next 3 years. And related to that, presumably freight and mix could still be headwinds as you look into 2018.
What are you assuming as other offsets in there? Thank you.
Yes. So we've guided gross margin flattish for the year. That includes the 53rd week. The margin in that 53rd week will be Because it doesn't have as much fixed costs allocated to it. So if you ignore the 53rd week, The gross margin for the business would be down, call it, 7 ish basis points.
We have factored into our outlook A tightening transportation market, higher fuel costs, a lot of that's gotten better recently. We're going to have to stay close to this. We've got lots of cost out opportunities that we will certainly drive. The transportation market is tightening, so we might have a little pressure there, but we'll manage through it.
Okay. And then a question on the delivery from store initiative. I It's been in the stores for over a year now. Can you speak about the performance, the types of pros that are utilizing it? And if you're seeing Actually, new customers come in or is it just driving share of existing pros wallet?
Thank you.
Sure, Seth. I'll comment. We're very pleased actually with the growth overall in delivery and we're seeing that happen both with our pro and with our consumer. And Mark is here and I'll let him comment.
Yes. We're seeing the same kind of mix of pro and consumer that we see across for business. We're very pleased that that store based delivery continues to grow. One highlight there, we're continuing to roll out The car and van lower cost delivery options to more markets as we go including our home market Atlanta now. So expect to have that rolled By spring, to all the major markets.
And the question always is incrementality. And based on our analysis, we're driving incremental growth here.
Very helpful. Thank you. Good luck. Thanks.
Our next question comes from Matt Fassler with Goldman Sachs. Please go ahead.
Thanks a lot. Good morning, Diane. Thanks so much for all your years and Isabelle, welcome back to you. I want to start with a quick follow-up for Carol. You gave the adjusted comps on a monthly basis for the total company.
Do you have December, January numbers for the U. S. Stores alone?
It's a 300 basis point shift. So you can just do that math.
Great. My next question, if you talk about the transactions under $50 I mean, we're used at this point to The bigger ticket transaction is growing at or close to double digit and the smaller ticket transactions growing low singles. Are those transactions being Subsumed by in other visits, I. E. The visits are coming down and that's just reflected in a bigger ticket.
Is it a question of market share or is it a question of that business being done online? How would you how should we think about that trend in the small ticket business?
Now we've actually done some work in this area. And I would start with a comment that this has Details of this, but we're actually pleased with what we're seeing.
We are. So we took our ticket and broken into quintel. And if you look at the bottom quintel, we see Price has jumped through innovation and inflation 11% over the past couple of years. It's moving out of that less than $50 bucket into a higher bucket. The other contributor is price deflation and LED light bulbs.
LED light bulbs would be in that particular bucket. So it's just a change in the business model and we're reacting to that change.
Great. Thank you so much, guys.
Our next question comes from Chuck Grom with Gordon Haskett. Please go ahead.
Hi, thanks. Just a quick modeling question, just on the expense growth factor of slightly north of 100%. Should we expect that to be pretty even Throughout the year by quarter or are you expecting any lumpiness throughout the year?
It will be lumpy. It will be higher in the First half of the year, then in the back half of the year, because in the back half of the year of 'seventeen, we had hurricane related expenses that will not repeat.
Okay, helpful. And then just historically, when you have the type of winner that you guys Are going through this, Sharon, and us as well. Can you just remind us how the business tends to pick back up in the spring based on your historical experience?
Well, it totally is dependent on when spring actually breaks. And that is that can happen Earlier, it can happen late. Mother Nature will control that. But what we do see from that type of activity As generally you'll see when you have a harsh winter, you've got a lot of garden opportunity with replacement of shrubs. You have Ice damage that takes place in Raffin.
So there's different types of elements within the business that will actually see a benefit from a hard winter.
Okay. Thank you.
Our next question comes from Elizabeth Suzuki with Bank of America Merrill Lynch. Please go ahead.
Hi, good morning. Just generally, when costs are rising, Transportation, labor, general inflation, etcetera, how much of these cost increases are you able to pass through to the consumer?
Well, first of all, in each situation, with cost in our first cost of Good. We look at that on a case by case basis and work with our suppliers to help them try to minimize as many impacts as we possibly can. And then candidly, we look at our portfolio approach to how we actually deal with that. And so cost May not necessarily go into a category where we may absorb some cost. It could go somewhere else.
And we obviously look to offset that within our own business to try to hold value for the customer.
All right, great. Thank you.
Our next question comes from Dennis McGill with Zelman and Associates. Please go ahead.
Hi, good morning. Thank you, everybody. Carol, first question from the Investor Day, I think you talked about the investments hopefully adding somewhere in the neighborhood of, I think it was 50 200 basis points to same store sales growth. How did you think about the benefit in 2018 when you formed the plan?
Yes. So not a lot of benefit in 2018. And if you think about we talked about $11,100,000,000 investment over the next 3 years. We're going to kind of wrap up. So you're going to see more of the return in back half of the 3 year planning than you do in the initial part of the 3 year plan.
Okay. Thank you. And then second question, when you talk about the cash flow from the business and then look at the guidance for share repurchases, can you just maybe talk about how you thought about getting to that $4,000,000,000 number, especially with repatriation being an opportunity? And maybe also just update us on Where that stands as far as getting that cash back?
Yes. So based on the cash flow guidance that we've given you and the use of cash, They're like, wow, you can have some leftover cash and that's right, we are. And we are exploring what to do with that cash And it could be additional share repurchases, dividends, payback debt, build cash for the future, so on and so forth. We're going to take our time to take through this year separately and as we determine what we will do with the cash, we will let you know. The $4,000,000,000 specifically is what we had on our Investor Day.
So we just kept that for the year and then we'll update you as the year continues.
Our next question comes from Scott Ciccarelli with RBC Capital Markets. Please go ahead.
Good morning, everyone. Carol, I don't know if this was answered earlier. You did. I apologize and I missed it. But what is the mortgage rate that you think starts to adversely impact home pricing trends?
And then related to that, Real estate is a very localized industry, but do you have thoughts regarding the potential impact on home prices in affected areas?
Yes. So let's look at the latter part of your question first. 80% of American households are going to have more money this year because of tax reform, given the increase in standard deduction. Further, corporations are enjoying many corporations are enjoying lower taxes and We see many corporations taking that cash, if you will, and investing in the
people, like their Home Depot. We think those
offset any negative that could arise with the change in the mortgage interest deduction or the cap on state and local tax deductions. And just a few other things. On the cap on mortgage interest deduction, dollars 700 Only 5% of houses that are sold in a year are $750,000 or so, it's a small subset of what happens in the housing Heather, as we've talked about, playing about 30% of tax filers itemized and only about 22% of them itemized for mortgage deductions. On the state and local tax front, if you live in California or New York, you're not going to feel very good, but Then there's a housing shortage. I commented on San Francisco with 0.8 months of supply.
New York City has 2.2 months of supply. We don't actually think there's going to be any impact on housing as a result, although if you live in New York or California, you may feel it. Now on mortgage rates, you can't just look at mortgage rates alone, because you have to look at where home prices are going to look at affordability. But if you just kept home prices where they are today, it's our view that mortgage rates could go to 7% before there's any issue on the affordability. The other way of thinking is just averages, right?
And the average mortgage rate over the past 30 years is 5.6%. So that might be a good number for us all to kind of To land on.
Got it. Okay. Thank you very much.
Our next question comes from Alan Ken with BTIG. Please go ahead.
Thank you. Congratulations, Diane, on your retirement and welcome back, Isabelle. So shortly before the tax reform was passed, you laid out your 3 year goals and presumably there are going to be incremental investment from the tax savings. Why is that and obviously those that will result in increased returns. My question is, why is there no change to the 3 year 2020 guidance if the returns by that point
So Alan, we're actually not looking to do incremental investment Beyond what we shared, dollars 11,100,000,000 over 3 years is what we believe that we need to do. And there's a Kind of, if you will, a durability factor to making that all happen. So there's not really the opportunity to add a whole bunch of new investment on As Carol mentioned, we are pulling some investments forward that we can do and make it happen faster, But don't look for us to add a whole new layer of investment on top of the 11,100,000,000
Okay. Thank you, Craig. And a follow-up, if I may. I believe you said that the flooring category, while comping positive, was below the corporate average. It seems like For the first time in many quarters, that is the case.
I was curious if you could provide some color as to what is going on in that category in your opinion.
We're very pleased with the performance. You have to remember, Alan, the average set is 7.5%. So It's very healthy across the flooring portfolio.
Okay. Thank you very much.
Our next question comes from Christopher Horvers with JPMorgan. Please go ahead.
Thanks and good morning. So following up on The SG and A to sales growth rate, you guided over the 3 years 75% to 90%. Is the pull Forward mainly from 2019 into 2018 and how should we think about the cadence of that 75% to 90% as we look past this year, is 2019 thus lower as a result?
We pull forward both from 2019 2020. So we'll update you on 2019 2020 guidance when we get to those 2 years, but nothing changes from the overall expense growth factor guidance that we gave you back in December.
Understood. And as you think about how robust the backdrop here is in home improvement, has there been any changes in terms of the promotional environment, is it seems like some prices being passed through here, is it becoming less promotional or any change at all sequentially?
I don't think there's been a significant change in the promotional activity. If anything, we were Less promotional in Q4, but the overall market was very similar to prior year.
Thanks very much. Have a great spring.
Thank you.
Our next question comes from Eric Baccard with Cleveland Research Company. Please go ahead.
Good morning. In terms of pro and online, I'm just curious what you learned or any Big learnings from those two areas in 2017 and then how you think about the growth rate in 2018 relative to 2017 in those areas?
So overall, we were very pleased with our pro business in 2017 And we continue to see growth there. And as customers continue to take on bigger projects As a result of feeling good about their home values, we see that continuing as we move into to 2018.
So I don't know if you
have any other comments on
that. Eric, I'd say the other learning is that the more dimensional our relationship with our pro is the stronger our share of wallet And I think that was exemplified by the PROs that are managed by our POSAs, which was one of our fastest growing areas for our Pro So it's that pro engagement and that 1 on 1 recognition that seems to be resonating with the customer and we will carry that into next year.
And as it relates to online, again, very pleased with what the team was able to accomplish in our online business, Setting in a whole new platform that we operate on, enhancing our capabilities around search and mobile. And Kevin is here. I'll let him speak to how we're thinking about 'eighteen.
Yes. And certainly from a learning perspective, it just reinforced What we've been chasing, chasing the customer and wherever they lead us, we invested significantly to eliminate a lot of friction between The different channels as we pursue our One Home Depot strategy, investing in expertise and knowledge and the online property. You'll see more of that in 2018 with similar growth aspirations. We've got A consistent track record of over $1,000,000,000 of growth in each of the last few years in our online property, and we'll look to do that again in 'eighteen.
And then one follow-up question. The inventory progress, inventory leverage was solid in 2017. The two points within that, what contributed to that and how should we think about the path of that moving forward?
Well, we were very pleased with our overall inventory position as we came through the Q4 and finished the fiscal year. Our primary focus when it comes to inventory is to maintain in stock. That is first and foremost, so that we have what the
Right, Craig. I mean customer service Begins with in stock, so that's always the top initiative, but we'd expect to continue to leverage inventory as our content business continues to grow in the core. We'll be making some investments as we open new distribution facilities for online, but we continue to expect to leverage our inventory.
Yes. So if you just want to model it, model inventory turnaround 5.3x.
Great. Thank you.
Abby, we have time for one more question.
Okay. Our last question will come from Daniel Binder with Jefferies. Please go ahead.
Great. Thank you. Just on the pro, I was wondering if you could talk a little bit about that gap Between DIY and Pro, I know it's been consistently growing faster than DIY. Is that accelerating? And then could you also talk a little bit about the interline trends.
Well, Danny, I think the one thing that we're seeing is there's a little cloudiness in where the actual Purchases are coming from. In some cases, you're seeing people that had DIY projects that are now electing their pros to go and do both The purchase and the work. So but we're very pleased with the DIY growth and seeing strength with our consumer business as well as the Pro. So there's a good balance there. And then as far as Interline, we're pleased with the progress, pleased with the results.
We saw strong sales growth in all three end markets institutional, multifamily and trades continue to see traction in Pro purchase and the MRO initiatives, so pleased with the progress.
And maybe one difference that we are seeing is the rate of growth
And then one follow-up, if
I could, on merchandising. One of the emerging trends we've seen out there obviously is connected home. Just wondering when we'll see more from Home Depot on that. It seems like you're pretty well positioned to capitalize on it, but maybe a little bit further behind Some other players in the electronics space on that area of the business.
Yes, we're rolling out Some more dedicated end caps and 12 and even 3 base sets as the amount of connected Home product comes into the store. We're super excited. There's new product coming from Ring. There's new product coming from Nesk. There's new product on light and fan controls by Lutron.
So really across the board, all our major suppliers are I think the other thing that you'll see is Just in general, in every bay in the store where there's an opportunity to have Product that is enabled through technology, you'll see that happen over the next 5 years. It will continue to evolve and it won't be so much a Section over the next 5 years, it will be in every day in the store. That will happen Because the manufacturers are finding ways to enhance their product for the customer.
Great. Thanks.
Well, thank you everyone for joining us today and we look forward to talking to you on our Q1 call in May.
Ladies and gentlemen, this does conclude today's call and we thank you for your participation. You may now disconnect.