Calculate the return on common equity

Assignment Help Financial Management
Reference no: EM131939004

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)

2018

2019

2020

2021

 

Sales growth rate per year

5%

6%

7%

7%

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

Verified Expert

This assignment deals having a understanding about USGAAP compliance with respect to calculation an estimation of operating and non operating items. For this assignment i have applied the rules and formula used by the various New York companies for estimating the various concepts asked in this paper.

Reference no: EM131939004

Questions Cloud

Meteorological office forecast for the united kingdom : The following is a Meteorological Office forecast for the United Kingdom covering the period 23 September to 2 October 2006.
Compare and evaluate the speeds of dsl and cable modem : Identify the DSL and cable modem services referenced in this assignment and the region(s) in which they operate.
Compare the pros and cons of 3g and 4g technology : Compare the pros and cons of 3G and 4G technology to determine the best uses of 3G and 4G technology in today's applications.
Evaluate the current ethical and legal concerns : Conduct a SWOT analysis by analyzing the strengths, weaknesses, application opportunities, and threats from competitors of the chosen topic.
Calculate the return on common equity : 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
How the carlson san approach would be implemented : Compare the pros and cons of consolidating data on a SAN central data facility versus the dispersed arrangement it replaces.
Assess the probable difficulties and risks : Analyze ING's solution for providing security to determine if the solution is adequate or inadequate. Provide a rationale for your answer.
Patient contracting the disease : As deduced from this information, what is the probability, expressed to three decimal places, that a given patient contracting the disease will die?
Explain how you would use dns in your plan : Compose a two-paragraph executive summary highlighting the main points of your plan.Analyze and explain how you would use DNS in your plan.

Reviews

Write a Review

Financial Management Questions & Answers

  Foreign company acquisition

Acquisition by a foreign company and the effects of that decision and the results of foreign exchange in Euro and the exchange rate differences.

  Financial management for profit and non profit organizations

In this essay, we are going to discuss the issues of financial management in a non-profit organisation.

  Method for estimating a venture''s value

Evaluate venture's present value, cash and surplus cash and basic venture capital.

  Replacement analysis

This document show the Replacement Analysis of modling machine. Is replacement give profit to company or not?

  Business finance task - capital budgeting

Your company is considering using the payback period for capital-budgeting. Discuss the advantages and disadvantages of this technique.

  Analysis of the investment

In this project, you will focus on one of these: the additional cost resulting from the purchase of an apple press (a piece of equipment required to manufacture apple juice).

  Conduct a what-if analysis

Review the readings and media for this unit, including the Anthony's Orchard case study media. Familiarise yourself with the Anthony's Orchard company and its current situation.

  Determine operational expenditures

Organisations' behaviour is guided by financial data. In the short term, such data will help determine operational expenditures; in the long term, historical data may help generate forecasts aimed at determining strategic plans. In both instances.

  Personal financial management

How much will you have left over each half year if you adopt the latter course of action?

  Sources of finance for expansion into new foreign markets

A quoted company is considering several long-term sources of finance for expansion into new foreign markets.

  Long term financial planning

This assignment is designed for analyze Long term financial planning begins with the sales forecast and the key input in the long term fincial planning.

  Explain the role of fincial manager

This assignment explain the role of fincial manager, function of manger. And what are the motives of financial manager.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd