Ratios Tell a Story - 2017
Exhibit 1 Ratios Tell A Story-2017 Selected Financial Data for 13 Companies (Balance sheet amounts are percentage of total assets) 2 3 4 5 6 8 9 10 11 12 13 12.31.17 12.31.17 Year end 2.3.18 12.01.17 12.31.17 12.31.17 12.31.17 2.3.18 12.31.17 9.30.17 12.31.17 7.1.17 12.31.17 Assets: Cash 4.1% 15.9%% 10.5% 15 2% 1.2% 5.8% 23.6%% 19.8% 17.9%% 4.9%% 1.4% 73% 1.0% Accts. Receivable 4.4% 8.4% 3.4% 32 4%% 2.7% 1.0% 10.0%% 4.8%% 10.1% 22.6% 64 2% 5.8% 2.3% 17.6% 0.0% 2.6% 4.5% 1.0% 22 2%% 122% 1.3% 9.9% 16.9% 0.0% 0.2% 0.7% nvertory 3.9%% 25.6% 1.3% 4.5% 0.4% 3.2% 0.0%% 8.5%% 4.8% 0.9% 11.1% 24% 2.6%% Ther CA 49.9% 17 8% 5.4% 32 2%% 343% 42.7%% 45 2% 15.8% 7.4% Total Current Assets 29.9%% 56.6%% 45.8% Net PPSE 56.6%% 6.4% 66.5% 28% 80.9%% 64.2% 37 2 9.0%% 19.6%% 24.6%% 0.9%% 66.4% 78.2% Goodwill 7.9%% 40.1% 8.0% 37.5% 0.0% 0.0%% 10.2% 1.5% 9.7% 22.1% 4.3% 7.0% 0.9%% htangibles & of 5.6%% 3.6% 3 2% 5.8% 3.6% 6.8% 55.2%% 28.0%% 8.1% 18.1% 10.8% 13.6% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% Total Assets Liabilities: Accts. Pay. 15.7% 0.8% 3.3% 46.4% 2.4% 22 2% 26.4% 13.1% 3.1% 22.4%% 710%% 2.7% 2.7% ST Debt 9.6%% 0.0%% 5.0% 0.0%% 0.1% 0.7% 0.1% 1.7% 8.2% 3.0% 2.2% 0.0%% 2.7% Other 128%% 23.5% 20.9%% 14.1% 2.9% 10.9% 17.7% 12.1% 20.9% %0' 6 2.7% 5.8%% 4 8% Total Current Liabilities 38 2% 24.3%% 29.1% 60.6% 5.3%% 338%% 44.2% 26.9% 32.3% 34 3% 8.6% 10 2% LT Debt 32.3%% 12.9%% 43.8%% 19.7% 33.0%% 29.0% 18.8%% 25.9%% 22.1% 43.1% 10.7% 87 4% 30.6%% Other 10.9% 4.6% 19.4% 7.0% 20.5% 7.1% 15.9% 11.5% 19.6% 8.6% 0.0% 13.7% 27.1% 81.4% 41.8%% 92.4% 87 4% 58.8% 70.0% 78.9% 64.3%% 74.1 86.1% 86.6% 109.7% 67.9% Total Liabilities -0.1% 0.0%% 0.0% 2.2% 0.0% 0.0% 0.0% 0.0% 02% 0.5%% 0.0%% 0.0%% Equity:Noncontrolling Int. Net Con. Cap -25.8%% -6.9% 11.1% -10.6%% 3.1% 15.1% 14.9%% 9.6%% 14.3% 32 7%% 6.7% -146 2%% 10.8% Ret, Inc. + OCI 44.5%% 65.1% -3.5%% 21.0%% 38.0%% 14.9%% 8.2% 26.2% 11.5% 46.1% 8.7% 136.5%% 21 2%% Total Equity 18.6%% 58 2% 7.6% 12.6% 41.2% 30.0% 21.1% 35.7%% 25.9% 13.9%% 13.4% -9.7%% 32.1% Total Liab. & Equity 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0%% 100.0% 100.0% 100.0% ROS 16% 232% 1.5% 7.1% 48.0% .1% .7% 21.1% -0.9% 2.1% 18.3% 22.8% 12.7% 3.12 0.05 0.68 D.25 Asset Turnover 3.30 0.50 0.82 0.61 0.32 1.84 1.35 0.61 0.51 ROA 5.1% 1 1.7% 3.7% 4.4% 15.3% 7.5% 2.3% 12.9%% -0.5%% 6 4%% 1.0%% 15.4% 32% 7.46 -10.34 3. 12 Financial Leverage 5.39 1.72 13.09 7.91 243 3.33 4.74 2.80 3.86 7.20 20.0%% 48.9% 34.5% 37.2%% 25.1% 10.9% 36.1% -1.7% 46.4% 7 5% -158.9%% 9.9% ROE 27.6%% Current ratio 0.78 2.05 0.61 0.93 1.01 0.95 1.04 1.28 1.32 1.32 NA 1.84 0.72 Receivables collection 5 61 15 193 31 2 27 28 73 26 4270 32 3:3 14.6 NA NA N/A NA 5.9 70 29.1 1.4 15.0 N'A 176 3.1 Inventory Turnover Gross margin 22.0%% 91.9% NA NA NA 28 8%% 5.6% 38.5% 73.5% 19.1% N'A 18 2% 76.9% 23 2% 0.0% 10.3%% 47.3%% 12.9%% 45.6% 0.0% 26.4%% -1 074.5% 61 2% 53,1%% 59.5% 52.7% Dividend payout Revenue grown 6.3% 24.7% 5.0%% 0.9%% 10.4% 3.3% 30.8%% 6.3%% 7 8%% 9.9% 5.4% -7.3 -0.3%% NA N'A 0.39%% R & D ratio NIA 16.76%% N'A NA N'A NA 12.72%% 5.05% 23.09%% NIA OFFO (millions) 3.413 1,470 4,744 2,024 3472 6.923 18.434 63.508 5.616 2,176 4,635 5,551 3,367 Data source: Created by author using company 10 Ks filed with the SEC
