Why is Bharti Airtel Ltd ?
1
High Debt Company with a Debt to Equity ratio (avg) of 2.03 times
- High Debt Company with a Debt to Equity ratio (avg) of 2.03 times
2
Healthy long term growth as Net Sales has grown by an annual rate of 15.81% and Operating profit at 27.50%
3
The company has declared Positive results for the last 9 consecutive quarters
- ROCE(HY) Highest at 20.36%
- DEBT-EQUITY RATIO(HY) Lowest at 1.31 times
- NET SALES(Q) Highest at Rs 55,383.20 cr
4
With ROCE of 22.3, it has a Fair valuation with a 4.6 Enterprise value to Capital Employed
- The stock is trading at a discount compared to its peers' average historical valuations
- Over the past year, while the stock has generated a return of 2.06%, its profits have risen by 12.3% ; the PEG ratio of the company is 15.5
5
Rising Promoter Confidence
- Promoters have increased their stake in the company by 1.2% over the previous quarter and currently hold 50.07% of the company
- Promoters increasing their stake is a sign of high confidence in the future of the business
6
Consistent Returns over the last 3 years
- Along with generating 2.06% returns in the last 1 year, the stock has outperformed BSE500 in each of the last 3 annual periods
How much should you hold?
- Overall Portfolio exposure to Bharti Airtel should be less than 10%
- Overall Portfolio exposure to Telecom - Services should be less than 30%
(If sector exposure > 30%, please use optimiser tool to see which are the best stocks to hold in Telecom - Services)
When to exit? - We will constantly monitor the company and suggest at the appropriate time to exit from the stock
Is Bharti Airtel for you?
Low Risk, Medium Return
Absolute
Risk Adjusted
Volatility
Bharti Airtel
2.05%
0.10
19.57%
Sensex
-5.75%
-0.42
13.55%
Quality key factors
Factor
Value
Sales Growth (5y)
15.81%
EBIT Growth (5y)
27.50%
EBIT to Interest (avg)
2.06
Debt to EBITDA (avg)
2.67
Net Debt to Equity (avg)
1.02
Sales to Capital Employed (avg)
0.51
Tax Ratio
25.13%
Dividend Payout Ratio
27.66%
Pledged Shares
0
Institutional Holding
47.28%
ROCE (avg)
14.58%
ROE (avg)
15.04%
Valuation Key Factors 
Factor
Value
P/E Ratio
41
Industry P/E
41
Price to Book Value
8.16
EV to EBIT
20.42
EV to EBITDA
11.42
EV to Capital Employed
4.55
EV to Sales
6.48
PEG Ratio
15.45
Dividend Yield
NA
ROCE (Latest)
22.29%
ROE (Latest)
19.98%
Loading Valuation Snapshot...
Technical key factors
Indicator
Weekly
Monthly
MACD
Mildly Bullish
Mildly Bearish
RSI
No Signal
No Signal
Bollinger Bands
Bullish
Bullish
Moving Averages
Mildly Bearish (Daily)
KST
Mildly Bullish
Mildly Bearish
Dow Theory
No Trend
Mildly Bullish
OBV
Mildly Bearish
Bearish
Technical Movement
15What is working for the Company
ROCE(HY)
Highest at 20.36%
DEBT-EQUITY RATIO(HY)
Lowest at 1.31 times
NET SALES(Q)
Highest at Rs 55,383.20 cr
PBDIT(Q)
Highest at Rs 31,491.60 cr.
PBT LESS OI(Q)
Highest at Rs 12,326.90 cr.
CASH AND CASH EQUIVALENTS(HY)
Highest at Rs 30,376.80 cr
PAT(Q)
At Rs 10,234.92 cr has Grown at 33.3% (vs previous 4Q average
-1What is not working for the Company
NO KEY NEGATIVE TRIGGERS
Loading Valuation Snapshot...
Here's what is working for Bharti Airtel
Net Sales - Quarterly
Highest at Rs 55,383.20 cr and Grown
each quarter in the last five quartersMOJO Watch
Near term sales trend is very positive
Net Sales (Rs Cr)
Operating Profit (PBDIT) - Quarterly
Highest at Rs 31,491.60 cr. and Grown
each quarter in the last five quartersMOJO Watch
Near term Operating Profit trend is quite positive
Operating Profit (Rs Cr)
Profit Before Tax less Other Income (PBT) - Quarterly
Highest at Rs 12,326.90 cr. and Grown
each quarter in the last five quartersMOJO Watch
Near term PBT trend is very positive
PBT less Other Income (Rs Cr)
Debt-Equity Ratio - Half Yearly
Lowest at 1.31 times and Fallen
each half year in the last five half yearly periodsMOJO Watch
The company has been reducing its borrowing as compared to equity capital
Debt-Equity Ratio
Profit After Tax (PAT) - Quarterly
At Rs 10,234.92 cr has Grown at 33.3% (vs previous 4Q average)
over average PAT of the previous four quarters of Rs 7,677.38 CrMOJO Watch
Near term PAT trend is positive
PAT (Rs Cr)
Cash and Cash Equivalents - Half Yearly
Highest at Rs 30,376.80 cr
in the last six half yearly periodsMOJO Watch
Short Term liquidity is improving
Cash and Cash Equivalents
Here's what is not working for Bharti Airtel
Non Operating Income - Quarterly
Highest at Rs 878.50 cr
in the last five quartersMOJO Watch
Increased income from non business activities may not be sustainable
Non Operating Income






