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.3 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.36%, its profits have risen by 12.3% ; the PEG ratio of the company is 7.5
5
High Institutional Holdings at 48.45%
- These investors have better capability and resources to analyse fundamentals of companies than most retail investors.
6
Consistent Returns over the last 3 years
- Along with generating 2.36% 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.35%
0.12
19.43%
Sensex
-6.4%
-0.50
12.94%
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
61.64%
Pledged Shares
0
Institutional Holding
48.45%
ROCE (avg)
14.58%
ROE (avg)
15.04%
Valuation Key Factors 
Factor
Value
P/E Ratio
38
Industry P/E
39
Price to Book Value
7.65
EV to EBIT
19.29
EV to EBITDA
10.79
EV to Capital Employed
4.30
EV to Sales
6.12
PEG Ratio
7.49
Dividend Yield
0.80%
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
Bearish
Mildly Bullish
Moving Averages
Mildly Bearish (Daily)
KST
Mildly Bullish
Mildly Bearish
Dow Theory
Mildly Bullish
Mildly Bearish
OBV
Mildly Bearish
Mildly Bullish
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






