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

Sector: Consumer Cyclical   

Industry: Specialty Retail

296.99
 
USD
  
10.71
  
(3.74%)
Optionable: Yes  Market Cap: 5,216 M  90-day average vol: 532,074

Previous close: 286.28  Open: 290.0  Bid: 317.02  Ask: 317.89
52 week range    
207.26   
   406.38
Peers   
WSM / 
KIRK / 
BBBY / 
Last updated: Thursday 28th March 2024
59
MarketXLS Rank
35
Value
84
Technical
60
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

RH Balance Sheet

Annual
Jan-14Jan-15Jan-16Jan-17Jan-18Jan-19Jan-20Jan-21Jan-22Jan-23
"""debtc"""66 M59 M72 M74 M80 M
Accounts payable116 M133 M157 M135 M195 M183 M181 M225 M442 M166 M
Accounts receivable22 M26 M29 M34 M31 M40 M49 M59 M58 M60 M
Accrued expenses207 M235 M262 M227 M319 M320 M330 M474 M442 M375 M
AccruedInterestReceivable5 M
Accumulated depreciation & depletion-116 M-143 M-175 M-234 M-283 M-345 M-412 M-489 M-514 M-602 M
Additional paid in capital585 M669 M764 M791 M841 M356 M431 M582 M621 M247 M
Cash and equivalents13 M149 M331 M87 M18 M6 M48 M100 M2,178 M1,512 M
CashCashEquivalentsAndShortTermInvestments13 M211 M462 M230 M18 M6 M48 M100 M2,178 M1,512 M
CashEquivalents13 M149 M331 M87 M18 M6 M48 M100 M1,512 M
Common par4000.04000.04000.04000.02000.02000.02000.02000.02000.02000.0
Common stock equity545 M703 M886 M920 M-8 M-39 M19 M447 M1,170 M785 M
CommonStock4000.04000.04000.04000.02000.02000.02000.02000.02000.02000.0
Construction in progress204 M
Cost in excess122 M124 M124 M174 M142 M124 M124 M141 M141 M141 M
CurrentCapitalLeaseObligation2 M255000.079 M90 M89 M66 M59 M72 M74 M80 M
CurrentDeferredAssets21 M28 M
CurrentDeferredRevenue54 M74 M107 M146 M149 M153 M162 M281 M388 M326 M
CurrentDeferredTaxesAssets21 M1 M2 M2 M3 M312 M313 M340 M384 M551 M
CurrentDeferredTaxesLiabilities145000.018 M18 M28 M15 M12 M13 M10 M-327 M161 M
CurrentProvisions38 M41 M54 M60 M55 M54 M
Deferred revenues54 M74 M107 M146 M149 M153 M162 M281 M388 M326 M
DeferredFinancingCosts-22 M
Deposits7 M
Float term debt85 M4 M2 M2 M359 M58 M31 M38 M1,101 M18 M
GoodwillAndOtherIntangibleAssets171 M173 M173 M274 M243 M210 M210 M213 M214 M216 M
Gross fixed assets (Plant Property & Equipment)331 M534 M691 M916 M1,084 M1,738 M1,790 M2,022 M2,293 M2,765 M
IncomeTaxPayable22 M2 M28 M619000.05 M719000.014 M50 M31 M4 M
Intangibles49 M49 M49 M101 M101 M86 M86 M72 M73 M75 M
InterestPayable36 M44 M63 M68 M87 M69 M65 M113 M
Inventories454 M559 M725 M752 M527 M532 M439 M544 M734 M802 M
InventoriesAdjustmentsAllowances-9 M-15 M-19 M-33 M-31 M-31 M-26 M-24 M-24 M-40 M
Invested capital631 M707 M888 M921 M362 M19 M50 M700 M4,281 M816 M
Leases784 M
LineOfCredit19 M20 M15 M14 M
LongTermCapitalLeaseObligation389000.07 M7 M7 M8 M859 M853 M934 M1,101 M1,159 M
LongTermDebtAndCapitalLeaseObligation85 M284 M359 M916 M884 M934 M1,101 M1,177 M
LongTermProvisions33 M125 M147 M203 M229 M229 M
Net fixed assets (net PP&E)215 M391 M516 M682 M801 M1,393 M1,379 M1,533 M1,779 M2,163 M
NetOtherUnrealizedGainLoss2 M8 M333000.0
Non-current deferred income taxes12 M133000.025 M32 M22 M137 M137 M147 M-155 M6 M
NonCurrentDeferredAssets17 M37 M37 M28 M23 M36 M45 M50 M57 M167 M
NonCurrentDeferredLiabilities133000.06 M
NonCurrentDeferredTaxesAssets17 M37 M37 M28 M23 M36 M45 M50 M57 M167 M
NonCurrentNoteReceivables5 M5 M
NonCurrentPrepaidAssets756000.0
Notes payable53 M20 M25 M
NotesReceivable14 M8 M3 M
Number of employees6500.06500.06500.06500.06500.06500.06500.06500.06500.06500.0
Other current assets1 M940000.0921000.05 M8 M22 M9 M8 M13 M26 M
Other equity adjustments629000.0-502000.0-3 M-2 M-171000.0-2 M-3 M3 M-2 M
Other fixed assets1,779 M
Other non-current assets8 M23 M25 M36 M21 M80 M215 M200 M298 M149 M
Other non-current liabilities6 M1 M1 M3 M3 M5 M29 M32 M9 M8 M
Other receivable2,440 M2,506 M2,647 M2,849 M3,759 M3,590 M
OtherCurrentBorrowings900000.0700000.0700000.0
OtherCurrentLiabilities57 M65 M94 M88 M128 M142 M141 M143 M147 M103 M
OtherDeferredCosts7 M22 M
OtherInventories454 M559 M725 M752 M527 M532 M439 M544 M734 M802 M
OtherPayable207 M235 M262 M227 M319 M320 M330 M424 M5 M375 M
Payables207 M235 M262 M227 M319 M320 M330 M474 M442 M375 M
Preferred securities of subsidiary trust10 M10 M10 M
PreferredStock10 M10 M10 M
Prepaid expenses103 M88 M79 M117 M69 M104 M62 M97 M121 M139 M
RecievablesAdjustmentsAllowances-2 M-2 M-2 M-2 M-2 M-2 M-2 M-3 M-4 M-3 M
Retained earnings-37 M54 M145 M150 M152 M-393 M-409 M-137 M550 M540 M
TaxesReceivable13 M5 M197000.05 M12 M
Total assets1,025 M1,526 M2,086 M2,193 M1,733 M2,423 M2,446 M2,898 M5,540 M5,309 M
Total current assets614 M912 M1,314 M1,138 M645 M704 M597 M801 M3,091 M2,513 M
Total current liabilities317 M344 M453 M416 M519 M993 M983 M922 M1,064 M886 M
Total equity545 M703 M886 M920 M-8 M-39 M19 M447 M1,170 M785 M
Total liabilities480 M823 M1,200 M1,273 M1,740 M2,462 M2,427 M2,451 M4,370 M4,525 M
Total non-current assets411 M642 M773 M1,054 M1,088 M1,719 M1,849 M2,097 M2,449 M2,797 M
Total non-current liabilities125 M125 M147 M203 M588 M916 M912 M965 M1,110 M1,191 M
TotalEquityGrossMinority545 M703 M886 M920 M-7 M-39 M19 M447 M1,170 M785 M
TotalEquityGrossMinorityInterest545 M703 M886 M920 M-7 M-39 M19 M447 M1,170 M785 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest1,025 M1,526 M2,086 M2,193 M1,733 M2,423 M2,446 M2,898 M5,540 M5,309 M
TotalNonCurrentLiabilitiesNetMinorityInteres125 M125 M147 M203 M588 M916 M912 M965 M1,110 M1,191 M
TotalTaxPayable50 M31 M
Treasury stock-3 M-19 M-20 M-20 M-1,000 M-243000.0250 M72000.01,000 M
Working capital296 M568 M861 M722 M126 M-289 M-386 M-120 M2,028 M1,627 M
ltinv0.018 M22 M33 M0.00.00.0101 M101 M101 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