| | Price Trend | Performance | Ratios | Snapshot

Bharti Airtel | 60.5% [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.15

19.45 | 0.98%

Price

Technology - Telecom Services - Diversified

1,795.00

Overvalued

Intrinsic Value

Top | Performance | Ratios | Snapshot

Price Trend

-2%
Price 14 Day

Past → Today

0%
Price 30 Day

Past → Today

-8%
Price 90 Day

Past → Today

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

Past → Today

4.32%
P/E

Past → Today

Quick Observations #1
  1. The operating revenue has grown consistently in the last 5 years
  2. Positive @15.13% p.a. in the last 5 years
  3. Not been 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 @5.8% p.a.
Quick Observations #2
  1. Not been 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 @-204.03% p.a.
  4. Not been 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 @-205.14% 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.11
Price ₹1,997.15
Intrinsic Value ₹1,795.00
P/E 39.38
EV/EBITDA 11.98
P/FCF 168.05
Current Price vs. Intrinsic Value (IV)
Current Price

₹1,997.15

Intrinsic Value

₹1,795.0009

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.01
WAAC 10.18%
ROCE-5Y 11.98%
Free Cash Flow Positive
Operating Profit 57,077.00
Net Profit 30,389.00
Profitability
Growth
Is It A Growing Company? Growth Rate Is Above Average
Growth Score [out of 5] 3.67
Reserves Growth 14.00%
Total Asset Growth 8.00%
Operating Revenue Growth 15.00%
Net Profit Growth 0.00%
Operating Cash Flow Growth 15.00%
FCF Growth (5Y) 11.00%
Sustainable Growth 9.00%
-273.74%
EPS

Past → Today

Financial Health
Is The Company Financially Healthy? Financial Health Is Weak
Financial Health Score [out of 5] 2.43
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.05
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.66
Competitors
NameM.Cap (₹ Cr.)Revenue (₹ Cr.)PAT (₹ Cr.)TTM EPSTTM P/EP/BROEOverall Score (%)
RailTel Corporation India10,606.573,551.04299.819.9033.375.300.00Subscribe to view
Bharti Airtel1,196,718.46174,558.9033,778.3052.4438.0810.5326.73Subscribe to view
Vodafone Idea119,068.9544,183.20-27,442.10-2.64-4.16-1.7035.19Subscribe to view
Bharti Hexacom85,116.318,729.701,493.6035.0948.5014.350.00Subscribe to view
Tata Communications48,005.4023,238.891,583.1562.4126.8415.8958.82Subscribe to view
Theme Ranks
Theme Rank Total Stocks Theme Rank Total Stocks
Best Stocks 355 1,347 Fast Growing Stocks 197 1,356
Profitable Stocks 432 1,340 Dividend Paying Stocks 232 361
Blue-Chip Stocks 0 97 Low PE Stocks 0 138
Debt Free Stocks 0 853 Buffet Type Stocks 510 1,356
Fundamentally Strong Stocks 406 1,356 High Return Stocks 273 1,367
Undervalued Stocks 247 1,355 Penny Stocks 0 255
Profitable & Growing Stocks 0 126
Price Summary
Today's High Today's Low 52W High 52W Low
2,000.9 1,983.5 2,174.7 1,561.0
Recent Results
Market Cap (Cr) Revenue (Cr) Net Profit (Cr) Net Worth (Cr)
1,196,718.46 174,558.90 33,778.30 113,671.90
D/E Current Ratio ROE (%) ROCE (%)
1.30 0.37 26.73 17.82
Valuation & Growth
P/E P/B Div.Yield (%) PEG (%)
39.38 10.53 0.80 0.80
EPSG-3Y (%) EPSG-3Y (%) 3M-Return (%) 1Y-Return (%)
65.83 -273.74 0.06 21.66
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

11.79%

Net Sales

Past → Today

11.95%

Total Income

Past → Today

16.9%

Operating Profit

Past → Today

38.88%

PAT

Past → Today

11.3%

Net Worth

Past → Today

45.65%

EPS

Past → Today

-2%

Last 14D Price Trend

Past → Today

0%

Last 30D Price Trend

Past → Today

-8%

Last 90D Price Trend

Past → Today

3%

Last 180D Price Trend

Past → Today

22%

Last 1Y Price Trend

Past → Today

36.86%

Last 3Y Price Trend

Past → Today

27.92%

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-2.772.591.441.821.610.78
Efficiency Ratios
IndicatorUnitTTMMar 25Mar 24Mar 23Mar 22Mar 21
Fixed Asset Turnover Ratio-0.590.500.510.470.540.51
Gross Margin%100.00100.00100.00100.00100.00100.00
Operating Margin%28.0531.7220.7924.5622.4311.04
EBITDA Margin%53.8658.4447.6551.0751.0540.65
PAT Margin%14.7619.353.868.235.02-12.12
Op.Cash Flow Margin%48.3356.8452.6046.9547.2147.91
ROA%5.916.571.322.581.62-3.55
ROE%26.7329.725.7912.708.84-20.82
ROCE%17.8216.9110.6610.8110.695.01
ROIC%5.016.820.661.930.97-3.81
Price Valuation Ratios
IndicatorUnitTTMMar 25Mar 24Mar 23Mar 22Mar 21
P/E-38.5629.84115.7266.71135.94-25.78
PEG-0.810.06-4.320.58-0.49-25.78
EV/EBITDA-12.148.316.5510.258.247.43
Price to Sales-5.764.142.254.173.201.88
P/B-10.316.303.346.405.613.22
Dividend Yield%0.380.650.680.290.000.66
P/FCF-94.6257.80-1,275.5727.2376.48108.57
FCF/Sales-0.050.05-1.700.040.150.25
Earnings Yield%4.426.666.904.795.413.84
Top | Price Trend | Performance | Ratios

Snapshot

Quarterly Report
IndicatorUnitTTMDec '25Sep '25Jun '25Mar '25Dec '24
SalesRs. Cr.203,464.0053,981.0052,145.0049,462.0047,876.0045,129.00
Other IncomeRs. Cr.2,422.00702.00727.00508.00485.00469.00
Op. ProfitRs. Cr.63,796.0017,362.0016,379.0015,373.0014,682.0012,892.00
EBITDARs. Cr.110,892.00102,019.7072,154.9071,540.3059,766.8041,156.70
PBTRs. Cr.44,373.0012,185.0012,241.0010,421.009,526.0015,232.00
PATRs. Cr.30,389.006,630.006,791.005,947.0011,021.0014,781.00
EPSRs. Cr.52.4411.4411.7210.2619.0225.54
Profit & Loss Account
IndicatorUnitTTMMar 25Mar 24Mar 23Mar 22Mar 21
IncomeRs. Cr.205,886.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.57,077.0054,875.7031,181.9034,171.9026,141.8011,109.50
EBITDARs. Cr.110,892.00102,019.7072,154.9071,540.3059,766.8041,156.70
PBTRs. Cr.44,373.0012,185.0012,241.0010,421.009,526.0015,232.00
PATRs. Cr.30,389.006,630.006,791.005,947.0011,021.0014,781.00
EPSRs. Cr.52.4411.4411.7210.2619.0225.54
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