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

JOANN Inc

Sector: Retail Trade   

Industry: Beer, Wine, and Liquor Stores

0.10
 
USD
  
-0.01
  
(-11.91%)
Optionable: Yes  Market Cap: 5 M  90-day average vol: 1,567,685

Previous close: 0.11  Open: 0.1145  Bid:   Ask:
52 week range    
0.08   
   2.19
Peers   
Last updated: Friday 26th April 2024

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

JOAN Balance Sheet

Annual
Invalid dateJan-22Jan-23
"""debtc"""181 M184 M
Accounts payable254 M198 M
Accrued expenses396 M317 M
Accumulated depreciation & depletion-683 M-712 M
Additional paid in capital203 M208 M
Cash and equivalents23 M20 M
CashCashEquivalentsAndShortTermInvestments23 M20 M
Common par400000400000
Common stock equity150 M-49 M
CommonStock400000400000
Cost in excess162 M162 M
CurrentAccruedExpenses142 M119 M
CurrentCapitalLeaseObligation174 M178 M
CurrentDeferredRevenue41 M42 M
CurrentDeferredTaxesAssets259 M300 M
CurrentDeferredTaxesLiabilities-346 M-317 M
DividendsPayable-13 M-14 M
Float term debt1,512 M1,683 M
GoodwillAndOtherIntangibleAssets532 M434 M
Gross fixed assets (Plant Property & Equipment)1,758 M1,778 M
IncomeTaxPayable24 M25 M
Intangibles370 M272 M
InterestPayable6000002 M
Inventories659 M584 M
Invested capital2,440 M2,610 M
Leases15 M14 M
LongTermCapitalLeaseObligation733 M707 M
LongTermDebtAndCapitalLeaseObligation1,512 M1,683 M
Net fixed assets (net PP&E)1,075 M1,066 M
Non-current deferred income taxes88 M17 M
NonCurrentDeferredLiabilities88 M17 M
NonCurrentDeferredTaxesAssets263 M304 M
Number of employees2200022000
Other current assets1 M1000000
Other fixed assets1,075 M1,066 M
Other non-current assets35 M38 M
Other non-current liabilities36 M29 M
Other receivable2,418 M2,217 M
OtherCurrentLiabilities10 M18 M
OtherInventories659 M584 M
Payables254 M198 M
Prepaid expenses39 M39 M
Retained earnings-23 M-231 M
Short term debt7 M7 M
Total assets2,362 M2,181 M
Total current assets720 M643 M
Total current liabilities577 M501 M
Total equity150 M-49 M
Total liabilities2,212 M2,230 M
Total non-current assets1,642 M1,538 M
Total non-current liabilities1,636 M1,729 M
TotalEquityGrossMinority150 M-49 M
TotalEquityGrossMinorityInterest150 M-49 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest2,362 M2,181 M
TotalNonCurrentLiabilitiesNetMinorityInteres1,636 M1,729 M
Treasury stock-31 M-27 M
UnearnedPremiums-9 M-8 M
Working capital144 M142 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