Spreadsheet: 54885d1254933118-select-from-list-and-it-pulls-data-from-corresponding-sheet-listandworksheet
Sheet: Cable & Subs Sales

515210 - Cable and Other Subscription Programming
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 |  | 3 | 2 | 2 | 6 | 12 | 25
Reviewed |  | 3 | 2 | 2 | 2 | 2 | 11
Compiled |  |  |  | 1 | 2 | 1 | 4
Tax Returns | 1 | 3 |  | 1 |  |  | 5
Other | 2 | 3 | 5 | 1 | 2 | 6 | 19
 |  |  |  |  |  |  | 12 (4/1-9/30/07) 52 (10/1-3/31/08)
Number of Statements | 3 | 12 | 9 | 7 | 12 | 21 | 64
ASSETS
Cash & Equivalents |  | 13.4 |  |  | 8.5 | 12.6 | 14.0
Trade Receivables - (net) |  | 10.8 |  |  | 17.3 | 11.3 | 13.5
Inventory |  | .3 |  |  | 8.0 | 1.7 | 2.7
All Other Current Assets |  | 5.2 |  |  | 3.1 | 5.1 | 4.0
Total Current Assets |  | 29.7 |  |  | 37.0 | 30.7 | 34.1
Fixed Assets (net) |  | 47.0 |  |  | 37.8 | 36.0 | 41.5
Intangibles (net) |  | 22.8 |  |  | 16.5 | 30.3 | 19.3
All Other Non-Current Assets |  | .5 |  |  | 8.8 | 2.9 | 5.1
Total Assets |  | 100.0 |  |  | 100.0 | 100.0 | 100.0
LIABILITIES
Notes Payable-Short Term |  | 3.2 |  |  | 7.4 | 1.1 | 4.6
Cur. Mat.-L/T/D |  | 10.3 |  |  | 3.0 | 4.7 | 5.2
Trade Payables |  | 4.0 |  |  | 10.7 | 13.9 | 11.6
Income Taxes Payable |  | .0 |  |  | 1.1 | .1 | .3
All Other Current Liabilities |  | 8.0 |  |  | 11.5 | 7.4 | 10.7
Total Current Liabilities |  | 25.6 |  |  | 33.7 | 27.2 | 32.4
Long Term Debt |  | 83.0 |  |  | 23.9 | 37.3 | 38.8
Deferred Taxes |  | .4 |  |  | .8 | 2.2 | .9
All Other Non-Current Liabilities |  | 4.0 |  |  | 9.2 | 5.9 | 7.2
Net Worth |  | -13.0 |  |  | 32.5 | 27.5 | 20.6
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 |  | 101.4 |  |  | 93.1 | 91.9 | 92.9
Operating Profit |  | -1.4 |  |  | 6.9 | 8.1 | 7.1
All Other Expenses (net) |  | 3.8 |  |  | 1.5 | 6.7 | 4.7
Profit Before Taxes |  | -5.2 |  |  | 5.3 | 1.4 | 2.4
RATIOS
Current - upper |  | 10.2 |  |  | 1.4 | 1.4 | 1.8
Current - median |  | 1.1 |  |  | 1.0 | .8 | .9
Current - lower |  | .4 |  |  | .7 | .5 | .5
Quick - upper |  | 9.7 |  |  | 1.0 | .9 | 1.4
Quick - median |  | .9 |  |  | .8 | .6 | .7
Quick - lower |  | .4 |  |  | .5 | .4 | .4
Sales / Receivables - upper |  | [2]  184.5 |  |  | [6]  57.2 | [12]  30.7 | [6]  58.6
Sales / Receivables - median |  | [8]  43.2 |  |  | [18]  20.3 | [26]  14.1 | [20]  18.3
Sales / Receivables - lower |  | [75]  4.9 |  |  | [38]  9.5 | [44]  8.2 | [46]  7.9
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 |  | 5.9 |  |  | 15.8 | 74.5 | 12.2
Sales / Working Capital - median |  | NM |  |  | -264.7 | -23.9 | -51.2
Sales / Working Capital - lower |  | -10.6 |  |  | -21.7 | -9.4 | -9.8
EBIT / Interest - upper |  | 7.5 |  |  | 3.9 | 4.4 | 6.6
EBIT / Interest - median |  | (10)  2.5 |  |  | (10)  1.9 | (20)  1.6 | (55)  2.5
EBIT / Interest - lower |  | .5 |  |  | 1.4 | .3 | .9
Net Profit + DDA / Curr Mat LTD - upper
Net Profit + DDA / Curr Mat LTD - median
Net Profit + DDA / Curr Mat LTD - lower
Fixed / Worth - upper |  | .6 |  |  | .4 | .7 | .6
Fixed / Worth - median |  | 2.7 |  |  | 1.4 | -4.1 | 2.7
Fixed / Worth - lower |  | -1.0 |  |  | -4.4 | -.8 | -2.4
Debt / Worth - upper |  | .4 |  |  | 1.1 | 3.5 | 1.0
Debt / Worth - median |  | 2.8 |  |  | 2.6 | -11.5 | 3.6
Debt / Worth - lower |  | -2.6 |  |  | -5.7 | -2.0 | -5.1
% Profit before Taxes / Tangible Net Worth - upper |  |  |  |  |  | 49.0 | 35.8
% Profit before Taxes / Tangible Net Worth - median |  |  |  |  |  | (10)  28.6 | (40)  23.1
% Profit before Taxes / Tangible Net Worth - lower |  |  |  |  |  | 5.9 | 7.8
% Profit before Taxes / Total Assets - upper |  | 20.1 |  |  | 14.0 | 6.6 | 13.5
% Profit before Taxes / Total Assets - median |  | -.7 |  |  | 3.5 | 1.8 | 4.1
% Profit before Taxes / Total Assets - lower |  | -13.2 |  |  | 1.5 | -4.1 | -2.0
Sales / Net Fixed Assets - upper |  | 9.5 |  |  | 44.7 | 7.5 | 16.0
Sales / Net Fixed Assets - median |  | 2.7 |  |  | 7.5 | 1.8 | 2.5
Sales / Net Fixed Assets - lower |  | 1.1 |  |  | 1.3 | 1.3 | 1.2
Sales / Total Assets - upper |  | 3.0 |  |  | 4.2 | 1.9 | 3.3
Sales / Total Assets - median |  | 1.1 |  |  | 2.4 | .8 | 1.1
Sales / Total Assets - lower |  | .6 |  |  | .5 | .4 | .6
% Depr, Depl, Amort / Sales - upper |  | 4.6 |  |  | .7 | 1.5 | 2.0
% Depr, Depl, Amort / Sales - median |  | (11)  16.2 |  |  | 4.2 | (11)  7.1 | (48)  7.0
% Depr, Depl, Amort / Sales - lower |  | 21.8 |  |  | 17.4 | 14.8 | 16.1
% Officers', Directors', Owners' Comp / Sales - upper |  |  |  |  |  |  | 1.8
% Officers', Directors', Owners' Comp / Sales - median |  |  |  |  |  |  | (15)  2.8
% Officers', Directors', Owners' Comp / Sales - lower |  |  |  |  |  |  | 9.3
Net Sales ($) | 2024M | 20947M | 36629M | 48748M | 207976M | 1896012M | 2212336M
Total Assets ($) | 3706M | 41159M | 44590M | 46668M | 201143M | 2134127M | 2471393M