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

515210 - Cable and Other Subscription Programming
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 |  |  | 8 | 6 | 2 | 9 | 25
Reviewed | 1 | 1 | 8 | 1 |  |  | 11
Compiled |  | 1 | 2 | 1 |  |  | 4
Tax Returns | 2 | 3 |  |  |  |  | 5
Other | 1 | 5 | 4 | 5 | 3 | 1 | 19
 |  |  |  |  |  |  | 12 (4/1-9/30/07) 52 (10/1-3/31/08)
Number of Statements | 4 | 10 | 22 | 13 | 5 | 10 | 64
ASSETS
Cash & Equivalents |  | 12.2 | 13.7 | 11.2 |  | 8.0 | 14.0
Trade Receivables - (net) |  | 25.3 | 18.9 | 5.8 |  | 7.4 | 13.5
Inventory |  | 3.7 | 4.5 | 1.8 |  | 1.5 | 2.7
All Other Current Assets |  | 8.0 | 1.4 | 7.0 |  | 2.6 | 4.0
Total Current Assets |  | 49.2 | 38.5 | 25.7 |  | 19.5 | 34.1
Fixed Assets (net) |  | 46.5 | 41.6 | 37.8 |  | 39.7 | 41.5
Intangibles (net) |  | 4.0 | 16.0 | 22.3 |  | 37.8 | 19.3
All Other Non-Current Assets |  | .2 | 3.9 | 14.3 |  | 3.0 | 5.1
Total Assets |  | 100.0 | 100.0 | 100.0 |  | 100.0 | 100.0
LIABILITIES
Notes Payable-Short Term |  | 8.4 | 6.2 | 1.7 |  | .3 | 4.6
Cur. Mat.-L/T/D |  | 2.8 | 5.4 | 1.3 |  | 5.9 | 5.2
Trade Payables |  | 17.3 | 12.2 | 14.2 |  | 7.4 | 11.6
Income Taxes Payable |  | .1 | .6 | .0 |  | .0 | .3
All Other Current Liabilities |  | 4.0 | 12.3 | 9.9 |  | 4.5 | 10.7
Total Current Liabilities |  | 32.6 | 36.8 | 27.1 |  | 18.1 | 32.4
Long Term Debt |  | 31.4 | 23.0 | 28.0 |  | 42.5 | 38.8
Deferred Taxes |  | .0 | .7 | .6 |  | 2.4 | .9
All Other Non-Current Liabilities |  | 8.4 | 2.4 | 15.4 |  | 4.7 | 7.2
Net Worth |  | 27.6 | 37.2 | 28.9 |  | 32.3 | 20.6
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 |  | 92.0 | 96.3 | 91.6 |  | 94.1 | 92.9
Operating Profit |  | 8.0 | 3.7 | 8.4 |  | 5.9 | 7.1
All Other Expenses (net) |  | 2.2 | 2.0 | 4.9 |  | 8.2 | 4.7
Profit Before Taxes |  | 5.8 | 1.7 | 3.5 |  | -2.3 | 2.4
RATIOS
Current - upper |  | 6.4 | 1.5 | 2.5 |  | 1.2 | 1.8
Current - median |  | 1.8 | .9 | .8 |  | .7 | .9
Current - lower |  | .9 | .6 | .2 |  | .6 | .5
Quick - upper |  | 6.4 | 1.5 | .9 |  | 1.1 | 1.4
Quick - median |  | 1.1 | .8 | .6 |  | .6 | .7
Quick - lower |  | .7 | .5 | .1 |  | .4 | .4
Sales / Receivables - upper |  | [5]  77.5 | [6]  58.0 | [4]  92.6 |  | [20]  18.0 | [6]  58.6
Sales / Receivables - median |  | [16]  23.3 | [21]  17.6 | [18]  19.9 |  | [34]  10.8 | [20]  18.3
Sales / Receivables - lower |  | [72]  5.1 | [39]  9.5 | [43]  8.4 |  | [47]  7.7 | [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 |  | 6.2 | 13.5 | 9.6 |  | NM | 12.2
Sales / Working Capital - median |  | 24.7 | -93.5 | -27.4 |  | -12.2 | -51.2
Sales / Working Capital - lower |  | -343.7 | -10.5 | -3.9 |  | -9.6 | -9.8
EBIT / Interest - upper |  |  | 6.4 | 4.9 |  | 2.6 | 6.6
EBIT / Interest - median |  |  | (17)  2.0 | (11)  2.5 |  | 1.4 | (55)  2.5
EBIT / Interest - lower |  |  | 1.2 | 1.2 |  | -.4 | .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 |  | .5 | .6 | .6 |  | 4.3 | .6
Fixed / Worth - median |  | 1.0 | 2.1 | 155.6 |  | -3.1 | 2.7
Fixed / Worth - lower |  | NM | NM | -1.6 |  | -.9 | -2.4
Debt / Worth - upper |  | .7 | 1.2 | .4 |  | 3.9 | 1.0
Debt / Worth - median |  | 1.2 | 2.6 | 318.5 |  | -8.7 | 3.6
Debt / Worth - lower |  | NM | NM | -2.9 |  | -2.1 | -5.1
% Profit before Taxes / Tangible Net Worth - upper |  |  | 32.4 |  |  |  | 35.8
% Profit before Taxes / Tangible Net Worth - median |  |  | (17)  20.0 |  |  |  | (40)  23.1
% Profit before Taxes / Tangible Net Worth - lower |  |  | 4.8 |  |  |  | 7.8
% Profit before Taxes / Total Assets - upper |  | 29.4 | 14.0 | 13.8 |  | 4.5 | 13.5
% Profit before Taxes / Total Assets - median |  | 13.6 | 3.4 | 6.0 |  | 1.7 | 4.1
% Profit before Taxes / Total Assets - lower |  | 5.7 | .3 | -2.2 |  | -8.8 | -2.0
Sales / Net Fixed Assets - upper |  | 13.7 | 23.5 | 51.6 |  | 2.7 | 16.0
Sales / Net Fixed Assets - median |  | 5.7 | 6.0 | 1.5 |  | 1.4 | 2.5
Sales / Net Fixed Assets - lower |  | 2.7 | 1.1 | .6 |  | 1.0 | 1.2
Sales / Total Assets - upper |  | 4.5 | 3.6 | 1.7 |  | .9 | 3.3
Sales / Total Assets - median |  | 2.5 | 1.3 | .6 |  | .4 | 1.1
Sales / Total Assets - lower |  | 1.5 | .6 | .3 |  | .3 | .6
% Depr, Depl, Amort / Sales - upper |  |  | .7 | 2.9 |  |  | 2.0
% Depr, Depl, Amort / Sales - median |  |  | (20)  2.5 | (12)  11.7 |  |  | (48)  7.0
% Depr, Depl, Amort / Sales - lower |  |  | 15.3 | 23.1 |  |  | 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 ($) | 4795M | 32859M | 241605M | 410597M | 366099M | 1156381M | 2212336M
Total Assets ($) | 937M | 11880M | 104950M | 340825M | 421986M | 1590815M | 2471393M