Benjamin Graham Net Net Cheap Stock Valuation Spreadsheet
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Benjamin Graham Net Net Cheap Stock Valuation Spreadsheet as PDF for free.
More details
- Words: 512
- Pages: 1
Ticker 1
ADGF
Figures in Millions except per share values Cash & Equivalents Restricted Cash 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 $ $ $ $ $ $ $ $ $ $ $ $ $
8.80 17.20 17.20 12.00 14.40 26.40 11.20 6.51
BV User Input Multiplier
Numbers from 2008/12 (go to SEC for accurate numbers) (Numbers From ADVFN)
Net Net Value $
8.80
x1
x 0.75
$
12.90
x 0.5 depending on type of inventory
$ $
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
Ticker 2
13.20 11.20 6.51
Total Per Share 23.70 $ 3.64 17.12 $ 2.63 28%
DRAD BV $ $ $ $ $ $ $ $ $ $ $ $ $
13.50 14.80 9.30 9.30 2.00 3.10 0.50 5.00 12.20 18.95
Figures in Millions except per share values Cash & Equivalents Restricted Cash 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 User Input Multiplier
28.30
x1
x 0.75
$
6.98
x 0.5 depending on type of inventory
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
$ $
BV Multiplier
Net Net Value $ 212.20
x1
x 0.75
$
0.38
x 0.5 depending on type of inventory
$ 1.80 $ 56.40 62.89 Total Per Share 157.98 $ 2.51 89.93 $ 1.43 43%
ASYS
Numbers from 2008/12 (go to SEC for accurate numbers) (Numbers From ADVFN)
Net Net Value $
User Input
212.20 0.50 0.50 1.90 1.70 3.60 56.40 62.89
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
Ticker 4
Numbers from 2008/12 (go to SEC for accurate numbers) (Numbers From ADVFN) Figures in Millions except per share values Cash & Equivalents Restricted Cash 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
TRID
Ticker 2
Numbers from 2008/09 (go to SEC for accurate numbers) (Numbers From ADVFN)
2.50 12.20 18.95
Total Per Share 25.58 $ 1.35 18.95 $ 1.00 26%
Figures in Millions except per share values Cash & Equivalents Restricted Cash 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 $ $ $ $ $ $ $ $ $ $ $ $ $
38.40 0.50 21.50 21.50 5.10 10.40 0.80 16.40 27.10 9.1
User Input
BV Multiplier
Net Net Value $ 38.90
x1
x 0.75
$ 16.13 x 0.5 depending on type of inventory
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
$ 8.20 $ 27.10 9.1 Total Per Share 36.13 $ 3.97 29.86 $ 3.28 17%
ADGF
Figures in Millions except per share values Cash & Equivalents Restricted Cash 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 $ $ $ $ $ $ $ $ $ $ $ $ $
8.80 17.20 17.20 12.00 14.40 26.40 11.20 6.51
BV User Input Multiplier
Numbers from 2008/12 (go to SEC for accurate numbers) (Numbers From ADVFN)
Net Net Value $
8.80
x1
x 0.75
$
12.90
x 0.5 depending on type of inventory
$ $
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
Ticker 2
13.20 11.20 6.51
Total Per Share 23.70 $ 3.64 17.12 $ 2.63 28%
DRAD BV $ $ $ $ $ $ $ $ $ $ $ $ $
13.50 14.80 9.30 9.30 2.00 3.10 0.50 5.00 12.20 18.95
Figures in Millions except per share values Cash & Equivalents Restricted Cash 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 User Input Multiplier
28.30
x1
x 0.75
$
6.98
x 0.5 depending on type of inventory
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
$ $
BV Multiplier
Net Net Value $ 212.20
x1
x 0.75
$
0.38
x 0.5 depending on type of inventory
$ 1.80 $ 56.40 62.89 Total Per Share 157.98 $ 2.51 89.93 $ 1.43 43%
ASYS
Numbers from 2008/12 (go to SEC for accurate numbers) (Numbers From ADVFN)
Net Net Value $
User Input
212.20 0.50 0.50 1.90 1.70 3.60 56.40 62.89
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
Ticker 4
Numbers from 2008/12 (go to SEC for accurate numbers) (Numbers From ADVFN) Figures in Millions except per share values Cash & Equivalents Restricted Cash 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
TRID
Ticker 2
Numbers from 2008/09 (go to SEC for accurate numbers) (Numbers From ADVFN)
2.50 12.20 18.95
Total Per Share 25.58 $ 1.35 18.95 $ 1.00 26%
Figures in Millions except per share values Cash & Equivalents Restricted Cash 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 $ $ $ $ $ $ $ $ $ $ $ $ $
38.40 0.50 21.50 21.50 5.10 10.40 0.80 16.40 27.10 9.1
User Input
BV Multiplier
Net Net Value $ 38.90
x1
x 0.75
$ 16.13 x 0.5 depending on type of inventory
Net Net Working Capital $ Current Market Cap/Share $ Discount to Liquidation Price
$ 8.20 $ 27.10 9.1 Total Per Share 36.13 $ 3.97 29.86 $ 3.28 17%
Related Documents
10 Cheap Value Stocks Graham Net Net
June 2020 17
Cheap Stocks Net Net Research- Rackable Systems
April 2020 19
Net
November 2019 45
Net
May 2020 23
Net
October 2019 36More Documents from ""
Forbes200 Small Companies 4
June 2020 8
10 Cheap Value Stocks Graham Net Net
June 2020 17
Msft 10yr Osv Stock Valuation Spreadsheet
June 2020 13
Forbes 2009 200 Small Companies
June 2020 16
100 Net Net Deep Value Screen Results
May 2020 12