Deciphering WWD by creating 2 excel charts

INSTRUCTIONS

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

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 so numbers are uniform. 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

QUESTION

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.