2020 2019 Year Ended December 31, 2018 (In thousands, except per share data) 2017 2016 Consolidated Statements of Operations Data: Net sales 515,872 $ 598,649 $ 567,810 $ 613,111 $ 706,603 Cost of sales 366,107 439,304 412,094 457,430 483,582 Gross profit 149,765 159,345 155,716 155,681 223,021 Selling, general and administrative expenses 134,860 161,210 185,142 205,223 205,915 Goodwill and other intangibles impairment 9,379 13,536 Restructuring charge 1,631 341 1,114 1,080 Pandemic related charges 366 Acquisition related and other 6,204 1,633 Income (loss) from operations 12,908 (17,789) (32,173) (64,158) 17,106 Income from joint ventures 2 227 105 Other income (expense), net 301 (1,158) 152 342 305 Loss on extinguishment of debt (13,205) (453) (611) Change in fair value of preferred stock derivative liability (2,815) (353) Change in fair value of convertible senior notes (2,265) (5,112) 2,948 (308) Write-off of investment in DreamPlay, LLC (7,000) Interest income 22 85 68 37 1118885 Interest expense (21,562) (15,935) (10,243) (9,829) (12,975) Income (loss) before provision for income taxes Provision for income taxes (13,409) (53,467) (39,474) (81,422) 5,376 735 1,912 2,951 1,606 4,127 Net income (loss) (14,144) (55,379) (42,425) (83,028) 1,249 Net income (loss) attributable to non-controlling interests Net income (loss) attributable to JAKKS Pacific, Inc. S 130 169 (57) 57 6 (14,274) $ (55,548) $ (42,368) $ (83,085) $ 1,243 Net income (loss) attributable to common stockholders $ (15,531) $ (56,031) $ (42,368) $ (83,085) $ 1,243 Basic earnings (loss) per share $ (4.27) $ (21.57) $ (18.34) $ (38.93) $ 0.75 Diluted earnings (loss) per share $ (4.27) $ (21.57) $ (18.34) $ (38.93) $ 0.75 Dividends declared per common share $ 28 2020 2019 2018 2017 Industry revenue growth rate -6.7% 1.7% -4.4% -3.8% Industry average Operating Prof Margin -2.4% -4.1% -6.9% -2.0% INSTRUCTIONS: A. Create an EXCEL spreadsheet** for this analysis. Design it simply - include only the data you need for the analysis requested. Create calculated fields to show the following: Calculate the percentage change in revenue (net sales) for each year (2017 through 2020). Calculate operating profit margin for each year (2016 through 2020)