Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Estee Lauder Companies Inc. (The) logo

Estee Lauder Companies Inc. (The)

Sector: Consumer Defensive   

Industry: Household & Personal Products

145.04
 
USD
  
5.73
  
(4.11%)
Optionable: Yes  Market Cap: 49,939 M  90-day average vol: 2,747,920

Previous close: 139.31  Open: 140.71  Bid: 144.0  Ask: 145.35
52 week range    
102.22   
   260.46
Peers   
PG / 
REV / 
NUS / 
COTY / 
SSDOY / 
IPAR / 
Last updated: Thursday 28th March 2024
38
MarketXLS Rank
50
Value
30
Technical
34
Quality

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord

Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

COTY

7 B-168.58

IPAR

0.01043 B30.595.85

NUS

0.03023 B10.951.29

PG

0.0215383 B28.3160.32

REV

1 B-1.210.33

SSDOY

UL

Financials

EL Income Statement

Annual
Jun-14Jun-15Jun-16Jun-17Jun-18Jun-19Jun-20Jun-21Jun-22Jun-23
Amortization of intangibles893 M1,145 M1,228 M1,916 M1,926 M1,868 M2,338 M4,095 M3,428 M5,602 M
Basic EPS from continuing operations3.122.873.013.43.014.911.97.916.642.81
Basic EPS total3.122.873.013.43.014.911.97.916.642.81
Basic weighted shares outstanding386 M379 M370 M367 M368 M364 M361 M363 M360 M358 M
Cost of sales2,158 M2,101 M2,181 M2,437 M2,844 M3,387 M3,552 M3,834 M4,305 M4,564 M
Depreciation385 M409 M415 M464 M531 M557 M611 M651 M727 M744 M
DepreciationAndAmortization385 M409 M415 M464 M531 M557 M611 M651 M727 M744 M
Diluted EPS total3.062.822.963.352.954.821.867.796.552.79
Diluted normalized net income/share3.062.822.963.352.954.821.867.796.552.79
Diluted weighted shares outstanding393 M386 M377 M373 M376 M370 M367 M368 M365 M361 M
Dividends paid per share0.780.921.141.321.481.671.392.072.332.58
Earnings from equity interest71 M
EarningsFromEquityInterestNetOfTax71 M
GainOnSaleOfSecurity9 M14 M16 M28 M56 M58 M48 M51 M30 M131 M
GeneralAndAdministrativeExpense6,986 M7,074 M7,338 M7,469 M8,553 M8,857 M8,637 M9,371 M9,888 M9,575 M
Gross operating profit8,811 M8,680 M9,081 M9,387 M10,839 M11,476 M10,742 M12,381 M13,432 M11,346 M
ImpairmentOfCapitalAssets28 M68 M812 M54 M
Income before tax1,777 M1,561 M1,555 M1,617 M1,980 M2,307 M1,046 M3,331 M3,036 M1,397 M
Income restructuring and M&A-3 M133 M195 M231 M216 M73 M204 M133 M55 M
Income taxes568 M467 M434 M361 M863 M513 M350 M456 M628 M387 M
Interest income-51 M
InterestExpenseNonOperating59 M60 M71 M103 M128 M133 M161 M173 M167 M255 M
InterestExpenseOperating300000.0-79 M-96 M-128 M-131 M-153 M-166 M-163 M-235 M
MinorityInterests-5 M-4 M-6 M-7 M-9 M-9 M-12 M-5 M-18 M-4 M
MiscOtherSpecialCharges2,011 M1,928 M2,111 M2,427 M3,320 M3,382 M271 M201 M285 M343 M
Net income from total operations1,204 M1,089 M1,115 M1,249 M1,108 M1,785 M684 M2,870 M2,390 M1,006 M
NetIncomeCommonStockholders1,204 M1,089 M1,115 M1,249 M1,108 M1,785 M684 M2,870 M2,390 M1,006 M
NetIncomeContinuousOperations1,204 M1,089 M1,115 M1,249 M1,108 M1,785 M684 M2,870 M2,390 M1,006 M
NetNonOperatingInterestIncomeExpense-59 M-60 M-71 M-103 M-128 M-133 M-161 M-173 M-167 M-255 M
Normalized income1,152 M1,022 M1,152 M1,220 M1,752 M2,092 M2,308 M3,035 M2,779 M1,366 M
Operating income1,828 M1,606 M1,610 M1,692 M2,055 M2,313 M606 M2,618 M3,170 M1,509 M
Operating income before depreciation (EBITDA)2,030 M1,962 M2,088 M2,511 M2,866 M1,665 M3,989 M3,767 M2,161 M
OperatingExpense6,983 M7,074 M7,471 M7,695 M8,784 M9,163 M10,136 M9,763 M10,262 M9,837 M
Other income net-9 M-14 M-16 M-25 M-56 M-36 M566 M83 M211 M76 M
OtherGandA6,986 M7,074 M7,338 M7,469 M8,553 M8,857 M8,637 M9,371 M9,888 M9,575 M
OtherImpairmentOfCapitalAssets3 M22 M614 M134 M241 M207 M
OtherOperatingExpenses3 M-11 M-12 M-10 M-7 M-71 M-557 M-847 M-1000000.0-4 M
OtherWriteOff12 M7 M
RentAndLandingFees356 M402 M442 M457 M538 M583 M
Research & development expense158 M
ResearchExpense158 M
RestructringAndMnAIncome-3 M133 M195 M231 M216 M73 M204 M133 M55 M
Revenue per share1,271 M1,545 M1,629 M2,344 M2,395 M2,363 M2,852 M4,611 M3,971 M6,179 M
SalariesAndWages-50 M-54 M-60 M-72 M3 M2 M4 M12 M-2 M-12 M
Selling Gen & administrative expense6,986 M7,074 M7,338 M7,469 M8,553 M8,857 M8,637 M9,371 M9,888 M9,575 M
SellingAndMarketingExpense2,840 M2,772 M2,821 M2,908 M3,287 M3,440 M
Special income/charges3 M-133 M-223 M-231 M-284 M-885 M-258 M-133 M-55 M
Total Income available for interest expense (EBIT)1,621 M1,547 M1,624 M1,980 M2,309 M1,054 M3,338 M3,040 M1,417 M
Total common shares outstanding381 M373 M366 M368 M367 M361 M361 M361 M357 M358 M
Total net income1,204 M1,089 M1,115 M1,249 M1,108 M1,785 M684 M2,870 M2,390 M1,006 M
Total ordinary shares233 M233 M233 M233 M233 M233 M233 M233 M233 M233 M
Total revenues10,969 M10,780 M11,262 M11,824 M13,683 M14,863 M14,294 M16,215 M17,737 M15,910 M
TotalExpenses9,141 M9,174 M9,652 M10,132 M11,628 M12,550 M13,688 M13,597 M14,567 M14,401 M
TotalRevenue10,969 M10,780 M11,262 M11,824 M13,683 M14,863 M14,294 M16,215 M17,737 M15,910 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

We respect your privacy and will never share your email.
MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University