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

517210 - Wireless Telecommunications Carriers (except Satellite)
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 |  |  | 6 | 7 | 5 | 8 | 26
Reviewed |  | 2 | 9 | 4 |  |  | 15
Compiled | 2 | 5 | 3 |  |  |  | 10
Tax Returns | 6 | 7 | 2 |  |  |  | 15
Other | 1 | 7 | 9 | 10 | 3 | 1 | 31
 |  |  |  |  |  |  | 14 (4/1-9/30/07) 83 (10/1-3/31/08)
Number of Statements | 9 | 21 | 29 | 21 | 8 | 9 | 97
ASSETS
Cash & Equivalents |  | 11.2 | 9.8 | 13.7 |  |  | 11.7
Trade Receivables - (net) |  | 29.7 | 22.3 | 24.0 |  |  | 21.3
Inventory |  | 17.1 | 9.9 | 6.3 |  |  | 10.6
All Other Current Assets |  | 4.7 | 6.8 | 6.8 |  |  | 5.0
Total Current Assets |  | 62.7 | 48.7 | 50.8 |  |  | 48.5
Fixed Assets (net) |  | 29.4 | 36.8 | 33.2 |  |  | 38.6
Intangibles (net) |  | 3.2 | 7.9 | 9.8 |  |  | 7.3
All Other Non-Current Assets |  | 4.8 | 6.5 | 6.3 |  |  | 5.6
Total Assets |  | 100.0 | 100.0 | 100.0 |  |  | 100.0
LIABILITIES
Notes Payable-Short Term |  | 10.6 | 10.0 | 1.0 |  |  | 6.0
Cur. Mat.-L/T/D |  | 7.4 | 4.2 | 2.1 |  |  | 4.1
Trade Payables |  | 20.5 | 12.0 | 12.5 |  |  | 15.1
Income Taxes Payable |  | .4 | .5 | .1 |  |  | .3
All Other Current Liabilities |  | 12.1 | 11.0 | 14.8 |  |  | 11.3
Total Current Liabilities |  | 51.1 | 37.8 | 30.5 |  |  | 36.8
Long Term Debt |  | 31.3 | 21.2 | 10.3 |  |  | 24.7
Deferred Taxes |  | .0 | .0 | .6 |  |  | .3
All Other Non-Current Liabilities |  | 2.5 | 2.4 | 11.8 |  |  | 5.9
Net Worth |  | 15.1 | 38.7 | 46.7 |  |  | 32.2
Total Liabilities & Net Worth |  | 100.0 | 100.0 | 100.0 |  |  | 100.0
INCOME DATA
Net Sales |  | 100.0 | 100.0 | 100.0 |  |  | 100.0
Gross Profit |  | 100.0 | 100.0 | 100.0 |  |  | 100.0
Operating Expenses |  | 96.8 | 92.0 | 94.2 |  |  | 93.1
Operating Profit |  | 3.2 | 8.0 | 5.8 |  |  | 6.9
All Other Expenses (net) |  | .7 | 2.5 | .7 |  |  | 1.7
Profit Before Taxes |  | 2.5 | 5.5 | 5.2 |  |  | 5.2
RATIOS
Current - upper |  | 2.3 | 2.6 | 2.9 |  |  | 2.3
Current - median |  | 1.7 | 1.4 | 1.6 |  |  | 1.5
Current - lower |  | .7 | .8 | 1.0 |  |  | 1.0
Quick - upper |  | 1.6 | 1.5 | 2.5 |  |  | 1.6
Quick - median |  | 1.0 | 1.0 | 1.1 |  |  | 1.0
Quick - lower |  | .4 | .6 | .7 |  |  | .6
Sales / Receivables - upper |  | [15]  23.7 | [22]  16.7 | [32]  11.4 |  |  | [22]  16.7
Sales / Receivables - median |  | [26]  13.9 | [32]  11.4 | [43]  8.5 |  |  | [35]  10.5
Sales / Receivables - lower |  | [63]  5.8 | [53]  6.9 | [60]  6.1 |  |  | [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 |  | 7.5 | 6.1 | 5.4 |  |  | 6.7
Sales / Working Capital - median |  | 18.6 | 31.2 | 12.4 |  |  | 15.0
Sales / Working Capital - lower |  | -20.6 | -23.6 | 37.1 |  |  | -131.4
EBIT / Interest - upper |  | 15.2 | 15.5 | 18.1 |  |  | 13.1
EBIT / Interest - median |  | (19)  2.8 | (27)  4.0 | (17)  12.8 |  |  | (83)  3.9
EBIT / Interest - lower |  | .9 | 1.3 | 3.9 |  |  | 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 |  | .1 | .6 | .2 |  |  | .5
Fixed / Worth - median |  | .6 | 1.4 | 1.2 |  |  | 1.4
Fixed / Worth - lower |  | NM | 2.5 | 1.7 |  |  | 2.8
Debt / Worth - upper |  | .8 | .8 | .5 |  |  | .8
Debt / Worth - median |  | 1.5 | 1.9 | 1.8 |  |  | 2.0
Debt / Worth - lower |  | NM | 4.6 | 4.2 |  |  | 8.6
% Profit before Taxes / Tangible Net Worth - upper |  | 49.8 | 51.9 | 69.2 |  |  | 60.8
% Profit before Taxes / Tangible Net Worth - median |  | (16)  28.1 | (25)  15.1 | (20)  27.2 |  |  | (80)  24.6
% Profit before Taxes / Tangible Net Worth - lower |  | 15.4 | 2.5 | 5.8 |  |  | 6.8
% Profit before Taxes / Total Assets - upper |  | 25.3 | 23.4 | 16.3 |  |  | 17.1
% Profit before Taxes / Total Assets - median |  | 8.2 | 5.4 | 6.4 |  |  | 7.0
% Profit before Taxes / Total Assets - lower |  | .4 | .5 | 3.7 |  |  | 1.0
Sales / Net Fixed Assets - upper |  | 46.9 | 20.9 | 20.2 |  |  | 21.1
Sales / Net Fixed Assets - median |  | 16.9 | 6.2 | 11.3 |  |  | 6.7
Sales / Net Fixed Assets - lower |  | 6.3 | 1.5 | 1.5 |  |  | 1.5
Sales / Total Assets - upper |  | 3.9 | 3.2 | 3.4 |  |  | 3.7
Sales / Total Assets - median |  | 3.2 | 2.2 | 1.6 |  |  | 1.8
Sales / Total Assets - lower |  | 1.8 | .9 | .6 |  |  | .7
% Depr, Depl, Amort / Sales - upper |  | 1.2 | 1.1 | .8 |  |  | 1.1
% Depr, Depl, Amort / Sales - median |  | (18)  1.7 | (26)  4.3 | 2.4 |  |  | (83)  2.4
% Depr, Depl, Amort / Sales - lower |  | 2.6 | 13.1 | 14.0 |  |  | 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 ($) | 10918M | 62197M | 285187M | 1132728M | 655609M | 1011740M | 3158379M
Total Assets ($) | 2450M | 19084M | 128594M | 469556M | 537644M | 1514272M | 2671600M