Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

EL Stock Annual Cash Flow. Download in Excel

Estee Lauder Companies Inc. (The) logo

Estee Lauder Companies Inc. (The)

Sector: Consumer Defensive   

Industry: Household & Personal Products

66.84
 
USD
  
1.51
  
(2.31%)
Previous close: 65.33  Open: 65.63  Bid: 66.83  Ask: 66.95
52 week range    
62.29   
   159.75
Mkt Cap: 23,258 M  Avg Vol (90 Days): 4,488,503
Peers   
PG / 
REV / 
NUS / 
COTY / 
SSDOY / 
IPAR / 
Last updated: Friday 22nd November 2024

Stock Rankings

40
MarketXLS Rank
75
Value
15
Technical
31
Quality
How are these ranks calculated?
Ad slot not ready
Search for a stock

Financials

EL Cash Flow

Annual
Jun-15Jun-16Jun-17Jun-18Jun-19Jun-20Jun-21Jun-22Jun-23Jun-24
(Increase) Decrease in inventories-26 M-69 M-85 M-147 M-375 M-3 M-140 M-602 M-64 M766 M
(Increase) Decrease in other current assets8 M-72 M-80 M12 M-62 M-212 M
(Increase) Decrease in other current liabilities117 M286 M224 M466 M285 M-169 M695 M1000000.0-129 M209 M
(Increase) Decrease in other working capital8 M-72 M-80 M1000000.0-62 M-212 M13 M-101 M26 M15 M
(Increase) Decrease in payables147 M101 M54 M349 M319 M-308 M440 M210 M-333 M-38 M
(Increase) Decrease in receivables103 M-101 M-92 M-105 M-169 M625 M-398 M-10 M185 M-285 M
Acquisitions-241 M-101 M-1,681 M-11 M-1,047 M-1,065 M-3 M
AssetImpairmentCharge500000.031 M90 M1,426 M188 M241 M207 M471 M
CapitalExpenditureReported473 M525 M504 M629 M744 M623 M637 M1,040 M3,289 M919 M
Cash at beginning of period1,629 M1,021 M914 M1,136 M2,181 M2,987 M5,022 M4,958 M3,957 M4,029 M
Cash at end of period1,021 M914 M1,136 M2,181 M2,987 M5,022 M4,958 M3,957 M4,029 M3,395 M
Cash flow1,936 M1,781 M1,857 M2,605 M2,554 M2,297 M3,633 M3,040 M1,731 M2,360 M
CashFlowFromContinuingInvestingActivities-1,609 M-1,261 M-2,271 M-401 M436 M-1,715 M-1,866 M-945 M-3,217 M-960 M
ChangeInAccountPayable147 M101 M54 M349 M319 M-308 M440 M210 M-333 M-38 M
ChangeInPayablesAndAccruedExpense147 M101 M54 M349 M319 M-308 M440 M210 M-333 M-38 M
ChangeInWorkingCapital348 M145 M21 M564 M-2 M-67 M610 M-502 M-315 M667 M
ChangesInAccountReceivables103 M-101 M-92 M-105 M-169 M625 M-398 M-10 M185 M-285 M
CommonStockDividendPaid-356 M-427 M-489 M-550 M-615 M-513 M-761 M-840 M-925 M-947 M
CommonStockPayments-983 M-890 M-413 M-759 M-1,555 M-893 M-733 M-2,309 M-271 M-780 M
Current deferred income taxes-53 M-94 M-118 M175 M-66 M-143 M-230 M-149 M-186 M-265 M
Deferred income taxes-53 M-94 M-118 M175 M-66 M-143 M-230 M-149 M-186 M-265 M
Depreciation409 M415 M464 M531 M557 M611 M651 M727 M744 M825 M
Depreciation unreconciled409 M415 M464 M531 M557 M611 M651 M727 M744 M825 M
DepreciationAndAmortization409 M415 M464 M531 M557 M611 M651 M727 M744 M825 M
EarningsLossesFromEquityInvestments-71 M-534 M-847 M-1000000.0
Effect of exchange rate changes-40 M-22 M6 M13 M-11 M-8 M61 M-60 M-32 M1000000.0
ExcessTaxBenefitFromStockBasedCompensation-48 M-23 M-45 M
FinancingCashFlow-895 M-605 M630 M-1,172 M-2,173 M1,461 M-1,892 M-3,036 M1,590 M-2,035 M
Free cash flow1,463 M1,256 M1,365 M1,976 M1,812 M1,674 M2,996 M2,000 M-1,558 M1,441 M
GainLossOnSaleOfBusiness-71 M
GainLossOnSaleOfPPE15 M17 M5 M15 M17 M20 M23 M8 M13 M9 M
Issuance of debt14 M-400000.0165 M-8 M-171 M755 M-744 M-4 M983 M-1,000 M
IssuanceOfDebt295 M604 M1,346 M-10 M-172 M2,705 M-611 M-23 M2,698 M-366 M
Net cash from financing activities-895 M-605 M630 M-1,172 M-2,173 M1,461 M-1,892 M-3,036 M1,590 M-2,035 M
Net cash from investing activities-1,609 M-1,261 M-2,271 M-401 M436 M-1,715 M-1,866 M-945 M-3,217 M-960 M
Net cash from operating activities1,936 M1,781 M1,857 M2,605 M2,554 M2,297 M3,633 M3,040 M1,731 M2,360 M
Net change in cash & cash equivalents-568 M-107 M222 M1,045 M817 M2,043 M-125 M-941 M104 M-635 M
Net income from continuing operations1,093 M1,121 M1,256 M1,117 M1,794 M696 M2,875 M2,408 M1,010 M409 M
NetBusinessPurchaseAndSale-234 M-93 M-1,738 M-43 M-37 M-1,064 M-1,067 M-3 M
NetCommonStockIssuance-983 M-890 M-413 M-759 M-1,555 M-893 M-733 M-2,309 M-271 M-780 M
NetIntangiblesPurchaseAndSale-2,286 M
NetInvestmentPropertiesPurchaseAndSale-902 M-643 M-41 M271 M1,215 M-28 M-162 M98 M72 M-41 M
NetInvestmentPurchaseAndSale-902 M-643 M-41 M271 M1,215 M-28 M-162 M98 M72 M-41 M
NetIssuancePaymentsOfDebt295 M604 M1,346 M-10 M-172 M2,705 M-611 M-23 M2,698 M-366 M
NetLongTermDebtIssuance281 M604 M1,181 M-2 M-1000000.01,950 M133 M-19 M1,715 M634 M
NetPPEPurchaseAndSale-473 M-525 M-492 M-629 M-742 M-623 M-637 M-1,040 M-1,003 M-919 M
Operating (gains) losses20 M107 M88 M89 M18 M-412 M-653 M99 M102 M66 M
Other financing charges net48 M23 M45 M-35 M-23 M-18 M-2 M-15 M18 M
Other investing changes net7 M8 M-57 M-43 M-37 M-40 M32 M
Other non-cash items118 M87 M146 M129 M253 M1,612 M380 M457 M376 M658 M
Payment of cash dividends356 M427 M489 M550 M615 M513 M761 M840 M925 M947 M
PensionAndEmployeeBenefitExpense6 M71 M80 M73 M72 M82 M95 M78 M53 M50 M
ProceedsFromStockOptionExercised101 M85 M141 M182 M192 M180 M215 M151 M88 M40 M
Purchase of Float term investments-1,207 M-2,016 M-1,267 M-478 M-14 M-5 M-42 M-10 M-8 M-18 M
Purchase of property plant & equipment-473 M-525 M-492 M-629 M-742 M-623 M-637 M-1,040 M-3,289 M-919 M
Purchase of short term investments286 M608 M1,192 M-2 M-1000000.01,968 M137 M-18 M1,730 M638 M
PurchaseOfIntangibles-2,286 M
PurchaseOfInvestment-1,207 M-2,016 M-1,267 M-478 M-14 M-28 M-194 M98 M72 M-41 M
PurchaseOfLongTermInvestments-23 M-152 M108 M80 M-23 M
PurchaseOfPPE-473 M-525 M-504 M-629 M-744 M-623 M-637 M-1,040 M-1,003 M-919 M
Repayment of debt-4 M-4 M-11 M-2 M-1000000.0-18 M-4 M-1000000.0-15 M-4 M
RepaymentOfDebt-4 M-4 M-11 M-10 M-172 M-18 M-4 M-1000000.0-15 M-789 M
Repurchase of capital stock-983 M-890 M-413 M-759 M-1,555 M-893 M-733 M-2,309 M-271 M-780 M
Sale of short term investments305 M1,373 M1,226 M749 M1,229 M
SaleOfBusiness7 M8 M-57 M-43 M-37 M-17 M-2 M
SaleOfInvestment305 M1,373 M1,226 M749 M1,229 M
SaleOfPPE12 M2 M
ShortTermDebtIssuance14 M165 M-8 M-171 M755 M-744 M-4 M983 M-215 M
ShortTermDebtPayments14 M-400000.0165 M-8 M-171 M755 M-785 M
StockBasedCompensation165 M184 M219 M236 M243 M213 M327 M331 M267 M325 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.

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