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

Don't use plagiarized sources. Get Your Custom Essay on
FIN571 University of Colorado Cheesecake Factory Comparable Analysis Please do a comparable valuation of Cheesecake Factory using the excel document attach
Just from $13/Page
Order Essay
Homework On Time
Calculate the Price of your PAPER Now
Pages (550 words)
Approximate price: -

Why Choose Us

Top quality papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

Professional academic writers

We have hired a team of professional writers experienced in academic and business writing. Most of them are native speakers and PhD holders able to take care of any assignment you need help with.

Free revisions

If you feel that we missed something, send the order for a free revision. You will have 10 days to send the order for revision after you receive the final paper. You can either do it on your own after signing in to your personal account or by contacting our support.

On-time delivery

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & confidential

We use several checkers to make sure that all papers you receive are plagiarism-free. Our editors carefully go through all in-text citations. We also promise full confidentiality in all our services.

24/7 Customer Support

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.

Essays

Essay Writing Service

You are welcome to choose your academic level and the type of your paper. Our academic experts will gladly help you with essays, case studies, research papers and other assignments.

Admissions

Admission help & business writing

You can be positive that we will be here 24/7 to help you get accepted to the Master’s program at the TOP-universities or help you get a well-paid position.

Reviews

Editing your paper

Our academic writers and editors will help you submit a well-structured and organized paper just on time. We will ensure that your final paper is of the highest quality and absolutely free of mistakes.

Reviews

Revising your paper

Our academic writers and editors will help you with unlimited number of revisions in case you need any customization of your academic papers