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

Office Depot Inc.

Sector: Consumer Cyclical   

Industry: Specialty Retail

Optionable: Yes  Market Cap: 1,916 M  90-day average vol: 338,161

Previous close: 52.31  Open: 51.82  Bid: 50.45  Ask: 52.18
52 week range    
WSM / 
Last updated: Thursday 25th April 2024
MarketXLS Rank

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



StockDividendMarket Cap (B)PEPrice ($)


0.03081 B6.738.99


0.012338 B3.358.7


0.017512 B12.1162

ODP Income Statement

AccruedPreferredStockDividends73 M
Amortization of intangibles-56 M-86 M-67 M-47 M-39 M-46 M944 M394 M464 M464 M
Basic EPS from continuing operations0.312.
Basic EPS total-2.9-
Basic weighted shares outstanding32 M54 M55 M54 M52 M55 M55 M53 M53 M48 M
Cost of sales8,616 M12,320 M8,864 M8,313 M-7,779 M8,464 M8,183 M6,921 M6,602 M6,643 M
Depreciation-149 M-210 M-172 M-124 M-111 M-114 M204 M157 M146 M131 M
Depreciation unreconciled-209 M-313 M-253 M-181 M-159 M-192 M
DepreciationAndAmortization-209 M-313 M-253 M-181 M-159 M-192 M204 M157 M146 M131 M
Diluted EPS total-2.9-
Diluted normalized net income/share0.
Diluted weighted shares outstanding38 M54 M56 M55 M54 M56 M55 M53 M55 M49 M
Dividends paid per share0.
Earnings from equity interest382 M
EarningsFromEquityInterestNetOfTax382 M
GainOnSaleOfBusiness382 M
GainOnSaleOfPPE36 M6 M
GainsLossOnDisposalOfDiscontinuedOperations25 M
GeneralAndAdministrativeExpense-458 M-682 M-513 M-484 M-443 M-11 M2,101 M1,661 M1,558 M1,552 M
Gross operating profit2,626 M3,776 M2,863 M2,708 M2,461 M2,551 M2,464 M1,951 M1,863 M1,848 M
ImpairmentOfCapitalAssets70 M88 M13 M15 M4 M7 M56 M182 M20 M14 M
Income before tax127 M-340 M115 M459 M299 M158 M146 M-38 M231 M242 M
Income restructuring and M&A-98 M-266 M-158 M-75 M-65 M-20 M-13 M82 M-2 M-13 M
Income taxes147 M12 M23 M-220 M153 M59 M47 M25 M44 M64 M
Interest income5 M24 M22 M22 M22 M25 M23 M4 M1000000.05 M
InterestExpenseNonOperating69 M89 M91 M80 M62 M121 M89 M42 M28 M16 M
InterestExpenseOperating-65 M-68 M
MinorityInterests-2 M2,173 M
MiscOtherSpecialCharges14 M1000000.0-14 M12 M35 M21 M-6 M24 M10 M
Net income from total operations-20 M-354 M92 M679 M146 M99 M99 M-319 M-208 M166 M
NetIncomeCommonStockholders-93 M-354 M92 M679 M146 M99 M331 M141 M289 M256 M
NetIncomeContinuousOperations-20 M-354 M92 M679 M146 M99 M99 M-319 M-208 M166 M
NetIncomeDiscontinuousOperations155 M-84 M25 M35 M5 M25 M-256 M-395 M-12 M
NetNonOperatingInterestIncomeExpense-64 M-65 M-69 M-58 M-40 M-96 M-66 M-38 M-27 M-11 M
NonRecurringOperationExpense81 M25 M
Normalized income216 M204 M
Operating income-135 M-106 M196 M546 M331 M286 M191 M6 M234 M243 M
Operating income before depreciation (EBITDA)340 M-6 M459 M720 M523 M481 M447 M164 M407 M391 M
OperatingExpense2,761 M3,882 M2,667 M2,162 M2,130 M2,265 M1,985 M1,559 M1,507 M1,513 M
Other income net-396 M-1000000.014 M-12 M-36 M-21 M6 M-24 M-10 M
OtherGainLossFromDispositionOfDiscontinuedOperations-256 M-395 M-12 M
OtherGandA-458 M-682 M-513 M-484 M-443 M-11 M2,101 M1,661 M1,558 M1,552 M
OtherImpairmentOfCapitalAssets-26 M-1000000.046 M48 M16 M12 M
OtherOperatingExpenses-4 M-7 M-1000000.0-1000000.0-2 M540 M472 M448 M
OtherunderPreferredStockDividend73 M
PreferredStockDividends73 M
PromotionAndAdvertising-378 M-447 M-285 M-272 M-264 M-270 M249 M177 M139 M130 M
RentAndLandingFees-458 M-682 M-513 M-484 M-443 M-442 M
RestructringAndMnAIncome-98 M-266 M-158 M-75 M-65 M-20 M-13 M82 M-2 M-13 M
Revenue per share-56 M-95 M-73 M-51 M-39 M-79 M979 M423 M488 M484 M
SalariesAndWages201 M403 M242 M-80 M94 M72 M-116 M-102 M-51 M-39 M
Selling Gen & administrative expense2,560 M3,479 M2,425 M2,242 M2,036 M2,193 M2,101 M1,661 M1,558 M1,552 M
SellingAndMarketingExpense2,560 M3,479 M2,425 M2,242 M2,036 M2,193 M249 M177 M139 M130 M
SellingExpense2,560 M3,479 M2,425 M2,242 M2,036 M2,193 M
Special income/charges-70 M-169 M-13 M-15 M-4 M-32 M-56 M-182 M-20 M-14 M
Total Income available for interest expense (EBIT)131 M-319 M206 M539 M361 M279 M235 M4 M259 M258 M
Total common shares outstanding53 M55 M55 M51 M55 M54 M53 M54 M48 M40 M
Total net income-20 M-354 M92 M679 M146 M99 M99 M-319 M-208 M166 M
Total ordinary shares37 M37 M37 M37 M37 M37 M37 M37 M37 M37 M
Total revenues11,242 M16,096 M11,727 M11,021 M10,240 M11,015 M10,647 M8,872 M8,465 M8,491 M
TotalExpenses11,377 M16,202 M11,531 M10,475 M-5,649 M10,729 M10,168 M8,480 M8,109 M8,156 M
TotalRevenue11,242 M16,096 M11,727 M11,021 M10,240 M11,015 M10,647 M8,872 M8,465 M8,491 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


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.


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