The note is the current scenario (Base). Download PDF renders this page on the server, fonts and colours exact; Print uses the browser.
Model Note · COLGATE PALMOLIVE LTD. · 11 September 2026Page 1 of 2
Model Note
Prepared by the reader · not a MarketPing document
COLGATE PALMOLIVE LTD. Discounted cash flow · base FY26
COLGATE PALMOLIVE LTD.
Value per share, this model₹709
CMP 2026-09-10₹1,797.40
Difference(60.6)%
Growth the CMP implies24.2%/yr
This note states the assumptions and the arithmetic of one model of COLGATE PALMOLIVE LTD., built on its filed FY26 consolidated statements. The value is the outcome of the assumptions below and nothing else; it is not a fair value, a target or a recommendation.
Assumptions
Input
This model
Filed reference
Revenue growth, 5 years
0% a year
FY26 (0.1)% · 5-yr CAGR 4.5%
EBITDA margin
30.6%
FY26 30.6% · 5-yr average 31.2%
Depreciation · capex, % of revenue
2.4% · 1.3%, fading to 1.2× depreciation
FY26 2.4% · 1.3%
Working capital, % of added revenue · tax
0% · 25.7%
-48 working-capital days · effective 25.7%
Discount rate
11.00%
1-yr beta 0.84
After FY31
5% flat · mid-year discounting
—
Net debt · non-controlling interest · non-operating investments
₹(1,426) · ₹0 · ₹0 cr
FY26 net debt ₹(1,426) cr
Shares
27.20 crore
27.20 crore today
Source: SEBI results XBRL as filed with BSE/NSE, exchange prices; the reader's assumptions.
Projected cash flow to the firm
₹ crore
FY26
FY27
FY28
FY29
FY30
FY31
Revenue
6,035
6,035
6,035
6,035
6,035
6,035
growth %
(0.1)
0.0
0.0
0.0
0.0
0.0
EBITDA
1,845
1,847
1,847
1,847
1,847
1,847
Depreciation
(146)
(145)
(145)
(145)
(145)
(145)
NOPAT
1,262
1,264
1,264
1,264
1,264
1,264
less capex
(76)
(78)
(102)
(126)
(150)
(174)
less working-capital build
—
0
0
0
0
0
Free cash flow to firm
—
1,331
1,307
1,283
1,259
1,236
Present value
1,263
1,118
989
874
773
Source: the model; base year as filed.
Every figure is the reader's model over filed numbers · No rating, target or fair value is expressedmarketping.in
Model Note · COLGATE PALMOLIVE LTD. · 11 September 2026Page 2 of 2
From enterprise to equity
PV of the 5 explicit years
5,016
PV of the terminal value (72% of EV)
12,831
Enterprise value
17,847
less net debt
1,426
less non-controlling interest
0
add non-operating investments
0
Equity value
19,273
÷ 27.20 crore shares
₹709
Source: the model.
Sensitivity, ₹ per share
WACC ↓ · terminal growth →
4.0%
4.5%
5.0%
5.5%
6.0%
10.0%
730
777
833
902
988
10.5%
680
719
765
821
888
11.0%
637
670
709
754
808
11.5%
600
628
661
698
743
12.0%
568
592
620
651
689
Source: the model; n/a where terminal growth reaches the discount rate.
Statement
This note is the reader's own model over publicly filed information: SEBI results XBRL filed with BSE and NSE and exchange price data, assembled by MarketPing software; every assumption above is the reader's. It contains no research recommendation, no price target and no opinion by MarketPing on the merits of any security, and is not a research report within the meaning of the SEBI (Research Analysts) Regulations, 2014, Regulation 2(1)(w)(vii). Historical per-share figures are on the current share count. Where a figure is unavailable the table shows a dash rather than an estimate. Nothing here constitutes investment advice, an offer or a solicitation.
Every figure is the reader's model over filed numbers · No rating, target or fair value is expressedmarketping.in
