| | Price Trend | Performance | Ratios | Snapshot

Bharti Airtel | 62.56% [Reasonable Score] |Shares Pledge: [0.55%]

Is the company worth investing in (now)?: I'll Wait Longer To Build Better Margin of Safety [Price is nearly undervalued But Fundamentals must Improve]

1,997.25

31.65 | 1.61%

Price

Technology - Telecom Services - Diversified

1,794.11

Overvalued

Intrinsic Value

Top | Performance | Ratios | Snapshot

Price Trend

-1%
Price 14 Day

Past → Today

-5%
Price 30 Day

Past → Today

-3%
Price 90 Day

Past → Today

Overview
How is the Stock? Price: Reasonably Valued & Fundamentally Average
Overall Score (Remark) 62.56% [Reasonable Score] |Shares Pledge: [0.55%]
Is It A Fundamentally Strong Company? Fundamentally Average
Fundamental Strength Score [out of 5] 2.78
Overview
21.01%
Last 10Y Price Trend

Past → Today

1.86%
P/E

Past → Today

Quick Observations #1
  1. The operating revenue has grown consistently in the last 5 years
  2. Positive @14.11% p.a. in the last 5 years
  3. Reasonably consistent in the last 5 years
  4. Maintained a positive EBITDA Margin of 51.06% in the last 5 years
  5. EBITDA Margin has improved in the last 5 years @7.41% p.a.
Quick Observations #2
  1. Reasonably consistent in the last 5 years
  2. Maintained a positive PAT Margin of 6.63% in the last 5 years
  3. PAT Margin has fallen in the last 5 years @-210.08% p.a.
  4. Reasonably consistent in the last 5 years
  5. Maintained a positive ROE of 10.78% in the last 5 years
  6. ROE has fallen in the last 5 years @-210.25% p.a.
Quick Observations #3
  1. Total asset has grown at 8.25% p.a. in the last 5 Years
  2. The company has not been consistently solvent in the last 5 years
  3. The company has reduced it's D/E ratio in the last 5 years
  4. Maintained an average D/E ratio of 1.83 in the last 5 years
Quick Observations #4
  1. Not been consistently liquid in the last 5 years
  2. Impaired in the last 5 years
  3. Maintained an average current ratio of 0.44 in the last 5 years
  4. Consistently Positive
Price Valuation
Is It An Undervalued Stock? Reasonably Valued
Price Valuation Score [out of 5] 4.65
Price ₹1,997.25
Intrinsic Value ₹1,794.11
P/E 31.05
EV/EBITDA 11.62
P/FCF 168.06
Current Price vs. Intrinsic Value (IV)
Current Price

₹1,997.25

Intrinsic Value

₹1,794.1106

Overvalued

Sample Data. Subscribe to view actual data.
Share Holding Pattern
Profitability
Is It A Profitable Company? Reasonably Profitable
Profitability Score [out of 5] 3.12
WAAC 10.18%
ROCE-5Y 12.24%
Free Cash Flow Positive
Operating Profit 62,472.00
Net Profit 38,540.00
Profitability
Growth
Is It A Growing Company? Growth Rate Is Above Average
Growth Score [out of 5] 3.68
Reserves Growth 14.00%
Total Asset Growth 8.00%
Operating Revenue Growth 14.00%
Net Profit Growth 0.00%
Operating Cash Flow Growth 15.00%
FCF Growth (5Y) 11.00%
Sustainable Growth 9.00%
-288.09%
EPS

Past → Today

Financial Health
Is The Company Financially Healthy? Financial Health Is Average
Financial Health Score [out of 5] 2.46
Is the company liquid? No. Not Liquid Enough
Is the ROE growing? No. The Trend is Falling
Is the ROE high? Yes. Its High
Company is reducing debt? Yes. D/E Ratio is Decreasing
Company's D/E ratio is low? No. D/E Ratio is High
Is the ROCE growing? No. It is Falling
Is the ROCE High? Yes. It is Moderately High
Financial Health
Quality of Management
How Is The Quality Of The Management? Management Quality Is Average
Management Quality Score [out of 5] 2.07
Operating profit is Growing? Yes. The Operating Profit has grown
Operating profit Consistently Growing? Yes. The Operating Profit has Consistently Grown
EPS is Growing? Yes. The EPS has grown
EPS Consistently Growing? No. The EPS Growth in not Consistent
Capital Utilization is Proper? No. Capital Use is Not Proper
Reinvested Capital Meets The Purpose? Yes. It is Excellent
Is It Overpaying The Dividends? Yes. It can Comfortably Afford
Operating Profit Margin
Competitive Moat
Does The Company Has Competitive Moat? Moat Is Average
Moat Score [out of 5] 2.49
Competitors
NameM.Cap (₹ Cr.)Revenue (₹ Cr.)PAT (₹ Cr.)TTM EPSTTM P/EP/BROEOverall Score (%)
RailTel Corporation India10,735.393,551.04299.819.9933.535.370.00Subscribe to view
Vodafone Idea123,619.3644,183.20-27,442.10-3.10-3.68-1.7737.09Subscribe to view
Bharti Airtel1,196,778.36174,558.9033,778.3066.5430.0210.5333.90Subscribe to view
Tata Communications44,973.0023,238.891,583.1562.4125.2214.8958.82Subscribe to view
Bharti Hexacom81,752.978,729.701,493.6030.8453.0013.780.00Subscribe to view
Theme Ranks
Theme Rank Total Stocks Theme Rank Total Stocks
Best Stocks 275 1,347 Fast Growing Stocks 188 1,356
Profitable Stocks 361 1,339 Dividend Paying Stocks 232 364
Blue-Chip Stocks 0 99 Low PE Stocks 0 145
Debt Free Stocks 0 855 Buffet Type Stocks 489 1,355
Fundamentally Strong Stocks 369 1,356 High Return Stocks 199 1,367
Undervalued Stocks 89 1,342 Penny Stocks 0 253
Profitable & Growing Stocks 0 125
Price Summary
Today's High Today's Low 52W High 52W Low
2,040.0 1,981.0 2,174.7 1,561.0
Recent Results
Market Cap (Cr) Revenue (Cr) Net Profit (Cr) Net Worth (Cr)
1,196,778.36 174,558.90 33,778.30 113,671.90
D/E Current Ratio ROE (%) ROCE (%)
1.30 0.37 33.90 19.36
Valuation & Growth
P/E P/B Div.Yield (%) PEG (%)
31.05 10.53 0.80 0.34
EPSG-3Y (%) EPSG-3Y (%) 3M-Return (%) 1Y-Return (%)
79.53 -288.09 -5.35 20.27
About Company

Bharti Airtel Limited is a leading global telecommunications company with operations in 17 countries across Asia and Africa. Headquartered in New Delhi India Bharti Airtel ranks amongst the top 3 mobile service providers globally in terms of subscribers. The company offers an integrated suite of telecom solutions to its enterprise customers in addition to providing long distance connectivity both nationally and internationally. The Company also offers Digital TV and IPTV Services. All these services are rendered under a unified brand 'airtel' either directly or through subsidiary companies.The company operates in four strategic business units namely Mobile Telemedia Enterprise and Digital TV. The mobile business offers services in India Sri Lanka and Bangladesh. The Telemedia business provides broadband IPTV and telephone services in 95 Indian cities.

Top | Price Trend | Ratios | Snapshot

Performance Summary

10.8%

Net Sales

Past → Today

10.95%

Total Income

Past → Today

19.03%

Operating Profit

Past → Today

45.64%

PAT

Past → Today

11.3%

Net Worth

Past → Today

52.76%

EPS

Past → Today

-1%

Last 14D Price Trend

Past → Today

-5%

Last 30D Price Trend

Past → Today

-3%

Last 90D Price Trend

Past → Today

4%

Last 180D Price Trend

Past → Today

20%

Last 1Y Price Trend

Past → Today

37.5%

Last 3Y Price Trend

Past → Today

28.95%

Last 5Y Price Trend

Past → Today

0%

EV/EBIDTA

Past → Today

Top | Price Trend | Performance | Snapshot

Ratios

Liquidity Ratios
IndicatorUnitTTMMar 25Mar 24Mar 23Mar 22Mar 21
Current Ratio-0.370.370.420.470.460.49
Quick Ratio-0.370.370.420.470.450.49
Cash Ratio-0.090.090.120.110.120.12
Solvency Ratios
IndicatorUnitTTMMar 25Mar 24Mar 23Mar 22Mar 21
Current Debt to Inventory-399.47399.47381.06473.46304.07419.68
Current Debt to Equity-1.301.301.501.822.002.20
D / E-1.301.301.501.822.002.20
Interest Coverage Ratio-3.012.591.441.821.610.78
Efficiency Ratios
IndicatorUnitTTMMar 25Mar 24Mar 23Mar 22Mar 21
Fixed Asset Turnover Ratio-0.560.500.510.470.540.51
Gross Margin%100.00100.00100.00100.00100.00100.00
Operating Margin%32.1031.7220.7924.5622.4311.04
EBITDA Margin%58.1058.4447.6551.0751.0540.65
PAT Margin%19.5819.353.868.235.02-12.12
Op.Cash Flow Margin%50.5356.8452.6046.9547.2147.91
ROA%7.496.571.322.581.62-3.55
ROE%33.9029.725.7912.708.84-20.82
ROCE%19.3616.9110.6610.8110.695.01
ROIC%7.186.820.661.930.97-3.81
Price Valuation Ratios
IndicatorUnitTTMMar 25Mar 24Mar 23Mar 22Mar 21
P/E-29.2529.84115.7266.71135.94-25.78
PEG-0.330.06-4.320.58-0.49-25.78
EV/EBITDA-11.358.316.5510.258.247.43
Price to Sales-5.794.142.254.173.201.88
P/B-9.926.303.346.405.613.22
Dividend Yield%0.400.650.680.290.000.66
P/FCF-91.0257.80-1,275.5727.2376.48108.57
FCF/Sales-0.050.05-1.700.040.150.25
Earnings Yield%4.986.666.904.795.413.84
Top | Price Trend | Performance | Ratios

Snapshot

Quarterly Report
IndicatorUnitTTMSep '25Jun '25Mar '25Dec '24Sep '24
SalesRs. Cr.194,612.0052,145.0049,462.0047,876.0045,129.0041,473.00
Other IncomeRs. Cr.2,189.00727.00508.00485.00469.00254.00
Op. ProfitRs. Cr.59,326.0016,379.0015,373.0014,682.0012,892.0010,846.00
EBITDARs. Cr.114,338.00102,019.7072,154.9071,540.3059,766.8041,156.70
PBTRs. Cr.47,420.0012,241.0010,421.009,526.0015,232.004,823.00
PATRs. Cr.38,540.006,791.005,947.0011,021.0014,781.003,593.00
EPSRs. Cr.66.5411.7210.2619.0225.546.21
Profit & Loss Account
IndicatorUnitTTMMar 25Mar 24Mar 23Mar 22Mar 21
IncomeRs. Cr.196,801.00174,558.90151,417.80140,081.40117,081.20101,258.60
ExpenseRs. Cr.147,150.20147,150.20133,875.90123,603.00108,719.9099,739.50
Op.ProfitRs. Cr.62,472.0054,875.7031,181.9034,171.9026,141.8011,109.50
EBITDARs. Cr.114,338.00102,019.7072,154.9071,540.3059,766.8041,156.70
PBTRs. Cr.47,420.0012,241.0010,421.009,526.0015,232.004,823.00
PATRs. Cr.38,540.006,791.005,947.0011,021.0014,781.003,593.00
EPSRs. Cr.66.5411.7210.2619.0225.546.21
DividendRs. Cr.4,630.304,630.302,275.201,697.600.001,241.90
Balance Sheet
IndicatorUnitTTMMar 25Mar 24Mar 23Mar 22Mar 21
Share CapitalRs. Cr.2,900.102,900.102,876.602,836.602,795.002,746.00
ReservesRs. Cr.110,771.80110,771.8097,870.4087,783.4063,759.3056,206.70
Net WorthRs. Cr.113,671.90113,671.90100,747.0090,620.0066,554.3058,952.70
ST BorrowingsRs. Cr.43,448.5043,448.5020,953.9013,976.2019,379.5019,229.60
LT BorrowingsRs. Cr.104,863.80104,863.80130,962.60151,568.60113,535.00110,560.30
Fixed AssetsRs. Cr.347,769.70347,769.70293,705.50293,045.10216,206.70196,299.70
Current LiabilitiesRs. Cr.180,440.20180,440.20138,667.80121,963.80114,026.00111,635.90
CashRs. Cr.16,719.9016,719.9016,339.9013,418.6013,494.3013,466.10
Current AssetsRs. Cr.67,588.8067,588.8058,276.1057,501.3052,027.9054,752.90
Total AssetsRs. Cr.514,360.40514,360.40444,531.00446,633.20363,656.00346,027.80
Cash Flow Report
IndicatorUnitTTMMar 25Mar 24Mar 23Mar 22Mar 21
Net Cash From Oprn.Rs. Cr.98,332.2098,332.2078,898.2065,324.6055,016.6048,205.00
Net Cash From InvestingRs. Cr.-60,269.80-60,269.80-50,203.90-39,080.20-41,869.60-26,888.40
Net Cash From FinancingRs. Cr.-36,533.20-36,533.20-27,778.50-24,469.50-15,203.20-24,910.30