Assignment Detail

Assignment ID: FG133233284

Deciphering WWD

Reconfigure the financial information in this text so that it is easier to understand by putting it into simple EXCEL charts. You will have to calculate some of the figures implied but not stated in this text in order to make the chart complete. You may use the formula sheet. You will not have to do any research for this homework. The information to chart is all self-contained.

Rules to follow – 1. This year goes before last year TY/LY. 2. Sales are always top line, profit bottom line. 3. Always include the % increase or decrease after TY/LY numbers. 4. Label all charts clearly. 5. Create a key in Millions or billions so numbers are uniform. Make sure you read the textbook before completing. (pg 65)

Lululemon 3rd quarter sales beat expectations despite Covid 19 and store closures! Huge penetration increase in Direct to consumer sales for 2020!

Key in Millions

Lululemon beat 3rd quarter SALES estimates on Thursday, as customers spent more on yoga pants and athleisure apparel for home workouts during the COVID-19 pandemic.

Net sales rose 22% over last year to $1,120.0 billion in the third quarter ending Nov.1, 2020. Net profit also surprised with an 24% increase in the 3rd quarter. Compared to 115.8 million from 2019.

For the first half of the year 2020 lululemon reported net profit of $169.9 million vs. $199.0 million from the year before. Sales decreased 6.6% from 1,665.0 billion in 2019.

Separate Chart

3RD QUARTER 2020 DIRECT TO CONSUMER (DTC) NET SALES REPRESENTED 42.8% OF TOTAL NET SALES COMPARED TO 26.9% FOR Q3 OF FISCAL 2019 . This compares to 58.2% of net SALES when stores were closed in the first half of 2020 compared to 24.6% in the first half of 2019. – Source text for Eikon: