25 XP 0   0   10  
0coffee
Main menu
3rd party ad coffee SUPPORTERis ad-free.

BHARTI AIRTEL LTD.
Buy, Hold or Sell?

Let's analyze Airtel together

I guess you are interested in BHARTI AIRTEL LTD.. Buy, hold or sell? I don't know! However, I do recommend doing research before doing anything. I will help you with that.

I'm going to help you getting a better view of BHARTI AIRTEL LTD.. At the end you don't have to ask anyone for trading advice. You can make your own decision, with more confidence, the odds in your favor, backed by data.

Get notifications about BHARTI AIRTEL LTD.

I send you an email if I find something interesting about BHARTI AIRTEL LTD..

1. Quick Overview

1.1. Quick analysis of Airtel (30 sec.)










1.2. What can you expect buying and holding a share of Airtel? (30 sec.)

How much money do you get?

How much money do you get?
INR0.13
When do you have the money?
1 year
How often do you get paid?
92.6%

What is your share worth?

Current worth
INR181.38
Expected worth in 1 year
INR226.59
How sure are you?
81.5%

+ What do you gain per year?

Total Gains per Share
INR56.40
Return On Investment
3.4%

For what price can you sell your share?

Current Price per Share
INR1,643.10
Expected price per share
INR1,511 - INR1,779
How sure are you?
50%
3rd party ad coffee SUPPORTERis ad-free.

2. Detailed Analysis

2.1. Valuation of Airtel (5 min.)




Live pricePrice per Share (EOD)
INR1,643.10
Intrinsic Value Per Share
INR188.05 - INR212.06
Total Value Per Share
INR369.43 - INR393.43

2.2. Growth of Airtel (5 min.)




Is Airtel growing?

Current yearPrevious yearGrowGrow %
How rich?$13b$9b$3.6b29.1%

How much money is Airtel making?

Current yearPrevious yearGrowGrow %
Making money$361.8m$222.6m$139.2m38.5%
Net Profit Margin7.9%5.2%--

How much money comes from the company's main activities?

2.3. Financial Health of Airtel (5 min.)




2.4. Comparing to competitors in the Telecom Services industry (5 min.)




  Industry Rankings (Telecom Services)  


Richest
#29 / 244

Most Revenue
#30 / 244

Most Profit
#27 / 244
3rd party ad coffee SUPPORTERis ad-free.

3. Summary and Key Metrics

3.1. What can you expect buying and holding a share of Airtel?

Welcome investor! Airtel's management wants to use your money to grow the business. In return you get a share of Airtel.

First you should know what it really means to hold a share of Airtel. And how you can make/lose money.

Speculation

The Price per Share of Airtel is INR1,643. The market price reflects what other people think it is worth; not what it's really worth. Your job is to find out if the market price is fair, overpriced, or underpriced. I will help you with that.

If you buy blind, there is a 50% chance of making or losing money by selling the stock in the future. However, we can look at a few things to determine the odds in our favor:

  • The fundamentals: the financial health trends of Airtel.
  • The technials: based on market psychology, we can make a calculated estimate of what the price will do in the future. We can do this through technical analysis. We can calculate the probabilities and the expected value (millionaire math). That's called speculation.
  • The book value: what is the market price compared to it's book value.

Investing

If you really want to invest in Airtel, you will have to let go of the thought of selling in the future. If you have to sell the share for less than you bought it, it can still be a good investment. Focus on what it means to hold the stock forever:

  • You own a part of the company. The equity of this part can grow or shrink. The current Book Value per Share is INR181.38. Based on the TTM, the Book Value Change Per Share is INR11.30 per quarter. Based on the YOY, the Book Value Change Per Share is INR2.03 per quarter.
  • You may receive quarterly/yearly dividend in the form of additional shares.
  • You may receive quarterly/yearly dividend in the form of cash. Based on the TTM the Dividend per Share is INR2.80 per quarter.
Based on historical numbers we can estimate the returns while holding a share of Airtel.

How much money are you going to get?

 MRQTTMYOY5Y10Y
 INR% of Price per ShareINR% of Price per ShareINR% of Price per ShareINR% of Price per ShareINR% of Price per Share
Usd Eps0.070.0%0.060.0%0.040.0%0.010.0%-0.010.0%
Usd Book Value Change Per Share-0.030.0%0.130.0%0.020.0%0.030.0%0.080.0%
Usd Dividend Per Share0.110.0%0.030.0%0.020.0%0.030.0%0.020.0%
Usd Total Gains Per Share0.070.0%0.170.0%0.050.0%0.060.0%0.100.0%
Usd Price Per Share20.18-15.98-9.91-9.33-8.08-
Price to Earnings Ratio72.35-69.60-70.87-61.22-73.29-
Price-to-Total Gains Ratio282.71-233.34--308.55-29.89-34.91-
Price to Book Ratio9.43-7.58-6.25-5.88-5.09-
Price-to-Total Gains Ratio282.71-233.34--308.55-29.89-34.91-

When do you get the money?

Usd Investment
$.00
Usd Price Per Share19.38858
Number of shares51
Gains per QuarterTrailing 12 Months5 Year
Usd Dividend Per Share0.030.03
Usd Book Value Change Per Share0.130.03
Usd Total Gains Per Share0.170.06
Gains per Quarter (51 shares)8.493.15
Gains per Year (51 shares)33.9412.60
YearsReturn on Investment (TTM)Return on Investment (5Y)
 DividendBook Value gainTotal gainsDividendBook Value gainTotal gains
Broker costs---10---10
172724673
2135458111416
3208292172129
427109126222842
534136160283555
640163194334268
747190228394981
854218262455694
9612452965063107
10672723305670120

How sure are you?

Based on the past periods, how sure are you to get value out of your investment.

Linear %
 Trailing 12 Months3Y5 Year10 YearALLTIME
  % % % % %
Earnings Per Share4.00.00.0100.0%12.00.00.0100.0%16.04.00.080.0%21.06.00.077.8%21.06.00.077.8%
Book Value Change Per Share3.01.00.075.0%10.02.00.083.3%13.07.00.065.0%19.08.00.070.4%19.08.00.070.4%
Dividend per Share4.00.00.0100.0%12.00.00.0100.0%20.00.00.0100.0%25.00.02.092.6%25.00.02.092.6%
Total Gains per Share4.00.00.0100.0%11.01.00.091.7%16.04.00.080.0%22.05.00.081.5%22.05.00.081.5%
3rd party ad coffee SUPPORTERis ad-free.

3.2. Key Performance Indicators

The key performance indicators of BHARTI AIRTEL LTD. compared to the Most Recent Quarter (MRQ).

 End of day+/-Most Recent QuarterTrailing 12 Months+/-Year-Over-Year+/-5 Year+/-10 Year+/-
Book Value Change Per Share---2.89811.303-126%2.035-242%2.920-199%6.718-143%
Book Value Per Share--181.376178.120+2%134.448+35%130.587+39%131.657+38%
Current Ratio--0.3590.411-13%0.477-25%0.477-25%0.447-20%
Debt To Asset Ratio--0.7610.760+0%0.827-8%0.810-6%0.781-3%
Debt To Equity Ratio--4.0264.064-1%4.795-16%4.529-11%3.924+3%
Dividend Per Share--8.9462.797+220%2.048+337%2.314+287%1.979+352%
Eps--5.9085.060+17%3.316+78%0.497+1088%-1.195+120%
Free Cash Flow Per Share--15.97315.678+2%9.803+63%7.802+105%6.436+148%
Free Cash Flow To Equity Per Share--15.97315.678+2%-6.369+140%-5.803+136%-3.319+121%
Gross Profit Margin--1.0001.0000%1.0000%1.0000%1.0000%
Intrinsic Value_10Y_max--212.056--------
Intrinsic Value_10Y_min--188.051--------
Intrinsic Value_1Y_max--31.373--------
Intrinsic Value_1Y_min--30.821--------
Intrinsic Value_3Y_max--86.547--------
Intrinsic Value_3Y_min--82.781--------
Intrinsic Value_5Y_max--132.421--------
Intrinsic Value_5Y_min--123.573--------
Market Cap9350142310656.000-11%10398694081280.9008206534164532.838+27%4780417457760.000+118%4610739856939.118+126%3977346650479.612+161%
Net Profit Margin--0.0870.079+10%0.052+67%-0.006+107%-0.047+154%
Operating Margin----0%0.196-100%0.094-100%0.100-100%
Operating Ratio--1.0591.097-3%1.073-1%1.155-8%1.167-9%
Pb Ratio9.059-4%9.4277.577+24%6.248+51%5.882+60%5.093+85%
Pe Ratio69.523-4%72.35069.598+4%70.872+2%61.220+18%73.290-1%
Price Per Share1643.100-4%1709.9001354.288+26%840.063+104%790.853+116%684.574+150%
Price To Free Cash Flow Ratio25.717-4%26.76325.290+6%3.348+699%10.317+159%1076.408-98%
Price To Total Gains Ratio271.665-4%282.710233.339+21%-308.548+209%29.894+846%34.908+710%
Quick Ratio--0.2470.269-8%0.610-59%0.527-53%0.454-46%
Return On Assets--0.0080.007+14%0.004+83%0.000+2945%-0.002+131%
Return On Equity--0.0410.036+14%0.025+68%0.002+2437%-0.011+128%
Total Gains Per Share--6.04814.100-57%4.082+48%5.234+16%8.697-30%
Usd Book Value--13015754000.00012727695350.000+2%9027997100.000+44%8940022790.000+46%8967473807.407+45%
Usd Book Value Change Per Share---0.0340.133-126%0.024-242%0.034-199%0.079-143%
Usd Book Value Per Share--2.1402.102+2%1.586+35%1.541+39%1.554+38%
Usd Dividend Per Share--0.1060.033+220%0.024+337%0.027+287%0.023+352%
Usd Eps--0.0700.060+17%0.039+78%0.006+1088%-0.014+120%
Usd Free Cash Flow--1146216600.0001119114950.000+2%658268900.000+74%540209900.000+112%444291851.852+158%
Usd Free Cash Flow Per Share--0.1880.185+2%0.116+63%0.092+105%0.076+148%
Usd Free Cash Flow To Equity Per Share--0.1880.185+2%-0.075+140%-0.068+136%-0.039+121%
Usd Market Cap110331679265.741-11%122704590159.11596837103141.488+27%56408926001.568+118%54406730311.882+126%46932690475.659+161%
Usd Price Per Share19.389-4%20.17715.981+26%9.913+104%9.332+116%8.078+150%
Usd Profit--423997600.000361873550.000+17%222636500.000+90%38144090.000+1012%-76711362.963+118%
Usd Revenue--4893849400.0004586609850.000+7%4315767400.000+13%3736543160.000+31%3429662133.333+43%
Usd Total Gains Per Share--0.0710.166-57%0.048+48%0.062+16%0.103-30%
 EOD+4 -4MRQTTM+23 -11YOY+26 -95Y+26 -910Y+25 -10

3.3 Fundamental Score

Let's check the fundamental score of BHARTI AIRTEL LTD. based on Penke's default stock scanner.

Penke's Stock Scanner

  
  
IndicatorConditionValue
Price to Earnings Ratio (EOD)Between0-1569.523
Price to Book Ratio (EOD)Between0-19.059
Net Profit Margin (MRQ)Greater than00.087
Operating Margin (MRQ)Greater than00.000
Quick Ratio (MRQ)Greater than10.247
Current Ratio (MRQ)Greater than10.359
Debt to Asset Ratio (MRQ)Less than10.761
Debt to Equity Ratio (MRQ)Less than14.026
Return on Equity (MRQ)Greater than0.150.041
Return on Assets (MRQ)Greater than0.050.008
Total2/10 (20.0%)

3.4 Technical Score

Let's check the technical score of BHARTI AIRTEL LTD. based on Penke's default Symbol scanner.

Penke's Symbol Scanner

  
  
IndicatorConditionValue
OpenGreater thanClose1,629.450
Total0/1 (0.0%)

4. In-depth Analysis

4.1 About BHARTI AIRTEL LTD.

Bharti Airtel Limited operates as a telecommunications company in India and internationally. It operates through Mobile Services India, Mobile Services Africa, Mobile Services South Asia, Airtel Business, Tower Infrastructure Services, Homes Services, Digital TV Services, and Others segments. The company engages in provision of voice and data telecom services through wireless technology including 2G/3G/4G/5G services; and operates as a single point of contact for telecommunication across data and voice, network integration, and managed services. It also provides services related to setting up, operation, and maintenance of wireless communication towers; and voice and data communications services through fixed-line network and broadband technology for homes, as well as offers digital broadcasting services under the DTH platform. In addition, the company offers post-paid, prepaid, roaming, internet, and various value-added services, as well as mobile TV, video calls, live-streaming videos, gaming, video streaming, and other services; and network integration, data centers, managed services, enterprise mobility applications and digital media services. The company was formerly known as Bharti Tele-Ventures Limited and changed its name to Bharti Airtel Limited in April 2006. Bharti Airtel Limited was incorporated in 1995 and is headquartered in New Delhi, India.

Fundamental data was last updated by Penke on 2024-11-17 04:50:03.

4.2 In-depth Summary

4.2.1. Financial Health Summary

Profitability Details
 Compared to previous yearCompared to industry
The company is making a profit.
Using its assets, the company is inefficient in making profit.
Using its investors money, the company is inefficient in making profit.
Operating Efficiency Details
 Compared to previous yearCompared to industry
The company is inefficient in keeping operating costs low.
Liquidity Details
 Compared to previous yearCompared to industry
The company is unable to pay all its short-term debts.
The company is just not able to pay all its short-term debts with the most liquid assets.
Solvency Details
 Compared to previous yearCompared to industry
The company is just able to pay all its debts by selling its assets.
The company is unable to pay all its debts with equity.

4.2.2. Valuation Summary

Valuation Details
 Compared to previous yearCompared to industry
Based on the equity, the company is overpriced.
Based on the earnings, the company is expensive.
Based on how much money comes from the company's main activities, the company is underpriced.
3rd party ad coffee SUPPORTERis ad-free.

4.3 Financial Health

4.3.1. Profitability

4.3.1 Profitability
4.3.1.1. Net Profit Margin

Measures how much net profit Airtel earns for each ₹1 of revenue.

  • Above 10% is considered healthy but always compare Airtel to the Telecom Services industry mean.
  • A Net Profit Margin of 8.7% means that ₹0.09 for each ₹1 in revenue is generated as profit.

Let's take a look of the Net Profit Margin trends of BHARTI AIRTEL LTD.:

  • The MRQ is 8.7%. The company is making a profit. +1
  • The TTM is 7.9%. The company is making a profit. +1
Trends
Current periodCompared to+/- 
MRQ8.7%TTM7.9%+0.8%
TTM7.9%YOY5.2%+2.7%
TTM7.9%5Y-0.6%+8.5%
5Y-0.6%10Y-4.7%+4.1%
Compared to industry (Telecom Services)
PeriodCompanyIndustry (mean)+/- 
MRQ8.7%5.1%+3.6%
TTM7.9%4.7%+3.2%
YOY5.2%4.9%+0.3%
5Y-0.6%5.8%-6.4%
10Y-4.7%5.4%-10.1%
4.3.1.2. Return on Assets

Shows how efficient Airtel is using its assets to generate profit.

  • Above 5% is considered healthy but always compare Airtel to the Telecom Services industry mean.
  • 0.8% Return on Assets means that Airtel generated ₹0.01 profit for each $1 in assets.

Let's take a look of the Return on Assets trends of BHARTI AIRTEL LTD.:

  • The MRQ is 0.8%. Using its assets, the company is inefficient in making profit. -1
  • The TTM is 0.7%. Using its assets, the company is inefficient in making profit. -1
Trends
Current periodCompared to+/- 
MRQ0.8%TTM0.7%+0.1%
TTM0.7%YOY0.4%+0.3%
TTM0.7%5Y0.0%+0.7%
5Y0.0%10Y-0.2%+0.3%
Compared to industry (Telecom Services)
PeriodCompanyIndustry (mean)+/- 
MRQ0.8%0.7%+0.1%
TTM0.7%0.6%+0.1%
YOY0.4%0.8%-0.4%
5Y0.0%0.8%-0.8%
10Y-0.2%1.0%-1.2%
4.3.1.3. Return on Equity

Shows how efficient Airtel is using its investors money to generate profit.

  • Above 15%-20% is considered healthy but always compare Airtel to the Telecom Services industry mean.
  • 4.1% Return on Equity means Airtel generated ₹0.04 for each ₹1 the owners (shareholders) invested.

Let's take a look of the Return on Equity trends of BHARTI AIRTEL LTD.:

  • The MRQ is 4.1%. Using its investors money, the company is inefficient in making profit. -1
  • The TTM is 3.6%. Using its investors money, the company is inefficient in making profit. -1
Trends
Current periodCompared to+/- 
MRQ4.1%TTM3.6%+0.5%
TTM3.6%YOY2.5%+1.2%
TTM3.6%5Y0.2%+3.4%
5Y0.2%10Y-1.1%+1.3%
Compared to industry (Telecom Services)
PeriodCompanyIndustry (mean)+/- 
MRQ4.1%2.2%+1.9%
TTM3.6%1.9%+1.7%
YOY2.5%2.1%+0.4%
5Y0.2%2.2%-2.0%
10Y-1.1%2.2%-3.3%
3rd party ad coffee SUPPORTERis ad-free.

4.3.2. Operating Efficiency of BHARTI AIRTEL LTD..

4.3.2. Operating Efficiency
4.3.2.1. Operating Margin

Measures how efficient Airtel is operating .

  • Measures how much profit Airtel makes for each ₹1 of sales after paying variable costs (production costs, wages, etc) but before taxes.
  • Above 15% is considered healthy but always compare Airtel to the Telecom Services industry mean.
  • An Operating Margin of 0.0% means the company generated ₹0.00  for each ₹1 in revenue (before taxes).

Let's take a look of the Operating Margin trends of BHARTI AIRTEL LTD.:

  • The MRQ is 0.0%. The data is not here.
Trends
Current periodCompared to+/- 
MRQ-TTM-0.0%
TTM-YOY19.6%-19.6%
TTM-5Y9.4%-9.4%
5Y9.4%10Y10.0%-0.7%
Compared to industry (Telecom Services)
PeriodCompanyIndustry (mean)+/- 
MRQ-11.9%-11.9%
TTM-10.2%-10.2%
YOY19.6%11.1%+8.5%
5Y9.4%11.1%-1.7%
10Y10.0%11.7%-1.7%
4.3.2.2. Operating Ratio

Measures how efficient Airtel is keeping operating costs low.

  • Below 1 is considered healthy (always compare to Telecom Services industry mean).
  • An Operation Ratio of 1.06 means that the operating costs are ₹1.06 for each ₹1 in net sales.

Let's take a look of the Operating Ratio trends of BHARTI AIRTEL LTD.:

  • The MRQ is 1.059. The company is inefficient in keeping operating costs low. -1
  • The TTM is 1.097. The company is inefficient in keeping operating costs low. -1
Trends
Current periodCompared to+/- 
MRQ1.059TTM1.097-0.038
TTM1.097YOY1.073+0.025
TTM1.0975Y1.155-0.058
5Y1.15510Y1.167-0.012
Compared to industry (Telecom Services)
PeriodCompanyIndustry (mean)+/- 
MRQ1.0590.958+0.101
TTM1.0970.978+0.119
YOY1.0730.945+0.128
5Y1.1550.948+0.207
10Y1.1670.940+0.227
3rd party ad coffee SUPPORTERis ad-free.

4.4.3. Liquidity of BHARTI AIRTEL LTD..

4.4.3. Liquidity
4.4.3.1. Current Ratio

Measures if Airtel is able to pay off Short-term Debt.

  • Above 1.5 is considered healthy (always compare to Telecom Services industry mean).
  • A Current Ratio of 0.36 means the company has ₹0.36 in assets for each ₹1 in short-term debts.

Let's take a look of the Current Ratio trends of BHARTI AIRTEL LTD.:

  • The MRQ is 0.359. The company is unable to pay all its short-term debts. -2
  • The TTM is 0.411. The company is unable to pay all its short-term debts. -2
Trends
Current periodCompared to+/- 
MRQ0.359TTM0.411-0.052
TTM0.411YOY0.477-0.066
TTM0.4115Y0.477-0.066
5Y0.47710Y0.447+0.030
Compared to industry (Telecom Services)
PeriodCompanyIndustry (mean)+/- 
MRQ0.3590.933-0.574
TTM0.4110.934-0.523
YOY0.4770.953-0.476
5Y0.4771.005-0.528
10Y0.4471.045-0.598
4.4.3.2. Quick Ratio

Measures if Airtel is able to pay off Short-term Debt but only using the most liquid assets.

  • Above 1 is considered healthy but always compare Airtel to the Telecom Services industry mean.
  • A Quick Ratio of 0.25 means the company can pay off ₹0.25 for each ₹1 in debt (using most liquid assets).

Let's take a look of the Quick Ratio trends of BHARTI AIRTEL LTD.:

  • The MRQ is 0.247. The company is just not able to pay all its short-term debts with the most liquid assets. -1
  • The TTM is 0.269. The company is just not able to pay all its short-term debts with the most liquid assets. -1
Trends
Current periodCompared to+/- 
MRQ0.247TTM0.269-0.022
TTM0.269YOY0.610-0.341
TTM0.2695Y0.527-0.258
5Y0.52710Y0.454+0.073
Compared to industry (Telecom Services)
PeriodCompanyIndustry (mean)+/- 
MRQ0.2470.602-0.355
TTM0.2690.631-0.362
YOY0.6100.718-0.108
5Y0.5270.753-0.226
10Y0.4540.793-0.339
3rd party ad coffee SUPPORTERis ad-free.

4.5.4. Solvency of BHARTI AIRTEL LTD..

4.5.4. Solvency
4.5.4.1. Debt to Asset Ratio

Measures how much % of Airtel assets are financed with debt.

  • Below 1 (100%) is considered healthy but always compare Airtel to Telecom Services industry mean.
  • A Debt to Asset Ratio of 0.76 means that Airtel assets are financed with 76.1% credit (debt) and the remaining percentage (100% - 76.1%) is financed by its owners/shareholders. 

Let's take a look of the Debt to Asset Ratio trends of BHARTI AIRTEL LTD.:

  • The MRQ is 0.761. The company is just able to pay all its debts by selling its assets.
  • The TTM is 0.760. The company is just able to pay all its debts by selling its assets.
Trends
Current periodCompared to+/- 
MRQ0.761TTM0.760+0.001
TTM0.760YOY0.827-0.068
TTM0.7605Y0.810-0.050
5Y0.81010Y0.781+0.028
Compared to industry (Telecom Services)
PeriodCompanyIndustry (mean)+/- 
MRQ0.7610.634+0.127
TTM0.7600.620+0.140
YOY0.8270.613+0.214
5Y0.8100.615+0.195
10Y0.7810.613+0.168
4.5.4.2. Debt to Equity Ratio

Measures if Airtel is able to pay off its debts by using shareholders equity.

  • Below 2 is considered healthy but always compare Airtel to the Telecom Services industry mean.
  • A Debt to Equity ratio of 402.6% means that company has ₹4.03 debt for each ₹1 in shareholders equity.

Let's take a look of the Debt to Equity Ratio trends of BHARTI AIRTEL LTD.:

  • The MRQ is 4.026. The company is unable to pay all its debts with equity. -1
  • The TTM is 4.064. The company is unable to pay all its debts with equity. -1
Trends
Current periodCompared to+/- 
MRQ4.026TTM4.064-0.038
TTM4.064YOY4.795-0.731
TTM4.0645Y4.529-0.465
5Y4.52910Y3.924+0.606
Compared to industry (Telecom Services)
PeriodCompanyIndustry (mean)+/- 
MRQ4.0261.594+2.432
TTM4.0641.580+2.484
YOY4.7951.575+3.220
5Y4.5291.690+2.839
10Y3.9241.627+2.297
3rd party ad coffee SUPPORTERis ad-free.

4.6. Market Valuation

4.6.1. Earnings Per Share
4.6.2.1. Price to Earnings Ratio

Measures how much money you pay for each share for every ₹1 in earnings Airtel generates.

  • Above 15 is considered overpriced but always compare Airtel to the Telecom Services industry mean.
  • A PE ratio of 72.35 means the investor is paying ₹72.35 for every ₹1 in earnings.

Let's take a look of the Price to Earnings Ratio trends of BHARTI AIRTEL LTD.:

  • The EOD is 69.523. Based on the earnings, the company is expensive. -2
  • The MRQ is 72.350. Based on the earnings, the company is expensive. -2
  • The TTM is 69.598. Based on the earnings, the company is expensive. -2
Trends
Current periodCompared to+/- 
EOD69.523MRQ72.350-2.826
MRQ72.350TTM69.598+2.752
TTM69.598YOY70.872-1.274
TTM69.5985Y61.220+8.378
5Y61.22010Y73.290-12.070
Compared to industry (Telecom Services)
PeriodCompanyIndustry (mean)+/- 
EOD69.52310.580+58.943
MRQ72.35010.949+61.401
TTM69.59810.481+59.117
YOY70.87210.869+60.003
5Y61.22016.074+45.146
10Y73.29017.532+55.758
4.6.2.2. Price To Free Cash Flow Ratio

Let's take a look of the Price To Free Cash Flow Ratio trends of BHARTI AIRTEL LTD.:

  • The EOD is 25.717. Based on how much money comes from the company's main activities, the company is underpriced. +1
  • The MRQ is 26.763. Based on how much money comes from the company's main activities, the company is underpriced. +1
  • The TTM is 25.290. Based on how much money comes from the company's main activities, the company is underpriced. +1
Trends
Current periodCompared to+/- 
EOD25.717MRQ26.763-1.046
MRQ26.763TTM25.290+1.473
TTM25.290YOY3.348+21.942
TTM25.2905Y10.317+14.973
5Y10.31710Y1,076.408-1,066.092
Compared to industry (Telecom Services)
PeriodCompanyIndustry (mean)+/- 
EOD25.7174.946+20.771
MRQ26.7635.047+21.716
TTM25.2903.860+21.430
YOY3.3484.992-1.644
5Y10.3175.093+5.224
10Y1,076.4085.968+1,070.440
3rd party ad coffee SUPPORTERis ad-free.
4.6.2. Book Value per Share
4.6.2.1. Price to Book Ratio

Measures if the stock price of Airtel is to cheap or to expensive compared to its book value.

  • At or below 1 is considered healthy (always compare to Telecom Services industry mean).
  • A PB ratio of 9.43 means the investor is paying ₹9.43 for each ₹1 in book value.

Let's take a look of the Price to Book Ratio trends of BHARTI AIRTEL LTD.:

  • The EOD is 9.059. Based on the equity, the company is overpriced. -1
  • The MRQ is 9.427. Based on the equity, the company is overpriced. -1
  • The TTM is 7.577. Based on the equity, the company is overpriced. -1
Trends
Current periodCompared to+/- 
EOD9.059MRQ9.427-0.368
MRQ9.427TTM7.577+1.851
TTM7.577YOY6.248+1.328
TTM7.5775Y5.882+1.694
5Y5.88210Y5.093+0.789
Compared to industry (Telecom Services)
PeriodCompanyIndustry (mean)+/- 
EOD9.0591.645+7.414
MRQ9.4271.456+7.971
TTM7.5771.578+5.999
YOY6.2481.619+4.629
5Y5.8821.958+3.924
10Y5.0932.508+2.585
4.6.2. Total Gains per Share
3rd party ad coffee SUPPORTERis ad-free.

6. Financial Statements




6.1. Latest Balance Sheet

Balance Sheet of 2024-09-30. Currency in INR. All numbers in thousands.

Summary
Total Assets4,609,821,000
Total Liabilities3,506,791,000
Total Stockholder Equity870,974,000
 As reported
Total Liabilities 3,506,791,000
Total Stockholder Equity+ 870,974,000
Total Assets = 4,609,821,000

Assets

Total Assets4,609,821,000
Total Current Assets552,831,000
Long-term Assets4,056,990,000
Total Current Assets
Cash And Cash Equivalents 47,380,000
Short-term Investments 324,425,000
Net Receivables 56,452,000
Inventory 4,361,000
Other Current Assets 119,758,000
Total Current Assets  (as reported)552,831,000
Total Current Assets  (calculated)552,376,000
+/- 455,000
Long-term Assets
Property Plant Equipment 1,877,458,000
Goodwill 262,555,000
Intangible Assets 1,249,507,000
Long-term Assets Other 104,619,000
Long-term Assets  (as reported)4,056,990,000
Long-term Assets  (calculated)3,494,139,000
+/- 562,851,000

Liabilities & Shareholders' Equity

Total Current Liabilities1,541,619,000
Long-term Liabilities1,965,172,000
Total Stockholder Equity870,974,000
Total Current Liabilities
Short Long Term Debt 297,870,000
Accounts payable 395,892,000
Other Current Liabilities 64,747,000
Total Current Liabilities  (as reported)1,541,619,000
Total Current Liabilities  (calculated)758,509,000
+/- 783,110,000
Long-term Liabilities
Long term Debt 1,165,534,000
Capital Lease Obligations Min Short Term Debt792,004,000
Long-term Liabilities Other 1,061,000
Long-term Liabilities  (as reported)1,965,172,000
Long-term Liabilities  (calculated)1,958,599,000
+/- 6,573,000
Total Stockholder Equity
Total Stockholder Equity (as reported)870,974,000
Total Stockholder Equity (calculated)0
+/- 870,974,000
Other
Capital Stock28,956,000
Common Stock Shares Outstanding 6,081,463
Net Debt 1,416,024,000
Net Invested Capital 2,334,378,000
Net Working Capital -988,788,000
Property Plant and Equipment Gross 1,877,458,000



6.2. Balance Sheets Structured

Currency in INR. All numbers in thousands.

 Trend2024-09-302024-06-302024-03-312023-12-312023-09-302023-06-302023-03-312022-12-312022-09-302022-06-302022-03-312021-12-312021-09-302021-06-302021-03-312020-12-312020-09-302020-06-302020-03-312019-12-312019-09-302019-06-302017-12-312017-09-302017-06-302017-03-312016-12-31
> Total Assets 
2,363,764,000
2,327,502,000
2,329,271,000
2,418,944,000
2,427,085,000
2,955,932,000
3,356,226,000
3,514,259,000
3,607,790,000
3,521,345,000
3,403,193,000
3,344,480,000
3,460,278,000
3,558,593,000
3,658,360,000
3,621,940,000
3,636,560,000
3,753,160,000
4,243,886,000
4,378,397,000
4,466,332,000
4,466,002,000
4,420,961,000
4,456,927,000
4,445,310,000
4,450,907,000
4,609,821,000
4,609,821,0004,450,907,0004,445,310,0004,456,927,0004,420,961,0004,466,002,0004,466,332,0004,378,397,0004,243,886,0003,753,160,0003,636,560,0003,621,940,0003,658,360,0003,558,593,0003,460,278,0003,344,480,0003,403,193,0003,521,345,0003,607,790,0003,514,259,0003,356,226,0002,955,932,0002,427,085,0002,418,944,0002,329,271,0002,327,502,0002,363,764,000
   > Total Current Assets 
181,576,000
203,150,000
218,228,000
247,472,000
256,641,000
341,344,000
596,601,000
738,462,000
766,432,000
740,045,000
619,818,000
508,933,000
547,529,000
515,925,000
580,743,000
537,108,000
520,279,000
530,046,000
532,391,000
587,413,000
575,013,000
645,466,000
579,928,000
642,882,000
582,761,000
548,858,000
552,831,000
552,831,000548,858,000582,761,000642,882,000579,928,000645,466,000575,013,000587,413,000532,391,000530,046,000520,279,000537,108,000580,743,000515,925,000547,529,000508,933,000619,818,000740,045,000766,432,000738,462,000596,601,000341,344,000256,641,000247,472,000218,228,000203,150,000181,576,000
       Cash And Cash Equivalents 
13,165,000
12,817,000
16,514,000
16,419,000
18,293,000
76,076,000
127,737,000
126,028,000
158,774,000
157,432,000
134,737,000
132,235,000
80,859,000
127,361,000
119,782,000
141,579,000
60,959,000
0
64,942,000
60,727,000
71,794,000
58,799,000
43,656,000
55,169,000
71,394,000
50,179,000
47,380,000
47,380,00050,179,00071,394,00055,169,00043,656,00058,799,00071,794,00060,727,00064,942,000060,959,000141,579,000119,782,000127,361,00080,859,000132,235,000134,737,000157,432,000158,774,000126,028,000127,737,00076,076,00018,293,00016,419,00016,514,00012,817,00013,165,000
       Short-term Investments 
40,597,000
3,763,000
59,558,000
61,408,000
78,558,000
0
281,239,000
419,049,000
328,830,000
0
309,800,000
197,842,000
251,573,000
200,085,000
271,950,000
213,234,000
245,630,000
239,400,000
244,221,000
292,841,000
277,505,000
310,722,000
253,490,000
414,412,000
251,308,000
326,208,000
324,425,000
324,425,000326,208,000251,308,000414,412,000253,490,000310,722,000277,505,000292,841,000244,221,000239,400,000245,630,000213,234,000271,950,000200,085,000251,573,000197,842,000309,800,0000328,830,000419,049,000281,239,000078,558,00061,408,00059,558,0003,763,00040,597,000
       Net Receivables 
70,528,000
101,712,000
67,540,000
70,130,000
54,785,000
51,551,000
53,290,000
53,558,000
201,240,000
56,047,000
49,617,000
45,826,000
36,377,000
47,707,000
50,350,000
49,846,000
40,562,000
44,933,000
47,751,000
47,595,000
142,771,000
52,163,000
55,927,000
55,099,000
47,277,000
50,768,000
56,452,000
56,452,00050,768,00047,277,00055,099,00055,927,00052,163,000142,771,00047,595,00047,751,00044,933,00040,562,00049,846,00050,350,00047,707,00036,377,00045,826,00049,617,00056,047,000201,240,00053,558,00053,290,00051,551,00054,785,00070,130,00067,540,000101,712,00070,528,000
       Inventory 
1,288,000
488,000
807,000
544,000
645,000
0
1,218,000
0
1,569,000
0
1,842,000
0
2,660,000
0
2,889,000
0
3,750,000
0
2,453,000
0
2,576,000
0
3,386,000
0
3,639,000
0
4,361,000
4,361,00003,639,00003,386,00002,576,00002,453,00003,750,00002,889,00002,660,00001,842,00001,569,00001,218,0000645,000544,000807,000488,0001,288,000
       Other Current Assets 
55,998,000
55,957,000
73,809,000
98,971,000
104,360,000
137,851,000
153,897,000
163,795,000
279,361,000
203,929,000
153,318,000
133,030,000
176,060,000
140,772,000
135,772,000
132,449,000
169,378,000
110,538,000
350,637,000
359,448,000
289,474,000
361,192,000
124,371,000
118,202,000
876,000
121,703,000
119,758,000
119,758,000121,703,000876,000118,202,000124,371,000361,192,000289,474,000359,448,000350,637,000110,538,000169,378,000132,449,000135,772,000140,772,000176,060,000133,030,000153,318,000203,929,000279,361,000163,795,000153,897,000137,851,000104,360,00098,971,00073,809,00055,957,00055,998,000
   > Long-term Assets 
0
0
0
0
0
0
2,759,625,000
2,775,797,000
2,841,358,000
0
2,783,375,000
2,835,547,000
2,912,749,000
0
3,077,617,000
0
3,116,281,000
0
3,711,495,000
3,790,984,000
3,891,319,000
3,820,536,000
3,841,033,000
3,814,045,000
3,862,549,000
3,902,049,000
4,056,990,000
4,056,990,0003,902,049,0003,862,549,0003,814,045,0003,841,033,0003,820,536,0003,891,319,0003,790,984,0003,711,495,00003,116,281,00003,077,617,00002,912,749,0002,835,547,0002,783,375,00002,841,358,0002,775,797,0002,759,625,000000000
       Property Plant Equipment 
0
644,030,000
673,930,000
711,858,000
725,398,000
1,118,292,000
1,143,109,000
1,153,315,000
1,176,594,000
1,171,339,000
1,184,512,000
1,164,988,000
1,189,828,000
1,213,714,000
1,246,145,000
1,259,219,000
1,270,397,000
1,391,332,000
1,450,932,000
1,507,572,000
1,609,000,000
1,607,047,000
1,636,927,000
1,655,598,000
1,714,565,000
1,759,878,000
1,877,458,000
1,877,458,0001,759,878,0001,714,565,0001,655,598,0001,636,927,0001,607,047,0001,609,000,0001,507,572,0001,450,932,0001,391,332,0001,270,397,0001,259,219,0001,246,145,0001,213,714,0001,189,828,0001,164,988,0001,184,512,0001,171,339,0001,176,594,0001,153,315,0001,143,109,0001,118,292,000725,398,000711,858,000673,930,000644,030,0000
       Goodwill 
352,545,000
338,082,000
341,595,000
346,458,000
326,351,000
0
336,606,000
0
346,192,000
0
340,096,000
0
329,064,000
0
335,209,000
0
338,313,000
0
341,111,000
0
337,741,000
0
296,778,000
0
265,017,000
0
262,555,000
262,555,0000265,017,0000296,778,0000337,741,0000341,111,0000338,313,0000335,209,0000329,064,0000340,096,0000346,192,0000336,606,0000326,351,000346,458,000341,595,000338,082,000352,545,000
       Long Term Investments 
156,791,000
127,984,000
125,772,000
129,276,000
127,352,000
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0000000000000000000000127,352,000129,276,000125,772,000127,984,000156,791,000
       Intangible Assets 
0
908,624,000
897,017,000
904,116,000
891,099,000
1,144,247,000
832,676,000
1,159,315,000
812,592,000
1,142,479,000
785,786,000
1,104,460,000
773,169,000
1,261,199,000
925,792,000
1,242,858,000
891,670,000
1,216,293,000
1,638,120,000
1,666,423,000
1,321,451,000
1,589,804,000
1,270,549,000
1,521,942,000
1,222,490,000
0
1,249,507,000
1,249,507,00001,222,490,0001,521,942,0001,270,549,0001,589,804,0001,321,451,0001,666,423,0001,638,120,0001,216,293,000891,670,0001,242,858,000925,792,0001,261,199,000773,169,0001,104,460,000785,786,0001,142,479,000812,592,0001,159,315,000832,676,0001,144,247,000891,099,000904,116,000897,017,000908,624,0000
       Other Assets 
0
105,632,000
72,729,000
79,764,000
100,244,000
223,455,000
332,119,000
336,224,000
388,878,000
326,663,000
308,994,000
293,807,000
341,797,000
304,640,000
279,531,000
306,880,000
291,030,000
310,953,000
341,048,000
339,368,000
340,633,000
336,352,000
297,945,000
0
0
0
0
0000297,945,000336,352,000340,633,000339,368,000341,048,000310,953,000291,030,000306,880,000279,531,000304,640,000341,797,000293,807,000308,994,000326,663,000388,878,000336,224,000332,119,000223,455,000100,244,00079,764,00072,729,000105,632,0000
> Total Liabilities 
1,675,644,000
1,584,189,000
1,579,025,000
1,647,756,000
1,627,316,000
2,042,186,000
2,656,393,000
2,825,972,000
2,836,342,000
2,911,443,000
2,809,800,000
2,747,410,000
2,870,751,000
2,966,559,000
3,056,486,000
2,963,310,000
2,971,017,000
3,071,628,000
3,515,356,000
3,637,198,000
3,690,703,000
3,697,335,000
3,646,118,000
3,421,458,000
3,389,671,000
3,330,572,000
3,506,791,000
3,506,791,0003,330,572,0003,389,671,0003,421,458,0003,646,118,0003,697,335,0003,690,703,0003,637,198,0003,515,356,0003,071,628,0002,971,017,0002,963,310,0003,056,486,0002,966,559,0002,870,751,0002,747,410,0002,809,800,0002,911,443,0002,836,342,0002,825,972,0002,656,393,0002,042,186,0001,627,316,0001,647,756,0001,579,025,0001,584,189,0001,675,644,000
   > Total Current Liabilities 
672,402,000
629,447,000
647,676,000
701,808,000
766,740,000
751,048,000
1,271,032,000
1,454,686,000
1,314,876,000
1,452,408,000
1,108,391,000
1,117,737,000
1,116,359,000
1,097,343,000
1,072,038,000
1,085,941,000
1,140,260,000
1,145,703,000
1,167,187,000
1,229,452,000
1,219,638,000
1,247,335,000
1,315,908,000
1,333,210,000
1,386,678,000
1,439,251,000
1,541,619,000
1,541,619,0001,439,251,0001,386,678,0001,333,210,0001,315,908,0001,247,335,0001,219,638,0001,229,452,0001,167,187,0001,145,703,0001,140,260,0001,085,941,0001,072,038,0001,097,343,0001,116,359,0001,117,737,0001,108,391,0001,452,408,0001,314,876,0001,454,686,0001,271,032,000751,048,000766,740,000701,808,000647,676,000629,447,000672,402,000
       Short-term Debt 
1,140,648,000
1,074,281,000
1,028,119,000
1,053,239,000
1,058,575,000
218,383,000
102,612,000
412,431,000
167,034,000
376,055,000
120,735,000
317,646,000
80,823,000
195,249,000
155,989,000
235,054,000
193,795,000
249,192,000
261,202,000
0
0
0
0
0
0
0
0
00000000261,202,000249,192,000193,795,000235,054,000155,989,000195,249,00080,823,000317,646,000120,735,000376,055,000167,034,000412,431,000102,612,000218,383,0001,058,575,0001,053,239,0001,028,119,0001,074,281,0001,140,648,000
       Short Long Term Debt 
1,140,648,000
1,074,281,000
1,028,119,000
1,053,239,000
1,058,575,000
0
186,471,000
412,431,000
265,398,000
0
247,868,000
317,646,000
192,296,000
0
155,989,000
0
193,795,000
0
174,136,000
262,763,000
139,762,000
225,645,000
167,009,000
262,083,000
209,539,000
361,515,000
297,870,000
297,870,000361,515,000209,539,000262,083,000167,009,000225,645,000139,762,000262,763,000174,136,0000193,795,0000155,989,0000192,296,000317,646,000247,868,0000265,398,000412,431,000186,471,00001,058,575,0001,053,239,0001,028,119,0001,074,281,0001,140,648,000
       Accounts payable 
273,660,000
268,537,000
298,518,000
304,215,000
301,979,000
0
267,212,000
294,583,000
250,199,000
272,472,000
274,995,000
301,101,000
278,721,000
0
298,625,000
0
292,741,000
0
333,554,000
343,933,000
328,946,000
361,185,000
360,453,000
367,843,000
351,325,000
382,085,000
395,892,000
395,892,000382,085,000351,325,000367,843,000360,453,000361,185,000328,946,000343,933,000333,554,0000292,741,0000298,625,0000278,721,000301,101,000274,995,000272,472,000250,199,000294,583,000267,212,0000301,979,000304,215,000298,518,000268,537,000273,660,000
       Other Current Liabilities 
161,056,000
145,717,000
196,708,000
233,198,000
207,511,000
0
281,584,000
747,672,000
676,290,000
803,881,000
45,350,000
317,743,000
595,000
0
32,597,000
0
626,000
0
572,431,000
622,756,000
590,934,000
660,505,000
46,765,000
421,745,000
7,006,000
435,191,000
64,747,000
64,747,000435,191,0007,006,000421,745,00046,765,000660,505,000590,934,000622,756,000572,431,0000626,000032,597,0000595,000317,743,00045,350,000803,881,000676,290,000747,672,000281,584,0000207,511,000233,198,000196,708,000145,717,000161,056,000
   > Long-term Liabilities 
0
0
0
0
0
0
1,215,045,000
1,148,368,000
1,271,619,000
0
1,451,832,000
1,448,332,000
1,531,653,000
0
1,750,806,000
0
1,576,950,000
0
2,071,104,000
2,126,947,000
2,182,251,000
2,188,135,000
2,070,961,000
2,088,248,000
2,002,993,000
1,891,321,000
1,965,172,000
1,965,172,0001,891,321,0002,002,993,0002,088,248,0002,070,961,0002,188,135,0002,182,251,0002,126,947,0002,071,104,00001,576,950,00001,750,806,00001,531,653,0001,448,332,0001,451,832,00001,271,619,0001,148,368,0001,215,045,000000000
       Long term Debt Total 
0
0
0
0
0
1,080,537,000
1,112,440,000
1,052,293,000
1,154,470,000
1,079,776,000
1,283,470,000
1,264,134,000
1,356,689,000
1,493,080,000
1,562,933,000
1,449,385,000
1,425,912,000
1,531,348,000
1,918,687,000
1,958,412,000
2,023,981,000
2,023,921,000
1,912,717,000
0
0
0
0
00001,912,717,0002,023,921,0002,023,981,0001,958,412,0001,918,687,0001,531,348,0001,425,912,0001,449,385,0001,562,933,0001,493,080,0001,356,689,0001,264,134,0001,283,470,0001,079,776,0001,154,470,0001,052,293,0001,112,440,0001,080,537,00000000
       Other Liabilities 
0
58,369,000
55,680,000
57,104,000
59,251,000
0
102,605,000
96,075,000
117,149,000
130,715,000
168,362,000
0
0
0
0
0
0
0
152,417,000
168,535,000
158,270,000
164,213,000
0
0
0
0
0
00000164,213,000158,270,000168,535,000152,417,0000000000168,362,000130,715,000117,149,00096,075,000102,605,000059,251,00057,104,00055,680,00058,369,0000
       Deferred Long Term Liability 
0
0
0
0
0
0
0
0
6,471,000
0
0
0
0
0
0
0
0
0
0
0
30,377,000
0
0
0
0
0
0
00000030,377,000000000000006,471,00000000000
> Total Stockholder Equity
0
674,563,000
679,258,000
695,691,000
714,175,000
913,746,000
699,833,000
688,287,000
771,448,000
609,902,000
593,393,000
597,070,000
589,527,000
592,034,000
601,874,000
658,630,000
665,543,000
681,532,000
728,530,000
741,199,000
775,629,000
768,667,000
774,843,000
790,854,000
820,188,000
883,067,000
870,974,000
870,974,000883,067,000820,188,000790,854,000774,843,000768,667,000775,629,000741,199,000728,530,000681,532,000665,543,000658,630,000601,874,000592,034,000589,527,000597,070,000593,393,000609,902,000771,448,000688,287,000699,833,000913,746,000714,175,000695,691,000679,258,000674,563,0000
   Retained Earnings 
0
510,668,000
0
0
0
913,746,000
199,147,000
0
135,586,000
609,902,000
566,115,000
0
562,067,000
592,034,000
574,414,000
0
637,593,000
681,532,000
0
0
87,494,000
0
746,266,000
0
114,706,000
0
0
00114,706,0000746,266,000087,494,00000681,532,000637,593,0000574,414,000592,034,000562,067,0000566,115,000609,902,000135,586,0000199,147,000913,746,000000510,668,0000
   Accumulated Other Comprehensive Income 000000000000000000000000000
   Capital Surplus 000000000000000000000000000
   Treasury Stock000000000000000000000000000



6.3. Balance Sheets

Currency in INR. All numbers in thousands.




6.4. Cash Flows

Currency in INR. All numbers in thousands.




6.5. Income Statements

Currency in INR. All numbers in thousands.


6.6. Latest Income Statement

Income Statement (annual), 2024-03-31. Currency in INR. All numbers in thousands.

Gross Profit (+$)
totalRevenue1,499,824,000
Cost of Revenue-535,521,000
Gross Profit964,303,000964,303,000
 
Operating Income (+$)
Gross Profit964,303,000
Operating Expense-1,100,952,000
Operating Income398,872,000-136,649,000
 
Operating Expense (+$)
Research Development0
Selling General Administrative85,679,000
Selling And Marketing Expenses0
Operating Expense1,100,952,00085,679,000
 
Net Interest Income (+$)
Interest Income6,493,000
Interest Expense-159,559,000
Other Finance Cost-30,022,000
Net Interest Income-183,088,000
 
Pretax Income (+$)
Operating Income398,872,000
Net Interest Income-183,088,000
Other Non-Operating Income Expenses0
Income Before Tax (EBT)126,790,000398,872,000
EBIT - interestExpense = -159,559,000
74,670,000
234,229,000
Interest Expense159,559,000
Earnings Before Interest and Taxes (EBIT)0286,349,000
Earnings Before Interest and Taxes (EBITDA)0
 
After tax Income (+$)
Income Before Tax126,790,000
Tax Provision-41,210,000
Net Income From Continuing Ops85,580,00085,580,000
Net Income74,670,000
Net Income Applicable To Common Shares0
 
Non-recurring Events
Discontinued Operations0
Extraordinary Items0
Effect of Accounting Charges0
Other Items0
Non Recurring0
Other Operating Expenses0
Total Other Income/Expenses Net0183,088,000
 

Technical Analysis of Airtel
The psychology behind the price

Technical indicators reflecting market sentiment and the collective psychology of you and other traders. Your emotions and other traders' emotions, such as fear and greed, play a significant role in driving price movements.

General trend

First of all, I'm going to put something in the back of your mind. One of the most stable factors that gives you more confidence as a trader: the general trend of Airtel. The general trend of Airtel is UNKNOWN with 0.0% confidence. It is very important for your mental being to use each indicator with this in mind. But beware, also the general trend flips once in a while! You can use moving averages to determine Airtel's overall trend. For convenience I use the most commonly used moving averages: 20, 50, 100 & 200. Of course you can use other moving averages or other indicators to determine the trend.

Indicator phases

Some of the indicators I use have 3 zones: overbought, oversold and neutral. Transitions between these zones (market phases) provide valuable trading signals and insights. Expecially with the general trend mind, I use the highlighted phases:

Indicator StateBullish trend Bearish trend
Overbought to neutralBullish pullback=Bearish reversal
Upper to lower neutralBullish correction=Bearish continuation
Nuetral to oversoldOversold=Oversold
Oversold to neutralBullish reversal=Bearish correction
Lower to upper neutralBullish continuation=Bearish pullback
Nuetral to overboughtOverbought=Overbought

1. Price Targets

1.1 Support & Resistance

Support and resistance are levels on a price chart that act as barriers or zones where the price of an asset tends to stop, reverse, or experience a significant amount of buying or selling pressure.

Support is a price level at which demand for an asset is strong enough to prevent the price from falling further.
Resistance is a price level at which selling pressure becomes significant enough to prevent the price of an asset from rising further.


Score

Let's take a look at the Support & Resistance of BHARTI AIRTEL LTD..

The long score for the Support & Resistance is 0/1.
The longshort score for the Support & Resistance is -1/(-1 +1).

  • Around resistance: The price is trading arround resistance levels. This can be considered as a potential exit level. -1

The bullish price targets are: 1,600 < 1,742 < 1,779.

The bearish price targets are: 1,522 > 1,512 > 1,511.

Tweet this
BHARTI AIRTEL LTD. Daily Support & Resistance Chart

2. Trend Indicators

2.1 Moving Averages

Shows the moving average of the selected period.

  • Moving averages are lagging trend indicators.
  • There are many types of moving averages.
  • Moving averages are also used within other indicators.

Score

Let's take a look at the Moving Averages of BHARTI AIRTEL LTD.. The current mas is .

Directionalities and relatives.

Moving AverageAmount of candlesTrendPrice +/-vs. MA 50vs. MA 100vs. MA 200

Explanation: https://www.youtube.com/watch?v=xwW8h0lrQ-I

BHARTI AIRTEL LTD. Daily Moving Averages Chart
2.2 Moving Average Convergence/Divergence (MACD)

Shows the momentum of the selected period based on two moving averages.

  • MACD is a lagging momentum indicator.
  • Uses two moving averages.
  • Can show buy or sell signals based on momentum.
  • Can show overbought. and oversold. levels.

Score

Let's take a look at the Moving Average Convergence/Divergence (MACD) of BHARTI AIRTEL LTD..

BHARTI AIRTEL LTD. Daily Moving Average Convergence/Divergence (MACD) ChartBHARTI AIRTEL LTD. Daily Moving Average Convergence/Divergence (MACD) Chart
2.3 Directional Movement Index (DMI)

The DMI is a collection of 3 indicators: +DI (Plus Direction Indicator), -DI (Minus Direction Indicator) and ADX (Average Directional Index). The ADX helps you determine the strength of a trend.


Score

Let's take a look at the Directional Movement Index (DMI) of BHARTI AIRTEL LTD.. The current adx is .

BHARTI AIRTEL LTD. Daily Directional Movement Index (DMI) Chart
2.4 Parabolic SAR

Shows the current trend and potential entry and exit signals.

  • Parabolic SAR (stop and reverse) is a lagging trend indicator.
  • Shows the current trend.
  • Shows potential entry signals.
  • Shows  potential exit signals.
  • Can be used to place trailing stoplosses..

Score

Let's take a look at the Parabolic SAR of BHARTI AIRTEL LTD..

BHARTI AIRTEL LTD. Daily Parabolic SAR Chart
3rd party ad coffee SUPPORTERis ad-free.

3. Momentum Indicators

3.1 Relative Strength Index (RSI)

Measures the speed and change of price movements.

  • Leading momentum indicator, meaning the signals are instant.
  • Ranges between 0 and 100.
  • Above 70 is considered overbought.
  • Below 30 is considered oversold.
  • Above or below 50 can also be used to determine price trend or support and resistance.
  • RSI divergence looks at a deviation between RSI and price movement. Penketrading automatically calculates RSI divergences.
  • Can be used in many different ways

Score

Let's take a look at the Relative Strength Index (RSI) of BHARTI AIRTEL LTD..

BHARTI AIRTEL LTD. Daily Relative Strength Index (RSI) ChartBHARTI AIRTEL LTD. Daily Relative Strength Index (RSI) Chart
3.2 Stochastic Oscillator

Compares a certain price to multiple prices ranging over time.

  • Leading momentum indicator, meaning the signals are instant.
  • Used to determine overbought and oversold areas much like the RSI.
  • Ranges between 0 and 100.
  • Above 80 is considered overbought.
  • Below 20 is considered oversold.
  • Consists of two lines named K and D.
  • K compares the highest high and lowest low on the selected price range.
  • The D line is a moving average of the K line.
  • Can be used to spot divergences

Score

Let's take a look at the Stochastic Oscillator of BHARTI AIRTEL LTD..

BHARTI AIRTEL LTD. Daily Stochastic Oscillator ChartBHARTI AIRTEL LTD. Daily Stochastic Oscillator Chart
3.3 Commodity Channel Index (CCI)

Measures the difference between the current price and the historical average price.

  • Lagging or leading Momentum indicator
  • When the CCI is above zero, the price is above the historical average
  • When the CCI is below zero, the price is below the historical average
  • Used for spotting trends
    • If the CCI moves from negative or near zero to positive 100 that might indicate an uptrend
    • If the CCI moves from positive or near zero to negative -100 that might indicate a downtrend

Score

Let's take a look at the Commodity Channel Index (CCI) of BHARTI AIRTEL LTD..

BHARTI AIRTEL LTD. Daily Commodity Channel Index (CCI) ChartBHARTI AIRTEL LTD. Daily Commodity Channel Index (CCI) Chart
3.4 Chande Momentum Oscillator (CMO)

Measures the difference between the sum of recent gains and the sum of recent losses. Then divides the result by the sum of all price movements in that period.

  • Lagging momentum indicator
  • Ranges between +100 and -100
  • Considered overbought above +50
  • Considered oversold below -50
  • It's possible to add a moving average that acts as a signal line

Score

Let's take a look at the Chande Momentum Oscillator (CMO) of BHARTI AIRTEL LTD..

BHARTI AIRTEL LTD. Daily Chande Momentum Oscillator (CMO) ChartBHARTI AIRTEL LTD. Daily Chande Momentum Oscillator (CMO) Chart
3.5 Williams %R

 Shows the current price relative to the highest high over the last 14 days.
 

  • Lagging momentum indicator
  • Ranging between 0 and -100
  • Above -20 is considered overbought
  • Below -80 is considered oversold
  • Is prone to give false signals

Score

Let's take a look at the Williams %R of BHARTI AIRTEL LTD..

BHARTI AIRTEL LTD. Daily Williams %R ChartBHARTI AIRTEL LTD. Daily Williams %R Chart
3rd party ad coffee SUPPORTERis ad-free.

4. Volatility Indicators

4.1 Bollinger Bands

Shows if the price is to high or to low relative to an average.

  • Lagging volatility indicator
  • Uses 3 bands: one upper, one lower and one in the middle
  • Works best when the middle band reflects an intermediate trend (MA20).
  • When the price is moving closer to the upper band, the market might be overbought
  • When the price is moving closer to the lower band, the market might be oversold 

Score

Let's take a look at the Bollinger Bands of BHARTI AIRTEL LTD..

BHARTI AIRTEL LTD. Daily Bollinger Bands Chart
4.2 Average True Range (ATR)
Measures market volatility
  • Leading volatility indicator
  • Can be used to determine stop-loss positions
  • Calculated by:
    • Current high minus the current low
    • Current high minus the previous close
    • Current low minus the previous close
  • The larger the range of the candles, the greater the ATR value

Score

Let's take a look at the Average True Range (ATR) of BHARTI AIRTEL LTD..

BHARTI AIRTEL LTD. Daily Average True Range (ATR) ChartBHARTI AIRTEL LTD. Daily Average True Range (ATR) Chart
3rd party ad coffee SUPPORTERis ad-free.

5. Volume Indicators

5.1 On-Balance Volume (OBV)

 Measures market volatility

  • Leading momentum indicator
  • Calculation:
    • If the closing price is above the previous closing price: OBV = previous OBV + current volume
    • If the closing price is below the previous closing price: OBV = previous OBV - current volume
    • If the closing price is the same as the previous closing price than the OBV is the same.
  • Can be used to confirm price trends
  • Can be used with divergences

Score

Let's take a look at the On-Balance Volume (OBV) of BHARTI AIRTEL LTD..

BHARTI AIRTEL LTD. Daily On-Balance Volume (OBV) ChartBHARTI AIRTEL LTD. Daily On-Balance Volume (OBV) Chart
5.2 Money Flow Index (MFI)

Measures the flow of money in and out of a security

  • Lagging momentum indicator
  • Looks like RSI but uses volume as an extra metric (RSI only considers price)
  • Above 80 is considered overbought
  • Below 20 is considered oversold
  • Can be used with divergences

Score

Let's take a look at the Money Flow Index (MFI) of BHARTI AIRTEL LTD..

BHARTI AIRTEL LTD. Daily Money Flow Index (MFI) ChartBHARTI AIRTEL LTD. Daily Money Flow Index (MFI) Chart
3rd party ad coffee SUPPORTERis ad-free.

6. Summary

6.1. Notifications

TypeNotificationDate
PenkeCurrently no notifications for BHARTI AIRTEL LTD..

6.2. Trading Signals

Below you will find trading signals as the indicator is commonly used. This doesn't mean you should use it that way. Learn from these, but don't use them blindly. I recommend using at least 4 indicators, 1 from each category: trend, momentum, volatility and volume.

DateIndicatorSignal
2024-07-11STOCH LONG EXITThe %K line crosses below the %D line.
2024-07-12WILLR SHORT ENTRY LONG CLOSE-80 crossover to downside
2024-07-16STOCH SHORT EXITThe %K line crosses above the %D line.
CCI LONG ENTRY SHORT CLOSE100 crossover to upside
2024-07-18MACD LONG ENTRY SHORT CLOSEThe MACD line crosses above the signal line.
BB SHORT ENTRY LONG CLOSEPrice closed above the lower band.
2024-07-24MACD SHORT ENTRY LONG CLOSEThe MACD line crosses below the signal line.
STOCH LONG EXITThe %K line crosses below the %D line.
2024-07-26MACD LONG ENTRY SHORT CLOSEThe MACD line crosses above the signal line.
SAR LONG ENTRY SHORT CLOSEThe price broke the SAR to the upside.
STOCH SHORT EXITThe %K line crosses above the %D line.
CCI LONG ENTRY SHORT CLOSE100 crossover to upside
WILLR LONG ENTRY SHORT CLOSE-20 crossover to upside
BB SHORT ENTRY LONG CLOSEPrice closed above the lower band.
ATR LONG ENTRY SHORT CLOSEPrice closed above (close + ATR).
2024-07-29STOCH LONG EXITThe %K line crosses below the %D line.
2024-07-31STOCH SHORT EXITThe %K line crosses above the %D line.
CCI LONG ENTRY SHORT CLOSE100 crossover to upside
2024-08-01WILLR LONG ENTRY SHORT CLOSE-20 crossover to upside
2024-08-02STOCH LONG EXITThe %K line crosses below the %D line.
2024-08-05MACD SHORT ENTRY LONG CLOSEThe MACD line crosses below the signal line.
CMO SHORT ENTRY LONG CLOSEZero line crossover to downside
2024-08-06SAR SHORT ENTRY LONG CLOSEThe price broke the SAR to the downside
WILLR SHORT ENTRY LONG CLOSE-80 crossover to downside
2024-08-08STOCH SHORT EXITThe %K line crosses above the %D line.
2024-08-09CMO LONG ENTRY SHORT CLOSEZero line crossover to upside
2024-08-12CMO SHORT ENTRY LONG CLOSEZero line crossover to downside
2024-08-13STOCH LONG EXITThe %K line crosses below the %D line.
2024-08-14STOCH SHORT EXITThe %K line crosses above the %D line.
CMO LONG ENTRY SHORT CLOSEZero line crossover to upside
2024-08-19STOCH LONG EXITThe %K line crosses below the %D line.
2024-08-20DMI SHORT ENTRY LONG CLOSEThe +DI crossed the -DI to the downside. The trend is reversing to a down trend.
CMO SHORT ENTRY LONG CLOSEZero line crossover to downside
2024-08-21STOCH SHORT EXITThe %K line crosses above the %D line.
2024-08-22DMI LONG ENTRY SHORT CLOSEThe +DI crossed the -DI to the upside. The trend is reversing to an up trend.
SAR LONG ENTRY SHORT CLOSEThe price broke the SAR to the upside.
CMO LONG ENTRY SHORT CLOSEZero line crossover to upside
2024-08-23MACD LONG ENTRY SHORT CLOSEThe MACD line crosses above the signal line.
CCI LONG ENTRY SHORT CLOSE100 crossover to upside
WILLR LONG ENTRY SHORT CLOSE-20 crossover to upside
2024-08-27BB SHORT ENTRY LONG CLOSEPrice closed above the lower band.
MFI LONG ENTRY SHORT CLOSE80 crossover to upside
2024-08-28STOCH LONG EXITThe %K line crosses below the %D line.
ATR LONG ENTRY SHORT CLOSEPrice closed above (close + ATR).
2024-08-29STOCH SHORT EXITThe %K line crosses above the %D line.
2024-08-30STOCH LONG EXITThe %K line crosses below the %D line.
2024-09-02RSI SHORT ENTRY LONG CLOSE70 crossover to downside
2024-09-05MFI SHORT ENTRY LONG CLOSE80 crossover to downside
2024-09-06SAR SHORT ENTRY LONG CLOSEThe price broke the SAR to the downside
2024-09-10STOCH SHORT EXITThe %K line crosses above the %D line.
ATR LONG ENTRY SHORT CLOSEPrice closed above (close + ATR).
2024-09-12SAR LONG ENTRY SHORT CLOSEThe price broke the SAR to the upside.
CCI LONG ENTRY SHORT CLOSE100 crossover to upside
WILLR LONG ENTRY SHORT CLOSE-20 crossover to upside
BB SHORT ENTRY LONG CLOSEPrice closed above the lower band.
ATR LONG ENTRY SHORT CLOSEPrice closed above (close + ATR).
2024-09-16STOCH LONG EXITThe %K line crosses below the %D line.
2024-09-17STOCH SHORT EXITThe %K line crosses above the %D line.
2024-09-18STOCH LONG EXITThe %K line crosses below the %D line.
2024-09-20STOCH SHORT EXITThe %K line crosses above the %D line.
WILLR LONG ENTRY SHORT CLOSE-20 crossover to upside
BB SHORT ENTRY LONG CLOSEPrice closed above the lower band.
ATR LONG ENTRY SHORT CLOSEPrice closed above (close + ATR).
2024-09-23ATR LONG ENTRY SHORT CLOSEPrice closed above (close + ATR).
2024-09-24STOCH LONG EXITThe %K line crosses below the %D line.
MFI LONG ENTRY SHORT CLOSE80 crossover to upside
2024-09-25STOCH SHORT EXITThe %K line crosses above the %D line.
2024-09-27STOCH LONG EXITThe %K line crosses below the %D line.
2024-09-30RSI SHORT ENTRY LONG CLOSE70 crossover to downside
MFI SHORT ENTRY LONG CLOSE80 crossover to downside
2024-10-01MACD SHORT ENTRY LONG CLOSEThe MACD line crosses below the signal line.
SAR SHORT ENTRY LONG CLOSEThe price broke the SAR to the downside
2024-10-03CMO SHORT ENTRY LONG CLOSEZero line crossover to downside
2024-10-04WILLR SHORT ENTRY LONG CLOSE-80 crossover to downside
2024-10-07STOCH SHORT EXITThe %K line crosses above the %D line.
2024-10-08DMI SHORT ENTRY LONG CLOSEThe +DI crossed the -DI to the downside. The trend is reversing to a down trend.
2024-10-09CMO LONG ENTRY SHORT CLOSEZero line crossover to upside
2024-10-14DMI LONG ENTRY SHORT CLOSEThe +DI crossed the -DI to the upside. The trend is reversing to an up trend.
2024-10-15SAR LONG ENTRY SHORT CLOSEThe price broke the SAR to the upside.
2024-10-17STOCH LONG EXITThe %K line crosses below the %D line.
2024-10-18DMI SHORT ENTRY LONG CLOSEThe +DI crossed the -DI to the downside. The trend is reversing to a down trend.
STOCH SHORT EXITThe %K line crosses above the %D line.
2024-10-21STOCH LONG EXITThe %K line crosses below the %D line.
2024-10-23CMO SHORT ENTRY LONG CLOSEZero line crossover to downside
2024-10-28WILLR SHORT ENTRY LONG CLOSE-80 crossover to downside
2024-10-29SAR SHORT ENTRY LONG CLOSEThe price broke the SAR to the downside
CCI SHORT ENTRY LONG CLOSE-100 crossover to downside
2024-10-30WILLR SHORT ENTRY LONG CLOSE-80 crossover to downside
2024-10-31BB LONG ENTRY SHORT CLOSEPrice closed below the lower band.
MFI SHORT ENTRY LONG CLOSE20 crossover to downside
2024-11-04STOCH SHORT EXITThe %K line crosses above the %D line.
BB LONG ENTRY SHORT CLOSEPrice closed below the lower band.
2024-11-05STOCH LONG EXITThe %K line crosses below the %D line.
2024-11-06STOCH SHORT EXITThe %K line crosses above the %D line.
MFI LONG ENTRY SHORT CLOSE20 crossover to upside
2024-11-07STOCH LONG EXITThe %K line crosses below the %D line.
WILLR SHORT ENTRY LONG CLOSE-80 crossover to downside
2024-11-14STOCH SHORT EXITThe %K line crosses above the %D line.
2024-11-18STOCH LONG EXITThe %K line crosses below the %D line.
2024-11-21STOCH SHORT EXITThe %K line crosses above the %D line.
2024-11-22SAR LONG ENTRY SHORT CLOSEThe price broke the SAR to the upside.
RSI LONG ENTRY SHORT CLOSE30 crossover to upside
ATR LONG ENTRY SHORT CLOSEPrice closed above (close + ATR).
2024-11-25MACD LONG ENTRY SHORT CLOSEThe MACD line crosses above the signal line.
CMO LONG ENTRY SHORT CLOSEZero line crossover to upside
2024-11-28STOCH LONG EXITThe %K line crosses below the %D line.
CMO SHORT ENTRY LONG CLOSEZero line crossover to downside
2024-11-29DMI LONG ENTRY SHORT CLOSEThe +DI crossed the -DI to the upside. The trend is reversing to an up trend.
STOCH SHORT EXITThe %K line crosses above the %D line.
CCI LONG ENTRY SHORT CLOSE100 crossover to upside
CMO LONG ENTRY SHORT CLOSEZero line crossover to upside
WILLR LONG ENTRY SHORT CLOSE-20 crossover to upside
BB SHORT ENTRY LONG CLOSEPrice closed above the lower band.
ATR LONG ENTRY SHORT CLOSEPrice closed above (close + ATR).

6.3. Candlestick Patterns

BHARTI AIRTEL LTD. Daily Candlestick Chart
DateCandlestick Pattern

6.4. Technical Score

Let's check the technical score of BHARTI AIRTEL LTD. based on Penke's default Symbol scanner.

Penke's Symbol Scanner

  
  
IndicatorConditionValue
OpenGreater thanClose1,629.450
Total0/1 (0.0%)
Penke
Good job! You gained 25 XP and 0   0   10 . What's next:
  • Share my analysis of Airtel with someone you think should read this too:
  • Are you bullish or bearish on Airtel? Let me know what you think in the comments.
  • Do you want an email if I find something interesting about Airtel? Add an email alert using the form below.
  • Join the community if you want to keep your earnings and track your progress: Join the community
  • Is this analysis useful to you? Support me via But Me a Coffee. I'll analyze the stock market faster for you!

Get notifications about BHARTI AIRTEL LTD.

I send you an email if I find something interesting about BHARTI AIRTEL LTD..


Comments

How you think about this?

Leave a comment

Stay informed about BHARTI AIRTEL LTD..

Receive notifications about BHARTI AIRTEL LTD. in your mailbox!

3rd party ad coffee SUPPORTERis ad-free.