Ratnakar Securities Pvt. Ltd.

BHARTI AIRTEL LTD.

NSE : BHARTIARTLBSE : 532454ISIN CODE : INE397D01024Industry : Telecommunication - Service ProviderHouse : Bharti

BSE1599.5015.35 (+0.97 %)

PREV CLOSE ( ) 1584.15

OPEN PRICE ( ) 1582.05

BID PRICE (QTY) 0.00 (0)

OFFER PRICE (QTY) 0.00 (0)

VOLUME 93268

TODAY'S LOW / HIGH ( )1581.95 1606.00

52 WK LOW / HIGH ( )998.45 1778.95

Select year

Particulars	Mar2024	Mar2023	Mar2022	Mar2021	Mar2020
Operational & Financial Ratios
Earnings Per Share (Rs)	12.98	14.71	7.61	-27.46	-58.99
CEPS(Rs)	83.60	85.88	74.05	10.69	-11.73
DPS(Rs)	8.00	4.00	3.00	0.00	2.00
Book NAV/Share(Rs)	142.20	136.41	118.88	107.18	141.28
Tax Rate(%)	32.50	25.80	33.47	-61.65	27.12
Margin Ratios
Core EBITDA Margin(%)	51.90	51.22	49.37	45.09	40.45
EBIT Margin(%)	23.55	25.77	24.97	0.60	-37.86
Pre Tax Margin(%)	8.45	11.90	10.71	-14.40	-54.48
PAT Margin (%)	5.71	8.83	7.13	-23.28	-39.70
Cash Profit Margin (%)	32.07	35.01	35.52	5.95	-7.70
Performance Ratios
ROA(%)	2.01	3.19	2.48	-7.10	-11.21
ROE(%)	10.75	17.08	13.25	-34.46	-45.30
ROCE(%)	14.81	16.21	14.99	0.31	-16.57
Asset Turnover(x)	0.35	0.36	0.35	0.31	0.28
Sales/Fixed Asset(x)	0.29	0.31	0.29	0.27	0.24
Working Capital/Sales(x)	-1.87	-2.16	-1.88	-1.76	-1.54
Efficiency Ratios
Fixed Capital/Sales(x)	3.41	3.26	3.45	3.77	4.16
Receivable days	10.60	10.54	12.05	14.96	19.20
Inventory Days	0.76	0.83	1.00	0.77	0.53
Payable days	3120.12	3379.84	4075.29	5246.73	7137.84
Valuation Parameters
PER(x)	94.70	50.91	99.24	0.00	0.00
PCE(x)	14.70	8.72	10.20	47.48	-36.85
Price/Book(x)	8.64	5.49	6.35	4.83	3.12
Yield(%)	0.65	0.53	0.40	0.00	0.45
EV/Net Sales(x)	5.62	4.15	4.65	3.98	4.04
EV/Core EBITDA(x)	10.57	7.99	9.33	8.70	9.56
EV/EBIT(x)	23.85	16.09	18.62	664.27	-10.67
EV/CE(x)	3.60	2.37	2.72	2.12	1.76
M Cap / Sales	4.71	3.05	3.62	2.82	2.84
Growth Ratio
Net Sales Growth(%)	7.79	19.39	15.83	18.82	4.82
Core EBITDA Growth(%)	10.41	24.35	26.20	28.57	32.78
EBIT Growth(%)	-1.49	23.24	4727.36	101.88	-460.58
PAT Growth(%)	-30.35	47.95	135.46	30.33	-2092.18
EPS Growth(%)	-11.77	93.27	127.71	53.44	-5858.51
Financial Stability Ratios
Total Debt/Equity(x)	1.86	2.14	2.00	2.20	1.53
Current Ratio(x)	0.42	0.47	0.46	0.49	0.58
Quick Ratio(x)	0.42	0.47	0.45	0.49	0.58
Interest Cover(x)	1.56	1.86	1.75	0.04	-2.28
Total Debt/Mcap(x)	0.20	0.37	0.30	0.46	0.49

attention investors
kyc
ipo
ibt trading
KYC & KRA Status Awareness

Stock Brokers can accept securities as margin from clients only by way of pledge in the depository system w.e.f. September 1, 2020.

Update your mobile number & email Id with your stock broker/depository participant and receive OTP directly from depository on your email id and/or mobile number to create pledge.

Pay 20% upfront margin of the transaction value to trade in cash market segment.

Investors may please refer to the Exchange's Frequently Asked Questions (FAQs) issued vide circular reference NSE/INSP/45191 dated July 31, 2020 and NSE/INSP/45534 dated August 31, 2020 and other guidelines issued from time to time in this regard.

Check your Securities /MF/ Bonds in the consolidated account statement issued by NSDL/CDSL every month.
.......... Issued in the interest of Investors

INVESTOR CHARTER

CLOSE X

RISK DISCLOSURES ON DERIVATIVES

9 out of 10 individual traders in equity Futures and Options Segment, incurred net losses.
On an average, loss makers registered net trading loss close to ₹ 50,000.
Over and above the net trading losses incurred, loss makers expended an additional 28% of net trading losses as transaction costs.
Those making net trading profits, incurred between 15% to 50% of such profits as transaction cost.

Source: SEBI study dated January 25, 2023 on “Analysis of Profit and Loss of Individual Traders dealing in equity Futures and Options (F&O) Segment”, wherein Aggregate Level findings are based on annual Profit/Loss incurred by individual traders in equity F&O during FY 2021-22.

Ratnakar Securities

Financial Ratios

BHARTI AIRTEL LTD.

Filing complaints on SCORES Easy & quick

RISK DISCLOSURES ON DERIVATIVES