Answered step by step
Verified Expert Solution
Link Copied!

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!

image text in transcribed

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

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

Step: 3

blur-text-image

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

Health Care Finance Economics And Policy For Nurses

Authors: Betty Rambur

2nd Edition

0826152538, 978-0826152534

More Books

Students also viewed these Finance questions

Question

Create a Fishbone diagram with the problem being coal "mine safety

Answered: 1 week ago