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

Mattel Inc.

Sector: Consumer Cyclical   

Industry: Leisure

18.05
 
USD
  
-0.12
  
(-0.66%)
Optionable: Yes  Market Cap: 6,182 M  90-day average vol: 3,047,910

Previous close: 18.17  Open: 18.02  Bid: 18.08  Ask: 18.25
52 week range    
16.20   
   22.64
Peers   
HAS / 
JAKK / 
EA / 
IGT / 
DIS / 
Last updated: Monday 22nd April 2024
45
MarketXLS Rank
60
Value
15
Technical
60
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 ($)

BBW

0 B8.319.01

DIS

263 B131.2142.51

EA

0.00537 B49136.4

HAS

0.029213 B28.393

IGT

0.02816 B25.528.45

JAKK

0 B-1.410.32
Financials

MAT Income Statement

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Amortization of intangibles-37 M-28 M-22 M-23 M-39 M1,391 M1,394 M-2 M1,379 M1,385 M
Basic EPS from continuing operations-0.620.362.581.110.61
Basic EPS total1.461.080.93-3.07-1.55-0.620.362.581.110.61
Basic weighted shares outstanding339 M339 M341 M344 M345 M346 M347 M350 M354 M354 M
Cost of sales-3,023 M-2,896 M-2,902 M-3,061 M-2,716 M2,524 M2,345 M2,831 M2,953 M2,858 M
Depreciation-249 M-265 M-262 M-275 M-272 M245 M193 M184 M182 M177 M
DepreciationAndAmortization-249 M-265 M-262 M-275 M-272 M245 M193 M184 M182 M177 M
Diluted EPS total1.451.080.92-3.07-1.55-0.620.362.531.10.6
Diluted normalized net income/share-0.620.362.531.10.6
Diluted weighted shares outstanding341 M340 M344 M344 M345 M346 M349 M357 M360 M357 M
Dividends paid per share1.521.521.520.91
Earnings from equity interest25 M18 M
EarningsFromEquityInterestNetOfTax25 M18 M
GainOnSaleOfBusiness-59 M
GeneralAndAdministrativeExpense1,614 M1,548 M1,400 M1,518 M1,509 M967000.09 M1 M18 M-2 M
Gross operating profit3,001 M2,806 M2,554 M1,825 M1,799 M1,981 M2,243 M2,627 M2,481 M2,584 M
ImpairmentOfCapitalAssets-56 M-18 M39 M2 M
Income before tax587 M464 M410 M-501 M-417 M-158 M178 M471 M504 M465 M
Income restructuring and M&A-45 M-110 M
Income taxes88 M94 M92 M549 M116 M55 M66 M-420 M136 M269 M
Interest income7 M7 M9 M8 M6 M6 M4 M4 M9 M25 M
InterestExpenseNonOperating79 M85 M95 M105 M182 M201 M198 M254 M133 M124 M
MarketingExpense733 M718 M635 M642 M524 M552 M526 M546 M534 M525 M
MiscOtherSpecialCharges5 M1 M-24 M-68 M-7 M-2 M-3 M-8 M-48 M2 M
Net income from total operations-5,525 M-5,333 M318 M-1,054 M-533 M-214 M124 M903 M394 M214 M
NetIncomeCommonStockholders-5,525 M-5,333 M318 M-1,054 M-533 M-214 M124 M879 M394 M214 M
NetIncomeContinuousOperations-5,525 M-5,333 M318 M-1,054 M-533 M-214 M124 M903 M394 M214 M
NetIncomeDiscontinuousOperations-59 M
NetIncomeFromOtherGainsLosses-771000.011 M-12 M-25 M
NetNonOperatingInterestIncomeExpense-72 M-78 M-86 M-97 M-175 M-195 M-194 M-250 M-123 M-99 M
Normalized income52 M368 M
Operating income-5,370 M-5,162 M519 M-339 M-234 M39 M375 M730 M676 M562 M
Operating income before depreciation (EBITDA)915 M815 M767 M-121 M37 M288 M569 M909 M875 M818 M
OperatingExpense2,347 M2,265 M2,035 M2,160 M2,033 M1,942 M1,868 M1,897 M1,806 M2,022 M
Other income net-5 M-1 M24 M68 M7 M2 M3 M8 M22 M-21 M
OtherGandA1,614 M1,548 M1,400 M1,518 M1,509 M967000.09 M1 M18 M-2 M
OtherOperatingExpenses-242 M-265 M-229 M-244 M-224 M-4 M-6 M-5 M-5 M-6 M
PromotionAndAdvertising-324 M-297 M-250 M-294 M
RentAndLandingFees-121 M-115 M-110 M-137 M-127 M-6 M
Research & development expense-209 M-218 M-215 M-225 M-205 M197 M189 M189 M195 M199 M
ResearchExpense197 M189 M189 M195 M199 M
RestructringAndMnAIncome-45 M-110 M
Revenue per share-37 M-28 M-22 M-23 M-39 M1,391 M1,394 M-2 M1,379 M1,385 M
SalariesAndWages-68 M-57 M-58 M-67 M-49 M56 M60 M-7 M-9 M-10 M
Selling Gen & administrative expense2,347 M2,265 M2,035 M2,160 M2,033 M1,942 M1,868 M1,897 M1,806 M2,022 M
SellingAndMarketingExpense733 M718 M635 M642 M524 M1,942 M1,868 M1,897 M1,806 M2,022 M
Special income/charges101 M22 M-39 M-2 M
Total Income available for interest expense (EBIT)666 M549 M505 M-396 M-235 M44 M376 M725 M637 M589 M
Total common shares outstanding338 M340 M342 M344 M345 M347 M348 M352 M356 M344 M
Total net income-5,525 M-5,333 M318 M-1,054 M-533 M-214 M124 M903 M394 M214 M
Total ordinary shares344 M344 M344 M344 M344 M344 M344 M344 M344 M344 M
Total revenues6,718 M6,284 M5,457 M4,882 M4,515 M4,505 M4,588 M5,458 M5,435 M5,441 M
TotalExpenses-675 M-631 M-867 M-901 M-683 M4,465 M4,214 M4,728 M4,759 M4,880 M
TotalRevenue6,024 M5,703 M5,457 M4,881 M4,515 M4,505 M4,588 M5,458 M5,435 M5,441 M
WriteDown-4 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