Spreadsheet: 54885d1254933118-select-from-list-and-it-pulls-data-from-corresponding-sheet-listandworksheet
Sheet: Internet Service Provide Sales

518111 - Internet Service Providers
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 | 1 | 3 | 4 | 8 | 18
Reviewed |  | 1 | 2 | 1 | 2 | 1 | 7
Compiled |  | 3 |  | 2 | 1 |  | 6
Tax Returns | 6 | 2 | 3 |  |  |  | 11
Other | 7 | 8 | 5 | 4 | 4 | 15 | 43
 |  |  |  |  |  |  | 8 (4/1-9/30/06) 77 (10/1-3/31/07)
Number of Statements | 13 | 16 | 11 | 10 | 11 | 24 | 85
ASSETS
Cash & Equivalents | 28.1 | 14.6 | 15.8 | 16.8 | 35.9 | 15.7 | 20.2
Trade Receivables - (net) | 17.9 | 14.2 | 16.3 | 36.0 | 30.5 | 30.3 | 24.2
Inventory | .6 | 2.8 | .7 | .9 | .2 | 1.6 | 1.3
All Other Current Assets | .0 | 9.7 | 3.6 | 1.4 | 5.3 | 7.9 | 5.4
Total Current Assets | 46.7 | 41.3 | 36.4 | 55.2 | 71.9 | 55.4 | 51.1
Fixed Assets (net) | 38.9 | 42.1 | 34.8 | 31.6 | 12.2 | 22.0 | 29.9
Intangibles (net) | 8.7 | 5.3 | 6.9 | 7.4 | 11.6 | 17.0 | 10.4
All Other Non-Current Assets | 5.7 | 11.3 | 21.9 | 5.8 | 4.2 | 5.7 | 8.7
Total Assets | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0
LIABILITIES
Notes Payable-Short Term | 15.3 | 13.4 | 30.3 | 10.0 | 13.3 | 5.5 | 13.2
Cur. Mat.-L/T/D | 2.3 | 3.4 | 5.7 | 3.5 | 2.6 | 2.0 | 3.0
Trade Payables | 54.6 | 11.3 | 14.5 | 15.9 | 14.8 | 7.3 | 18.2
Income Taxes Payable | .0 | .7 | .1 | .2 | .0 | .4 | .3
All Other Current Liabilities | 28.6 | 14.5 | 46.5 | 28.7 | 23.8 | 22.9 | 26.0
Total Current Liabilities | 100.9 | 43.2 | 97.1 | 58.1 | 54.5 | 38.1 | 60.8
Long Term Debt | 28.7 | 20.4 | 10.8 | 10.4 | 9.2 | 23.5 | 18.7
Deferred Taxes | .0 | .0 | .0 | .0 | .0 | .3 | .1
All Other Non-Current Liabilities | 4.9 | 14.1 | 22.1 | 13.4 | 4.4 | 7.0 | 10.4
Net Worth | -34.4 | 22.4 | -30.0 | 18.1 | 31.9 | 31.2 | 10.1
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 | 95.5 | 97.7 | 104.4 | 89.8 | 90.6 | 93.7 | 95.2
Operating Profit | 4.5 | 2.3 | -4.4 | 10.2 | 9.4 | 6.3 | 4.8
All Other Expenses (net) | 3.3 | 1.6 | 2.5 | .4 | .1 | 2.7 | 2.0
Profit Before Taxes | 1.1 | .7 | -6.9 | 9.8 | 9.3 | 3.6 | 2.8
RATIOS
Current - upper | 1.0 | 2.7 | 1.2 | 2.3 | 4.8 | 2.7 | 2.4
Current - median | .6 | 1.1 | .8 | 1.5 | 1.7 | 1.8 | 1.2
Current - lower | .1 | .5 | .2 | .4 | 1.2 | .8 | .5
Quick - upper | 1.0 | 1.6 | 1.1 | 2.3 | 4.6 | 2.6 | 2.0
Quick - median | .6 | .5 | .6 | 1.4 | 1.4 | 1.4 | 1.0
Quick - lower | .1 | .3 | .2 | .3 | 1.1 | .7 | .3
Sales / Receivables - upper | [0]  UND | [2]  184.8 | [6]  62.9 | [12]  30.3 | [10]  34.9 | [42]  8.6 | [6]  56.9
Sales / Receivables - median | [8]  43.7 | [10]  36.7 | [7]  48.8 | [59]  6.2 | [28]  13.2 | [60]  6.1 | [29]  12.6
Sales / Receivables - lower | [37]  9.8 | [27]  13.4 | [40]  9.1 | [70]  5.2 | [65]  5.6 | [73]  5.0 | [64]  5.7
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 | NM | 15.0 | 79.4 | 6.1 | 5.9 | 6.0 | 7.7
Sales / Working Capital - median | -13.9 | 205.8 | -14.3 | 14.0 | 11.5 | 9.8 | 69.4
Sales / Working Capital - lower | -3.9 | -8.6 | -2.8 | -6.4 | 39.7 | -13.5 | -7.3
EBIT / Interest - upper |  | 29.3 | 2.8 |  |  | 11.8 | 13.5
EBIT / Interest - median |  | (13)  2.9 | .8 |  |  | (16)  2.1 | (65)  2.1
EBIT / Interest - lower |  | -5.2 | -13.0 |  |  | -.2 | -.4
Net Profit + DDA / Curr Mat LTD - upper |  |  |  |  |  |  | 46.1
Net Profit + DDA / Curr Mat LTD - median |  |  |  |  |  |  | (12)  6.9
Net Profit + DDA / Curr Mat LTD - lower |  |  |  |  |  |  | 4.0
Fixed / Worth - upper | .6 | .7 | .9 | .2 | .1 | .2 | .2
Fixed / Worth - median | 11.5 | 1.8 | -5.3 | 2.1 | .2 | .6 | 1.2
Fixed / Worth - lower | -2.3 | -1.6 | -1.1 | -1.6 | -.9 | -1.1 | -1.3
Debt / Worth - upper | 6.6 | .7 | 1.5 | .7 | .2 | .6 | .8
Debt / Worth - median | 45.2 | 2.7 | -25.0 | 14.2 | 1.7 | 1.7 | 3.3
Debt / Worth - lower | -2.8 | -4.1 | -3.8 | -3.1 | -3.5 | -3.4 | -3.8
% Profit before Taxes / Tangible Net Worth - upper |  | 78.9 |  |  |  | 56.5 | 108.5
% Profit before Taxes / Tangible Net Worth - median |  | (10)  29.2 |  |  |  | (15)  36.3 | (53)  37.6
% Profit before Taxes / Tangible Net Worth - lower |  | -20.2 |  |  |  | 10.9 | 3.0
% Profit before Taxes / Total Assets - upper | 51.5 | 26.9 | 7.5 | 38.9 | 63.4 | 24.0 | 28.6
% Profit before Taxes / Total Assets - median | 1.5 | .9 | -.2 | 22.0 | 18.0 | 5.5 | 6.8
% Profit before Taxes / Total Assets - lower | -4.0 | -19.4 | -48.8 | -3.5 | 8.5 | -6.5 | -7.1
Sales / Net Fixed Assets - upper | UND | 39.5 | 22.0 | 22.0 | 121.2 | 34.7 | 34.7
Sales / Net Fixed Assets - median | 5.9 | 6.4 | 6.3 | 9.4 | 22.0 | 15.2 | 12.2
Sales / Net Fixed Assets - lower | 1.5 | 2.2 | 4.6 | 6.0 | 11.1 | 8.6 | 4.9
Sales / Total Assets - upper | 6.6 | 5.1 | 3.2 | 4.0 | 5.1 | 3.2 | 3.6
Sales / Total Assets - median | 2.1 | 2.5 | 2.1 | 2.4 | 2.4 | 2.0 | 2.2
Sales / Total Assets - lower | .7 | 1.5 | 1.1 | 1.6 | 1.9 | .9 | 1.3
% Depr, Depl, Amort / Sales - upper |  | 3.1 |  |  |  | 1.5 | 1.8
% Depr, Depl, Amort / Sales - median |  | (14)  5.7 |  |  |  | (17)  3.4 | (61)  3.8
% Depr, Depl, Amort / Sales - lower |  | 12.1 |  |  |  | 6.7 | 7.9
% Officers', Directors', Owners' Comp / Sales - upper |  |  |  |  |  |  | 1.5
% Officers', Directors', Owners' Comp / Sales - median |  |  |  |  |  |  | (16)  4.8
% Officers', Directors', Owners' Comp / Sales - lower |  |  |  |  |  |  | 17.5
Net Sales ($) | 6102M | 34401M | 40723M | 65911M | 183867M | 1739402M | 2070406M
Total Assets ($) | 3026M | 22774M | 28018M | 29920M | 79025M | 1415407M | 1578170M