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

2.07
 
USD
  
-0.26
  
(-0.11158798)
Optionable: Yes  Market Cap: 66698365.0  90-day average vol: 1435226.0

Previous close: 2.33  Open: 2.29  Bid: 2.06  Ask: 2.15
52 week range    
2.06   
   11.06
Last updated: Sunday 16th June 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

Metrics

Valuation

0.014

0.23

-0.0

9.64

NA , NA

Returns

-0.1

-0.4623376623376624

-0.42817679558011057

-0.7269129287598944

-0.9653657924457272

-0.9166867906302826

-0.7342747111681643

Risk

2.357

1.6162

Ranks

50.0

30.0

Dividends

0.0

2023-03-31

0.0

-2.03

Analyst Estimates

-11.62

-8.95

-3.53

-3.67

3.38

4.0

3.33

3.33

Financial Health

-8.54

1.3

0.1

7.96

68.54

Technicals

27.5466952274

2.90857142857

2.7681

80.0695803381

0.302181176954

3.4142

4.7719

20.1015157733

-0.305615707417

Growth

Profitability

-13.74

-8.2

-91.93

-16.09

35.7

Peers

StockDividendMarket Cap (B)PEPrice ($)
Financials

BIG Income Statement

Annual
Jan-14Jan-15Jan-16Jan-17Jan-18Jan-19Jan-20Jan-21Jan-22Jan-23
Basic EPS from continuing operations2.462.492.833.376.185.43-7.3
Basic EPS total2.182.082.833.374.433.846.1816.465.43-7.3
Basic weighted shares outstanding57 M55 M51 M45 M43 M41 M39 M38 M33 M29 M
BasicDiscontinuousOperations-0.28-0.41
Cost of sales3,117 M-3,133 M-3,123 M3,101 M3,122 M3,116 M3,208 M-3,702 M3,754 M3,555 M
Depreciation113 M120 M123 M120 M117 M125 M135 M138 M143 M155 M
Depreciation unreconciled113 M120 M123 M120 M117 M125 M135 M138 M143 M155 M
DepreciationAndAmortization113 M120 M123 M120 M117 M125 M135 M138 M143 M155 M
Diluted EPS total2.162.062.83.324.383.836.1616.115.33-7.3
Diluted normalized net income/share2.442.462.813.326.165.33-7.3
Diluted weighted shares outstanding58 M56 M51 M46 M43 M41 M39 M39 M33 M29 M
DilutedDiscontinuousOperations-0.28-0.4
Dividends paid per share0.510.760.841.01.21.21.2
GainOnSaleOfBusiness-83000.0-2 M-2 M-24 M
GeneralAndAdministrativeExpense-310 M-315 M-315 M-322 M-346 M1,823 M-424 M2,015 M2,040 M
Gross operating profit2,007 M2,044 M2,067 M2,099 M-3,122 M-3,116 M2,115 M2,497 M2,397 M1,914 M
ImpairmentOfCapitalAssets-13 M-3 M-400000.0-100000.0-100000.0400000.0-900000.0900000.018 M
Income before tax227 M222 M227 M244 M295 M208 M318 M845 M232 M-280 M
Income restructuring and M&A38 M
Income taxes86 M85 M84 M91 M106 M51 M75 M215 M54 M-70 M
InterestExpenseNonOperating3 M3 M4 M5 M7 M10 M17 M11 M9 M20 M
InterestExpenseOperating-3 M-2 M-3 M-4 M-10 M-17 M-6 M-8 M-22 M
MiscOtherSpecialCharges-12000.0200000.0-5 M1 M5,265 M5,238 M-451000.06,198 M1 M1 M
Net income from total operations141 M137 M143 M153 M190 M157 M242 M629 M178 M-211 M
NetIncomeCommonStockholders141 M137 M143 M153 M190 M157 M-115 M629 M178 M-211 M
NetIncomeContinuousOperations141 M137 M143 M153 M190 M157 M242 M629 M178 M-211 M
NetIncomeDiscontinuousOperations124000.0448000.0135000.059000.0
NetNonOperatingInterestIncomeExpense-3 M-3 M-4 M-5 M-7 M-10 M-17 M-11 M-9 M-20 M
Operating income230 M224 M236 M248 M-4,963 M-5,020 M335 M-5,343 M240 M-261 M
Operating income before depreciation (EBITDA)330 M328 M335 M353 M408 M322 M682 M1,235 M642 M146 M
OperatingExpense1,777 M1,819 M1,831 M1,851 M1,841 M1,903 M2,137 M1,641 M2,157 M2,215 M
Other income net12000.02 M5 M-1 M-5,265 M-5,238 M451000.0-6,198 M-1 M-1 M
OtherGandA-310 M-315 M-315 M-322 M-346 M1,823 M-424 M2,015 M2,040 M
OtherImpairmentOfCapitalAssets4 M-900000.0
OtherOperatingExpenses-5 M-898000.0-939000.0-822000.0-180 M-976000.0-251 M-410000.0-357000.0
PromotionAndAdvertising-98 M-97 M-91 M-92 M-94 M95 M-103 M98 M98 M
RentAndLandingFees-310 M-315 M-315 M-322 M-346 M
RestructringAndMnAIncome38 M
Revenue per share2 M1 M2 M2 M4 M-4 M3 M2 M
SalariesAndWages-13 M-10 M-13 M-33 M-26 M179 M-463 M20 M
Selling Gen & administrative expense1,664 M1,700 M1,709 M1,731 M1,724 M1,778 M1,823 M1,966 M2,015 M2,040 M
SellingAndMarketingExpense1,664 M1,700 M1,709 M1,731 M1,724 M1,778 M95 M1,966 M98 M98 M
SellingExpense1,664 M1,700 M1,709 M1,731 M1,724 M1,778 M1,966 M
Special income/charges13 M4 M400000.0100000.0100000.0-39 M900000.0-900000.0-18 M
Total Income available for interest expense (EBIT)227 M223 M227 M245 M302 M208 M317 M849 M233 M-282 M
Total common shares outstanding58 M54 M50 M45 M42 M40 M39 M35 M29 M29 M
Total net income141 M137 M143 M153 M190 M157 M242 M629 M178 M-211 M
Total ordinary shares30 M30 M30 M30 M30 M30 M30 M30 M30 M30 M
Total revenues5,125 M5,177 M5,191 M5,200 M5,271 M5,238 M5,323 M6,199 M6,151 M5,468 M
TotalExpenses4,895 M-1,314 M-1,292 M4,952 M4,963 M5,020 M5,345 M-2,061 M5,911 M5,770 M
TotalRevenue5,125 M5,177 M5,191 M5,200 M5,271 M5,238 M5,323 M6,199 M6,151 M5,468 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