Updates Available Do you want to restart to install t updates now or try tonight? General Delete Format Cell Insert $- % Conditional Format Formatting as Table Styles Center Clear As Reported Annual Balance Sheet Report Date Common Stock Year end December 31 2017 2018 2018 2017 USD USD Currency Not Qualified Audit Status Not Available Consolidated Yes Yes Thousands Scale Thousands Cash & cash equlvalents Accounts receivable, gross Less: allowance for doubtful accounts 312483 13.13% 7.80% 557403 674746 629370 15.89% 15.71% - 19700 609670 0.49% 15.22% 22200 0.52% Accounts receivable, net 15.37% 652546 Inventories 1158548 24.02% 1019496 28.92% Prepaid expenses & other current assets Deferred income taxes 364183 256978 8.58% 6.41% Total current assets 2593628 2337679 61.10% 58.35% Leasehold & tenant improvements Furniture, fixtures & displays 446330 431761 10.51% 10.78% 218930 204926 5.16% 5.12% Buildings 48230 47625 1.14% 1.19% Software 286014 232660 6.74% 5.81% Office equipment Accumulated depreciation Property & equipment, net Soodwill ntangible assets, net Deferred income taxes Other long term assets otal assets 121202 98802 2.86% 2.47% 655595 526984 15.44% 13.15% 826868 885774 19.48% 22.11% 546494 555674 12.87% 13.87% 41793 46995 0.98% 1.17% 112420 82801 2.65% 2.07% 123819 97444 2.92% 2.43% 4245022 4006367 100% 100% evolving credit facility, current ccounts payable ccrued expenses ustomer refund liability urrent maturities of long term debt cher current liabilities tal current liabilities ng term debt, net of current maturities volving credit facility, long term her long term liabilities cal liabilities 125000 3.12% 560884 561108 13.21% 14.01% 340415 296841 8.02% 7.41% 301421 7.10% 25000 27000 0.59% 0.67% 88257 50426 2.08% 1.26% 1315977 1060375 31.00% 26.47% 703834 765046 16.58% 19.10% 208340 162304 4.91% 4.05% 2228151 1987725 52.49% 49.61% 59 Q Search Sheet 2 Public Company Summary 2 Updates Available Do you want to restart to install these updates now or try tonight? General Wrap Text Sort & Filter Delete Format Conditional Format Formatting as Table Styles Cell Insert Clear Merge & Center 58.35% 61.10% 1048576Rx 6C 2593628 2337679 10.78% 5.12% 431761 10.51% 446330 Leasehold & tenant improvements 218930 48230 204926 5.16% Furniture, fatures & displays Buildings Software Ofice equipment Accumulated depreciation Property & equipment, net Goodwill Intangible assets, net Defered income taxes Other long term assets Total assets 1.14% 1.19% 47625 6.74% 5.81% 232660 286014 2.47% 98802 286% 121202 13.15% 22.11% 526984 15.44% 655595 19.48% 12.87% 826868 885774 13.87% 555674 546494 1.17% 46995 0.98% 41793 2.07% 112420 82801 2.65% 2.92% 2.43% 123819 97444 100% 100% 4245022 4006367 Revolving credit facility, current Accounts payable Accrued expenses Customer refund liability Current maturities of long term debt Other current labilities 125000 3.12% 14.01% 13.21% 560884 561108 340415 296841 8.02% 7.41% 301421 7.10% 0.67% 25000 27000 0.59% 88257 S0426 1.26% 2.08% 26.47% Total current liabilities 31.00% 1315977 1060375 Long term debt, net of current maturities Revolving credit facility, long term Other long term liabilities Total liabilities 703834 765046 16.S8% 19.10% 208340 162304 4.91% 4.05% 2228151 1987725 52.49% 49.61% Cass A common stock Class B convertible common stock Cass C common stock Additional paid-in capital Retained earnings Accumulated other comprehensive income (loss) Total stockholders' equity (deficit) Total stockholders' equity and liabilit 62 0.00% 0.00% 61 0.00% 11 0.00% 11 75 74 0.00% 0.00% 916628 872266 21.59% 21.77% 1139082 -38987 1184441 26.83% 29.56% -38211 -0.92% -0.95% 2016871 2018642 4006367 47.51% 50.39% 4245022 100.00% 100.00% Average: 35971460.74% Count: 209 Sum: 5323776189.89% Articie. d. E-mail me the name and ticker of the company you select by Saturday 1/11 2. Create a common size income statement for 2017 and 2018 for your company a. Provide a statement that analyzes your work and demonstrates your understanding of the common size techniques. Home Insert Draw Formulas View Page Layout Data Review X Cut Calibri (Body) A A- 12 Wr Copy aste Format Income Statement (in thousands) Year Ended December 31 2017 2018 Net revenues $5,193,185.00 $4,989,244.00 Cost of Goods Sold $2,852,714.00 $2,737,830.00 $2,340,471.00 $ 251,414.00 Gross profit Selling, General and Admin Expenses Restructuring and impairment charges $2,182,339.00 $2,099,522.00 $ 183,149.00 $ 124,049.00 (25,017.00) $ (33,568.00) $ (9,203.00) $ (67,788.00) $ $ (20,552.00) $ Income from Operations 2$ 27,843.00 Interest Expense, net (34,538.00) Other expense, net (3,614.00) Income before Income Taxes (10,309.00) Income tax expense (benefit) Income from equity method investment 37,951.00 934.00 Net income (loss) $ (46,302.00) $ (48,260.00) Asset Management (Turnover Ratios) 2018 2017 ventory Turnover yables Turnover = COGS/Accounts Payable =COGS/Inventory 2.80 2.36 5.09 4.88 PROFITABILITY MEASURES 2018 2017 ofit Margin= Net Income/Sales curn on Assets = Net Income/Total Assets -0.89% -0.97% -1.79% -2.06% curn on Equity = Net Income/Total Equity -2.30% -2.39% uli Updates Available Do you want to restart to install t updates now or try tonight? General Delete Format Cell Insert $- % Conditional Format Formatting as Table Styles Center Clear As Reported Annual Balance Sheet Report Date Common Stock Year end December 31 2017 2018 2018 2017 USD USD Currency Not Qualified Audit Status Not Available Consolidated Yes Yes Thousands Scale Thousands Cash & cash equlvalents Accounts receivable, gross Less: allowance for doubtful accounts 312483 13.13% 7.80% 557403 674746 629370 15.89% 15.71% - 19700 609670 0.49% 15.22% 22200 0.52% Accounts receivable, net 15.37% 652546 Inventories 1158548 24.02% 1019496 28.92% Prepaid expenses & other current assets Deferred income taxes 364183 256978 8.58% 6.41% Total current assets 2593628 2337679 61.10% 58.35% Leasehold & tenant improvements Furniture, fixtures & displays 446330 431761 10.51% 10.78% 218930 204926 5.16% 5.12% Buildings 48230 47625 1.14% 1.19% Software 286014 232660 6.74% 5.81% Office equipment Accumulated depreciation Property & equipment, net Soodwill ntangible assets, net Deferred income taxes Other long term assets otal assets 121202 98802 2.86% 2.47% 655595 526984 15.44% 13.15% 826868 885774 19.48% 22.11% 546494 555674 12.87% 13.87% 41793 46995 0.98% 1.17% 112420 82801 2.65% 2.07% 123819 97444 2.92% 2.43% 4245022 4006367 100% 100% evolving credit facility, current ccounts payable ccrued expenses ustomer refund liability urrent maturities of long term debt cher current liabilities tal current liabilities ng term debt, net of current maturities volving credit facility, long term her long term liabilities cal liabilities 125000 3.12% 560884 561108 13.21% 14.01% 340415 296841 8.02% 7.41% 301421 7.10% 25000 27000 0.59% 0.67% 88257 50426 2.08% 1.26% 1315977 1060375 31.00% 26.47% 703834 765046 16.58% 19.10% 208340 162304 4.91% 4.05% 2228151 1987725 52.49% 49.61% 59 Q Search Sheet 2 Public Company Summary 2 Updates Available Do you want to restart to install these updates now or try tonight? General Wrap Text Sort & Filter Delete Format Conditional Format Formatting as Table Styles Cell Insert Clear Merge & Center 58.35% 61.10% 1048576Rx 6C 2593628 2337679 10.78% 5.12% 431761 10.51% 446330 Leasehold & tenant improvements 218930 48230 204926 5.16% Furniture, fatures & displays Buildings Software Ofice equipment Accumulated depreciation Property & equipment, net Goodwill Intangible assets, net Defered income taxes Other long term assets Total assets 1.14% 1.19% 47625 6.74% 5.81% 232660 286014 2.47% 98802 286% 121202 13.15% 22.11% 526984 15.44% 655595 19.48% 12.87% 826868 885774 13.87% 555674 546494 1.17% 46995 0.98% 41793 2.07% 112420 82801 2.65% 2.92% 2.43% 123819 97444 100% 100% 4245022 4006367 Revolving credit facility, current Accounts payable Accrued expenses Customer refund liability Current maturities of long term debt Other current labilities 125000 3.12% 14.01% 13.21% 560884 561108 340415 296841 8.02% 7.41% 301421 7.10% 0.67% 25000 27000 0.59% 88257 S0426 1.26% 2.08% 26.47% Total current liabilities 31.00% 1315977 1060375 Long term debt, net of current maturities Revolving credit facility, long term Other long term liabilities Total liabilities 703834 765046 16.S8% 19.10% 208340 162304 4.91% 4.05% 2228151 1987725 52.49% 49.61% Cass A common stock Class B convertible common stock Cass C common stock Additional paid-in capital Retained earnings Accumulated other comprehensive income (loss) Total stockholders' equity (deficit) Total stockholders' equity and liabilit 62 0.00% 0.00% 61 0.00% 11 0.00% 11 75 74 0.00% 0.00% 916628 872266 21.59% 21.77% 1139082 -38987 1184441 26.83% 29.56% -38211 -0.92% -0.95% 2016871 2018642 4006367 47.51% 50.39% 4245022 100.00% 100.00% Average: 35971460.74% Count: 209 Sum: 5323776189.89% Articie. d. E-mail me the name and ticker of the company you select by Saturday 1/11 2. Create a common size income statement for 2017 and 2018 for your company a. Provide a statement that analyzes your work and demonstrates your understanding of the common size techniques. Home Insert Draw Formulas View Page Layout Data Review X Cut Calibri (Body) A A- 12 Wr Copy aste Format Income Statement (in thousands) Year Ended December 31 2017 2018 Net revenues $5,193,185.00 $4,989,244.00 Cost of Goods Sold $2,852,714.00 $2,737,830.00 $2,340,471.00 $ 251,414.00 Gross profit Selling, General and Admin Expenses Restructuring and impairment charges $2,182,339.00 $2,099,522.00 $ 183,149.00 $ 124,049.00 (25,017.00) $ (33,568.00) $ (9,203.00) $ (67,788.00) $ $ (20,552.00) $ Income from Operations 2$ 27,843.00 Interest Expense, net (34,538.00) Other expense, net (3,614.00) Income before Income Taxes (10,309.00) Income tax expense (benefit) Income from equity method investment 37,951.00 934.00 Net income (loss) $ (46,302.00) $ (48,260.00) Asset Management (Turnover Ratios) 2018 2017 ventory Turnover yables Turnover = COGS/Accounts Payable =COGS/Inventory 2.80 2.36 5.09 4.88 PROFITABILITY MEASURES 2018 2017 ofit Margin= Net Income/Sales curn on Assets = Net Income/Total Assets -0.89% -0.97% -1.79% -2.06% curn on Equity = Net Income/Total Equity -2.30% -2.39% uli