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

517919 - All Other Telecommunications
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 | 12 | 12 | 3 | 6 | 36
Reviewed |  | 4 | 4 | 1 |  |  | 9
Compiled | 4 | 4 | 5 | 1 | 1 |  | 15
Tax Returns | 4 | 3 | 5 |  |  |  | 12
Other | 3 | 15 | 20 | 12 | 5 | 3 | 58
 |  |  |  |  |  |  | 15 (4/1-9/30/07) 115 (10/1-3/31/08)
Number of Statements | 11 | 29 | 46 | 26 | 9 | 9 | 130
ASSETS
Cash & Equivalents | 35.5 | 10.4 | 14.9 | 14.4 |  |  | 14.5
Trade Receivables - (net) | 19.5 | 31.6 | 36.1 | 32.7 |  |  | 31.5
Inventory | 9.5 | 7.3 | 7.3 | 6.4 |  |  | 7.3
All Other Current Assets | 8.4 | 4.5 | 4.7 | 5.0 |  |  | 4.8
Total Current Assets | 73.0 | 53.7 | 63.1 | 58.4 |  |  | 58.1
Fixed Assets (net) | 14.9 | 30.8 | 21.6 | 21.9 |  |  | 24.4
Intangibles (net) | .0 | 2.6 | 7.3 | 11.8 |  |  | 7.9
All Other Non-Current Assets | 12.2 | 12.9 | 7.9 | 7.9 |  |  | 9.7
Total Assets | 100.0 | 100.0 | 100.0 | 100.0 |  |  | 100.0
LIABILITIES
Notes Payable-Short Term | 26.9 | 17.9 | 8.0 | 5.2 |  |  | 10.7
Cur. Mat.-L/T/D | 18.7 | 2.0 | 3.3 | 3.2 |  |  | 4.2
Trade Payables | 11.3 | 14.5 | 22.0 | 17.8 |  |  | 17.5
Income Taxes Payable | .0 | .7 | .4 | .5 |  |  | .4
All Other Current Liabilities | 19.8 | 16.0 | 16.6 | 17.6 |  |  | 16.6
Total Current Liabilities | 76.7 | 51.1 | 50.4 | 44.4 |  |  | 49.4
Long Term Debt | 31.0 | 16.2 | 12.9 | 20.5 |  |  | 19.5
Deferred Taxes | .0 | .0 | .3 | 1.0 |  |  | .4
All Other Non-Current Liabilities | 18.4 | 4.2 | 8.1 | 2.8 |  |  | 6.6
Net Worth | -26.1 | 28.6 | 28.2 | 31.4 |  |  | 24.2
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 | 85.3 | 89.3 | 94.9 | 89.6 |  |  | 91.4
Operating Profit | 14.7 | 10.7 | 5.1 | 10.4 |  |  | 8.6
All Other Expenses (net) | 3.0 | 2.4 | 1.0 | 1.9 |  |  | 2.4
Profit Before Taxes | 11.7 | 8.3 | 4.1 | 8.5 |  |  | 6.2
RATIOS
Current - upper | 3.3 | 2.3 | 1.8 | 1.9 |  |  | 1.9
Current - median | .9 | 1.3 | 1.2 | 1.3 |  |  | 1.3
Current - lower | .6 | .4 | .8 | .8 |  |  | .8
Quick - upper | 1.5 | 1.8 | 1.5 | 1.5 |  |  | 1.5
Quick - median | .6 | 1.0 | 1.0 | 1.1 |  |  | 1.0
Quick - lower | .4 | .3 | .5 | .8 |  |  | .5
Sales / Receivables - upper | [0]  UND | [0]  UND | [30]  12.0 | [20]  18.5 |  |  | [24]  15.5
Sales / Receivables - median | [0]  999.8 | [33]  11.0 | [50]  7.3 | [46]  7.9 |  |  | [44]  8.3
Sales / Receivables - lower | [67]  5.5 | [51]  7.1 | [70]  5.2 | [70]  5.2 |  |  | [71]  5.1
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 | 19.8 | 8.3 | 7.7 | 8.6 |  |  | 8.2
Sales / Working Capital - median | -51.2 | 26.9 | 20.4 | 18.9 |  |  | 19.8
Sales / Working Capital - lower | -14.2 | -10.4 | -24.5 | -34.9 |  |  | -26.1
EBIT / Interest - upper |  | 7.4 | 8.0 | 12.0 |  |  | 9.7
EBIT / Interest - median |  | (23)  3.3 | (33)  4.4 | (20)  3.6 |  |  | (100)  3.8
EBIT / Interest - lower |  | .1 | 1.5 | 2.2 |  |  | 1.2
Net Profit + DDA / Curr Mat LTD - upper |  |  |  |  |  |  | 4.9
Net Profit + DDA / Curr Mat LTD - median |  |  |  |  |  |  | (21)  2.4
Net Profit + DDA / Curr Mat LTD - lower |  |  |  |  |  |  | 1.3
Fixed / Worth - upper | .0 | .2 | .2 | .2 |  |  | .2
Fixed / Worth - median | 2.0 | .6 | .7 | 1.0 |  |  | 1.0
Fixed / Worth - lower | -.1 | 18.8 | 15.2 | 4.7 |  |  | 17.1
Debt / Worth - upper | 2.0 | 1.1 | 1.0 | 1.5 |  |  | 1.2
Debt / Worth - median | 12.6 | 2.4 | 3.0 | 3.2 |  |  | 3.1
Debt / Worth - lower | -2.8 | 23.2 | 24.8 | 9.3 |  |  | 69.6
% Profit before Taxes / Tangible Net Worth - upper |  | 85.4 | 84.4 | 81.6 |  |  | 86.8
% Profit before Taxes / Tangible Net Worth - median |  | (24)  73.4 | (36)  33.1 | (21)  19.4 |  |  | (100)  33.1
% Profit before Taxes / Tangible Net Worth - lower |  | 10.1 | 5.7 | 2.2 |  |  | 10.1
% Profit before Taxes / Total Assets - upper | 291.1 | 22.0 | 23.7 | 23.2 |  |  | 23.0
% Profit before Taxes / Total Assets - median | 33.7 | 6.6 | 7.6 | 7.6 |  |  | 7.0
% Profit before Taxes / Total Assets - lower | 9.3 | -1.8 | .8 | 3.4 |  |  | .8
Sales / Net Fixed Assets - upper | 999.8 | 39.8 | 46.1 | 52.0 |  |  | 49.1
Sales / Net Fixed Assets - median | 105.4 | 19.5 | 16.4 | 21.2 |  |  | 17.6
Sales / Net Fixed Assets - lower | 16.3 | 6.0 | 6.2 | 8.4 |  |  | 6.2
Sales / Total Assets - upper | 14.8 | 4.4 | 3.4 | 3.9 |  |  | 3.8
Sales / Total Assets - median | 8.3 | 3.5 | 2.4 | 2.8 |  |  | 2.6
Sales / Total Assets - lower | 2.5 | 2.0 | 1.7 | 1.0 |  |  | 1.3
% Depr, Depl, Amort / Sales - upper |  | .7 | 1.2 | .5 |  |  | .8
% Depr, Depl, Amort / Sales - median |  | (22)  1.6 | (39)  1.7 | (22)  1.4 |  |  | (99)  1.9
% Depr, Depl, Amort / Sales - lower |  | 3.5 | 5.3 | 4.3 |  |  | 5.3
% Officers', Directors', Owners' Comp / Sales - upper |  | 2.2 | 1.9 |  |  |  | 2.2
% Officers', Directors', Owners' Comp / Sales - median |  | (13)  3.7 | (11)  7.7 |  |  |  | (33)  5.0
% Officers', Directors', Owners' Comp / Sales - lower |  | 9.8 | 11.6 |  |  |  | 11.7
Net Sales ($) | 17087M | 114082M | 588436M | 1387024M | 974227M | 1930001M | 5010857M
Total Assets ($) | 2651M | 32953M | 235638M | 599470M | 653153M | 1759526M | 3283391M