DDM Analysis: BHARTIARTL.BO

Valuation Snapshot

Stable Growth	$10,802.27 - $12,726.91	$11,926.98
Multi-Stage	$3,056.54 - $3,350.49	$3,200.79
Blended Fair Value	$7,563.88
Current Price	$1,878.40
Upside	302.68%
Decision	Buy

Dividend History & Growth Metrics (10Y)

Metric	5Y CAGR	10Y CAGR	2025	2024	2023	2022	2021	2020	2019	2018	2017	2016
DPS	30.59%	15.77%	11.51	6.95	5.96	2.40	4.47	3.03	7.74	5.42	1.52	1.77
YoY Growth	-	-	65.73%	16.57%	148.64%	-46.34%	47.33%	-60.82%	42.77%	256.15%	-14.15%	-33.40%
Dividend Yield	-	-	0.57%	0.48%	0.68%	0.35%	0.87%	0.55%	2.26%	1.58%	0.44%	0.54%

Stable Growth Model (Adjusted)

(USD in Millions except Per Share Data)

Net Income To Common (M)	385,426.00
(-) Cash Dividends Paid (M)	114,035.00
(=) Cash Retained (M)	271,391.00

Metric	LOW	BASE	HIGH
Required Retention Ratio	20.0%	12.5%	7.5%
(=) Cash Required (M)	77,085.20	48,178.25	28,906.95
Cash Retained (M)	271,391.00	271,391.00	271,391.00
(-) Cash Required (M)	-77,085.20	-48,178.25	-28,906.95
(=) Excess Retained (M)	194,305.80	223,212.75	242,484.05
(/) Shares Outstanding (M)	6,022.80	6,022.80	6,022.80
(=) Excess Retained per Share	32.26	37.06	40.26
LTM Dividend per Share	18.93	18.93	18.93
(+) Excess Retained per Share	32.26	37.06	40.26
(=) Adjusted Dividend	51.20	56.00	59.19
WACC / Discount Rate	5.18%	5.18%	5.18%
Growth Rate	5.50%	6.50%	7.50%
Fair Value	$10,802.27	$11,926.98	$12,726.91
Upside / Downside	475.08%	534.95%	577.54%

Multi-Stage Model: Projections

(USD in Millions)

Metric	TTM	Dec-27	Dec-28	Dec-29	Dec-30	Dec-31	Terminal
Net Income (M)	385,426.00	410,478.69	437,159.80	465,575.19	495,837.58	528,067.02	543,909.03
Payout Ratio	29.59%	41.67%	53.75%	65.83%	77.92%	90.00%	92.50%
Projected Dividends (M)	114,035.00	171,043.98	234,982.34	306,510.02	386,343.50	475,260.32	503,115.86

Multi-Stage Valuation

Metric	LOW	BASE	HIGH
WACC / Discount Rate	5.18%	5.18%	5.18%
Growth Rate	5.50%	6.50%	7.50%
Year 1 PV (M)	161,097.64	162,624.63	164,151.62
Year 2 PV (M)	208,448.10	212,418.45	216,426.26
Year 3 PV (M)	256,087.72	263,439.08	270,929.80
Year 4 PV (M)	304,017.83	315,709.49	327,735.19
Year 5 PV (M)	352,239.75	369,253.06	386,917.51
PV of Terminal Value (M)	17,127,028.48	17,954,270.36	18,813,172.73
Equity Value (M)	18,408,919.52	19,277,715.08	20,179,333.11
Shares Outstanding (M)	6,022.80	6,022.80	6,022.80
Fair Value	$3,056.54	$3,200.79	$3,350.49
Upside / Downside	62.72%	70.40%	78.37%

High-Yield Dividend Screener

US Stocks Global Stocks

« Prev Page 24 of 30 Next »

Ticker ⇵	Company ⇵	Dividend Yield % ▼	Dividend Per Share ⇵	Payout Ratio % ⇵
EXPD	Expeditors International of Washington, Inc.	0.99%	$1.50	24.32%
LISOX	Lazard International Strategic Equity Ptf Open Shares	0.99%	$0.13	36.87%
MXC	Mexco Energy Corporation	0.99%	$0.10	12.25%
NIC	Nicolet Bankshares, Inc.	0.99%	$1.19	12.58%
PAYC	Paycom Software, Inc.	0.99%	$1.51	18.80%
RRC	Range Resources Corporation	0.99%	$0.35	14.60%
WLFC	Willis Lease Finance Corporation	0.99%	$1.32	7.58%
WOR	Worthington Industries, Inc.	0.99%	$0.52	23.95%
CNXN	PC Connection, Inc.	0.98%	$0.56	16.89%
CAT	Caterpillar Inc.	0.97%	$5.78	29.40%
CNK	Cinemark Holdings, Inc.	0.97%	$0.23	18.28%
ECL	Ecolab Inc.	0.97%	$2.54	36.57%
EVR	Evercore Inc.	0.97%	$3.41	27.02%
LSBK	Lake Shore Bancorp, Inc.	0.96%	$0.14	24.34%
0ITL.L	Arthur J. Gallagher & Co.	0.95%	$2.42	39.43%
0IZI.L	W.W. Grainger, Inc.	0.95%	$9.52	26.47%
0L5V.L	The Sherwin-Williams Company	0.95%	$3.11	30.09%
0R2S.L	Stryker Corporation	0.95%	$3.28	43.09%
RRX	Regal Rexnord Corporation	0.95%	$1.39	36.07%
WT	WisdomTree, Inc.	0.95%	$0.12	18.12%
J	Jacobs Solutions Inc.	0.94%	$1.27	53.80%
ORCL	Oracle Corporation	0.94%	$1.84	34.81%
TCBS	Texas Community Bancshares, Inc.	0.94%	$0.17	19.22%
IMKTA	Ingles Markets, Incorporated	0.93%	$0.65	14.68%
ODC	Oil-Dri Corporation of America	0.93%	$0.45	12.28%
PENG	Penguin Solutions, Inc.	0.93%	$0.19	40.17%
SSBK	Southern States Bancshares, Inc.	0.93%	$0.34	9.19%
DAL	Delta Air Lines, Inc.	0.92%	$0.63	8.94%
HIFS	Hingham Institution for Savings	0.92%	$2.49	12.15%
RL	Ralph Lauren Corporation	0.92%	$3.34	24.37%
OPY	Oppenheimer Holdings Inc.	0.91%	$0.66	8.90%
BGC	BGC Group, Inc	0.90%	$0.08	23.56%
CDRE	Cadre Holdings, Inc.	0.90%	$0.37	33.35%
MBNKP	Medallion Bank	0.90%	$0.23	12.50%
JBHT	J.B. Hunt Transport Services, Inc.	0.89%	$1.75	30.14%
NYT	The New York Times Company	0.89%	$0.62	30.32%
RMD	ResMed Inc.	0.89%	$2.18	22.31%
VBFC	Village Bank and Trust Financial Corp.	0.89%	$0.72	15.35%
0I14.L	Cognex Corporation	0.88%	$0.32	49.16%
AR	Antero Resources Corporation	0.88%	$0.30	17.15%
LDOS	Leidos Holdings, Inc.	0.88%	$1.61	14.88%
LMAT	LeMaitre Vascular, Inc.	0.88%	$0.70	32.20%
NNI	Nelnet, Inc.	0.88%	$1.14	9.52%
PFSI	PennyMac Financial Services, Inc.	0.88%	$1.16	12.49%
SMBK	SmartFinancial, Inc.	0.88%	$0.32	11.76%
BYD	Boyd Gaming Corporation	0.87%	$0.75	3.22%
ROST	Ross Stores, Inc.	0.87%	$1.59	24.85%
BBSI	Barrett Business Services, Inc.	0.86%	$0.31	15.02%
BCO	The Brink's Company	0.86%	$1.00	24.81%
HXL	Hexcel Corporation	0.86%	$0.66	77.18%

Financial Statements

Fundamentals

Valuations

Miscellaneous

Mode

Ticker

Industry

Sector

Bharti Airtel Limited (BHARTIARTL.BO)

Valuation Snapshot

Dividend History & Growth Metrics (10Y)

Stable Growth Model (Adjusted)

Multi-Stage Model: Projections

Multi-Stage Valuation

High-Yield Dividend Screener