Showing posts with label AMZN. Show all posts
Showing posts with label AMZN. Show all posts

Saturday, November 30, 2024

Retail Inventory Status - 2024 Holiday Season

 The 2024 holiday shopping season has officially started with Black Friday on November 29. I want to get answers to a couple of questions:

  • How much inventory did U.S. retailers carry coming into this holiday season?
  • How has this inventory increased or decreased since last year?

Retailers are enjoying the benefits of robust economic growth and low unemployment. At the end of October, the unemployment rate stood at 4.1%, and inflation was 2.6%. Inflation has come down dramatically since a dramatic increase in 2021 and 2022. Since inflation affects inventory costs, the data shows a dramatic increase in inventory held on a company's balance sheet in 2020 and 2021. The initial demand shock of 2020 during March quickly turned into a supply shock as demand skyrocketed as stimulus was rolled out. The increased demand and supply chain constraints likely increased the costs of procuring inventory.

Amazon, for example, saw a steep 30% increase in inventory costs between 2020 and 2021 and another 18% increase in 2023 (Exhibit 1). In 2024, the company only showed a modest 1.9% increase in its inventory. Amazon has a massive number of third-party sellers on its marketplace, and their inventory is not included in Amazon's balance sheet.

Exhibit 1: Amazon's Inventory Costs in its Balance Sheet.

Amazon Inventory Costs
SEC, Snowflake Cortex Analyst, Excel

Similarly, Walmart saw a double-digit increase in its inventory costs in 2021 and 2022 but showed a 1.9% decrease in 2024 compared to 2023 (Exhibit 2). However, Walmart's data is for the fiscal period ending July 2024.

Exhibit 2: Walmart's Inventory Costs.

SEC, Snowflake Cortex Analyst, Excel

Among the big three retailers, Amazon, Walmart, and Costco, Costco has increased its inventory by a double-digit rate going into the 2024 holiday season (Exhibit 3). However, Costco has an excellent inventory turnover practice, so it will quickly convert its inventory into cash. Costco typically only carries 30 days of sales in inventory, the lowest among these three retailers. You can read more about Costco here.

Exhibit 3: Costco's Inventory Costs.

SEC, Snowflake Cortex Analyst, Excel

I looked at the inventory for a few other retail companies, including Dick's Sporting Goods, Deckers Outdoor, Home Depot, Lowe's, Burlington Stores, and Autozone (Exhibit 4). Most of these companies are coming into this holiday season with a mid-to-upper single-digit increase in inventory compared to last year. Lowe's is being cautious, with almost no change in inventory since 2023. Dick's Sporting Goods has the highest inventory cost increase of 13% over 2023.

Exhibit 4: Inventory Costs of Various Other Retailers.

SEC, Snowflake Cortex Analyst, Excel

Inventory costs are normalizing across the board for retailers after the tumult caused by the pandemic. Dick's Sporting Goods increase in inventory costs is a bit worrying, followed by Burlington Stores, Deckers Outdoor, and Autozone. They are hoping for a strong holiday season.

I generated the SQL using Snowflake Cortex Analyst. Cortex Analyst is a massive productivity booster that takes just a little time to get started. Snowflake is one of the most accessible data platforms for businesses to gain insights quickly. You can try it here.

Disclosures: I am a Sales Engineer at Snowflake. All opinions in this blog post are solely mine and do not reflect Snowflake's views. I am not a Registered Investment Advisor, and any discussion on securities or investments is not an inducement to make a particular investment.

Wednesday, July 29, 2020

Big Tech is Taking a Break From the Rally

    Both Apple (AAPL) and Microsoft (MSFT) are trading below its 10-day moving average. Apple is down from its 52-week high of $399.82 and currently trades at $380.16. That's a drop from the 52-week high of - 4.97%. Apple's 10-day moving average is 382.436 (Tuesday, July 28, 2020). Microsoft is down from $216.38 to $204.06 that's a -5.6% change. Its 10-day moving average is $202.15. Amazon (AMZN), Facebook (FB), and Alphabet (GOOG) are all trading below their 10-day moving average. Out of this cohort only Facebook is trading below its 50-day moving average. 

Exhibit: Big Tech's Downturn has Started. When will it end? 


(Source: SECURFII)


    Microsoft has gained 53% from its lows in March 2020. Apple has gained 76% form its March 2020 lows.  The gains have been spectacular. Google has gained 50% from its March lows. Amazon has gained nearly 82% from its March 2020 lows.     

    It seems like all these stocks are starting a downward trend after the huge run-up they have had over the last few years and the rebound they have had since the pandemic induced crash of March 2020.           

How Much Does Coca-Cola Spend on Advertising?

Coke's AI Generated Ad (Source: WSJ.com) Ads are meant to evoke a reaction, an emotion, and an action. Great ads can bring you t...