Docstoc

Excel valuation model comparing companies

Document Sample
Excel valuation model comparing companies Powered By Docstoc
					BT Wolfensohn Market Comparison Spreadsheet
Once you have entered the Stock Tickers you should go to the Reorder Page and sort the data by Company Name. This will feed the data into the Output Sheet alphabetically. Do not sort the Client Cell Entry Ticker - it is meant to be placed last to facilitate a comparision with your market comps.
Name of Project: Name of Output Sheet: Amount of $ Displayed: Current Date: Stock Symbol XXX XXX $ millions 5/10/2000 Name of Company Comments

Macro Control Area

Designed by John P. Burns Analyst - 98.12.15

Client Cell Entry

Project XXX

Once you have entered the Stock Tickers, you should select the columns (E through AH) and rows (11 through 59) with information - then go to Data, Sort and sort by row 12 (Company Names), in descending order. Then sort just those columns with information in ascending order. This will feed the data into the Output Sheet alphabetically.

0
OFFSET

Number of Comparable Companies
Description 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 MEDIAN

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48

Company Name Fiscal Year Ending LTM Date Share Price Shares Outstanding Equity Value TEV LTM Revenues LTM EBITDA LTM EBIT LTM Net Income FY 1E EPS FY 2E EPS FY 3E EPS Book Value TEV/LTM Revenues TEV/LTM EBITDA TEV/LTM EBIT Equity Value/LTM Net Income Price to FY1 EPS Price to FY2 EPS Price to FY3 EPS Equity Value/Book Value Update Financials 1 Update Financials 2 EBIT Margin (LTM) EBITDA Margin (LTM) Net Income Margin (LTM) Discount/Premium to Book Minority Interest Net Debt Total Debt Effective Tax Rate (LTM) Fiscal Year Tax Rate 52 Week High 52 Week Low % Off From 52 Week High Total Assets Debt-to-Capital (Book) Net Debt-to-Capital (Book) Debt-to-Capital (Market) Net Debt-to-Capital (Market) LTM Interest Expense LTM CapEx LTM Debt / EBITDA LTM Net Debt / EBITDA LTM EBITDA / Interest Expense LTM (EBITDA-CapEx) / Interest

0 1/0/1900 01/00/00 NA NA NA NA NA NA NA NA $0.00 $0.00 $0.00 NA NA NA NA NA NA NA NA NA Check for New 10K 10K Latest Info

0 1/0/1900 01/00/00 NA NA NA NA NA NA NA NA $0.00 $0.00 $0.00 NA NA NA NA NA NA NA NA NA Check for New 10K 10K Latest Info

0 1/0/1900 01/00/00 NA NA NA NA NA NA NA NA $0.00 $0.00 $0.00 NA NA NA NA NA NA NA NA NA Check for New 10K 10K Latest Info

0 1/0/1900 01/00/00 NA NA NA NA NA NA NA NA $0.00 $0.00 $0.00 NA NA NA NA NA NA NA NA NA Check for New 10K 10K Latest Info

0 1/0/1900 01/00/00 NA NA NA NA NA NA NA NA $0.00 $0.00 $0.00 NA NA NA NA NA NA NA NA NA Check for New 10K 10K Latest Info

0 1/0/1900 01/00/00 NA NA NA NA NA NA NA NA $0.00 $0.00 $0.00 NA NA NA NA NA NA NA NA NA Check for New 10K 10K Latest Info

0 1/0/1900 01/00/00 NA NA NA NA NA NA NA NA $0.00 $0.00 $0.00 NA NA NA NA NA NA NA NA NA Check for New 10K 10K Latest Info

0 1/0/1900 01/00/00 NA NA NA NA NA NA NA NA $0.00 $0.00 $0.00 NA NA NA NA NA NA NA NA NA Check for New 10K 10K Latest Info

0 1/0/1900 01/00/00 NA NA NA NA NA NA NA NA $0.00 $0.00 $0.00 NA NA NA NA NA NA NA NA NA Check for New 10K 10K Latest Info

0 1/0/1900 01/00/00 NA NA NA NA NA NA NA NA $0.00 $0.00 $0.00 NA NA NA NA NA NA NA NA NA Check for New 10K 10K Latest Info

0 1/0/1900 01/00/00 NA NA NA NA NA NA NA NA $0.00 $0.00 $0.00 NA NA NA NA NA NA NA NA NA Check for New 10K 10K Latest Info

0 1/0/1900 01/00/00 NA NA NA NA NA NA NA NA $0.00 $0.00 $0.00 NA NA NA NA NA NA NA NA NA Check for New 10K 10K Latest Info

0 1/0/1900 01/00/00 NA NA NA NA NA NA NA NA $0.00 $0.00 $0.00 NA NA NA NA NA NA NA NA NA Check for New 10K 10K Latest Info

0 1/0/1900 01/00/00 NA NA NA NA NA NA NA NA $0.00 $0.00 $0.00 NA NA NA NA NA NA NA NA NA Check for New 10K 10K Latest Info

0 1/0/1900 01/00/00 NA NA NA NA NA NA NA NA $0.00 $0.00 $0.00 NA NA NA NA NA NA NA NA NA Check for New 10K 10K Latest Info

0 1/0/1900 01/00/00 NA NA NA NA NA NA NA NA $0.00 $0.00 $0.00 NA NA NA NA NA NA NA NA NA Check for New 10K 10K Latest Info

0 1/0/1900 01/00/00 NA NA NA NA NA NA NA NA $0.00 $0.00 $0.00 NA NA NA NA NA NA NA NA NA Check for New 10K 10K Latest Info

0 1/0/1900 01/00/00 NA NA NA NA NA NA NA NA $0.00 $0.00 $0.00 NA NA NA NA NA NA NA NA NA Check for New 10K 10K Latest Info

0 1/0/1900 01/00/00 NA NA NA NA NA NA NA NA $0.00 $0.00 $0.00 NA NA NA NA NA NA NA NA NA Check for New 10K 10K Latest Info

0 1/0/1900 01/00/00 NA NA NA NA NA NA NA NA $0.00 $0.00 $0.00 NA NA NA NA NA NA NA NA NA Check for New 10K 10K Latest Info

0 1/0/1900 01/00/00 NA NA NA NA NA NA NA NA $0.00 $0.00 $0.00 NA NA NA NA NA NA NA NA NA Check for New 10K 10K Latest Info

0 1/0/1900 01/00/00 NA NA NA NA NA NA NA NA $0.00 $0.00 $0.00 NA NA NA NA NA NA NA NA NA Check for New 10K 10K Latest Info

0 1/0/1900 01/00/00 NA NA NA NA NA NA NA NA $0.00 $0.00 $0.00 NA NA NA NA NA NA NA NA NA Check for New 10K 10K Latest Info

0 1/0/1900 01/00/00 NA NA NA NA NA NA NA NA $0.00 $0.00 $0.00 NA NA NA NA NA NA NA NA NA Check for New 10K 10K Latest Info

0 1/0/1900 01/00/00 NA NA NA NA NA NA NA NA $0.00 $0.00 $0.00 NA NA NA NA NA NA NA NA NA Check for New 10K 10K Latest Info

0 1/0/1900 01/00/00 NA NA NA NA NA NA NA NA $0.00 $0.00 $0.00 NA NA NA NA NA NA NA NA NA Check for New 10K 10K Latest Info

0 1/0/1900 01/00/00 NA NA NA NA NA NA NA NA $0.00 $0.00 $0.00 NA NA NA NA NA NA NA NA NA Check for New 10K 10K Latest Info

0 1/0/1900 01/00/00 NA NA NA NA NA NA NA NA $0.00 $0.00 $0.00 NA NA NA NA NA NA NA NA NA Check for New 10K 10K Latest Info

0 1/0/1900 01/00/00 NA NA NA NA NA NA NA NA $0.00 $0.00 $0.00 NA NA NA NA NA NA NA NA NA Check for New 10K 10K Latest Info

0 1/0/1900 01/00/00 NA NA NA NA NA NA NA NA $0.00 $0.00 $0.00 NA NA NA NA NA NA NA NA NA Check for New 10K 10K Latest Info

0 1/0/1900 01/00/00 NA NA NA NA NA NA NA NA $0.00 $0.00 $0.00 NA NA NA NA NA NA NA NA NA Check for New 10K 10K Latest Info

#NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM!

#NUM! #NUM! #NUM! NA $0.0 $0.0 $0.0 40.0% 40.0% $35.44 $18.25 NA NA NA NA NA NA NA NA NA NA NA NM NA $0.0 $0.0 $0.0 40.0% 40.0% $53.47 $31.38 NA NA NA NA NA NA NA NA NA NA NA NM NA $0.0 $0.0 $0.0 40.0% 40.0% $84.00 $28.38 NA NA NA NA NA NA NA NA NA NA NA NM NA $0.0 $0.0 $0.0 40.0% 40.0% $0.00 $0.00 NA NA NA NA NA NA NA NA NA NA NA NM NA $0.0 $0.0 $0.0 40.0% 40.0% $0.00 $0.00 NA NA NA NA NA NA NA NA NA NA NA NM NA $0.0 $0.0 $0.0 40.0% 40.0% $0.00 $0.00 NA NA NA NA NA NA NA NA NA NA NA NM NA $0.0 $0.0 $0.0 40.0% 40.0% $0.00 $0.00 NA NA NA NA NA NA NA NA NA NA NA NM NA $0.0 $0.0 $0.0 40.0% 40.0% $0.00 $0.00 NA NA NA NA NA NA NA NA NA NA NA NM NA $0.0 $0.0 $0.0 40.0% 40.0% $0.00 $0.00 NA NA NA NA NA NA NA NA NA NA NA NM NA $0.0 $0.0 $0.0 40.0% 40.0% $0.00 $0.00 NA NA NA NA NA NA NA NA NA NA NA NM NA $0.0 $0.0 $0.0 40.0% 40.0% $0.00 $0.00 NA NA NA NA NA NA NA NA NA NA NA NM NA $0.0 $0.0 $0.0 40.0% 40.0% $0.00 $0.00 NA NA NA NA NA NA NA NA NA NA NA NM NA $0.0 $0.0 $0.0 40.0% 40.0% $0.00 $0.00 NA NA NA NA NA NA NA NA NA NA NA NM NA $0.0 $0.0 $0.0 40.0% 40.0% $0.00 $0.00 NA NA NA NA NA NA NA NA NA NA NA NM NA $0.0 $0.0 $0.0 40.0% 40.0% $0.00 $0.00 NA NA NA NA NA NA NA NA NA NA NA NM NA $0.0 $0.0 $0.0 40.0% 40.0% $0.00 $0.00 NA NA NA NA NA NA NA NA NA NA NA NM NA $0.0 $0.0 $0.0 40.0% 40.0% $0.00 $0.00 NA NA NA NA NA NA NA NA NA NA NA NM NA $0.0 $0.0 $0.0 40.0% 40.0% $0.00 $0.00 NA NA NA NA NA NA NA NA NA NA NA NM NA $0.0 $0.0 $0.0 40.0% 40.0% $0.00 $0.00 NA NA NA NA NA NA NA NA NA NA NA NM NA $0.0 $0.0 $0.0 40.0% 40.0% $0.00 $0.00 NA NA NA NA NA NA NA NA NA NA NA NM NA $0.0 $0.0 $0.0 40.0% 40.0% $0.00 $0.00 NA NA NA NA NA NA NA NA NA NA NA NM NA $0.0 $0.0 $0.0 40.0% 40.0% $0.00 $0.00 NA NA NA NA NA NA NA NA NA NA NA NM NA $0.0 $0.0 $0.0 40.0% 40.0% $0.00 $0.00 NA NA NA NA NA NA NA NA NA NA NA NM NA $0.0 $0.0 $0.0 40.0% 40.0% $0.00 $0.00 NA NA NA NA NA NA NA NA NA NA NA NM NA $0.0 $0.0 $0.0 40.0% 40.0% $0.00 $0.00 NA NA NA NA NA NA NA NA NA NA NA NM NA $0.0 $0.0 $0.0 40.0% 40.0% $0.00 $0.00 NA NA NA NA NA NA NA NA NA NA NA NM NA $0.0 $0.0 $0.0 40.0% 40.0% $0.00 $0.00 NA NA NA NA NA NA NA NA NA NA NA NM NA $0.0 $0.0 $0.0 40.0% 40.0% $0.00 $0.00 NA NA NA NA NA NA NA NA NA NA NA NM NA $0.0 $0.0 $0.0 40.0% 40.0% $0.00 $0.00 NA NA NA NA NA NA NA NA NA NA NA NM NA $0.0 $0.0 $0.0 40.0% 40.0% $0.00 $0.00 NA NA NA NA NA NA NA NA NA NA NA NM NA $0.0 $0.0 $0.0 40.0% 40.0% $0.00 $0.00 NA NA NA NA NA NA NA NA NA NA NA NM $0.0 $0.0 $0.0 40.0% 40.0%

#NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM!

Net Debt excludes Minority Interest in Debt Ratios

Comparable Company Analysis -- XXX (in $ millions, except per share data)
Market Value as a Multiple of: FY 1E FY 2E FY 3E EPS EPS EPS $0.00 NM 0.00 NM 0.00 NM 0.0x 0.0 NA NA $0.00 NM 0.00 NM 0.00 NM 0.0x 0.0 NA NA $0.00 NM 0.00 NM 0.00 NM 0.0x 0.0 NA NA

Company Name 0

LTM Date As of 01/00/00

Share Price 5/10/2000 NA

Equity Value NA

TEV NA

TEV Value as a Multiple of: LTM Revenues LTM EBITDA LTM EBIT NA NA NA NA NA NA 0.0x 0.0 NA NA NA NA NA NA NA NA 0.0x 0.0 NA NA NA NA NA NA NA NA 0.0x 0.0 NA NA

LTM Net Income NA NA NA NA NA NA 0.0x 0.0 NA NA

Book Value NA NA NA NA NA NA 0.0x 0.0 NA NA

0

01/00/00

NA

NA

NA

0

01/00/00

NA

NA

NA

High: Low: Mean: Median: 2

e6827318-8222-4527-a49a-51b56eedf3231Output

A 1 2

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

NA

Check for New 10K
10K Latest Info
Options Table - Treasury Stock Method: 0 0 Number of Shares: (in millions) 0.000000 Net New Shares: (in millions) 0.000000

3 4 I. Summary Information 5 A. Company Name: 6 B. Industry: 7 C. Description 8 D. Fiscal Year End: 9 E. Latest Quarter: 10 F. Previous Quarter: 11 G. FY1 Median Est. EPS 12 H. FY2 Median Est. EPS 13 I. FY3 Median Est. EPS 14 15 16 J. LT I/B/E/S EPS Growth Rate: 17 18 II. Equity Value 19 A. Current Shares Outstanding: 20 (Fully Diluted: 0-No,1-Yes) 21 B. Current Share Price: 22 C. Market Value of Equity: 23 24 III. Total Enterprise Value: 25 A. Short-term debt: 26 27 28 29 30 31 32 33 34 B. C. D. E. F. G. H. I. Long-term debt: Minority Interest: Preferred Stock: Total Debt Outstanding: Less: Cash and Equivalents: Net Debt (E-F): Market Value of Equity: Total Enterprise Value (G+H):

Number of Options ## ##

Weighted Price

Excercise 0 0 0 0 0 0 0

Proceeds Stock Buyback

NA

NA NA NA

0 Convertible Debt / Preferred Stock Table: #NAME?
Convertible Debt:

Total # of Shares: Bal. Sht Amt.
(in millions)

0.00 Number of Shares:

Convert Price:

Excercise

Proceeds Stock Buyback

$ $ NA NA

Preferred Stock:

Total # of Shares: Bal. Sht Amt.
(in millions)

0.00 Number of Shares:

Convert Price:

Excercise

Proceeds Stock Buyback

35 IV. Financial Data 36 A. Latest Fiscal Year End Revenues: 37 B. Plus: Latest Revenues: 38 C. Less: Prior Revenues: 39 D. LTM Revenues: 40 41 E. Latest Fiscal Year End EBIT: 42 F. Plus: Latest EBIT: 43 G. Less: Prior EBIT: 44 H. LTM EBIT: 45 46 I. Latest Fiscal Year End D&A: 47 J. Plus: Latest D&A: 48 K. Less: Prior D&A: 49 L. LTM D&A: 50 51 M. LTM EBITDA: 52 53 N. Latest Fiscal Year Net Income: 54 O. Plus: Latest Net Income: 55 P. Less: Prior Net Income: 56 Q. LTM Net Income: 57 58 R. Latest Book Value of Common Equity: 59 S. Amount of Total Assets: 60 V. Multiples 61 A. TEV/LTM Revenues: 62 B. TEV/LTM EBITDA: 63 C. TEV/LTM EBIT: 64 D. Equity Value/LTM Net Income: 65 E. Price to FY1 Est. EPS 66 F. Price to FY2 Est. EPS 67 G. Price to FY3 Est. EPS 68 H. Equity Value/Book Value: 69 Footnotes: 70 (a) 0 71 (b) 0 72 (c) 0 73 (d) 0 74 (e) 0 75 (f) 0 76 (g) 0 77 (h) 0 78 (i) 0 79 (j) 0 80 81 82 83 84 85 86 87 88 89 90 91

NA Latest $ $ $ NA Adj. EBIT: $ Operating Profit: $ Previous $ Annual -

(enter footnotes below)

$ NA $ $ $ NA NA NA

-

Effective Tax Rate: Adj. Net Income: $ Income from Ops: Tax Effect: $ Sum of Extra: $ Note: Don't forget to add the extraordinary back for Net Income when backing out for EBIT be careful not to back out in EBIT any extraordinaries that affect only Net Income !

Latest 40.0% $ $ $

Previous 40.0% $ $ $

Annual 40.0% -

NA NA NA NA NA NA NA NA

Latest CapEx Interest Expense 52 Week High 52 Week Low Segment Financials by Sales Sales

Other Financial Information Previous Annual NA NA $53.47 $31.38

LTM

Division

Percentage

Total Firm Sales

$0.0

0.0%

NA

Check for New 10K
10K Latest Info
I. Summary Information A. Company Name: B. Industry: C. Description D. Fiscal Year End: E. Latest Quarter: F. Previous Quarter: G. FY1 Median Est. EPS H. I. FY2 Median Est. EPS FY3 Median Est. EPS 0 Computer Manufacturing

J.

LT I/B/E/S EPS Growth Rate:

II. Equity Value A. Current Shares Outstanding: (Fully Diluted: 0-No,1-Yes) B. Current Share Price: C. Market Value of Equity: III. Total Enterprise Value: A. Short-term debt: B. C. D. E. F. G. H. I. Long-term debt: Minority Interest: Preferred Stock: Total Debt Outstanding: Less: Cash and Equivalents: Net Debt (E-F): Market Value of Equity: Total Enterprise Value (G+H):

NA NA NA

$ $ NA NA

-

IV. Financial Data A. Latest Fiscal Year End Revenues: B. Plus: Latest Revenues: C. Less: Prior Revenues: D. LTM Revenues: E. F. G. H. I. J. Latest Fiscal Year End EBIT: Plus: Latest EBIT: Less: Prior EBIT: LTM EBIT: Latest Fiscal Year End D&A: Plus: Latest D&A:

NA $ $ $ NA -

K. L. M. N. O. P. Q. R. S. V. Multiples A. B. C. D. E. F. G. H. Footnotes: (a) (b) (c) (d) (e) (f) (g) (h) (i) (j)

Less: Prior D&A: LTM D&A: LTM EBITDA: Latest Fiscal Year Net Income: Plus: Latest Net Income: Less: Prior Net Income: LTM Net Income: Latest Book Value of Common Equity: Amount of Total Assets: TEV/LTM Revenues: TEV/LTM EBITDA: TEV/LTM EBIT: Equity Value/LTM Net Income: Price to FY1 Est. EPS Price to FY2 Est. EPS Price to FY3 Est. EPS Equity Value/Book Value: 0 0 0 0 0 0 0 0 0 0

$ NA $ $ $ NA NA NA

-

-

NA NA NA NA NA NA NA NA

Total Firm Sales

Options Table - Treasury Stock Method: 0 Number of Shares: (in millions) 0.000000 Net New Shares: (in millions)

Number of Options ### ###

Weighted Price

0 Convertible Debt / Preferred Stock Table: #NAME?
Convertible Debt:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Preferred Stock:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Latest Adj. EBIT: $ Operating Profit: $

Previous -

(enter footnotes below)

Latest Effective Tax Rate: Adj. Net Income: $ Income from Ops: Tax Effect: $ Sum of Extra: $ Note: Don't forget to add the extraordinary back for Net Income when backing out for EBIT be careful not to back out in EBIT any extraordinaries that affect only Net Income ! 40.0% $ $ $

Previous 40.0% -

Latest CapEx Interest Expense 52 Week High 52 Week Low Segment Financials by Sales Sales

Other Financial Information Previous

$35.44 $18.25

Division

Percentage

Total Firm Sales

$0.0

0.0%

ethod: 0.000000

k Table: 0.00 Number of Shares:

0.00 Number of Shares:

Annual $ -

Annual 40.0% $ $ $ -

Information Annual

NA

Check for New 10K
10K Latest Info
I. Summary Information A. Company Name: B. Industry: C. Description D. Fiscal Year End: E. Latest Quarter: F. Previous Quarter: G. FY1 Median Est. EPS H. I. FY2 Median Est. EPS FY3 Median Est. EPS 0 Computer Manufacturer

J.

LT I/B/E/S EPS Growth Rate:

NA

II. Equity Value A. Current Shares Outstanding: (Fully Diluted: 0-No,1-Yes) B. Current Share Price: C. Market Value of Equity: III. Total Enterprise Value: A. Short-term debt: B. C. D. E. F. G. H. I. Long-term debt: Minority Interest: Preferred Stock: Total Debt Outstanding: Less: Cash and Equivalents: Net Debt (E-F): Market Value of Equity: Total Enterprise Value (G+H):

NA NA NA

$ $ NA NA

-

IV. Financial Data A. Latest Fiscal Year End Revenues: B. Plus: Latest Revenues: C. Less: Prior Revenues: D. LTM Revenues: E. F. G. H. I. J. Latest Fiscal Year End EBIT: Plus: Latest EBIT: Less: Prior EBIT: LTM EBIT: Latest Fiscal Year End D&A: Plus: Latest D&A:

NA $ $ $ NA -

K. L. M. N. O. P. Q. R. S. V. Multiples A. B. C. D. E. F. G. H. Footnotes: (a) (b) (c) (d) (e) (f) (g) (h) (i) (j)

Less: Prior D&A: LTM D&A: LTM EBITDA: Latest Fiscal Year Net Income: Plus: Latest Net Income: Less: Prior Net Income: LTM Net Income: Latest Book Value of Common Equity: Amount of Total Assets: TEV/LTM Revenues: TEV/LTM EBITDA: TEV/LTM EBIT: Equity Value/LTM Net Income: Price to FY1 Est. EPS Price to FY2 Est. EPS Price to FY3 Est. EPS Equity Value/Book Value: 0 0 0 0 0 0 0 0 0 0

$ NA $ $ $ NA NA NA

-

-

NA NA NA NA NA NA NA NA

Total Firm Sales

Options Table - Treasury Stock Method: 0 Number of Shares: (in millions) 0.000000 Net New Shares: (in millions)

Number of Options ### ###

Weighted Price

0 Convertible Debt / Preferred Stock Table: #NAME?
Convertible Debt:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Preferred Stock:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Latest Adj. EBIT: $ Operating Profit: $

Previous -

(enter footnotes below)

Latest Effective Tax Rate: Adj. Net Income: $ Income from Ops: Tax Effect: $ Sum of Extra: $ Note: Don't forget to add the extraordinary back for Net Income when backing out for EBIT be careful not to back out in EBIT any extraordinaries that affect only Net Income ! 40.0% $ $ $

Previous 40.0% -

Latest CapEx Interest Expense 52 Week High 52 Week Low Segment Financials by Sales Sales

Other Financial Information Previous

$84.00 $28.38

Division

Percentage

Total Firm Sales

$0.0

0.0%

ethod: 0.000000

k Table: 0.00 Number of Shares:

0.00 Number of Shares:

Annual $ -

Annual 40.0% $ $ $ -

Information Annual

Comparable Company Analysis

Check for New 10K
10K Latest Info
I. Summary Information A. Company Name: B. Industry: C. Description D. Fiscal Year End: E. Latest Quarter: F. Previous Quarter: G. FY1 Median Est. EPS H. I. FY2 Median Est. EPS FY3 Median Est. EPS 0

J.

LT I/B/E/S EPS Growth Rate:

NA

II. Equity Value A. Current Shares Outstanding: (Fully Diluted: 0-No,1-Yes) B. Current Share Price: C. Market Value of Equity: III. Total Enterprise Value: A. Short-term debt: B. C. D. E. F. G. H. I. Long-term debt: Minority Interest: Preferred Stock: Total Debt Outstanding: Less: Cash and Equivalents: Net Debt (E-F): Market Value of Equity: Total Enterprise Value (G+H):

NA NA NA

$ $ NA NA

-

IV. Financial Data A. Latest Fiscal Year End Revenues: B. Plus: Latest Revenues: C. Less: Prior Revenues: D. LTM Revenues: E. F. G. H. I. J. Latest Fiscal Year End EBIT: Plus: Latest EBIT: Less: Prior EBIT: LTM EBIT: Latest Fiscal Year End D&A: Plus: Latest D&A:

NA $ $ $ NA -

K. L. M. N. O. P. Q. R. S. V. Multiples A. B. C. D. E. F. G. H. Footnotes: (a) (b) (c) (d) (e) (f) (g) (h) (i) (j)

Less: Prior D&A: LTM D&A: LTM EBITDA: Latest Fiscal Year Net Income: Plus: Latest Net Income: Less: Prior Net Income: LTM Net Income: Latest Book Value of Common Equity: Amount of Total Assets: TEV/LTM Revenues: TEV/LTM EBITDA: TEV/LTM EBIT: Equity Value/LTM Net Income: Price to FY1 Est. EPS Price to FY2 Est. EPS Price to FY3 Est. EPS Equity Value/Book Value: 0 0 0 0 0 0 0 0 0 0

$ NA $ $ $ NA NA NA

-

-

NA NA NA NA NA NA NA NA

Total Firm Sales

s

Options Table - Treasury Stock Method: 0 Number of Shares: (in millions) 0.000000 Net New Shares: (in millions)

Number of Options ### ###

Weighted Price

0 Convertible Debt / Preferred Stock Table: #NAME?
Convertible Debt:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Preferred Stock:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Latest Adj. EBIT: $ Operating Profit: $

Previous -

(enter footnotes below)

Latest Effective Tax Rate: Adj. Net Income: $ Income from Ops: Tax Effect: $ Sum of Extra: $ Note: Don't forget to add the extraordinary back for Net Income when backing out for EBIT be careful not to back out in EBIT any extraordinaries that affect only Net Income ! 40.0% $ $ $

Previous 40.0% -

Latest CapEx Interest Expense 52 Week High 52 Week Low Segment Financials by Sales Sales

Other Financial Information Previous

Division

Percentage

Total Firm Sales

$0.0

0.0%

ethod: 0.000000

k Table: 0.00 Number of Shares:

0.00 Number of Shares:

Annual $ -

Annual 40.0% $ $ $ -

Information Annual

Comparable Company Analysis

Check for New 10K
10K Latest Info
I. Summary Information A. Company Name: B. Industry: C. Description D. Fiscal Year End: E. Latest Quarter: F. Previous Quarter: G. FY1 Median Est. EPS H. I. FY2 Median Est. EPS FY3 Median Est. EPS 0

J.

LT I/B/E/S EPS Growth Rate:

NA

II. Equity Value A. Current Shares Outstanding: (Fully Diluted: 0-No,1-Yes) B. Current Share Price: C. Market Value of Equity: III. Total Enterprise Value: A. Short-term debt: B. C. D. E. F. G. H. I. Long-term debt: Minority Interest: Preferred Stock: Total Debt Outstanding: Less: Cash and Equivalents: Net Debt (E-F): Market Value of Equity: Total Enterprise Value (G+H):

NA NA NA

$ $ NA NA

-

IV. Financial Data A. Latest Fiscal Year End Revenues: B. Plus: Latest Revenues: C. Less: Prior Revenues: D. LTM Revenues: E. F. G. H. I. J. Latest Fiscal Year End EBIT: Plus: Latest EBIT: Less: Prior EBIT: LTM EBIT: Latest Fiscal Year End D&A: Plus: Latest D&A:

NA $ $ $ NA -

K. L. M. N. O. P. Q. R. S. V. Multiples A. B. C. D. E. F. G. H. Footnotes: (a) (b) (c) (d) (e) (f) (g) (h) (i) (j)

Less: Prior D&A: LTM D&A: LTM EBITDA: Latest Fiscal Year Net Income: Plus: Latest Net Income: Less: Prior Net Income: LTM Net Income: Latest Book Value of Common Equity: Amount of Total Assets: TEV/LTM Revenues: TEV/LTM EBITDA: TEV/LTM EBIT: Equity Value/LTM Net Income: Price to FY1 Est. EPS Price to FY2 Est. EPS Price to FY3 Est. EPS Equity Value/Book Value: 0 0 0 0 0 0 0 0 0 0

$ NA $ $ $ NA NA NA

-

-

NA NA NA NA NA NA NA NA

Total Firm Sales

s

Options Table - Treasury Stock Method: 0 Number of Shares: (in millions) 0.000000 Net New Shares: (in millions)

Number of Options ### ###

Weighted Price

0 Convertible Debt / Preferred Stock Table: #NAME?
Convertible Debt:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Preferred Stock:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Latest Adj. EBIT: $ Operating Profit: $

Previous -

(enter footnotes below)

Latest Effective Tax Rate: Adj. Net Income: $ Income from Ops: Tax Effect: $ Sum of Extra: $ Note: Don't forget to add the extraordinary back for Net Income when backing out for EBIT be careful not to back out in EBIT any extraordinaries that affect only Net Income ! 40.0% $ $ $

Previous 40.0% -

Latest CapEx Interest Expense 52 Week High 52 Week Low Segment Financials by Sales Sales

Other Financial Information Previous

Division

Percentage

Total Firm Sales

$0.0

0.0%

ethod: 0.000000

k Table: 0.00 Number of Shares:

0.00 Number of Shares:

Annual $ -

Annual 40.0% $ $ $ -

Information Annual

Comparable Company Analysis

Check for New 10K
10K Latest Info
I. Summary Information A. Company Name: B. Industry: C. Description D. Fiscal Year End: E. Latest Quarter: F. Previous Quarter: G. FY1 Median Est. EPS H. I. FY2 Median Est. EPS FY3 Median Est. EPS 0

J.

LT I/B/E/S EPS Growth Rate:

NA

II. Equity Value A. Current Shares Outstanding: (Fully Diluted: 0-No,1-Yes) B. Current Share Price: C. Market Value of Equity: III. Total Enterprise Value: A. Short-term debt: B. C. D. E. F. G. H. I. Long-term debt: Minority Interest: Preferred Stock: Total Debt Outstanding: Less: Cash and Equivalents: Net Debt (E-F): Market Value of Equity: Total Enterprise Value (G+H):

NA NA NA

$ $ NA NA

-

IV. Financial Data A. Latest Fiscal Year End Revenues: B. Plus: Latest Revenues: C. Less: Prior Revenues: D. LTM Revenues: E. F. G. H. I. J. Latest Fiscal Year End EBIT: Plus: Latest EBIT: Less: Prior EBIT: LTM EBIT: Latest Fiscal Year End D&A: Plus: Latest D&A:

NA $ $ $ NA -

K. L. M. N. O. P. Q. R. S. V. Multiples A. B. C. D. E. F. G. H. Footnotes: (a) (b) (c) (d) (e) (f) (g) (h) (i) (j)

Less: Prior D&A: LTM D&A: LTM EBITDA: Latest Fiscal Year Net Income: Plus: Latest Net Income: Less: Prior Net Income: LTM Net Income: Latest Book Value of Common Equity: Amount of Total Assets: TEV/LTM Revenues: TEV/LTM EBITDA: TEV/LTM EBIT: Equity Value/LTM Net Income: Price to FY1 Est. EPS Price to FY2 Est. EPS Price to FY3 Est. EPS Equity Value/Book Value: 0 0 0 0 0 0 0 0 0 0

$ NA $ $ $ NA NA NA

-

-

NA NA NA NA NA NA NA NA

Total Firm Sales

s

Options Table - Treasury Stock Method: 0 Number of Shares: (in millions) 0.000000 Net New Shares: (in millions)

Number of Options ### ###

Weighted Price

0 Convertible Debt / Preferred Stock Table: #NAME?
Convertible Debt:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Preferred Stock:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Latest Adj. EBIT: $ Operating Profit: $

Previous -

(enter footnotes below)

Latest Effective Tax Rate: Adj. Net Income: $ Income from Ops: Tax Effect: $ Sum of Extra: $ Note: Don't forget to add the extraordinary back for Net Income when backing out for EBIT be careful not to back out in EBIT any extraordinaries that affect only Net Income ! 40.0% $ $ $

Previous 40.0% -

Latest CapEx Interest Expense 52 Week High 52 Week Low Segment Financials by Sales Sales

Other Financial Information Previous

Division

Percentage

Total Firm Sales

$0.0

0.0%

ethod: 0.000000

k Table: 0.00 Number of Shares:

0.00 Number of Shares:

Annual $ -

Annual 40.0% $ $ $ -

Information Annual

Comparable Company Analysis

Check for New 10K
10K Latest Info
I. Summary Information A. Company Name: B. Industry: C. Description D. Fiscal Year End: E. Latest Quarter: F. Previous Quarter: G. FY1 Median Est. EPS H. I. FY2 Median Est. EPS FY3 Median Est. EPS 0

J.

LT I/B/E/S EPS Growth Rate:

NA

II. Equity Value A. Current Shares Outstanding: (Fully Diluted: 0-No,1-Yes) B. Current Share Price: C. Market Value of Equity: III. Total Enterprise Value: A. Short-term debt: B. C. D. E. F. G. H. I. Long-term debt: Minority Interest: Preferred Stock: Total Debt Outstanding: Less: Cash and Equivalents: Net Debt (E-F): Market Value of Equity: Total Enterprise Value (G+H):

NA NA NA

$ $ NA NA

-

IV. Financial Data A. Latest Fiscal Year End Revenues: B. Plus: Latest Revenues: C. Less: Prior Revenues: D. LTM Revenues: E. F. G. H. I. J. Latest Fiscal Year End EBIT: Plus: Latest EBIT: Less: Prior EBIT: LTM EBIT: Latest Fiscal Year End D&A: Plus: Latest D&A:

NA $ $ $ NA -

K. L. M. N. O. P. Q. R. S. V. Multiples A. B. C. D. E. F. G. H. Footnotes: (a) (b) (c) (d) (e) (f) (g) (h) (i) (j)

Less: Prior D&A: LTM D&A: LTM EBITDA: Latest Fiscal Year Net Income: Plus: Latest Net Income: Less: Prior Net Income: LTM Net Income: Latest Book Value of Common Equity: Amount of Total Assets: TEV/LTM Revenues: TEV/LTM EBITDA: TEV/LTM EBIT: Equity Value/LTM Net Income: Price to FY1 Est. EPS Price to FY2 Est. EPS Price to FY3 Est. EPS Equity Value/Book Value: 0 0 0 0 0 0 0 0 0 0

$ NA $ $ $ NA NA NA

-

-

NA NA NA NA NA NA NA NA

Total Firm Sales

s

Options Table - Treasury Stock Method: 0 Number of Shares: (in millions) 0.000000 Net New Shares: (in millions)

Number of Options ### ###

Weighted Price

0 Convertible Debt / Preferred Stock Table: #NAME?
Convertible Debt:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Preferred Stock:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Latest Adj. EBIT: $ Operating Profit: $

Previous -

(enter footnotes below)

Latest Effective Tax Rate: Adj. Net Income: $ Income from Ops: Tax Effect: $ Sum of Extra: $ Note: Don't forget to add the extraordinary back for Net Income when backing out for EBIT be careful not to back out in EBIT any extraordinaries that affect only Net Income ! 40.0% $ $ $

Previous 40.0% -

Latest CapEx Interest Expense 52 Week High 52 Week Low Segment Financials by Sales Sales

Other Financial Information Previous

Division

Percentage

Total Firm Sales

$0.0

0.0%

ethod: 0.000000

k Table: 0.00 Number of Shares:

0.00 Number of Shares:

Annual $ -

Annual 40.0% $ $ $ -

Information Annual

Comparable Company Analysis

Check for New 10K
10K Latest Info
I. Summary Information A. Company Name: B. Industry: C. Description D. Fiscal Year End: E. Latest Quarter: F. Previous Quarter: G. FY1 Median Est. EPS H. I. FY2 Median Est. EPS FY3 Median Est. EPS 0

J.

LT I/B/E/S EPS Growth Rate:

NA

II. Equity Value A. Current Shares Outstanding: (Fully Diluted: 0-No,1-Yes) B. Current Share Price: C. Market Value of Equity: III. Total Enterprise Value: A. Short-term debt: B. C. D. E. F. G. H. I. Long-term debt: Minority Interest: Preferred Stock: Total Debt Outstanding: Less: Cash and Equivalents: Net Debt (E-F): Market Value of Equity: Total Enterprise Value (G+H):

NA NA NA

$ $ NA NA

-

IV. Financial Data A. Latest Fiscal Year End Revenues: B. Plus: Latest Revenues: C. Less: Prior Revenues: D. LTM Revenues: E. F. G. H. I. J. Latest Fiscal Year End EBIT: Plus: Latest EBIT: Less: Prior EBIT: LTM EBIT: Latest Fiscal Year End D&A: Plus: Latest D&A:

NA $ $ $ NA -

K. L. M. N. O. P. Q. R. S. V. Multiples A. B. C. D. E. F. G. H. Footnotes: (a) (b) (c) (d) (e) (f) (g) (h) (i) (j)

Less: Prior D&A: LTM D&A: LTM EBITDA: Latest Fiscal Year Net Income: Plus: Latest Net Income: Less: Prior Net Income: LTM Net Income: Latest Book Value of Common Equity: Amount of Total Assets: TEV/LTM Revenues: TEV/LTM EBITDA: TEV/LTM EBIT: Equity Value/LTM Net Income: Price to FY1 Est. EPS Price to FY2 Est. EPS Price to FY3 Est. EPS Equity Value/Book Value: 0 0 0 0 0 0 0 0 0 0

$ NA $ $ $ NA NA NA

-

-

NA NA NA NA NA NA NA NA

Total Firm Sales

s

Options Table - Treasury Stock Method: 0 Number of Shares: (in millions) 0.000000 Net New Shares: (in millions)

Number of Options ### ###

Weighted Price

0 Convertible Debt / Preferred Stock Table: #NAME?
Convertible Debt:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Preferred Stock:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Latest Adj. EBIT: $ Operating Profit: $

Previous -

(enter footnotes below)

Latest Effective Tax Rate: Adj. Net Income: $ Income from Ops: Tax Effect: $ Sum of Extra: $ Note: Don't forget to add the extraordinary back for Net Income when backing out for EBIT be careful not to back out in EBIT any extraordinaries that affect only Net Income ! 40.0% $ $ $

Previous 40.0% -

Latest CapEx Interest Expense 52 Week High 52 Week Low Segment Financials by Sales Sales

Other Financial Information Previous

Division

Percentage

Total Firm Sales

$0.0

0.0%

ethod: 0.000000

k Table: 0.00 Number of Shares:

0.00 Number of Shares:

Annual $ -

Annual 40.0% $ $ $ -

Information Annual

Comparable Company Analysis

Check for New 10K
10K Latest Info
I. Summary Information A. Company Name: B. Industry: C. Description D. Fiscal Year End: E. Latest Quarter: F. Previous Quarter: G. FY1 Median Est. EPS H. I. FY2 Median Est. EPS FY3 Median Est. EPS 0

J.

LT I/B/E/S EPS Growth Rate:

NA

II. Equity Value A. Current Shares Outstanding: (Fully Diluted: 0-No,1-Yes) B. Current Share Price: C. Market Value of Equity: III. Total Enterprise Value: A. Short-term debt: B. C. D. E. F. G. H. I. Long-term debt: Minority Interest: Preferred Stock: Total Debt Outstanding: Less: Cash and Equivalents: Net Debt (E-F): Market Value of Equity: Total Enterprise Value (G+H):

NA NA NA

$ $ NA NA

-

IV. Financial Data A. Latest Fiscal Year End Revenues: B. Plus: Latest Revenues: C. Less: Prior Revenues: D. LTM Revenues: E. F. G. H. I. J. Latest Fiscal Year End EBIT: Plus: Latest EBIT: Less: Prior EBIT: LTM EBIT: Latest Fiscal Year End D&A: Plus: Latest D&A:

NA $ $ $ NA -

K. L. M. N. O. P. Q. R. S. V. Multiples A. B. C. D. E. F. G. H. Footnotes: (a) (b) (c) (d) (e) (f) (g) (h) (i) (j)

Less: Prior D&A: LTM D&A: LTM EBITDA: Latest Fiscal Year Net Income: Plus: Latest Net Income: Less: Prior Net Income: LTM Net Income: Latest Book Value of Common Equity: Amount of Total Assets: TEV/LTM Revenues: TEV/LTM EBITDA: TEV/LTM EBIT: Equity Value/LTM Net Income: Price to FY1 Est. EPS Price to FY2 Est. EPS Price to FY3 Est. EPS Equity Value/Book Value: 0 0 0 0 0 0 0 0 0 0

$ NA $ $ $ NA NA NA

-

-

NA NA NA NA NA NA NA NA

Total Firm Sales

s

Options Table - Treasury Stock Method: 0 Number of Shares: (in millions) 0.000000 Net New Shares: (in millions)

Number of Options ### ###

Weighted Price

0 Convertible Debt / Preferred Stock Table: #NAME?
Convertible Debt:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Preferred Stock:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Latest Adj. EBIT: $ Operating Profit: $

Previous -

(enter footnotes below)

Latest Effective Tax Rate: Adj. Net Income: $ Income from Ops: Tax Effect: $ Sum of Extra: $ Note: Don't forget to add the extraordinary back for Net Income when backing out for EBIT be careful not to back out in EBIT any extraordinaries that affect only Net Income ! 40.0% $ $ $

Previous 40.0% -

Latest CapEx Interest Expense 52 Week High 52 Week Low Segment Financials by Sales Sales

Other Financial Information Previous

Division

Percentage

Total Firm Sales

$0.0

0.0%

ethod: 0.000000

k Table: 0.00 Number of Shares:

0.00 Number of Shares:

Annual $ -

Annual 40.0% $ $ $ -

Information Annual

Comparable Company Analysis

Check for New 10K
10K Latest Info
I. Summary Information A. Company Name: B. Industry: C. Description D. Fiscal Year End: E. Latest Quarter: F. Previous Quarter: G. FY1 Median Est. EPS H. I. FY2 Median Est. EPS FY3 Median Est. EPS 0

J.

LT I/B/E/S EPS Growth Rate:

NA

II. Equity Value A. Current Shares Outstanding: (Fully Diluted: 0-No,1-Yes) B. Current Share Price: C. Market Value of Equity: III. Total Enterprise Value: A. Short-term debt: B. C. D. E. F. G. H. I. Long-term debt: Minority Interest: Preferred Stock: Total Debt Outstanding: Less: Cash and Equivalents: Net Debt (E-F): Market Value of Equity: Total Enterprise Value (G+H):

NA NA NA

$ $ NA NA

-

IV. Financial Data A. Latest Fiscal Year End Revenues: B. Plus: Latest Revenues: C. Less: Prior Revenues: D. LTM Revenues: E. F. G. H. I. J. Latest Fiscal Year End EBIT: Plus: Latest EBIT: Less: Prior EBIT: LTM EBIT: Latest Fiscal Year End D&A: Plus: Latest D&A:

NA $ $ $ NA -

K. L. M. N. O. P. Q. R. S. V. Multiples A. B. C. D. E. F. G. H. Footnotes: (a) (b) (c) (d) (e) (f) (g) (h) (i) (j)

Less: Prior D&A: LTM D&A: LTM EBITDA: Latest Fiscal Year Net Income: Plus: Latest Net Income: Less: Prior Net Income: LTM Net Income: Latest Book Value of Common Equity: Amount of Total Assets: TEV/LTM Revenues: TEV/LTM EBITDA: TEV/LTM EBIT: Equity Value/LTM Net Income: Price to FY1 Est. EPS Price to FY2 Est. EPS Price to FY3 Est. EPS Equity Value/Book Value: 0 0 0 0 0 0 0 0 0 0

$ NA $ $ $ NA NA NA

-

-

NA NA NA NA NA NA NA NA

Total Firm Sales

s

Options Table - Treasury Stock Method: 0 Number of Shares: (in millions) 0.000000 Net New Shares: (in millions)

Number of Options ### ###

Weighted Price

0 Convertible Debt / Preferred Stock Table: #NAME?
Convertible Debt:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Preferred Stock:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Latest Adj. EBIT: $ Operating Profit: $

Previous -

(enter footnotes below)

Latest Effective Tax Rate: Adj. Net Income: $ Income from Ops: Tax Effect: $ Sum of Extra: $ Note: Don't forget to add the extraordinary back for Net Income when backing out for EBIT be careful not to back out in EBIT any extraordinaries that affect only Net Income ! 40.0% $ $ $

Previous 40.0% -

Latest CapEx Interest Expense 52 Week High 52 Week Low Segment Financials by Sales Sales

Other Financial Information Previous

Division

Percentage

Total Firm Sales

$0.0

0.0%

ethod: 0.000000

k Table: 0.00 Number of Shares:

0.00 Number of Shares:

Annual $ -

Annual 40.0% $ $ $ -

Information Annual

Comparable Company Analysis

Check for New 10K
10K Latest Info
I. Summary Information A. Company Name: B. Industry: C. Description D. Fiscal Year End: E. Latest Quarter: F. Previous Quarter: G. FY1 Median Est. EPS H. I. FY2 Median Est. EPS FY3 Median Est. EPS 0

J.

LT I/B/E/S EPS Growth Rate:

NA

II. Equity Value A. Current Shares Outstanding: (Fully Diluted: 0-No,1-Yes) B. Current Share Price: C. Market Value of Equity: III. Total Enterprise Value: A. Short-term debt: B. C. D. E. F. G. H. I. Long-term debt: Minority Interest: Preferred Stock: Total Debt Outstanding: Less: Cash and Equivalents: Net Debt (E-F): Market Value of Equity: Total Enterprise Value (G+H):

NA NA NA

$ $ NA NA

-

IV. Financial Data A. Latest Fiscal Year End Revenues: B. Plus: Latest Revenues: C. Less: Prior Revenues: D. LTM Revenues: E. F. G. H. I. J. Latest Fiscal Year End EBIT: Plus: Latest EBIT: Less: Prior EBIT: LTM EBIT: Latest Fiscal Year End D&A: Plus: Latest D&A:

NA $ $ $ NA -

K. L. M. N. O. P. Q. R. S. V. Multiples A. B. C. D. E. F. G. H. Footnotes: (a) (b) (c) (d) (e) (f) (g) (h) (i) (j)

Less: Prior D&A: LTM D&A: LTM EBITDA: Latest Fiscal Year Net Income: Plus: Latest Net Income: Less: Prior Net Income: LTM Net Income: Latest Book Value of Common Equity: Amount of Total Assets: TEV/LTM Revenues: TEV/LTM EBITDA: TEV/LTM EBIT: Equity Value/LTM Net Income: Price to FY1 Est. EPS Price to FY2 Est. EPS Price to FY3 Est. EPS Equity Value/Book Value: 0 0 0 0 0 0 0 0 0 0

$ NA $ $ $ NA NA NA

-

-

NA NA NA NA NA NA NA NA

Total Firm Sales

s

Options Table - Treasury Stock Method: 0 Number of Shares: (in millions) 0.000000 Net New Shares: (in millions)

Number of Options ### ###

Weighted Price

0 Convertible Debt / Preferred Stock Table: #NAME?
Convertible Debt:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Preferred Stock:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Latest Adj. EBIT: $ Operating Profit: $

Previous -

(enter footnotes below)

Latest Effective Tax Rate: Adj. Net Income: $ Income from Ops: Tax Effect: $ Sum of Extra: $ Note: Don't forget to add the extraordinary back for Net Income when backing out for EBIT be careful not to back out in EBIT any extraordinaries that affect only Net Income ! 40.0% $ $ $

Previous 40.0% -

Latest CapEx Interest Expense 52 Week High 52 Week Low Segment Financials by Sales Sales

Other Financial Information Previous

Division

Percentage

Total Firm Sales

$0.0

0.0%

ethod: 0.000000

k Table: 0.00 Number of Shares:

0.00 Number of Shares:

Annual $ -

Annual 40.0% $ $ $ -

Information Annual

Comparable Company Analysis

Check for New 10K
10K Latest Info
I. Summary Information A. Company Name: B. Industry: C. Description D. Fiscal Year End: E. Latest Quarter: F. Previous Quarter: G. FY1 Median Est. EPS H. I. FY2 Median Est. EPS FY3 Median Est. EPS 0

J.

LT I/B/E/S EPS Growth Rate:

NA

II. Equity Value A. Current Shares Outstanding: (Fully Diluted: 0-No,1-Yes) B. Current Share Price: C. Market Value of Equity: III. Total Enterprise Value: A. Short-term debt: B. C. D. E. F. G. H. I. Long-term debt: Minority Interest: Preferred Stock: Total Debt Outstanding: Less: Cash and Equivalents: Net Debt (E-F): Market Value of Equity: Total Enterprise Value (G+H):

NA NA NA

$ $ NA NA

-

IV. Financial Data A. Latest Fiscal Year End Revenues: B. Plus: Latest Revenues: C. Less: Prior Revenues: D. LTM Revenues: E. F. G. H. I. J. Latest Fiscal Year End EBIT: Plus: Latest EBIT: Less: Prior EBIT: LTM EBIT: Latest Fiscal Year End D&A: Plus: Latest D&A:

NA $ $ $ NA -

K. L. M. N. O. P. Q. R. S. V. Multiples A. B. C. D. E. F. G. H. Footnotes: (a) (b) (c) (d) (e) (f) (g) (h) (i) (j)

Less: Prior D&A: LTM D&A: LTM EBITDA: Latest Fiscal Year Net Income: Plus: Latest Net Income: Less: Prior Net Income: LTM Net Income: Latest Book Value of Common Equity: Amount of Total Assets: TEV/LTM Revenues: TEV/LTM EBITDA: TEV/LTM EBIT: Equity Value/LTM Net Income: Price to FY1 Est. EPS Price to FY2 Est. EPS Price to FY3 Est. EPS Equity Value/Book Value: 0 0 0 0 0 0 0 0 0 0

$ NA $ $ $ NA NA NA

-

-

NA NA NA NA NA NA NA NA

Total Firm Sales

s

Options Table - Treasury Stock Method: 0 Number of Shares: (in millions) 0.000000 Net New Shares: (in millions)

Number of Options ### ###

Weighted Price

0 Convertible Debt / Preferred Stock Table: #NAME?
Convertible Debt:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Preferred Stock:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Latest Adj. EBIT: $ Operating Profit: $

Previous -

(enter footnotes below)

Latest Effective Tax Rate: Adj. Net Income: $ Income from Ops: Tax Effect: $ Sum of Extra: $ Note: Don't forget to add the extraordinary back for Net Income when backing out for EBIT be careful not to back out in EBIT any extraordinaries that affect only Net Income ! 40.0% $ $ $

Previous 40.0% -

Latest CapEx Interest Expense 52 Week High 52 Week Low Segment Financials by Sales Sales

Other Financial Information Previous

Division

Percentage

Total Firm Sales

$0.0

0.0%

ethod: 0.000000

k Table: 0.00 Number of Shares:

0.00 Number of Shares:

Annual $ -

Annual 40.0% $ $ $ -

Information Annual

Comparable Company Analysis

Check for New 10K
10K Latest Info
I. Summary Information A. Company Name: B. Industry: C. Description D. Fiscal Year End: E. Latest Quarter: F. Previous Quarter: G. FY1 Median Est. EPS H. I. FY2 Median Est. EPS FY3 Median Est. EPS 0

J.

LT I/B/E/S EPS Growth Rate:

NA

II. Equity Value A. Current Shares Outstanding: (Fully Diluted: 0-No,1-Yes) B. Current Share Price: C. Market Value of Equity: III. Total Enterprise Value: A. Short-term debt: B. C. D. E. F. G. H. I. Long-term debt: Minority Interest: Preferred Stock: Total Debt Outstanding: Less: Cash and Equivalents: Net Debt (E-F): Market Value of Equity: Total Enterprise Value (G+H):

NA NA NA

$ $ NA NA

-

IV. Financial Data A. Latest Fiscal Year End Revenues: B. Plus: Latest Revenues: C. Less: Prior Revenues: D. LTM Revenues: E. F. G. H. I. J. Latest Fiscal Year End EBIT: Plus: Latest EBIT: Less: Prior EBIT: LTM EBIT: Latest Fiscal Year End D&A: Plus: Latest D&A:

NA $ $ $ NA -

K. L. M. N. O. P. Q. R. S. V. Multiples A. B. C. D. E. F. G. H. Footnotes: (a) (b) (c) (d) (e) (f) (g) (h) (i) (j)

Less: Prior D&A: LTM D&A: LTM EBITDA: Latest Fiscal Year Net Income: Plus: Latest Net Income: Less: Prior Net Income: LTM Net Income: Latest Book Value of Common Equity: Amount of Total Assets: TEV/LTM Revenues: TEV/LTM EBITDA: TEV/LTM EBIT: Equity Value/LTM Net Income: Price to FY1 Est. EPS Price to FY2 Est. EPS Price to FY3 Est. EPS Equity Value/Book Value: 0 0 0 0 0 0 0 0 0 0

$ NA $ $ $ NA NA NA

-

-

NA NA NA NA NA NA NA NA

Total Firm Sales

s

Options Table - Treasury Stock Method: 0 Number of Shares: (in millions) 0.000000 Net New Shares: (in millions)

Number of Options ### ###

Weighted Price

0 Convertible Debt / Preferred Stock Table: #NAME?
Convertible Debt:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Preferred Stock:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Latest Adj. EBIT: $ Operating Profit: $

Previous -

(enter footnotes below)

Latest Effective Tax Rate: Adj. Net Income: $ Income from Ops: Tax Effect: $ Sum of Extra: $ Note: Don't forget to add the extraordinary back for Net Income when backing out for EBIT be careful not to back out in EBIT any extraordinaries that affect only Net Income ! 40.0% $ $ $

Previous 40.0% -

Latest CapEx Interest Expense 52 Week High 52 Week Low Segment Financials by Sales Sales

Other Financial Information Previous

Division

Percentage

Total Firm Sales

$0.0

0.0%

ethod: 0.000000

k Table: 0.00 Number of Shares:

0.00 Number of Shares:

Annual $ -

Annual 40.0% $ $ $ -

Information Annual

Comparable Company Analysis

Check for New 10K
10K Latest Info
I. Summary Information A. Company Name: B. Industry: C. Description D. Fiscal Year End: E. Latest Quarter: F. Previous Quarter: G. FY1 Median Est. EPS H. I. FY2 Median Est. EPS FY3 Median Est. EPS 0

J.

LT I/B/E/S EPS Growth Rate:

NA

II. Equity Value A. Current Shares Outstanding: (Fully Diluted: 0-No,1-Yes) B. Current Share Price: C. Market Value of Equity: III. Total Enterprise Value: A. Short-term debt: B. C. D. E. F. G. H. I. Long-term debt: Minority Interest: Preferred Stock: Total Debt Outstanding: Less: Cash and Equivalents: Net Debt (E-F): Market Value of Equity: Total Enterprise Value (G+H):

NA NA NA

$ $ NA NA

-

IV. Financial Data A. Latest Fiscal Year End Revenues: B. Plus: Latest Revenues: C. Less: Prior Revenues: D. LTM Revenues: E. F. G. H. I. J. Latest Fiscal Year End EBIT: Plus: Latest EBIT: Less: Prior EBIT: LTM EBIT: Latest Fiscal Year End D&A: Plus: Latest D&A:

NA $ $ $ NA -

K. L. M. N. O. P. Q. R. S. V. Multiples A. B. C. D. E. F. G. H. Footnotes: (a) (b) (c) (d) (e) (f) (g) (h) (i) (j)

Less: Prior D&A: LTM D&A: LTM EBITDA: Latest Fiscal Year Net Income: Plus: Latest Net Income: Less: Prior Net Income: LTM Net Income: Latest Book Value of Common Equity: Amount of Total Assets: TEV/LTM Revenues: TEV/LTM EBITDA: TEV/LTM EBIT: Equity Value/LTM Net Income: Price to FY1 Est. EPS Price to FY2 Est. EPS Price to FY3 Est. EPS Equity Value/Book Value: 0 0 0 0 0 0 0 0 0 0

$ NA $ $ $ NA NA NA

-

-

NA NA NA NA NA NA NA NA

Total Firm Sales

s

Options Table - Treasury Stock Method: 0 Number of Shares: (in millions) 0.000000 Net New Shares: (in millions)

Number of Options ### ###

Weighted Price

0 Convertible Debt / Preferred Stock Table: #NAME?
Convertible Debt:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Preferred Stock:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Latest Adj. EBIT: $ Operating Profit: $

Previous -

(enter footnotes below)

Latest Effective Tax Rate: Adj. Net Income: $ Income from Ops: Tax Effect: $ Sum of Extra: $ Note: Don't forget to add the extraordinary back for Net Income when backing out for EBIT be careful not to back out in EBIT any extraordinaries that affect only Net Income ! 40.0% $ $ $

Previous 40.0% -

Latest CapEx Interest Expense 52 Week High 52 Week Low Segment Financials by Sales Sales

Other Financial Information Previous

Division

Percentage

Total Firm Sales

$0.0

0.0%

ethod: 0.000000

k Table: 0.00 Number of Shares:

0.00 Number of Shares:

Annual $ -

Annual 40.0% $ $ $ -

Information Annual

Comparable Company Analysis

Check for New 10K
10K Latest Info
I. Summary Information A. Company Name: B. Industry: C. Description D. Fiscal Year End: E. Latest Quarter: F. Previous Quarter: G. FY1 Median Est. EPS H. I. FY2 Median Est. EPS FY3 Median Est. EPS 0

J.

LT I/B/E/S EPS Growth Rate:

NA

II. Equity Value A. Current Shares Outstanding: (Fully Diluted: 0-No,1-Yes) B. Current Share Price: C. Market Value of Equity: III. Total Enterprise Value: A. Short-term debt: B. C. D. E. F. G. H. I. Long-term debt: Minority Interest: Preferred Stock: Total Debt Outstanding: Less: Cash and Equivalents: Net Debt (E-F): Market Value of Equity: Total Enterprise Value (G+H):

NA NA NA

$ $ NA NA

-

IV. Financial Data A. Latest Fiscal Year End Revenues: B. Plus: Latest Revenues: C. Less: Prior Revenues: D. LTM Revenues: E. F. G. H. I. J. Latest Fiscal Year End EBIT: Plus: Latest EBIT: Less: Prior EBIT: LTM EBIT: Latest Fiscal Year End D&A: Plus: Latest D&A:

NA $ $ $ NA -

K. L. M. N. O. P. Q. R. S. V. Multiples A. B. C. D. E. F. G. H. Footnotes: (a) (b) (c) (d) (e) (f) (g) (h) (i) (j)

Less: Prior D&A: LTM D&A: LTM EBITDA: Latest Fiscal Year Net Income: Plus: Latest Net Income: Less: Prior Net Income: LTM Net Income: Latest Book Value of Common Equity: Amount of Total Assets: TEV/LTM Revenues: TEV/LTM EBITDA: TEV/LTM EBIT: Equity Value/LTM Net Income: Price to FY1 Est. EPS Price to FY2 Est. EPS Price to FY3 Est. EPS Equity Value/Book Value: 0 0 0 0 0 0 0 0 0 0

$ NA $ $ $ NA NA NA

-

-

NA NA NA NA NA NA NA NA

Total Firm Sales

s

Options Table - Treasury Stock Method: 0 Number of Shares: (in millions) 0.000000 Net New Shares: (in millions)

Number of Options ### ###

Weighted Price

0 Convertible Debt / Preferred Stock Table: #NAME?
Convertible Debt:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Preferred Stock:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Latest Adj. EBIT: $ Operating Profit: $

Previous -

(enter footnotes below)

Latest Effective Tax Rate: Adj. Net Income: $ Income from Ops: Tax Effect: $ Sum of Extra: $ Note: Don't forget to add the extraordinary back for Net Income when backing out for EBIT be careful not to back out in EBIT any extraordinaries that affect only Net Income ! 40.0% $ $ $

Previous 40.0% -

Latest CapEx Interest Expense 52 Week High 52 Week Low Segment Financials by Sales Sales

Other Financial Information Previous

Division

Percentage

Total Firm Sales

$0.0

0.0%

ethod: 0.000000

k Table: 0.00 Number of Shares:

0.00 Number of Shares:

Annual $ -

Annual 40.0% $ $ $ -

Information Annual

Comparable Company Analysis

Check for New 10K
10K Latest Info
I. Summary Information A. Company Name: B. Industry: C. Description D. Fiscal Year End: E. Latest Quarter: F. Previous Quarter: G. FY1 Median Est. EPS H. I. FY2 Median Est. EPS FY3 Median Est. EPS 0

J.

LT I/B/E/S EPS Growth Rate:

NA

II. Equity Value A. Current Shares Outstanding: (Fully Diluted: 0-No,1-Yes) B. Current Share Price: C. Market Value of Equity: III. Total Enterprise Value: A. Short-term debt: B. C. D. E. F. G. H. I. Long-term debt: Minority Interest: Preferred Stock: Total Debt Outstanding: Less: Cash and Equivalents: Net Debt (E-F): Market Value of Equity: Total Enterprise Value (G+H):

NA NA NA

$ $ NA NA

-

IV. Financial Data A. Latest Fiscal Year End Revenues: B. Plus: Latest Revenues: C. Less: Prior Revenues: D. LTM Revenues: E. F. G. H. I. J. Latest Fiscal Year End EBIT: Plus: Latest EBIT: Less: Prior EBIT: LTM EBIT: Latest Fiscal Year End D&A: Plus: Latest D&A:

NA $ $ $ NA -

K. L. M. N. O. P. Q. R. S. V. Multiples A. B. C. D. E. F. G. H. Footnotes: (a) (b) (c) (d) (e) (f) (g) (h) (i) (j)

Less: Prior D&A: LTM D&A: LTM EBITDA: Latest Fiscal Year Net Income: Plus: Latest Net Income: Less: Prior Net Income: LTM Net Income: Latest Book Value of Common Equity: Amount of Total Assets: TEV/LTM Revenues: TEV/LTM EBITDA: TEV/LTM EBIT: Equity Value/LTM Net Income: Price to FY1 Est. EPS Price to FY2 Est. EPS Price to FY3 Est. EPS Equity Value/Book Value: 0 0 0 0 0 0 0 0 0 0

$ NA $ $ $ NA NA NA

-

-

NA NA NA NA NA NA NA NA

Total Firm Sales

s

Options Table - Treasury Stock Method: 0 Number of Shares: (in millions) 0.000000 Net New Shares: (in millions)

Number of Options ### ###

Weighted Price

0 Convertible Debt / Preferred Stock Table: #NAME?
Convertible Debt:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Preferred Stock:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Latest Adj. EBIT: $ Operating Profit: $

Previous -

(enter footnotes below)

Latest Effective Tax Rate: Adj. Net Income: $ Income from Ops: Tax Effect: $ Sum of Extra: $ Note: Don't forget to add the extraordinary back for Net Income when backing out for EBIT be careful not to back out in EBIT any extraordinaries that affect only Net Income ! 40.0% $ $ $

Previous 40.0% -

Latest CapEx Interest Expense 52 Week High 52 Week Low Segment Financials by Sales Sales

Other Financial Information Previous

Division

Percentage

Total Firm Sales

$0.0

0.0%

ethod: 0.000000

k Table: 0.00 Number of Shares:

0.00 Number of Shares:

Annual $ -

Annual 40.0% $ $ $ -

Information Annual

Comparable Company Analysis

Check for New 10K
10K Latest Info
I. Summary Information A. Company Name: B. Industry: C. Description D. Fiscal Year End: E. Latest Quarter: F. Previous Quarter: G. FY1 Median Est. EPS H. I. FY2 Median Est. EPS FY3 Median Est. EPS 0

J.

LT I/B/E/S EPS Growth Rate:

NA

II. Equity Value A. Current Shares Outstanding: (Fully Diluted: 0-No,1-Yes) B. Current Share Price: C. Market Value of Equity: III. Total Enterprise Value: A. Short-term debt: B. C. D. E. F. G. H. I. Long-term debt: Minority Interest: Preferred Stock: Total Debt Outstanding: Less: Cash and Equivalents: Net Debt (E-F): Market Value of Equity: Total Enterprise Value (G+H):

NA NA NA

$ $ NA NA

-

IV. Financial Data A. Latest Fiscal Year End Revenues: B. Plus: Latest Revenues: C. Less: Prior Revenues: D. LTM Revenues: E. F. G. H. I. J. Latest Fiscal Year End EBIT: Plus: Latest EBIT: Less: Prior EBIT: LTM EBIT: Latest Fiscal Year End D&A: Plus: Latest D&A:

NA $ $ $ NA -

K. L. M. N. O. P. Q. R. S. V. Multiples A. B. C. D. E. F. G. H. Footnotes: (a) (b) (c) (d) (e) (f) (g) (h) (i) (j)

Less: Prior D&A: LTM D&A: LTM EBITDA: Latest Fiscal Year Net Income: Plus: Latest Net Income: Less: Prior Net Income: LTM Net Income: Latest Book Value of Common Equity: Amount of Total Assets: TEV/LTM Revenues: TEV/LTM EBITDA: TEV/LTM EBIT: Equity Value/LTM Net Income: Price to FY1 Est. EPS Price to FY2 Est. EPS Price to FY3 Est. EPS Equity Value/Book Value: 0 0 0 0 0 0 0 0 0 0

$ NA $ $ $ NA NA NA

-

-

NA NA NA NA NA NA NA NA

Total Firm Sales

s

Options Table - Treasury Stock Method: 0 Number of Shares: (in millions) 0.000000 Net New Shares: (in millions)

Number of Options ### ###

Weighted Price

0 Convertible Debt / Preferred Stock Table: #NAME?
Convertible Debt:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Preferred Stock:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Latest Adj. EBIT: $ Operating Profit: $

Previous -

(enter footnotes below)

Latest Effective Tax Rate: Adj. Net Income: $ Income from Ops: Tax Effect: $ Sum of Extra: $ Note: Don't forget to add the extraordinary back for Net Income when backing out for EBIT be careful not to back out in EBIT any extraordinaries that affect only Net Income ! 40.0% $ $ $

Previous 40.0% -

Latest CapEx Interest Expense 52 Week High 52 Week Low Segment Financials by Sales Sales

Other Financial Information Previous

Division

Percentage

Total Firm Sales

$0.0

0.0%

ethod: 0.000000

k Table: 0.00 Number of Shares:

0.00 Number of Shares:

Annual $ -

Annual 40.0% $ $ $ -

Information Annual

Comparable Company Analysis

Check for New 10K
10K Latest Info
I. Summary Information A. Company Name: B. Industry: C. Description D. Fiscal Year End: E. Latest Quarter: F. Previous Quarter: G. FY1 Median Est. EPS H. I. FY2 Median Est. EPS FY3 Median Est. EPS 0

J.

LT I/B/E/S EPS Growth Rate:

NA

II. Equity Value A. Current Shares Outstanding: (Fully Diluted: 0-No,1-Yes) B. Current Share Price: C. Market Value of Equity: III. Total Enterprise Value: A. Short-term debt: B. C. D. E. F. G. H. I. Long-term debt: Minority Interest: Preferred Stock: Total Debt Outstanding: Less: Cash and Equivalents: Net Debt (E-F): Market Value of Equity: Total Enterprise Value (G+H):

NA NA NA

$ $ NA NA

-

IV. Financial Data A. Latest Fiscal Year End Revenues: B. Plus: Latest Revenues: C. Less: Prior Revenues: D. LTM Revenues: E. F. G. H. I. J. Latest Fiscal Year End EBIT: Plus: Latest EBIT: Less: Prior EBIT: LTM EBIT: Latest Fiscal Year End D&A: Plus: Latest D&A:

NA $ $ $ NA -

K. L. M. N. O. P. Q. R. S. V. Multiples A. B. C. D. E. F. G. H. Footnotes: (a) (b) (c) (d) (e) (f) (g) (h) (i) (j)

Less: Prior D&A: LTM D&A: LTM EBITDA: Latest Fiscal Year Net Income: Plus: Latest Net Income: Less: Prior Net Income: LTM Net Income: Latest Book Value of Common Equity: Amount of Total Assets: TEV/LTM Revenues: TEV/LTM EBITDA: TEV/LTM EBIT: Equity Value/LTM Net Income: Price to FY1 Est. EPS Price to FY2 Est. EPS Price to FY3 Est. EPS Equity Value/Book Value: 0 0 0 0 0 0 0 0 0 0

$ NA $ $ $ NA NA NA

-

-

NA NA NA NA NA NA NA NA

Total Firm Sales

s

Options Table - Treasury Stock Method: 0 Number of Shares: (in millions) 0.000000 Net New Shares: (in millions)

Number of Options ### ###

Weighted Price

0 Convertible Debt / Preferred Stock Table: #NAME?
Convertible Debt:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Preferred Stock:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Latest Adj. EBIT: $ Operating Profit: $

Previous -

(enter footnotes below)

Latest Effective Tax Rate: Adj. Net Income: $ Income from Ops: Tax Effect: $ Sum of Extra: $ Note: Don't forget to add the extraordinary back for Net Income when backing out for EBIT be careful not to back out in EBIT any extraordinaries that affect only Net Income ! 40.0% $ $ $

Previous 40.0% -

Latest CapEx Interest Expense 52 Week High 52 Week Low Segment Financials by Sales Sales

Other Financial Information Previous

Division

Percentage

Total Firm Sales

$0.0

0.0%

ethod: 0.000000

k Table: 0.00 Number of Shares:

0.00 Number of Shares:

Annual $ -

Annual 40.0% $ $ $ -

Information Annual

Comparable Company Analysis

Check for New 10K
10K Latest Info
I. Summary Information A. Company Name: B. Industry: C. Description D. Fiscal Year End: E. Latest Quarter: F. Previous Quarter: G. FY1 Median Est. EPS H. I. FY2 Median Est. EPS FY3 Median Est. EPS 0

J.

LT I/B/E/S EPS Growth Rate:

NA

II. Equity Value A. Current Shares Outstanding: (Fully Diluted: 0-No,1-Yes) B. Current Share Price: C. Market Value of Equity: III. Total Enterprise Value: A. Short-term debt: B. C. D. E. F. G. H. I. Long-term debt: Minority Interest: Preferred Stock: Total Debt Outstanding: Less: Cash and Equivalents: Net Debt (E-F): Market Value of Equity: Total Enterprise Value (G+H):

NA NA NA

$ $ NA NA

-

IV. Financial Data A. Latest Fiscal Year End Revenues: B. Plus: Latest Revenues: C. Less: Prior Revenues: D. LTM Revenues: E. F. G. H. I. J. Latest Fiscal Year End EBIT: Plus: Latest EBIT: Less: Prior EBIT: LTM EBIT: Latest Fiscal Year End D&A: Plus: Latest D&A:

NA $ $ $ NA -

K. L. M. N. O. P. Q. R. S. V. Multiples A. B. C. D. E. F. G. H. Footnotes: (a) (b) (c) (d) (e) (f) (g) (h) (i) (j)

Less: Prior D&A: LTM D&A: LTM EBITDA: Latest Fiscal Year Net Income: Plus: Latest Net Income: Less: Prior Net Income: LTM Net Income: Latest Book Value of Common Equity: Amount of Total Assets: TEV/LTM Revenues: TEV/LTM EBITDA: TEV/LTM EBIT: Equity Value/LTM Net Income: Price to FY1 Est. EPS Price to FY2 Est. EPS Price to FY3 Est. EPS Equity Value/Book Value: 0 0 0 0 0 0 0 0 0 0

$ NA $ $ $ NA NA NA

-

-

NA NA NA NA NA NA NA NA

Total Firm Sales

s

Options Table - Treasury Stock Method: 0 Number of Shares: (in millions) 0.000000 Net New Shares: (in millions)

Number of Options ### ###

Weighted Price

0 Convertible Debt / Preferred Stock Table: #NAME?
Convertible Debt:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Preferred Stock:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Latest Adj. EBIT: $ Operating Profit: $

Previous -

(enter footnotes below)

Latest Effective Tax Rate: Adj. Net Income: $ Income from Ops: Tax Effect: $ Sum of Extra: $ Note: Don't forget to add the extraordinary back for Net Income when backing out for EBIT be careful not to back out in EBIT any extraordinaries that affect only Net Income ! 40.0% $ $ $

Previous 40.0% -

Latest CapEx Interest Expense 52 Week High 52 Week Low Segment Financials by Sales Sales

Other Financial Information Previous

Division

Percentage

Total Firm Sales

$0.0

0.0%

ethod: 0.000000

k Table: 0.00 Number of Shares:

0.00 Number of Shares:

Annual $ -

Annual 40.0% $ $ $ -

Information Annual

Comparable Company Analysis

Check for New 10K
10K Latest Info
I. Summary Information A. Company Name: B. Industry: C. Description D. Fiscal Year End: E. Latest Quarter: F. Previous Quarter: G. FY1 Median Est. EPS H. I. FY2 Median Est. EPS FY3 Median Est. EPS 0

J.

LT I/B/E/S EPS Growth Rate:

NA

II. Equity Value A. Current Shares Outstanding: (Fully Diluted: 0-No,1-Yes) B. Current Share Price: C. Market Value of Equity: III. Total Enterprise Value: A. Short-term debt: B. C. D. E. F. G. H. I. Long-term debt: Minority Interest: Preferred Stock: Total Debt Outstanding: Less: Cash and Equivalents: Net Debt (E-F): Market Value of Equity: Total Enterprise Value (G+H):

NA NA NA

$ $ NA NA

-

IV. Financial Data A. Latest Fiscal Year End Revenues: B. Plus: Latest Revenues: C. Less: Prior Revenues: D. LTM Revenues: E. F. G. H. I. J. Latest Fiscal Year End EBIT: Plus: Latest EBIT: Less: Prior EBIT: LTM EBIT: Latest Fiscal Year End D&A: Plus: Latest D&A:

NA $ $ $ NA -

K. L. M. N. O. P. Q. R. S. V. Multiples A. B. C. D. E. F. G. H. Footnotes: (a) (b) (c) (d) (e) (f) (g) (h) (i) (j)

Less: Prior D&A: LTM D&A: LTM EBITDA: Latest Fiscal Year Net Income: Plus: Latest Net Income: Less: Prior Net Income: LTM Net Income: Latest Book Value of Common Equity: Amount of Total Assets: TEV/LTM Revenues: TEV/LTM EBITDA: TEV/LTM EBIT: Equity Value/LTM Net Income: Price to FY1 Est. EPS Price to FY2 Est. EPS Price to FY3 Est. EPS Equity Value/Book Value: 0 0 0 0 0 0 0 0 0 0

$ NA $ $ $ NA NA NA

-

-

NA NA NA NA NA NA NA NA

Total Firm Sales

s

Options Table - Treasury Stock Method: 0 Number of Shares: (in millions) 0.000000 Net New Shares: (in millions)

Number of Options ### ###

Weighted Price

0 Convertible Debt / Preferred Stock Table: #NAME?
Convertible Debt:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Preferred Stock:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Latest Adj. EBIT: $ Operating Profit: $

Previous -

(enter footnotes below)

Latest Effective Tax Rate: Adj. Net Income: $ Income from Ops: Tax Effect: $ Sum of Extra: $ Note: Don't forget to add the extraordinary back for Net Income when backing out for EBIT be careful not to back out in EBIT any extraordinaries that affect only Net Income ! 40.0% $ $ $

Previous 40.0% -

Latest CapEx Interest Expense 52 Week High 52 Week Low Segment Financials by Sales Sales

Other Financial Information Previous

Division

Percentage

Total Firm Sales

$0.0

0.0%

ethod: 0.000000

k Table: 0.00 Number of Shares:

0.00 Number of Shares:

Annual $ -

Annual 40.0% $ $ $ -

Information Annual

Comparable Company Analysis

Check for New 10K
10K Latest Info
I. Summary Information A. Company Name: B. Industry: C. Description D. Fiscal Year End: E. Latest Quarter: F. Previous Quarter: G. FY1 Median Est. EPS H. I. FY2 Median Est. EPS FY3 Median Est. EPS 0

J.

LT I/B/E/S EPS Growth Rate:

NA

II. Equity Value A. Current Shares Outstanding: (Fully Diluted: 0-No,1-Yes) B. Current Share Price: C. Market Value of Equity: III. Total Enterprise Value: A. Short-term debt: B. C. D. E. F. G. H. I. Long-term debt: Minority Interest: Preferred Stock: Total Debt Outstanding: Less: Cash and Equivalents: Net Debt (E-F): Market Value of Equity: Total Enterprise Value (G+H):

NA NA NA

$ $ NA NA

-

IV. Financial Data A. Latest Fiscal Year End Revenues: B. Plus: Latest Revenues: C. Less: Prior Revenues: D. LTM Revenues: E. F. G. H. I. J. Latest Fiscal Year End EBIT: Plus: Latest EBIT: Less: Prior EBIT: LTM EBIT: Latest Fiscal Year End D&A: Plus: Latest D&A:

NA $ $ $ NA -

K. L. M. N. O. P. Q. R. S. V. Multiples A. B. C. D. E. F. G. H. Footnotes: (a) (b) (c) (d) (e) (f) (g) (h) (i) (j)

Less: Prior D&A: LTM D&A: LTM EBITDA: Latest Fiscal Year Net Income: Plus: Latest Net Income: Less: Prior Net Income: LTM Net Income: Latest Book Value of Common Equity: Amount of Total Assets: TEV/LTM Revenues: TEV/LTM EBITDA: TEV/LTM EBIT: Equity Value/LTM Net Income: Price to FY1 Est. EPS Price to FY2 Est. EPS Price to FY3 Est. EPS Equity Value/Book Value: 0 0 0 0 0 0 0 0 0 0

$ NA $ $ $ NA NA NA

-

-

NA NA NA NA NA NA NA NA

Total Firm Sales

s

Options Table - Treasury Stock Method: 0 Number of Shares: (in millions) 0.000000 Net New Shares: (in millions)

Number of Options ### ###

Weighted Price

0 Convertible Debt / Preferred Stock Table: #NAME?
Convertible Debt:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Preferred Stock:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Latest Adj. EBIT: $ Operating Profit: $

Previous -

(enter footnotes below)

Latest Effective Tax Rate: Adj. Net Income: $ Income from Ops: Tax Effect: $ Sum of Extra: $ Note: Don't forget to add the extraordinary back for Net Income when backing out for EBIT be careful not to back out in EBIT any extraordinaries that affect only Net Income ! 40.0% $ $ $

Previous 40.0% -

Latest CapEx Interest Expense 52 Week High 52 Week Low Segment Financials by Sales Sales

Other Financial Information Previous

Division

Percentage

Total Firm Sales

$0.0

0.0%

ethod: 0.000000

k Table: 0.00 Number of Shares:

0.00 Number of Shares:

Annual $ -

Annual 40.0% $ $ $ -

Information Annual

Comparable Company Analysis

Check for New 10K
10K Latest Info
I. Summary Information A. Company Name: B. Industry: C. Description D. Fiscal Year End: E. Latest Quarter: F. Previous Quarter: G. FY1 Median Est. EPS H. I. FY2 Median Est. EPS FY3 Median Est. EPS 0

J.

LT I/B/E/S EPS Growth Rate:

NA

II. Equity Value A. Current Shares Outstanding: (Fully Diluted: 0-No,1-Yes) B. Current Share Price: C. Market Value of Equity: III. Total Enterprise Value: A. Short-term debt: B. C. D. E. F. G. H. I. Long-term debt: Minority Interest: Preferred Stock: Total Debt Outstanding: Less: Cash and Equivalents: Net Debt (E-F): Market Value of Equity: Total Enterprise Value (G+H):

NA NA NA

$ $ NA NA

-

IV. Financial Data A. Latest Fiscal Year End Revenues: B. Plus: Latest Revenues: C. Less: Prior Revenues: D. LTM Revenues: E. F. G. H. I. J. Latest Fiscal Year End EBIT: Plus: Latest EBIT: Less: Prior EBIT: LTM EBIT: Latest Fiscal Year End D&A: Plus: Latest D&A:

NA $ $ $ NA -

K. L. M. N. O. P. Q. R. S. V. Multiples A. B. C. D. E. F. G. H. Footnotes: (a) (b) (c) (d) (e) (f) (g) (h) (i) (j)

Less: Prior D&A: LTM D&A: LTM EBITDA: Latest Fiscal Year Net Income: Plus: Latest Net Income: Less: Prior Net Income: LTM Net Income: Latest Book Value of Common Equity: Amount of Total Assets: TEV/LTM Revenues: TEV/LTM EBITDA: TEV/LTM EBIT: Equity Value/LTM Net Income: Price to FY1 Est. EPS Price to FY2 Est. EPS Price to FY3 Est. EPS Equity Value/Book Value: 0 0 0 0 0 0 0 0 0 0

$ NA $ $ $ NA NA NA

-

-

NA NA NA NA NA NA NA NA

Total Firm Sales

s

Options Table - Treasury Stock Method: 0 Number of Shares: (in millions) 0.000000 Net New Shares: (in millions)

Number of Options ### ###

Weighted Price

0 Convertible Debt / Preferred Stock Table: #NAME?
Convertible Debt:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Preferred Stock:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Latest Adj. EBIT: $ Operating Profit: $

Previous -

(enter footnotes below)

Latest Effective Tax Rate: Adj. Net Income: $ Income from Ops: Tax Effect: $ Sum of Extra: $ Note: Don't forget to add the extraordinary back for Net Income when backing out for EBIT be careful not to back out in EBIT any extraordinaries that affect only Net Income ! 40.0% $ $ $

Previous 40.0% -

Latest CapEx Interest Expense 52 Week High 52 Week Low Segment Financials by Sales Sales

Other Financial Information Previous

Division

Percentage

Total Firm Sales

$0.0

0.0%

ethod: 0.000000

k Table: 0.00 Number of Shares:

0.00 Number of Shares:

Annual $ -

Annual 40.0% $ $ $ -

Information Annual

Comparable Company Analysis

Check for New 10K
10K Latest Info
I. Summary Information A. Company Name: B. Industry: C. Description D. Fiscal Year End: E. Latest Quarter: F. Previous Quarter: G. FY1 Median Est. EPS H. I. FY2 Median Est. EPS FY3 Median Est. EPS 0

J.

LT I/B/E/S EPS Growth Rate:

NA

II. Equity Value A. Current Shares Outstanding: (Fully Diluted: 0-No,1-Yes) B. Current Share Price: C. Market Value of Equity: III. Total Enterprise Value: A. Short-term debt: B. C. D. E. F. G. H. I. Long-term debt: Minority Interest: Preferred Stock: Total Debt Outstanding: Less: Cash and Equivalents: Net Debt (E-F): Market Value of Equity: Total Enterprise Value (G+H):

NA NA NA

$ $ NA NA

-

IV. Financial Data A. Latest Fiscal Year End Revenues: B. Plus: Latest Revenues: C. Less: Prior Revenues: D. LTM Revenues: E. F. G. H. I. J. Latest Fiscal Year End EBIT: Plus: Latest EBIT: Less: Prior EBIT: LTM EBIT: Latest Fiscal Year End D&A: Plus: Latest D&A:

NA $ $ $ NA -

K. L. M. N. O. P. Q. R. S. V. Multiples A. B. C. D. E. F. G. H. Footnotes: (a) (b) (c) (d) (e) (f) (g) (h) (i) (j)

Less: Prior D&A: LTM D&A: LTM EBITDA: Latest Fiscal Year Net Income: Plus: Latest Net Income: Less: Prior Net Income: LTM Net Income: Latest Book Value of Common Equity: Amount of Total Assets: TEV/LTM Revenues: TEV/LTM EBITDA: TEV/LTM EBIT: Equity Value/LTM Net Income: Price to FY1 Est. EPS Price to FY2 Est. EPS Price to FY3 Est. EPS Equity Value/Book Value: 0 0 0 0 0 0 0 0 0 0

$ NA $ $ $ NA NA NA

-

-

NA NA NA NA NA NA NA NA

Total Firm Sales

s

Options Table - Treasury Stock Method: 0 Number of Shares: (in millions) 0.000000 Net New Shares: (in millions)

Number of Options ### ###

Weighted Price

0 Convertible Debt / Preferred Stock Table: #NAME?
Convertible Debt:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Preferred Stock:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Latest Adj. EBIT: $ Operating Profit: $

Previous -

(enter footnotes below)

Latest Effective Tax Rate: Adj. Net Income: $ Income from Ops: Tax Effect: $ Sum of Extra: $ Note: Don't forget to add the extraordinary back for Net Income when backing out for EBIT be careful not to back out in EBIT any extraordinaries that affect only Net Income ! 40.0% $ $ $

Previous 40.0% -

Latest CapEx Interest Expense 52 Week High 52 Week Low Segment Financials by Sales Sales

Other Financial Information Previous

Division

Percentage

Total Firm Sales

$0.0

0.0%

ethod: 0.000000

k Table: 0.00 Number of Shares:

0.00 Number of Shares:

Annual $ -

Annual 40.0% $ $ $ -

Information Annual

Comparable Company Analysis

Check for New 10K
10K Latest Info
I. Summary Information A. Company Name: B. Industry: C. Description D. Fiscal Year End: E. Latest Quarter: F. Previous Quarter: G. FY1 Median Est. EPS H. I. FY2 Median Est. EPS FY3 Median Est. EPS 0

J.

LT I/B/E/S EPS Growth Rate:

NA

II. Equity Value A. Current Shares Outstanding: (Fully Diluted: 0-No,1-Yes) B. Current Share Price: C. Market Value of Equity: III. Total Enterprise Value: A. Short-term debt: B. C. D. E. F. G. H. I. Long-term debt: Minority Interest: Preferred Stock: Total Debt Outstanding: Less: Cash and Equivalents: Net Debt (E-F): Market Value of Equity: Total Enterprise Value (G+H):

NA NA NA

$ $ NA NA

-

IV. Financial Data A. Latest Fiscal Year End Revenues: B. Plus: Latest Revenues: C. Less: Prior Revenues: D. LTM Revenues: E. F. G. H. I. J. Latest Fiscal Year End EBIT: Plus: Latest EBIT: Less: Prior EBIT: LTM EBIT: Latest Fiscal Year End D&A: Plus: Latest D&A:

NA $ $ $ NA -

K. L. M. N. O. P. Q. R. S. V. Multiples A. B. C. D. E. F. G. H. Footnotes: (a) (b) (c) (d) (e) (f) (g) (h) (i) (j)

Less: Prior D&A: LTM D&A: LTM EBITDA: Latest Fiscal Year Net Income: Plus: Latest Net Income: Less: Prior Net Income: LTM Net Income: Latest Book Value of Common Equity: Amount of Total Assets: TEV/LTM Revenues: TEV/LTM EBITDA: TEV/LTM EBIT: Equity Value/LTM Net Income: Price to FY1 Est. EPS Price to FY2 Est. EPS Price to FY3 Est. EPS Equity Value/Book Value: 0 0 0 0 0 0 0 0 0 0

$ NA $ $ $ NA NA NA

-

-

NA NA NA NA NA NA NA NA

Total Firm Sales

s

Options Table - Treasury Stock Method: 0 Number of Shares: (in millions) 0.000000 Net New Shares: (in millions)

Number of Options ### ###

Weighted Price

0 Convertible Debt / Preferred Stock Table: #NAME?
Convertible Debt:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Preferred Stock:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Latest Adj. EBIT: $ Operating Profit: $

Previous -

(enter footnotes below)

Latest Effective Tax Rate: Adj. Net Income: $ Income from Ops: Tax Effect: $ Sum of Extra: $ Note: Don't forget to add the extraordinary back for Net Income when backing out for EBIT be careful not to back out in EBIT any extraordinaries that affect only Net Income ! 40.0% $ $ $

Previous 40.0% -

Latest CapEx Interest Expense 52 Week High 52 Week Low Segment Financials by Sales Sales

Other Financial Information Previous

Division

Percentage

Total Firm Sales

$0.0

0.0%

ethod: 0.000000

k Table: 0.00 Number of Shares:

0.00 Number of Shares:

Annual $ -

Annual 40.0% $ $ $ -

Information Annual

Comparable Company Analysis

Check for New 10K
10K Latest Info
I. Summary Information A. Company Name: B. Industry: C. Description D. Fiscal Year End: E. Latest Quarter: F. Previous Quarter: G. FY1 Median Est. EPS H. I. FY2 Median Est. EPS FY3 Median Est. EPS 0

J.

LT I/B/E/S EPS Growth Rate:

NA

II. Equity Value A. Current Shares Outstanding: (Fully Diluted: 0-No,1-Yes) B. Current Share Price: C. Market Value of Equity: III. Total Enterprise Value: A. Short-term debt: B. C. D. E. F. G. H. I. Long-term debt: Minority Interest: Preferred Stock: Total Debt Outstanding: Less: Cash and Equivalents: Net Debt (E-F): Market Value of Equity: Total Enterprise Value (G+H):

NA NA NA

$ $ NA NA

-

IV. Financial Data A. Latest Fiscal Year End Revenues: B. Plus: Latest Revenues: C. Less: Prior Revenues: D. LTM Revenues: E. F. G. H. I. J. Latest Fiscal Year End EBIT: Plus: Latest EBIT: Less: Prior EBIT: LTM EBIT: Latest Fiscal Year End D&A: Plus: Latest D&A:

NA $ $ $ NA -

K. L. M. N. O. P. Q. R. S. V. Multiples A. B. C. D. E. F. G. H. Footnotes: (a) (b) (c) (d) (e) (f) (g) (h) (i) (j)

Less: Prior D&A: LTM D&A: LTM EBITDA: Latest Fiscal Year Net Income: Plus: Latest Net Income: Less: Prior Net Income: LTM Net Income: Latest Book Value of Common Equity: Amount of Total Assets: TEV/LTM Revenues: TEV/LTM EBITDA: TEV/LTM EBIT: Equity Value/LTM Net Income: Price to FY1 Est. EPS Price to FY2 Est. EPS Price to FY3 Est. EPS Equity Value/Book Value: 0 0 0 0 0 0 0 0 0 0

$ NA $ $ $ NA NA NA

-

-

NA NA NA NA NA NA NA NA

Total Firm Sales

s

Options Table - Treasury Stock Method: 0 Number of Shares: (in millions) 0.000000 Net New Shares: (in millions)

Number of Options ### ###

Weighted Price

0 Convertible Debt / Preferred Stock Table: #NAME?
Convertible Debt:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Preferred Stock:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Latest Adj. EBIT: $ Operating Profit: $

Previous -

(enter footnotes below)

Latest Effective Tax Rate: Adj. Net Income: $ Income from Ops: Tax Effect: $ Sum of Extra: $ Note: Don't forget to add the extraordinary back for Net Income when backing out for EBIT be careful not to back out in EBIT any extraordinaries that affect only Net Income ! 40.0% $ $ $

Previous 40.0% -

Latest CapEx Interest Expense 52 Week High 52 Week Low Segment Financials by Sales Sales

Other Financial Information Previous

Division

Percentage

Total Firm Sales

$0.0

0.0%

ethod: 0.000000

k Table: 0.00 Number of Shares:

0.00 Number of Shares:

Annual $ -

Annual 40.0% $ $ $ -

Information Annual

Comparable Company Analysis

Check for New 10K
10K Latest Info
I. Summary Information A. Company Name: B. Industry: C. Description D. Fiscal Year End: E. Latest Quarter: F. Previous Quarter: G. FY1 Median Est. EPS H. I. FY2 Median Est. EPS FY3 Median Est. EPS 0

J.

LT I/B/E/S EPS Growth Rate:

NA

II. Equity Value A. Current Shares Outstanding: (Fully Diluted: 0-No,1-Yes) B. Current Share Price: C. Market Value of Equity: III. Total Enterprise Value: A. Short-term debt: B. C. D. E. F. G. H. I. Long-term debt: Minority Interest: Preferred Stock: Total Debt Outstanding: Less: Cash and Equivalents: Net Debt (E-F): Market Value of Equity: Total Enterprise Value (G+H):

NA NA NA

$ $ NA NA

-

IV. Financial Data A. Latest Fiscal Year End Revenues: B. Plus: Latest Revenues: C. Less: Prior Revenues: D. LTM Revenues: E. F. G. H. I. J. Latest Fiscal Year End EBIT: Plus: Latest EBIT: Less: Prior EBIT: LTM EBIT: Latest Fiscal Year End D&A: Plus: Latest D&A:

NA $ $ $ NA -

K. L. M. N. O. P. Q. R. S. V. Multiples A. B. C. D. E. F. G. H. Footnotes: (a) (b) (c) (d) (e) (f) (g) (h) (i) (j)

Less: Prior D&A: LTM D&A: LTM EBITDA: Latest Fiscal Year Net Income: Plus: Latest Net Income: Less: Prior Net Income: LTM Net Income: Latest Book Value of Common Equity: Amount of Total Assets: TEV/LTM Revenues: TEV/LTM EBITDA: TEV/LTM EBIT: Equity Value/LTM Net Income: Price to FY1 Est. EPS Price to FY2 Est. EPS Price to FY3 Est. EPS Equity Value/Book Value: 0 0 0 0 0 0 0 0 0 0

$ NA $ $ $ NA NA NA

-

-

NA NA NA NA NA NA NA NA

Total Firm Sales

s

Options Table - Treasury Stock Method: 0 Number of Shares: (in millions) 0.000000 Net New Shares: (in millions)

Number of Options ### ###

Weighted Price

0 Convertible Debt / Preferred Stock Table: #NAME?
Convertible Debt:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Preferred Stock:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Latest Adj. EBIT: $ Operating Profit: $

Previous -

(enter footnotes below)

Latest Effective Tax Rate: Adj. Net Income: $ Income from Ops: Tax Effect: $ Sum of Extra: $ Note: Don't forget to add the extraordinary back for Net Income when backing out for EBIT be careful not to back out in EBIT any extraordinaries that affect only Net Income ! 40.0% $ $ $

Previous 40.0% -

Latest CapEx Interest Expense 52 Week High 52 Week Low Segment Financials by Sales Sales

Other Financial Information Previous

Division

Percentage

Total Firm Sales

$0.0

0.0%

ethod: 0.000000

k Table: 0.00 Number of Shares:

0.00 Number of Shares:

Annual $ -

Annual 40.0% $ $ $ -

Information Annual

Comparable Company Analysis

Check for New 10K
10K Latest Info
I. Summary Information A. Company Name: B. Industry: C. Description D. Fiscal Year End: E. Latest Quarter: F. Previous Quarter: G. FY1 Median Est. EPS H. I. FY2 Median Est. EPS FY3 Median Est. EPS 0

J.

LT I/B/E/S EPS Growth Rate:

NA

II. Equity Value A. Current Shares Outstanding: (Fully Diluted: 0-No,1-Yes) B. Current Share Price: C. Market Value of Equity: III. Total Enterprise Value: A. Short-term debt: B. C. D. E. F. G. H. I. Long-term debt: Minority Interest: Preferred Stock: Total Debt Outstanding: Less: Cash and Equivalents: Net Debt (E-F): Market Value of Equity: Total Enterprise Value (G+H):

NA NA NA

$ $ NA NA

-

IV. Financial Data A. Latest Fiscal Year End Revenues: B. Plus: Latest Revenues: C. Less: Prior Revenues: D. LTM Revenues: E. F. G. H. I. J. Latest Fiscal Year End EBIT: Plus: Latest EBIT: Less: Prior EBIT: LTM EBIT: Latest Fiscal Year End D&A: Plus: Latest D&A:

NA $ $ $ NA -

K. L. M. N. O. P. Q. R. S. V. Multiples A. B. C. D. E. F. G. H. Footnotes: (a) (b) (c) (d) (e) (f) (g) (h) (i) (j)

Less: Prior D&A: LTM D&A: LTM EBITDA: Latest Fiscal Year Net Income: Plus: Latest Net Income: Less: Prior Net Income: LTM Net Income: Latest Book Value of Common Equity: Amount of Total Assets: TEV/LTM Revenues: TEV/LTM EBITDA: TEV/LTM EBIT: Equity Value/LTM Net Income: Price to FY1 Est. EPS Price to FY2 Est. EPS Price to FY3 Est. EPS Equity Value/Book Value: 0 0 0 0 0 0 0 0 0 0

$ NA $ $ $ NA NA NA

-

-

NA NA NA NA NA NA NA NA

Total Firm Sales

s

Options Table - Treasury Stock Method: 0 Number of Shares: (in millions) 0.000000 Net New Shares: (in millions)

Number of Options ### ###

Weighted Price

0 Convertible Debt / Preferred Stock Table: #NAME?
Convertible Debt:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Preferred Stock:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Latest Adj. EBIT: $ Operating Profit: $

Previous -

(enter footnotes below)

Latest Effective Tax Rate: Adj. Net Income: $ Income from Ops: Tax Effect: $ Sum of Extra: $ Note: Don't forget to add the extraordinary back for Net Income when backing out for EBIT be careful not to back out in EBIT any extraordinaries that affect only Net Income ! 40.0% $ $ $

Previous 40.0% -

Latest CapEx Interest Expense 52 Week High 52 Week Low Segment Financials by Sales Sales

Other Financial Information Previous

Division

Percentage

Total Firm Sales

$0.0

0.0%

ethod: 0.000000

k Table: 0.00 Number of Shares:

0.00 Number of Shares:

Annual $ -

Annual 40.0% $ $ $ -

Information Annual

Comparable Company Analysis

Check for New 10K
10K Latest Info
I. Summary Information A. Company Name: B. Industry: C. Description D. Fiscal Year End: E. Latest Quarter: F. Previous Quarter: G. FY1 Median Est. EPS H. I. FY2 Median Est. EPS FY3 Median Est. EPS 0

J.

LT I/B/E/S EPS Growth Rate:

NA

II. Equity Value A. Current Shares Outstanding: (Fully Diluted: 0-No,1-Yes) B. Current Share Price: C. Market Value of Equity: III. Total Enterprise Value: A. Short-term debt: B. C. D. E. F. G. H. I. Long-term debt: Minority Interest: Preferred Stock: Total Debt Outstanding: Less: Cash and Equivalents: Net Debt (E-F): Market Value of Equity: Total Enterprise Value (G+H):

NA NA NA

$ $ NA NA

-

IV. Financial Data A. Latest Fiscal Year End Revenues: B. Plus: Latest Revenues: C. Less: Prior Revenues: D. LTM Revenues: E. F. G. H. I. J. Latest Fiscal Year End EBIT: Plus: Latest EBIT: Less: Prior EBIT: LTM EBIT: Latest Fiscal Year End D&A: Plus: Latest D&A:

NA $ $ $ NA -

K. L. M. N. O. P. Q. R. S. V. Multiples A. B. C. D. E. F. G. H. Footnotes: (a) (b) (c) (d) (e) (f) (g) (h) (i) (j)

Less: Prior D&A: LTM D&A: LTM EBITDA: Latest Fiscal Year Net Income: Plus: Latest Net Income: Less: Prior Net Income: LTM Net Income: Latest Book Value of Common Equity: Amount of Total Assets: TEV/LTM Revenues: TEV/LTM EBITDA: TEV/LTM EBIT: Equity Value/LTM Net Income: Price to FY1 Est. EPS Price to FY2 Est. EPS Price to FY3 Est. EPS Equity Value/Book Value: 0 0 0 0 0 0 0 0 0 0

$ NA $ $ $ NA NA NA

-

-

NA NA NA NA NA NA NA NA

Total Firm Sales

s

Options Table - Treasury Stock Method: 0 Number of Shares: (in millions) 0.000000 Net New Shares: (in millions)

Number of Options ### ###

Weighted Price

0 Convertible Debt / Preferred Stock Table: #NAME?
Convertible Debt:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Preferred Stock:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Latest Adj. EBIT: $ Operating Profit: $

Previous -

(enter footnotes below)

Latest Effective Tax Rate: Adj. Net Income: $ Income from Ops: Tax Effect: $ Sum of Extra: $ Note: Don't forget to add the extraordinary back for Net Income when backing out for EBIT be careful not to back out in EBIT any extraordinaries that affect only Net Income ! 40.0% $ $ $

Previous 40.0% -

Latest CapEx Interest Expense 52 Week High 52 Week Low Segment Financials by Sales Sales

Other Financial Information Previous

Division

Percentage

Total Firm Sales

$0.0

0.0%

ethod: 0.000000

k Table: 0.00 Number of Shares:

0.00 Number of Shares:

Annual $ -

Annual 40.0% $ $ $ -

Information Annual

Comparable Company Analysis

Check for New 10K
10K Latest Info
I. Summary Information A. Company Name: B. Industry: C. Description D. Fiscal Year End: E. Latest Quarter: F. Previous Quarter: G. FY1 Median Est. EPS H. I. FY2 Median Est. EPS FY3 Median Est. EPS 0

J.

LT I/B/E/S EPS Growth Rate:

NA

II. Equity Value A. Current Shares Outstanding: (Fully Diluted: 0-No,1-Yes) B. Current Share Price: C. Market Value of Equity: III. Total Enterprise Value: A. Short-term debt: B. C. D. E. F. G. H. I. Long-term debt: Minority Interest: Preferred Stock: Total Debt Outstanding: Less: Cash and Equivalents: Net Debt (E-F): Market Value of Equity: Total Enterprise Value (G+H):

NA NA NA

$ $ NA NA

-

IV. Financial Data A. Latest Fiscal Year End Revenues: B. Plus: Latest Revenues: C. Less: Prior Revenues: D. LTM Revenues: E. F. G. H. I. J. Latest Fiscal Year End EBIT: Plus: Latest EBIT: Less: Prior EBIT: LTM EBIT: Latest Fiscal Year End D&A: Plus: Latest D&A:

NA $ $ $ NA -

K. L. M. N. O. P. Q. R. S. V. Multiples A. B. C. D. E. F. G. H. Footnotes: (a) (b) (c) (d) (e) (f) (g) (h) (i) (j)

Less: Prior D&A: LTM D&A: LTM EBITDA: Latest Fiscal Year Net Income: Plus: Latest Net Income: Less: Prior Net Income: LTM Net Income: Latest Book Value of Common Equity: Amount of Total Assets: TEV/LTM Revenues: TEV/LTM EBITDA: TEV/LTM EBIT: Equity Value/LTM Net Income: Price to FY1 Est. EPS Price to FY2 Est. EPS Price to FY3 Est. EPS Equity Value/Book Value: 0 0 0 0 0 0 0 0 0 0

$ NA $ $ $ NA NA NA

-

-

NA NA NA NA NA NA NA NA

Total Firm Sales

s

Options Table - Treasury Stock Method: 0 Number of Shares: (in millions) 0.000000 Net New Shares: (in millions)

Number of Options ### ###

Weighted Price

0 Convertible Debt / Preferred Stock Table: #NAME?
Convertible Debt:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Preferred Stock:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Latest Adj. EBIT: $ Operating Profit: $

Previous -

(enter footnotes below)

Latest Effective Tax Rate: Adj. Net Income: $ Income from Ops: Tax Effect: $ Sum of Extra: $ Note: Don't forget to add the extraordinary back for Net Income when backing out for EBIT be careful not to back out in EBIT any extraordinaries that affect only Net Income ! 40.0% $ $ $

Previous 40.0% -

Latest CapEx Interest Expense 52 Week High 52 Week Low Segment Financials by Sales Sales

Other Financial Information Previous

Division

Percentage

Total Firm Sales

$0.0

0.0%

ethod: 0.000000

k Table: 0.00 Number of Shares:

0.00 Number of Shares:

Annual $ -

Annual 40.0% $ $ $ -

Information Annual

Comparable Company Analysis

Check for New 10K
10K Latest Info
I. Summary Information A. Company Name: B. Industry: C. Description D. Fiscal Year End: E. Latest Quarter: F. Previous Quarter: G. FY1 Median Est. EPS H. I. FY2 Median Est. EPS FY3 Median Est. EPS 0

J.

LT I/B/E/S EPS Growth Rate:

NA

II. Equity Value A. Current Shares Outstanding: (Fully Diluted: 0-No,1-Yes) B. Current Share Price: C. Market Value of Equity: III. Total Enterprise Value: A. Short-term debt: B. C. D. E. F. G. H. I. Long-term debt: Minority Interest: Preferred Stock: Total Debt Outstanding: Less: Cash and Equivalents: Net Debt (E-F): Market Value of Equity: Total Enterprise Value (G+H):

NA NA NA

$ $ NA NA

-

IV. Financial Data A. Latest Fiscal Year End Revenues: B. Plus: Latest Revenues: C. Less: Prior Revenues: D. LTM Revenues: E. F. G. H. I. J. Latest Fiscal Year End EBIT: Plus: Latest EBIT: Less: Prior EBIT: LTM EBIT: Latest Fiscal Year End D&A: Plus: Latest D&A:

NA $ $ $ NA -

K. L. M. N. O. P. Q. R. S. V. Multiples A. B. C. D. E. F. G. H. Footnotes: (a) (b) (c) (d) (e) (f) (g) (h) (i) (j)

Less: Prior D&A: LTM D&A: LTM EBITDA: Latest Fiscal Year Net Income: Plus: Latest Net Income: Less: Prior Net Income: LTM Net Income: Latest Book Value of Common Equity: Amount of Total Assets: TEV/LTM Revenues: TEV/LTM EBITDA: TEV/LTM EBIT: Equity Value/LTM Net Income: Price to FY1 Est. EPS Price to FY2 Est. EPS Price to FY3 Est. EPS Equity Value/Book Value: 0 0 0 0 0 0 0 0 0 0

$ NA $ $ $ NA NA NA

-

-

NA NA NA NA NA NA NA NA

Total Firm Sales

s

Options Table - Treasury Stock Method: 0 Number of Shares: (in millions) 0.000000 Net New Shares: (in millions)

Number of Options ### ###

Weighted Price

0 Convertible Debt / Preferred Stock Table: #NAME?
Convertible Debt:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Preferred Stock:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Latest Adj. EBIT: $ Operating Profit: $

Previous -

(enter footnotes below)

Latest Effective Tax Rate: Adj. Net Income: $ Income from Ops: Tax Effect: $ Sum of Extra: $ Note: Don't forget to add the extraordinary back for Net Income when backing out for EBIT be careful not to back out in EBIT any extraordinaries that affect only Net Income ! 40.0% $ $ $

Previous 40.0% -

Latest CapEx Interest Expense 52 Week High 52 Week Low Segment Financials by Sales Sales

Other Financial Information Previous

Division

Percentage

Total Firm Sales

$0.0

0.0%

ethod: 0.000000

k Table: 0.00 Number of Shares:

0.00 Number of Shares:

Annual $ -

Annual 40.0% $ $ $ -

Information Annual

NA

Check for New 10K
10K Latest Info
I. Summary Information A. Company Name: B. Industry: C. Description D. Fiscal Year End: E. Latest Quarter: F. Previous Quarter: G. FY1 Median Est. EPS H. I. FY2 Median Est. EPS FY3 Median Est. EPS 0

J.

LT I/B/E/S EPS Growth Rate:

NA

II. Equity Value A. Current Shares Outstanding: (Fully Diluted: 0-No,1-Yes) B. Current Share Price: C. Market Value of Equity: III. Total Enterprise Value: A. Short-term debt: B. C. D. E. F. G. H. I. Long-term debt: Minority Interest: Preferred Stock: Total Debt Outstanding: Less: Cash and Equivalents: Net Debt (E-F): Market Value of Equity: Total Enterprise Value (G+H):

NA NA NA

$ $ NA NA

-

IV. Financial Data A. Latest Fiscal Year End Revenues: B. Plus: Latest Revenues: C. Less: Prior Revenues: D. LTM Revenues: E. F. G. H. I. J. Latest Fiscal Year End EBIT: Plus: Latest EBIT: Less: Prior EBIT: LTM EBIT: Latest Fiscal Year End D&A: Plus: Latest D&A:

NA $ $ $ NA -

K. L. M. N. O. P. Q. R. S. V. Multiples A. B. C. D. E. F. G. H. Footnotes: (a) (b) (c) (d) (e) (f) (g) (h) (i) (j)

Less: Prior D&A: LTM D&A: LTM EBITDA: Latest Fiscal Year Net Income: Plus: Latest Net Income: Less: Prior Net Income: LTM Net Income: Latest Book Value of Common Equity: Amount of Total Assets: TEV/LTM Revenues: TEV/LTM EBITDA: TEV/LTM EBIT: Equity Value/LTM Net Income: Price to FY1 Est. EPS Price to FY2 Est. EPS Price to FY3 Est. EPS Equity Value/Book Value: 0 0 0 0 0 0 0 0 0 0

$ NA $ $ $ NA NA NA

-

-

NA NA NA NA NA NA NA NA

Total Firm Sales

Options Table - Treasury Stock Method: 0 Number of Shares: (in millions) 0.000000 Net New Shares: (in millions)

Number of Options ### ###

Weighted Price

0 Convertible Debt / Preferred Stock Table: #NAME?
Convertible Debt:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Preferred Stock:

Total # of Shares: Bal. Sht Amt.
(in millions)

Convert Price:

Latest Adj. EBIT: $ Operating Profit: $

Previous -

(enter footnotes below)

Latest Effective Tax Rate: Adj. Net Income: $ Income from Ops: Tax Effect: $ Sum of Extra: $ Note: Don't forget to add the extraordinary back for Net Income when backing out for EBIT be careful not to back out in EBIT any extraordinaries that affect only Net Income ! 40.0% $ $ $

Previous 40.0% -

Latest CapEx Interest Expense 52 Week High 52 Week Low Segment Financials by Sales Sales

Other Financial Information Previous

Division

Percentage

Total Firm Sales

$0.0

0.0%

ethod: 0.000000

k Table: 0.00 Number of Shares:

0.00 Number of Shares:

Annual $ -

Annual 40.0% $ $ $ -

Information Annual

C:\jpb\models\[Comparable Companies (NON-FDS).xlt]Setup Companies Input Variables 4.64% 5.56% S&P 500 02/28/99 Market Risk Premium Risk Free Rate Index Used In Beta Calc Date of MRP (Alcar) 1 40.0% 0 1

(1=Market Value of Equity, 0=Boo Assumed Effective Tax Rate (1=Corporate Tax, 0=Assumed T (1=Market Value of Debt, 0=Book

Company Name

Ticker 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Beta Calculation Source Bloomberg FactSet NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA

Estimated Cost of Debt Debt Description Short-term bank debt 7.5% debentures 8.875% debentures 8.125% debentures 8.375% debentures 7.125% debentures 6.25% notes 6.95% debentures Zero Coupon debt 6.75% debentures 7% debentures 10.25% debentures Industrial Bonds $0.0 0.00% Amount Rate

Estimated Cost of Debt Debt Description Amount Rate

$0.0

0.00%

Estimated Cost of Debt Debt Description Amount Rate

$0.0

0.00%

Estimated Cost of Debt Debt Description Amount Rate

$0.0

0.00%

Estimated Cost of Debt Debt Description Amount Rate

$0.0

0.00%

Estimated Cost of Debt Debt Description Amount Rate

$0.0

0.00%

Estimated Cost of Debt Debt Description Amount Rate

$0.0

0.00%

Estimated Cost of Debt Debt Description Amount Rate

$0.0

0.00%

Estimated Cost of Debt Debt Description Amount Rate

$0.0

0.00%

Estimated Cost of Debt Debt Description Amount Rate

$0.0

0.00%

(1=Market Value of Equity, 0=Book Value of Equity) Assumed Effective Tax Rate (1=Corporate Tax, 0=Assumed Tax Rate) (1=Market Value of Debt, 0=Book Value of Debt)

Weighted Average Cost of Capital (in thousands)
Barra Median Asset Beta Shares Out. 36656.506 Price

a Calculation Source Alcar

Median:

Total Debt Tables (Source: 10-K)

Estimated Cost of Debt Wtd. Rate Debt Description Amount Rate

0.00%

$0.0

0.00%

Estimated Cost of Debt Wtd. Rate Debt Description Amount Rate

0.00%

$0.0

0.00%

Estimated Cost of Debt Wtd. Rate Debt Description Amount Rate

0.00%

$0.0

0.00%

Estimated Cost of Debt Wtd. Rate Debt Description Amount Rate

0.00%

$0.0

0.00%

Estimated Cost of Debt Wtd. Rate Debt Description Amount Rate

0.00%

$0.0

0.00%

Estimated Cost of Debt Wtd. Rate Debt Description Amount Rate

0.00%

$0.0

0.00%

Estimated Cost of Debt Wtd. Rate Debt Description Amount Rate

0.00%

$0.0

0.00%

Estimated Cost of Debt Wtd. Rate Debt Description Amount Rate

0.00%

$0.0

0.00%

Estimated Cost of Debt Wtd. Rate Debt Description Amount Rate

0.00%

$0.0

0.00%

Estimated Cost of Debt Wtd. Rate Debt Description Amount Rate

0.00%

$0.0

0.00%

sands)
Market Value Total Debt $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 Tax Rate Debt/ Total Cap. Cost of Debt 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Equity

0.00%

Estimated Cost of Debt Wtd. Rate Debt Description Amount Rate

0.00%

$0.0

0.00%

Estimated Cost of Debt Wtd. Rate Debt Description Amount Rate

0.00%

$0.0

0.00%

Estimated Cost of Debt Wtd. Rate Debt Description Amount Rate

0.00%

$0.0

0.00%

Estimated Cost of Debt Wtd. Rate Debt Description Amount Rate

0.00%

$0.0

0.00%

Estimated Cost of Debt Wtd. Rate Debt Description Amount Rate

0.00%

$0.0

0.00%

Estimated Cost of Debt Wtd. Rate Debt Description Amount Rate

0.00%

$0.0

0.00%

Estimated Cost of Debt Wtd. Rate Debt Description Amount Rate

0.00%

$0.0

0.00%

Estimated Cost of Debt Wtd. Rate Debt Description Amount Rate

0.00%

$0.0

0.00%

Estimated Cost of Debt Wtd. Rate Debt Description Amount Rate

0.00%

$0.0

0.00%

Estimated Cost of Debt Wtd. Rate Debt Description Amount Rate

0.00%

$0.0

0.00%

WACC

Wtd. Rate

0.00%

Wtd. Rate

0.00%

Wtd. Rate

0.00%

Wtd. Rate

0.00%

Wtd. Rate

0.00%

Wtd. Rate

0.00%

Wtd. Rate

0.00%

Wtd. Rate

0.00%

Wtd. Rate

0.00%

Wtd. Rate

0.00%


				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:132
posted:10/16/2009
language:English
pages:204
Description: Excel valuation model comparing companies