Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What is the Total Debt (Liabilities) for each year based on the balance sheet provided? My professor has already given the answer for 2015, which

What is the Total Debt (Liabilities) for each year based on the balance sheet provided?

My professor has already given the answer for 2015, which they say is $3,919,435 but I don't know how they got that.

2015 2016 2017 2018 2019
Total Debt (Liabilities) $3,919,435

image text in transcribedimage text in transcribed

9/16/2020 9/16/2020 Mergent Online - As Reported: Mattel Inc MATTEL Mattel Inc (NMS: MAT) Powered by Cleartit Exchange rate used is that of the Year End reported date As Reported Annual Balance Sheet Report Date 12/31/2019 12/31/2018 12/31/2017 12/31/2016 12/31/2015 Currency USD USD USD USD USD Audit Status Not D Not Not D Not D Not 1 Qualified Available Qualified Qualified Qualified Consolidated Yes Yes Yes Yes Yes Scale Thousands Thousands Thousands Thousands Thousands Cash & equivalents 630,028 594,481 1,079,221 869,531 892,814 Accounts receivable, gross 954,859 992,083 1,154,010 1,136,617 1.169,499 Allowances 18,500 22,000 25,400 21,400 24,400 Accounts receivable, net 936,359 970,083 1,128,610 1.115,217 1,145,099 Raw materials & work in process 103,123 115,966 101,690 112,327 105,917 Finished goods 392,381 426,923 499,014 501,471 481,604 Inventories 495,504 542,889 600,704 613,798 587,521 Prepaid expenses & other current 186,083 244,987 303,053 341,518 571,429 assets Total current assets 2,247,974 2,352,440 3,111,588 2,940,064 3,196,863 Land 25,112 25,023 25,114 25,113 27.049 Buildings 302,956 294,227 303,495 280,226 275,266 Machinery & equipment 812.509 875,308 902,861 828,969 764,657 Software 364,391 400,488 384,568 356,622 331,251 Tools, dies & molds 747,706 831,743 887,442 869,385 840,586 Capital leases 23,927 24,279 23,970 23,970 Leasehold improvements 183,250 240,636 213,238 261,254 245,082 Property, plant & equipment, gross 2,435,924 2,691,352 2,740,997 2,645,539 2,507,861 Less: accumulated depreciation 1,885,785 2,033,757 1,955,712 1,871,574 1,766,714 Property, plant & equipment, net 550,139 657,595 785,285 773,965 741,147 Right-of-use assets, net 303, 187 Goodwill 1,390,714 1,386,424 1,396,669 1,387,628 1,384,520 Identifiable intangibles, net 553,114 587,528 639,203 201,859 212,161 Deferred income taxes 67.900 49,937 76,750 508,363 317,391 Nonamortizable identifiable intangibles 458,589 488,144 Other noncurrent assets 212,198 209,541 229.008 223,326 212,463 https://www.mergentonline.com/companyfinancials.php?pagetype=asreported&compnumber=5302&period=Annuals&dataarea=BS&range=5¤c... 1/2 - - 9/16/2020 Mergent Online - As Reported: Mattel Inc Report Date 12/31/2019 12/31/2018 12/31/2017 12/31/2016 12/31/2015 Currency USD USD USD USD USD Audit Status Not :) Not i Not i Not 1) Not i Qualified Available Qualified Qualified Qualified Consolidated Yes Yes Yes Yes Yes Scale Thousands Thousands Thousands Thousands Thousands Total other noncurrent assets 833,212 847,006 944,961 1,392,137 1,230,159 Total assets 5,325,226 5,243,465 6,238,503 6,493,794 6,552,689 Short-term borrowings 4,176 192.168 16,914 Current portion of long-term debt 250,000 300,000 Accounts payable 459,357 537,965 572,166 664,857 651,681 Accrued advertising & promotion 93,804 86,935 165,572 85,116 75,991 Lease liability 74,065 Accrued royalties 94,228 108, 109 111,669 107,077 122,153 Accrued taxes other than income taxes 54,317 74,626 67,555 66,848 Accrued incentive compensation 122,923 87,086 20,218 18,830 52,721 Other accrued liabilities 384,493 363,974 420,054 350,248 340,512 Accrued liabilities 769,513 700,421 792,139 628,826 658,225 Income taxes payable 48,037 10,046 9,498 19,722 18,752 Total current liabilities 1,276,907 1,252,608 1,623,803 1,505,573 1,645,572 Senior notes 2,900,000 2,900,000 3,150,000 2,150,000 2,100,000 Debt issuance costs & debt discount (53,249) (48,277) (26,881) (15,729) Total debt 2,846,751 2,851,723 3,123,119 2,134,271 Less: current portion : 250,000 300,000 Long-term debt 2,846,751 2,851,723 2,873,119 2,134,271 1,800,000 Noncurrent lease liabilities 270,853 Benefit plan liabilities 212,280 166,289 168,539 192,466 195,916 Noncurrent tax liabilities 125,515 150,960 124,330 96,871 108,808 Other noncurrent liabilities 101,206 152,420 191,257 156,831 169,139 Total other noncurrent liabilities 439,001 469,669 484,126 446,168 473,863 Total noncurrent liabilities 3,556,605 3,321,392 3,357,245 2,580,439 2,273,863 Common stock 441,369 441,369 441,369 441,369 441,369 Additional paid-in capital 1,825,569 1,812,682 1,808,391 1,790,832 1,789,870 Treasury stock at cost 2,318,921 2,354,617 2,389,877 2,426,749 2,494,901 Retained earnings (accumulated deficit) 1,413,181 1,629,257 2, 179.358 3,545,359 3,745,815 Derivative instruments, net of tax 11,041 11,411 (21,098) 17,469 15,363 Available for-sale securities (8,260) (6,547) (2.799) 3,149 Defined benefit pension, net of tax (169,857) (142,763) (143,213) (157,704) (159,858) Currency translation adjustments (702,408) (721,327) (614,676) (805,943) (704,404) Accumulated other comprehensive (869,484) (859,226) (781,786) (943,029) (848,899) income (loss) Total stockholders' equity (deficit) 491,714 669,465 1,257,455 2,407,782 2,633,254 https://www.mergentonline.com/companyfinancials.php?pagetype=asreported&compnumber=5302&period=Annuals&dataarea=BS&range=5¤c... 2/2 9/16/2020 9/16/2020 Mergent Online - As Reported: Mattel Inc MATTEL Mattel Inc (NMS: MAT) Powered by Cleartit Exchange rate used is that of the Year End reported date As Reported Annual Balance Sheet Report Date 12/31/2019 12/31/2018 12/31/2017 12/31/2016 12/31/2015 Currency USD USD USD USD USD Audit Status Not D Not Not D Not D Not 1 Qualified Available Qualified Qualified Qualified Consolidated Yes Yes Yes Yes Yes Scale Thousands Thousands Thousands Thousands Thousands Cash & equivalents 630,028 594,481 1,079,221 869,531 892,814 Accounts receivable, gross 954,859 992,083 1,154,010 1,136,617 1.169,499 Allowances 18,500 22,000 25,400 21,400 24,400 Accounts receivable, net 936,359 970,083 1,128,610 1.115,217 1,145,099 Raw materials & work in process 103,123 115,966 101,690 112,327 105,917 Finished goods 392,381 426,923 499,014 501,471 481,604 Inventories 495,504 542,889 600,704 613,798 587,521 Prepaid expenses & other current 186,083 244,987 303,053 341,518 571,429 assets Total current assets 2,247,974 2,352,440 3,111,588 2,940,064 3,196,863 Land 25,112 25,023 25,114 25,113 27.049 Buildings 302,956 294,227 303,495 280,226 275,266 Machinery & equipment 812.509 875,308 902,861 828,969 764,657 Software 364,391 400,488 384,568 356,622 331,251 Tools, dies & molds 747,706 831,743 887,442 869,385 840,586 Capital leases 23,927 24,279 23,970 23,970 Leasehold improvements 183,250 240,636 213,238 261,254 245,082 Property, plant & equipment, gross 2,435,924 2,691,352 2,740,997 2,645,539 2,507,861 Less: accumulated depreciation 1,885,785 2,033,757 1,955,712 1,871,574 1,766,714 Property, plant & equipment, net 550,139 657,595 785,285 773,965 741,147 Right-of-use assets, net 303, 187 Goodwill 1,390,714 1,386,424 1,396,669 1,387,628 1,384,520 Identifiable intangibles, net 553,114 587,528 639,203 201,859 212,161 Deferred income taxes 67.900 49,937 76,750 508,363 317,391 Nonamortizable identifiable intangibles 458,589 488,144 Other noncurrent assets 212,198 209,541 229.008 223,326 212,463 https://www.mergentonline.com/companyfinancials.php?pagetype=asreported&compnumber=5302&period=Annuals&dataarea=BS&range=5¤c... 1/2 - - 9/16/2020 Mergent Online - As Reported: Mattel Inc Report Date 12/31/2019 12/31/2018 12/31/2017 12/31/2016 12/31/2015 Currency USD USD USD USD USD Audit Status Not :) Not i Not i Not 1) Not i Qualified Available Qualified Qualified Qualified Consolidated Yes Yes Yes Yes Yes Scale Thousands Thousands Thousands Thousands Thousands Total other noncurrent assets 833,212 847,006 944,961 1,392,137 1,230,159 Total assets 5,325,226 5,243,465 6,238,503 6,493,794 6,552,689 Short-term borrowings 4,176 192.168 16,914 Current portion of long-term debt 250,000 300,000 Accounts payable 459,357 537,965 572,166 664,857 651,681 Accrued advertising & promotion 93,804 86,935 165,572 85,116 75,991 Lease liability 74,065 Accrued royalties 94,228 108, 109 111,669 107,077 122,153 Accrued taxes other than income taxes 54,317 74,626 67,555 66,848 Accrued incentive compensation 122,923 87,086 20,218 18,830 52,721 Other accrued liabilities 384,493 363,974 420,054 350,248 340,512 Accrued liabilities 769,513 700,421 792,139 628,826 658,225 Income taxes payable 48,037 10,046 9,498 19,722 18,752 Total current liabilities 1,276,907 1,252,608 1,623,803 1,505,573 1,645,572 Senior notes 2,900,000 2,900,000 3,150,000 2,150,000 2,100,000 Debt issuance costs & debt discount (53,249) (48,277) (26,881) (15,729) Total debt 2,846,751 2,851,723 3,123,119 2,134,271 Less: current portion : 250,000 300,000 Long-term debt 2,846,751 2,851,723 2,873,119 2,134,271 1,800,000 Noncurrent lease liabilities 270,853 Benefit plan liabilities 212,280 166,289 168,539 192,466 195,916 Noncurrent tax liabilities 125,515 150,960 124,330 96,871 108,808 Other noncurrent liabilities 101,206 152,420 191,257 156,831 169,139 Total other noncurrent liabilities 439,001 469,669 484,126 446,168 473,863 Total noncurrent liabilities 3,556,605 3,321,392 3,357,245 2,580,439 2,273,863 Common stock 441,369 441,369 441,369 441,369 441,369 Additional paid-in capital 1,825,569 1,812,682 1,808,391 1,790,832 1,789,870 Treasury stock at cost 2,318,921 2,354,617 2,389,877 2,426,749 2,494,901 Retained earnings (accumulated deficit) 1,413,181 1,629,257 2, 179.358 3,545,359 3,745,815 Derivative instruments, net of tax 11,041 11,411 (21,098) 17,469 15,363 Available for-sale securities (8,260) (6,547) (2.799) 3,149 Defined benefit pension, net of tax (169,857) (142,763) (143,213) (157,704) (159,858) Currency translation adjustments (702,408) (721,327) (614,676) (805,943) (704,404) Accumulated other comprehensive (869,484) (859,226) (781,786) (943,029) (848,899) income (loss) Total stockholders' equity (deficit) 491,714 669,465 1,257,455 2,407,782 2,633,254 https://www.mergentonline.com/companyfinancials.php?pagetype=asreported&compnumber=5302&period=Annuals&dataarea=BS&range=5¤c... 2/2

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

The Practice Of Modern Internal Auditing

Authors: Lawrence B Sawyer

1st Edition

B0006C58OA, 978-0894130120

More Books

Students also viewed these Accounting questions

Question

Explain how EAP works.

Answered: 1 week ago

Question

3. Identify cultural universals in nonverbal communication.

Answered: 1 week ago

Question

2. Discuss the types of messages that are communicated nonverbally.

Answered: 1 week ago