Question: Figure 1 Scenario Summary Current Values: Base Scenario Scenario 1 Scenario 2 Scenario 3 Changing Cells: SalesGrowth2012 4.0% 4.0% 5.0% 5.0% 5.0% SalesGrowth2013 4.0% 4.0%

Figure 1

Scenario Summary Current Values: Base Scenario Scenario 1 Scenario 2 Scenario 3 Changing Cells: SalesGrowth2012 4.0% 4.0% 5.0% 5.0% 5.0% SalesGrowth2013 4.0% 4.0% 5.0% 5.0% 5.0% SalesGrowth2014 4.0% 4.0% 5.0% 5.0% 5.0% SalesGrowth2015 4.0% 4.0% 5.0% 5.0% 5.0% SalesGrowth2016 4.0% 4.0% 5.0% 5.0% 5.0% TerminalEBITDAMultiple 7.0 7.0 7.0 7.5 7.5 UnleveredCostOfEquity 11.2% 11.2% 11.2% 11.2% 20.0% Operating Margin 2012 10.0% 10.0% 12.0% 12.0% 12.0% OperatingMargin2013 10.0% 10.0% 12.0% 12.0% 12.0% Operating Margin2014 10.0% 10.0% 12.0% 12.0% 12.0% OperatingMargin 2015 10.0% 10.0% 12.0% 12.0% 12.0% Operating Margin 2016 10.0% 10.0% 12.0% 12.0% 12.0% Result Cells: Enterprise Value $3,970 $3.970 $4.859 $5,102 $3,670 Notes: Current Values column represents values of changing cells at time Scenario Summary Report was created. Changing cells for each scenario are highlighted in gray.Stand-Alone Valuation (dollars in millions) PPG Industries Metric Actual Projected 2011 2012E 2013E Sales Growth (x) 10.9% 4 13 4.32 EBIT Margin (Pretax) 11.2% 1102 12. 02 EVEBITDA 2012 [*) 7.3 DuPont Performance Coatings Metric 2011A Closing Projected 2012E 2013E 2014E 2015E 2016E Sales Growth (x) 12.5% 4.0% 4.0% 4.0% 4.0% 4.0% Depreciation and Amortization $104 $ 115 $118 $122 $125 $130 EBIT Margin (Pretax) 6.3% 10.0% 10.0% 10.0% 10.0% 10.0% Tax Rate' 25% 25% 25% 25% 25% 25% Capital Expenditures $80 $115 $122 $132 $144 $150 Net Working Capital (7) 15.0% 15.0% 15.0% 15.0% 15.0% Terminal EBITDA Multiple (x) = 7.0 Debt/EBITDA 2012 (x) NIA Debt Blended Interest Rate on Debt 6.75% Unlevered Cost of Equity* 11.2% Valuation Analysis: with Zero leverage. 2011A Closing 2012E 2013E 2014E 2015E 2016E Net Sales $4.281 $4.452 $4.630 $4.816 $5,008 $5,208 EBITOA $372 $560 $581 $604 $626 $651 Depreciation and Amortization $104 $ 115 $718 $122 $125 $130 Pretax Operating Income (EBIT) $268 $445 $463 $482 $501 $521 Interest Expense $0 $0 $0 Earnings before Takes $445 $463 $482 $501 $521 Takes $ 1201 $1251 Net Income $334 $347 $36 $376 $391 subtract Increase in Net Working Capital ($26) ($27) $28 ($29 ($30) subtract Capital Expenditures $ 115) ($122) ( $132 ($144) $150 Unlevered Free Cash Flow $308 $317 $323 $327 $341 Terminal Value $4.738 Unlevered FCF, including TV $308 $317 $323 $327 $5,079 Enterprise Value (EV) $3.970 Interest Tax Shield PV Tax Shield EV with Tax Shield $3.970

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Need help with parts a through d. Scenario Summary Current Values Base Best Worst Changing Cells: $D$29 1,000 1,000 1,200 800 $D$30 $24.00 $24.00 $28.80 $19.20 $D$31 $17.50 $17.50 $14.00 $21.00...

Scenario Summary Current Values: Base Case Best Case Worst Case Changing Cells: $D$27 Base Case Base Case Best Case Worst Case $D$28 50% 50% 25% 25% $D$31 1,000 1,000 1,200 800 $D$32 $24.00 $24.00...

Answer Questions 2-5, and 6 for an upvote All screenshots of excel are included Need Answers for the Q&A Questions 1-6 fx What click response rate is required for a gross profit of over $7,000? B D 1...

Please note these may be out of order. Follow the number in steps. 1,2,3 3. Name the first new worksheet Scenario Manager. In this worksheet, use Scenario Manager as shown in Figure 2 to see the...

I am having trouble creating the formulas for number 11 and 13. Excel File Edit View Insert Format Tools Data Window Help Seminar Budget.xlsx Q Search Sheet cut AutoSum A | Fill Calibri Light Wrap...

Hi, if someone can please help with this. Exam tom!!!! Question related to the cash flow statement (given attached ) : #21 Net cash used for finance activities?, #22 The old machine was sold for?...

Evaluate the three projects by using the Mean-semi-variance approach ( b =5),and give recommendations for the airport. The possibility of each scenario is shown in Table 1. The detailed cash inflows...

Question 1 2 pts Consider the information in the le named Green Paradox. Concentrate on the scenario called Green Paradox Case 1. Currently (prior to any GHG policies by the Group 1 countries) the...

Hello, Can you help me with this assignment? the instruction for this assignment is in the attachment below CIS 1220 Final Exam Problem Statement Fashion Impressions is a designer clothing...

State the effect (cash receipt or payment and amount) of each of the following transactions, considered individually, on cash flows: a. Sold 5,000 shares of $30 par common stock for $45 per share. b....

Suppose that the inflation rate in an economy has been 4% for several years. The central bank unexpectedly increases the rate of growth of the money supply by 2%. Describe the effect on each of the...

in the statement of activities, can a private not - for - profit classify expenses by category in the notes

A newly formed team in an organization is diverse in terms of age, culture, and professional background. Discuss the potential challenges and benefits this diversity brings to the team's dynamics and