Investment Banking Valuation, Leveraged Buyouts, and Mergers & Acquisitions Comparable Companies Analysis - Template
JOSHUA ROSENBAUM JOSHUA PEARL
($ in millions)
List of Comparable Companies Company
Ticker
Business Description
Equity Value
Enterprise Value
LTM Sales
TargetCo
TTT
[to come]
-
-
-
Company A
AAA
[to come]
-
-
-
Company B
BBB
[to come]
-
-
-
Company C
CCC
[to come]
-
-
-
Company D
DDD
[to come]
-
-
-
Company E
EEE
[to come]
-
-
-
Company F
FFF
[to come]
-
-
-
Company G
GGG
[to come]
-
-
-
Company H
HHH
[to come]
-
-
-
Company I
III
[to come]
-
-
-
Company J
JJJ
[to come]
-
-
-
ValueCo Corporation Benchmarking Analysis – Financial Statistics and Ratios, Page 1 ($ in millions, except per share data)
Market Valuation
LTM Financial Statistics
LTM Profitability Margins Gross
Company TargetCo
Ticker
Equity Value
Enterprise Value
Sales
Gross Profit
EBITDA
EBIT
Net Income
Growth Rates Net
Sales
EBITDA
EPS
Profit (%)
EBITDA (%)
EBIT (%)
Income (%)
Hist. 1-year
Est. 1-year
Hist. 1-year
Est. 1-year
Hist. 1-year
Est. 1-year
Est. LT
TTT
-
-
-
-
-
-
-
NA
NA
NA
NA
0%
0%
0%
0%
0%
0%
0%
AAA BBB CCC DDD EEE
-
-
-
-
-
-
-
NA NA NA NA NA
NA NA NA NA NA
NA NA NA NA NA
NA NA NA NA NA
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%
NA NA
NA NA
NA NA
NA NA
0% 0%
0% 0%
0% 0%
0% 0%
0% 0%
0% 0%
0% 0%
NA NA NA NA NA
NA NA NA NA NA
NA NA NA NA NA
NA NA NA NA NA
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%
NA NA
NA NA
NA NA
NA NA
0% 0%
0% 0%
0% 0%
0% 0%
0% 0%
0% 0%
0% 0%
NA NA NA NA NA
NA NA NA NA NA
NA NA NA NA NA
NA NA NA NA NA
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%
NA NA
NA NA
NA NA
NA NA
0% 0%
0% 0%
0% 0%
0% 0%
0% 0%
0% 0%
0% 0%
Mean Median
NA NA
NA NA
NA NA
NA NA
0% 0%
0% 0%
0% 0%
0% 0%
0% 0%
0% 0%
0% 0%
High Low
0% 0%
0% 0%
0% 0%
0% 0%
0% 0%
0% 0%
0% 0%
0% 0%
0% 0%
0% 0%
0% 0%
Tier I: Large-Cap Company A Company B Company C Company D Company E Mean Median Tier II: Mid-Cap Company F Company G Company H Company I Company J
FFF GGG HHH III JJJ
-
-
-
-
-
-
-
Mean Median Tier III: Small-Cap Company K Company L Company M Company N Company O
K-LLL MMM NNN OOO
-
-
-
-
-
-
Mean Median
-
Overall
Source: Company filings, Bloomberg, Consensus Estimates Note: Last twelve months data based on September 30, 2008. Estimated annual financial data based on a calendar year.
ValueCo Corporation Benchmarking Analysis – Financial Statistics and Ratios, Page 2 ($ in millions, except per share data)
General
Return on Investment
LTM Leverage Ratios
LTM Coverage Ratios
FYE
Predicted Beta
ROIC (%)
ROE (%)
ROA (%)
Moody's
S&P
TTT
Dec-31
1.00
0%
0%
0%
NA
0%
0.0x
0.0x
0.0x
0.0x
0.0x
NA
NA
AAA BBB CCC DDD EEE
Dec-31 Dec-31 Dec-31 Dec-31 Dec-31
1.00 1.00 1.00 1.00 1.00
0% 0% 0% 0% 0%
0% 0% 0% 0% 0%
0% 0% 0% 0% 0%
NA NA NA NA NA
0% 0% 0% 0% 0%
0.0x 0.0x 0.0x 0.0x 0.0x
0.0x 0.0x 0.0x 0.0x 0.0x
0.0x 0.0x 0.0x 0.0x 0.0x
0.0x 0.0x 0.0x 0.0x 0.0x
0.0x 0.0x 0.0x 0.0x 0.0x
NA NA NA NA NA
NA NA NA NA NA
1.00 1.00
0% 0%
0% 0%
0% 0%
NA NA
0% 0%
0.0x 0.0x
0.0x 0.0x
0.0x 0.0x
0.0x 0.0x
0.0x 0.0x
1.00 1.00 1.00 1.00 1.00
0% 0% 0% 0% 0%
0% 0% 0% 0% 0%
0% 0% 0% 0% 0%
NA NA NA NA NA
0% 0% 0% 0% 0%
0.0x 0.0x 0.0x 0.0x 0.0x
0.0x 0.0x 0.0x 0.0x 0.0x
0.0x 0.0x 0.0x 0.0x 0.0x
0.0x 0.0x 0.0x 0.0x 0.0x
0.0x 0.0x 0.0x 0.0x 0.0x
NA NA NA NA NA
NA NA NA NA NA
1.00 1.00
0% 0%
0% 0%
0% 0%
NA NA
0% 0%
0.0x 0.0x
0.0x 0.0x
0.0x 0.0x
0.0x 0.0x
0.0x 0.0x
1.00 1.00 1.00 1.00 1.00
0% 0% 0% 0% 0%
0% 0% 0% 0% 0%
0% 0% 0% 0% 0%
NA NA NA NA NA
0% 0% 0% 0% 0%
0.0x 0.0x 0.0x 0.0x 0.0x
0.0x 0.0x 0.0x 0.0x 0.0x
0.0x 0.0x 0.0x 0.0x 0.0x
0.0x 0.0x 0.0x 0.0x 0.0x
0.0x 0.0x 0.0x 0.0x 0.0x
NA NA NA NA NA
NA NA NA NA NA
1.00 1.00
0% 0%
0% 0%
0% 0%
NA NA
0% 0%
0.0x 0.0x
0.0x 0.0x
0.0x 0.0x
0.0x 0.0x
0.0x 0.0x
Mean Median
1.00 1.00
0% 0%
0% 0%
0% 0%
NA NA
0% 0%
0.0x 0.0x
0.0x 0.0x
0.0x 0.0x
0.0x 0.0x
0.0x 0.0x
High Low
1.00 1.00
0% 0%
0% 0%
0% 0%
0% 0%
0% 0%
0.0x 0.0x
0.0x 0.0x
0.0x 0.0x
0.0x 0.0x
0.0x 0.0x
Company TargetCo
Ticker
Debt / Tot. Cap. (%)
Debt / EBITDA (x)
Net Debt / EBITDA (x)
EBITDA / Int. Exp. (x)
EBITDA - Cpx/ Int. (x)
EBIT / Int. Exp. (x)
Credit Ratings
Implied Div. Yield (%)
Tier I: Large-Cap Company A Company B Company C Company D Company E Mean Median Tier II: Mid-Cap Company F Company G Company H Company I Company J
FFF GGG HHH III JJJ
Dec-31 Dec-31 Dec-31 Dec-31 Dec-31
Mean Median Tier III: Small-Cap Company K Company L Company M Company N Company O Mean Median
K-LLL MMM NNN OOO
Dec-31 Dec-31 Dec-31 Dec-31 Dec-31
Overall
Source: Company filings, Bloomberg, Consensus Estimates
ValueCo Corporation Comparable Companies Analysis ($ in millions, except per share data)
Company TargetCo
Ticker
Current
% of
Share Price
52-wk. High
Enterprise Value / Equity Value
Enterprise Value
LTM Sales
2008E Sales
2009E Sales
LTM 2008E 2009E EBITDA EBITDA EBITDA
LTM LTM EBIT
2008E EBIT
2009E EBIT
Total
EBITDA Debt / Margin EBITDA
Price /
LT
LTM EPS
2008E EPS
2009E EPS
EPS Growth
TTT
-
NA
-
-
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
0.0.x
NA
NA
NA
0%
AAA BBB CCC DDD EEE
-
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
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
0.0.x 0.0.x 0.0.x 0.0.x 0.0.x
NA NA NA NA NA
NA NA NA NA NA
NA NA NA NA NA
0% 0% 0% 0% 0%
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
0.0x 0.0x
NA NA
NA NA
NA NA
0% 0%
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
NA NA NA NA NA
NA NA NA NA NA
NA NA NA NA NA
NA NA NA NA NA
0.0.x 0.0.x 0.0.x 0.0.x 0.0.x
NA NA NA NA NA
NA NA NA NA NA
NA NA NA NA NA
0% 0% 0% 0% 0%
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
0.0x 0.0x
NA NA
NA NA
NA NA
0% 0%
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
NA NA NA NA NA
NA NA NA NA NA
NA NA NA NA NA
NA NA NA NA NA
0.0.x 0.0.x 0.0.x 0.0.x 0.0.x
NA NA NA NA NA
NA NA NA NA NA
NA NA NA NA NA
0% 0% 0% 0% 0%
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
0.0x 0.0x
NA NA
NA NA
NA NA
0% 0%
Mean Median
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
0.0x 0.0x
NA NA
NA NA
NA NA
0% 0%
High Low
0.0x 0.0x
0.0x 0.0x
0.0x 0.0x
0.0x 0.0x
0.0x 0.0x
0.0x 0.0x
0.0x 0.0x
0.0x 0.0x
0.0x 0.0x
0% 0%
0.0x 0.0x
0.0x 0.0x
0.0x 0.0x
0.0x 0.0x
0% 0%
Tier I: Large-Cap Company A Company B Company C Company D Company E Mean Median Tier II: Mid-Cap Company F Company G Company H Company I Company J
FFF GGG HHH III JJJ
-
NA NA NA NA NA
-
-
Mean Median Tier III: Small-Cap Company K Company L Company M Company N Company O Mean Median
K-LLL MMM NNN OOO
-
NA NA NA NA NA
-
-
Overall
Source: Company filings, Bloomberg, Consensus Estimates Note: Last twelve months data based on September 30, 2008. Estimated annual financial data based on a calendar year.
TargetCo (NYSE:TTT)
Business Description
Input Page
[to come]
($ in millions, except per share data)
General Information
Reported Income Statement
Company Name
Balance Sheet Data
TargetCo
Ticker
Prior
TTT
Stock Exchange
Fiscal Year Ending December 31,
NYSE
Fiscal Year Ending
Dec-31
Moody's Corporate Rating
NA
S&P Corporate Rating Predicted Beta Marginal Tax Rate
NA 1.00 38.0%
Selected Market Data Current Price
1/0/1900
% of 52-week High 52-week High Price 52-week Low Price Dividend Per Share (MRQ)
-
NA -
1/0/1900 1/0/1900
2005A
2007A
2007A
Stub
Stub
LTM
9/302007
9/30/2008
9/30/2008
-
-
-
-
-
-
-
Inventories
-
-
COGS
-
-
-
-
-
-
Prepaids and Other Current Assets
-
-
Gross Profit SG&A Other Expense / (Income)
-
-
-
-
-
-
-
-
Property, Plant and Equipment, net
-
-
EBIT Interest Expense
-
-
-
-
-
-
Goodwill and Intangible Assets Other Assets
-
-
-
-
-
-
-
-
Total Assets
-
-
-
-
-
-
-
-
Pre-tax Income Income Taxes Noncontrolling Interest Preferred Dividends Net Income
Total Current Assets
Accounts Payable
-
-
-
-
-
-
-
-
Accrued Liabilities
-
-
-
-
-
-
-
-
Other Current Liabilities
-
-
NA
NA
NA
NA
NA
NA
Total Current Liabilities
-
Weighted Avg. Dil uted Shares Diluted EPS
-
NA
NA
NA
NA
NA
NA
Total Debt Other Long-Term Liabilities
-
-
-
Adjusted Income Statement
Less: Cash and Cash Equivalents
-
Reported Gross Profit
-
-
-
-
-
-
Non-recurring Items in COGS
-
-
-
-
NA
NA
NA
Reported EBIT
-
-
Non-recurring Items in COGS Other Non-recurring Items
-
-
NA
Enterprise Value
Total Liabilities
Adj. Gross Profit Trading Multiples
% margin
LTM 9/30/2008
NFY 2008E
NA -
NFY+1 2009E NA -
NA -
EV/EBITDA
NA
NA
NA
Adjusted EBIT
Metric EV/EBIT
NA
NA
NA
% margin
Metric
-
-
-
Plus: Total Debt Plus: Preferred Stock Plus: Noncontrolling Interest
P/E Metric
-
-
Equity Value
EV/Sales Metric
9/30/2008
Cash and Cash Equivalents Accounts Receivable
Sales
Effective Tax Rate Fully Diluted Shares Outstanding
2006A
Current
-
-
-
NA -
NA -
NA -
LTM Return on Investment Ratios
NA
Return on Invested Capital Return on Equity Return on Assets Implied Annual Dividend Per Share
Depreciation & Amortization
-
-
-
-
Preferred Stock
-
-
-
-
Shareholders' Equity
-
NA
NA
NA
-
-
-
-
Calculation of Fully Diluted Shares Outstanding
-
-
-
-
Basic Shares Outstanding Plus: Shares from In-the-Money Options
NA
NA
NA
NA
NA
-
-
-
-
-
-
Adjusted EBITDA % margin
NA
NA
NA
NA
NA
NA
Reported Net Income
-
-
-
-
-
-
Non-recurring Items in COGS Other Non-recurring Items Non-operating Non-rec. Items Tax Adjustment
-
-
-
-
-
-
NA
NA
NA
NA
NA
NA
-
-
-
-
-
-
Adjusted Net Income LTM Credit Statistics
-
Noncontrolling Interest
% margin
Total Liabilities and Equity Balance Check
0.000
0.000
-
Less: Shares Repurchased
-
Net New Shares from Options Plus: Shares from Convertible Securities
-
Fully Diluted Shares Outstanding
-
Options/Warrants Number of Shares
Exercise Price
-
-
-
-
Tranche 5
-
-
-
-
Total
-
-
-
Tranche Tranche Tranche Tranche Tranche
1 2 3 4
In-the-Money Shares
Proceeds
-
Debt/Total Capitalization Total Debt/EBITDA
-
Net Debt/EBITDA EBITDA/Interest Expense
-
Adjusted Diluted EPS
-
Cash Flow Statement Data
EBIT/Interest Expense
-
Depreciation & Amortization % sales Capital Ex penditures
Growth Rates EBITDA
Conversion Price
Amount
(EBITDA-capex)/Interest Expense
Sales
Convertible Securities
% sales
EPS
Historical
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
-
-
-
Notes
Estimated 1-year 2-year CAGR Long-term
-
-
-
(1) (2) (3) (4)
[to come] [to come] [to come] [to come]
New Shares
Issue 1
-
-
-
-
Issue 2 Issue 3 Issue 4
-
-
-
-
Issue 5
-
-
-
Total
1-year 2-year CAGR
Conversion Ratio
-
Company A (NYSE:AAA)
Business Description
Input Page
[to come]
($ in millions, except per share data)
General Information
Reported Income Statement
Company Name
Balance Sheet Data
Company A
Ticker
Prior
AAA
Stock Exchange
Fiscal Year Ending December 31,
NYSE
Fiscal Year Ending
Dec-31
Moody's Corporate Rating
NA
S&P Corporate Rating Predicted Beta Marginal Tax Rate
NA 1.00 38.0%
Selected Market Data Current Price
1/0/1900
% of 52-week High 52-week High Price 52-week Low Price Dividend Per Share (MRQ)
-
NA -
1/0/1900 1/0/1900
2005A
2007A
2007A
Stub
Stub
LTM
9/302007
9/30/2008
9/30/2008
-
-
-
-
-
-
-
Inventories
-
-
COGS
-
-
-
-
-
-
Prepaids and Other Current Assets
-
-
Gross Profit SG&A Other Expense / (Income)
-
-
-
-
-
-
-
-
Property, Plant and Equipment, net
-
-
EBIT Interest Expense
-
-
-
-
-
-
Goodwill and Intangible Assets Other Assets
-
-
-
-
-
-
-
-
Total Assets
-
-
-
-
-
-
-
-
Pre-tax Income Income Taxes Noncontrolling Interest Preferred Dividends Net Income
Total Current Assets
Accounts Payable
-
-
-
-
-
-
-
-
Accrued Liabilities
-
-
-
-
-
-
-
-
Other Current Liabilities
-
-
NA
NA
NA
NA
NA
NA
Total Current Liabilities
-
Weighted Avg. Diluted Shares Diluted EPS
-
NA
NA
NA
NA
NA
NA
Total Debt Other Long-Term Liabilities
-
-
-
Adjusted Income Statement
Less: Cash and Cash Equivalents
-
Reported Gross Profit
-
-
-
-
-
-
Non-recurring Items in COGS
-
-
-
-
NA
NA
NA
Reported EBIT
-
-
Non-recurring Items in COGS Other Non-recurring Items
-
-
NA
Adjusted EBITDA % margin
Enterprise Value
-
-
Noncontrolling Interest
Total Liabilities
-
-
-
Preferred Stock
-
-
-
-
Shareholders' Equity
-
NA
NA
NA
-
-
-
-
Calculation of Fully Diluted Shares Outstanding
-
-
-
-
Basic Shares Outstanding Plus: Shares from In-the-Money Options
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
Reported Net Income
-
-
-
-
-
-
Non-recurring Items in COGS Other Non-recurring Items Non-operating Non-rec. Items Tax Adjustment
-
-
-
-
-
-
NA
NA
NA
NA
NA
NA
-
-
-
-
-
-
Adj. Gross Profit Trading Multiples
% margin
LTM 9/30/2008
NFY 2008E
NA -
NFY+1 2009E NA -
NA -
EV/EBITDA
NA
NA
NA
Adjusted EBIT
Metric EV/EBIT
NA
NA
NA
% margin
Metric
-
-
-
Plus: Total Debt Plus: Preferred Stock Plus: Noncontrolling Interest
P/E Metric
-
-
Equity Value
EV/Sales Metric
9/30/2008
Cash and Cash Equivalents Accounts Receivable
Sales
Effective Tax Rate Fully Diluted Shares Outstanding
2006A
Current
-
-
-
NA -
NA -
NA -
LTM Return on Investment Ratios
NA
Return on Invested Capital Return on Equity Return on Assets Implied Annual Dividend Per Share
Depreciation & Amortization
Adjusted Net Income LTM Credit Statistics
% margin
Total Liabilities and Equity Balance Check
0.000
0.000
-
Less: Shares Repurchased
-
Net New Shares from Options Plus: Shares from Convertible Securities
-
Fully Diluted Shares Outstanding
-
Options/Warrants Number of Shares
Exercise Price
-
-
-
-
Tranche 5
-
-
-
-
Total
-
-
-
Tranche Tranche Tranche Tranche Tranche
1 2 3 4
In-the-Money Shares
Proceeds
-
Debt/Total Capitalization Total Debt/EBITDA
-
Net Debt/EBITDA EBITDA/Interest Expense
-
(EBITDA-capex)/Interest Expense
-
Cash Flow Statement Data
EBIT/Interest Expense
-
Depreciation & Amortization % sales Capital Ex penditures
Adjusted Diluted EPS
EBITDA
Conversion Price
Amount
Growth Rates Sales
Convertible Securities
% sales
EPS
Historical
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
-
-
-
Notes
Estimated 1-year 2-year CAGR Long-term
-
-
-
(1) (2) (3) (4)
[to come] [to come] [to come] [to come]
New Shares
-
-
-
-
Issue 2 Issue 3 Issue 4
-
-
-
-
Issue 5
-
-
-
Total
1-year 2-year CAGR
Conversion Ratio
Issue 1
-
Company B (NYSE:BBB)
Business Description
Input Page
[to come]
($ in millions, except per share data)
General Information
Reported Income Statement
Company Name
Balance Sheet Data
Company B
Ticker
Prior
BBB
Stock Exchange
Fiscal Year Ending December 31,
NYSE
Fiscal Year Ending
Dec-31
Moody's Corporate Rating
NA
S&P Corporate Rating Predicted Beta Marginal Tax Rate
NA 1.00 38.0%
Selected Market Data Current Price
1/0/1900
% of 52-week High 52-week High Price 52-week Low Price Dividend Per Share (MRQ)
-
NA -
1/0/1900 1/0/1900
2005A
2007A
2007A
Stub
Stub
LTM
9/302007
9/30/2008
9/30/2008
-
-
-
-
-
-
-
Inventories
-
-
COGS
-
-
-
-
-
-
Prepaids and Other Current Assets
-
-
Gross Profit SG&A Other Expense / (Income)
-
-
-
-
-
-
-
-
Property, Plant and Equipment, net
-
-
EBIT Interest Expense
-
-
-
-
-
-
Goodwill and Intangible Assets Other Assets
-
-
-
-
-
-
-
-
Total Assets
-
-
-
-
-
-
-
-
Pre-tax Income Income Taxes Noncontrolling Interest Preferred Dividends Net Income
Total Current Assets
Accounts Payable
-
-
-
-
-
-
-
-
Accrued Liabilities
-
-
-
-
-
-
-
-
Other Current Liabilities
-
-
NA
NA
NA
NA
NA
NA
Total Current Liabilities
-
Weighted Avg. Diluted Shares Diluted EPS
-
NA
NA
NA
NA
NA
NA
Total Debt Other Long-Term Liabilities
-
-
-
Adjusted Income Statement
Less: Cash and Cash Equivalents
-
Reported Gross Profit
-
-
-
-
-
-
Non-recurring Items in COGS
-
-
-
-
NA
NA
NA
Reported EBIT
-
-
Non-recurring Items in COGS Other Non-recurring Items
-
-
NA
Adjusted EBITDA % margin
Enterprise Value
-
-
Noncontrolling Interest
Total Liabilities
-
-
-
Preferred Stock
-
-
-
-
Shareholders' Equity
-
NA
NA
NA
-
-
-
-
Calculation of Fully Diluted Shares Outstanding
-
-
-
-
Basic Shares Outstanding Plus: Shares from In-the-Money Options
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
Reported Net Income
-
-
-
-
-
-
Non-recurring Items in COGS Other Non-recurring Items Non-operating Non-rec. Items Tax Adjustment
-
-
-
-
-
-
NA
NA
NA
NA
NA
NA
-
-
-
-
-
-
Adj. Gross Profit Trading Multiples
% margin
LTM 9/30/2008
NFY 2008E
NA -
NFY+1 2009E NA -
NA -
EV/EBITDA
NA
NA
NA
Adjusted EBIT
Metric EV/EBIT
NA
NA
NA
% margin
Metric
-
-
-
Plus: Total Debt Plus: Preferred Stock Plus: Noncontrolling Interest
P/E Metric
-
-
Equity Value
EV/Sales Metric
9/30/2008
Cash and Cash Equivalents Accounts Receivable
Sales
Effective Tax Rate Fully Diluted Shares Outstanding
2006A
Current
-
-
-
NA -
NA -
NA -
LTM Return on Investment Ratios
NA
Return on Invested Capital Return on Equity Return on Assets Implied Annual Dividend Per Share
Depreciation & Amortization
Adjusted Net Income LTM Credit Statistics
% margin
Total Liabilities and Equity Balance Check
0.000
0.000
-
Less: Shares Repurchased
-
Net New Shares from Options Plus: Shares from Convertible Securities
-
Fully Diluted Shares Outstanding
-
Options/Warrants Number of Shares
Exercise Price
-
-
-
-
Tranche 5
-
-
-
-
Total
-
-
-
Tranche Tranche Tranche Tranche Tranche
1 2 3 4
In-the-Money Shares
Proceeds
-
Debt/Total Capitalization Total Debt/EBITDA
-
Net Debt/EBITDA EBITDA/Interest Expense
-
(EBITDA-capex)/Interest Expense
-
Cash Flow Statement Data
EBIT/Interest Expense
-
Depreciation & Amortization % sales Capital Ex penditures
Adjusted Diluted EPS
EBITDA
Conversion Price
Amount
Growth Rates Sales
Convertible Securities
% sales
EPS
Historical
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
-
-
-
Notes
Estimated 1-year 2-year CAGR Long-term
-
-
-
(1) (2) (3) (4)
[to come] [to come] [to come] [to come]
New Shares
-
-
-
-
Issue 2 Issue 3 Issue 4
-
-
-
-
Issue 5
-
-
-
Total
1-year 2-year CAGR
Conversion Ratio
Issue 1
-
Company C (NYSE:CCC)
Business Description
Input Page
[to come]
($ in millions, except per share data)
General Information
Reported Income Statement
Company Name
Balance Sheet Data
Company C
Ticker
Prior
CCC
Stock Exchange
Fiscal Year Ending December 31,
NYSE
Fiscal Year Ending
Dec-31
Moody's Corporate Rating
NA
S&P Corporate Rating Predicted Beta Marginal Tax Rate
NA 1.00 38.0%
Selected Market Data Current Price
1/0/1900
% of 52-week High 52-week High Price 52-week Low Price Dividend Per Share (MRQ)
-
NA -
1/0/1900 1/0/1900
2005A
2007A
2007A
Stub
Stub
LTM
9/302007
9/30/2008
9/30/2008
-
-
-
-
-
-
-
Inventories
-
-
COGS
-
-
-
-
-
-
Prepaids and Other Current Assets
-
-
Gross Profit SG&A Other Expense / (Income)
-
-
-
-
-
-
-
-
Property, Plant and Equipment, net
-
-
EBIT Interest Expense
-
-
-
-
-
-
Goodwill and Intangible Assets Other Assets
-
-
-
-
-
-
-
-
Total Assets
-
-
-
-
-
-
-
-
Pre-tax Income Income Taxes Noncontrolling Interest Preferred Dividends Net Income
Total Current Assets
Accounts Payable
-
-
-
-
-
-
-
-
Accrued Liabilities
-
-
-
-
-
-
-
-
Other Current Liabilities
-
-
NA
NA
NA
NA
NA
NA
Total Current Liabilities
-
Weighted Avg. Diluted Shares Diluted EPS
-
NA
NA
NA
NA
NA
NA
Total Debt Other Long-Term Liabilities
-
-
-
Adjusted Income Statement
Less: Cash and Cash Equivalents
-
Reported Gross Profit
-
-
-
-
-
-
Non-recurring Items in COGS
-
-
-
-
NA
NA
NA
Reported EBIT
-
-
Non-recurring Items in COGS Other Non-recurring Items
-
-
NA
Adjusted EBITDA % margin
Enterprise Value
-
-
Noncontrolling Interest
Total Liabilities
-
-
-
Preferred Stock
-
-
-
-
Shareholders' Equity
-
NA
NA
NA
-
-
-
-
Calculation of Fully Diluted Shares Outstanding
-
-
-
-
Basic Shares Outstanding Plus: Shares from In-the-Money Options
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
Reported Net Income
-
-
-
-
-
-
Non-recurring Items in COGS Other Non-recurring Items Non-operating Non-rec. Items Tax Adjustment
-
-
-
-
-
-
NA
NA
NA
NA
NA
NA
-
-
-
-
-
-
Adj. Gross Profit Trading Multiples
% margin
LTM 9/30/2008
NFY 2008E
NA -
NFY+1 2009E NA -
NA -
EV/EBITDA
NA
NA
NA
Adjusted EBIT
Metric EV/EBIT
NA
NA
NA
% margin
Metric
-
-
-
Plus: Total Debt Plus: Preferred Stock Plus: Noncontrolling Interest
P/E Metric
-
-
Equity Value
EV/Sales Metric
9/30/2008
Cash and Cash Equivalents Accounts Receivable
Sales
Effective Tax Rate Fully Diluted Shares Outstanding
2006A
Current
-
-
-
NA -
NA -
NA -
LTM Return on Investment Ratios
NA
Return on Invested Capital Return on Equity Return on Assets Implied Annual Dividend Per Share
Depreciation & Amortization
Adjusted Net Income LTM Credit Statistics
% margin
Total Liabilities and Equity Balance Check
0.000
0.000
-
Less: Shares Repurchased
-
Net New Shares from Options Plus: Shares from Convertible Securities
-
Fully Diluted Shares Outstanding
-
Options/Warrants Number of Shares
Exercise Price
-
-
-
-
Tranche 5
-
-
-
-
Total
-
-
-
Tranche Tranche Tranche Tranche Tranche
1 2 3 4
In-the-Money Shares
Proceeds
-
Debt/Total Capitalization Total Debt/EBITDA
-
Net Debt/EBITDA EBITDA/Interest Expense
-
(EBITDA-capex)/Interest Expense
-
Cash Flow Statement Data
EBIT/Interest Expense
-
Depreciation & Amortization % sales Capital Ex penditures
Adjusted Diluted EPS
EBITDA
Conversion Price
Amount
Growth Rates Sales
Convertible Securities
% sales
EPS
Historical
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
-
-
-
Notes
Estimated 1-year 2-year CAGR Long-term
-
-
-
(1) (2) (3) (4)
[to come] [to come] [to come] [to come]
New Shares
-
-
-
-
Issue 2 Issue 3 Issue 4
-
-
-
-
Issue 5
-
-
-
Total
1-year 2-year CAGR
Conversion Ratio
Issue 1
-
Company D (NYSE:DDD)
Business Description
Input Page
[to come]
($ in millions, except per share data)
General Information
Reported Income Statement
Company Name
Balance Sheet Data
Company D
Ticker
Prior
DDD
Stock Exchange
Fiscal Year Ending December 31,
NYSE
Fiscal Year Ending
Dec-31
Moody's Corporate Rating
NA
S&P Corporate Rating Predicted Beta Marginal Tax Rate
NA 1.00 38.0%
Selected Market Data Current Price
1/0/1900
% of 52-week High 52-week High Price 52-week Low Price Dividend Per Share (MRQ)
-
NA -
1/0/1900 1/0/1900
2005A
2007A
2007A
Stub
Stub
LTM
9/302007
9/30/2008
9/30/2008
-
-
-
-
-
-
-
Inventories
-
-
COGS
-
-
-
-
-
-
Prepaids and Other Current Assets
-
-
Gross Profit SG&A Other Expense / (Income)
-
-
-
-
-
-
-
-
Property, Plant and Equipment, net
-
-
EBIT Interest Expense
-
-
-
-
-
-
Goodwill and Intangible Assets Other Assets
-
-
-
-
-
-
-
-
Total Assets
-
-
-
-
-
-
-
-
Pre-tax Income Income Taxes Noncontrolling Interest Preferred Dividends Net Income
Total Current Assets
Accounts Payable
-
-
-
-
-
-
-
-
Accrued Liabilities
-
-
-
-
-
-
-
-
Other Current Liabilities
-
-
NA
NA
NA
NA
NA
NA
Total Current Liabilities
-
Weighted Avg. Diluted Shares Diluted EPS
-
NA
NA
NA
NA
NA
NA
Total Debt Other Long-Term Liabilities
-
-
-
Adjusted Income Statement
Less: Cash and Cash Equivalents
-
Reported Gross Profit
-
-
-
-
-
-
Non-recurring Items in COGS
-
-
-
-
NA
NA
NA
Reported EBIT
-
-
Non-recurring Items in COGS Other Non-recurring Items
-
-
NA
Adjusted EBITDA % margin
Enterprise Value
-
-
Noncontrolling Interest
Total Liabilities
-
-
-
Preferred Stock
-
-
-
-
Shareholders' Equity
-
NA
NA
NA
-
-
-
-
Calculation of Fully Diluted Shares Outstanding
-
-
-
-
Basic Shares Outstanding Plus: Shares from In-the-Money Options
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
Reported Net Income
-
-
-
-
-
-
Non-recurring Items in COGS Other Non-recurring Items Non-operating Non-rec. Items Tax Adjustment
-
-
-
-
-
-
NA
NA
NA
NA
NA
NA
-
-
-
-
-
-
Adj. Gross Profit Trading Multiples
% margin
LTM 9/30/2008
NFY 2008E
NA -
NFY+1 2009E NA -
NA -
EV/EBITDA
NA
NA
NA
Adjusted EBIT
Metric EV/EBIT
NA
NA
NA
% margin
Metric
-
-
-
Plus: Total Debt Plus: Preferred Stock Plus: Noncontrolling Interest
P/E Metric
-
-
Equity Value
EV/Sales Metric
9/30/2008
Cash and Cash Equivalents Accounts Receivable
Sales
Effective Tax Rate Fully Diluted Shares Outstanding
2006A
Current
-
-
-
NA -
NA -
NA -
LTM Return on Investment Ratios
NA
Return on Invested Capital Return on Equity Return on Assets Implied Annual Dividend Per Share
Depreciation & Amortization
Adjusted Net Income LTM Credit Statistics
% margin
Total Liabilities and Equity Balance Check
0.000
0.000
-
Less: Shares Repurchased
-
Net New Shares from Options Plus: Shares from Convertible Securities
-
Fully Diluted Shares Outstanding
-
Options/Warrants Number of Shares
Exercise Price
-
-
-
-
Tranche 5
-
-
-
-
Total
-
-
-
Tranche Tranche Tranche Tranche Tranche
1 2 3 4
In-the-Money Shares
Proceeds
-
Debt/Total Capitalization Total Debt/EBITDA
-
Net Debt/EBITDA EBITDA/Interest Expense
-
(EBITDA-capex)/Interest Expense
-
Cash Flow Statement Data
EBIT/Interest Expense
-
Depreciation & Amortization % sales Capital Ex penditures
Adjusted Diluted EPS
EBITDA
Conversion Price
Amount
Growth Rates Sales
Convertible Securities
% sales
EPS
Historical
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
-
-
-
Notes
Estimated 1-year 2-year CAGR Long-term
-
-
-
(1) (2) (3) (4)
[to come] [to come] [to come] [to come]
New Shares
-
-
-
-
Issue 2 Issue 3 Issue 4
-
-
-
-
Issue 5
-
-
-
Total
1-year 2-year CAGR
Conversion Ratio
Issue 1
-
Company E (NYSE:EEE)
Business Description
Input Page
[to come]
($ in millions, except per share data)
General Information
Reported Income Statement
Company Name
Balance Sheet Data
Company E
Ticker
Prior
EEE
Stock Exchange
Fiscal Year Ending December 31,
NYSE
Fiscal Year Ending
Dec-31
Moody's Corporate Rating
NA
S&P Corporate Rating Predicted Beta Marginal Tax Rate
NA 1.00 38.0%
Selected Market Data Current Price
1/0/1900
% of 52-week High 52-week High Price 52-week Low Price Dividend Per Share (MRQ)
-
NA -
1/0/1900 1/0/1900
2005A
2007A
2007A
Stub
Stub
LTM
9/302007
9/30/2008
9/30/2008
-
-
-
-
-
-
-
Inventories
-
-
COGS
-
-
-
-
-
-
Prepaids and Other Current Assets
-
-
Gross Profit SG&A Other Expense / (Income)
-
-
-
-
-
-
-
-
Property, Plant and Equipment, net
-
-
EBIT Interest Expense
-
-
-
-
-
-
Goodwill and Intangible Assets Other Assets
-
-
-
-
-
-
-
-
Total Assets
-
-
-
-
-
-
-
-
Pre-tax Income Income Taxes Noncontrolling Interest Preferred Dividends Net Income
Total Current Assets
Accounts Payable
-
-
-
-
-
-
-
-
Accrued Liabilities
-
-
-
-
-
-
-
-
Other Current Liabilities
-
-
NA
NA
NA
NA
NA
NA
Total Current Liabilities
-
Weighted Avg. Diluted Shares Diluted EPS
-
NA
NA
NA
NA
NA
NA
Total Debt Other Long-Term Liabilities
-
-
-
Adjusted Income Statement
Less: Cash and Cash Equivalents
-
Reported Gross Profit
-
-
-
-
-
-
Non-recurring Items in COGS
-
-
-
-
NA
NA
NA
Reported EBIT
-
-
Non-recurring Items in COGS Other Non-recurring Items
-
-
NA
Adjusted EBITDA % margin
Enterprise Value
-
-
Noncontrolling Interest
Total Liabilities
-
-
-
Preferred Stock
-
-
-
-
Shareholders' Equity
-
NA
NA
NA
-
-
-
-
Calculation of Fully Diluted Shares Outstanding
-
-
-
-
Basic Shares Outstanding Plus: Shares from In-the-Money Options
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
Reported Net Income
-
-
-
-
-
-
Non-recurring Items in COGS Other Non-recurring Items Non-operating Non-rec. Items Tax Adjustment
-
-
-
-
-
-
NA
NA
NA
NA
NA
NA
-
-
-
-
-
-
Adj. Gross Profit Trading Multiples
% margin
LTM 9/30/2008
NFY 2008E
NA -
NFY+1 2009E NA -
NA -
EV/EBITDA
NA
NA
NA
Adjusted EBIT
Metric EV/EBIT
NA
NA
NA
% margin
Metric
-
-
-
Plus: Total Debt Plus: Preferred Stock Plus: Noncontrolling Interest
P/E Metric
-
-
Equity Value
EV/Sales Metric
9/30/2008
Cash and Cash Equivalents Accounts Receivable
Sales
Effective Tax Rate Fully Diluted Shares Outstanding
2006A
Current
-
-
-
NA -
NA -
NA -
LTM Return on Investment Ratios
NA
Return on Invested Capital Return on Equity Return on Assets Implied Annual Dividend Per Share
Depreciation & Amortization
Adjusted Net Income LTM Credit Statistics
% margin
Total Liabilities and Equity Balance Check
0.000
0.000
-
Less: Shares Repurchased
-
Net New Shares from Options Plus: Shares from Convertible Securities
-
Fully Diluted Shares Outstanding
-
Options/Warrants Number of Shares
Exercise Price
-
-
-
-
Tranche 5
-
-
-
-
Total
-
-
-
Tranche Tranche Tranche Tranche Tranche
1 2 3 4
In-the-Money Shares
Proceeds
-
Debt/Total Capitalization Total Debt/EBITDA
-
Net Debt/EBITDA EBITDA/Interest Expense
-
(EBITDA-capex)/Interest Expense
-
Cash Flow Statement Data
EBIT/Interest Expense
-
Depreciation & Amortization % sales Capital Ex penditures
Adjusted Diluted EPS
EBITDA
Conversion Price
Amount
Growth Rates Sales
Convertible Securities
% sales
EPS
Historical
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
-
-
-
Notes
Estimated 1-year 2-year CAGR Long-term
-
-
-
(1) (2) (3) (4)
[to come] [to come] [to come] [to come]
New Shares
-
-
-
-
Issue 2 Issue 3 Issue 4
-
-
-
-
Issue 5
-
-
-
Total
1-year 2-year CAGR
Conversion Ratio
Issue 1
-
Company F (NYSE:FFF)
Business Description
Input Page
[to come]
($ in millions, except per share data)
General Information
Reported Income Statement
Company Name
Balance Sheet Data
Company F
Ticker
Prior
FFF
Stock Exchange
Fiscal Year Ending December 31,
NYSE
Fiscal Year Ending
Dec-31
Moody's Corporate Rating
NA
S&P Corporate Rating Predicted Beta Marginal Tax Rate
NA 1.00 38.0%
Selected Market Data Current Price
1/0/1900
% of 52-week High 52-week High Price 52-week Low Price Dividend Per Share (MRQ)
-
NA -
1/0/1900 1/0/1900
2005A
2007A
2007A
Stub
Stub
LTM
9/302007
9/30/2008
9/30/2008
-
-
-
-
-
-
-
Inventories
-
-
COGS
-
-
-
-
-
-
Prepaids and Other Current Assets
-
-
Gross Profit SG&A Other Expense / (Income)
-
-
-
-
-
-
-
-
Property, Plant and Equipment, net
-
-
EBIT Interest Expense
-
-
-
-
-
-
Goodwill and Intangible Assets Other Assets
-
-
-
-
-
-
-
-
Total Assets
-
-
-
-
-
-
-
-
Pre-tax Income Income Taxes Noncontrolling Interest Preferred Dividends Net Income
Total Current Assets
Accounts Payable
-
-
-
-
-
-
-
-
Accrued Liabilities
-
-
-
-
-
-
-
-
Other Current Liabilities
-
-
NA
NA
NA
NA
NA
NA
Total Current Liabilities
-
Weighted Avg. Diluted Shares Diluted EPS
-
NA
NA
NA
NA
NA
NA
Total Debt Other Long-Term Liabilities
-
-
-
Adjusted Income Statement
Less: Cash and Cash Equivalents
-
Reported Gross Profit
-
-
-
-
-
-
Non-recurring Items in COGS
-
-
-
-
NA
NA
NA
Reported EBIT
-
-
Non-recurring Items in COGS Other Non-recurring Items
-
-
NA
Adjusted EBITDA % margin
Enterprise Value
-
-
Noncontrolling Interest
Total Liabilities
-
-
-
Preferred Stock
-
-
-
-
Shareholders' Equity
-
NA
NA
NA
-
-
-
-
Calculation of Fully Diluted Shares Outstanding
-
-
-
-
Basic Shares Outstanding Plus: Shares from In-the-Money Options
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
Reported Net Income
-
-
-
-
-
-
Non-recurring Items in COGS Other Non-recurring Items Non-operating Non-rec. Items Tax Adjustment
-
-
-
-
-
-
NA
NA
NA
NA
NA
NA
-
-
-
-
-
-
Adj. Gross Profit Trading Multiples
% margin
LTM 9/30/2008
NFY 2008E
NA -
NFY+1 2009E NA -
NA -
EV/EBITDA
NA
NA
NA
Adjusted EBIT
Metric EV/EBIT
NA
NA
NA
% margin
Metric
-
-
-
Plus: Total Debt Plus: Preferred Stock Plus: Noncontrolling Interest
P/E Metric
-
-
Equity Value
EV/Sales Metric
9/30/2008
Cash and Cash Equivalents Accounts Receivable
Sales
Effective Tax Rate Fully Diluted Shares Outstanding
2006A
Current
-
-
-
NA -
NA -
NA -
LTM Return on Investment Ratios
NA
Return on Invested Capital Return on Equity Return on Assets Implied Annual Dividend Per Share
Depreciation & Amortization
Adjusted Net Income LTM Credit Statistics
% margin
Total Liabilities and Equity Balance Check
0.000
0.000
-
Less: Shares Repurchased
-
Net New Shares from Options Plus: Shares from Convertible Securities
-
Fully Diluted Shares Outstanding
-
Options/Warrants Number of Shares
Exercise Price
-
-
-
-
Tranche 5
-
-
-
-
Total
-
-
-
Tranche Tranche Tranche Tranche Tranche
1 2 3 4
In-the-Money Shares
Proceeds
-
Debt/Total Capitalization Total Debt/EBITDA
-
Net Debt/EBITDA EBITDA/Interest Expense
-
(EBITDA-capex)/Interest Expense
-
Cash Flow Statement Data
EBIT/Interest Expense
-
Depreciation & Amortization % sales Capital Ex penditures
Adjusted Diluted EPS
EBITDA
Conversion Price
Amount
Growth Rates Sales
Convertible Securities
% sales
EPS
Historical
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
-
-
-
Notes
Estimated 1-year 2-year CAGR Long-term
-
-
-
(1) (2) (3) (4)
[to come] [to come] [to come] [to come]
New Shares
-
-
-
-
Issue 2 Issue 3 Issue 4
-
-
-
-
Issue 5
-
-
-
Total
1-year 2-year CAGR
Conversion Ratio
Issue 1
-
Company G (NYSE:GGG)
Business Description
Input Page
[to come]
($ in millions, except per share data)
General Information
Reported Income Statement
Company Name
Balance Sheet Data
Company G
Ticker
Prior
GGG
Stock Exchange
Fiscal Year Ending December 31,
NYSE
Fiscal Year Ending
Dec-31
Moody's Corporate Rating
NA
S&P Corporate Rating Predicted Beta Marginal Tax Rate
NA 1.00 38.0%
Selected Market Data Current Price
1/0/1900
% of 52-week High 52-week High Price 52-week Low Price Dividend Per Share (MRQ)
-
NA -
1/0/1900 1/0/1900
2005A
2007A
2007A
Stub
Stub
LTM
9/302007
9/30/2008
9/30/2008
-
-
-
-
-
-
-
Inventories
-
-
COGS
-
-
-
-
-
-
Prepaids and Other Current Assets
-
-
Gross Profit SG&A Other Expense / (Income)
-
-
-
-
-
-
-
-
Property, Plant and Equipment, net
-
-
EBIT Interest Expense
-
-
-
-
-
-
Goodwill and Intangible Assets Other Assets
-
-
-
-
-
-
-
-
Total Assets
-
-
-
-
-
-
-
-
Pre-tax Income Income Taxes Noncontrolling Interest Preferred Dividends Net Income
Total Current Assets
Accounts Payable
-
-
-
-
-
-
-
-
Accrued Liabilities
-
-
-
-
-
-
-
-
Other Current Liabilities
-
-
NA
NA
NA
NA
NA
NA
Total Current Liabilities
-
Weighted Avg. Diluted Shares Diluted EPS
-
NA
NA
NA
NA
NA
NA
Total Debt Other Long-Term Liabilities
-
-
-
Adjusted Income Statement
Less: Cash and Cash Equivalents
-
Reported Gross Profit
-
-
-
-
-
-
Non-recurring Items in COGS
-
-
-
-
NA
NA
NA
Reported EBIT
-
-
Non-recurring Items in COGS Other Non-recurring Items
-
-
NA
Adjusted EBITDA % margin
Enterprise Value
-
-
Noncontrolling Interest
Total Liabilities
-
-
-
Preferred Stock
-
-
-
-
Shareholders' Equity
-
NA
NA
NA
-
-
-
-
Calculation of Fully Diluted Shares Outstanding
-
-
-
-
Basic Shares Outstanding Plus: Shares from In-the-Money Options
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
Reported Net Income
-
-
-
-
-
-
Non-recurring Items in COGS Other Non-recurring Items Non-operating Non-rec. Items Tax Adjustment
-
-
-
-
-
-
NA
NA
NA
NA
NA
NA
-
-
-
-
-
-
Adj. Gross Profit Trading Multiples
% margin
LTM 9/30/2008
NFY 2008E
NA -
NFY+1 2009E NA -
NA -
EV/EBITDA
NA
NA
NA
Adjusted EBIT
Metric EV/EBIT
NA
NA
NA
% margin
Metric
-
-
-
Plus: Total Debt Plus: Preferred Stock Plus: Noncontrolling Interest
P/E Metric
-
-
Equity Value
EV/Sales Metric
9/30/2008
Cash and Cash Equivalents Accounts Receivable
Sales
Effective Tax Rate Fully Diluted Shares Outstanding
2006A
Current
-
-
-
NA -
NA -
NA -
LTM Return on Investment Ratios
NA
Return on Invested Capital Return on Equity Return on Assets Implied Annual Dividend Per Share
Depreciation & Amortization
Adjusted Net Income LTM Credit Statistics
% margin
Total Liabilities and Equity Balance Check
0.000
0.000
-
Less: Shares Repurchased
-
Net New Shares from Options Plus: Shares from Convertible Securities
-
Fully Diluted Shares Outstanding
-
Options/Warrants Number of Shares
Exercise Price
-
-
-
-
Tranche 5
-
-
-
-
Total
-
-
-
Tranche Tranche Tranche Tranche Tranche
1 2 3 4
In-the-Money Shares
Proceeds
-
Debt/Total Capitalization Total Debt/EBITDA
-
Net Debt/EBITDA EBITDA/Interest Expense
-
(EBITDA-capex)/Interest Expense
-
Cash Flow Statement Data
EBIT/Interest Expense
-
Depreciation & Amortization % sales Capital Ex penditures
Adjusted Diluted EPS
EBITDA
Conversion Price
Amount
Growth Rates Sales
Convertible Securities
% sales
EPS
Historical
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
-
-
-
Notes
Estimated 1-year 2-year CAGR Long-term
-
-
-
(1) (2) (3) (4)
[to come] [to come] [to come] [to come]
New Shares
-
-
-
-
Issue 2 Issue 3 Issue 4
-
-
-
-
Issue 5
-
-
-
Total
1-year 2-year CAGR
Conversion Ratio
Issue 1
-
Company H (NYSE:HHH)
Business Description
Input Page
[to come]
($ in millions, except per share data)
General Information
Reported Income Statement
Company Name
Balance Sheet Data
Company H
Ticker
Prior
HHH
Stock Exchange
Fiscal Year Ending December 31,
NYSE
Fiscal Year Ending
Dec-31
Moody's Corporate Rating
NA
S&P Corporate Rating Predicted Beta Marginal Tax Rate
NA 1.00 38.0%
Selected Market Data Current Price
1/0/1900
% of 52-week High 52-week High Price 52-week Low Price Dividend Per Share (MRQ)
-
NA -
1/0/1900 1/0/1900
2005A
2007A
2007A
Stub
Stub
LTM
9/302007
9/30/2008
9/30/2008
-
-
-
-
-
-
-
Inventories
-
-
COGS
-
-
-
-
-
-
Prepaids and Other Current Assets
-
-
Gross Profit SG&A Other Expense / (Income)
-
-
-
-
-
-
-
-
Property, Plant and Equipment, net
-
-
EBIT Interest Expense
-
-
-
-
-
-
Goodwill and Intangible Assets Other Assets
-
-
-
-
-
-
-
-
Total Assets
-
-
-
-
-
-
-
-
Pre-tax Income Income Taxes Noncontrolling Interest Preferred Dividends Net Income
Total Current Assets
Accounts Payable
-
-
-
-
-
-
-
-
Accrued Liabilities
-
-
-
-
-
-
-
-
Other Current Liabilities
-
-
NA
NA
NA
NA
NA
NA
Total Current Liabilities
-
Weighted Avg. Diluted Shares Diluted EPS
-
NA
NA
NA
NA
NA
NA
Total Debt Other Long-Term Liabilities
-
-
-
Adjusted Income Statement
Less: Cash and Cash Equivalents
-
Reported Gross Profit
-
-
-
-
-
-
Non-recurring Items in COGS
-
-
-
-
NA
NA
NA
Reported EBIT
-
-
Non-recurring Items in COGS Other Non-recurring Items
-
-
NA
Adjusted EBITDA % margin
Enterprise Value
-
-
Noncontrolling Interest
Total Liabilities
-
-
-
Preferred Stock
-
-
-
-
Shareholders' Equity
-
NA
NA
NA
-
-
-
-
Calculation of Fully Diluted Shares Outstanding
-
-
-
-
Basic Shares Outstanding Plus: Shares from In-the-Money Options
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
Reported Net Income
-
-
-
-
-
-
Non-recurring Items in COGS Other Non-recurring Items Non-operating Non-rec. Items Tax Adjustment
-
-
-
-
-
-
NA
NA
NA
NA
NA
NA
-
-
-
-
-
-
Adj. Gross Profit Trading Multiples
% margin
LTM 9/30/2008
NFY 2008E
NA -
NFY+1 2009E NA -
NA -
EV/EBITDA
NA
NA
NA
Adjusted EBIT
Metric EV/EBIT
NA
NA
NA
% margin
Metric
-
-
-
Plus: Total Debt Plus: Preferred Stock Plus: Noncontrolling Interest
P/E Metric
-
-
Equity Value
EV/Sales Metric
9/30/2008
Cash and Cash Equivalents Accounts Receivable
Sales
Effective Tax Rate Fully Diluted Shares Outstanding
2006A
Current
-
-
-
NA -
NA -
NA -
LTM Return on Investment Ratios
NA
Return on Invested Capital Return on Equity Return on Assets Implied Annual Dividend Per Share
Depreciation & Amortization
Adjusted Net Income LTM Credit Statistics
% margin
Total Liabilities and Equity Balance Check
0.000
0.000
-
Less: Shares Repurchased
-
Net New Shares from Options Plus: Shares from Convertible Securities
-
Fully Diluted Shares Outstanding
-
Options/Warrants Number of Shares
Exercise Price
-
-
-
-
Tranche 5
-
-
-
-
Total
-
-
-
Tranche Tranche Tranche Tranche Tranche
1 2 3 4
In-the-Money Shares
Proceeds
-
Debt/Total Capitalization Total Debt/EBITDA
-
Net Debt/EBITDA EBITDA/Interest Expense
-
(EBITDA-capex)/Interest Expense
-
Cash Flow Statement Data
EBIT/Interest Expense
-
Depreciation & Amortization % sales Capital Ex penditures
Adjusted Diluted EPS
EBITDA
Conversion Price
Amount
Growth Rates Sales
Convertible Securities
% sales
EPS
Historical
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
-
-
-
Notes
Estimated 1-year 2-year CAGR Long-term
-
-
-
(1) (2) (3) (4)
[to come] [to come] [to come] [to come]
New Shares
-
-
-
-
Issue 2 Issue 3 Issue 4
-
-
-
-
Issue 5
-
-
-
Total
1-year 2-year CAGR
Conversion Ratio
Issue 1
-
Company I (NYSE:III)
Business Description
Input Page
[to come]
($ in millions, except per share data)
General Information
Reported Income Statement
Company Name
Balance Sheet Data
Company I
Ticker
Prior
III
Stock Exchange
Fiscal Year Ending December 31,
NYSE
Fiscal Year Ending
Dec-31
Moody's Corporate Rating
NA
S&P Corporate Rating Predicted Beta Marginal Tax Rate
NA 1.00 38.0%
Selected Market Data Current Price
1/0/1900
% of 52-week High 52-week High Price 52-week Low Price Dividend Per Share (MRQ)
-
NA -
1/0/1900 1/0/1900
2005A
2007A
2007A
Stub
Stub
LTM
9/302007
9/30/2008
9/30/2008
-
-
-
-
-
-
-
Inventories
-
-
COGS
-
-
-
-
-
-
Prepaids and Other Current Assets
-
-
Gross Profit SG&A Other Expense / (Income)
-
-
-
-
-
-
-
-
Property, Plant and Equipment, net
-
-
EBIT Interest Expense
-
-
-
-
-
-
Goodwill and Intangible Assets Other Assets
-
-
-
-
-
-
-
-
Total Assets
-
-
-
-
-
-
-
-
Pre-tax Income Income Taxes Noncontrolling Interest Preferred Dividends Net Income
Total Current Assets
Accounts Payable
-
-
-
-
-
-
-
-
Accrued Liabilities
-
-
-
-
-
-
-
-
Other Current Liabilities
-
-
NA
NA
NA
NA
NA
NA
Total Current Liabilities
-
Weighted Avg. Diluted Shares Diluted EPS
-
NA
NA
NA
NA
NA
NA
Total Debt Other Long-Term Liabilities
-
-
-
Adjusted Income Statement
Less: Cash and Cash Equivalents
-
Reported Gross Profit
-
-
-
-
-
-
Non-recurring Items in COGS
-
-
-
-
NA
NA
NA
Reported EBIT
-
-
Non-recurring Items in COGS Other Non-recurring Items
-
-
NA
Adjusted EBITDA % margin
Enterprise Value
-
-
Noncontrolling Interest
Total Liabilities
-
-
-
Preferred Stock
-
-
-
-
Shareholders' Equity
-
NA
NA
NA
-
-
-
-
Calculation of Fully Diluted Shares Outstanding
-
-
-
-
Basic Shares Outstanding Plus: Shares from In-the-Money Options
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
Reported Net Income
-
-
-
-
-
-
Non-recurring Items in COGS Other Non-recurring Items Non-operating Non-rec. Items Tax Adjustment
-
-
-
-
-
-
NA
NA
NA
NA
NA
NA
-
-
-
-
-
-
Adj. Gross Profit Trading Multiples
% margin
LTM 9/30/2008
NFY 2008E
NA -
NFY+1 2009E NA -
NA -
EV/EBITDA
NA
NA
NA
Adjusted EBIT
Metric EV/EBIT
NA
NA
NA
% margin
Metric
-
-
-
Plus: Total Debt Plus: Preferred Stock Plus: Noncontrolling Interest
P/E Metric
-
-
Equity Value
EV/Sales Metric
9/30/2008
Cash and Cash Equivalents Accounts Receivable
Sales
Effective Tax Rate Fully Diluted Shares Outstanding
2006A
Current
-
-
-
NA -
NA -
NA -
LTM Return on Investment Ratios
NA
Return on Invested Capital Return on Equity Return on Assets Implied Annual Dividend Per Share
Depreciation & Amortization
Adjusted Net Income LTM Credit Statistics
% margin
Total Liabilities and Equity Balance Check
0.000
0.000
-
Less: Shares Repurchased
-
Net New Shares from Options Plus: Shares from Convertible Securities
-
Fully Diluted Shares Outstanding
-
Options/Warrants Number of Shares
Exercise Price
-
-
-
-
Tranche 5
-
-
-
-
Total
-
-
-
Tranche Tranche Tranche Tranche Tranche
1 2 3 4
In-the-Money Shares
Proceeds
-
Debt/Total Capitalization Total Debt/EBITDA
-
Net Debt/EBITDA EBITDA/Interest Expense
-
(EBITDA-capex)/Interest Expense
-
Cash Flow Statement Data
EBIT/Interest Expense
-
Depreciation & Amortization % sales Capital Ex penditures
Adjusted Diluted EPS
EBITDA
Conversion Price
Amount
Growth Rates Sales
Convertible Securities
% sales
EPS
Historical
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
-
-
-
Notes
Estimated 1-year 2-year CAGR Long-term
-
-
-
(1) (2) (3) (4)
[to come] [to come] [to come] [to come]
New Shares
-
-
-
-
Issue 2 Issue 3 Issue 4
-
-
-
-
Issue 5
-
-
-
Total
1-year 2-year CAGR
Conversion Ratio
Issue 1
-
Company J (NYSE:JJJ)
Business Description
Input Page
[to come]
($ in millions, except per share data)
General Information
Reported Income Statement
Company Name
Balance Sheet Data
Company J
Ticker
Prior
JJJ
Stock Exchange
Fiscal Year Ending December 31,
NYSE
Fiscal Year Ending
Dec-31
Moody's Corporate Rating
NA
S&P Corporate Rating Predicted Beta Marginal Tax Rate
NA 1.00 38.0%
Selected Market Data Current Price
1/0/1900
% of 52-week High 52-week High Price 52-week Low Price Dividend Per Share (MRQ)
-
NA -
1/0/1900 1/0/1900
2005A
2007A
2007A
Stub
Stub
LTM
9/302007
9/30/2008
9/30/2008
-
-
-
-
-
-
-
Inventories
-
-
COGS
-
-
-
-
-
-
Prepaids and Other Current Assets
-
-
Gross Profit SG&A Other Expense / (Income)
-
-
-
-
-
-
-
-
Property, Plant and Equipment, net
-
-
EBIT Interest Expense
-
-
-
-
-
-
Goodwill and Intangible Assets Other Assets
-
-
-
-
-
-
-
-
Total Assets
-
-
-
-
-
-
-
-
Pre-tax Income Income Taxes Noncontrolling Interest Preferred Dividends Net Income
Total Current Assets
Accounts Payable
-
-
-
-
-
-
-
-
Accrued Liabilities
-
-
-
-
-
-
-
-
Other Current Liabilities
-
-
NA
NA
NA
NA
NA
NA
Total Current Liabilities
-
Weighted Avg. Diluted Shares Diluted EPS
-
NA
NA
NA
NA
NA
NA
Total Debt Other Long-Term Liabilities
-
-
-
Adjusted Income Statement
Less: Cash and Cash Equivalents
-
Reported Gross Profit
-
-
-
-
-
-
Non-recurring Items in COGS
-
-
-
-
NA
NA
NA
Reported EBIT
-
-
Non-recurring Items in COGS Other Non-recurring Items
-
-
NA
Adjusted EBITDA % margin
Enterprise Value
-
-
Noncontrolling Interest
Total Liabilities
-
-
-
Preferred Stock
-
-
-
-
Shareholders' Equity
-
NA
NA
NA
-
-
-
-
Calculation of Fully Diluted Shares Outstanding
-
-
-
-
Basic Shares Outstanding Plus: Shares from In-the-Money Options
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
Reported Net Income
-
-
-
-
-
-
Non-recurring Items in COGS Other Non-recurring Items Non-operating Non-rec. Items Tax Adjustment
-
-
-
-
-
-
NA
NA
NA
NA
NA
NA
-
-
-
-
-
-
Adj. Gross Profit Trading Multiples
% margin
LTM 9/30/2008
NFY 2008E
NA -
NFY+1 2009E NA -
NA -
EV/EBITDA
NA
NA
NA
Adjusted EBIT
Metric EV/EBIT
NA
NA
NA
% margin
Metric
-
-
-
Plus: Total Debt Plus: Preferred Stock Plus: Noncontrolling Interest
P/E Metric
-
-
Equity Value
EV/Sales Metric
9/30/2008
Cash and Cash Equivalents Accounts Receivable
Sales
Effective Tax Rate Fully Diluted Shares Outstanding
2006A
Current
-
-
-
NA -
NA -
NA -
LTM Return on Investment Ratios
NA
Return on Invested Capital Return on Equity Return on Assets Implied Annual Dividend Per Share
Depreciation & Amortization
Adjusted Net Income LTM Credit Statistics
% margin
Total Liabilities and Equity Balance Check
0.000
0.000
-
Less: Shares Repurchased
-
Net New Shares from Options Plus: Shares from Convertible Securities
-
Fully Diluted Shares Outstanding
-
Options/Warrants Number of Shares
Exercise Price
-
-
-
-
Tranche 5
-
-
-
-
Total
-
-
-
Tranche Tranche Tranche Tranche Tranche
1 2 3 4
In-the-Money Shares
Proceeds
-
Debt/Total Capitalization Total Debt/EBITDA
-
Net Debt/EBITDA EBITDA/Interest Expense
-
(EBITDA-capex)/Interest Expense
-
Cash Flow Statement Data
EBIT/Interest Expense
-
Depreciation & Amortization % sales Capital Ex penditures
Adjusted Diluted EPS
EBITDA
Conversion Price
Amount
Growth Rates Sales
Convertible Securities
% sales
EPS
Historical
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
-
-
-
Notes
Estimated 1-year 2-year CAGR Long-term
-
-
-
(1) (2) (3) (4)
[to come] [to come] [to come] [to come]
New Shares
-
-
-
-
Issue 2 Issue 3 Issue 4
-
-
-
-
Issue 5
-
-
-
Total
1-year 2-year CAGR
Conversion Ratio
Issue 1
-
Company K (NYSE:K--)
Business Description
Input Page
[to come]
($ in millions, except per share data)
General Information
Reported Income Statement
Company Name
Balance Sheet Data
Company K
Ticker
Prior
K--
Stock Exchange
Fiscal Year Ending December 31,
NYSE
Fiscal Year Ending
Dec-31
Moody's Corporate Rating
NA
S&P Corporate Rating Predicted Beta Marginal Tax Rate
NA 1.00 38.0%
Selected Market Data Current Price
1/0/1900
% of 52-week High 52-week High Price 52-week Low Price Dividend Per Share (MRQ)
-
NA -
1/0/1900 1/0/1900
2005A
2007A
2007A
Stub
Stub
LTM
9/302007
9/30/2008
9/30/2008
-
-
-
-
-
-
-
Inventories
-
-
COGS
-
-
-
-
-
-
Prepaids and Other Current Assets
-
-
Gross Profit SG&A Other Expense / (Income)
-
-
-
-
-
-
-
-
Property, Plant and Equipment, net
-
-
EBIT Interest Expense
-
-
-
-
-
-
Goodwill and Intangible Assets Other Assets
-
-
-
-
-
-
-
-
Total Assets
-
-
-
-
-
-
-
-
Pre-tax Income Income Taxes Noncontrolling Interest Preferred Dividends Net Income
Total Current Assets
Accounts Payable
-
-
-
-
-
-
-
-
Accrued Liabilities
-
-
-
-
-
-
-
-
Other Current Liabilities
-
-
NA
NA
NA
NA
NA
NA
Total Current Liabilities
-
Weighted Avg. Diluted Shares Diluted EPS
-
NA
NA
NA
NA
NA
NA
Total Debt Other Long-Term Liabilities
-
-
-
Adjusted Income Statement
Less: Cash and Cash Equivalents
-
Reported Gross Profit
-
-
-
-
-
-
Non-recurring Items in COGS
-
-
-
-
NA
NA
NA
Reported EBIT
-
-
Non-recurring Items in COGS Other Non-recurring Items
-
-
NA
Adjusted EBITDA % margin
Enterprise Value
-
-
Noncontrolling Interest
Total Liabilities
-
-
-
Preferred Stock
-
-
-
-
Shareholders' Equity
-
NA
NA
NA
-
-
-
-
Calculation of Fully Diluted Shares Outstanding
-
-
-
-
Basic Shares Outstanding Plus: Shares from In-the-Money Options
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
Reported Net Income
-
-
-
-
-
-
Non-recurring Items in COGS Other Non-recurring Items Non-operating Non-rec. Items Tax Adjustment
-
-
-
-
-
-
NA
NA
NA
NA
NA
NA
-
-
-
-
-
-
Adj. Gross Profit Trading Multiples
% margin
LTM 9/30/2008
NFY 2008E
NA -
NFY+1 2009E NA -
NA -
EV/EBITDA
NA
NA
NA
Adjusted EBIT
Metric EV/EBIT
NA
NA
NA
% margin
Metric
-
-
-
Plus: Total Debt Plus: Preferred Stock Plus: Noncontrolling Interest
P/E Metric
-
-
Equity Value
EV/Sales Metric
9/30/2008
Cash and Cash Equivalents Accounts Receivable
Sales
Effective Tax Rate Fully Diluted Shares Outstanding
2006A
Current
-
-
-
NA -
NA -
NA -
LTM Return on Investment Ratios
NA
Return on Invested Capital Return on Equity Return on Assets Implied Annual Dividend Per Share
Depreciation & Amortization
Adjusted Net Income LTM Credit Statistics
% margin
Total Liabilities and Equity Balance Check
0.000
0.000
-
Less: Shares Repurchased
-
Net New Shares from Options Plus: Shares from Convertible Securities
-
Fully Diluted Shares Outstanding
-
Options/Warrants Number of Shares
Exercise Price
-
-
-
-
Tranche 5
-
-
-
-
Total
-
-
-
Tranche Tranche Tranche Tranche Tranche
1 2 3 4
In-the-Money Shares
Proceeds
-
Debt/Total Capitalization Total Debt/EBITDA
-
Net Debt/EBITDA EBITDA/Interest Expense
-
(EBITDA-capex)/Interest Expense
-
Cash Flow Statement Data
EBIT/Interest Expense
-
Depreciation & Amortization % sales Capital Ex penditures
Adjusted Diluted EPS
EBITDA
Conversion Price
Amount
Growth Rates Sales
Convertible Securities
% sales
EPS
Historical
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
-
-
-
Notes
Estimated 1-year 2-year CAGR Long-term
-
-
-
(1) (2) (3) (4)
[to come] [to come] [to come] [to come]
New Shares
-
-
-
-
Issue 2 Issue 3 Issue 4
-
-
-
-
Issue 5
-
-
-
Total
1-year 2-year CAGR
Conversion Ratio
Issue 1
-
Company L (NYSE:LLL)
Business Description
Input Page
[to come]
($ in millions, except per share data)
General Information
Reported Income Statement
Company Name
Balance Sheet Data
Company L
Ticker
Prior
LLL
Stock Exchange
Fiscal Year Ending December 31,
NYSE
Fiscal Year Ending
Dec-31
Moody's Corporate Rating
NA
S&P Corporate Rating Predicted Beta Marginal Tax Rate
NA 1.00 38.0%
Selected Market Data Current Price
1/0/1900
% of 52-week High 52-week High Price 52-week Low Price Dividend Per Share (MRQ)
-
NA -
1/0/1900 1/0/1900
2005A
2007A
2007A
Stub
Stub
LTM
9/302007
9/30/2008
9/30/2008
-
-
-
-
-
-
-
Inventories
-
-
COGS
-
-
-
-
-
-
Prepaids and Other Current Assets
-
-
Gross Profit SG&A Other Expense / (Income)
-
-
-
-
-
-
-
-
Property, Plant and Equipment, net
-
-
EBIT Interest Expense
-
-
-
-
-
-
Goodwill and Intangible Assets Other Assets
-
-
-
-
-
-
-
-
Total Assets
-
-
-
-
-
-
-
-
Pre-tax Income Income Taxes Noncontrolling Interest Preferred Dividends Net Income
Total Current Assets
Accounts Payable
-
-
-
-
-
-
-
-
Accrued Liabilities
-
-
-
-
-
-
-
-
Other Current Liabilities
-
-
NA
NA
NA
NA
NA
NA
Total Current Liabilities
-
Weighted Avg. Diluted Shares Diluted EPS
-
NA
NA
NA
NA
NA
NA
Total Debt Other Long-Term Liabilities
-
-
-
Adjusted Income Statement
Less: Cash and Cash Equivalents
-
Reported Gross Profit
-
-
-
-
-
-
Non-recurring Items in COGS
-
-
-
-
NA
NA
NA
Reported EBIT
-
-
Non-recurring Items in COGS Other Non-recurring Items
-
-
NA
Adjusted EBITDA % margin
Enterprise Value
-
-
Noncontrolling Interest
Total Liabilities
-
-
-
Preferred Stock
-
-
-
-
Shareholders' Equity
-
NA
NA
NA
-
-
-
-
Calculation of Fully Diluted Shares Outstanding
-
-
-
-
Basic Shares Outstanding Plus: Shares from In-the-Money Options
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
Reported Net Income
-
-
-
-
-
-
Non-recurring Items in COGS Other Non-recurring Items Non-operating Non-rec. Items Tax Adjustment
-
-
-
-
-
-
NA
NA
NA
NA
NA
NA
-
-
-
-
-
-
Adj. Gross Profit Trading Multiples
% margin
LTM 9/30/2008
NFY 2008E
NA -
NFY+1 2009E NA -
NA -
EV/EBITDA
NA
NA
NA
Adjusted EBIT
Metric EV/EBIT
NA
NA
NA
% margin
Metric
-
-
-
Plus: Total Debt Plus: Preferred Stock Plus: Noncontrolling Interest
P/E Metric
-
-
Equity Value
EV/Sales Metric
9/30/2008
Cash and Cash Equivalents Accounts Receivable
Sales
Effective Tax Rate Fully Diluted Shares Outstanding
2006A
Current
-
-
-
NA -
NA -
NA -
LTM Return on Investment Ratios
NA
Return on Invested Capital Return on Equity Return on Assets Implied Annual Dividend Per Share
Depreciation & Amortization
Adjusted Net Income LTM Credit Statistics
% margin
Total Liabilities and Equity Balance Check
0.000
0.000
-
Less: Shares Repurchased
-
Net New Shares from Options Plus: Shares from Convertible Securities
-
Fully Diluted Shares Outstanding
-
Options/Warrants Number of Shares
Exercise Price
-
-
-
-
Tranche 5
-
-
-
-
Total
-
-
-
Tranche Tranche Tranche Tranche Tranche
1 2 3 4
In-the-Money Shares
Proceeds
-
Debt/Total Capitalization Total Debt/EBITDA
-
Net Debt/EBITDA EBITDA/Interest Expense
-
(EBITDA-capex)/Interest Expense
-
Cash Flow Statement Data
EBIT/Interest Expense
-
Depreciation & Amortization % sales Capital Ex penditures
Adjusted Diluted EPS
EBITDA
Conversion Price
Amount
Growth Rates Sales
Convertible Securities
% sales
EPS
Historical
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
-
-
-
Notes
Estimated 1-year 2-year CAGR Long-term
-
-
-
(1) (2) (3) (4)
[to come] [to come] [to come] [to come]
New Shares
-
-
-
-
Issue 2 Issue 3 Issue 4
-
-
-
-
Issue 5
-
-
-
Total
1-year 2-year CAGR
Conversion Ratio
Issue 1
-
Company M (NYSE:MMM)
Business Description
Input Page
[to come]
($ in millions, except per share data)
General Information
Reported Income Statement
Company Name
Balance Sheet Data
Company M
Ticker
MMM
Stock Exchange
NYSE
Fiscal Year Ending
Dec-31
Moody's Corporate Rating
NA
S&P Corporate Rating Predicted Beta Marginal Tax Rate
NA 1.00 38.0%
Selected Market Data Current Price
1/0/1900
% of 52-week High 52-week High Price 52-week Low Price Dividend Per Share (MRQ)
-
NA -
1/0/1900 1/0/1900
Prior Fiscal Year Ending December 31, 2005A
2007A
2007A
Stub
Stub
LTM
9/302007
9/30/2008
9/30/2008
-
-
-
-
-
-
-
Inventories
-
-
COGS
-
-
-
-
-
-
Prepaids and Other Current Assets
-
-
Gross Profit SG&A Other Expense / (Income)
-
-
-
-
-
-
-
-
Property, Plant and Equipment, net
-
-
EBIT Interest Expense
-
-
-
-
-
-
Goodwill and Intangible Assets Other Assets
-
-
-
-
-
-
-
-
Total Assets
-
-
-
-
-
-
-
-
Pre-tax Income Income Taxes Noncontrolling Interest Preferred Dividends Net Income
Total Current Assets
Accounts Payable
-
-
-
-
-
-
-
-
Accrued Liabilities
-
-
-
-
-
-
-
-
Other Current Liabilities
-
-
NA
NA
NA
NA
NA
NA
Total Current Liabilities
-
Weighted Avg. Diluted Shares Diluted EPS
-
NA
NA
NA
NA
NA
NA
Total Debt Other Long-Term Liabilities
-
-
-
Adjusted Income Statement
Less: Cash and Cash Equivalents
-
Reported Gross Profit
-
-
-
-
-
-
Non-recurring Items in COGS
-
-
-
-
NA
NA
NA
Reported EBIT
-
-
Non-recurring Items in COGS Other Non-recurring Items
-
-
NA
Adjusted EBITDA % margin
Enterprise Value
-
-
Noncontrolling Interest
Total Liabilities
-
-
-
Preferred Stock
-
-
-
-
Shareholders' Equity
-
NA
NA
NA
-
-
-
-
Calculation of Fully Diluted Shares Outstanding
-
-
-
-
Basic Shares Outstanding Plus: Shares from In-the-Money Options
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
Reported Net Income
-
-
-
-
-
-
Non-recurring Items in COGS Other Non-recurring Items Non-operating Non-rec. Items Tax Adjustment
-
-
-
-
-
-
NA
NA
NA
NA
NA
NA
-
-
-
-
-
-
Adj. Gross Profit Trading Multiples
% margin
LTM 9/30/2008
NFY 2008E
NA -
NFY+1 2009E NA -
NA -
EV/EBITDA
NA
NA
NA
Adjusted EBIT
Metric EV/EBIT
NA
NA
NA
% margin
Metric
-
-
-
Plus: Total Debt Plus: Preferred Stock Plus: Noncontrolling Interest
P/E Metric
-
-
Equity Value
EV/Sales Metric
9/30/2008
Cash and Cash Equivalents Accounts Receivable
Sales
Effective Tax Rate Fully Diluted Shares Outstanding
2006A
Current
-
-
-
NA -
NA -
NA -
LTM Return on Investment Ratios
NA
Return on Invested Capital Return on Equity Return on Assets Implied Annual Dividend Per Share
Depreciation & Amortization
Adjusted Net Income LTM Credit Statistics
% margin
Total Liabilities and Equity Balance Check
0.000
0.000
-
Less: Shares Repurchased
-
Net New Shares from Options Plus: Shares from Convertible Securities
-
Fully Diluted Shares Outstanding
-
Options/Warrants Number of Shares
Exercise Price
-
-
-
-
Tranche 5
-
-
-
-
Total
-
-
-
Tranche Tranche Tranche Tranche Tranche
1 2 3 4
In-the-Money Shares
Proceeds
-
Debt/Total Capitalization Total Debt/EBITDA
-
Net Debt/EBITDA EBITDA/Interest Expense
-
(EBITDA-capex)/Interest Expense
-
Cash Flow Statement Data
EBIT/Interest Expense
-
Depreciation & Amortization % sales Capital Ex penditures
Adjusted Diluted EPS
EBITDA
Conversion Price
Amount
Growth Rates Sales
Convertible Securities
% sales
EPS
Historical
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
-
-
-
Notes
Estimated 1-year 2-year CAGR Long-term
-
-
-
(1) (2) (3) (4)
[to come] [to come] [to come] [to come]
New Shares
-
-
-
-
Issue 2 Issue 3 Issue 4
-
-
-
-
Issue 5
-
-
-
Total
1-year 2-year CAGR
Conversion Ratio
Issue 1
-
Company N (NYSE:NNN)
Business Description
Input Page
[to come]
($ in millions, except per share data)
General Information
Reported Income Statement
Company Name
Balance Sheet Data
Company N
Ticker
Prior
NNN
Stock Exchange
Fiscal Year Ending December 31,
NYSE
Fiscal Year Ending
Dec-31
Moody's Corporate Rating
NA
S&P Corporate Rating Predicted Beta Marginal Tax Rate
NA 1.00 38.0%
Selected Market Data Current Price
1/0/1900
% of 52-week High 52-week High Price 52-week Low Price Dividend Per Share (MRQ)
-
NA -
1/0/1900 1/0/1900
2005A
2007A
2007A
Stub
Stub
LTM
9/302007
9/30/2008
9/30/2008
-
-
-
-
-
-
-
Inventories
-
-
COGS
-
-
-
-
-
-
Prepaids and Other Current Assets
-
-
Gross Profit SG&A Other Expense / (Income)
-
-
-
-
-
-
-
-
Property, Plant and Equipment, net
-
-
EBIT Interest Expense
-
-
-
-
-
-
Goodwill and Intangible Assets Other Assets
-
-
-
-
-
-
-
-
Total Assets
-
-
-
-
-
-
-
-
Pre-tax Income Income Taxes Noncontrolling Interest Preferred Dividends Net Income
Total Current Assets
Accounts Payable
-
-
-
-
-
-
-
-
Accrued Liabilities
-
-
-
-
-
-
-
-
Other Current Liabilities
-
-
NA
NA
NA
NA
NA
NA
Total Current Liabilities
-
Weighted Avg. Diluted Shares Diluted EPS
-
NA
NA
NA
NA
NA
NA
Total Debt Other Long-Term Liabilities
-
-
-
Adjusted Income Statement
Less: Cash and Cash Equivalents
-
Reported Gross Profit
-
-
-
-
-
-
Non-recurring Items in COGS
-
-
-
-
NA
NA
NA
Reported EBIT
-
-
Non-recurring Items in COGS Other Non-recurring Items
-
-
NA
Adjusted EBITDA % margin
Enterprise Value
-
-
Noncontrolling Interest
Total Liabilities
-
-
-
Preferred Stock
-
-
-
-
Shareholders' Equity
-
NA
NA
NA
-
-
-
-
Calculation of Fully Diluted Shares Outstanding
-
-
-
-
Basic Shares Outstanding Plus: Shares from In-the-Money Options
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
Reported Net Income
-
-
-
-
-
-
Non-recurring Items in COGS Other Non-recurring Items Non-operating Non-rec. Items Tax Adjustment
-
-
-
-
-
-
NA
NA
NA
NA
NA
NA
-
-
-
-
-
-
Adj. Gross Profit Trading Multiples
% margin
LTM 9/30/2008
NFY 2008E
NA -
NFY+1 2009E NA -
NA -
EV/EBITDA
NA
NA
NA
Adjusted EBIT
Metric EV/EBIT
NA
NA
NA
% margin
Metric
-
-
-
Plus: Total Debt Plus: Preferred Stock Plus: Noncontrolling Interest
P/E Metric
-
-
Equity Value
EV/Sales Metric
9/30/2008
Cash and Cash Equivalents Accounts Receivable
Sales
Effective Tax Rate Fully Diluted Shares Outstanding
2006A
Current
-
-
-
NA -
NA -
NA -
LTM Return on Investment Ratios
NA
Return on Invested Capital Return on Equity Return on Assets Implied Annual Dividend Per Share
Depreciation & Amortization
Adjusted Net Income LTM Credit Statistics
% margin
Total Liabilities and Equity Balance Check
0.000
0.000
-
Less: Shares Repurchased
-
Net New Shares from Options Plus: Shares from Convertible Securities
-
Fully Diluted Shares Outstanding
-
Options/Warrants Number of Shares
Exercise Price
-
-
-
-
Tranche 5
-
-
-
-
Total
-
-
-
Tranche Tranche Tranche Tranche Tranche
1 2 3 4
In-the-Money Shares
Proceeds
-
Debt/Total Capitalization Total Debt/EBITDA
-
Net Debt/EBITDA EBITDA/Interest Expense
-
(EBITDA-capex)/Interest Expense
-
Cash Flow Statement Data
EBIT/Interest Expense
-
Depreciation & Amortization % sales Capital Ex penditures
Adjusted Diluted EPS
EBITDA
Conversion Price
Amount
Growth Rates Sales
Convertible Securities
% sales
EPS
Historical
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
-
-
-
Notes
Estimated 1-year 2-year CAGR Long-term
-
-
-
(1) (2) (3) (4)
[to come] [to come] [to come] [to come]
New Shares
-
-
-
-
Issue 2 Issue 3 Issue 4
-
-
-
-
Issue 5
-
-
-
Total
1-year 2-year CAGR
Conversion Ratio
Issue 1
-
Company O (NYSE:OOO)
Business Description
Input Page
[to come]
($ in millions, except per share data)
General Information
Reported Income Statement
Company Name
Balance Sheet Data
Company O
Ticker
Prior
OOO
Stock Exchange
Fiscal Year Ending December 31,
NYSE
Fiscal Year Ending
Dec-31
Moody's Corporate Rating
NA
S&P Corporate Rating Predicted Beta Marginal Tax Rate
NA 1.00 38.0%
Selected Market Data Current Price
1/0/1900
% of 52-week High 52-week High Price 52-week Low Price Dividend Per Share (MRQ)
-
NA -
1/0/1900 1/0/1900
2005A
2007A
2007A
Stub
Stub
LTM
9/302007
9/30/2008
9/30/2008
-
-
-
-
-
-
-
Inventories
-
-
COGS
-
-
-
-
-
-
Prepaids and Other Current Assets
-
-
Gross Profit SG&A Other Expense / (Income)
-
-
-
-
-
-
-
-
Property, Plant and Equipment, net
-
-
EBIT Interest Expense
-
-
-
-
-
-
Goodwill and Intangible Assets Other Assets
-
-
-
-
-
-
-
-
Total Assets
-
-
-
-
-
-
-
-
Pre-tax Income Income Taxes Noncontrolling Interest Preferred Dividends Net Income
Total Current Assets
Accounts Payable
-
-
-
-
-
-
-
-
Accrued Liabilities
-
-
-
-
-
-
-
-
Other Current Liabilities
-
-
NA
NA
NA
NA
NA
NA
Total Current Liabilities
-
Weighted Avg. Diluted Shares Diluted EPS
-
NA
NA
NA
NA
NA
NA
Total Debt Other Long-Term Liabilities
-
-
-
Adjusted Income Statement
Less: Cash and Cash Equivalents
-
Reported Gross Profit
-
-
-
-
-
-
Non-recurring Items in COGS
-
-
-
-
NA
NA
NA
Reported EBIT
-
-
Non-recurring Items in COGS Other Non-recurring Items
-
-
NA
Adjusted EBITDA % margin
Enterprise Value
-
-
Noncontrolling Interest
Total Liabilities
-
-
-
Preferred Stock
-
-
-
-
Shareholders' Equity
-
NA
NA
NA
-
-
-
-
Calculation of Fully Diluted Shares Outstanding
-
-
-
-
Basic Shares Outstanding Plus: Shares from In-the-Money Options
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
Reported Net Income
-
-
-
-
-
-
Non-recurring Items in COGS Other Non-recurring Items Non-operating Non-rec. Items Tax Adjustment
-
-
-
-
-
-
NA
NA
NA
NA
NA
NA
-
-
-
-
-
-
Adj. Gross Profit Trading Multiples
% margin
LTM 9/30/2008
NFY 2008E
NA -
NFY+1 2009E NA -
NA -
EV/EBITDA
NA
NA
NA
Adjusted EBIT
Metric EV/EBIT
NA
NA
NA
% margin
Metric
-
-
-
Plus: Total Debt Plus: Preferred Stock Plus: Noncontrolling Interest
P/E Metric
-
-
Equity Value
EV/Sales Metric
9/30/2008
Cash and Cash Equivalents Accounts Receivable
Sales
Effective Tax Rate Fully Diluted Shares Outstanding
2006A
Current
-
-
-
NA -
NA -
NA -
LTM Return on Investment Ratios
NA
Return on Invested Capital Return on Equity Return on Assets Implied Annual Dividend Per Share
Depreciation & Amortization
Adjusted Net Income LTM Credit Statistics
% margin
Total Liabilities and Equity Balance Check
0.000
0.000
-
Less: Shares Repurchased
-
Net New Shares from Options Plus: Shares from Convertible Securities
-
Fully Diluted Shares Outstanding
-
Options/Warrants Number of Shares
Exercise Price
-
-
-
-
Tranche 5
-
-
-
-
Total
-
-
-
Tranche Tranche Tranche Tranche Tranche
1 2 3 4
In-the-Money Shares
Proceeds
-
Debt/Total Capitalization Total Debt/EBITDA
-
Net Debt/EBITDA EBITDA/Interest Expense
-
(EBITDA-capex)/Interest Expense
-
Cash Flow Statement Data
EBIT/Interest Expense
-
Depreciation & Amortization % sales Capital Ex penditures
Adjusted Diluted EPS
EBITDA
Conversion Price
Amount
Growth Rates Sales
Convertible Securities
% sales
EPS
Historical
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
-
-
-
Notes
Estimated 1-year 2-year CAGR Long-term
-
-
-
(1) (2) (3) (4)
[to come] [to come] [to come] [to come]
New Shares
-
-
-
-
Issue 2 Issue 3 Issue 4
-
-
-
-
Issue 5
-
-
-
Total
1-year 2-year CAGR
Conversion Ratio
Issue 1
-
Copyright © 2009 by Joshua Rosenbaum and Joshua Pearl. All rights reserved. Published by John Wiley & Sons, Inc., Hoboken, New Jersey. Published simultaneously in Canada. No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning, or otherwise, except as permitted under Section 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, Inc., 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 750-4470, or on the web at www.copyright.com. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748-6011, fax (201) 748-6008, or online at http://www.wiley.com/go/permissions. Limit of Liability/Disclaimer of Warranty: While the publisher and author have used their best efforts in preparing this book, they make no representations or warranties with respect to the accuracy or completeness of the contents of this book and specifically disclaim any implied warranties of merchantability or fitness for a particular purpose. No warranty may be created or extended by sales representatives or written sales materials. The advice and strategies contained herein may not be suitable for your situation. You should consult with a professional where appropriate. Neither the publisher nor author shall be liable for any loss of profit or any other commercial damages, including but not limited to special, incidental, consequential, or other damages. For general information on our other products and services or for technical support, please contact our Customer Care Department within the United States at (800) 762-2974, outside the United States at (317) 572-3993 or fax (317) 572-4002. Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may not be available in electronic books. For more information about Wiley products, visit our web site at www.wiley.com. Library of Congress Cataloging-in-Publication Data:
ISBN-13 978-0-470-44220-3 Printed in the United States of America 10 9 8 7 6 5 4 3 2 1