Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Big Lots Inc. logo

Big Lots Inc.

Sector: Consumer Defensive   

Industry: Discount Stores

3.43
 
USD
  
-0.21
  
(-5.77%)
Optionable: Yes  Market Cap: 102 M  90-day average vol: 1,529,088

Previous close: 3.64  Open: 3.63  Bid: 3.45  Ask: 3.47
52 week range    
3.13   
   11.06
Peers   
DG / 
DLTR / 
TGT / 
COST / 
Last updated: Wednesday 24th April 2024
51
MarketXLS Rank
80
Value
23
Technical
50
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

BIG Balance Sheet

Annual
Jan-14Jan-15Jan-16Jan-17Jan-18Jan-19Jan-20Jan-21Jan-22Jan-23
"""debtc"""212 M226 M242 M252 M
Accounts payable366 M359 M382 M400 M351 M397 M378 M398 M587 M422 M
Accrued expenses540 M549 M638 M638 M551 M600 M623 M740 M800 M606 M
Accumulated depreciation & depletion-1,171 M-1,211 M-1,233 M-1,305 M-1,356 M-1,359 M-1,352 M-1,221 M-1,295 M-1,269 M
Additional paid in capital562 M574 M588 M618 M623 M623 M621 M635 M641 M628 M
Cash and equivalents69 M52 M54 M51 M51 M46 M53 M560 M54 M45 M
CashCashEquivalentsAndShortTermInvestments69 M52 M54 M51 M51 M46 M53 M560 M54 M45 M
CashEquivalents69 M52 M54 M51 M51 M46 M53 M560 M54 M
Common par1 M1 M1 M1 M1 M1 M1 M1 M1 M1 M
Common stock equity901 M790 M720 M651 M670 M693 M845 M1,278 M1,007 M764 M
CommonStock1 M1 M1 M1 M1 M1 M1 M1 M1 M1 M
CurrentAccruedExpenses86 M111 M154 M125 M111 M126 M158 M188 M121 M112 M
CurrentCapitalLeaseObligation261 M248 M250 M256 M269 M280 M212 M226 M242 M252 M
CurrentDeferredAssets60 M39 M
CurrentDeferredTaxesAssets60 M154 M156 M151 M91 M101 M446 M616 M629 M663 M
CurrentDeferredTaxesLiabilities117 M107 M109 M104 M77 M9 M44 M15 M640 M606 M
DefinedPensionBenefit65 M78 M75 M
Float term debt77 M62 M62 M106 M200 M374 M279 M36 M1,573 M1,815 M
Gross fixed assets (Plant Property & Equipment)1,740 M1,761 M1,793 M1,831 M1,922 M2,181 M3,403 M3,588 M3,763 M3,580 M
IncomeTaxPayable14 M2 M25 M31 M8 M1 M4 M44 M894000.0845000.0
InterestPayable3 M
Inventories915 M852 M850 M859 M873 M970 M921 M940 M1,238 M1,148 M
Invested capital978 M852 M783 M757 M869 M1,067 M1,125 M1,313 M2,584 M1,065 M
Leases4 M24 M32 M31 M29 M30 M28 M26 M
LongTermCapitalLeaseObligation1,035 M1,465 M1,570 M1,514 M
LongTermDebtAndCapitalLeaseObligation77 M62 M62 M106 M200 M374 M1,315 M1,501 M1,573 M1,815 M
Net fixed assets (net PP&E)570 M551 M560 M526 M566 M822 M2,051 M2,366 M2,468 M2,311 M
Non-current deferred income taxes72 M67 M71 M71 M51 M66 M49 M8 M21 M113 M
NonCurrentDeferredAssets5 M46 M48 M46 M14 M9 M5 M16 M11 M56 M
NonCurrentDeferredLiabilities76 M66 M59 M56 M58 M61 M49 M8 M21 M
NonCurrentDeferredTaxesAssets5 M46 M48 M46 M14 M9 M5 M16 M11 M56 M
NonCurrentPensionAndOtherPostretirementBenefitPlans8 M23 M20 M
Number of employees10200.010200.010200.010200.010200.010200.010200.010200.010200.010200.0
Other current assets78 M95 M90 M85 M98 M112 M90 M86 M119 M93 M
Other equity adjustments-14 M-15 M-16 M
Other fixed assets2,468 M2,311 M
Other non-current assets44 M40 M38 M41 M50 M64 M69 M69 M37 M38 M
Other non-current liabilities107 M130 M120 M116 M119 M112 M110 M250 M201 M192 M
Other receivable5,264 M5,238 M5,323 M6,199 M6,151 M5,468 M
OtherCurrentLiabilities38 M39 M41 M40 M54 M183 M36 M35 M83 M62 M
OtherEquityInterest8 M15 M16 M
OtherInventories1,238 M1,148 M
OtherPayable105 M93 M126 M90 M143 M232 M265 M135 M161 M159 M
Payables453 M438 M484 M513 M440 M473 M464 M552 M679 M494 M
Preferred securities of subsidiary trust2 M2 M
PreferredStock2 M2 M
Retained earnings2,021 M2,107 M2,210 M2,323 M2,468 M2,575 M2,770 M3,351 M3,487 M3,240 M
Total assets1,740 M1,636 M1,640 M1,608 M1,652 M2,023 M3,189 M4,037 M3,927 M3,691 M
Total current assets1,121 M1,038 M994 M994 M1,022 M1,128 M1,064 M1,586 M1,411 M1,285 M
Total current liabilities577 M588 M678 M679 M590 M639 M871 M1,001 M1,125 M920 M
Total equity901 M790 M720 M651 M670 M693 M845 M1,278 M1,007 M764 M
Total liabilities838 M846 M920 M957 M982 M1,330 M2,344 M2,760 M2,920 M2,927 M
Total non-current assets619 M637 M646 M613 M630 M895 M2,125 M2,451 M2,516 M2,406 M
Total non-current liabilities261 M259 M241 M278 M377 M547 M1,473 M1,759 M1,795 M2,007 M
TotalEquityGrossMinority901 M790 M720 M651 M670 M693 M845 M1,278 M1,007 M764 M
TotalEquityGrossMinorityInterest901 M790 M720 M651 M670 M693 M845 M1,278 M1,007 M764 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest1,740 M1,636 M1,640 M1,608 M1,652 M2,023 M3,189 M4,037 M3,927 M3,691 M
TotalNonCurrentLiabilitiesNetMinorityInteres261 M259 M241 M278 M377 M547 M1,473 M1,759 M1,795 M2,007 M
TotalTaxPayable88 M79 M102 M113 M89 M77 M86 M153 M92 M72 M
Treasury stock-1,670 M-1,879 M-2,063 M-2,291 M-2,422 M-2,506 M-2,546 M-2,709 M-3,122 M-3,105 M
Working capital544 M451 M316 M316 M432 M489 M193 M585 M286 M365 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