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 Cap12017.99 B
Enterprise Value13536.65 B
Price/Book TTM8.30
Outstanding Share5698.97 M
Float/ Outstanding Share46.85%
Dividend Yield0.760 %
Share Holding
Guru Numbers
Price/Graham No3.89
Peter Lynch Ratio10.81
Piotroski F Score7.00                  
Altman Z Score2.39                  
Sloan Ratio-0.0088
Peter Lynch Fair Value1661.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 ...
Quick Overview of Fundamental Filters