Benjamin Graham Net Net Cheap Stock Valuation Spreadsheet

  • Uploaded by: Old School Value
  • 0
  • 0
  • April 2020
  • PDF

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%

Related Documents


More Documents from ""