Edition:
United Kingdom

Colgate-Palmolive (India) Ltd (COLG.NS)

COLG.NS on National Stock Exchange of India

1,234.85INR
23 May 2018
Change (% chg)

Rs4.25 (+0.35%)
Prev Close
Rs1,230.60
Open
Rs1,230.00
Day's High
Rs1,245.45
Day's Low
Rs1,220.50
Volume
340,905
Avg. Vol
382,030
52-wk High
Rs1,281.70
52-wk Low
Rs975.05

Consensus Recommendations

Consensus Recommendation Next Earnings (approx.) Company Fiscal Year
End Month
Last Updated
Hold 6.68 March 26 May 2018

Analyst Recommendations and Revisions

1-5 Linear Scale Current 1 Month
Ago
2 Month
Ago
3 Month
Ago
(1) BUY 4 5 6 6
(2) OUTPERFORM 8 9 9 8
(3) HOLD 14 11 10 10
(4) UNDERPERFORM 8 10 10 11
(5) SELL 2 1 1 1
No Opinion 0 0 0 0
Mean Rating 2.89 2.81 2.75 2.81

Consensus Estimates Analysis

Sales and Profit Figures in India Rupee (INR)
Earnings and Dividend Figures in India Rupee (INR)
  # of Estimates Mean High Low 1 Year
Ago
SALES (in millions)
Quarter Ending Sep-18 2 11,880.60 12,224.30 11,537.00 --
Quarter Ending Dec-18 2 11,493.30 11,772.00 11,214.50 --
Year Ending Mar-18 33 43,349.40 51,713.00 41,370.00 --
Year Ending Mar-19 35 47,161.80 54,327.20 45,458.00 52,659.30
Year Ending Mar-20 34 53,025.30 66,384.00 49,305.00 59,819.90
Earnings (per share)
Quarter Ending Sep-18 3 6.68 7.04 6.20 --
Quarter Ending Dec-18 3 6.48 6.96 6.20 --
Year Ending Mar-18 33 24.17 25.95 22.90 --
Year Ending Mar-19 35 28.06 31.10 26.00 28.47
Year Ending Mar-20 34 32.21 37.10 29.10 31.21
LT Growth Rate (%) 3 13.74 14.00 13.30 11.31

Historical Surprises

Sales and Profit Figures in India Rupee (INR)
Earnings and Dividend Figures in India Rupee (INR)
Estimates vs Actual Estimate Actual Difference Surprise %
SALES (in millions)
Quarter Ending Mar-18 11,526.70 10,850.60 676.06 5.87
Quarter Ending Dec-17 10,215.40 10,269.70 54.28 0.53
Quarter Ending Sep-17 11,383.20 10,779.80 603.37 5.30
Quarter Ending Jun-17 10,685.00 9,694.30 990.66 9.27
Quarter Ending Mar-17 11,369.70 10,325.80 1,043.85 9.18
Earnings (per share)
Quarter Ending Mar-18 6.91 7.37 0.46 6.63
Quarter Ending Dec-17 5.83 6.27 0.44 7.48
Quarter Ending Sep-17 6.42 6.53 0.11 1.70
Quarter Ending Jun-17 4.85 5.01 0.16 3.26
Quarter Ending Mar-17 5.71 5.24 0.47 8.28

Consensus Estimates Trend

Sales and Profit Figures in India Rupee (INR)
Earnings and Dividend Figures in India Rupee (INR)
  Current 1 Week
Ago
1 Month
Ago
2 Month
Ago
1 Year
Ago
SALES (in millions)
Quarter Ending Sep-18 11,880.60 11,597.70 11,597.70 11,597.70 --
Quarter Ending Dec-18 11,493.30 11,708.90 11,708.90 11,708.90 --
Year Ending Mar-18 43,349.40 -- -- -- --
Year Ending Mar-19 47,161.80 48,321.50 48,321.50 48,669.80 52,659.30
Year Ending Mar-20 53,025.30 54,038.80 54,034.30 54,081.40 59,819.90
Earnings (per share)
Quarter Ending Sep-18 6.68 6.58 6.58 6.58 --
Quarter Ending Dec-18 6.48 6.55 6.55 6.55 --
Year Ending Mar-18 24.17 -- -- -- --
Year Ending Mar-19 28.06 27.67 27.66 27.83 28.47
Year Ending Mar-20 32.21 31.76 31.70 31.83 31.21

Estimates Revisions Summary

  Last Week Last 4 Weeks
Number Of Revisions: Up Down Up Down
Revenue
Quarter Ending Sep-18 1 0 1 0
Quarter Ending Dec-18 0 1 0 1
Year Ending Mar-18 -- -- -- --
Year Ending Mar-19 4 22 4 22
Year Ending Mar-20 6 18 7 18
Earnings
Quarter Ending Sep-18 1 0 1 0
Quarter Ending Dec-18 0 1 0 1
Year Ending Mar-18 -- -- -- --
Year Ending Mar-19 17 7 18 7
Year Ending Mar-20 15 9 15 9