Formed in 1946 by Estée Lauder and her husband Joseph Lauder as a small family operated cosmetics firm in New York City, the Estee Lauder Companies Inc. (ELC) first carried only four products. ELC is now a leading consumer products company with over $12 billion in revenues, 46 thousand employees and products sold in more than 150 countries.

ELC operates in beauty products segment, manufactures and markets skin care, makeup, and fragrance and hair care products. ELC's products are sold under brand names including Estee Lauder, Aramis, Clinique, Prescriptives, Lab Series, Origins, Tommy Hilfiger, MAC, Kiton, La Mer, Bobbi Brown, Donna Karan New York, DKNY, Aveda, Jo Malone London, Bumble and bumble, Michael Kors, Darphin, Tom Ford, Smashbox, ErmenegildoZegna, AERIN, Tory Burch, RODIN olio lusso, Le Labo, Editions de Parfums Frederic Malle, GLAMGLOW, By Kilian, BECCA and Too Faced. Its skin care products include moisturizers, serums, cleansers, toners, body care, exfoliators, acne and oil correctors, facial masks, cleansing devices and sun care products.

The maintenance of firm's brands along with new product development and effective advertising is critical to the success of the company's operations. Marketing and product innovations along with streamlined production and distribution, have contributed to growth, but the firm has also purchased brands through acquisition of other companies. In fiscal 2016, the company acquired Becca Cosmetics, their first colour cosmetic group acquisition since Smashbox in 2010. In November 2016, the company made its largest acquisition to date by acquiring California-based cosmetics company Too Faced for $1.45 billion.

The branded consumer products business is very competitive, and ELC battles the likes of Avon, Kimberly-Clark, L'Oreal, Colgate-Palmolive and Procter & Gamble. Like these companies, continual innovation is essential to the firm's continuing profitability, so the firm maintains an extensive research and development operation, including marketing research and spends considerable amounts on advertising and promoting its brands.

The 2017 ELC Annual Report is the Appendix. Read the management letters and the Management Discussion and Analysis. Management communications are helpful in understanding the strategy and how the management is executing on that strategy. The stress on brand innovation and research is evident from ELC's management letters.

Required

After understanding the company, go to the financial statements, which along with the footnotes to the statements are our main focus for financial statement analysis.

1. On the basis of the information supplied, reformulate the income statements and balance sheets for 2017 to ready them for analysis using the following layout for the balance sheet.

As advertising, merchandising and sample expenditure is so important make sure you include these as line items in the reformulated statements. State your assumptions clearly as you do the reformulation. Review the reformulated balance sheet and summarize your key insights.

2. Calculate the return on common equity (ROCE) for years 2017 and 2016. For 2017 (2016) you can use yearly averages (end of year) amounts in ratios' denominators.

3. Calculate the return on net operating assets (RNOA) for 2017 and 2016.

4. Comment on your findings. More broadly, discuss how the company's profitability changed between 2016 and 2017.

5. Calculate sales growth rates for 2017 and 2016 and also growth rates for operating income from sales. Calculate growth rates for net operating assets for 2017. Do you see a trend? Is there any balance sheet item that particularly affects the growth?

6. What caused other comprehensive income loss in 2016?

7. Why did goodwill increase in 2017?

8. Operating profitability should be distinguished from return on common equity. Apply the financial leverage equation to highlight the difference. Is the firm favorably levered?

9. Calculate ROCE and its drivers RNOA, FLEV and SPREAD for 2017. What would be the effect on ROCE if operating profitability fell?

10. Calculate operating profit margin from sales for each year.

11. Calculate expense ratios as percentage of sales for advertising and promotion and R&D for each year. Do you see any trends? Carry out a comprehensive analysis of profit margin and asset turnovers (ATO) for 2017. In calculating ATO ratios use balance sheet amounts as averages for the year.

12. Using the margins, explain how cost of sales, operating and non-operating costs have been managed across the two years of 2017 and 2016.

13. What would be the effect on RNOA if profit margins changed? How might an increase in advertising and promotion affect profitability? In some years, translation gains/losses have big effects on total operating income. After excluding translation gains/losses and other non-sales items from operating income, calculate the return on net operating assets (RNOA) for 2017 and 2016. Comment on your findings and summarize key insights.

14. Prepare a pro forma forecast of sales, operating profit margin (PM), asset turnover (ATO), Operating income (OI), RNOA and residual operating income (Re_OI) for years 2018 - 2021 under the following conditions:

a)

b) perating profit margins and asset turnovers will be the same as in 2017.Prepare a pro forma forecasts of sales, operating profit margin (PM), asset turnover (ATO), Operating income (OI), RNOA and residual operating income (Re_OI) for years 2018 - 2021 under the following conditions:

c) Required return for operations is 9%

Use the forecasts of Re_OI to value the operations (VNOA) of the firm and calculate its intrinsic value of equity (VE).

Some important notes regarding the coursework

- Maximum length 1,200 words. However, it is possible to produce a concise yet thorough analysis in less than 1,200 words. Reformulated statements and detailed numerical analysis can be included in the excel spreadsheets and attached to the word file report.

- Summarize your broad conclusion and finding at the front of your report in an executive summary (which is included in the word count).

- Apply your knowledge and use a logical approach in your calculations and their interpretation.

- Your objective is to highlight the most salient information to enable your reader to understand ELC's performance and financial position.

- You do not need to explain technical terms but you must show the formulae and figures used for your calculations.

Present the analysis of why the ratios may have changed or the possible implications of the ratio changing or remaining the same.

Use - THE ESTEE LAUDER COMPANIES INC. - The Global House of Prestige Beauty - 2017 ANNUAL REPORT