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

ODP Stock Forecast, Price Targets, Chart, Dividends & Analysis

Office Depot Inc. logo

Office Depot Inc.

Sector: Consumer Cyclical   

Industry: Specialty Retail

26.63
 
USD
  
0.77
  
(2.98%)
Previous close: 25.86  Open: 26.08  Bid: 25.23  Ask: 27.48
52 week range    
23.69   
   58.98
Mkt Cap: 777 M  Avg Vol (90 Days): 554,813
Peers   
WSM / 
EBAY / 
Last updated: Friday 22nd November 2024

Stock Rankings

42
MarketXLS Rank
60
Value
15
Technical
52
Quality
How are these ranks calculated?
Ad slot not ready
Search for a stock

Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

BIG

0 B00.4968

EBAY

0.017629 B15.4561.41

WSM

0.017517 B15.68172.49
Financials

ODP Income Statement

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Amortization of intangibles-86 M-67 M-47 M-39 M-46 M944 M394 M464 M464 M403 M
Basic EPS from continuing operations0.312.62.81.81.8-6.053.543.733.61
Basic EPS total-6.60.39.83.51.91.8-6.05-3.933.483.61
Basic weighted shares outstanding54 M55 M54 M52 M55 M55 M53 M53 M48 M39 M
BasicDiscontinuousOperations0.3-2.80.70.1-7.47-0.25
Cost of sales12,320 M8,864 M8,313 M-7,779 M8,464 M8,183 M6,921 M6,602 M6,643 M6,065 M
Depreciation-210 M-172 M-124 M-111 M-114 M204 M157 M146 M131 M115 M
Depreciation unreconciled-313 M-253 M-181 M-159 M-192 M
DepreciationAndAmortization-313 M-253 M-181 M-159 M-192 M204 M157 M146 M131 M115 M
Diluted EPS total-6.60.19.63.41.91.8-6.05-3.793.373.5
Diluted normalized net income/share0.112.42.71.81.8-6.053.423.613.5
Diluted weighted shares outstanding54 M56 M55 M54 M56 M55 M53 M55 M49 M40 M
DilutedDiscontinuousOperations0.1-2.70.60.1-7.21-0.24
Dividends paid per share0.51.01.00.25
GainOnSaleOfPPE36 M6 M4 M4 M
GainsLossOnDisposalOfDiscontinuedOperations25 M
GeneralAndAdministrativeExpense-682 M-513 M-484 M-443 M-11 M2,101 M1,661 M1,558 M1,552 M1,476 M
Gross operating profit3,776 M2,863 M2,708 M2,461 M2,551 M2,464 M1,951 M1,863 M1,848 M1,766 M
ImpairmentOfCapitalAssets88 M13 M15 M4 M7 M56 M182 M20 M14 M85 M
Income before tax-340 M115 M459 M299 M158 M146 M-38 M231 M242 M200 M
Income restructuring and M&A-266 M-158 M-75 M-65 M-20 M-13 M82 M-2 M-13 M5 M
Income taxes12 M23 M-220 M153 M59 M47 M25 M44 M64 M61 M
Interest income24 M22 M22 M22 M25 M23 M4 M1000000.05 M10 M
InterestExpenseNonOperating89 M91 M80 M62 M121 M89 M42 M28 M16 M20 M
InterestExpenseOperating-68 M
MinorityInterests-2 M2,173 M
MiscOtherSpecialCharges1000000.0-14 M12 M35 M21 M-6 M24 M10 M9 M
Net income from total operations-354 M92 M679 M146 M99 M99 M-319 M-208 M166 M139 M
NetIncomeCommonStockholders-354 M92 M679 M146 M99 M331 M-319 M-208 M166 M139 M
NetIncomeContinuousOperations-354 M92 M679 M146 M99 M99 M-319 M-208 M166 M139 M
NetIncomeDiscontinuousOperations155 M-84 M25 M35 M5 M25 M-256 M-395 M-12 M
NetNonOperatingInterestIncomeExpense-65 M-69 M-58 M-40 M-96 M-66 M-38 M-27 M-11 M-10 M
NonRecurringOperationExpense81 M25 M
Operating income-106 M196 M546 M331 M286 M191 M6 M234 M243 M201 M
Operating income before depreciation (EBITDA)-6 M459 M720 M523 M481 M447 M161 M405 M389 M335 M
OperatingExpense3,882 M2,667 M2,162 M2,130 M2,265 M1,985 M1,559 M1,507 M1,513 M1,472 M
Other income net-1000000.014 M-12 M-36 M-21 M6 M-24 M-10 M-80 M
OtherGainLossFromDispositionOfDiscontinuedOperations-256 M-395 M-12 M
OtherGandA-682 M-513 M-484 M-443 M-11 M2,101 M1,661 M1,558 M1,552 M1,476 M
OtherImpairmentOfCapitalAssets-1000000.046 M48 M16 M12 M12 M
OtherOperatingExpenses-7 M-1000000.0-1000000.0-2 M540 M472 M448 M439 M
PromotionAndAdvertising-447 M-285 M-272 M-264 M-270 M249 M177 M139 M130 M128 M
RentAndLandingFees-682 M-513 M-484 M-443 M-442 M
RestructringAndMnAIncome-266 M-158 M-75 M-65 M-20 M-13 M82 M-2 M-13 M5 M
Revenue per share-95 M-73 M-51 M-39 M-79 M979 M423 M488 M484 M416 M
SalariesAndWages403 M242 M-80 M94 M72 M-116 M-102 M-51 M-39 M-4 M
Selling Gen & administrative expense3,479 M2,425 M2,242 M2,036 M2,193 M2,101 M1,661 M1,558 M1,552 M1,476 M
SellingAndMarketingExpense3,479 M2,425 M2,242 M2,036 M2,193 M249 M177 M139 M130 M128 M
SellingExpense3,479 M2,425 M2,242 M2,036 M2,193 M
Special income/charges-169 M-13 M-15 M-4 M-32 M-56 M-182 M-20 M-14 M-85 M
Total Income available for interest expense (EBIT)-319 M206 M539 M361 M279 M235 M4 M259 M258 M220 M
Total common shares outstanding55 M55 M51 M55 M54 M53 M54 M48 M40 M37 M
Total net income-354 M92 M679 M146 M99 M99 M-319 M-208 M166 M139 M
Total ordinary shares34 M34 M34 M34 M34 M34 M34 M34 M34 M34 M
Total revenues16,096 M11,727 M11,021 M10,240 M11,015 M10,647 M8,872 M8,465 M8,491 M7,831 M
TotalExpenses16,202 M11,531 M10,475 M-5,649 M10,729 M10,168 M8,480 M8,109 M8,156 M7,541 M
TotalRevenue16,096 M11,727 M11,021 M10,240 M11,015 M10,647 M8,872 M8,465 M8,491 M7,831 M
WriteDown-24 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