Bharti Airtel's intrinsic value using Intellectual Capital analysis

Bharti Airtel

BSE : 532454

|

NSE : BHARTIARTL

Industry : Telecom

|

ISIN : INE397D01024

|

FreeFloat : 43.94%

|

FnO : Yes

|

LotSize : 950

BSE SENSEX | BSE SENSEX 50 | Nifty 50 | Nifty50 Equal Weight | BSE 100 | BSE 100 Largecap TMC | BSE 200 | BSE 250 LargeMidcap | BSE Largecap | BSE LargeMidcap | Nifty 100 | Nifty 200 | Nifty LargeMidcap 250 | Nifty100 Equal Weight | Nifty100 Liquid 15 | Nifty Alpha Low Volatility 30 | BSE Telecom | BSE Dividend Stability | Nifty100 Alpha 30 | Nifty200 Momentum 30 | BSE 100 ESG | BSE CARBONEX | NIFTY 100 ESG Sector Leaders | Nifty100 Enhanced ESG | Nifty100 ESG | BSE TECk | Nifty India Consumption | Nifty India Digital | Nifty Infrastructure | Nifty Non-Cyclical Consumer | Nifty Services Sector

Intellectual Capital (IC)	260,427.00
Net Worth (NW)	102,199.80
Intrinsic Worth (IW)	362,626.80
Market Cap (MC)	480,170.30
Economic Value Added	-4,492.83

Discount Rate	%
Liquidity Premium	%

Knowledge Basis (IC/IW)	71.82%
IC Gross Margin (EBITDA/IC)	23.65%
IC Net Margin (NPT/IC)	2.40%
Knowledge Turnover (Sales/IC)	0.48
Market to Intrinsic Value (MC/IW)	1.32

As Of	Intrinsic Value	Market Price
31 Dec 2022	Rs. 608.77	Rs. 806.10
20 Mar 2023	----	Rs. 754.80
20 Mar 2023	----	-2.45 -0.32%

Fundamental - medium term		Technical - near term		Combined outlook
EVA > 0 : No	Sell	10 DMA : Rs. 763.21	Sell	Strong Sell
KB > 50% : Yes		50 DMA : Rs. 770.48
0 < M2IV < 1 : No		Vol-Price trend : Falling
Disclaimer: Stock outlook is based on data calculations only and does NOT constitute investment advice.

Question 3 - Is this stock undervalued?

Question 2 - Does this business have significant knowledge assets?

Question 1 - Is this business generating enough profits to cover its cost of capital?

* EVA is a registered trademark of Stern Stewart and Co.

Quarterly Results (Rs. Cr)

Quarter

Type*

Sales

Income

EBITDA

EBIT

PBT

PAT

NPT

Mar-20
C
23722.70
23822.10
4174.70
-2880.30
-7010.50
-4977.00
-5416.80

Jun-20
C
23938.70
24419.20
-690.70
-7917.50
-11373.70
-15191.20
-15328.40

Sep-20
C
25785.00
25933.90
11699.30
4278.20
517.80
-33.90
-172.20

Dec-20
C
26517.80
26567.00
7321.70
-181.40
-4153.30
1350.10
595.20

Mar-21
C
25747.30
25831.20
13383.60
5881.70
2021.10
1511.00
896.60

Jun-21
C
26853.60
27063.40
13715.30
6001.60
1775.90
941.40
1204.60

Sep-21
C
28326.40
28435.20
14518.10
6270.90
2306.80
1998.10
2160.40

Dec-21
C
29866.60
30063.70
15555.80
7008.60
2641.50
1650.70
1618.30

Mar-22
C
31500.30
31518.90
16772.50
8189.90
4130.60
3715.00
3577.40

Jun-22
C
32804.60
32996.80
16884.40
8103.00
3592.10
2468.80
1618.40

Sep-22
C
34526.80
34728.70
18152.40
9205.60
4265.30
2978.90
2611.60

Dec-22
C
35804.40
36062.00
18342.40
9044.70
4359.10
2613.70
2240.70

* C - Consolidated, S - Standalone