Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

*Could you help me with the ratios for Mattel, Inc. and Subsidiaries? I'm having trouble the formulas, so if you could add them in your

*Could you help me with the ratios for Mattel, Inc. and Subsidiaries? I'm having trouble the formulas, so if you could add them in your explanation for me to further understand them, that would be very much appreciated.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Mattel, Inc. and Subsidiaries Consolidated Statements of Operations As of December 31, 2021, December 31, 2020, December 31, 2019 Dollars in Thousands, Except Share and Per Share Data Twelve Months Ended December 31, 2020 December 31, 2021 $ Change % Change $ Change % Change December 21, 2019 $ 1.86% $ -7.20% 13.44% -4.44% -3.41% 910.02% -1.35% -36.02% Net Sales Cost of sales Gross Profit Advertising and promotion expenses Other selling and administrative expenses Operating Income Interest expense Interest (income) Other non-operating expense, net Income (Loss) Before Income Taxes (Benefit) provision for income taxes Income (loss) from equity method investments Net Income (Loss) Net Income (Loss) Per Common Share - Basic Weighted average number of common shares Net Income (Loss) Per Common Share - Diluted Weighted-average number of common and potential common shares 5,457,741 2,831,079 2,626,662 545,674 1,351,426 729,562 253,937 (3,503) 8,364 470,764 (420,381) 11,842 902,987.00 2.58 350,007 2.53 357,253 869,308 485,749 383,559 19,871 8,862 354,826 55,605 442 5,672 293,107 (485,930) 371 779,408 2.22 2,544 2.18 8,137 18.95% $ 20.71% 17.10% 3.78% 0.66% 94.69% 28.04% -11.20% 210.70% 164.98% -741.32% 3.23% 630.70% $ 616.67% $ 0.73% 622.86% $ 2.33% 4,588,433 2,345,330 2,243,103 525,803 1,342,564 374,736 198,332 (3,945) 2,692 177,657 65,549 11,471 123,579 0.36 347,463 0.35 349,116 43.27% 83,862 (181,900) 265,762 (24,414) (47,458) 337,634 (2,712) 2,221 813 337,312 7,225 12,242 342,329 0.99 1,336 0.98 2,989 4,504,571 2,527,230 1,977,341 550,217 1,390,022 37,102 201,044 (6,166) 1,879 (159,655) 58,324 (771) (218,750) (0.63) 346,127 (0.63) 346,127 -211.28% 12.39% -1587.81% $ -156.49% $ -157.14% $ $ $ 0.39% $ -155.56% $ 0.86% Mattel, Inc. and Subsidiaries Consolidated Balance Sheets As of December 31, 2021, December 31, 2020, December 31, 2019 Dollars in Thousands, Except Share and Per Share Data Twelve Months Ended December 31, 2020 December 31, 2021 $ Change % Change $ Change % Change December 31, 2019 731,362 1,072,684 777,184 293,299 2,874,529 (30,819) 38,718 248,710 121,229 377,838 -4.04% $ 3.74% 47.06% 70.45% 15.13% 762,181 1,033,966 528,474 172,070 2,496,691 132,153 97,607 32,970 (14,013) 248,717 20.98%. $ 10.42% 6.65% -7.53% 11.06% 630,028 936,359 495,504 186,083 2,247,974 ASSETS Current Assets Cash and equivalents Accounts receivable Inventories Prepaid expenses and other current assets Total current assets Noncurrent Assets Property, plant, and equipment, net Right-of-use assets, net Goodwill Deferred income tax assets Identifiable intangible assets, net Other noncurrent assets Total Assets LIABILITIES AND STOCKHOLDERS' EQUITY Current Liabilities Short-term borrowings Accounts payable Accrued liabilities Income taxes payable Total current liabilities 550,139 303,187 1,390,714 455,966 325,484 1,390,207 526,906 476,858 343,944 6,393,894 (17,828) 33,883 (3,687) 454,224 (41,332) 55,846 859,004 -3.76% $ 11.62% -0.26% 624.95% -7.98% 19.38% 15.52% $ 473,794 291,601 1,393,894 72,682 518,190 288,098 5,534,890 (76,345) (11,586) 3,180 72,682 518,190 (545,114) 209,664 -13.88% -3.82% 0.23% 0.00% 0.00% -65.42% 3.94% $ 833,212 5,325,226 $ $ 579,152 991,592 27,509 (969) 83,789 159,670 384 -100.00% $ 16.91% 19.19% 1.42% 969 495,363 831,922 27,125 969 36,006 62,409 (20,912) 0.00% $ 7.84% 8.11% -43.53% 459,357 769,513 48,037 1,598,253 242,874 17.92% 1,355,379 78,472 6.15% 1,276,907 Noncurrent Liabilities Long-term debt Noncurrent lease liabilities Other noncurrent liabilities Total noncurrent liabilities 270,992 283,626 372,174 3,226,792 (2,583,672) 34,273 (93,176) (342,575) -90.51% 13.74% -20.02% -9.60% 2,854,664 249,353 465,350 3,569,367 7,913 (21,500) 26,349 12,762 0.28% -7.94% 6.00% 0.36% 2,846,751 270,853 439,001 3,556,605 Stockholders' Equity Common stock Additional paid-in capital Treasury stock at cost Retained earnings Accumulated other comprehensive loss Total stockholders' equity Total Liabilities and Stockholders' Equity 441,369 1,832,144 (2,219,990) 2,456,597 (941,271) 1,568,849 6,393,894 (10,536) 62,949 902,987 3,305 958,705 859,004 0.00% -0.57% -2.76% 58.12% -0.35% 157.13% 15.52%. $ 441,369 1,842,680 (2,282,939) 1,553,610 (944,576) 610,144 5,534,890 (100) 17,111 35,982 140,429 (75,092) 118,430 209,664 -0.02% 0.94% -1.55% 9.94% 8.64% 24.09% 3.94% $ 441,469 1,825,569 (2,318,921) 1,413,181 (869,484) 491,714 5,325,226 $ Mattel, Inc. and Subsidiaries Consolidated Statements of Cash Flows As of December 31, 2021, December 31, 2020, December 31, 2019 Dollars in Thousands, Except Share and Per Share Data Twelve Months Ended December 31, 2021 $ Change % Change December 31, 2020 $ Change % Change December 31, 2019 $ 902,987 779,408 630.70% $ 123,579 $ 342,329 -156.49% $ (218,750) Net income (loss) Adjustments to reconcile net income (loss) to net cash flows provided by operating activities: Depreciation Amortization Share-based compensation Bad debt expense Inventory obsolescence Asset impairments Deferred income taxes (Income) loss from equity method investments Loss on extinguishment of long-term borrowings (Gain) loss on sale of assets/business, net Release of valuation allowances on deferred tax assets Changes in assets and liabilities: Accounts receivable Inventories Prepaid expenses and other current assets Accounts payable, accrued liabilities, and income taxes payable Other, net Net cash flows provided by operating activities 146,274 38,039 60,081 202 40,881 9,690 56,658 (11,842) 101,695 (23,823) (540,803) (8,252) (886) (87) (7,947) (3,125) (3,316) 61,958 (1,090) 101,695 (24,851) (540,803) -5.34% -2.28% -0.14% -86.86% -7.10% -25.50% -1169.02% 10.14% 0.00% -2417.41% 0.00% 154,526 38,925 60,168 9,149 44,006 13,006 (5,300) (10,752) (49,880) (1,187) 4,200 8,182 (31,133) (28,208) 736 (11,523) (9,236) 2,549 13,489 -24.40% -2.96% 7.50% 846.12% -41.43% -68.44% -12.19% -1494.55% -100.00% -167.59% -100.00% 204,406 40,112 55,968 967 75,139 41,214 (6,036) 771 9,236 (1,521) (13,489) 1,028 -7.24% 684.25% (85,603) (330,899) (26,533) 207,143 (59,684) 485,463 6,677 (288,706) (6,494) 189,740 (54,154) 199,767 32.41% 1090.27% 979.28% 69.92% (92,280) (42,193) (20,039) 17,403 (5,530) 285,696 (133,309) (19,507) (69,110) 72,055 26,813 117,260 -324.91% 85.99% -140.84% -131.84% -82.90% 69.62% 41,029 (22,686) 49,071 (54,652) (32,343) 168,436 (74,222) (77,131) 1,585 43,649 1,022 105,097 (14,818) (17,742) 24,468 37,834 (2,735) (27,007) 24.94% 29.87% -106.93% 650.63% -72.80% -20.44% (59,404) (59,389) (22,883) 5,815 3,757 132,104 (6,410) (8,572) (22,202) 2,513 4,202 233,739 12.10% 16.87% 3260.21% 76.11% -944.27% -229.98% (52,994) (50,817) (681) 3,302 (445) (101,635) 969 Cash Flows From Investing Activities: Purchases of tools, dies, and molds Purchases of other property, plant, and equipment Proceeds from (payments of) foreign currency forward exchange contracts, net Proceeds from sale of assets/business Other, net Net cash flows used for investing activities Cash Flows From Financing Activities: (Payments of) proceeds from short-term borrowings, net Payments of long-term borrowings Proceeds from long-term borrowings, net Option proceeds and tax withholdings for share-based compensation, net Other, net Net cash flows used for financing activities Effect of Currency Exchange Rate Changes on Cash and Equivalents Change in Cash and Equivalents Cash and Equivalents at Beginning of Period Cash and Equivalents at End of Period Supplemental Cash Flow Information: Cash paid during the year for: Income taxes, gross Interest (969) (1,575,997) 1,184,913 (7,856) (2,165) (402,074) (9,111) (30,819) 762,181 731,362 (1,938) (1,575,997) 1,184,913 (657) (2,553) (396,232) 6,486 (162,972) 132,153 (30,819) -200.00% 0.00% 0.00% 9.13% -657.99% 6782.47% -41.58% -123.32% 20.98% -4.04% $ (7,199) 388 (5,842) (15,597) 132,153 630,028 762,181 5,145 607,898 (588,244) 311 2,186 27,296 (17,481) 96,606 35,547 132,153 -123.20% -100.00% -100.00% -4.14% -121.58% -82.37% -927.87% 271.77% 5.98% 20.98% $ (4,176) (607,898) 588,244 (7,510) (1,798) (33,138) 1,884 35,547 594,481 630,028 $ $ $ 93,129 210,140 (6,366) 19,466 -6.40% 10.21% 99,495 190,674 26,848 (248) 36.96% $ -0.13% 72,647 190,922 Build-A-Bear Workshop, Inc. and Mattel, Inc. and Subsidiaries Ratios Statement As of 2021, 2020, 2019 Mattel, Inc. and Subsidiaries 2021 2020 2019 Ratios: Liquidity Ratios: Current Ratio Quick Ratio Activity Ratios: Inventory Turnover Days in Inventory Total Assets Turnover Total Fixed Asset Turnnover Accounts Receivable Tirnover Days in AR Leverage Ratios: Debt to Total Assets Ratio Debt Equity Ratio Long-term Debt to Equity Times Interest Earned Ratio Profitability Ratios: Gross Profit Margin Operating Profit Margin Net Profit Margin Retun on Total Assets (ROA) Return on Stockholders' Equity (ROE) Market Prospects: Earnings Per Share (EPS) Price Earnings Ratio Stock price = 21.95

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Principles And Practice

Authors: Kumar And Sharma

3rd Edition

8120350987, 9788120350984

More Books

Students also viewed these Accounting questions