SV - DCF Analysis - Template
SV - DCF Analysis - Template
Enterprise Value
Exit Multiple
0.0 -1.0x -0.5x 0.0x 0.5x 1.0x
-1.0% 0 0 0 0 0
-0.5% 0 0 0 0 0
WACC
WACC
0.0% 0 0 $0 0 0
0.5% 0 0 0 0 0
1.0% 0 0 0 0 0
Assumptions
Sales (% growth) NA -% -% -%
COGS (% sales) -% -% -% -%
SG&A (% sales) -% -% -% -%
Depreciation & Amortization (% sales) -% -% -% -%
Capital Expenditures (% sales) -% -% -% -%
Tax Rate -% -% -% -%
Working Capital (% sales)
ValueCo Corporation
Sensitivity Analysis
($ in millions)
Enterprise Value
Exit Multiple
0.0 -1.0x -0.5x 0.0x 0.5x 1.0x
-1.0% 0 0 0 0 0
-0.5% 0 0 0 0 0
WACC
WACC
0.0% 0 0 $0 0 0
0.5% 0 0 0 0 0
1.0% 0 0 0 0 0
WACC
0.0%
0.5%
1.0%
WACC
0.0%
0.5%
1.0%
Options/Warrants
Number of Exercise In-the-Money
Tranche Shares Price Shares Proceeds
Options 1 - - - -
Options 2 - - - -
Options 3 - - - -
Options 4 - - - -
Options 5 - - - -
Total - - -
NA Implied EV/EBITDA -x
-% -% -% -% -%
-% -% -% -% -%
-% -% -% -% -%
-% -% -% -% -%
-% -% -% -% -%
-% -% -% -% -%
-% -% -% -% -%
Implied Equity Value
Exit Multiple
0.0 -1.0x -0.5x 0.0x 0.5x 1.0x
-1.0% 0 0 0 0 0
-0.5% 0 0 0 0 0
0.0% 0 0 $0 0 0
0.5% 0 0 0 0 0
1.0% 0 0 0 0 0
Current Assets
Accounts Receivable - - - - - - -
Inventories - - - - - - -
Prepaid Expenses and Other - - - - - - -
Total Current Assets - - - - - - -
Current Liabilities
Accounts Payable - - - - - - -
Accrued Liabilities - - - - - - -
Other Current Liabilities - - - - - - -
Total Current Liabilities - - - - - - -
Assumptions
Days Sales Outstanding - - - - - - -
Days Inventory Held - - - - - - -
Prepaids and Other CA (% of sales) -% -% -% -% -% -% -%
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
-% -%
- -
-% -%
-% -%
ValueCo Corporation
Weighted Average Cost of Capital Analysis
($ in millions)
Debt-to-Total Capitalization
Pre-tax C
WACC -% 0.0 -1.0%
-20.0% 0.2%
-10.0% 0.1%
0.0% 0.0%
10.0% -0.1%
20.0% -0.2%
-% -
-% -
Projection Period
Year 1 Year 2 Year 3 Year 4 Year 5 Year 6
2009 2010 2011 2012 2013 2014
SG&A (% sales) -% -% -% -% -% -
Base 1 -% -% -% -% -% -
Management 2 -% -% -% -% -% -
Upside 3 -% -% -% -% -% -
Downside 1 4 -% -% -% -% -% -
Downside 2 5 -% -% -% -% -% -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
Assumptions Page 2 - Balance Sheet
Projection Period
Year 1 Year 2 Year 3 Year 4 Year 5 Year 6
2009 2010 2011 2012 2013 2014
Current Assets
Days Sales Outstanding (DSO) - - - - - -
Base 1 - - - - - -
Management 2 - - - - - -
Upside 3 - - - - - -
Downside 1 4 - - - - - -
Downside 2 5 - - - - - -
Current Liabilities
Days Payable Outstanding (DPO) - - - - - -
Base 1 - - - - - -
Management 2 - - - - - -
Upside 3 - - - - - -
Downside 1 4 - - - - - -
Downside 2 5 - - - - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -