EL Valuation Bremer

5 135 135 135 135 14 14 8251 5651 9073 11822 13945

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 1 2055.58 2241.50 2375.99 2518.55 2652.03 2705.07 2793.24 2852.43 10.4% 7.7% 11.6% 13.4% 14.4% 15.0% 15.5% 15.7% 15.7% 16.0% 16.0% 16.0% 16.2% 16.2% 16.4% 16.5% 288.3 191.1 271.4 370.9 443.0 503.6 562.0 614.8 657.8 717.3 760.3 805.9 848.7 865.6 893.8 912.8 34.9% 33.8% 29.9% 31.4% 31.8% 32% 32% 32% 32% 32% 32% 32% 32% 32% 32% 32% 250.7 254 263.7 294.4 295.8 344.22 368.61 399.01 440.96 468.78 500.00 530.34 551.25 561.64 593.93 603.43 24.0% 24.7% 25.8% 25.8% 24.0% 24.9% 25.0% 25.1% 24.9% 24.8% 24.9% 25.0% 24.9% 24.9% 24.9% 24.9% 473.8 348.3 281.3 607.1 428.3 191.44 280.29 281.18 264.14 345.05 386.52 410.06 466.25 517.44 463.69 567.67 45.4% 33.9% 27.5% 53.1% 34.8% 13.8% 19.0% 17.7% 14.9% 18.2% 19.3% 19.3% 21.1% 23.0% 19.4% 23.5% Revenue Revenue Growth EBIT EBIT Margin Taxes Tax Rate Depreciation Depr Rate as % of Net Fixed Assets CAPX CAPX Rate as % of Net Fixed Assets Non-Cash WC 686.3 588.8 428.1 490.2 381.6 665.09 665.37 665.57 710.80 756.77 845.93 876.43 901.51 921.80 943.35 962.23 Non-Cash WC/Revenue 8.7% 8.0% 5.5% 5.6% 3.9% 6.3% 5.9% 5.4% 5.4% 5.4% 5.7% 5.6% 5.5% 5.5% 5.5% 5.6% -97.5 -160.7 62.1 -108.6 283.49 0.28 0.20 45.23 45.97 89.16 30.50 25.08 20.29 21.55 18.88 939.34 1282.21 1423.98 1529.39 1601.98 1639.99 1802.40 1863.31 1863.36 2008.09 939.34 1282.21 1423.98 1529.39 1601.98 1639.99 1802.40 1863.31 1863.36 Chg in Non-Cash WC FCFF Terminal Value Total Cash Flows Firm Value Less: LT Debt Plus Cash and Mkt Sec. Equity Value Intrinsic Value Current Price Price Difference Premium $23,751.08 1069.1 1347.7 $24,029.68 $62.16 63.10 ($0.94) -1.5% WACC Terminal Growth Shares Outstanding 8.12% 1.50% 386.6 1956.54 30005.678 2008.09 31962.21 Company (Exchange: Ticker) Avon Products Inc (NYSE: AVP) Colgate-Palmolive Co (NYSE: CL) Elizabeth Arden, Inc (NasdaqGS:RDEN) Kimberley-Clark Corp (NYSE:KMB) L'Oreal SA (ENXTPA: OR) Limited Brands, Inc (NYSE:LTD) Proctor & Gamble Co. (NYSE:PG) Mean Median The Estee Lauder Companies Ratios NTM Forward TEV/EBITDA P/E Growth Sales Growth Net Income Growth 1 Year 5 Year CAGR 1 Year 5 Year 11.9 10.5 10.7 16.06 21.9 14.31 18.21 17.7 18.2 -5.1% 2.1% 8.1% 1.0% 10.4% -1.8% -0.4% 2.1% 1.0% 1.5% 4.4% 2.6% 2.9% 5.7% -1.5% 1.1% 2.4% 2.6% 1...
View Full Document

This document was uploaded on 03/20/2014 for the course FINC 490 at Xavier.

Ask a homework question - tutors are online