Spreadsheet: 54885d1254933118-select-from-list-and-it-pulls-data-from-corresponding-sheet-listandworksheet
Sheet: Wired Sales

517110 - Wired Telecommunications Carriers
2008-09 Annual Statement Studies
National - All Regions
TOC
 | 0-1MM | 1-3MM | 3-5MM | 5-10MM | 10-25MM | 25MM and Over | All
Type of Statement
Unqualified | 7 | 10 | 7 | 21 | 36 | 58 | 139
Reviewed |  | 1 | 4 | 4 | 4 | 5 | 18
Compiled | 1 | 3 | 3 | 1 | 1 | 2 | 11
Tax Returns | 10 | 9 | 4 | 4 | 3 | 1 | 31
Other | 11 | 10 | 5 | 22 | 21 | 52 | 121
 |  |  |  |  |  |  | 30 (4/1-9/30/07) 290 (10/1-3/31/08)
Number of Statements | 29 | 33 | 23 | 52 | 65 | 118 | 320
ASSETS
Cash & Equivalents | 16.0 | 18.3 | 10.1 | 12.4 | 14.2 | 15.0 | 14.5
Trade Receivables - (net) | 17.8 | 16.0 | 15.2 | 16.5 | 15.7 | 19.9 | 17.5
Inventory | 5.7 | 7.7 | 3.6 | 3.4 | 2.6 | 3.8 | 4.0
All Other Current Assets | 2.7 | .5 | 5.2 | 2.3 | 2.7 | 4.0 | 3.0
Total Current Assets | 42.1 | 42.4 | 34.0 | 34.6 | 35.0 | 42.6 | 39.1
Fixed Assets (net) | 33.3 | 42.1 | 51.7 | 46.1 | 45.1 | 32.4 | 39.7
Intangibles (net) | 16.8 | 2.3 | 7.3 | 5.2 | 7.9 | 17.8 | 11.3
All Other Non-Current Assets | 7.8 | 13.1 | 6.9 | 14.0 | 12.0 | 7.2 | 9.9
Total Assets | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0
LIABILITIES
Notes Payable-Short Term | 12.1 | 34.3 | 3.4 | 6.4 | 2.7 | 3.7 | 7.8
Cur. Mat.-L/T/D | 2.3 | 5.1 | 8.5 | 4.7 | 4.2 | 4.1 | 4.5
Trade Payables | 9.1 | 15.7 | 10.4 | 9.9 | 13.1 | 11.3 | 11.6
Income Taxes Payable | .0 | .8 | .3 | .2 | .3 | .4 | .3
All Other Current Liabilities | 11.4 | 21.2 | 8.0 | 8.6 | 12.7 | 14.4 | 13.1
Total Current Liabilities | 35.0 | 77.1 | 30.7 | 29.9 | 33.0 | 33.9 | 37.4
Long Term Debt | 35.9 | 28.9 | 19.6 | 25.4 | 24.0 | 23.2 | 25.2
Deferred Taxes | .0 | .0 | 2.0 | .9 | .7 | .9 | .8
All Other Non-Current Liabilities | 11.2 | 18.7 | 9.1 | 9.8 | 7.2 | 7.2 | 9.3
Net Worth | 17.9 | -24.7 | 38.6 | 34.0 | 35.1 | 34.8 | 27.3
Total Liabilities & Net Worth | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0
INCOME DATA
Net Sales | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0
Gross Profit | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0
Operating Expenses | 94.1 | 89.4 | 96.1 | 92.0 | 90.7 | 91.3 | 91.7
Operating Profit | 5.9 | 10.6 | 3.9 | 8.0 | 9.3 | 8.7 | 8.3
All Other Expenses (net) | 3.5 | 2.0 | 3.2 | 1.0 | 2.3 | 2.3 | 2.2
Profit Before Taxes | 2.4 | 8.5 | .7 | 7.0 | 7.0 | 6.4 | 6.1
RATIOS
Current - upper | 2.3 | 2.7 | 2.9 | 2.3 | 2.0 | 1.9 | 2.1
Current - median | 1.2 | .7 | 1.2 | 1.3 | 1.1 | 1.3 | 1.2
Current - lower | .6 | .4 | .5 | .8 | .7 | .9 | .8
Quick - upper | 1.8 | 1.8 | 2.3 | 1.9 | 1.6 | 1.6 | 1.6
Quick - median | 1.1 | .6 | 1.0 | 1.0 | .9 | 1.1 | 1.0
Quick - lower | .3 | .3 | .4 | .6 | .5 | .7 | .6
Sales / Receivables - upper | [0]  UND | [13]  27.1 | [9]  38.9 | [24]  15.5 | [18]  20.2 | [20]  17.8 | [17]  20.9
Sales / Receivables - median | [29]  12.4 | [23]  15.7 | [29]  12.8 | [37]  9.9 | [29]  12.7 | [38]  9.6 | [34]  10.9
Sales / Receivables - lower | [80]  4.6 | [40]  9.1 | [76]  4.8 | [55]  6.6 | [54]  6.8 | [62]  5.9 | [57]  6.4
Cost of Sales / Inventory - upper
Cost of Sales / Inventory - median
Cost of Sales / Inventory - lower
Cost of Sales / Payables - upper
Cost of Sales / Payables - median
Cost of Sales / Payables - lower
Sales / Working Capital - upper | 6.1 | 8.8 | 5.0 | 4.0 | 5.2 | 6.6 | 5.8
Sales / Working Capital - median | 20.8 | -60.1 | 30.0 | 16.6 | 45.5 | 15.6 | 21.3
Sales / Working Capital - lower | -10.8 | -11.4 | -8.9 | -27.7 | -16.0 | -47.3 | -20.1
EBIT / Interest - upper | 5.5 | 11.4 | 15.4 | 19.5 | 15.1 | 8.6 | 10.0
EBIT / Interest - median | (19)  .8 | (26)  2.8 | (22)  1.4 | (46)  3.7 | (60)  2.9 | (93)  3.9 | (266)  3.2
EBIT / Interest - lower | .0 | .7 | -.2 | 1.6 | 1.4 | 1.6 | 1.0
Net Profit + DDA / Curr Mat LTD - upper |  |  |  | 13.4 | 14.7 | 10.5 | 10.8
Net Profit + DDA / Curr Mat LTD - median |  |  |  | (21)  3.1 | (21)  3.2 | (53)  3.5 | (111)  3.2
Net Profit + DDA / Curr Mat LTD - lower |  |  |  | 1.8 | 2.2 | 2.1 | 1.8
Fixed / Worth - upper | .5 | .5 | .8 | .6 | .6 | .6 | .6
Fixed / Worth - median | 4.8 | 1.4 | 1.6 | 1.5 | 1.3 | 1.8 | 1.6
Fixed / Worth - lower | -1.3 | -.7 | 4.9 | 4.9 | 45.0 | -2.9 | -6.9
Debt / Worth - upper | .5 | .8 | .5 | .6 | .7 | 1.2 | .8
Debt / Worth - median | 8.8 | 2.0 | 1.3 | 1.7 | 1.7 | 3.3 | 2.4
Debt / Worth - lower | -3.6 | -2.2 | 14.1 | 6.8 | 66.2 | -12.4 | -13.9
% Profit before Taxes / Tangible Net Worth - upper | 118.6 | 71.4 | 19.6 | 51.2 | 40.8 | 59.4 | 55.2
% Profit before Taxes / Tangible Net Worth - median | (17)  28.5 | (19)  12.7 | (18)  6.1 | (44)  13.0 | (50)  13.1 | (85)  22.7 | (233)  14.7
% Profit before Taxes / Tangible Net Worth - lower | -10.9 | 5.5 | -4.3 | 4.7 | 5.1 | 5.6 | 4.1
% Profit before Taxes / Total Assets - upper | 12.3 | 51.2 | 7.1 | 11.7 | 12.9 | 14.0 | 13.9
% Profit before Taxes / Total Assets - median | -1.0 | 12.6 | 2.0 | 6.1 | 4.6 | 6.2 | 5.2
% Profit before Taxes / Total Assets - lower | -3.3 | 1.2 | -2.5 | -1.7 | .7 | 1.6 | -.2
Sales / Net Fixed Assets - upper | 26.4 | 50.8 | 12.6 | 11.4 | 15.1 | 19.9 | 17.6
Sales / Net Fixed Assets - median | 5.1 | 4.6 | 1.1 | 1.4 | 1.8 | 7.3 | 3.6
Sales / Net Fixed Assets - lower | 1.1 | 1.0 | .6 | .7 | .7 | 1.2 | .8
Sales / Total Assets - upper | 2.9 | 5.5 | 2.6 | 2.3 | 2.2 | 2.9 | 2.8
Sales / Total Assets - median | 1.5 | 2.1 | .7 | .9 | .7 | 1.1 | 1.1
Sales / Total Assets - lower | .5 | .5 | .5 | .4 | .4 | .5 | .5
% Depr, Depl, Amort / Sales - upper | 3.0 | 1.8 | 4.9 | 5.8 | 3.9 | 1.0 | 2.3
% Depr, Depl, Amort / Sales - median | (21)  8.7 | (22)  18.8 | (19)  17.1 | (44)  14.8 | (57)  17.1 | (87)  3.8 | (250)  9.8
% Depr, Depl, Amort / Sales - lower | 14.7 | 23.3 | 24.3 | 19.4 | 25.1 | 10.8 | 19.4
% Officers', Directors', Owners' Comp / Sales - upper |  |  |  |  |  |  | 3.0
% Officers', Directors', Owners' Comp / Sales - median |  |  |  |  |  |  | (43)  5.6
% Officers', Directors', Owners' Comp / Sales - lower |  |  |  |  |  |  | 10.5
Net Sales ($) | 13949M | 64621M | 87031M | 387006M | 1031863M | 9972069M | 11556539M
Total Assets ($) | 17812M | 77954M | 236714M | 585060M | 1582647M | 10022818M | 12523005M