FIN571 University of Colorado Cheesecake Factory Comparable Analysis Please do a comparable valuation of Cheesecake Factory using the excel document attach

FIN571 University of Colorado Cheesecake Factory Comparable Analysis Please do a comparable valuation of Cheesecake Factory using the excel document attached. The commentary part is very important. It can and should draw from any information available that you believe is important.Please use numbers that have been filed with the SEC. Company Name0
Analyst
Date
Stock Price
Commentary
($ in millions)
List of Comparable Companies
Company
Ticker
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Business Description
0
0
0
0
0
0
0
0
0
0
0
$
$
$
$
$
$
$
$
$
$
$
Equity
Enterprise
Current
Current
EV/
Value
Value
Sales
EBIT
EBITDA
–
$
$
$
$
$
$
$
$
$
$
$
–
$
$
$
$
$
$
$
$
$
$
$
–
$
$
$
$
$
$
$
$
$
$
$
–
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
EV/
Current
NFY
NFY EBITDA
P/E
P/E
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
Stock Comparison Graphs
Football Fields
Red lines indicate
the medians/means
LTM EV / Sales:
1900E EV / Sales:
1901E EV / Sales:
1902E EV / Sales:
LTM EV / EBITDA:
1900E EV / EBITDA:
1901E EV / EBITDA:
1902E EV / EBITDA:
LTM EV / EBIT:
1900E EV / EBIT:
1901E EV / EBIT:
1902E EV / EBIT:
LTM P / E:
1900E P / E:
1901E P / E:
1902E P / E:
$0.00
1902E P / E:
1901E P / E:
1900E P / E:
LTM P / E:
1902E EV / EBIT:
1901E EV / EBIT:
Min
$0.00
$0.00
$0.00
$0.00
#DIV/0!
#DIV/0!
$0.10
25th
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
Med/Mean
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
1900E EV / EBIT:
LTM EV / EBIT:
1902E EV / EBITDA:
1901E EV / EBITDA:
1900E EV / EBITDA:
LTM EV / EBITDA:
1902E EV / Sales:
1901E EV / Sales:
1900E EV / Sales:
LTM EV / Sales:
Positioning
y
0
18.5
0.4
0.8
1.55
2
2.7
3.2
3.8
4.35
5
5.55
6.2
6.7
7.35
7.9
8.6
9.05
x
CURRENT PRICE
–
$0.00
1902E P / E:
#NUM!
#NUM!
1901E P / E:
#NUM!
#NUM!
1900E P / E:
#NUM!
#NUM!
LTM P / E:
#NUM!
#NUM!
1902E EV / EBIT:
#NUM!
#NUM!
1901E EV / EBIT:
#NUM!
#NUM!
1900E EV / EBIT:
#NUM!
#NUM!
LTM EV / EBIT:
#NUM!
#NUM!
1902E EV / EBITDA:
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
9.7
10.3
10.9
11.5
12
12.65
13.25
13.8
14.4
15
15.6
16.15
16.8
17.3
18
18.5
#NUM!
#NUM!
1901E EV / EBITDA:
#NUM!
#NUM!
1900E EV / EBITDA:
#NUM!
#NUM!
LTM EV / EBITDA:
#NUM!
#NUM!
1902E EV / Sales:
#NUM!
#NUM!
1901E EV / Sales:
#NUM!
#NUM!
1900E EV / Sales:
#NUM!
#NUM!
LTM EV / Sales:
#NUM!
#NUM!
$0.20
75th
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
$0.30
Max
$0.00
$0.00
$0.00
$0.00
#DIV/0!
#DIV/0!
Min point
$0.00
$0.00
$0.00
$0.00
#DIV/0!
#DIV/0!
$0.40
25th point
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
$0.50
Med point
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
75th point
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
$0.60
Max point
#NUM!
#NUM!
#NUM!
#NUM!
#DIV/0!
#DIV/0!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
20
18
25th to median
median to 75th
16
CURRENT PRICE
14
LTM EV / Sales:
1900E EV / Sales:
12
1901E EV / Sales:
1902E EV / Sales:
LTM EV / EBITDA:
10
1900E EV / EBITDA:
1902E EV / EBITDA:
8
1901E EV / EBITDA:
LTM EV / EBIT:
6
1900E EV / EBIT:
1901E EV / EBIT:
4
1902E EV / EBIT:
LTM P / E:
1900E P / E:
2
1901E P / E:
1902E P / E:
$0.70
$0.80
$0.90
0
$1.00
25th to median
median to 75th
CURRENT PRICE
LTM EV / Sales:
1900E EV / Sales:
1901E EV / Sales:
1902E EV / Sales:
LTM EV / EBITDA:
1900E EV / EBITDA:
1902E EV / EBITDA:
1901E EV / EBITDA:
LTM EV / EBIT:
1900E EV / EBIT:
1901E EV / EBIT:
1902E EV / EBIT:
LTM P / E:
1900E P / E:
1901E P / E:
1902E P / E:
Valuation Summary –
($ in Millions, Except Per Share Amounts in Dollars
Valuation Statistics –
– Range of Valuation Multiples
Minimum
Multiple
25th
Pecentile
Multiple
Median
Multiple
Trading Multiples
LTM EV / Sales:
1900E EV / Sales:
1901E EV / Sales:
1902E EV / Sales:
0.0x
0.0x
0.0x
0.0x
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
LTM EV / EBITDA:
1900E EV / EBITDA:
1901E EV / EBITDA:
1902E EV / EBITDA:
0.0x
0.0x
0.0x
0.0x
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
LTM EV / EBIT:
1900E EV / EBIT:
1901E EV / EBIT:
1902E EV / EBIT:
0.0x
0.0x
0.0x
0.0x
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
LTM P / E:
1900E P / E:
1901E P / E:
1902E P / E:
0.0x
0.0x
0.0x
0.0x
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
Range of Valuation Multiples
75th
Pecentile
Multiple
– Implied Per Share Value Range
Maximum
Multiple
Applicable
Figure
Minimum
Multiple
25th
Pecentile
Multiple
Median
Multiple
#NUM!
#NUM!
#NUM!
#NUM!
0.0x
0.0x
0.0x
0.0x
$0.00
$0.00
$0.00
$0.00
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
0.0x
0.0x
0.0x
0.0x
$0.00
$0.00
$0.00
$0.00
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
0.0x
0.0x
0.0x
0.0x
$0.00
$0.00
$0.00
$0.00
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
0.0x
0.0x
0.0x
0.0x
$0.00
$0.00
$0.00
$0.00
–
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
$
$
$
$
Per Share Value Range
75th
Pecentile
Multiple
Maximum
Multiple
#NUM!
#NUM!
#NUM!
#NUM!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#NUM!
#NUM!
#NUM!
#NUM!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#NUM!
#NUM!
#NUM!
#NUM!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#NUM!
#NUM!
#NUM!
#NUM!
$
$
$
$
–
0
Comparable Companies Analysis
$ in millions, except for per share data
Company
Ticker
0
0
0
0
0
0
0
Mean
Median
Maximum
75th
Median/Mean
25th
Minimum
0
0
0
0
0
0
0
$
$
$
$
$
$
$
Current
% of
Share
Price
52-wk.
High
–
NA
NA
NA
NA
NA
NA
NA
Median
Mean
Enterprise Value /
Equity
Value ($)
Enterprise
Value ($)
LTM
Sales
1900E
Sales
1901E
Sales
–
–
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
–
–
#DIV/0!
#NUM!
#DIV/0!
#NUM!
#DIV/0!
#NUM!
–
–
0.0x
#NUM!
#NUM!
#NUM!
0.0x
0.0x
#NUM!
#NUM!
#NUM!
0.0x
0.0x
#NUM!
#NUM!
#NUM!
0.0x
Mean
Mean
Mean
Median OR Mean
Value /
Enterprise Value /
1902E
Sales
Enterprise Value /
LTM
1900E 1901E 1902E
EBITDA EBITDA EBITDA EBITDA
LTM
EBIT
1900E
EBIT
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
#DIV/0!
#NUM!
#DIV/0!
#NUM!
#DIV/0!
#NUM!
#DIV/0!
#NUM!
#DIV/0!
#NUM!
#DIV/0!
#NUM!
#DIV/0!
#NUM!
0.0x
#NUM!
#NUM!
#NUM!
0.0x
0.0x
#NUM!
#NUM!
#NUM!
0.0x
0.0x
#NUM!
#NUM!
#NUM!
0.0x
0.0x
#NUM!
#NUM!
#NUM!
0.0x
0.0x
#NUM!
#NUM!
#NUM!
0.0x
0.0x
#NUM!
#NUM!
#NUM!
0.0x
0.0x
#NUM!
#NUM!
#NUM!
0.0x
Mean
Mean
Mean
Mean
Mean
Mean
Mean
Enterprise Value /
Price /
1901E
EBIT
1902E
EBIT
LTM
EPS
1900E
EPS
1901E
EPS
1902E
EPS
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
#DIV/0!
#NUM!
#DIV/0!
#NUM!
#DIV/0!
#NUM!
#DIV/0!
#NUM!
#DIV/0!
#NUM!
#DIV/0!
#NUM!
0.0x
#NUM!
#NUM!
#NUM!
0.0x
0.0x
#NUM!
#NUM!
#NUM!
0.0x
0.0x
#NUM!
#NUM!
#NUM!
0.0x
0.0x
#NUM!
#NUM!
#NUM!
0.0x
0.0x
#NUM!
#NUM!
#NUM!
0.0x
0.0x
#NUM!
#NUM!
#NUM!
0.0x
Mean
Mean
Median
Median
Median
Median
($ in Millions, Except Per Share Amounts)
En
Company
Enterprise
Value ($)
LTM
Sales
1900E
Sales
0
0
0
0
0
0
0
–
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
Mean
Median
–
#DIV/0!
#NUM!
#DIV/0!
#NUM!
Maximum
75th
Median/Mean
25th
Minimum
–
0.0x
#NUM!
#NUM!
#NUM!
0.0x
0.0x
#NUM!
#NUM!
#NUM!
0.0x
Enterprise Value /
1901E 1902E
LTM
1900E 1901E 1902E
Sales
Sales EBITDA EBITDA EBITDA EBITDA
Enterpri
LTM
EBIT
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
#DIV/0!
#NUM!
#DIV/0!
#NUM!
#DIV/0!
#NUM!
#DIV/0!
#NUM!
#DIV/0!
#NUM!
#DIV/0!
#NUM!
#DIV/0!
#NUM!
0.0x
#NUM!
#NUM!
#NUM!
0.0x
0.0x
#NUM!
#NUM!
#NUM!
0.0x
0.0x
#NUM!
#NUM!
#NUM!
0.0x
0.0x
#NUM!
#NUM!
#NUM!
0.0x
0.0x
#NUM!
#NUM!
#NUM!
0.0x
0.0x
#NUM!
#NUM!
#NUM!
0.0x
0.0x
#NUM!
#NUM!
#NUM!
0.0x
Year
LTM
1900E
1901E
1902E
Enterprise Value /
1900E
1901E
EBIT
EBIT
1902E
EBIT
LTM
EPS
Price /
1900E 1901E
EPS
EPS
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
#DIV/0!
#NUM!
#DIV/0!
#NUM!
#DIV/0!
#NUM!
#DIV/0!
#NUM!
#DIV/0!
#NUM!
#DIV/0!
#NUM!
0.0x
#NUM!
#NUM!
#NUM!
0.0x
0.0x
#NUM!
#NUM!
#NUM!
0.0x
0.0x
#NUM!
#NUM!
#NUM!
0.0x
0.0x
#NUM!
#NUM!
#NUM!
0.0x
0.0x
#NUM!
#NUM!
#NUM!
0.0x
0.0x
#NUM!
#NUM!
#NUM!
0.0x
EBITDA
(millions)
$0.00
$0.00
$0.00
$0.00
Multiple Range
#NUM!
#NUM!
#NUM!
#NUM!
–
#NUM!
#NUM!
#NUM!
#NUM!
Implied Share Price
#NUM!
#NUM!
#NUM!
#NUM!
–
#NUM!
#NUM!
#NUM!
#NUM!
/
1902E
EPS
NA
NA
NA
NA
NA
NA
NA
#DIV/0!
#NUM!
0.0x
#NUM!
#NUM!
#NUM!
0.0x
0
Benchmarking Analysis – Financial Statistics and Ratios
($ in millions, except per share data)
Market Valuation
Company
Ticker
Equity
Value
LTM Financial Statistics
Enterprise
Value
Sales
Gross
Profit
EBITDA
EBIT
LTM Profitability Margins
Gross
Net
Profit EBITDA EBIT
Income
(%)
(%)
(%)
(%)
Net
Income
Sales
Hist.
1-year
Est.
1-year
Growth Rates
EBITDA
Hist.
Est.
1-year
1-year
0
0
–
–
–
–
–
–
–
NA
NA
NA
NA
0%
0%
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
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%
Mean
Median
NA
NA
NA
NA
NA
NA
NA
NA
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%
Overall
Market Valuation
General
Return on Investment
LTM Leverage Ratios
Debt /
Debt /
Net Debt /
Tot. Cap. EBITDA EBITDA
(%)
(x)
(x)
LTM Coverage Ratios
EBITDA / EBITDA
EBIT /
Int. Exp. – Cpx/ Int. Int. Exp.
(x)
(x)
(x)
Ticker
Equity
Value
Enterprise
Value
FYE
Predicted
Beta
ROIC
(%)
ROE
(%)
ROA
(%)
Implied
Div. Yield
(%)
0
0
0
0
Jan-00
0.00
0%
0%
0%
NA
0%
0.0x
0.0x
0.0x
0.0x
0.0x
0
0
0
0
0
0
0
0
0
0
0
0
Jan-00
Jan-00
Jan-00
Jan-00
Jan-00
Jan-00
0.00
0.00
0.00
0.00
0.00
0.00
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
NA
NA
NA
NA
NA
NA
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
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.00
0.00
0%
0%
0%
0%
0%
0%
#DIV/0!
#NUM!
0%
0%
0.0x
0.0x
0.0x
0.0x
0.0x
0.0x
0.0x
0.0x
0.0x
0.0x
0.00
0.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
–
–
EPS
Growth Rates
Hist.
1-year
EPS
Est.
1-year
Est.
LT
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%
Credit Ratings
Moody’s
S&P
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)
Input Page
($ in millions, except per share data)
General Information
Reported Income Statement
Company Name
Ticker
Stock Exchange
Fiscal Year Ending
Moody’s Corporate Rating
Sales
COGS (incl. D&A)
S&P Corporate Rating
Predicted Beta
Marginal Tax Rate
Gross Profit
SG&A
Other Expense / (Income)
Selected Market Data
Current Price
EBIT
Interest Expense
Pre-tax Income
% of 52-week High
52-week High Price
52-week Low Price
Dividend Per Share (MRQ)
NA
Fully Diluted Shares Outstanding
Income Taxes
Net loss (income) from dis. op.
Preferred Dividends
Net Income
Effective Tax Rate
–
Equity Value
–
Plus: Total Debt
Plus: Preferred Stock
Plus: Noncontrolling Interest
Less: Cash and Investments
Enterprise Value
–
Weighted Avg. Diluted Shares
Diluted EPS
Adjusted Income Statement
Reported Gross Profit
Non-recurring Items in COGS
Adj. Gross Profit
% margin
Trading Multiples
EV / Sales
Metric
EV / EBITDA
LTM
1/0/1900
NA
NA
Metric
EV / EBIT
Metric
P/E
NA
NA
Metric
P / FCF
FCF Yield
NFY
1900E
NFY+1
1901E
NFY+2
1902E
NA
NA
NA
NA
NA
NA
Reported EBIT
Non-recurring Items in COGS
Other Non-recurring Items
Stock-Based Compensation
Adjusted EBIT
% margin
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
Depreciation & Amortization
Adjusted EBITDA
% margin
Reported Net Income
Metric
–
Non-recurring Items in COGS
Other Non-recurring Items
Stock-Based Compensation (cond
LTM Return on Investment Ratios
Return on Invested Capital
Return on Equity
Return on Assets
–
Implied Annual Dividend Yield
NA
LTM Credit Statistics
Non-operating Non-rec. Items
Tax Adjustment
Adjusted Net Income
% margin
Adjusted Diluted EPS
Debt/Total Capitalization
Total Debt/EBITDA
Net Debt/EBITDA
0.0%
–
Cash Flow Statement Data
Cash From Operating Activities
EBITDA/Interest Expense
(EBITDA-capex)/Interest Expense
–
Capital Expenditures
% sales
EBIT/Interest Expense
–
Free Cash Flow
% margin
FCF / Share
Growth Rates
Sales
Historical
1-year
EBITDA
FCF
EPS
–
–
–
–
2-year CAGR
Estimated
1-year
–
–
–
–
–
–
–
–
2-year CAGR
Long-term
–
–
–
–
Depreciation & Amortization
% sales
Stock-Based Compensation
(input only when considered signif
Notes
Non-recurring item ad
Opex adjustment
Non-opex adjustment
Prior
Stub
Fiscal Year Ending January 0,
############### #############
1900A
–
–
–
–
–
–
–
–
–
–
–
–
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
–
–
–
–
NA
NA
NA
NA
–
–
–
–
NA
NA
NA
NA
–
–
–
–
ecurring Items in COGS
–
–
–
–
Non-recurring Items
-Based Compensation (conditional)
–
–
–
–
–
–
–
–
NA
NA
NA
NA
–
–
–
–
NA
NA
NA
NA
NA
–
NA
–
NA
–
NA
–
NA
NA
NA
NA
operating Non-rec. Items
usted Net Income
ted Diluted EPS
Flow Statement Data
From Operating Activities
al Expenditures
e Cash Flow
eciation & Amortization
-Based Compensation
only when considered significant, otherwise left blank)
Non-recurring item adjustment ############### #############
1900A
1/0/1900
adjustment
Total
–
–
–
–
Total
–
–
–
–
opex adjustment
Business Description
Balance Sheet Data
Current
Stub
LTM
1/0/1900
–
Cash and Investments (ST & LT)
Accounts Receivable
Inventories
Prepaids and Other Current Assets
–
Property, Plant and Equipment, net
–
–
Goodwill and Intangible Assets
Other Assets
Total Assets
NA
NA
Accounts Payable
Accrued Liabilities
Other Current Liabilities
Total Current Liabilities
NA
NA
Long term debt
Other Long-Term Liabilities
–
Total Current Assets
Total Liabilities
NA
NA
–
–
NA
NA
–
–
NA
NA
Noncontrolling Interest
Preferred Stock
Shareholders’ Equity
Total Liabilities and Equity
Balance Check
Calculation of Fully Diluted Shares Outstanding
Basic Shares Outstanding
Plus: Shares from In-the-Money Options
Less: Shares Repurchased
Net New Shares from Options
Plus: Shares from Convertible Securities
Plus: Shares from RSU’s Dilution
Fully Diluted Shares Outstanding
Options/Warrants
–
–
Number of
Exercise
–
–
Tranche
–
–
Tranche 1
Tranche 2
–
–
Tranche 3
Tranche 4
Tranche 5
NA
NA
–
–
Tranche 6
Tranche 7
Tranche 8
Shares
Total
NA
NA
NA
–
NA
–
NA
NA
Price
–
Convertible Securities
Conversion
Price
Amount
Issue 1
Issue 2
Issue 3
Issue 4
Issue 5
Total
–
–
–
1/0/1900
Total Indebtedness
1/0/1900
Current portion
Non-current portion
–
–
Total
0.0
1900A
1/0/1900
–
–
–
–
–
–
–
–
0.000
0.000
–
In-the-Money
Shares
Proceeds
–
–
–
–
–
–
–
–
Conversion
Ratio
New
Shares
–
–
(:)
Input Page
($ in millions, except per share data)
General Information
Reported Income Statement
Company Name
Ticker
Stock Exchange
Fiscal Year Ending
Sales
Moody’s Corporate Rating
COGS (incl. D&A)
S&P Corporate Rating
Gross Profit
Predicted Beta
SG&A
Marginal Tax Rate
Other Expense / (Income)
EBIT
Selected Market Data
Interest Expense
Current Price
Pre-tax Income
% of 52-week High
NA
Income Taxes
52-week High Price
Net loss (income) from dis. op.
52-week Low Price
Non-controlling Interest
Dividend Per Share (MRQ)
Net Income
Effective Tax Rate
Fully Diluted Shares Outstanding
Equity Value
–
Weighted Avg. Diluted Shares
Diluted EPS
Plus: Total Debt
–
Plus: Preferred Stock
–
Adjusted Income Statement
Plus: Noncontrolling Interest
–
Reported Gross Profit
Less: Cash and Investments
–
Non-recurring Items in COGS
Enterprise Value
–
Adj. Gross Profit
% margin
Trading Multiples
LTM
NFY
NFY+1
NFY+2
Reported EBIT
1/0/1900
1900E
1901E
1902E
Non-recurring Items in COGS
EV/Sales
NA
Metric
–
EV/EBITDA
Metric
NA
–
NA
NA
NA
Other Non-recurring Items
Stock-Based Compensation (conditional)
NA
NA
NA
Adjusted EBIT
% margin
EV/EBIT
NA
Metric
–
P/E
NA
NA
Depreciation & Amortization
NA
Metric
NA
NA
NA
NA
–
P / FCF
NA
FCF Yield
NA
Metric
–
Adjusted EBITDA
% margin
NA
NA
NA
Reported Net Income
Non-recurring Items in COGS
Other Non-recurring Items
LTM Return on Investment Ratios
Stock-Based Compensation (conditional)
Return on Invested Capital
–
Non-operating Non-rec. Items
Return on Equity
–
Tax Adjustment
Return on Assets
–
Implied Annual Dividend Yield
NA
LTM Credit Statistics
Adjusted Net Income
% margin
Adjusted Diluted EPS
Debt/Total Capitalization
–
Total Debt/EBITDA
–
Cash Flow Statement Data
Net Debt/EBITDA
–
Cash From Operating Activities
EBITDA/Interest Expense
–
Capital Expenditures
(EBITDA-capex)/Interest Expense
–
% sales
EBIT/Interest Expense
–
Free Cash Flow
% margin
Growth Rates
FCF / Share
Sales
EBITDA
FCF
EPS
Historical
Depreciation & Amortization
1-year
–
–
–
–
2-year CAGR
–
–
–
–
Estimated
Stock-Based Compensation
(input only when considered significant, oth
1-year
–
–
–
–
2-year CAGR
–
–
–
–
Long-term
% sales
Notes
–
Non-recurring item adjustme
Opex adjustment
Non-opex adjustment
Fiscal Year Ending January 0,
########### ############
Prior
Current
Stub
Stub
1900A
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
–
–
–
–
–
–
–
–
–
–
NA
NA
NA
NA
NA
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
NA
NA
NA
NA
NA
ation & Amortization
–
–
–
–
–
ted EBITDA
–
–
–
–
–
NA
NA
NA
NA
NA
d Net Income
–
–
–
–
–
urring Items in COGS
–
–
–
–
–
on-recurring Items
–
–
–
–
–
ased Compensation (conditional)
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
NA
NA
NA
NA
NA
–
–
–
–
–
NA
NA
NA
NA
NA
–
–
–
–
–
NA
NA
NA
NA
NA
–
–
–
–
–
NA
NA
NA
NA
NA
erating Non-rec. Items
ted Net Income
d Diluted EPS
ow Statement Data
om Operating Activities
Expenditures
ation & Amortization
ased Compensation
nly when considered significant, otherwise left blank)
Non-recurring item adjustment ########### ############
1900A
1/0/1900
1/0/1900
Total
–
–
–
–
–
Total
–
–
–
–
–
ex adjustment
Business Description
Balance Sheet Data
1900A
LTM
1/0/1900
Cash and Investments (ST & LT)
1/0/1900
Accounts Receivable
–
Inventories
–
Prepaids and Other Current Assets
–
Total Current Assets
–
–
–
–
–
–
–
–
–
–
–
Property, Plant and Equipment, net
–
Goodwill and Intangible Assets
–
Other Assets
–
Total Assets
–
Accounts Payable
–
Accrued Liabilities
–
Other Current Liabilities
NA
NA
Total Current Liabilities
Long term debt
Other Long-Term Liabilities
Total Liabilities
–
Noncontrolling Interest
–
Preferred Stock
–
Shareholders’ Equity
NA
Total Liabilities and Equity
Balance Check
0.000
0.000
–
Calculation of Fully Diluted Shares Outstanding
–
Basic Shares Outstanding
–
Plus: Shares from In-the-Money Options
–
–
Less: Shares Repurchased
–
NA
Net New Shares from Options
–
–
Plus: Shares from Convertible Securities
–
Plus: Shares from RSU’s Dilution
–
Fully Diluted Shares Outstanding
–
NA
Options…
Purchase answer to see full
attachment