Hi I need an excel sheet, I will attach the instructions followed by the formula sheet.

Instructions:

Reconfigure the financial information in this text so that it is easier to understandby putting it into a simpleEXCEL chart.You will probably have tocalculate some of the figures implied but not stated in this textin order to make the chart complete. You may use the formula sheet. The information to chart is all self-contained.

Rules to follow - 1. This year goes before last year. 2. Sales are top line, profit bottom line. 3. Always include the % increase from TY/LY. 4. Label. 5. Create key so numbers are uniform. Make sure you read the text before completing. 6. Remember to look at the 4-5-4 calendar posted for yearend dates.

Zara parent Inditex sales hit record; profit rises 2/2019

LISBON-- Inditex SA, the retailer behind the Zara fast-fashion chain, on Wednesday reported a jump in full-year net profit on record-high sales, and signaled it will speed up closures of smaller stores to open bigger ones that together with online can attract more customers.

The largest fashion retailer in the world by sales said net profit for the year ended Feb 2, 2019 rose to $3.36 billion vs. $2.88 billion. Sales increased 12% to $23.31 billion from the year before. Both were roughly in line with analysts' expectations, according to Fact Set.

For the fourth quarter, it reported net profit of $952 million vs. $889 million from the year before. Sales increased 15% from 6.95 billion in 2017.

For the 2nd half of the year 2018, same store sales for Zara were up 14% percent.Posted by month they were:August

+ 10%, September +17 % October + 8%, November +12% December +18% and January down 3%.

???????

The following Formulas are used in SALES PLANNING and SALES REPORTING. To calculate the SALES percentage increase/decrease over last year . FORMULA This Year minus Last Year divided by Last Year or TY - LY LY To calculate or plan a TY sales figure if you know LY (last years) sales figure and the desired increase. FORMULA LY x ( 100 + desired increase%) = TY (or for a decrease in sales) LY x ( 100 - decrease % ) = TY To calculate or figure a LY sales figure if you know TY (this year) sales figure and the desired increase. FORMULA TY Divided by (100 + actual increase %) = LY (or for a decrease in sales) TY Divided by (100 - actual increase %) = LY