Why is Bharti Airtel Ltd ?
1
High Debt Company with a Debt to Equity ratio (avg) at 2.42 times
- High Debt Company with a Debt to Equity ratio (avg) at 2.42 times
2
Reducing Promoter Confidence
- Promoters have decreased their stake in the company by -1.4% over the previous quarter and currently hold 48.87% of the company
- Promoters decreasing their stake may signify reduced confidence in the future of the business
How much should you sell?
- All quantity irrespective of whether you are making profits or losses
(If sector exposure > 30%, please use optimiser tool to see which are the best stocks to hold in Telecom - Services)
When to re-enter? - We will constantly monitor the company and review our call based on new data
Is Bharti Airtel for you?
Low Risk, Medium Return
Absolute
Risk Adjusted
Volatility
Bharti Airtel
4.05%
0.22
18.79%
Sensex
-5.47%
-0.43
12.65%
Quality key factors
Factor
Value
Sales Growth (5y)
15.61%
EBIT Growth (5y)
29.08%
EBIT to Interest (avg)
1.96
Debt to EBITDA (avg)
2.80
Net Debt to Equity (avg)
1.56
Sales to Capital Employed (avg)
0.50
Tax Ratio
17.13%
Dividend Payout Ratio
61.64%
Pledged Shares
0
Institutional Holding
48.41%
ROCE (avg)
13.45%
ROE (avg)
15.49%
Valuation Key Factors 
Factor
Value
P/E Ratio
34
Industry P/E
35
Price to Book Value
8.94
EV to EBIT
19.39
EV to EBITDA
10.74
EV to Capital Employed
4.10
EV to Sales
6.08
PEG Ratio
0.58
Dividend Yield
0.87%
ROCE (Latest)
19.64%
ROE (Latest)
26.72%
Loading Valuation Snapshot...
Technical key factors
Indicator
Weekly
Monthly
MACD
Bearish
Mildly Bearish
RSI
No Signal
No Signal
Bollinger Bands
Bearish
Bearish
Moving Averages
Bearish (Daily)
KST
Bearish
Mildly Bearish
Dow Theory
No Trend
Mildly Bearish
OBV
No Trend
Bearish
Technical Movement
20What is working for the Company
PAT(9M)
At Rs 19,547.60 cr has Grown at 27.32%
NET SALES(Latest six months)
At Rs 106,127.00 cr has Grown at 22.54%
ROCE(HY)
Highest at 19.46%
DEBT-EQUITY RATIO(HY)
Lowest at 1.77 times
PBDIT(Q)
Highest at Rs 30,782.80 cr.
PBT LESS OI(Q)
Highest at Rs 11,855.80 cr.
CASH AND CASH EQUIVALENTS(HY)
Highest at Rs 18,983.90 cr
OPERATING PROFIT TO NET SALES(Q)
Highest at 57.02%
-3What is not working for the Company
PAT(Q)
At Rs 6,808.00 cr has Fallen at -13.5% (vs previous 4Q average
DEBTORS TURNOVER RATIO(HY)
Lowest at 21.84 times
Loading Valuation Snapshot...
Here's what is working for Bharti Airtel
Net Sales - Quarterly
Highest at Rs 53,981.60 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 30,782.80 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 11,855.80 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.77 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
Operating Profit Margin - Quarterly
Highest at 57.02%
in the last five quartersMOJO Watch
Company's efficiency has improved
Operating Profit to Sales
Cash and Cash Equivalents - Half Yearly
Highest at Rs 18,983.90 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
Profit After Tax (PAT) - Quarterly
At Rs 6,808.00 cr has Fallen at -13.5% (vs previous 4Q average)
over average PAT of the previous four quarters of Rs 7,868.85 CrMOJO Watch
Near term PAT trend is very negative
PAT (Rs Cr)
Debtors Turnover Ratio- Half Yearly
Lowest at 21.84 times
in the last five half yearly periodsMOJO Watch
Company's pace of settling its Debtors has slowed
Debtors Turnover Ratio






