ENR Valuation Bremer_031213

32 88205 160 163 164 143 149 150 150 155 155 155 155

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: .65 216.40 179.62 236.92 188.44 213.43 217.89 225.82 236.80 234.10 242.40 254.99 259.76 265.45 267.20 Tax Rate 30.4% 33.1% 25.8% 35.7% 27.7% 30.5% 30.6% 30.1% 30.9% 30.0% 30.4% 30.4% 30.3% 30.4% 30.3% Depreciation 136 124.5 133.4 176.1 Depr Rate as % of Net Fixed Assets 16.3% 14.4% 15.9% 19.9% 18.8% CAPX 2040.9 412.2 107.9 357.5 91.7 CAPX Rate as % of Net Fixed Assets 244% 48% 13% 40% 11% Non-Cash WC 493.9 607 546.3 762.1 496.6 11% 15% 13% 16% 11% 113.1 -60.7 215.8 -265.5 Non-Cash WC/Revenue 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 Value Premium/Discount Discount 159.5 159.322205 149.679019 150.875986 157.997719 19.0% 18.0% 18.6% 18.5% 183.00 17% 17% 621.60306 652.466622 651.512952 13% 14% 13% 18.8% 159.28958 162.097486 164.516372 168.618678 172.407089 173.720058 149.36 142.691203 143.273242 174.476667 176.098106 179.242182 182.003962 186.456021 190.601179 18% 18.3% 21% 18.6% 21% 18.5% 20% 18.4% 20% 18.5% 20% 21% 670.3076 655.016059 689.889205 704.419186 715.252405 728.727064 733.722303 14% 13% 13% 13% 13% 13% 4.6% 470.99 533.99 494.19 545.98 502.81 552.40 567.76 576.20 370.31 $95.98 $91.74 $4.24 13% 125.00306 30.8635612 -0.9536696 18.7946479 -15.291541 34.8731458 14.5299807 10.8332198 13.4746584 4.99523934 370.31 $7,361.30 2138.6 718.5 $5,941.20 20% 470.99 533.99 494.19 545.98 502.81 552.40 567.76 576.20 WACC Terminal Growth Shares Outstanding 8.06% 1% 61.9 600.57 8587.0203 9187.59 Company (Exchange: Ticker) Avon Products Inc (NYSE: AVP) Church & Dwight Co (NYSE: CHD) Colgate-Palmolive Co (NYSE: CL) Newell Rubbermaid Inc (NYSE:NWL) Proctor & Gamble Co (NYSE: PG) Sprectrum Brands Holdings (NYSE: SPB) The Clorox Company (NYSE: CLX) Estee Lauder Companies (NYSE: EL) Mean Median Energizer Holdings Inc (NYSE: ENR) Ratios NTM Forward TEV/EBITDA P/E Growth Sales Growth Net Income Growth 1 Year 5 Year CAGR 1 Year 5 Year 10.1 12.6 12.6 9 11.7 9.1 11.2 12.8 11.1 11.2 19.22 21.95 20.09 12.99 18.46 15.21 18.9 23.64 18.8 18.9 -5.1% 6.3% 2.1% 0.7% -0.4% 3.1% 5.5% 5.7% 0.0 0.0 0.5 0.1 0.5 0.1 0.2 0.2 0.3 2.2% 3.1% 13.0% 6.9% 50.2% 9.3% 18.4% 13.0% 19.1% Err:509 Err:509 Err:509...
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