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

517919 - All Other Telecommunications
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 |  |  |  | 10 | 5 | 21 | 36
Reviewed |  |  | 3 | 2 | 3 | 1 | 9
Compiled | 4 | 2 | 2 | 5 |  | 2 | 15
Tax Returns | 2 | 4 |  | 3 | 3 |  | 12
Other | 4 | 9 | 5 | 9 | 15 | 16 | 58
 |  |  |  |  |  |  | 15 (4/1-9/30/07) 115 (10/1-3/31/08)
Number of Statements | 10 | 15 | 10 | 29 | 26 | 40 | 130
ASSETS
Cash & Equivalents | 28.3 | 14.4 | 16.2 | 14.6 | 11.7 | 12.2 | 14.5
Trade Receivables - (net) | 9.7 | 17.2 | 42.3 | 30.1 | 40.1 | 35.1 | 31.5
Inventory | 7.3 | 4.6 | 11.5 | 7.6 | 5.8 | 8.0 | 7.3
All Other Current Assets | 2.3 | 6.4 | 7.8 | 3.9 | 3.7 | 5.5 | 4.8
Total Current Assets | 47.6 | 42.6 | 77.7 | 56.1 | 61.3 | 60.8 | 58.1
Fixed Assets (net) | 39.7 | 37.7 | 14.7 | 23.6 | 23.0 | 19.4 | 24.4
Intangibles (net) | 7.9 | .8 | .0 | 9.9 | 6.7 | 11.7 | 7.9
All Other Non-Current Assets | 4.7 | 18.9 | 7.6 | 10.4 | 8.9 | 8.0 | 9.7
Total Assets | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0
LIABILITIES
Notes Payable-Short Term | 34.2 | 12.0 | 8.6 | 13.1 | 6.6 | 5.8 | 10.7
Cur. Mat.-L/T/D | 8.1 | 11.3 | 1.8 | 2.6 | 3.1 | 3.0 | 4.2
Trade Payables | 12.2 | 4.6 | 11.6 | 17.7 | 23.5 | 20.9 | 17.5
Income Taxes Payable | .0 | .0 | 2.1 | .6 | .1 | .3 | .4
All Other Current Liabilities | 30.8 | 4.8 | 20.0 | 12.9 | 18.3 | 18.2 | 16.6
Total Current Liabilities | 85.2 | 32.7 | 44.2 | 46.9 | 51.6 | 48.3 | 49.4
Long Term Debt | 40.3 | 18.3 | 10.7 | 15.2 | 20.9 | 19.0 | 19.5
Deferred Taxes | .0 | .5 | .0 | .2 | .1 | .9 | .4
All Other Non-Current Liabilities | 21.0 | 5.0 | 7.5 | 8.3 | 6.3 | 2.3 | 6.6
Net Worth | -46.5 | 43.5 | 37.6 | 29.4 | 21.1 | 29.5 | 24.2
Total Liabilities & Net Worth | 100.0 | 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 | 100.0
Gross Profit | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0
Operating Expenses | 86.6 | 80.4 | 91.9 | 93.8 | 94.6 | 92.6 | 91.4
Operating Profit | 13.4 | 19.6 | 8.1 | 6.2 | 5.4 | 7.4 | 8.6
All Other Expenses (net) | 6.4 | 2.7 | 2.4 | 2.0 | 2.7 | 1.4 | 2.4
Profit Before Taxes | 7.0 | 16.9 | 5.7 | 4.1 | 2.7 | 5.9 | 6.2
RATIOS
Current - upper | 1.0 | 5.9 | 3.1 | 3.4 | 2.2 | 1.8 | 1.9
Current - median | .6 | 1.8 | 1.6 | 1.2 | 1.3 | 1.3 | 1.3
Current - lower | .3 | .3 | 1.4 | .7 | .9 | 1.0 | .8
Quick - upper | .7 | 2.3 | 2.2 | 1.7 | 1.9 | 1.3 | 1.5
Quick - median | .4 | .7 | 1.1 | .9 | 1.1 | 1.0 | 1.0
Quick - lower | .2 | .3 | 1.0 | .5 | .6 | .8 | .5
Sales / Receivables - upper | [0]  UND | [0]  UND | [26]  14.1 | [26]  14.1 | [33]  11.2 | [33]  11.0 | [24]  15.5
Sales / Receivables - median | [14]  25.3 | [8]  47.6 | [48]  7.6 | [37]  10.0 | [60]  6.1 | [57]  6.4 | [44]  8.3
Sales / Receivables - lower | [56]  6.5 | [47]  7.8 | [86]  4.2 | [56]  6.6 | [75]  4.8 | [82]  4.5 | [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 | 18.5 | 5.9 | 8.6 | 5.1 | 6.0 | 8.9 | 8.2
Sales / Working Capital - median | -12.0 | 21.0 | 13.3 | 26.9 | 17.3 | 18.9 | 19.8
Sales / Working Capital - lower | -5.6 | -5.8 | 22.9 | -18.6 | -25.5 | 298.7 | -26.1
EBIT / Interest - upper |  | 7.3 |  | 8.9 | 7.9 | 13.6 | 9.7
EBIT / Interest - median |  | (12)  6.2 |  | (21)  3.3 | (19)  3.8 | (32)  4.8 | (100)  3.8
EBIT / Interest - lower |  | 1.4 |  | .7 | 1.2 | .7 | 1.2
Net Profit + DDA / Curr Mat LTD - upper |  |  |  |  |  | 5.0 | 4.9
Net Profit + DDA / Curr Mat LTD - median |  |  |  |  |  | (13)  2.4 | (21)  2.4
Net Profit + DDA / Curr Mat LTD - lower |  |  |  |  |  | 1.0 | 1.3
Fixed / Worth - upper | 7.0 | .1 | .1 | .3 | .2 | .3 | .2
Fixed / Worth - median | NM | 1.0 | .3 | 1.0 | 1.3 | .8 | 1.0
Fixed / Worth - lower | -.1 | 2.7 | 1.5 | NM | -1.4 | 3.8 | 17.1
Debt / Worth - upper | 24.8 | .3 | .8 | 1.0 | 1.5 | 1.5 | 1.2
Debt / Worth - median | -259.4 | 2.0 | 1.2 | 3.1 | 4.2 | 3.6 | 3.1
Debt / Worth - lower | -1.6 | 5.9 | 4.1 | NM | -5.9 | 11.3 | 69.6
% Profit before Taxes / Tangible Net Worth - upper |  | 96.7 |  | 79.5 | 91.0 | 82.3 | 86.8
% Profit before Taxes / Tangible Net Worth - median |  | 72.9 |  | (22)  54.7 | (18)  24.9 | (32)  23.2 | (100)  33.1
% Profit before Taxes / Tangible Net Worth - lower |  | 12.7 |  | 22.7 | 4.2 | 5.9 | 10.1
% Profit before Taxes / Total Assets - upper | 18.1 | 58.6 | 43.5 | 24.5 | 21.3 | 18.7 | 23.0
% Profit before Taxes / Total Assets - median | 2.9 | 17.0 | 6.7 | 7.5 | 7.5 | 5.8 | 7.0
% Profit before Taxes / Total Assets - lower | -4.4 | 3.7 | -1.9 | 1.0 | .1 | .3 | .8
Sales / Net Fixed Assets - upper | 81.7 | 91.1 | 158.0 | 38.1 | 64.7 | 39.8 | 49.1
Sales / Net Fixed Assets - median | 6.9 | 16.3 | 21.8 | 19.5 | 19.5 | 19.4 | 17.6
Sales / Net Fixed Assets - lower | .5 | 1.1 | 15.7 | 5.8 | 5.9 | 7.9 | 6.2
Sales / Total Assets - upper | 5.5 | 4.8 | 4.4 | 4.2 | 3.4 | 3.8 | 3.8
Sales / Total Assets - median | 1.7 | 3.1 | 3.2 | 2.6 | 2.4 | 2.6 | 2.6
Sales / Total Assets - lower | .1 | .8 | 2.6 | 1.7 | 1.5 | 1.0 | 1.3
% Depr, Depl, Amort / Sales - upper |  |  |  | .6 | 1.2 | .6 | .8
% Depr, Depl, Amort / Sales - median |  |  |  | (26)  1.5 | (22)  1.8 | (29)  1.7 | (99)  1.9
% Depr, Depl, Amort / Sales - lower |  |  |  | 6.4 | 5.9 | 3.9 | 5.3
% Officers', Directors', Owners' Comp / Sales - upper |  |  |  | 1.9 |  |  | 2.2
% Officers', Directors', Owners' Comp / Sales - median |  |  |  | (14)  6.2 |  |  | (33)  5.0
% Officers', Directors', Owners' Comp / Sales - lower |  |  |  | 10.3 |  |  | 11.7
Net Sales ($) | 5866M | 27595M | 41271M | 214783M | 439440M | 4281902M | 5010857M
Total Assets ($) | 10752M | 19965M | 12035M | 111260M | 420905M | 2708474M | 3283391M