Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How do you get the red highlighted number, what is the formula? Table 19.15: Continuation Value Estimate for Ideko Continuation Value: Multiples Approach (5000) EBIDTA

image text in transcribed

How do you get the red highlighted number, what is the formula?

Table 19.15: Continuation Value Estimate for Ideko Continuation Value: Multiples Approach (5000) EBIDTA in 2010 EBITDA multiple Continuation Enterprise Value Debt Continuation Equity Value 32,094 9.1x 292,052 Common Multiples EV/Sales P/E (levered) PE (unlevered) 1.8x 16.3x 18.4x (120,000) 172,052 Table 19.16 Continuation Value: DCF and EBITDA Multiple (5000s) 1 2 3 Free Cash Flow in 2011 5.34% 40.0% 9.05% Long-Term Growth Rate Target D(ED) Projected WACC rwace = ru-d TrD = 10% - 0.40(0.35) = 9.05 Unlevered Net Income Less: Increase in NWC Less: Increase in Fixed Assets Free Cash Flow 4 S 16,695 (2,157) (3,704) 10,834 Continuation Enterprise Value = V1.2010= (FCF2011)(rwacc-g) CEV 292,052 Implied EBITDA Multiple 9.1x 6 7 ru= 10% 10.0% Year 2005PF 2009 1,458.09 274,891.40 202,731.66 Table 19.17 APV Estimate for Ideko's Initial Equity Value APV Method (5000) Free Cash Flow Unlevered Value Vu (at 10%) Interest Tax Shield (at 6.8%) %) Tax Shield Value Ts APV: VL - V+ Debt Equity Value 2010 10,328.25 292,052.29 2,856.00 2006 13,474.41 209,530.41 2,380.00 8,757.02 218,287.43 (100,000) 118,287.43 2007 7,408.57 223,074.88 2,380.00 6,972.50 230,047.38 (100,000) 130,047.38 2008 (5.844.44) 251.226.81 2,380.00 5,066.63 256.293.44 (115,000) 141,293.44 2,737.00 10,427.92 213,159.58 (100,000) 113,159.58 2,674.16 277,565.56 (120,000) 157,565.56 292,052.29 (120,000) 172,052.29 Table 19.15: Continuation Value Estimate for Ideko Continuation Value: Multiples Approach (5000) EBIDTA in 2010 EBITDA multiple Continuation Enterprise Value Debt Continuation Equity Value 32,094 9.1x 292,052 Common Multiples EV/Sales P/E (levered) PE (unlevered) 1.8x 16.3x 18.4x (120,000) 172,052 Table 19.16 Continuation Value: DCF and EBITDA Multiple (5000s) 1 2 3 Free Cash Flow in 2011 5.34% 40.0% 9.05% Long-Term Growth Rate Target D(ED) Projected WACC rwace = ru-d TrD = 10% - 0.40(0.35) = 9.05 Unlevered Net Income Less: Increase in NWC Less: Increase in Fixed Assets Free Cash Flow 4 S 16,695 (2,157) (3,704) 10,834 Continuation Enterprise Value = V1.2010= (FCF2011)(rwacc-g) CEV 292,052 Implied EBITDA Multiple 9.1x 6 7 ru= 10% 10.0% Year 2005PF 2009 1,458.09 274,891.40 202,731.66 Table 19.17 APV Estimate for Ideko's Initial Equity Value APV Method (5000) Free Cash Flow Unlevered Value Vu (at 10%) Interest Tax Shield (at 6.8%) %) Tax Shield Value Ts APV: VL - V+ Debt Equity Value 2010 10,328.25 292,052.29 2,856.00 2006 13,474.41 209,530.41 2,380.00 8,757.02 218,287.43 (100,000) 118,287.43 2007 7,408.57 223,074.88 2,380.00 6,972.50 230,047.38 (100,000) 130,047.38 2008 (5.844.44) 251.226.81 2,380.00 5,066.63 256.293.44 (115,000) 141,293.44 2,737.00 10,427.92 213,159.58 (100,000) 113,159.58 2,674.16 277,565.56 (120,000) 157,565.56 292,052.29 (120,000) 172,052.29

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_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

Commodity Finance

Authors: Weixin Huang

2nd Edition

0857196650, 978-0857196651

More Books

Students also viewed these Finance questions

Question

=+j Identify the challenges of training an international workforce.

Answered: 1 week ago