Visit http://www.oldschoolvalue.com for more investment spreadsheets and idea screen results CRC
Ticker 1
Numbers from 2009/06 (Numbers From ADVFN) Figures in Millions except per share values Cash & Equivalents Marketable Securities Accounts Receivable Other Receivable Receivables Inventories: Raw Materials Inventories: Work in Progress Inventories: Purchased Components Inventories: Finished Goods Inventories: Other Inventories -- Total Total Liabilities Shares Outstanding
BV $ $ $ $ $ $ $ $ $ $ $ $
User Input
BV Multiplier
3.10 8.30 8.30 4.40 0.60 10.20 15.20 9.70 6.13
100%
Ticker 3
Figures in Millions except per share values Cash & Equivalents Marketable Securities Accounts Receivable Other Receivable Receivables Inventories: Raw Materials Inventories: Work in Progress Inventories: Purchased Components Inventories: Finished Goods Inventories: Other Inventories -- Total Total Liabilities Shares Outstanding
BV $ $ $ $ $ $ $ $ $ $ $ $
6.23
$ $
7.60 9.70 6.13
Total Per Share 7.23 $ 1.18 9.69 $ 1.58 0%
User Input
BV Multiplier 100%
Net Net Value $
382.70
$
8.10
75%
50%
$ $
1.80 35.40 119.98
Total Per Share 357.20 $ 2.98 375.54 $ 3.13 0%
BV Multiplier 100%
Net Net Value $
43.90
$
69.30
75%
50%
$ $
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
40.60 130.10 17.91
Total Per Share 23.70 $ 1.32 89.18 $ 4.98 0%
ANDS
Numbers from 2009/06 (Numbers From ADVFN)
BV $ $ $ $ $ $ $ $ $ $ $ $
Figures in Millions except per share values Cash & Equivalents Marketable Securities Accounts Receivable Other Receivable Receivables Inventories: Raw Materials Inventories: Work in Progress Inventories: Purchased Components Inventories: Finished Goods Inventories: Other Inventories -- Total Total Liabilities Shares Outstanding
Figures in Millions except per share values Cash & Equivalents Marketable Securities Accounts Receivable Other Receivable Receivables Inventories: Raw Materials Inventories: Work in Progress Inventories: Purchased Components Inventories: Finished Goods Inventories: Other Inventories -- Total Total Liabilities Shares Outstanding
BV Multiplier
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
100%
Net Net Value $
30.60
$
-
75%
50%
$ $
142.90
$
-
$ $
110.70 155.50 54.56
Total 98.10 $ 533.05 $
Per Share 1.80 9.77 0%
100%
75%
50%
VOXX BV $ $ $ $ $ $ $ $ $ $ $ $
User Input
BV Multiplier
62.30 108.10 23.80 131.90 118.80 118.80 118.30 22.87
Net Net Value $
62.30
$
98.93
$ $
59.40 118.30 22.87
Total 102.33 $ 142.68 $
Per Share 4.47 6.24 0%
100%
75%
50%
MNOV BV $ $ $ $ $ $ $ $ $ $ $ $
User Input
BV Multiplier
28.70 21.30 20.10 12.05
Net Net Value $
50.00
$
-
$ $
20.10 12.05
Total 29.90 $ 73.01 $
Per Share 2.48 6.06 0%
100%
75%
50%
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
Ticker 8
User Input
Net Net Value $
NUHC
Numbers from 2009/05 (go to SEC for accurate numbers) (Numbers From ADVFN)
(go to SEC for accurate numbers)
18.00 12.60 8.80 37.31
BV Multiplier
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
Ticker 6
User Input
User Input
142.90 221.40 221.40 155.50 54.56
Numbers from 2009/06 (go to SEC for accurate numbers) (Numbers From ADVFN)
(go to SEC for accurate numbers)
43.90 92.40 92.40 81.20 81.20 130.10 17.91
BV $ $ $ $ $ $ $ $ $ $ $ $
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
Ticker 4
101.80 280.90 10.80 10.80 0.20 3.40 3.60 35.40 119.98
BV $ $ $ $ $ $ $ $ $ $ $ $
Figures in Millions except per share values Cash & Equivalents Marketable Securities Accounts Receivable Other Receivable Receivables Inventories: Raw Materials Inventories: Work in Progress Inventories: Purchased Components Inventories: Finished Goods Inventories: Other Inventories -- Total Total Liabilities Shares Outstanding
Numbers from 2009/05 (go to SEC for accurate numbers) (Numbers From ADVFN)
(go to SEC for accurate numbers)
RELL
Ticker 5
Figures in Millions except per share values Cash & Equivalents Marketable Securities Accounts Receivable Other Receivable Receivables Inventories: Raw Materials Inventories: Work in Progress Inventories: Purchased Components Inventories: Finished Goods Inventories: Other Inventories -- Total Total Liabilities Shares Outstanding
$
ADPT
Numbers from 2009/05 (Numbers From ADVFN)
Ticker 7
3.10
50%
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
Figures in Millions except per share values Cash & Equivalents Marketable Securities Accounts Receivable Other Receivable Receivables Inventories: Raw Materials Inventories: Work in Progress Inventories: Purchased Components Inventories: Finished Goods Inventories: Other Inventories -- Total Total Liabilities Shares Outstanding
Net Net Value $
75%
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
Numbers from 2009/06 (Numbers From ADVFN)
FINL
Ticker 2
Numbers from 2009/08 (go to SEC for accurate numbers) (Numbers From ADVFN)
(go to SEC for accurate numbers)
8.80 37.31
Total Per Share 21.80 $ 0.58 93.65 $ 2.51 0%
Figures in Millions except per share values Cash & Equivalents Marketable Securities Accounts Receivable Other Receivable Receivables Inventories: Raw Materials Inventories: Work in Progress Inventories: Purchased Components Inventories: Finished Goods Inventories: Other Inventories -- Total Total Liabilities Shares Outstanding
BV $ $ $ $ $ $ $ $ $ $ $ $
User Input
BV Multiplier
6.10 111.60 111.60 95.50 95.50 97.40 18.53
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
Net Net Value $
6.10
$
83.70
$ $
47.75 97.40 18.53
Total 40.15 $ 72.27 $
Per Share 2.17 3.90 0%
100%
75%
50%
Ticker 9
PMRY
Numbers from 2009/06 (Numbers From ADVFN) Figures in Millions except per share values Cash & Equivalents Marketable Securities Accounts Receivable Other Receivable Receivables Inventories: Raw Materials Inventories: Work in Progress Inventories: Purchased Components Inventories: Finished Goods Inventories: Other Inventories -- Total Total Liabilities Shares Outstanding
BV $ $ $ $ $ $ $ $ $ $ $ $
User Input
BV Multiplier
38.10 1.20 69.90 0.40 70.30 8.80 8.80 62.70 9.32
100%
BV $ $ $ $ $ $ $ $ $ $ $ $
$
52.73
$ $
4.40 62.70 9.32
Total Per Share 33.73 $ 3.62 59.94 $ 6.43 0%
BV $ $ $ $ $ $ $ $ $ $ $ $
User Input
BV Multiplier 100%
Net Net Value $
2.10
$
19.95
75%
50%
$ $
38.85 35.20 20.32
Total Per Share 25.70 $ 1.26 45.12 $ 2.22 0%
User Input
BV Multiplier 100%
Net Net Value $
5.30
$
9.98
75%
50%
$ $
11.35 16.20 31.16
Total Per Share 10.43 $ 0.33 32.41 $ 1.04 0%
LDIS BV $ $ $ $ $ $ $ $ $ $ $ $
Figures in Millions except per share values Cash & Equivalents Marketable Securities Accounts Receivable Other Receivable Receivables Inventories: Raw Materials Inventories: Work in Progress Inventories: Purchased Components Inventories: Finished Goods Inventories: Other Inventories -- Total Total Liabilities Shares Outstanding
BV Multiplier
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
100%
Net Net Value $
28.70
$
4.65
75%
50%
$ $
$
38.30
$
2.63
$ $
5.05 5.80 26.2
Total 40.18 $ 51.35 $
Per Share 1.53 1.96 0%
100%
75%
50%
MSN BV $ $ $ $ $ $ $ $ $ $ $ $
User Input
BV Multiplier
23.60 26.70 1.50 28.10 22.10 17.90 34.30 27.13
Net Net Value $
23.60
$
21.08
$ $
8.95 34.30 27.13
Total 19.33 $ 33.91 $
Per Share 0.71 1.25 0%
100%
75%
50%
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
Figures in Millions except per share values Cash & Equivalents Marketable Securities Accounts Receivable Other Receivable Receivables Inventories: Raw Materials Inventories: Work in Progress Inventories: Purchased Components Inventories: Finished Goods Inventories: Other Inventories -- Total Total Liabilities Shares Outstanding
TWMC BV $ $ $ $ $ $ $ $ $ $ $ $
User Input
BV Multiplier
7.10 320.40 320.40 197.20 31.4
Net Net Value $
7.10
$
-
$ $
160.20 197.20 31.4
Total (29.90) $ 30.45 $
Per Share (0.95) 0.97 0%
100%
75%
50%
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
Ticker 16
User Input
38.30 3.50 3.50 0.20 9.90 10.10 5.80 26.2
Net Net Value
TBAC
Numbers from 2009/06 (go to SEC for accurate numbers) (Numbers From ADVFN)
(go to SEC for accurate numbers)
25.10 3.60 2.50 3.60 6.20 0.10 0.10 0.20 4.20 30.06
BV Multiplier
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
Ticker 14
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
Ticker 15
$ $ $ $ $ $ $ $ $ $ $ $
User Input
Numbers from 2009/07 (go to SEC for accurate numbers) (Numbers From ADVFN)
(go to SEC for accurate numbers)
5.30 10.80 2.50 13.30 12.90 9.70 22.70 16.20 31.16
Numbers from 2009/06 (Numbers From ADVFN)
BV
Ticker 12
FSII
Ticker 13
Figures in Millions except per share values Cash & Equivalents Marketable Securities Accounts Receivable Other Receivable Receivables Inventories: Raw Materials Inventories: Work in Progress Inventories: Purchased Components Inventories: Finished Goods Inventories: Other Inventories -- Total Total Liabilities Shares Outstanding
Numbers from 2009/06 (go to SEC for accurate numbers) (Numbers From ADVFN)
(go to SEC for accurate numbers)
2.10 22.20 4.50 26.60 4.50 25.60 47.50 77.70 35.20 20.32
Numbers from 2009/05 (Numbers From ADVFN)
Figures in Millions except per share values Cash & Equivalents Marketable Securities Accounts Receivable Other Receivable Receivables Inventories: Raw Materials Inventories: Work in Progress Inventories: Purchased Components Inventories: Finished Goods Inventories: Other Inventories -- Total Total Liabilities Shares Outstanding
39.30
50%
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
Figures in Millions except per share values Cash & Equivalents Marketable Securities Accounts Receivable Other Receivable Receivables Inventories: Raw Materials Inventories: Work in Progress Inventories: Purchased Components Inventories: Finished Goods Inventories: Other Inventories -- Total Total Liabilities Shares Outstanding
$
PARL
Ticker 11
Figures in Millions except per share values Cash & Equivalents Marketable Securities Accounts Receivable Other Receivable Receivables Inventories: Raw Materials Inventories: Work in Progress Inventories: Purchased Components Inventories: Finished Goods Inventories: Other Inventories -- Total Total Liabilities Shares Outstanding
Net Net Value
75%
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
Numbers from 2009/06 (Numbers From ADVFN)
DITC
Ticker 10
Numbers from 2009/07 (go to SEC for accurate numbers) (Numbers From ADVFN)
(go to SEC for accurate numbers)
0.10 4.20 30.06
Total Per Share 29.25 $ 0.97 30.66 $ 1.02 0%
Figures in Millions except per share values Cash & Equivalents Marketable Securities Accounts Receivable Other Receivable Receivables Inventories: Raw Materials Inventories: Work in Progress Inventories: Purchased Components Inventories: Finished Goods Inventories: Other Inventories -- Total Total Liabilities Shares Outstanding
BV $ $ $ $ $ $ $ $ $ $ $ $
User Input
BV Multiplier
3.70 19.60 19.60 1.50 0.10 21.50 23.00 20.30 7.06
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
Net Net Value $
3.70
$
14.70
$ $
11.50 20.30 7.06
Total 9.60 $ 24.00 $
Per Share 1.36 3.40 0%
100%
75%
50%
CSII
Ticker 17
Numbers from 2008/12 (Numbers From ADVFN) Figures in Millions except per share values Cash & Equivalents Marketable Securities Accounts Receivable Other Receivable Receivables Inventories: Raw Materials Inventories: Work in Progress Inventories: Purchased Components Inventories: Finished Goods Inventories: Other Inventories -- Total Total Liabilities Shares Outstanding
BV $ $ $ $ $ $ $ $ $ $ $ $
Ticker 18
User Input
BV Multiplier
33.70 11.80 4.70 14.01
100%
$
45.50
$
-
75%
50%
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
4.70 14.01
Total Per Share 40.80 $ 2.91 93.00 $ 6.64 0%
HDL
Ticker 19
Numbers from 2008/01 (Numbers From ADVFN) Figures in Millions except per share values Cash & Equivalents Marketable Securities Accounts Receivable Other Receivable Receivables Inventories: Raw Materials Inventories: Work in Progress Inventories: Purchased Components Inventories: Finished Goods Inventories: Other Inventories -- Total Total Liabilities Shares Outstanding
Net Net Value
$ $
BV $ $ $ $ $ $ $ $ $ $ $ $
32.40 175.40 175.40 116.90 116.90 275.10 #VALUE!
CTHR
Numbers from 2009/06 (go to SEC for accurate numbers) (Numbers From ADVFN)
(go to SEC for accurate numbers)
Figures in Millions except per share values Cash & Equivalents Marketable Securities Accounts Receivable Other Receivable Receivables Inventories: Raw Materials Inventories: Work in Progress Inventories: Purchased Components Inventories: Finished Goods Inventories: Other Inventories -- Total Total Liabilities Shares Outstanding
BV $ $ $ $ $ $ $ $ $ $ $ $
100%
Net Net Value $
32.40
$
131.55
75%
50%
$ $ 20.52
7.00 0.40 0.40 6.80 1.90 33.40 0.90 3.50 4.20 18.93
Net Net Value $
7.00
$
0.30
$ $
1.75 4.20 18.93
Total 4.85 $ 9.27 $
Per Share 0.26 0.49 0%
100%
75%
50%
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
ICCC
Ticker 20
BV Multiplier
BV Multiplier
Numbers from 2009/06 (go to SEC for accurate numbers) (Numbers From ADVFN)
(go to SEC for accurate numbers)
User Input
User Input
58.45 275.10 20.52
Total Per Share Net Net Working Capital $ (52.70) $ (2.57) Current Market Cap/Share #VALUE! Error 0% Discount to Liquidation Price
Figures in Millions except per share values Cash & Equivalents Marketable Securities Accounts Receivable Other Receivable Receivables Inventories: Raw Materials Inventories: Work in Progress Inventories: Purchased Components Inventories: Finished Goods Inventories: Other Inventories -- Total Total Liabilities Shares Outstanding
BV $ $ $ $ $ $ $ $ $ $ $ $
User Input
BV Multiplier
1.10 3.70 0.50 0.40 0.90 0.70 0.70 0.40 2.97
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
Net Net Value $
4.80
$
0.68
$ $
0.35 0.40 2.97
Total 5.43 $ 9.62 $
Per Share 1.83 3.24 0%
100%
75%
50%