Spreadsheet: 54885d1254933118-select-from-list-and-it-pulls-data-from-corresponding-sheet-listandworksheet
Sheet: SW Publish Assets

511210 SW Publish
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 | 0 | 1 | 12 | 30 | 5 | 23 | 71
Reviewed | 0 | 1 | 13 | 3 |  |  | 17
Compiled | 1 | 6 | 7 | 1 |  | 2 | 17
Tax Returns | 5 | 7 | 2 | 1 |  |  | 15
Other | 8 | 10 | 20 | 20 | 15 | 24 | 97
 |  |  |  |  |  |  | 47 (4/1-9/30/07) 170 (10/1-3/31/08)
Number of Statements | 14 | 25 | 54 | 55 | 20 | 49 | 217
ASSETS
Cash & Equivalents | 37.8 | 11.6 | 24.2 | 29.0 | 24.5 | 24.4 | 24.9
Trade Receivables - (net) | 28.5 | 46.8 | 34.2 | 27.7 | 26.0 | 15.5 | 28.7
Inventory | .8 | 3.1 | 3.1 | 1.0 | 1.9 | .9 | 1.8
All Other Current Assets | 2.5 | 1.3 | 4.3 | 4.5 | 4.7 | 6.0 | 4.3
Total Current Assets | 69.6 | 62.7 | 65.7 | 62.2 | 57.1 | 46.8 | 59.7
Fixed Assets (net) | 16.8 | 16.4 | 11.9 | 8.0 | 9.8 | 6.0 | 10.2
Intangibles (net) | 10.2 | 7.7 | 12.8 | 23.6 | 29.4 | 40.2 | 22.5
All Other Non-Current Assets | 3.4 | 13.1 | 9.6 | 6.1 | 3.6 | 7.1 | 7.6
Total Assets | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0
LIABILITIES
Notes Payable-Short Term | 26.2 | 14.2 | 5.5 | 1.8 | 1.7 | .6 | 5.4
Cur. Mat.-L/T/D | 6.7 | 2.7 | 3.2 | 2.7 | 3.5 | 1.1 | 2.8
Trade Payables | 15.5 | 12.6 | 10.5 | 7.1 | 8.0 | 6.9 | 9.2
Income Taxes Payable | 1.9 | .2 | .9 | .6 | .2 | .5 | .7
All Other Current Liabilities | 16.8 | 17.3 | 28.0 | 28.0 | 28.0 | 23.3 | 25.0
Total Current Liabilities | 67.1 | 47.1 | 48.2 | 40.2 | 41.3 | 32.4 | 43.0
Long Term Debt | 40.9 | 11.9 | 9.1 | 12.6 | 33.6 | 18.7 | 16.8
Deferred Taxes | .0 | .0 | .2 | .5 | .5 | 1.5 | .6
All Other Non-Current Liabilities | 40.3 | 20.3 | 16.6 | 9.7 | 10.9 | 4.2 | 13.5
Net Worth | -48.3 | 20.7 | 25.9 | 37.1 | 13.7 | 43.2 | 26.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 | 94.3 | 95.1 | 93.5 | 93.5 | 94.6 | 94.6 | 94.1
Operating Profit | 5.7 | 4.9 | 6.5 | 6.5 | 5.4 | 5.4 | 5.9
All Other Expenses (net) | 2.4 | .2 | .7 | 1.6 | 7.9 | 2.6 | 2.1
Profit Before Taxes | 3.3 | 4.7 | 5.8 | 4.9 | -2.5 | 2.8 | 3.8
RATIOS
Current - upper | 2.6 | 2.1 | 4.0 | 3.1 | 1.7 | 2.1 | 2.2
Current - median | 1.3 | 1.4 | 1.6 | 1.5 | 1.2 | 1.4 | 1.4
Current - lower | .5 | .9 | .8 | .9 | 1.0 | .8 | .9
Quick - upper | 2.6 | 2.1 | 3.3 | 3.0 | 1.6 | 1.8 | 2.1
Quick - median | 1.2 | 1.2 | 1.4 | 1.3 | 1.1 | 1.2 | 1.2
Quick - lower | .5 | .8 | .7 | .8 | .9 | .6 | .7
Sales / Receivables - upper | [0]  UND | [32]  11.3 | [37]  9.8 | [46]  7.9 | [70]  5.2 | [53]  6.9 | [41]  9.0
Sales / Receivables - median | [15]  24.9 | [48]  7.6 | [62]  5.9 | [68]  5.4 | [82]  4.5 | [73]  5.0 | [68]  5.4
Sales / Receivables - lower | [44]  8.3 | [76]  4.8 | [90]  4.1 | [97]  3.8 | [112]  3.3 | [88]  4.1 | [90]  4.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 | 8.9 | 7.7 | 4.0 | 2.4 | 3.8 | 2.6 | 3.4
Sales / Working Capital - median | 54.0 | 28.7 | 8.7 | 6.8 | 8.3 | 5.0 | 9.3
Sales / Working Capital - lower | -11.6 | -71.0 | -14.1 | -20.0 | NM | -13.6 | -19.7
EBIT / Interest - upper |  | 14.5 | 35.2 | 15.6 | 4.1 | 15.8 | 13.5
EBIT / Interest - median |  | (21)  6.2 | (40)  6.4 | (33)  7.9 | (17)  -.3 | (34)  1.3 | (153)  3.2
EBIT / Interest - lower |  | 2.1 | -.6 | -.4 | -1.9 | -1.0 | -.9
Net Profit + DDA / Curr Mat LTD - upper |  |  | 23.5 | 8.3 |  |  | 10.1
Net Profit + DDA / Curr Mat LTD - median |  |  | (11)  5.3 | (11)  4.3 |  |  | (37)  4.3
Net Profit + DDA / Curr Mat LTD - lower |  |  | 1.2 | .8 |  |  | 1.0
Fixed / Worth - upper | .0 | .1 | .1 | .1 | .4 | .1 | .1
Fixed / Worth - median | .6 | .5 | .8 | .4 | -2.2 | .4 | .6
Fixed / Worth - lower | -1.9 | NM | -.3 | -.8 | -.1 | -.1 | -.4
Debt / Worth - upper | .7 | 1.1 | .8 | .9 | 1.4 | 1.0 | .9
Debt / Worth - median | NM | 2.3 | 4.1 | 3.9 | -7.8 | 5.1 | 4.6
Debt / Worth - lower | -3.6 | NM | -5.0 | -5.2 | -1.8 | -1.9 | -3.9
% Profit before Taxes / Tangible Net Worth - upper |  | 65.9 | 49.5 | 94.5 |  | 36.8 | 56.7
% Profit before Taxes / Tangible Net Worth - median |  | (19)  50.8 | (34)  28.4 | (38)  34.9 |  | (29)  3.7 | (135)  26.5
% Profit before Taxes / Tangible Net Worth - lower |  | 21.9 | 20.4 | -6.6 |  | -15.2 | -1.1
% Profit before Taxes / Total Assets - upper | 50.9 | 27.3 | 22.2 | 19.8 | 6.4 | 8.8 | 19.2
% Profit before Taxes / Total Assets - median | 7.8 | 15.1 | 9.4 | 7.7 | -3.6 | 1.4 | 6.2
% Profit before Taxes / Total Assets - lower | -12.0 | 3.2 | -.3 | -4.1 | -7.1 | -3.8 | -3.8
Sales / Net Fixed Assets - upper | 227.3 | 101.4 | 57.8 | 47.5 | 35.1 | 28.6 | 47.5
Sales / Net Fixed Assets - median | 85.6 | 38.1 | 27.5 | 21.5 | 16.4 | 16.8 | 21.2
Sales / Net Fixed Assets - lower | 20.6 | 16.7 | 12.3 | 12.4 | 7.0 | 10.3 | 12.3
Sales / Total Assets - upper | 10.6 | 4.6 | 2.7 | 1.8 | 1.2 | .9 | 2.3
Sales / Total Assets - median | 5.0 | 4.0 | 1.9 | 1.3 | 1.0 | .7 | 1.4
Sales / Total Assets - lower | 2.0 | 2.1 | 1.2 | .8 | .6 | .5 | .8
% Depr, Depl, Amort / Sales - upper |  | .4 | 1.2 | .9 | .5 | 2.0 | .8
% Depr, Depl, Amort / Sales - median |  | (19)  .5 | (34)  2.4 | (34)  1.4 | (10)  3.3 | (21)  3.5 | (124)  2.1
% Depr, Depl, Amort / Sales - lower |  | 4.2 | 4.1 | 4.0 | 11.7 | 5.8 | 4.4
% Officers', Directors', Owners' Comp / Sales - upper |  |  |  |  |  |  | 5.5
% Officers', Directors', Owners' Comp / Sales - median |  |  |  |  |  |  | (30)  9.7
% Officers', Directors', Owners' Comp / Sales - lower |  |  |  |  |  |  | 18.9
Net Sales ($) | 21751M | 101390M | 526218M | 1963092M | 1421247M | 5907033M | 9940731M
Total Assets ($) | 3555M | 30530M | 263287M | 1414042M | 1453630M | 7763300M | 10928344M