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 Writings Pro
Calculate your paper price
Pages (550 words)
Approximate price: -

Why should I choose Homework Writings Pro as my essay writing service?

We Follow Instructions and Give Quality Papers

We are strict in following paper instructions. You are welcome to provide directions to your writer, who will follow it as a law in customizing your paper. Quality is guaranteed! Every paper is carefully checked before delivery. Our writers are professionals and always deliver the highest quality work.

Professional and Experienced Academic Writers

We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.

Reasonable Prices and Free Unlimited Revisions

Typical student budget? No problem. Affordable rates, generous discounts - the more you order, the more you save. We reward loyalty and welcome new customers. Furthermore, if you think we missed something, please send your order for a free review. You can do this yourself by logging into your personal account or by contacting our support..

Essay Delivered On Time and 100% Money-Back-Guarantee

Your essay will arrive on time, or even before your deadline – even if you request your paper within hours. You won’t be kept waiting, so relax and work on other tasks.We also guatantee a refund in case you decide to cancel your order.

100% Original Essay and Confidentiality

Anti-plagiarism policy. The authenticity of each essay is carefully checked, resulting in truly unique works. Our collaboration is a secret kept safe with us. We only need your email address to send you a unique username and password. We never share personal customer information.

24/7 Customer Support

We recognize that people around the world use our services in different time zones, so we have a support team that is happy to help you use our service. Our writing service has a 24/7 support policy. Contact us and discover all the details that may interest you!

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

Our reputation for excellence in providing professional tailor-made essay writing services to students of different academic levels is the best proof of our reliability and quality of service we offer.

Essays

Essay Writing Service

When using our academic writing services, you can get help with different types of work including college essays, research articles, writing, essay writing, various academic reports, book reports and so on. Whatever your task, homeworkwritingspro.com has experienced specialists qualified enough to handle it professionally.

Admissions

Admission Essays & Business Writing Help

An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.

Reviews

Editing Support

Our professional editor will check your grammar to make sure it is free from errors. You can rest assured that we will do our best to provide you with a piece of dignified academic writing. Homeworkwritingpro experts can manage any assignment in any academic field.

Reviews

Revision Support

If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.