Colgate-Palmolive

Navigate firm data through the following pages:

Analyst Listing       Primary Input Data
Derived Input Data       Valuation Model Outcomes

Analyst Listing

The following analysts provide coverage for the subject firm as of May 2016:

Broker Analyst Analyst Email
Bernstein Research Ali Dibadj ali.dibadj@bernstein.com
CRT Capital Group April Scee ascee@sterneageecrt.com
Deutsche Bank Research Bill Schmitz Jr. william.schmitz@db.com
Atlantic Equities Charles Eden c.eden@atlantic-equities.com
Consumer Edge Research Javier Escalante jescalante@consumeredgeresearch.com
William Blair Jon R. Andersen jandersen@williamblair.com
Raymond James Joseph Altobello joe.altobello@raymondjames.com
First Global Stockbroking Kavita Thomas kavita.thomas@fglobal.com
B Riley & Co Linda Bolton Weiser lweiser@brileyco.com
Stifel Nicolaus Mark S. Astrachan msastrachan@stifel.com
RBC Capital Markets Nik Modi nik.modi@rbccm.com
SunTrust Robinson Humphrey William B. Chappell Jr. bill.chappell@suntrust.com

Return to top of page


Primary Input Data

 

Return to top of page


Derived Input Data

Derived Input

Label

2015  Value

2016  Value

Equational Form

Net Operating Profit Less Adjusted Taxes NOPLAT   2,581  2,574 NOPLAT\, =\, EBIT\, x\, (1 \,-\, Avg \,\,Tax\,\, Rate\,\, on\,\, EBIT)
Free Cash Flow FCF  2,258  2,548 FCF\,=NOPLAT\,+\,Non-Cash\,Expenses-\Delta NWC\,-\,NCS
Tax Shield TS  62  48 TS\,=\,Interest\,\,Paid\,\,x\,\, Avg \,\,Tax\,\,Rate\,\, on\,\, Pre-Tax\,\, Income
Invested Capital IC  8,424  8,818 IC\,=\,Fixed\,\,Operating\,\,Assets\,\,+\,\,Net\,\, Working\,\, Capital
Return on Invested Capital ROIC 30.63% 29.19% ROIC\,=\,\frac { NOPLAT }{ IC }
Net Investment NetInv  (640)  837 NetInv\,=\,{ {IC}_{1}}-{{IC}_{0}}+Depreciation
Investment Rate IR -24.80% 32.52% IR\,=\,\frac {NetInv}{NOPLAT}
Weighted Average Cost of Capital WACCMarket 8.49% 7.17% WACC\,=\,\frac { E }{ V } { R }_{ E }\,+\,\frac { P }{ V } { R }_{ P }\,+\,\frac { D }{ V } { R }_{ D }\left( 1- Avg\,\, Tax\,\,Rate\,\,on\,\,Pre-Tax\,\,Income \right)
 WACCBook  6.85% 6.82%
Enterprise value EVMarket  63,925  61,935  EV\,=\,Market\,\,Cap\,\,Equity\,+\,\,Long\,\,Term\,\,Debt\,-\,Cash
 EVBook  64,671  62,925
EV/EBIT Multiple \frac{EV_{Market}}{EBIT}  16.10  15.64 EV/EBIT\,=\,\frac { EV}{ EBIT}
Long-Run Growth g = IR x ROIC
   -7.60%   9.49% Long-run growth rates of the income variable  are used in the Continuing Value portion of the valuation models.
 g = % \Delta GDP     2.50%   2.50%

Return to top of page


Valuation Model Outcomes

The outcomes presented in this study are the result of original input data, derived data, and synthesized inputs and, depending on the equational form of any particular valuation model, may result in irrelevant or implausible results.  For example, in the event WACC < g, the value of this term, often found in the denominator of an equation’s continuation value term, will be expressly negative and may result in a negative overall valuation for the firm.  In the event of a WACC < g relation, the model form as applied to the subject firm offers an irrelevant outcome.

Valuation Model Type

Label

Equational form

Key Value Driver (NOPLAT) KVD (NOPLAT) { Value }_{ DCF/KVD }=\sum { \frac { NOPLAT_{ t } }{ { \left( 1+WACC \right) }^{ t } } +\frac { \frac { { NOPLAT }_{ 1 }\left( 1-\frac { g }{ ROIC } \right) }{ WACC-g } }{ { \left( 1+WACC \right) }^{ t } } }
 
Key Value Driver (FCF) KVD (FCF)
{ Value }_{ DCF/KVD }=\sum { \frac { FCF_{ t } }{ { \left( 1+WACC \right) }^{ t } } +\frac { \frac { { NOPLAT }_{ 1 }\left( 1-\frac { g }{ ROIC } \right) }{ WACC-g } }{ { \left( 1+WACC \right) }^{ t } } }
 
Free Cash Flow FCF  { Value }_{ DCF/FCF }=\sum { \frac { FCF_{ t } }{ { \left( 1+WACC \right) }^{ t } } +\frac { \frac { { FCF }_{ 1 }}{ WACC-g } }{ { \left( 1+WACC \right) }^{ t } } }
 
Economic Profit ECON π  { Value }_{ { ECON\pi } }= I{ C }_{ 0 }+\sum { \frac { { IC }_{ t-1 }(ROI{ C }_{t}-WAC{C}_{t}) }{ { \left( 1+WACC \right) }^{ t } }+ \frac {\frac { I{C}_{0}\ x\ (ROI{C}_{1}\ -\ WAC{C}_{1}) }{ WACC-g } }{ { \left( 1+WACC \right) }^{ t } } }
 
Adjusted Present Value APV { Value }_{ APV }=\sum { \frac { FCF_{ t } }{ { \left( 1+{ k }_{ u } \right) }^{ t } } +\frac { \frac { { FCF }_{ 1 }}{ { k }_{ u }-g } }{ { \left( 1+{ k }_{ u } \right) }^{ t } } } +\sum { \frac { { TS }_{ t } }{ { \left( 1+{ k }_{ tax } \right) }^{ t } } +\frac { \frac { { TS }_{ 1 }}{ { k }_{ tax }-g } }{ { \left( 1+{ k }_{ tax } \right) }^{ t } } }
 
Forward Market Multiple FMM  { Value }_{ DCF/FMM}=\sum { \frac { FCF_{ t } }{ { \left( 1+WACC \right) }^{ t } } +\frac { { EBIT }_{ 1 }\,{x}\,{FMM}}{ { \left( 1+WACC \right) }^{ t } } }{\,\,\,; \,\,FMM\,=\,\frac{{EV}_{t=0}}{{EBIT}_{t=0}}}
 

Return to top of page