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

517110 - Wired Telecommunications Carriers
2008-09 Annual Statement Studies
National - All Regions
TOC
 | 0-500M | 500M-2MM | 2-10MM | 10-50MM | 50-100MM | 100-250MM | All
Type of Statement
Unqualified | 3 | 4 | 25 | 55 | 29 | 23 | 139
Reviewed |  | 5 | 9 | 4 |  |  | 18
Compiled | 2 | 3 | 2 | 3 | 1 |  | 11
Tax Returns | 18 | 9 | 4 |  |  |  | 31
Other | 10 | 10 | 39 | 33 | 13 | 16 | 121
 |  |  |  |  |  |  | 30 (4/1-9/30/07) 290 (10/1-3/31/08)
Number of Statements | 33 | 31 | 79 | 95 | 43 | 39 | 320
ASSETS
Cash & Equivalents | 23.4 | 14.8 | 12.0 | 15.1 | 13.1 | 11.6 | 14.5
Trade Receivables - (net) | 22.1 | 26.0 | 20.7 | 17.4 | 9.8 | 9.6 | 17.5
Inventory | 8.2 | 6.2 | 4.1 | 3.2 | 3.3 | 1.7 | 4.0
All Other Current Assets | 1.0 | 1.0 | 3.9 | 3.7 | 3.0 | 3.1 | 3.0
Total Current Assets | 54.7 | 48.0 | 40.6 | 39.3 | 29.1 | 26.0 | 39.1
Fixed Assets (net) | 27.0 | 36.6 | 39.0 | 44.4 | 50.4 | 30.7 | 39.7
Intangibles (net) | 7.9 | 8.7 | 7.6 | 5.8 | 12.8 | 35.6 | 11.3
All Other Non-Current Assets | 10.4 | 6.7 | 12.7 | 10.4 | 7.7 | 7.7 | 9.9
Total Assets | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0
LIABILITIES
Notes Payable-Short Term | 36.6 | 13.1 | 5.2 | 3.5 | 2.2 | 1.4 | 7.8
Cur. Mat.-L/T/D | 5.1 | 5.3 | 5.6 | 3.7 | 4.1 | 3.4 | 4.5
Trade Payables | 18.6 | 22.6 | 12.9 | 10.1 | 6.0 | 4.4 | 11.6
Income Taxes Payable | .0 | .7 | .3 | .4 | .4 | .3 | .3
All Other Current Liabilities | 24.4 | 16.7 | 14.2 | 11.2 | 9.0 | 7.7 | 13.1
Total Current Liabilities | 84.6 | 58.4 | 38.2 | 28.8 | 21.7 | 17.3 | 37.4
Long Term Debt | 35.3 | 25.3 | 20.4 | 20.2 | 31.0 | 32.1 | 25.2
Deferred Taxes | .0 | .1 | .8 | .9 | .7 | 1.7 | .8
All Other Non-Current Liabilities | 19.4 | 9.3 | 8.4 | 8.4 | 9.4 | 4.8 | 9.3
Net Worth | -39.4 | 6.9 | 32.2 | 41.7 | 37.2 | 44.2 | 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 | 92.5 | 93.1 | 92.2 | 92.3 | 89.2 | 90.1 | 91.7
Operating Profit | 7.5 | 6.9 | 7.8 | 7.7 | 10.8 | 9.9 | 8.3
All Other Expenses (net) | 1.2 | 1.4 | 3.2 | .9 | 2.3 | 4.8 | 2.2
Profit Before Taxes | 6.2 | 5.6 | 4.5 | 6.8 | 8.5 | 5.1 | 6.1
RATIOS
Current - upper | 2.3 | 1.3 | 2.0 | 2.6 | 2.3 | 1.8 | 2.1
Current - median | 1.0 | 1.0 | 1.1 | 1.4 | 1.5 | 1.4 | 1.2
Current - lower | .3 | .5 | .7 | .9 | .9 | 1.1 | .8
Quick - upper | 2.0 | 1.2 | 1.6 | 2.2 | 1.7 | 1.4 | 1.6
Quick - median | .6 | .7 | .9 | 1.1 | 1.1 | 1.2 | 1.0
Quick - lower | .2 | .5 | .5 | .6 | .6 | .9 | .6
Sales / Receivables - upper | [0]  UND | [15]  23.6 | [18]  20.8 | [23]  15.7 | [21]  17.8 | [23]  16.1 | [17]  20.9
Sales / Receivables - median | [13]  28.3 | [27]  13.6 | [34]  10.7 | [36]  10.2 | [31]  11.7 | [41]  9.0 | [34]  10.9
Sales / Receivables - lower | [42]  8.8 | [48]  7.6 | [67]  5.4 | [57]  6.4 | [58]  6.3 | [65]  5.6 | [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 | 14.1 | 21.7 | 6.7 | 4.5 | 3.8 | 5.1 | 5.8
Sales / Working Capital - median | UND | -999.8 | 87.6 | 12.5 | 9.8 | 10.1 | 21.3
Sales / Working Capital - lower | -10.8 | -11.1 | -13.1 | -35.0 | -35.5 | 53.1 | -20.1
EBIT / Interest - upper | 9.7 | 20.0 | 14.5 | 10.2 | 7.6 | 8.5 | 10.0
EBIT / Interest - median | (20)  1.6 | (27)  6.8 | (70)  3.0 | (81)  3.4 | (37)  3.6 | (31)  2.2 | (266)  3.2
EBIT / Interest - lower | .4 | .6 | .5 | 1.4 | 2.1 | .2 | 1.0
Net Profit + DDA / Curr Mat LTD - upper |  |  | 3.0 | 15.1 | 9.8 |  | 10.8
Net Profit + DDA / Curr Mat LTD - median |  |  | (18)  1.5 | (56)  4.1 | (24)  3.6 |  | (111)  3.2
Net Profit + DDA / Curr Mat LTD - lower |  |  | .4 | 2.6 | 2.3 |  | 1.8
Fixed / Worth - upper | .2 | .6 | .5 | .6 | .9 | 1.2 | .6
Fixed / Worth - median | 7.8 | 1.9 | 1.4 | 1.2 | 1.7 | 4.4 | 1.6
Fixed / Worth - lower | -.2 | -.9 | 7.6 | 3.1 | 10.3 | -.6 | -6.9
Debt / Worth - upper | .8 | 1.3 | .7 | .6 | .8 | 1.3 | .8
Debt / Worth - median | UND | -22.9 | 2.2 | 1.7 | 1.6 | 5.9 | 2.4
Debt / Worth - lower | -1.7 | -3.2 | 17.2 | 5.4 | 11.8 | -3.9 | -13.9
% Profit before Taxes / Tangible Net Worth - upper | 176.0 | 70.7 | 77.8 | 35.4 | 19.1 | 81.0 | 55.2
% Profit before Taxes / Tangible Net Worth - median | (17)  77.1 | (15)  35.7 | (61)  21.2 | (84)  12.7 | (33)  12.5 | (23)  16.3 | (233)  14.7
% Profit before Taxes / Tangible Net Worth - lower | 6.0 | 8.1 | 3.4 | 2.8 | 6.3 | 3.0 | 4.1
% Profit before Taxes / Total Assets - upper | 59.2 | 44.7 | 15.1 | 10.5 | 10.1 | 8.3 | 13.9
% Profit before Taxes / Total Assets - median | 10.8 | 20.4 | 5.8 | 4.9 | 4.7 | 2.9 | 5.2
% Profit before Taxes / Total Assets - lower | -2.1 | -1.3 | -1.8 | .9 | 3.0 | -1.3 | -.2
Sales / Net Fixed Assets - upper | 110.8 | 53.3 | 17.3 | 10.6 | 5.3 | 12.6 | 17.6
Sales / Net Fixed Assets - median | 29.9 | 14.1 | 5.1 | 1.4 | 1.1 | 1.9 | 3.6
Sales / Net Fixed Assets - lower | 9.3 | 2.4 | 1.1 | .7 | .5 | .9 | .8
Sales / Total Assets - upper | 8.1 | 5.3 | 2.5 | 2.4 | 1.0 | .8 | 2.8
Sales / Total Assets - median | 3.6 | 3.2 | 1.5 | .7 | .5 | .5 | 1.1
Sales / Total Assets - lower | 2.1 | 1.0 | .6 | .4 | .4 | .4 | .5
% Depr, Depl, Amort / Sales - upper | .3 | 1.2 | 2.1 | 2.3 | 6.8 | 3.4 | 2.3
% Depr, Depl, Amort / Sales - median | (19)  2.4 | (24)  3.9 | (62)  8.2 | (91)  14.8 | (36)  16.7 | (18)  5.7 | (250)  9.8
% Depr, Depl, Amort / Sales - lower | 9.2 | 13.5 | 18.7 | 20.9 | 25.2 | 15.4 | 19.4
% Officers', Directors', Owners' Comp / Sales - upper | 4.6 | 3.7 | 2.0 |  |  |  | 3.0
% Officers', Directors', Owners' Comp / Sales - median | (10)  8.2 | (13)  6.4 | (13)  4.5 |  |  |  | (43)  5.6
% Officers', Directors', Owners' Comp / Sales - lower | 11.2 | 12.8 | 7.2 |  |  |  | 10.5
Net Sales ($) | 34424M | 157123M | 858199M | 3442165M | 2721474M | 4343154M | 11556539M
Total Assets ($) | 6680M | 36603M | 446535M | 2270633M | 3055700M | 6706854M | 12523005M