Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Western Digital Corporation logo

Western Digital Corporation

Sector: Technology   

Industry: Data Storage

69.44
 
USD
  
-0.11
  
(-0.16%)
Optionable: Yes  Market Cap: 22,784 M  90-day average vol: 6,663,463

Previous close: 69.55  Open: 66.74  Bid: 68.46  Ask: 68.61
52 week range    
32.01   
   76.92
Peers   
NTAP / 
STX / 
HPQ / 
NTGR / 
SMCI / 
Last updated: Friday 26th April 2024
60
MarketXLS Rank
60
Value
84
Technical
36
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

Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

HPQ

0.026741 B6.937.49

NTAP

0.022919 B20.987.33

NTGR

1 B10.626.21

SMCI

2 B19.438.01

STX

0.025624 B13.5109.44

TDC

5 B38.440.28
Financials

WDC Income Statement

Annual
Jun-14Jun-15Jun-16Jun-17Jun-18Jun-19Jun-20Jun-21Jun-22Jun-23
AccruedPreferredStockDividends24 M
Amortization of intangibles-213 M-266 M-1,169 M-1,185 M-968 M486 M221 M133 M
Basic EPS from continuing operations2.694.81-5.44
Basic EPS total6.886.311.011.382.27-2.58-0.842.694.81-5.44
Basic weighted shares outstanding235 M232 M239 M288 M297 M292 M298 M305 M312 M318 M
Cost of sales10,770 M10,351 M9,559 M13,021 M12,942 M12,817 M12,955 M12,401 M12,919 M10,431 M
Depreciation-888 M-960 M-871 M-844 M726 M708 M695 M
DepreciationAndAmortization-888 M-960 M-871 M-844 M726 M708 M695 M
Diluted EPS total6.686.181.01.342.2-2.58-0.842.664.75-5.44
Diluted normalized net income/share2.664.75-5.44
Diluted weighted shares outstanding242 M237 M242 M296 M307 M292 M298 M309 M316 M318 M
Dividends paid per share1.82.02.02.02.01.5
Earnings from equity interest579 M
EarningsFromEquityInterestNetOfTax579 M
GainOnSaleOfBusiness3 M
GainOnSaleOfPPE75 M7 M
GainOnSaleOfSecurity3 M55 M17 M
GeneralAndAdministrativeExpense-59 M-59 M232 M-49 M-47 M1,105 M1,117 M970 M
Gross operating profit4,360 M4,221 M3,435 M6,072 M7,705 M3,752 M3,781 M4,521 M5,874 M1,887 M
ImpairmentOfCapitalAssets-53 M-37 M-11 M-16 M
Income before tax1,752 M1,577 M153 M769 M2,085 M-287 M-46 M927 M2,123 M-1,560 M
Income restructuring and M&A-95 M-104 M-632 M-281 M-215 M-166 M-47 M50 M
Income taxes135 M112 M-89 M372 M1,410 M467 M204 M106 M623 M146 M
InsuranceAndClaims215 M
Interest income-39 M14 M26 M26 M60 M57 M28 M7 M6 M24 M
InterestExpenseNonOperating49 M266 M847 M676 M469 M413 M326 M304 M312 M
MiscOtherSpecialCharges1000000.0-73 M-364 M-916 M38 M4 M26 M30 M13 M
Net income from total operations1,617 M1,465 M242 M397 M675 M-754 M-250 M821 M1,500 M-1,706 M
NetIncomeCommonStockholders1,617 M1,465 M242 M397 M675 M-754 M-250 M821 M1,500 M-1,730 M
NetIncomeContinuousOperations1,617 M1,465 M242 M397 M675 M-754 M-250 M821 M1,500 M-1,706 M
NetNonOperatingInterestIncomeExpense-39 M-35 M-240 M-821 M-616 M-412 M-385 M-319 M-298 M-288 M
NonRecurringOperationExpense-75 M-7 M
Normalized income535 M1,677 M-1,232 M
Operating income1,791 M1,611 M466 M1,954 M3,617 M87 M335 M1,126 M2,477 M-899 M
Operating income before depreciation (EBITDA)2,996 M2,740 M1,612 M4,029 M5,038 M2,032 M1,973 M2,505 M3,400 M-407 M
OperatingExpense2,569 M2,610 M2,969 M4,118 M4,088 M3,665 M3,446 M3,301 M3,483 M3,172 M
Other income net-3 M-1000000.073 M364 M916 M-38 M-4 M-26 M-30 M-13 M
OtherGandA-59 M-59 M232 M-49 M-47 M1,105 M1,117 M970 M
OtherOperatingExpenses147 M176 M345 M-4,118 M-4,088 M166 M32 M47 M-43 M-193 M
OtherWriteDown-4 M-274 M
OtherunderPreferredStockDividend24 M
PreferredStockDividends24 M
PromotionAndAdvertising-60 M-60 M-89 M-112 M-107 M84 M88 M69 M
RentAndLandingFees-59 M-59 M232 M-49 M-47 M
Research & development expense1,661 M1,646 M1,627 M2,441 M2,400 M2,182 M2,261 M2,243 M2,323 M2,009 M
ResearchExpense1,661 M1,646 M1,627 M2,441 M2,400 M2,182 M2,261 M2,243 M2,323 M2,009 M
RestructringAndMnAIncome-95 M-104 M-632 M-281 M-215 M-166 M-47 M50 M
Revenue per share-213 M-266 M-1,169 M-1,185 M-968 M486 M250 M133 M
SalariesAndWages-85 M-191 M-394 M-377 M-306 M-47 M-48 M-43 M
Selling Gen & administrative expense761 M788 M997 M1,677 M1,688 M1,317 M1,153 M1,105 M1,117 M970 M
SellingAndMarketingExpense761 M788 M997 M1,445 M1,688 M1,317 M1,153 M84 M88 M69 M
SellingExpense761 M788 M997 M1,445 M1,688 M1,317 M1,153 M
Special income/charges148 M104 M669 M292 M231 M166 M122 M-43 M
Total Income available for interest expense (EBIT)1,752 M1,626 M419 M1,616 M2,761 M182 M367 M1,253 M2,427 M-1,248 M
Total common shares outstanding234 M230 M284 M295 M291 M296 M303 M309 M314 M322 M
Total net income1,617 M1,465 M242 M397 M675 M-754 M-250 M821 M1,500 M-1,706 M
Total ordinary shares326 M326 M326 M326 M326 M326 M326 M326 M326 M326 M
Total revenues15,130 M14,572 M12,994 M19,093 M20,647 M16,569 M16,736 M16,922 M18,793 M12,318 M
TotalExpenses13,339 M12,961 M12,528 M17,139 M17,030 M16,482 M16,401 M15,702 M16,402 M13,603 M
TotalRevenue15,130 M14,572 M12,994 M19,093 M20,647 M16,569 M16,736 M16,922 M18,793 M12,318 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