Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help me finish filling in some of the blanks here, every cell highlighted in yellow needs a formula. Thank you in advance! TELMEX Today:
Please help me finish filling in some of the blanks here, every cell highlighted in yellow needs a formula. Thank you in advance!
TELMEX Today: September 12, 2011 Risk Free Rate 3% Country Premium Terminal Value 1.085% Figures in MXN MM 2011E 2013E 2012E 2014E 2015E 2016E Market Risk Premium 6% 42112 EBITDA 43278 41255 39914 39508 39038 Average Unlevered Beta D/(D+E) D/E Tax-affected EBIT (EBIAT) Depreciation & Amortization Capital Expenditures Increase in Net Working Capital 0.58 17546 17805 17979 18066 17719 17513 16324 0.25 16803 15466 15304 15139 14715 0.3333333 11000 10248 10408 9853 9716 8732 Tax Rate 0.28 336 567 -157 -266 -54 -79 Levered Beta Unlevered FCF 30940 29642 28404 27912 27439 27587 0 Fee Cost of Equity % of cash flow to discount 25% 100% 100% 100% 99.17% 0.83% 100% 100% Unleveled FCF to discount (MXN) Cost of Debt, Pre-Tax 5% 384584.2 356436.24 369042.9 355902.12 356432.61 363596.66 WACC FX rate: MXN per USD 13.27 12.43 12.45 12.53 12.77 12.99 13.18 Exit EV(T)/EBITDA(T) multiple Unlevered FCF to discount (USD) 5.5 Periods to discount 0.125 0.75 3.75 1.75 2.75 4.75 5.25 Discounted unlevered FCF (USD) Present value of FCFS Present value of Terminal Value EV Marke value of debt (& minority interest) 5667 Equity Value Total shares outstanding (MM) 18029 Price per share (USD) Spot FX rate: MXN per USD 12.77 Price per share (MXN)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started