Bharti Airtel

₹1349.5 5.3 | 0.4%

WEBSITE BSE:532454 NSE : BHARTI ARTL 18 May, 12:50

Market Cap ₹818594 Cr.

Stock P/E 103.4

P/B 8

Current Price ₹1349.5

Book Value ₹ 168.1

Face Value 5

52W High ₹1364.1

Dividend Yield 0.59%

52W Low ₹ 793.2

Edit Ratio

Bharti Airtel Research see more...

Overview Inc. Year: 1995Industry: Telecommunication - Service Provider

Bharti Airtel Limited is a global telecommunications agency with operations in 18 nations throughout Asia and Africa. Its segments are Mobile Services India, Mobile Services Africa, Mobile Services South Asia, Tower Infrastructure Services, Digital TV Services, Homes Services, Airtel Business and Others. The Mobile Services India segment consists of voice and data telecom offerings supplied through wireless technology (2G / 3G / 4G) in India. The Mobile Services Africa section consists of voice and records telecom offerings supplied via wi-fi era (2G / 3G / 4G) offered to customers in Africa. The Mobile Services South Asia segment consists of voice and information telecom services supplied through wireless generation (2G / 3G) in Sri Lanka. The Tower Infrastructure Services section consists of setting up, operating and maintaining wireless communication towers in India. The Digital TV Services section includes digital broadcasting offerings provided underneath the direct-to-home platform.

Bharti Airtel Share Price

New

Volume

Price

Price: NSE50 DMA200 DMAVolume

Quarterly Price

Quarterly Monthly

Show Value Show %

Peer Comparison

Bharti Airtel Quarterly Results

#(Fig in Cr.)
Net Sales
Other Income
Total Income
Total Expenditure
Operating Profit
Interest
Depreciation
Exceptional Income / Expenses
Profit Before Tax
Provision for Tax
Profit After Tax
Adjustments
Profit After Adjustments
Adjusted Earnings Per Share

Bharti Airtel Profit & Loss

#(Fig in Cr.)	Mar 2013	Mar 2014	Mar 2015	Mar 2016	Mar 2017	Mar 2018	Mar 2019	Mar 2020	Mar 2021	Mar 2022	Mar 2023
Net Sales	45351	49919	55496	60300	62276	53663	49606	54317	64326	70795	84720
Other Income	1463	853	5193	1744	2526	1077	4102	2243	2892	604	2634
Total Income	46814	50772	60689	62044	64803	54740	53708	56560	67218	71399	87354
Total Expenditure	31880	33620	36065	37989	38583	35858	38789	34184	36342	36095	40921
Operating Profit	14934	17152	24624	24055	26219	18882	14919	22376	30876	35305	46433
Interest	1652	1336	1409	3545	5255	5911	7848	11463	12321	13221	14532
Depreciation	6827	7231	7560	9575	12203	13049	15120	20392	21998	24330	26355
Exceptional Income / Expenses	0	-207	0	-680	-17271	-604	2805	-41542	-15023	-2010	-4276
Profit Before Tax	6455	8377	15655	10254	-8510	-681	-5244	-51021	-18465	-4256	1269
Provision for Tax	1359	1777	2455	2474	1416	-760	-3375	-14933	6732	-392	1359
Profit After Tax	5096	6600	13201	7780	-9926	79	-1869	-36088	-25198	-3864	-90
Adjustments	0	0	0	0	0	0	0	0	0	0	0
Profit After Adjustments	5096	6600	13201	7780	-9926	79	-1869	-36088	-25198	-3864	-90
Adjusted Earnings Per Share	12.1	14.9	29.7	17.5	-22.4	0.2	-4.2	-64.9	-45	-6.9	-0.2

Growth Rates

#	1 Year	3 Year	5 Year	10 Year
Sales CAGR	20%	16%	10%	6%
Operating Profit CAGR	32%	28%	20%	12%
PAT CAGR	0%	0%	NAN%	NAN%

#	1 Year	3 Year	5 Year	10 Year
Share Price CAGR	69%	37%	32%	16%
ROE Average	-0%	-11%	-14%	-3%
ROCE Average	8%	3%	-2%	4%

Bharti Airtel Balance Sheet

#(Fig in Cr.)	Mar 2013	Mar 2014	Mar 2015	Mar 2016	Mar 2017	Mar 2018	Mar 2019	Mar 2020	Mar 2021	Mar 2022	Mar 2023
Shareholder's Funds	54146	66728	78273	111729	101207	102861	98306	101429	77360	74871	78993
Minority's Interest	0	0	0	0	0	0	0	0	0	0	0
Borrowings	9841	7272	19627	41457	50342	54468	58612	70471	89909	97323	136230
Other Non-Current Liabilities	4471	5096	5473	1688	3391	2544	308	12581	23200	6849	27465
Total Current Liabilities	19477	29995	37028	27913	35816	43640	60701	93211	71439	76181	78245
Total Liabilities	87934	109091	140400	182787	190757	203513	217927	277692	261909	255223	320933
Fixed Assets	43183	39878	53444	91926	111523	122609	133812	161679	157388	163736	187409
Other Non-Current Assets	38497	51587	58060	79375	62530	65073	64601	57232	64448	58196	92947
Total Current Assets	6255	17626	28732	11487	15331	15830	19515	58781	40072	33291	40577
Total Assets	87934	109091	140400	182787	190757	203513	217927	277692	261909	255223	320933

Bharti Airtel Cash Flow

#(Fig in Cr.)	Mar 2013	Mar 2014	Mar 2015	Mar 2016	Mar 2017	Mar 2018	Mar 2019	Mar 2020	Mar 2021	Mar 2022	Mar 2023
Opening Cash & Cash Equivalents	355	328	446	385	-256	82	417	171	3040	1014	310
Cash Flow from Operating Activities	13885	16022	17940	19450	21166	15954	10812	4026	34392	36754	43583
Cash Flow from Investing Activities	-10726	-17086	-12801	-21989	-24283	-17211	-20456	-22272	-13223	-33170	-30006
Cash Flow from Financing Activities	-3186	1182	-5196	1898	3456	1637	9398	21114	-23218	-4289	-12500
Net Cash Inflow / Outflow	-27	118	-57	-641	338	380	-246	2869	-2049	-704	1076
Closing Cash & Cash Equivalent	328	446	389	-256	82	463	171	3040	991	310	1386

Bharti Airtel Ratios

#	Mar 2013	Mar 2014	Mar 2015	Mar 2016	Mar 2017	Mar 2018	Mar 2019	Mar 2020	Mar 2021	Mar 2022	Mar 2023
Earnings Per Share (Rs)	12.09	14.87	29.74	17.53	-22.36	0.18	-4.21	-64.9	-45.02	-6.91	-0.16
CEPS(Rs)	28.28	31.16	46.78	39.11	5.13	29.58	29.86	-28.23	-5.72	36.61	46.3
DPS(Rs)	1	1.8	3.85	1.36	1	5.34	2.5	2	0	3	4
Book NAV/Share(Rs)	127.74	149.81	175.82	250.88	227.14	231.61	221.35	182.31	138.05	133.77	138.95
Core EBITDA Margin(%)	29.7	32.65	35.01	37	38.04	33.18	21.81	37.07	43.5	49.02	51.7
EBIT Margin(%)	17.88	19.46	30.75	22.88	-5.23	9.75	5.25	-72.83	-9.55	12.66	18.65
Pre Tax Margin(%)	14.23	16.78	28.21	17.01	-13.66	-1.27	-10.57	-93.93	-28.71	-6.01	1.5
PAT Margin (%)	11.24	13.22	23.79	12.9	-15.94	0.15	-3.77	-66.44	-39.17	-5.46	-0.11
Cash Profit Margin (%)	26.29	27.71	37.41	28.78	3.66	24.46	26.71	-28.9	-4.97	28.91	31
ROA(%)	5.79	6.7	10.58	4.81	-5.31	0.04	-0.89	-14.56	-9.34	-1.49	-0.03
ROE(%)	9.9	10.97	18.27	8.22	-9.36	0.08	-1.86	-36.16	-28.21	-5.08	-0.12
ROCE(%)	12.18	13.36	19.31	10.74	-2.04	3.17	1.49	-21.63	-3.46	5.06	7.86
Receivable days	17.63	16.13	18.01	19.62	18.71	25.61	30.02	25.7	19.83	15.34	10.53
Inventory Days	0.43	0.35	0.33	0.39	0.22	0.03	0.03	0.01	0.01	0	0
Payable days	0	0	0	0	0	0	0	0	0	0	0
PER(x)	21.74	19.31	11.93	18.03	0	2013.91	0	0	0	0	0
Price/Book(x)	2.06	1.92	2.02	1.26	1.39	1.55	1.35	2.37	3.68	5.65	5.39
Dividend Yield(%)	0.34	0.56	0.98	0.39	0.29	1.34	0.75	0.45	0	0.4	0.53
EV/Net Sales(x)	2.75	2.75	3.22	3.08	3.21	4.18	4.37	5.88	5.87	7.48	6.66
EV/Core EBITDA(x)	8.35	8.01	7.25	7.72	7.62	11.88	14.52	14.27	12.23	15	12.15
Net Sales Growth(%)	9.01	10.07	11.17	8.66	3.28	-13.83	-7.56	9.5	18.43	10.06	19.67
EBIT Growth(%)	-2.94	19.82	75.67	-19.13	-123.59	260.67	-50.21	-1619.23	84.47	245.9	76.25
PAT Growth(%)	-11.06	29.51	100	-41.06	-227.57	100.8	-2460.1	-1830.68	30.18	84.67	97.68
EPS Growth(%)	-11.06	23.04	100	-41.06	-227.57	100.8	-2460.76	-1441	30.64	84.65	97.72
Debt/Equity(x)	0.26	0.16	0.28	0.41	0.6	0.64	0.85	0.81	1.22	1.44	1.78
Current Ratio(x)	0.32	0.59	0.78	0.41	0.43	0.36	0.32	0.63	0.56	0.44	0.52
Quick Ratio(x)	0.32	0.59	0.77	0.41	0.43	0.36	0.32	0.63	0.56	0.44	0.52
Interest Cover(x)	4.91	7.27	12.11	3.89	-0.62	0.88	0.33	-3.45	-0.5	0.68	1.09
Total Debt/Mcap(x)	0.13	0.08	0.14	0.32	0.43	0.41	0.63	0.34	0.33	0.24	0.31

Bharti Airtel Shareholding Pattern

#	Dec 2021	Mar 2022	Jun 2022	Sep 2022	Dec 2022	Mar 2023	Jun 2023	Sep 2023	Dec 2023	Mar 2024
Promoter	55.93	55.93	55.93	55.13	55.12	55.02	54.97	54.75	54.57	53.49
FII	19.37	19.36	18.54	21.87	21.7	20.98	21.48	21.87	22.68	24.35
DII	19.48	19.5	20.22	18.89	19.13	19.91	19.66	19.81	19.62	19.31
Public	5.22	5.21	5.31	4.1	4.04	4.09	3.88	3.58	3.13	2.85
Others	0	0	0	0	0	0	0	0	0	0
Total	100	100	100	100	100	100	100	100	100	100

#	Dec 2021	Mar 2022	Jun 2022	Sep 2022	Dec 2022	Mar 2023	Jun 2023	Sep 2023	Dec 2023	Mar 2024
Promoter	329.12	329.12	329.12	328.35	328.35	328.35	328.35	328.35	328.35	323.45
FII	113.96	113.9	109.08	130.27	129.28	125.19	128.34	131.16	136.49	147.25
DII	114.65	114.76	118.98	112.51	113.96	118.78	117.47	118.81	118.05	116.8
Public	30.7	30.65	31.25	24.43	24.08	24.43	23.2	21.45	18.83	17.24
Others	0	0	0	0	0	0	0	0	0	0
Total	588.43	588.43	588.43	595.55	595.67	596.74	597.35	599.76	601.72	604.74

Pros

Cons

Company has a low return on equity of -11% over the last 3 years.
Stock is trading at 8 times its book value.

* The pros and cons are machine generated. Pros / cons are based on a checklist to highlight important points. Please exercise caution and do your own analysis.

Bharti Airtel News

IPO

Companies	Open Date	Close Date	Issue Price	Cost of 1 Lot	GMP	Expected Listing	Listing Gain(%)	Listing Price	Current Price	Type	Exchange

Companies	Open Date	Close Date	Issue Price	Cost of 1 Lot	GMP	Expected Listing	Listing Gain(%)	Listing Price	Current Price	Type	Exchange

Companies	Open Date	Close Date	Issue Price	Cost of 1 Lot	GMP	Expected Listing	Listing Gain(%)	Listing Price	Current Price	Type	Exchange

Companies	Open Date	Close Date	Issue Price	Cost of 1 Lot	GMP	Expected Listing	Listing Gain(%)	Listing Price	Current Price	Type	Exchange

Companies	Open Date	Close Date	Issue Price	Cost of 1 Lot	GMP	Expected Listing	Listing Gain(%)	Listing Price	Current Price	Type	Exchange

Bharti Airtel

Add Watchlist

Bharti Airtel Research see more...

Overview Inc. Year: 1995Industry: Telecommunication - Service Provider

Bharti Airtel Share Price

Alert Data

Quarterly Price

Peer Comparison

Bharti Airtel Quarterly Results

Bharti Airtel Profit & Loss

Growth Rates

Bharti Airtel Balance Sheet

Bharti Airtel Cash Flow

Bharti Airtel Ratios

Bharti Airtel Shareholding Pattern

Bharti Airtel News

IPO

Stocx: India's #1 Marketplace to Find Your Winning Stock

Please Login!

Error!