Visit http://www.oldschoolvalue.com for more investment spreadsheets and idea screen results ATV
Ticker 1
Numbers from 2008/10 (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
147.60 19.70 27.70 27.90 14.20 15.30 29.50 88.40 29.05
100%
BV $ $ $ $ $ $ $ $ $ $ $ $
$
20.93
$ $
14.75 88.40 29.05
Total Per Share 114.58 $ 3.94 101.69 $ 3.50 11%
$ $ $ $ $ $ $ $ $ $ $ $
BV $ $ $ $ $ $ $ $ $ $ $ $
User Input
BV Multiplier 100%
Net Net Value $
56.90
$
30.75
75%
50%
$ $
7.05 47.20 46.95
Total Per Share 47.50 $ 1.01 32.86 $ 0.70 31%
BV Multiplier
41.70 2.50 4.40 4.40 15.00 27.8
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
100%
45.40 220.55
$
3.90
BV Multiplier
Net Net Value $
265.95
$
2.93
$ $
4.35 16.90 77.99
Total 256.33 $ 154.41 $
Per Share 3.29 1.98 40%
100%
75%
50%
$ $
8.70 16.90
FTAR
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 $ $ $ $ $ $ $ $ $ $ $ $
56.60 56.80 56.80 24.40 #VALUE!
User Input
BV Multiplier
Net Net Value $
56.60
$
42.60
$ $
24.40 21.58
Total Net Net Working Capital $ 74.80 $ Current Market Cap/Share #VALUE! $ Discount to Liquidation Price
Per Share 3.47 1.05 70%
100%
75%
50%
21.58
HLYS
Numbers from 2008/12 (go to SEC for accurate numbers) (Numbers From ADVFN)
Net Net Value $
44.20
$
3.30
75%
50%
$ $
User Input $ $
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
Ticker 6 (go to SEC for accurate numbers)
User Input
77.99
Numbers from 2008/12 (go to SEC for accurate numbers) (Numbers From ADVFN)
GRVY 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
Ticker 4 (go to SEC for accurate numbers)
56.90 41.00 41.00 2.60 11.50 14.10 47.20 46.95
Numbers from 2008/10 (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
167.30
50%
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
Ticker 5
Net Net Value $
HILL
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
Numbers from 2008/12 (go to SEC for accurate numbers) (Numbers From ADVFN)
75%
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
Numbers from 2008/12 (Numbers From ADVFN)
ACTS
Ticker 2 (go to SEC for accurate numbers)
15.00 27.8
Total Per Share 32.50 $ 1.17 27.24 $ 0.98 16%
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
68.40 6.60 0.30 6.90 12.10 12.10 10.10 27.57
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
Net Net Value $
68.40
$
5.18
$ $
6.05 10.10 27.57
Total 69.53 $ 50.73 $
Per Share 2.52 1.84 27%
100%
75%
50%
Ticker 7
HRAY
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 $ $ $ $ $ $ $ $ $ $ $ $
65.90 16.40 0.30 16.70 0.30 0.30 12.40 21.9
User Input $
59.47
$
12.65
BV Multiplier 100%
BV $ $ $ $ $ $ $ $ $ $ $ $
$ $
0.26 6.63
$
9.49
$ $
0.13 6.63 21.9
Total Per Share 62.46 $ 2.85 45.55 $ 2.08 27%
BV
BV
User Input
BV Multiplier 100%
Net Net Value $
63.30
$
9.30
75%
50%
$ $
6.25 17.90 29.09
Total Per Share 60.95 $ 2.10 40.44 $ 1.39 34%
User Input
BV Multiplier
96.00
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
100%
Net Net Value 4,775.00
$
540.75
$ $
30.00 3,411.00 320.96
Total Net Net Working Capital $ 1,934.75 $ Current Market Cap/Share $ 1,470.00 $ Discount to Liquidation Price
Per Share 6.03 4.57 24%
100%
75%
50%
IPAS
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
33.10 35.30 33.80 33.80 35.50 61.32
$ $
33.70 34.18
$
31.67
BV Multiplier
Net Net Value $
67.88
$
23.75
$ $
34.97 61.32
Total 56.66 $ 91.98 $
Per Share 0.92 1.50 0%
100%
75%
50%
$
34.97
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
MTSN
Numbers from 2008/12 (go to SEC for accurate numbers) (Numbers From ADVFN)
Net Net Value $
96.00
$
16.05
75%
50%
$ $
BV Multiplier $
Ticker 12 (go to SEC for accurate numbers)
91.60 $ 12.70 15.30 6.10 21.40 16.60 42.06
User Input
$ 4,775.00 $ $ 707.00 $ 14.00 $ 721.00 $ $ $ $ $ 60.00 $ 60.00 $ 3,411.00 320.96
Numbers from 2008/12 (go to SEC for accurate numbers) (Numbers From ADVFN)
LTON
$ $ $ $ $ $ $ $ $ $ $ $
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 10 (go to SEC for accurate numbers)
27.20 36.10 12.40 12.40 7.50 0.50 4.50 12.50 17.90 29.09
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
59.47
50%
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
Ticker 11
Net Net Value $
IKAN
Ticker 9
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 2008/12 (go to SEC for accurate numbers) (Numbers From ADVFN)
75%
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
Numbers from 2008/10 (Numbers From ADVFN)
HTX
Ticker 8 (go to SEC for accurate numbers)
16.60 42.06
Total Per Share 95.45 $ 2.27 69.40 $ 1.65 27%
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 49.7
$ $
77.10 26.30
$
14.50
BV Multiplier
Net Net Value $
103.40
$
10.88
$ $
24.65 51.40 49.7
Total 87.53 $ 76.04 $
Per Share 1.76 1.53 13%
100%
75%
50%
$ $
49.30 51.40
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
Ticker 13
MEMS
Numbers from 2008/10 (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
64.40 $ 1.50 $ 1.90 1.90 1.60 3.40 1.30 6.30 2.70 23.7
BV Multiplier
64.37 1.49
100%
Ticker 15
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
65.85
$
1.43
$ $
3.15 2.70 23.7
Total Per Share 67.73 $ 2.86 65.17 $ 2.75 4%
NSTR BV $ $ $ $ $ $ $ $ $ $ $ $
$ $ $ $ $ $ $ $ $ $ $ $
User Input
BV Multiplier 100%
Net Net Value $
64.70
$
-
75%
50%
$ $
2.60 26.12
Total Per Share 62.10 $ 2.38 50.41 $ 1.93 19%
User Input
165.40 31.10 50.90 82.00 6.30 30.40 0.30 (6.20) 11.60 148.50 54.62
$ 130.15 $ 24.60
BV Multiplier 100%
47.00
Net Net Value $
154.75
$
35.25
50%
$ 9.10 $ 143.90
$ $
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
4.55 143.90 54.62
Total Per Share 50.65 $ 0.93 118.53 $ 2.17 0%
ELOS
Ticker 19
BV $ $ $ $ $ $ $ $ $ $ $ $
User Input
37.90 110.80 25.00 0.10 25.10 2.90 3.60 5.90 12.40 11.40 36.35
$ $
110.90 40.00
$
23.80
BV Multiplier
Net Net Value $
150.90
$
17.85
$ $
8.55 39.30 36.35
Total 138.00 $ 120.68 $
Per Share 3.80 3.32 13%
100%
75%
50%
$ $
17.10 39.30
PDII
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
90.10 $ 0.20 18.30 18.30 41.90 $ 14.22
BV Multiplier
81.10
Net Net Value $
81.10
$
13.73
$ $
31.58 14.22
Total 63.25 $ 48.35 $
Per Share 4.45 3.40 24%
100%
75%
50%
31.58
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
SWIR
Numbers from 2008/12 (go to SEC for accurate numbers) (Numbers From ADVFN)
75%
$
BV
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
Ticker 18 (go to SEC for accurate numbers)
BV
Numbers from 2008/12 (Numbers From ADVFN)
$ $ $ $ $ $ $ $ $ $ $ $
Numbers from 2008/12 (go to SEC for accurate numbers) (Numbers From ADVFN)
QLTI
Ticker 17
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 16 (go to SEC for accurate numbers)
8.60 56.10 2.60 26.12
Numbers from 2008/10 (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 $
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
Numbers from 2008/12 (go to SEC for accurate numbers) (Numbers From ADVFN)
75%
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
Numbers from 2008/12 (Numbers From ADVFN)
NED
Ticker 14 (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 $ $ $ $ $ $ $ $ $ $ $ $
User Input
BV Multiplier
63.30 18.00 67.10 67.10 7.90 25.10 33.00 104.90 31.03
Net Net Value $
81.30
$
50.33
$ $
16.50 104.90 31.03
Total 43.23 $ 174.39 $
Per Share 1.39 5.62 0%
100%
75%
50%
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
Ticker 20 (go to SEC for accurate numbers)
User Input
BV Multiplier
72.40 124.20 36.90 36.90 12.70 12.70 38.70 24.48
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
100%
Numbers from 2008/12 (go to SEC for accurate numbers) (Numbers From ADVFN)
Net Net Value $
196.60
$
27.68
75%
50%
$ $
6.35 38.70 24.48
Total Per Share 191.93 $ 7.84 192.40 $ 7.86 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
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 $
-
75%
#VALUE!
50%
#VALUE! Error #VALUE! Total Per Share #VALUE! #VALUE! #VALUE! Error #VALUE!