calculate the financial ratios for the company after analyzing the financial highlights. Income Data (5000 except per

 calculate the financial ratios for the company after analyzing the financial highlights.

Transcribed Image Text:

Income Data (5000 except per share data) 2018 2017 2016 2015 2014 Net Sales 433,947 405,232 383,977 358,632 356,322 Gross Profit 103,533 123,397 118,080 108,681 108,263 Operating Income 55,790 74,103 79,594 71,302 68,006 Interest Income (Expense), Net 196 298 292 161 276 Depreciation and Amortization 17,655 15,007 13,035 11,741 11,553 Pre-Tax Income 55,939 74,492 79,991 71,339 68,246 Net Income 42,572 54,498 53,376 45,728 44,158 Earnings per Share Basic 0.81 1.04 1.01 0.85 0.81 Diluted 0.81 1.03 1.00 0.84 0.80 Balance Sheet (5000 except per share data) Working Capital' 92,790 103,662 101,939 80,800 82,227 Current Assets 140,861 153,727 140,981 124,213 124,940 Net Fixed Assets 163,003 142,375 114,892 101,061 91,922 Accumulated Depreciation 166,880 149,963 137,146 124,348 113,605 Cash and Cash Equivalents 1,994 21,457 24,153 7,908 21,952 Total Assets 308,197 296,780 256,530 232,854 226,974 Current Liabilities 48,071 50,065 39,042 43,413 42,713 Long-Term Debt Stockholders' Equity 247,499 237,226 205,898 178,918 174,059 Stockholders' Equity per Diluted Share 4.70 4.47 3.85 3.28 3.14 Funds Flow Data (5000) Operations 54,856 57,994 63,923 55,355 53,518 Investments (34,635) (31,052) (16,925) (23,194) (6,029) Financing (39,684) (29,638) (30,753) (46,205) (37,622) Net Increase (Decrease) in Cash (19,463) (2,696) 16,245 (14,044) 9,867 Ratio Analysis Gross Profit 23.9% 30.5% 30.8% 30.3% 30.4% Return on Average Equity 17.6% 24.6% 27.7% 25.9% 26.1% Return on Average Assets 14.1% 19.7% 21.8% 19.9% 20.2% Pre-Tax Income on Sales 12.9 % 18.4% 20.8% 19.9% 19.2% Net Income of Sales 9.8% 13.4% 13.9% 12.8% 12.4% Total Liabilities to Equity 0.2 0.3 0.2 0.3 0.3 Quick Ratio 1.3 1.6 2.4 2.1 2.2 Current Ratio 2.9 3.1 3.6 2.9 2.9 Year-End Price Earnings Ratio" 43 35 33 28 28 1=Reflects 3-for-2 stock split in July 2014 2=(Cash & cash equivalents + investments + receivables)/current liabilities 3=Reflects retrospective adoption of ASU 2015-17 7 Income Data (5000 except per share data) 2018 2017 2016 2015 2014 Net Sales 433,947 405,232 383,977 358,632 356,322 Gross Profit 103,533 123,397 118,080 108,681 108,263 Operating Income 55,790 74,103 79,594 71,302 68,006 Interest Income (Expense), Net 196 298 292 161 276 Depreciation and Amortization 17,655 15,007 13,035 11,741 11,553 Pre-Tax Income 55,939 74,492 79,991 71,339 68,246 Net Income 42,572 54,498 53,376 45,728 44,158 Earnings per Share Basic 0.81 1.04 1.01 0.85 0.81 Diluted 0.81 1.03 1.00 0.84 0.80 Balance Sheet (5000 except per share data) Working Capital' 92,790 103,662 101,939 80,800 82,227 Current Assets 140,861 153,727 140,981 124,213 124,940 Net Fixed Assets 163,003 142,375 114,892 101,061 91,922 Accumulated Depreciation 166,880 149,963 137,146 124,348 113,605 Cash and Cash Equivalents 1,994 21,457 24,153 7,908 21,952 Total Assets 308,197 296,780 256,530 232,854 226,974 Current Liabilities 48,071 50,065 39,042 43,413 42,713 Long-Term Debt Stockholders' Equity 247,499 237,226 205,898 178,918 174,059 Stockholders' Equity per Diluted Share 4.70 4.47 3.85 3.28 3.14 Funds Flow Data (5000) Operations 54,856 57,994 63,923 55,355 53,518 Investments (34,635) (31,052) (16,925) (23,194) (6,029) Financing (39,684) (29,638) (30,753) (46,205) (37,622) Net Increase (Decrease) in Cash (19,463) (2,696) 16,245 (14,044) 9,867 Ratio Analysis Gross Profit 23.9% 30.5% 30.8% 30.3% 30.4% Return on Average Equity 17.6% 24.6% 27.7% 25.9% 26.1% Return on Average Assets 14.1% 19.7% 21.8% 19.9% 20.2% Pre-Tax Income on Sales 12.9 % 18.4% 20.8% 19.9% 19.2% Net Income of Sales 9.8% 13.4% 13.9% 12.8% 12.4% Total Liabilities to Equity 0.2 0.3 0.2 0.3 0.3 Quick Ratio 1.3 1.6 2.4 2.1 2.2 Current Ratio 2.9 3.1 3.6 2.9 2.9 Year-End Price Earnings Ratio" 43 35 33 28 28 1=Reflects 3-for-2 stock split in July 2014 2=(Cash & cash equivalents + investments + receivables)/current liabilities 3=Reflects retrospective adoption of ASU 2015-17 7

Answer rating: 100% (QA)

Certainly The provided data consists of financial information over a span of several years including ... View the full answer