Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

Calculate and Complete the followng DCF Model WACC Calculation Asset beta 0.82 Risk-free rate 4.86% Market Risk Premium 5.00% Cost of debt 6.00% Target Debt

Calculate and Complete the followng DCF Model

WACC Calculation
Asset beta 0.82
Risk-free rate 4.86%
Market Risk Premium 5.00%
Cost of debt 6.00%
Target Debt Ratio 35%
Re-levered equity beta
Cost of equity
WACC
<=History Pro Forma =>
Operating Forecasts 2010 2011 2012 2013 2014 2015 2016 2017 Pro forma assumptions
US Sales 330 328 330 0.5% annual growth
International Sales 29 32 36 13.0% annual growth
Net Sales 359 360 366
Cost of Goods Sold 160 150 140 38.0% of sales
Depreciation 24 9 9 20.0% of beginning net PP&E
Marketing Expense 23 24 24 7.0% of sales
Other SG&A 107 108 111 30.0% of sales
EBIT 45 69 82
Supplementary Schedules
Net Working Capital
working cash 10 10 10 2.8% of sales
A/R 98 99 100 100 days sales outstanding AR = sales*(DSO/365)
Inventory 310 291 272 708 days of COGS Inv = cogs*(DCO/365)
Other CA 7 7 7 2.0% of sales
A/P 90 90 90 90 days of cash op expenses AP = cash op exp*(DCO/365)
Net working capital 335 317 299
D NWC
Other assets 45 45 45 12.50% of sales
D Other assets
Beginning net PP&E 144 140 132
Capital Expenditures 20 20 20 given and constant
Depreciation 24 28 26 20% of beginning net PP&E
Ending Net PP&E 140 132 126
Free Cash Flow Calculation Pro Forma =>
2013 2014 2015 2016 2017
EBIT
EBIT(1-t) tax rate = 40%
Depreciation
Capital expenditures
D NWC
D Other assets
Free cash flow
Terminal value Perp. g = 3% growing perpetuity
Discount factor
PV(FCF + TV)
PV Enterprise
Less EOY 2008 Debt 301
Estimated Equity Value
number of shares (000,000s) 10
Value per share $ -

Step by Step Solution

There are 3 Steps involved in it

Step: 1

To calculate the DCF model we need the following information Asset beta 082 Riskfree rate 486 Market ... blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Valuation The Art and Science of Corporate Investment Decisions

Authors: Sheridan Titman, John D. Martin

3rd edition

133479528, 978-0133479522

More Books

Students explore these related Finance questions

Question

What is a model?

Answered: 3 weeks ago

Question

What is a prototype?

Answered: 3 weeks ago