Visit http://www.oldschoolvalue.com for more investment spreadsheets and idea screen results Ticker 1
CHCG
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 $ $ $ $ $ $ $ $ $ $ $ $
25.40 24.50 24.50 9.40 9.40 4.80 #VALUE!
Ticker 2
User Input
BV Multiplier 100%
Net Net Value $
25.40
$
18.38
75%
50%
$ $
4.70 4.80 53.93
53.93
Total Per Share Net Net Working Capital $ 43.68 $ 0.81 #VALUE! $ 0.57 Current Market Cap/Share 30% Discount to Liquidation Price
FMTI
Ticker 3
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 $ $ $ $ $ $ $ $ $ $ $ $
1.00 0.80 0.80 1.50 3.10 3.90 1.40 #VALUE!
BV Multiplier 100%
Net Net Value $
1.00
$
0.60
75%
50%
$ $
1.95 1.40 4.97
4.97
ELST
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
BV $ $ $ $ $ $ $ $ $ $ $ $
0.90 1.30 0.20 0.20 0.10 0.20 0.30 0.60 0.10 #VALUE!
BV Multiplier 100%
Net Net Value $
2.20
$
0.15
75%
50%
$ $
0.30 0.10 5.16
5.16
Ticker 7
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
RCMT 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 $ $ $ $ $ $ $ $ $ $ $ $
BV Multiplier
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
100%
Net Net Value $
9.60
$
35.85
75%
50%
$ $
68.70
$
3.30
$ $
2.50 4.30 9.59
Total 70.20 $ 28.40 $
Per Share 7.32 2.96 60%
100%
75%
50%
User Input
BV Multiplier
7.30 5.10 5.10 2.60 0.10 1.80 4.50 3.60 8.87
Net Net Value $
7.30
$
3.83
$ $
2.25 3.60 8.87
Total 9.78 $ 28.85 $
Per Share 1.10 3.25 0%
100%
75%
50%
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
QXM
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
431.50 70.70 0.10 70.80 24.80 24.80 216.90 47.61
Net Net Value $
431.50
$
53.10
$ $
12.40 216.90 47.61
Total 280.10 $ 139.50 $
Per Share 5.88 2.93 50%
100%
75%
50%
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
TAIT
Ticker 8
User Input
Net Net Value $
Numbers from 2009/06 (go to SEC for accurate numbers) (Numbers From ADVFN)
(go to SEC for accurate numbers)
9.60 47.80 47.80 15.80 12.86
BV Multiplier
DRAM
Ticker 6
User Input
User Input
49.20 19.50 4.40 4.40 4.40 0.50 0.10 5.00 4.30 9.59
Numbers from 2009/03 (go to SEC for accurate numbers) (Numbers From ADVFN)
(go to SEC for accurate numbers)
Total Per Share Net Net Working Capital $ 2.55 $ 0.49 Current Market Cap/Share #VALUE! $ 0.33 Discount to Liquidation Price 33%
Numbers from 2009/06 (Numbers From ADVFN)
BV $ $ $ $ $ $ $ $ $ $ $ $
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
Ticker 4
Total Per Share Net Net Working Capital $ 2.15 $ 0.43 #VALUE! $ 0.34 Current Market Cap/Share 21% Discount to Liquidation Price
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
Numbers from 2009/07 (go to SEC for accurate numbers) (Numbers From ADVFN)
(go to SEC for accurate numbers)
User Input
ENWV
Numbers from 2009/06 (go to SEC for accurate numbers) (Numbers From ADVFN)
(go to SEC for accurate numbers)
15.80 12.86
Total Per Share 29.65 $ 2.31 28.42 $ 2.21 4%
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.80 0.90 0.90 12.90 12.90 2.10 5.54
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
Net Net Value $
1.80
$
0.68
$ $
6.45 2.10 5.54
Total 6.83 $ 6.65 $
Per Share 1.23 1.20 3%
100%
75%
50%
TSRI
Ticker 9
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
BV $ $ $ $ $ $ $ $ $ $ $ $
User Input
BV Multiplier
4.10 4.50 6.40 6.40 3.00 4.05
100%
Net Net Value $
8.60
$
4.80
75%
50%
$ $
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
3.00 4.05
Total Per Share 10.40 $ 2.57 8.30 $ 2.05 20%
Ticker 11
BV
(go to SEC for accurate numbers)
User Input
Error Error Error Error Error Error Error Error Error Error Error Error #VALUE!
BV Multiplier 100%
Net Net Value #VALUE!
75%
#VALUE!
50%
#VALUE! Error #VALUE!
Net Net Working Capital Current Market Cap/Share Discount to Liquidation Price
Total Per Share #VALUE! #VALUE! #VALUE! Error #VALUE!
Ticker 13
BV
(go to SEC for accurate numbers)
User Input
Error Error Error Error Error Error Error Error Error Error Error Error #VALUE!
BV Multiplier 100%
Net Net Value #VALUE!
75%
#VALUE!
50%
#VALUE! Error #VALUE!
Net Net Working Capital Current Market Cap/Share Discount to Liquidation Price
Total Per Share #VALUE! #VALUE! #VALUE! Error #VALUE!
Ticker 15
$ $ $ $ $ $ $ $ $ $ $ $
User Input
BV Multiplier
42.10 5.50 2.00 1.20 3.20 2.60 16.39
Net Net Value $
47.60
$
2.40
$ $
2.60 16.39
Total 47.40 $ 39.50 $
Per Share 2.89 2.41 17%
100%
75%
50%
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
Numbers from Error (go to SEC for accurate numbers) (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
Error Error Error Error Error Error Error Error Error Error Error Error #VALUE!
BV Multiplier 100%
Net Net Value #VALUE!
75%
#VALUE!
50%
#VALUE! Error #VALUE!
Net Net Working Capital Current Market Cap/Share Discount to Liquidation Price
Total Per Share #VALUE! #VALUE! #VALUE! Error #VALUE!
Numbers from Error (go to SEC for accurate numbers) (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
Error Error Error Error Error Error Error Error Error Error Error Error #VALUE!
BV Multiplier 100%
Net Net Value #VALUE!
75%
#VALUE!
50%
#VALUE! Error #VALUE!
Net Net Working Capital Current Market Cap/Share Discount to Liquidation Price
Total Per Share #VALUE! #VALUE! #VALUE! Error #VALUE!
Ticker 16
Numbers from Error (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 14
Numbers from Error (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
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
Ticker 12
Numbers from Error (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
PRLS
Ticker 10
Numbers from 2009/07 (go to SEC for accurate numbers) (Numbers From ADVFN)
(go to SEC for accurate numbers)
BV
(go to SEC for accurate numbers)
User Input
Error Error Error Error Error Error Error Error Error Error Error Error #VALUE!
Net Net Working Capital Current Market Cap/Share Discount to Liquidation Price
BV Multiplier 100%
Net Net Value #VALUE!
75%
#VALUE!
50%
#VALUE! Error #VALUE! Total Per Share #VALUE! #VALUE! #VALUE! Error #VALUE!
Numbers from Error (go to SEC for accurate numbers) (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
Error Error Error Error Error Error Error Error Error Error Error Error #VALUE!
Net Net Working Capital Current Market Cap/Share Discount to Liquidation Price
BV Multiplier 100%
Net Net Value #VALUE!
75%
#VALUE!
50%
#VALUE! Error #VALUE! Total Per Share #VALUE! #VALUE! #VALUE! Error #VALUE!