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

517212 - Cellular and Other Wireless Telecommunications
2007-08 Annual Statement Studies
National - All Regions
TOC
 | 0-500M | 500M-2MM | 2-10MM | 10-50MM | 50-100MM | 100-250MM | All
Type of Statement
Unqualified |  |  | 4 | 12 | 4 | 8 | 28
Reviewed |  | 1 | 9 | 2 |  |  | 12
Compiled | 1 | 4 | 5 |  |  |  | 10
Tax Returns | 6 | 5 | 3 |  |  | 1 | 15
Other | 3 | 11 | 8 | 9 | 2 |  | 33
 |  |  |  |  |  |  | 16 (4/1-9/30/06) 82 (10/1-3/31/07)
Number of Statements | 10 | 21 | 29 | 23 | 6 | 9 | 98
ASSETS
Cash & Equivalents | 19.5 | 10.0 | 14.2 | 12.3 |  |  | 13.6
Trade Receivables - (net) | 11.8 | 23.6 | 25.5 | 20.5 |  |  | 20.2
Inventory | 22.6 | 17.1 | 12.3 | 7.5 |  |  | 12.3
All Other Current Assets | .8 | 1.9 | 8.4 | 2.9 |  |  | 3.8
Total Current Assets | 54.6 | 52.6 | 60.3 | 43.1 |  |  | 50.0
Fixed Assets (net) | 22.7 | 38.5 | 27.4 | 39.3 |  |  | 34.6
Intangibles (net) | .0 | 3.7 | 4.6 | 8.3 |  |  | 6.0
All Other Non-Current Assets | 22.7 | 5.2 | 7.6 | 9.3 |  |  | 9.5
Total Assets | 100.0 | 100.0 | 100.0 | 100.0 |  |  | 100.0
LIABILITIES
Notes Payable-Short Term | 16.3 | 8.6 | 9.1 | 1.7 |  |  | 6.7
Cur. Mat.-L/T/D | 9.8 | 7.9 | 3.2 | 4.5 |  |  | 5.0
Trade Payables | 6.3 | 14.4 | 18.6 | 15.6 |  |  | 14.3
Income Taxes Payable | .0 | .0 | .3 | .2 |  |  | .2
All Other Current Liabilities | 28.5 | 7.7 | 19.1 | 12.8 |  |  | 14.4
Total Current Liabilities | 60.8 | 38.5 | 50.2 | 34.6 |  |  | 40.5
Long Term Debt | 25.1 | 32.5 | 21.2 | 20.0 |  |  | 25.2
Deferred Taxes | .0 | .0 | .2 | .3 |  |  | .5
All Other Non-Current Liabilities | 8.9 | 6.8 | 3.0 | 4.2 |  |  | 7.1
Net Worth | 5.0 | 22.2 | 25.4 | 41.0 |  |  | 26.8
Total Liabilities & Net Worth | 100.0 | 100.0 | 100.0 | 100.0 |  |  | 100.0
INCOME DATA
Net Sales | 100.0 | 100.0 | 100.0 | 100.0 |  |  | 100.0
Gross Profit | 100.0 | 100.0 | 100.0 | 100.0 |  |  | 100.0
Operating Expenses | 93.0 | 96.2 | 93.9 | 90.5 |  |  | 92.5
Operating Profit | 7.0 | 3.8 | 6.1 | 9.5 |  |  | 7.5
All Other Expenses (net) | .6 | .5 | 2.7 | 2.2 |  |  | 1.8
Profit Before Taxes | 6.5 | 3.4 | 3.3 | 7.3 |  |  | 5.8
RATIOS
Current - upper | 5.9 | 2.0 | 2.5 | 2.0 |  |  | 2.2
Current - median | 2.2 | 1.3 | 1.0 | 1.3 |  |  | 1.3
Current - lower | .2 | .9 | .7 | .7 |  |  | .8
Quick - upper | 3.9 | 1.5 | 1.9 | 1.8 |  |  | 1.6
Quick - median | 1.0 | .8 | .7 | .9 |  |  | .8
Quick - lower | .2 | .4 | .5 | .6 |  |  | .5
Sales / Receivables - upper | [0]  UND | [14]  26.8 | [19]  19.7 | [31]  11.8 |  |  | [18]  20.2
Sales / Receivables - median | [0]  UND | [28]  12.9 | [41]  8.9 | [40]  9.0 |  |  | [33]  11.0
Sales / Receivables - lower | [27]  13.3 | [49]  7.5 | [60]  6.1 | [55]  6.7 |  |  | [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 | 7.6 | 15.4 | 6.4 | 5.3 |  |  | 7.2
Sales / Working Capital - median | 28.3 | 29.7 | 192.8 | 15.5 |  |  | 28.2
Sales / Working Capital - lower | -17.0 | -98.8 | -16.0 | -23.6 |  |  | -19.6
EBIT / Interest - upper |  | 5.7 | 14.4 | 16.3 |  |  | 13.3
EBIT / Interest - median |  | (20)  2.5 | (26)  5.3 | (20)  6.2 |  |  | (85)  4.0
EBIT / Interest - lower |  | .3 | 1.4 | 1.5 |  |  | 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 | .1 | .7 | .4 | .6 |  |  | .5
Fixed / Worth - median | 1.1 | 1.5 | 1.1 | 1.2 |  |  | 1.3
Fixed / Worth - lower | -.5 | -34.9 | 5.4 | 4.1 |  |  | 24.5
Debt / Worth - upper | .8 | 1.1 | .6 | .7 |  |  | .9
Debt / Worth - median | 4.9 | 4.5 | 6.3 | 2.1 |  |  | 4.0
Debt / Worth - lower | -6.4 | -45.3 | 16.4 | 24.3 |  |  | 89.9
% Profit before Taxes / Tangible Net Worth - upper |  | 252.5 | 58.0 | 48.1 |  |  | 80.7
% Profit before Taxes / Tangible Net Worth - median |  | (15)  35.4 | (24)  31.5 | (19)  24.2 |  |  | (76)  34.5
% Profit before Taxes / Tangible Net Worth - lower |  | -7.1 | 12.7 | 6.1 |  |  | 12.0
% Profit before Taxes / Total Assets - upper | 51.1 | 16.2 | 18.0 | 21.7 |  |  | 20.9
% Profit before Taxes / Total Assets - median | 18.8 | 7.2 | 5.6 | 6.7 |  |  | 6.8
% Profit before Taxes / Total Assets - lower | 4.2 | -3.8 | 1.3 | 1.4 |  |  | 1.7
Sales / Net Fixed Assets - upper | 276.0 | 32.2 | 27.6 | 14.8 |  |  | 31.0
Sales / Net Fixed Assets - median | 125.2 | 5.0 | 12.0 | 6.7 |  |  | 8.6
Sales / Net Fixed Assets - lower | 14.4 | 3.4 | 4.8 | .9 |  |  | 2.0
Sales / Total Assets - upper | 21.3 | 3.6 | 3.3 | 2.8 |  |  | 3.5
Sales / Total Assets - median | 4.8 | 2.7 | 2.4 | 1.1 |  |  | 2.2
Sales / Total Assets - lower | 3.1 | 1.5 | 1.0 | .6 |  |  | .8
% Depr, Depl, Amort / Sales - upper |  | 1.2 | 1.4 | 1.8 |  |  | 1.3
% Depr, Depl, Amort / Sales - median |  | 3.8 | (25)  2.2 | (21)  3.7 |  |  | (77)  3.2
% Depr, Depl, Amort / Sales - lower |  | 8.3 | 6.8 | 16.1 |  |  | 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 ($) | 14023M | 72163M | 327154M | 972467M | 642980M | 1815019M | 3843806M
Total Assets ($) | 2164M | 23618M | 131485M | 544766M | 423226M | 1542848M | 2668107M