Read Mattel Incorporated in 2019: Hard Times in the Toy Industry (Case 7 in Textbook) Complete the

Fantastic news! We've Found the answer you've been seeking!

Question:

Read “Mattel Incorporated in 2019: Hard Times in the Toy Industry” (Case 7 in Textbook) Complete the Mattel Incorporated Spreadsheet with your calculations of the indicated (green boxes) financial ratios. Calculate your financial ratios for the spreadsheet from the PDF files of the company’s Income Statements and Balance Sheets for 2015-2019 attached to this unit on Blackboard (Mergent Online Financial Statements). NOTE: Use the “Commonly Used Financial Ratios” PDF file formulas for the financial ratio calculations. TIP: Use n=4 in your CAGR calculation. NOTE: Use the Net Income (Loss) per share – diluted as the answer for the EPS (diluted) line on your spreadsheet. NOTE: Total Debt (Liabilities) can be calculated two ways: (1) Total Current Liabilities line PLUS Total Noncurrent Liabilities line. OR (2) Total Assets line MINUS Total Stockholder’s Equity line.

MATTEL INCORPORATED Financial Analysis Fiscal 2015-2019 Numbers in Thousands, except where indicated 2015 2016 2017 2018 2019

2015 2016 2017 2018 2019 BALANCE SHEET Current Assets Inventories (Net) Current Liabilities $3,196,863 $587,521 $1,645,572 Cu

USD USD EMATTEL Mattel Inc (NMS: MAT) Powered by Clearbit Exchange rate used is that of the Year End reported date As Reporte

2,170 1,340 1,885 2,455 1.946 68,837 91.930 113,315 91,070 89,825 76,527 97,205 112,047 90,484 90,366 Current income tax prov Exchange rate used is that of the Year End reported date As Reported Annual Balance Sheet Report Date Currency Audit Status Y

- 1,377 3,179 (530,993) (1,053,836) 316,645 366,237 346,127 345,012 343,564 341,480 339.172 346,127 345,012 343,564 344,233 3 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,