Free Access to TSR Screeners - Sign Up for Your Weekend Pass
Fundamental Analysis of Bharti Airtel Ltd. - Growth / Value Index
BHARTIARTL - Valuation Highlights
Valuation Analysis
Tsr Value Index - Good Score of 68.06
Undervalued - Price to Intrinsic Value of 0.722
Book Value in last 3 years is trending up
Price to Book Ratio of 8.30 suggesting that it is very expensive
Valuation Key Ratios
| Ratio | TTM | Latest FY | Yoy Change | MRQ | Screener/ About |
|---|---|---|---|---|---|
| Price to Earning | 31.73 | 29.89 | -68.16 % | ||
| Price to Book | 8.30 | 8.82 | 27.09 % | 7.63 | |
| Price to Sales | 6.28 | 5.80 | 24.07 % | ||
| Enterprise Value to EBITDA Multiple | 11.32 | -3.48 % |
BHARTIARTL - Profitability Highlights
Profitability Analysis
Tsr Profitability Index - Good Score of 70.62
Piotroski F Score - Good Value of 7.0
Excellent QoQ /QoQ FY EPS growth
Company Earning excess return
During the past twelve months, the company has given a strong Return On Equity of 35.57%
All key Trailing Twelve Months Margin growing by 15 %
Annual Net Profit in last 3 years is trending up
EBITDA is continuously increasing for last 3 Years
Good Return On Capital Employed of 12.89
Good Net Margin of 19.80% is achieved by the company
Very Low Dividend Yield of 0.770 %
Low Earning Yield of 3.15 %
Profitability Key Ratios
| Ratio | TTM | Latest FY | Yoy Change | MRQ | Screener/ About |
|---|---|---|---|---|---|
| Return On Equity | 35.57 | 29.52 | 299.12 % | 5.77 | |
| Return On Asset | 7.66 | 6.52 | 288.38 % | 1.30 | |
| Net Profit Margin | 19.80 | 19.40 | 289.63 % | 13.02 | |
| Operating Profit Margin | 63.89 | 14.93 | 39.07 % | 56.69 | |
| EBITDA Margin | 58.75 | 58.98 | 22.59 % | 54.68 |
Highlights
| Market Cap | 12017.99 B |
| Enterprise Value | 13536.65 B |
| Price/Book TTM | 8.30 |
| Outstanding Share | 5698.97 M |
| Float/ Outstanding Share | 46.85% |
| Dividend Yield | 0.760 % |
Share Holding
Guru Numbers
| Price/Graham No | 3.89 |
| Peter Lynch Ratio | 10.81 |
| Piotroski F Score | 7.00 |
| Altman Z Score | 2.39 |
| Sloan Ratio | -0.0088 |
| Peter Lynch Fair Value | 1661.46 |
BHARTIARTL - Growth Highlights
Growth Analysis
Short term positive trend in total sale and net profit
YoY Net Margin Jump by 289.63%
Annual sales of the company is increased for three years in a row
Quarterly sales in last 5 years is trending up
Steady increase in Total Assets for last 3 Years
Growth Key Fields
| Field | TTM | YoY Growth | QoQ Growth |
|---|---|---|---|
| Revenue | 194613 (Cr) | 15.34 % | 5.42 % |
| Gross Profit | 121406 (Cr) | 113.29 % | 37.49 % |
| EBITDA | 114343 (Cr) | 41.39 % | 5.77 % |
| Net Profit | 38542.60 (Cr) | 349.39 % | 14.19 % |
| EPS | 66.46 | 343.09 % | NA |
BHARTIARTL - Stability Highlights
Stability Analysis
Debt to equity ratio has decreased and is lowest in last five years
Decreasing debt with Increasing revenue
Stability Key Ratios
| Ratio | Latest FY | Yoy Change | MRQ | Screener/ About |
|---|---|---|---|---|
| Debt to Equity Ratio | 1.39 | -13.22 % | 1.26 | |
| Cash Ratio | 0.093 | -21.36 % | ||
| Quick Ratio | 0.372 | -10.91 % | 0.411 | |
| Shareholders Equity | 22.10 | -2.69 % | ||
| Debt to EBITDA | 1.55 | -30.89 % |
Historical Valuation Ratios of Bharti Airtel Ltd.
Historical Valuation Ratios
Loading ...
Historical Profitability Ratios of Bharti Airtel Ltd.
Historical Profitability Ratios
Loading ...
Historical Efficiency Ratios of Bharti Airtel Ltd.
Historical Efficiency Ratios
Loading ...
Historical Solvency Ratios of Bharti Airtel Ltd.
Historical Solvency Ratios
Loading ...
Birds's Eye
Technicals
MovingAverage
Candlestick
PivotPoint
Fin Statements
Beta&Vols
Tech Charts
Future/Option