BHARTIARTL Analysis

Stock Data

Balance Sheet Analysis

Detailed yearly balance sheet data for BHARTIARTL in the Telecomm-Service sector.

	Mar 2013	Mar 2014	Mar 2015	Mar 2016	Mar 2017	Mar 2018	Mar 2019	Mar 2020	Mar 2021	Mar 2022	Mar 2023	Mar 2024	Sep 2024
Equity Capital	1,899	1,999	1,999	1,999	1,999	1,999	1,999	2,728	2,746	2,795	2,837	2,877	2,896
Reserves	48,423	57,757	37,778	64,771	65,458	67,536	69,424	74,417	56,207	63,759	74,726	79,142	84,202
Borrowings	66,736	75,896	83,415	100,646	107,288	111,334	125,428	148,228	162,785	169,678	226,020	215,592	225,541
Other Liabilities	40,912	45,840	58,747	57,056	57,578	68,653	77,176	133,718	122,679	124,975	140,974	144,408	148,344
Total Liabilities	157,970	181,492	181,939	224,472	232,322	249,521	274,026	359,091	344,417	361,207	444,557	442,019	460,982
Fixed Assets	125,674	140,614	124,279	172,293	178,235	187,200	200,832	229,256	223,480	244,083	277,394	303,303	330,199
CWIP	2,992	-0	17,415	5,702	10,838	9,751	9,634	4,282	5,726	5,955	49,425	16,904	8,753
Investments	7,710	15,531	10,752	11,977	14,339	16,159	15,711	25,476	27,550	29,349	32,954	31,602	34,438
Other Assets	21,594	25,347	29,494	34,500	28,910	36,411	47,850	100,077	87,661	81,820	84,784	90,210	87,592
Total Assets	157,970	181,492	181,939	224,472	232,322	249,521	274,026	359,091	344,417	361,207	444,557	442,019	460,982

Detailed yearly cash flow data for BHARTIARTL in the Telecomm-Service sector.

	Mar 2013	Mar 2014	Mar 2015	Mar 2016	Mar 2017	Mar 2018	Mar 2019	Mar 2020	Mar 2021	Mar 2022	Mar 2023	Mar 2024
Cash from Operating Activity	22,608	26,233	28,059	27,942	28,280	29,854	20,070	18,129	48,205	55,017	65,325	78,898
Cash from Investing Activity	-18,676	-25,181	-22,301	-14,091	-30,680	-27,940	-28,286	-29,598	-27,286	-41,478	-39,232	-51,089
Cash from Financing Activity	-4,566	2,774	-9,672	-11,946	-351	1,920	9,464	19,144	-24,910	-15,203	-24,470	-27,778
Net Cash Flow	-634	3,826	-3,914	1,905	-2,752	3,835	1,248	7,675	-3,991	-1,664	1,623	31

Yearly operational and efficiency metrics for BHARTIARTL in the Telecomm-Service sector.

	Mar 2013	Mar 2014	Mar 2015	Mar 2016	Mar 2017	Mar 2018	Mar 2019	Mar 2020	Mar 2021	Mar 2022	Mar 2023	Mar 2024
Debtor Days	32	27	20	21	18	26	19	19	13	13	10	12
Inventory Days
Days Payable
Cash Conversion Cycle	32	27	20	21	18	26	19	19	13	13	10	12
Working Capital Days	-98	-105	-172	-139	-150	-200	-189	-257	-172	-154	-155	-161
ROCE %	7%	10%	11%	13%	10%	7%	3%	5%	7%	11%	12%	13%

List of Companies that are in the same sector as the BHARTIARTL stock which is the Telecomm-Service sector

Name	CMP Rs.	P/E	Mar Cap Rs.Cr.	Div Yld %	NP Qtr Rs.Cr.	Qtr Profit Var %	Sales Qtr Rs.Cr.	Qtr Sales Var %	ROCE %
Bharti Airtel	1715.55	51.42	1.0282e+06	0.47	16134.6	230.71	45129.3	19.08	13.13
Bharti Hexacom	1432.5	68.18	71625	0.28	260.9	52.19	2250.7	25	13.98
Vodafone Idea	7.09		50617.7	0	-6609.3	14.62	11117.3	4.16	-3.61
Tata Comm	1547.35	39.61	44099.5	1.08	236.08	893.33	5798.07	3.76	17.55
Tata Tele Mah	55.1		10771.6	0	-315.11	-2.41	332.77	12.41	47.91
Railtel Corpn	284.9	32.75	9143.54	1	65.05	-3.79	767.62	14.85	20.25
Nazara Technolo	969.55	118.88	8494.83	0	13.68	-46.04	534.69	66.88	5.53

Detailed yearly financial data for BHARTIARTL in the Telecomm-Service sector.

	Mar 2013	Mar 2014	Mar 2015	Mar 2016	Mar 2017	Mar 2018	Mar 2019	Mar 2020	Mar 2021	Mar 2022	Mar 2023	Mar 2024	TTM
Sales	76,947	85,864	96,101	96,532	95,468	82,639	80,780	87,539	100,616	116,547	139,145	149,982	162,708
Expenses	53,987	59,352	62,499	62,548	60,138	52,560	55,016	50,930	55,337	59,013	67,871	71,691	77,193
Operating Profit	22,960	26,512	33,602	33,984	35,330	30,079	25,764	36,610	45,279	57,534	71,274	78,292	85,515
OPM %	30%	31%	35%	35%	37%	36%	32%	42%	45%	49%	51%	52%	53%
Other Income	1,159	2,881	1,243	4,858	1,713	1,756	4,474	-37,775	-4,215	4,656	1,019	-3,428	10,852
Exceptional items	298	424	272	2,072	-1,302	-807	2,739	-40,362	-4,858	1,699	-670	-7,572
Other income normal	861	2,457	971	2,786	3,015	2,564	1,735	2,587	643	2,958	1,689	4,145
Interest	4,519	5,879	4,446	8,546	9,547	9,326	10,622	13,992	15,091	16,616	19,300	22,648	21,455
Depreciation	14,815	15,650	19,858	17,450	19,773	19,243	21,348	27,690	29,404	33,091	36,432	39,538	43,320
Profit before tax	4,785	7,864	10,540	12,846	7,723	3,267	-1,732	-42,846	-3,432	12,483	16,561	12,679	31,593
Tax %	53%	62%	52%	46%	45%	33%	-197%	-28%	260%	33%	26%	32%
Net Profit	2,267	3,019	5,048	6,893	4,241	2,184	1,688	-30,664	-12,364	8,305	12,287	8,558	27,074
EPS in Rs	4.32	5.04	8.41	11.05	6.91	2.00	0.74	-55.06	-25.63	7.23	14.97	13.20	43.23
Dividend Payout %	17%	26%	33%	9%	11%	194%	244%	-3%	-0%	39%	27%	62%

Detailed quarterly financial data for BHARTIARTL in the Telecomm-Service sector.

	Dec 2021	Mar 2022	Jun 2022	Sep 2022	Dec 2022	Mar 2023	Jun 2023	Sep 2023	Dec 2023	Mar 2024	Jun 2024	Sep 2024	Dec 2024
Sales	29,867	31,500	32,805	34,527	35,804	36,009	37,440	37,044	37,900	37,599	38,506	41,473	45,129
Expenses	15,164	15,460	16,275	16,933	17,720	17,312	17,842	17,530	18,085	18,234	18,799	19,627	20,533
Operating Profit	14,703	16,040	16,529	17,594	18,085	18,697	19,598	19,514	19,815	19,365	19,708	21,846	24,597
OPM %	49%	51%	50%	51%	51%	52%	52%	53%	52%	52%	51%	53%	54%
Other Income	853	1,638	355	559	-412	886	-2,478	-654	1,013	-1,308	2,010	475	9,675
Interest	4,367	4,059	4,511	4,940	4,686	5,163	5,614	5,186	6,645	5,203	5,152	5,424	5,676
Depreciation	8,547	8,583	8,781	8,947	9,298	9,406	9,654	9,734	10,074	10,075	10,540	11,000	11,704
Profit before tax	2,642	5,037	3,592	4,265	3,689	5,014	1,853	3,940	4,108	2,778	6,025	5,897	16,892
Tax %	38%	26%	31%	30%	29%	16%	18%	47%	30%	26%	22%	30%	4%
Net Profit	1,651	3,715	2,469	2,979	2,614	4,226	1,520	2,093	2,876	2,068	4,718	4,153	16,135
EPS in Rs	1.41	3.41	2.73	3.86	2.85	5.39	2.89	2.39	4.34	3.66	7.31	6.31	25.95

Shareholding pattern trends for BHARTIARTL in the Telecomm-Service sector.

	Mar 2022	Jun 2022	Sep 2022	Dec 2022	Mar 2023	Jun 2023	Sep 2023	Dec 2023	Mar 2024	Jun 2024	Sep 2024	Dec 2024
Promoters	55.93%	55.93%	55.14%	55.12%	55.02%	54.97%	54.75%	54.57%	53.48%	53.17%	53.14%	53.12%
FIIs	19.36%	18.54%	21.87%	21.70%	20.97%	21.48%	21.87%	22.69%	24.35%	24.62%	25.07%	24.27%
DIIs	19.50%	20.22%	18.76%	19.02%	19.78%	19.55%	19.69%	19.51%	19.20%	19.13%	18.69%	19.52%
Government	0.00%	0.00%	0.12%	0.12%	0.12%	0.12%	0.12%	0.12%	0.12%	0.12%	0.12%	0.12%
Public	5.16%	5.26%	4.06%	4.00%	4.05%	3.82%	3.53%	3.07%	2.80%	2.89%	2.89%	2.91%
Others	0.05%	0.05%	0.04%	0.05%	0.05%	0.05%	0.04%	0.06%	0.05%	0.06%	0.07%	0.07%
No of Shareholders	7,67,578	7,86,169	7,79,996	7,54,961	7,58,715	7,09,952	6,85,529	6,77,690	6,94,297	7,62,266	7,84,930	8,36,095

Yearly shareholding pattern trends for BHARTIARTL in the Telecomm-Service sector.

	Mar 2017	Mar 2018	Mar 2019	Mar 2020	Mar 2021	Mar 2022	Mar 2023	Mar 2024	Dec 2024
Promoters	67.14%	67.14%	67.14%	58.98%	55.86%	55.93%	55.02%	53.48%	53.12%
FIIs	15.22%	18.45%	17.61%	20.29%	18.57%	19.36%	20.97%	24.35%	24.27%
DIIs	11.15%	12.38%	13.25%	15.83%	20.35%	19.50%	19.78%	19.20%	19.52%
Government	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.12%	0.12%	0.12%
Public	6.46%	1.99%	2.00%	4.87%	5.16%	5.16%	4.05%	2.80%	2.91%
Others	0.03%	0.04%	0.00%	0.04%	0.06%	0.05%	0.05%	0.05%	0.07%
No of Shareholders	2,12,238	1,93,663	1,86,238	2,30,528	7,13,866	7,67,578	7,58,715	6,94,297	8,36,095