Questions 1- Introduction 2- An executive summary 3- An overview of Essilor-Luxottica, Safilo Group, and Walmart 4-
Question:
Questions
1- Introduction
2- An executive summary
3- An overview of Essilor-Luxottica, Safilo Group, and Walmart
4- Analyze the financial ratio of the three companies
5- Analyze the industry ratios of the three companies
6- Provide a solid review of the industry categories.
7- Analyze the stock valuation.
8- evaluate Beta for the three companies
9- Analyzethe CAMP of the three firms
10- Analyze the DDM of the
11- Justify which company is a better investment by looking at the CAPM as it is applied to the DDM.
13- Analyze the stock value for the three companies
12- Is the stock value at more or less than it is currently trading
Essilor-Luxottica
Profitability
| Profit Margin | 9.23% |
| Operating Margin (ttm) | 14.15% |
Management Effectiveness
| Return on Assets (ttm) | 3.37% |
| Return on Equity (ttm) | 6.44% |
Income Statement
| Revenue (ttm) | 25.35B |
| Revenue Per Share (ttm) | 28.51 |
| Quarterly Revenue Growth (yoy) | 7.10% |
| Gross Profit (ttm) | -- |
| EBITDA | 5.38B |
| Net Income Avi to Common (ttm) | 2.34B |
| Diluted EPS (ttm) | 2.81 |
| Quarterly Earnings Growth (yoy) | 15.90% |
Balance Sheet
| Total Cash (mrq) | 1.7B |
| Total Cash Per Share (mrq) | 3.76 |
| Total Debt (mrq) | 11.75B |
| Total Debt/Equity (mrq) | 30.62% |
| Current Ratio (mrq) | 0.92 |
| Book Value Per Share (mrq) | 83.61 |
Cash Flow Statement
| Operating Cash Flow (ttm) | 4.82B |
| Levered Free Cash Flow (ttm) | 2.87B |
Trading Information
Stock Price History
| Beta (5Y Monthly) | 0.89 |
| 52 Week Range 3 | 10.98% |
| S&P 500 52-Week Change 3 | 21.41% |
| 52 Week High 3 | 103.27 |
| 52 Week Low 3 | 82.24 |
| 50-Day Moving Average 3 | 98.91 |
| 200-Day Moving Average 3 | 95.08 |
Share Statistics
| Avg Vol (3 month) 3 | 31.63k |
| Avg Vol (10 day) 3 | 44.12k |
| Shares Outstanding 5 | 904.12M |
| Implied Shares Outstanding 6 | 906.38M |
| Float 8 | 287.87M |
| % Held by Insiders 1 | 0.00% |
| % Held by Institutions 1 | 0.02% |
| Shares Short 4 | -- |
| Short Ratio 4 | -- |
| Short % of Float 4 | -- |
| Short % of Shares Outstanding 4 | -- |
| Shares Short (prior month ) 4 | -- |
Dividends & Splits
| Forward Annual Dividend Rate 4 | 1.74 |
| Forward Annual Dividend Yield 4 | 1.69% |
| Trailing Annual Dividend Rate 3 | 3.23 |
| Trailing Annual Dividend Yield 3 | 3.15% |
| 5 Year Average Dividend Yield 4 | 1.09 |
| Payout Ratio 4 |
Safilo Group
Financial Highlights
Fiscal Year
| Fiscal Year Ends | 12/31/2022 |
| Most Recent Quarter (mrq) | 6/30/2023 |
Profitability
| Profit Margin | 1.18% |
| Operating Margin (ttm) | 4.66% |
Management Effectiveness
| Return on Assets (ttm) | 3.21% |
| Return on Equity (ttm) | 2.50% |
Income Statement
| Revenue (ttm) | 1.06B |
| Revenue Per Share (ttm) | 2.55 |
| Quarterly Revenue Growth (yoy) | -3.60% |
| Gross Profit (ttm) | 597.45M |
| EBITDA | 79.79M |
| Net Income Avi to Common (ttm) | 12.48M |
| Diluted EPS (ttm) | 0.0300 |
| Quarterly Earnings Growth (yoy) | -- |
Balance Sheet
| Total Cash (mrq) | 71.23M |
| Total Cash Per Share (mrq) | 0.17 |
| Total Debt (mrq) | 174.28M |
| Total Debt/Equity (mrq) | 41.60% |
| Current Ratio (mrq) | 1.94 |
| Book Value Per Share (mrq) | 0.95 |
Cash Flow Statement
| Operating Cash Flow (ttm) | 33.87M |
| Levered Free Cash Flow (ttm) | 58.71M |
Trading Information
Stock Price History
| Beta (5Y Monthly) | 1.34 |
| 52 Week Range 3 | -17.64% |
| S&P 500 52-Week Change 3 | 21.41% |
| 52 Week High 3 | 1.4300 |
| 52 Week Low 3 | 0.7350 |
| 50-Day Moving Average 3 | 0.9499 |
| 200-Day Moving Average 3 | 1.0115 |
Share Statistics
| Avg Vol (3 month) 3 | 9.12k |
| Avg Vol (10 day) 3 | 5.09k |
| Shares Outstanding 5 | 413.74M |
| Implied Shares Outstanding 6 | 474.93M |
| Float 8 | 207.52M |
| % Held by Insiders 1 | 49.82% |
| % Held by Institutions 1 | 34.92% |
| Shares Short 4 | -- |
| Short Ratio 4 | -- |
| Short % of Float 4 | -- |
| Short % of Shares Outstanding 4 | -- |
| Shares Short (prior month ) 4 | -- |
Dividends & Splits
| Forward Annual Dividend Rate 4 | -- |
| Forward Annual Dividend Yield 4 | -- |
| Trailing Annual Dividend Rate 3 | 0.00 |
| Trailing Annual Dividend Yield 3 | 0.00% |
| 5 Year Average Dividend Yield 4 | -- |
| Payout Ratio 4 | 0.00% |
Walmart
Financial Highlights
Fiscal Year
| Fiscal Year Ends | 1/31/2023 |
| Most Recent Quarter (mrq) | 10/31/2023 |
Profitability
| Profit Margin | 2.55% |
| Operating Margin (ttm) | 3.86% |
Management Effectiveness
| Return on Assets (ttm) | 6.44% |
| Return on Equity (ttm) | 19.74% |
Income Statement
| Revenue (ttm) | 638.79B |
| Revenue Per Share (ttm) | 237.11 |
| Quarterly Revenue Growth (yoy) | 5.20% |
| Gross Profit (ttm) | -- |
| EBITDA | 37.67B |
| Net Income Avi to Common (ttm) | 16.29B |
| Diluted EPS (ttm) | 6.01 |
| Quarterly Earnings Growth (yoy) | -- |
Balance Sheet
| Total Cash (mrq) | 12.15B |
| Total Cash Per Share (mrq) | 4.51 |
| Total Debt (mrq) | 71.98B |
| Total Debt/Equity (mrq) | 83.88% |
| Current Ratio (mrq) | 0.85 |
| Book Value Per Share (mrq) | 29.50 |
Cash Flow Statement
| Operating Cash Flow (ttm) | 32.16B |
| Levered Free Cash Flow (ttm) | 10.4B |
Trading Information
Stock Price History
| Beta (5Y Monthly) | 0.49 |
| 52 Week Range 3 | 17.05% |
| S&P 500 52-Week Change 3 | 21.41% |
| 52 Week High 3 | 171.07 |
| 52 Week Low 3 | 136.09 |
| 50-Day Moving Average 3 | 159.81 |
| 200-Day Moving Average 3 | 158.18 |
Share Statistics
| Avg Vol (3 month) 3 | 8M |
| Avg Vol (10 day) 3 | 5.93M |
| Shares Outstanding 5 | 2.69B |
| Implied Shares Outstanding 6 | 2.69B |
| Float 8 | 1.07B |
| % Held by Insiders 1 | 46.53% |
| % Held by Institutions 1 | 34.89% |
| Shares Short (1/31/2024) 4 | 11.61M |
| Short Ratio (1/31/2024) 4 | 1.9 |
| Short % of Float (1/31/2024) 4 | 0.82% |
| Short % of Shares Outstanding (1/31/2024) 4 | 0.43% |
| Shares Short (prior month 12/29/2023) 4 | 11.4M |
Dividends & Splits
| Forward Annual Dividend Rate 4 | 2.28 |
| Forward Annual Dividend Yield 4 | 1.34% |
| Trailing Annual Dividend Rate 3 | 2.27 |
| Trailing Annual Dividend Yield 3 | 1.33% |
| 5 Year Average Dividend Yield 4 | 1.64 |
| Payout Ratio 4 | 37.77% |
Expert Answer:
International Financial Reporting and Analysis
ISBN: 978-1408075012
5th edition
Authors: David Alexander, Anne Britton, Ann Jorissen
