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

517212 - Cellular and Other Wireless Telecommunications
2007-08 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 |  |  | 2 | 4 | 4 | 18 | 28
Reviewed |  |  | 3 | 4 | 2 | 3 | 12
Compiled | 1 | 2 | 3 | 2 | 2 |  | 10
Tax Returns | 5 | 4 | 3 | 2 | 1 |  | 15
Other | 3 | 6 | 5 | 4 | 6 | 9 | 33
 |  |  |  |  |  |  | 16 (4/1-9/30/06) 82 (10/1-3/31/07)
Number of Statements | 9 | 12 | 16 | 16 | 15 | 30 | 98
ASSETS
Cash & Equivalents |  | 14.9 | 9.7 | 9.5 | 14.6 | 15.0 | 13.6
Trade Receivables - (net) |  | 15.9 | 24.3 | 23.6 | 20.7 | 21.0 | 20.2
Inventory |  | 15.9 | 15.4 | 14.6 | 7.3 | 9.9 | 12.3
All Other Current Assets |  | 2.5 | 2.6 | 1.1 | 9.4 | 4.6 | 3.8
Total Current Assets |  | 49.2 | 51.9 | 48.8 | 52.1 | 50.5 | 50.0
Fixed Assets (net) |  | 32.3 | 36.2 | 37.3 | 27.6 | 34.2 | 34.6
Intangibles (net) |  | 4.5 | 4.7 | 8.3 | 3.7 | 8.8 | 6.0
All Other Non-Current Assets |  | 14.1 | 7.2 | 5.6 | 16.7 | 6.4 | 9.5
Total Assets |  | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0
LIABILITIES
Notes Payable-Short Term |  | 15.9 | 5.7 | 11.9 | 5.7 | 1.4 | 6.7
Cur. Mat.-L/T/D |  | 4.2 | 8.4 | 4.0 | 1.6 | 3.3 | 5.0
Trade Payables |  | 12.0 | 14.9 | 11.3 | 22.3 | 16.7 | 14.3
Income Taxes Payable |  | .0 | .2 | .1 | .3 | .2 | .2
All Other Current Liabilities |  | 25.0 | 10.6 | 10.0 | 17.3 | 15.7 | 14.4
Total Current Liabilities |  | 57.0 | 39.7 | 37.2 | 47.1 | 37.3 | 40.5
Long Term Debt |  | 25.5 | 22.2 | 32.8 | 15.9 | 20.0 | 25.2
Deferred Taxes |  | .0 | .0 | .0 | .4 | 1.3 | .5
All Other Non-Current Liabilities |  | 6.2 | 3.8 | 3.6 | 13.6 | 6.0 | 7.1
Net Worth |  | 11.2 | 34.4 | 26.4 | 23.0 | 35.5 | 26.8
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 |  | 100.0 | 93.3 | 93.0 | 92.3 | 91.1 | 92.5
Operating Profit |  | .0 | 6.7 | 7.0 | 7.7 | 8.9 | 7.5
All Other Expenses (net) |  | 1.1 | 1.3 | .8 | 1.7 | 1.0 | 1.8
Profit Before Taxes |  | -1.1 | 5.5 | 6.2 | 6.0 | 7.9 | 5.8
RATIOS
Current - upper |  | 1.9 | 2.2 | 3.2 | 2.1 | 1.8 | 2.2
Current - median |  | 1.5 | 1.3 | 1.2 | 1.0 | 1.3 | 1.3
Current - lower |  | .6 | .9 | .7 | .6 | .9 | .8
Quick - upper |  | 1.0 | 1.9 | 1.8 | 1.1 | 1.5 | 1.6
Quick - median |  | .9 | .7 | .7 | .8 | .8 | .8
Quick - lower |  | .4 | .4 | .5 | .5 | .6 | .5
Sales / Receivables - upper |  | [0]  UND | [23]  15.9 | [17]  21.2 | [15]  24.9 | [28]  12.9 | [18]  20.2
Sales / Receivables - median |  | [20]  18.0 | [32]  11.3 | [42]  8.6 | [36]  10.1 | [39]  9.4 | [33]  11.0
Sales / Receivables - lower |  | [43]  8.4 | [77]  4.7 | [58]  6.3 | [54]  6.8 | [51]  7.2 | [54]  6.8
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 |  | 16.5 | 6.0 | 8.5 | 5.3 | 9.8 | 7.2
Sales / Working Capital - median |  | 33.0 | 22.6 | 32.9 | 192.8 | 26.8 | 28.2
Sales / Working Capital - lower |  | -15.7 | -17.2 | -11.3 | -20.0 | -40.8 | -19.6
EBIT / Interest - upper |  | 12.2 | 14.9 | 7.2 | 16.2 | 15.4 | 13.3
EBIT / Interest - median |  | 3.1 | 3.8 | (15)  2.4 | (13)  4.1 | (24)  6.4 | (85)  4.0
EBIT / Interest - lower |  | .3 | -1.6 | 1.1 | 1.4 | 3.8 | 1.5
Net Profit + DDA / Curr Mat LTD - upper |  |  |  |  |  |  | 11.1
Net Profit + DDA / Curr Mat LTD - median |  |  |  |  |  |  | (13)  2.9
Net Profit + DDA / Curr Mat LTD - lower |  |  |  |  |  |  | 1.8
Fixed / Worth - upper |  | .5 | .5 | .5 | .1 | .5 | .5
Fixed / Worth - median |  | 1.2 | 1.2 | 1.8 | 1.1 | 1.3 | 1.3
Fixed / Worth - lower |  | -2.2 | 24.6 | 6.3 | 4.0 | 14.3 | 24.5
Debt / Worth - upper |  | .8 | .6 | 1.1 | .9 | .9 | .9
Debt / Worth - median |  | 4.9 | 2.5 | 4.2 | 6.3 | 3.7 | 4.0
Debt / Worth - lower |  | -5.7 | 62.8 | 11.1 | -25.8 | 47.9 | 89.9
% Profit before Taxes / Tangible Net Worth - upper |  |  | 235.1 | 44.7 | 58.2 | 154.6 | 80.7
% Profit before Taxes / Tangible Net Worth - median |  |  | (13)  31.6 | (13)  16.4 | (11)  33.6 | (25)  45.8 | (76)  34.5
% Profit before Taxes / Tangible Net Worth - lower |  |  | .2 | 4.9 | 16.4 | 24.7 | 12.0
% Profit before Taxes / Total Assets - upper |  | 23.2 | 27.8 | 20.4 | 10.9 | 22.4 | 20.9
% Profit before Taxes / Total Assets - median |  | 5.6 | 12.3 | 4.7 | 5.6 | 8.8 | 6.8
% Profit before Taxes / Total Assets - lower |  | -4.0 | -7.8 | .4 | .7 | 4.5 | 1.7
Sales / Net Fixed Assets - upper |  | 214.7 | 29.9 | 24.0 | 77.2 | 21.7 | 31.0
Sales / Net Fixed Assets - median |  | 11.7 | 6.5 | 11.2 | 11.1 | 11.5 | 8.6
Sales / Net Fixed Assets - lower |  | 3.1 | 3.8 | 1.4 | 2.8 | 1.2 | 2.0
Sales / Total Assets - upper |  | 15.4 | 3.5 | 3.1 | 4.0 | 3.5 | 3.5
Sales / Total Assets - median |  | 3.0 | 2.2 | 2.4 | 2.2 | 1.6 | 2.2
Sales / Total Assets - lower |  | 1.5 | 1.2 | .8 | .6 | .6 | .8
% Depr, Depl, Amort / Sales - upper |  |  | 1.3 | 1.6 | .8 | 1.1 | 1.3
% Depr, Depl, Amort / Sales - median |  |  | 3.2 | 3.0 | (12)  3.3 | (18)  2.4 | (77)  3.2
% Depr, Depl, Amort / Sales - lower |  |  | 6.7 | 9.8 | 11.2 | 9.0 | 9.1
% Officers', Directors', Owners' Comp / Sales - upper |  |  |  |  |  |  | 3.6
% Officers', Directors', Owners' Comp / Sales - median |  |  |  |  |  |  | (24)  7.2
% Officers', Directors', Owners' Comp / Sales - lower |  |  |  |  |  |  | 10.8
Net Sales ($) | 5765M | 23877M | 62333M | 128069M | 240166M | 3383596M | 3843806M
Total Assets ($) | 8741M | 8381M | 43856M | 90819M | 309278M | 2207032M | 2668107M