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

517210 - Wireless Telecommunications Carriers (except Satellite)
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 | 1 |  |  | 5 | 5 | 15 | 26
Reviewed |  | 1 | 2 | 6 | 4 | 2 | 15
Compiled |  | 4 | 2 | 3 | 1 |  | 10
Tax Returns | 5 | 7 | 2 | 1 |  |  | 15
Other | 4 | 5 | 1 | 5 | 8 | 8 | 31
 |  |  |  |  |  |  | 14 (4/1-9/30/07) 83 (10/1-3/31/08)
Number of Statements | 10 | 17 | 7 | 20 | 18 | 25 | 97
ASSETS
Cash & Equivalents | 13.1 | 13.7 |  | 7.8 | 13.8 | 13.4 | 11.7
Trade Receivables - (net) | 11.0 | 24.1 |  | 21.1 | 21.6 | 22.4 | 21.3
Inventory | 6.3 | 15.7 |  | 9.5 | 9.1 | 6.7 | 10.6
All Other Current Assets | 1.5 | 4.5 |  | 7.8 | 6.0 | 3.9 | 5.0
Total Current Assets | 31.9 | 58.0 |  | 46.2 | 50.5 | 46.5 | 48.5
Fixed Assets (net) | 55.3 | 32.6 |  | 39.5 | 36.8 | 39.6 | 38.6
Intangibles (net) | 10.6 | 3.8 |  | 7.6 | 6.4 | 8.5 | 7.3
All Other Non-Current Assets | 2.3 | 5.5 |  | 6.7 | 6.3 | 5.4 | 5.6
Total Assets | 100.0 | 100.0 |  | 100.0 | 100.0 | 100.0 | 100.0
LIABILITIES
Notes Payable-Short Term | 10.1 | 4.9 |  | 8.9 | 5.5 | .4 | 6.0
Cur. Mat.-L/T/D | 1.1 | 6.0 |  | 7.2 | 3.4 | 1.8 | 4.1
Trade Payables | 1.4 | 20.6 |  | 15.0 | 11.4 | 16.1 | 15.1
Income Taxes Payable | .0 | .5 |  | .5 | .3 | .3 | .3
All Other Current Liabilities | 5.3 | 7.7 |  | 9.5 | 14.2 | 15.4 | 11.3
Total Current Liabilities | 17.9 | 39.8 |  | 41.2 | 34.7 | 34.0 | 36.8
Long Term Debt | 32.8 | 27.6 |  | 36.9 | 11.1 | 22.4 | 24.7
Deferred Taxes | .0 | .0 |  | .0 | .7 | .6 | .3
All Other Non-Current Liabilities | 8.8 | 3.3 |  | 6.1 | 3.0 | 9.8 | 5.9
Net Worth | 40.6 | 29.4 |  | 15.8 | 50.5 | 33.3 | 32.2
Total Liabilities & Net Worth | 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
Gross Profit | 100.0 | 100.0 |  | 100.0 | 100.0 | 100.0 | 100.0
Operating Expenses | 85.6 | 98.6 |  | 93.6 | 93.9 | 91.5 | 93.1
Operating Profit | 14.4 | 1.4 |  | 6.4 | 6.1 | 8.5 | 6.9
All Other Expenses (net) | 8.0 | .5 |  | 1.1 | -.1 | 2.2 | 1.7
Profit Before Taxes | 6.4 | 1.0 |  | 5.4 | 6.1 | 6.3 | 5.2
RATIOS
Current - upper | 4.7 | 4.1 |  | 2.2 | 2.1 | 1.7 | 2.3
Current - median | 2.5 | 1.4 |  | 1.6 | 1.6 | 1.4 | 1.5
Current - lower | .5 | .7 |  | .9 | 1.0 | 1.0 | 1.0
Quick - upper | 3.9 | 2.4 |  | 1.5 | 1.6 | 1.4 | 1.6
Quick - median | 1.6 | .8 |  | 1.0 | 1.1 | .9 | 1.0
Quick - lower | .4 | .5 |  | .4 | .6 | .7 | .6
Sales / Receivables - upper | [0]  UND | [13]  27.1 |  | [15]  24.4 | [26]  14.2 | [26]  14.1 | [22]  16.7
Sales / Receivables - median | [38]  9.7 | [26]  13.9 |  | [34]  10.9 | [41]  8.8 | [42]  8.6 | [35]  10.5
Sales / Receivables - lower | [119]  3.1 | [63]  5.8 |  | [52]  7.1 | [57]  6.4 | [54]  6.8 | [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 | 2.7 | 6.4 |  | 7.0 | 4.0 | 8.2 | 6.7
Sales / Working Capital - median | 14.5 | 19.0 |  | 13.7 | 11.8 | 16.2 | 15.0
Sales / Working Capital - lower | -6.3 | -30.6 |  | NM | NM | 257.7 | -131.4
EBIT / Interest - upper |  | 5.5 |  | 15.5 | 17.5 | 16.7 | 13.1
EBIT / Interest - median |  | (14)  1.7 |  | (19)  4.0 | (15)  8.3 | (22)  5.6 | (83)  3.9
EBIT / Interest - lower |  | -.3 |  | .7 | 3.7 | 3.0 | 1.5
Net Profit + DDA / Curr Mat LTD - upper |  |  |  |  |  |  | 9.8
Net Profit + DDA / Curr Mat LTD - median |  |  |  |  |  |  | (12)  3.1
Net Profit + DDA / Curr Mat LTD - lower |  |  |  |  |  |  | 1.8
Fixed / Worth - upper | .7 | .1 |  | .6 | .4 | .7 | .5
Fixed / Worth - median | 1.8 | .6 |  | 1.4 | 1.0 | 1.4 | 1.4
Fixed / Worth - lower | NM | -7.4 |  | 2.5 | 2.6 | 3.9 | 2.8
Debt / Worth - upper | .6 | .5 |  | .8 | .4 | 1.8 | .8
Debt / Worth - median | 1.3 | 2.5 |  | 1.8 | 1.1 | 3.0 | 2.0
Debt / Worth - lower | NM | -10.7 |  | 7.7 | 3.2 | 11.4 | 8.6
% Profit before Taxes / Tangible Net Worth - upper |  | 33.7 |  | 72.9 | 82.0 | 102.3 | 60.8
% Profit before Taxes / Tangible Net Worth - median |  | (12)  20.3 |  | (16)  24.3 | 23.7 | (22)  43.2 | (80)  24.6
% Profit before Taxes / Tangible Net Worth - lower |  | 1.4 |  | 2.2 | 6.3 | 17.8 | 6.8
% Profit before Taxes / Total Assets - upper | 9.9 | 18.6 |  | 33.3 | 18.5 | 15.1 | 17.1
% Profit before Taxes / Total Assets - median | 4.9 | 4.4 |  | 9.2 | 6.1 | 7.0 | 7.0
% Profit before Taxes / Total Assets - lower | -.3 | -.9 |  | -.4 | 2.8 | 3.7 | 1.0
Sales / Net Fixed Assets - upper | 7.0 | 31.0 |  | 20.9 | 21.3 | 21.3 | 21.1
Sales / Net Fixed Assets - median | .8 | 16.9 |  | 5.6 | 5.6 | 2.8 | 6.7
Sales / Net Fixed Assets - lower | .4 | 6.3 |  | 1.1 | 1.9 | 1.0 | 1.5
Sales / Total Assets - upper | 1.6 | 3.8 |  | 3.2 | 3.4 | 3.8 | 3.7
Sales / Total Assets - median | .4 | 2.6 |  | 2.0 | 1.7 | 1.2 | 1.8
Sales / Total Assets - lower | .3 | 1.7 |  | .8 | .6 | .6 | .7
% Depr, Depl, Amort / Sales - upper |  | 1.1 |  | 1.7 | 1.1 | .8 | 1.1
% Depr, Depl, Amort / Sales - median |  | (16)  1.6 |  | (18)  4.2 | 3.6 | (18)  1.1 | (83)  2.4
% Depr, Depl, Amort / Sales - lower |  | 7.2 |  | 16.6 | 12.3 | 8.4 | 12.1
% Officers', Directors', Owners' Comp / Sales - upper |  |  |  |  |  |  | 2.4
% Officers', Directors', Owners' Comp / Sales - median |  |  |  |  |  |  | (24)  6.8
% Officers', Directors', Owners' Comp / Sales - lower |  |  |  |  |  |  | 10.3
Net Sales ($) | 4381M | 34280M | 25894M | 152797M | 310715M | 2630312M | 3158379M
Total Assets ($) | 10110M | 18876M | 10229M | 156997M | 377313M | 2098075M | 2671600M