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

518111 - Internet Service Providers
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 | 6 | 2 | 2 | 4 | 18
Reviewed |  | 1 | 6 |  |  |  | 7
Compiled | 2 |  | 4 |  |  |  | 6
Tax Returns | 7 | 4 |  |  |  |  | 11
Other | 9 | 11 | 10 | 9 | 4 |  | 43
 |  |  |  |  |  |  | 8 (4/1-9/30/06) 77 (10/1-3/31/07)
Number of Statements | 18 | 20 | 26 | 11 | 6 | 4 | 85
ASSETS
Cash & Equivalents | 29.2 | 13.3 | 20.7 | 22.6 |  |  | 20.2
Trade Receivables - (net) | 17.6 | 24.5 | 25.6 | 40.3 |  |  | 24.2
Inventory | .4 | 1.9 | .9 | 1.3 |  |  | 1.3
All Other Current Assets | 5.9 | 4.4 | 3.4 | 7.5 |  |  | 5.4
Total Current Assets | 53.2 | 44.1 | 50.6 | 71.7 |  |  | 51.1
Fixed Assets (net) | 29.2 | 43.4 | 28.2 | 21.2 |  |  | 29.9
Intangibles (net) | 9.0 | 2.1 | 11.4 | 2.9 |  |  | 10.4
All Other Non-Current Assets | 8.5 | 10.5 | 9.8 | 4.2 |  |  | 8.7
Total Assets | 100.0 | 100.0 | 100.0 | 100.0 |  |  | 100.0
LIABILITIES
Notes Payable-Short Term | 17.7 | 20.0 | 11.5 | 3.9 |  |  | 13.2
Cur. Mat.-L/T/D | 3.1 | 4.1 | 3.1 | 2.1 |  |  | 3.0
Trade Payables | 43.0 | 14.8 | 12.3 | 9.3 |  |  | 18.2
Income Taxes Payable | .1 | .4 | .1 | .6 |  |  | .3
All Other Current Liabilities | 25.1 | 33.0 | 23.0 | 18.0 |  |  | 26.0
Total Current Liabilities | 89.0 | 72.3 | 50.2 | 33.9 |  |  | 60.8
Long Term Debt | 22.9 | 15.7 | 11.6 | 28.3 |  |  | 18.7
Deferred Taxes | .0 | .0 | .0 | .0 |  |  | .1
All Other Non-Current Liabilities | 9.2 | 12.4 | 13.5 | .5 |  |  | 10.4
Net Worth | -21.2 | -.5 | 24.7 | 37.3 |  |  | 10.1
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 | 94.9 | 101.8 | 91.3 | 90.0 |  |  | 95.2
Operating Profit | 5.1 | -1.8 | 8.7 | 10.0 |  |  | 4.8
All Other Expenses (net) | 1.9 | 1.8 | 1.5 | 1.2 |  |  | 2.0
Profit Before Taxes | 3.2 | -3.5 | 7.2 | 8.8 |  |  | 2.8
RATIOS
Current - upper | 2.5 | 2.3 | 2.2 | 2.9 |  |  | 2.4
Current - median | .7 | 1.1 | 1.2 | 2.4 |  |  | 1.2
Current - lower | .4 | .4 | .6 | 1.5 |  |  | .5
Quick - upper | 1.3 | 2.3 | 2.0 | 2.8 |  |  | 2.0
Quick - median | .6 | 1.0 | 1.2 | 2.3 |  |  | 1.0
Quick - lower | .2 | .3 | .3 | 1.3 |  |  | .3
Sales / Receivables - upper | [0]  UND | [8]  46.6 | [6]  56.3 | [40]  9.1 |  |  | [6]  56.9
Sales / Receivables - median | [2]  179.0 | [21]  17.7 | [30]  12.2 | [61]  6.0 |  |  | [29]  12.6
Sales / Receivables - lower | [36]  10.2 | [50]  7.3 | [65]  5.6 | [76]  4.8 |  |  | [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 | 36.3 | 15.8 | 6.3 | 6.0 |  |  | 7.7
Sales / Working Capital - median | -16.5 | 96.5 | 41.3 | 6.8 |  |  | 69.4
Sales / Working Capital - lower | -5.2 | -6.6 | -7.7 | 11.8 |  |  | -7.3
EBIT / Interest - upper | 11.5 | 12.8 | 34.4 |  |  |  | 13.5
EBIT / Interest - median | (11)  1.4 | (17)  -1.3 | (24)  4.5 |  |  |  | (65)  2.1
EBIT / Interest - lower | .2 | -16.4 | 1.0 |  |  |  | -.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 | .4 | .7 | .2 | .1 |  |  | .2
Fixed / Worth - median | 7.6 | 1.5 | 1.1 | .3 |  |  | 1.2
Fixed / Worth - lower | -.3 | -1.6 | -2.5 | .5 |  |  | -1.3
Debt / Worth - upper | 2.3 | .7 | .8 | .5 |  |  | .8
Debt / Worth - median | 38.8 | 2.9 | 3.0 | .7 |  |  | 3.3
Debt / Worth - lower | -2.8 | -4.6 | -4.8 | 1.4 |  |  | -3.8
% Profit before Taxes / Tangible Net Worth - upper | 124.9 | 95.6 | 125.5 | 48.6 |  |  | 108.5
% Profit before Taxes / Tangible Net Worth - median | (10)  29.9 | (13)  39.7 | (17)  63.9 | (10)  31.3 |  |  | (53)  37.6
% Profit before Taxes / Tangible Net Worth - lower | -61.5 | -114.8 | 20.7 | 13.2 |  |  | 3.0
% Profit before Taxes / Total Assets - upper | 67.5 | 26.7 | 37.9 | 24.2 |  |  | 28.6
% Profit before Taxes / Total Assets - median | 8.6 | -6.6 | 10.1 | 15.1 |  |  | 6.8
% Profit before Taxes / Total Assets - lower | -3.1 | -35.7 | .3 | 6.8 |  |  | -7.1
Sales / Net Fixed Assets - upper | 596.0 | 21.6 | 22.2 | 41.6 |  |  | 34.7
Sales / Net Fixed Assets - median | 14.8 | 7.3 | 11.7 | 15.8 |  |  | 12.2
Sales / Net Fixed Assets - lower | 4.8 | 4.6 | 4.3 | 5.1 |  |  | 4.9
Sales / Total Assets - upper | 7.8 | 4.4 | 3.4 | 3.2 |  |  | 3.6
Sales / Total Assets - median | 3.4 | 2.8 | 1.9 | 2.9 |  |  | 2.2
Sales / Total Assets - lower | 1.7 | 2.0 | 1.3 | 1.8 |  |  | 1.3
% Depr, Depl, Amort / Sales - upper |  | 2.2 | 1.9 |  |  |  | 1.8
% Depr, Depl, Amort / Sales - median |  | (16)  5.4 | (21)  3.8 |  |  |  | (61)  3.8
% Depr, Depl, Amort / Sales - lower |  | 9.2 | 8.8 |  |  |  | 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 ($) | 18538M | 93317M | 310262M | 631373M | 422881M | 594035M | 2070406M
Total Assets ($) | 4667M | 23479M | 141132M | 251242M | 432878M | 724772M | 1578170M