Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Ralph Lauren Corporation logo

Ralph Lauren Corporation

Sector: Consumer Cyclical   

Industry: Apparel Manufacturing

157.33
 
USD
  
-1.92
  
(-1.21%)
Optionable: Yes  Market Cap: 10,285 M  90-day average vol: 1,045,961

Previous close: 159.25  Open: 159.74  Bid: 156.95  Ask: 162.53
52 week range    
103.17   
   192.03
Peers   
PVH / 
VFC / 
HBI / 
GES / 
Last updated: Friday 19th April 2024
47
MarketXLS Rank
55
Value
46
Technical
42
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

Financials

RL Balance Sheet

Annual
Mar-14Mar-15Mar-16Mar-17Mar-18Mar-19Mar-20Mar-21Mar-22Mar-23
"""debtc"""234 M116 M308 M1,063 M303 M762 M267 M
Accounts payable203 M210 M151 M148 M166 M202 M247 M356 M449 M372 M
Accounts receivable588 M655 M517 M450 M421 M398 M277 M452 M405 M448 M
Accrued expenses280 M237 M184 M177 M196 M232 M312 M407 M503 M431 M
Accumulated depreciation & depletion-1,526 M-1,679 M-1,904 M-2,021 M-2,041 M-2,103 M-2,128 M-2,292 M-2,249 M-2,334 M
Additional paid in capital1,979 M2,117 M2,258 M2,309 M2,383 M2,494 M2,594 M2,667 M2,749 M2,824 M
Building & improvements183 M409 M460 M457 M458 M388 M309 M493 M480 M472 M
Cash and equivalents797 M500 M456 M668 M1,305 M584 M1,620 M2,579 M1,864 M1,529 M
CashCashEquivalentsAndShortTermInvestments1,285 M1,144 M1,086 M1,353 M2,004 M1,988 M2,116 M2,777 M2,598 M1,566 M
CashEquivalents797 M500 M456 M668 M1,305 M584 M
CommercialPaper234 M90 M
Common par1000000.01000000.01 M900000.01000000.01000000.01000000.01000000.01000000.01000000.0
Common stock equity4,034 M3,891 M3,744 M3,299 M3,457 M3,287 M2,693 M2,604 M2,536 M2,431 M
CommonStock1000000.01000000.01 M900000.01000000.01000000.01000000.01000000.01000000.01000000.0
Construction in progress38 M35 M55 M61 M
Cost in excess964 M903 M918 M905 M951 M920 M916 M935 M909 M899 M
CurrentCapitalLeaseObligation255 M238 M266 M23 M20 M22 M288 M303 M262 M267 M
CurrentDeferredAssets150 M145 M
CurrentDeferredRevenue41 M38 M50 M30 M32 M15 M15 M12 M17 M14 M
CurrentDeferredTaxesAssets150 M145 M15 M9 M5 M1 M200000.01 M96 M70 M
CurrentDeferredTaxesLiabilities219 M209 M217 M217 M149 M150 M235 M273 M291 M248 M
DefinedPensionBenefit52 M60 M65 M56 M43 M48 M52 M57 M49 M53 M
Deposits27 M28 M32 M27 M27 M25 M
DerivativeProductLiabilities1000000.034 M9 M49 M12 M55 M18 M
DividendsPayable40 M43 M41 M41 M41 M199 M-205 M-198 M-199 M
Finished goods1,015 M1,037 M
Float term debt298 M298 M597 M588 M288 M689 M1,965 M3,298 M2,610 M2,595 M
GoodwillAndOtherIntangibleAssets1,263 M1,170 M1,162 M1,124 M1,139 M1,083 M1,057 M1,056 M1,012 M988 M
Gross fixed assets (Plant Property & Equipment)2,848 M3,115 M3,487 M3,337 M3,228 M3,142 M4,620 M4,545 M4,330 M4,424 M
IncomeTaxPayable77 M27 M33 M30 M30 M29 M65 M51 M54 M60 M
Intangibles299 M267 M244 M220 M188 M164 M141 M121 M103 M89 M
Inventories1,020 M1,042 M1,125 M792 M761 M818 M736 M759 M977 M1,071 M
Invested capital4,332 M4,189 M4,341 M3,888 M3,745 M3,976 M5,054 M7,535 M6,283 M6,164 M
Land & improvements1,064 M1,185 M1,248 M1,179 M1,147 M1,169 M15 M15 M15 M15 M
Leases1,195 M1,207 M1,170 M1,216 M
LineOfCredit9 M9 M10 M10 M9 M12 M9 M9 M10 M12 M
LongTermCapitalLeaseObligation251 M236 M213 M1,568 M1,665 M1,474 M1,456 M
LongTermDebtAndCapitalLeaseObligation298 M298 M597 M588 M288 M689 M1,965 M3,298 M2,610 M2,595 M
LongTermProvisions400000.0-59 M28 M2 M-2 M
Machinery furniture & equipment661 M686 M727 M687 M647 M626 M630 M609 M590 M609 M
Net fixed assets (net PP&E)1,322 M1,436 M1,583 M1,316 M1,186 M1,039 M2,491 M2,254 M2,081 M2,090 M
Non-current deferred income taxes90 M87 M89 M62 M37 M25 M-3 M
NonCurrentAccruedExpenses125 M147 M133 M119 M99 M76 M
NonCurrentDeferredAssets39 M45 M119 M126 M87 M67 M245 M284 M304 M255 M
NonCurrentDeferredRevenue51 M45 M26 M58 M62 M53 M43 M
NonCurrentDeferredTaxesAssets39 M45 M119 M126 M87 M67 M245 M284 M304 M255 M
NotesReceivable17 M31 M
Number of employees22200.022200.022200.022200.022200.022200.022200.022200.022200.022200.0
Other current assets83 M69 M58 M50 M64 M65 M73 M71 M75 M77 M
Other equity adjustments114 M-165 M-181 M-198 M-98 M-103 M
Other fixed assets2,491 M2,254 M2,081 M2,090 M
Other non-current assets135 M131 M297 M131 M184 M159 M112 M86 M111 M133 M
Other non-current liabilities786 M731 M674 M604 M686 M620 M397 M282 M224 M195 M
Other receivable22 M14 M13 M16 M4 M8 M27 M29 M41 M31 M
OtherCurrentBorrowings234 M116 M10 M475 M
OtherCurrentLiabilities690 M715 M898 M983 M1,083 M968 M717 M875 M991 M796 M
OtherInventories736 M759 M977 M1,071 M
Payables280 M237 M184 M177 M196 M232 M312 M407 M503 M431 M
Prepaid expenses224 M281 M268 M280 M324 M359 M161 M167 M173 M189 M
Raw materials3 M3 M
Restricted cash1,630 M2,588 M1,872 M1,537 M
Retained earnings5,257 M5,787 M6,015 M5,752 M5,752 M5,979 M5,876 M5,752 M6,095 M6,402 M
Short term debt234 M116 M308 M775 M500 M
TaxesReceivable62 M57 M58 M79 M38 M32 M85 M54 M64 M51 M
Total assets6,088 M6,106 M6,213 M5,652 M6,143 M5,943 M7,280 M7,888 M7,725 M6,790 M
Total current assets3,329 M3,324 M3,053 M2,955 M3,548 M3,595 M3,375 M4,208 M4,217 M3,324 M
Total current liabilities970 M1,186 M1,198 M1,160 M1,587 M1,200 M2,092 M1,585 M2,256 M1,494 M
Total equity4,034 M3,891 M3,744 M3,299 M3,457 M3,287 M2,693 M2,604 M2,536 M2,431 M
Total liabilities2,054 M2,215 M2,470 M2,352 M2,686 M2,656 M4,587 M5,283 M5,189 M4,359 M
Total non-current assets2,759 M2,782 M3,160 M2,698 M2,595 M2,348 M3,905 M3,680 M3,507 M3,465 M
Total non-current liabilities1,084 M1,029 M1,271 M1,193 M1,099 M1,456 M2,495 M3,698 M2,933 M2,866 M
TotalEquityGrossMinority4,034 M3,891 M3,744 M3,299 M3,457 M3,287 M2,693 M2,604 M2,536 M2,430 M
TotalEquityGrossMinorityInterest4,034 M3,891 M3,744 M3,299 M3,457 M3,287 M2,693 M2,604 M2,536 M2,430 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest6,088 M6,106 M6,213 M5,652 M6,143 M5,943 M7,280 M7,888 M7,725 M6,790 M
TotalNonCurrentLiabilitiesNetMinorityInteres1,084 M1,029 M1,271 M1,193 M1,099 M1,456 M2,495 M3,698 M2,933 M2,866 M
TotalTaxPayable77 M27 M33 M30 M30 M29 M65 M51 M54 M60 M
Treasury stock-3,317 M-3,849 M-4,349 M-4,564 M-4,581 M-5,084 M-5,778 M-5,816 M-6,309 M-6,797 M
Work in progress2 M2 M
Working capital2,359 M2,138 M1,854 M1,795 M1,961 M2,395 M1,283 M2,623 M1,962 M1,831 M
ltinv2 M8 M187 M21 M86 M45 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