BHARTIARTL Analysis

Stock Data

    Balance Sheet Analysis

    Detailed yearly balance sheet data for BHARTIARTL in the Telecomm-Service sector.

    Data Table

    Mar 2013Mar 2014Mar 2015Mar 2016Mar 2017Mar 2018Mar 2019Mar 2020Mar 2021Mar 2022Mar 2023Mar 2024Sep 2024
    Equity Capital1,8991,9991,9991,9991,9991,9991,9992,7282,7462,7952,8372,8772,896
    Reserves48,42357,75737,77864,77165,45867,53669,42474,41756,20763,75974,72679,14284,202
    Borrowings66,73675,89683,415100,646107,288111,334125,428148,228162,785169,678226,020215,592225,541
    Other Liabilities40,91245,84058,74757,05657,57868,65377,176133,718122,679124,975140,974144,408148,344
    Total Liabilities157,970181,492181,939224,472232,322249,521274,026359,091344,417361,207444,557442,019460,982
    Fixed Assets125,674140,614124,279172,293178,235187,200200,832229,256223,480244,083277,394303,303330,199
    CWIP2,992-017,4155,70210,8389,7519,6344,2825,7265,95549,42516,9048,753
    Investments7,71015,53110,75211,97714,33916,15915,71125,47627,55029,34932,95431,60234,438
    Other Assets21,59425,34729,49434,50028,91036,41147,850100,07787,66181,82084,78490,21087,592
    Total Assets157,970181,492181,939224,472232,322249,521274,026359,091344,417361,207444,557442,019460,982

    Cash Flow Analysis

    Detailed yearly cash flow data for BHARTIARTL in the Telecomm-Service sector.

    Data Table

    Mar 2013Mar 2014Mar 2015Mar 2016Mar 2017Mar 2018Mar 2019Mar 2020Mar 2021Mar 2022Mar 2023Mar 2024
    Cash from Operating Activity22,60826,23328,05927,94228,28029,85420,07018,12948,20555,01765,32578,898
    Cash from Investing Activity-18,676-25,181-22,301-14,091-30,680-27,940-28,286-29,598-27,286-41,478-39,232-51,089
    Cash from Financing Activity-4,5662,774-9,672-11,946-3511,9209,46419,144-24,910-15,203-24,470-27,778
    Net Cash Flow-6343,826-3,9141,905-2,7523,8351,2487,675-3,991-1,6641,62331

    Operational and Efficiency Metrics Analysis

    Yearly operational and efficiency metrics for BHARTIARTL in the Telecomm-Service sector.

    Data Table

    Mar 2013Mar 2014Mar 2015Mar 2016Mar 2017Mar 2018Mar 2019Mar 2020Mar 2021Mar 2022Mar 2023Mar 2024
    Debtor Days322720211826191913131012
    Inventory Days
    Days Payable
    Cash Conversion Cycle322720211826191913131012
    Working Capital Days-98-105-172-139-150-200-189-257-172-154-155-161
    ROCE %7%10%11%13%10%7%3%5%7%11%12%13%

    Peer Comparison

    List of Companies that are in the same sector as the BHARTIARTL stock which is the Telecomm-Service sector

    Data Table

    NameCMP Rs.P/EMar Cap Rs.Cr.Div Yld %NP Qtr Rs.Cr.Qtr Profit Var %Sales Qtr Rs.Cr.Qtr Sales Var %ROCE %
    Bharti Airtel1715.5551.421.0282e+060.4716134.6230.7145129.319.0813.13
    Bharti Hexacom1432.568.18716250.28260.952.192250.72513.98
    Vodafone Idea7.0950617.70-6609.314.6211117.34.16-3.61
    Tata Comm1547.3539.6144099.51.08236.08893.335798.073.7617.55
    Tata Tele Mah55.110771.60-315.11-2.41332.7712.4147.91
    Railtel Corpn284.932.759143.54165.05-3.79767.6214.8520.25
    Nazara Technolo969.55118.888494.83013.68-46.04534.6966.885.53

    Yearly Financial Profit & Loss Analysis

    Detailed yearly financial data for BHARTIARTL in the Telecomm-Service sector.

    Data Table

    Mar 2013Mar 2014Mar 2015Mar 2016Mar 2017Mar 2018Mar 2019Mar 2020Mar 2021Mar 2022Mar 2023Mar 2024TTM
    Sales76,94785,86496,10196,53295,46882,63980,78087,539100,616116,547139,145149,982162,708
    Expenses53,98759,35262,49962,54860,13852,56055,01650,93055,33759,01367,87171,69177,193
    Operating Profit22,96026,51233,60233,98435,33030,07925,76436,61045,27957,53471,27478,29285,515
    OPM %30%31%35%35%37%36%32%42%45%49%51%52%53%
    Other Income1,1592,8811,2434,8581,7131,7564,474-37,775-4,2154,6561,019-3,42810,852
    Exceptional items2984242722,072-1,302-8072,739-40,362-4,8581,699-670-7,572
    Other income normal8612,4579712,7863,0152,5641,7352,5876432,9581,6894,145
    Interest4,5195,8794,4468,5469,5479,32610,62213,99215,09116,61619,30022,64821,455
    Depreciation14,81515,65019,85817,45019,77319,24321,34827,69029,40433,09136,43239,53843,320
    Profit before tax4,7857,86410,54012,8467,7233,267-1,732-42,846-3,43212,48316,56112,67931,593
    Tax %53%62%52%46%45%33%-197%-28%260%33%26%32%
    Net Profit2,2673,0195,0486,8934,2412,1841,688-30,664-12,3648,30512,2878,55827,074
    EPS in Rs4.325.048.4111.056.912.000.74-55.06-25.637.2314.9713.2043.23
    Dividend Payout %17%26%33%9%11%194%244%-3%-0%39%27%62%

    Financial Performance Quarterly Report Analysis

    Detailed quarterly financial data for BHARTIARTL in the Telecomm-Service sector.

    Data Table

    Dec 2021Mar 2022Jun 2022Sep 2022Dec 2022Mar 2023Jun 2023Sep 2023Dec 2023Mar 2024Jun 2024Sep 2024Dec 2024
    Sales29,86731,50032,80534,52735,80436,00937,44037,04437,90037,59938,50641,47345,129
    Expenses15,16415,46016,27516,93317,72017,31217,84217,53018,08518,23418,79919,62720,533
    Operating Profit14,70316,04016,52917,59418,08518,69719,59819,51419,81519,36519,70821,84624,597
    OPM %49%51%50%51%51%52%52%53%52%52%51%53%54%
    Other Income8531,638355559-412886-2,478-6541,013-1,3082,0104759,675
    Interest4,3674,0594,5114,9404,6865,1635,6145,1866,6455,2035,1525,4245,676
    Depreciation8,5478,5838,7818,9479,2989,4069,6549,73410,07410,07510,54011,00011,704
    Profit before tax2,6425,0373,5924,2653,6895,0141,8533,9404,1082,7786,0255,89716,892
    Tax %38%26%31%30%29%16%18%47%30%26%22%30%4%
    Net Profit1,6513,7152,4692,9792,6144,2261,5202,0932,8762,0684,7184,15316,135
    EPS in Rs1.413.412.733.862.855.392.892.394.343.667.316.3125.95

    Quarterly Shareholding Pattern Analysis

    Shareholding pattern trends for BHARTIARTL in the Telecomm-Service sector.

    Data Table

    Mar 2022Jun 2022Sep 2022Dec 2022Mar 2023Jun 2023Sep 2023Dec 2023Mar 2024Jun 2024Sep 2024Dec 2024
    Promoters55.93%55.93%55.14%55.12%55.02%54.97%54.75%54.57%53.48%53.17%53.14%53.12%
    FIIs19.36%18.54%21.87%21.70%20.97%21.48%21.87%22.69%24.35%24.62%25.07%24.27%
    DIIs19.50%20.22%18.76%19.02%19.78%19.55%19.69%19.51%19.20%19.13%18.69%19.52%
    Government0.00%0.00%0.12%0.12%0.12%0.12%0.12%0.12%0.12%0.12%0.12%0.12%
    Public5.16%5.26%4.06%4.00%4.05%3.82%3.53%3.07%2.80%2.89%2.89%2.91%
    Others0.05%0.05%0.04%0.05%0.05%0.05%0.04%0.06%0.05%0.06%0.07%0.07%
    No of Shareholders7,67,5787,86,1697,79,9967,54,9617,58,7157,09,9526,85,5296,77,6906,94,2977,62,2667,84,9308,36,095

    Yearly Shareholding Pattern Analysis

    Yearly shareholding pattern trends for BHARTIARTL in the Telecomm-Service sector.

    Data Table

    Mar 2017Mar 2018Mar 2019Mar 2020Mar 2021Mar 2022Mar 2023Mar 2024Dec 2024
    Promoters67.14%67.14%67.14%58.98%55.86%55.93%55.02%53.48%53.12%
    FIIs15.22%18.45%17.61%20.29%18.57%19.36%20.97%24.35%24.27%
    DIIs11.15%12.38%13.25%15.83%20.35%19.50%19.78%19.20%19.52%
    Government0.00%0.00%0.00%0.00%0.00%0.00%0.12%0.12%0.12%
    Public6.46%1.99%2.00%4.87%5.16%5.16%4.05%2.80%2.91%
    Others0.03%0.04%0.00%0.04%0.06%0.05%0.05%0.05%0.07%
    No of Shareholders2,12,2381,93,6631,86,2382,30,5287,13,8667,67,5787,58,7156,94,2978,36,095

Please Log In to Chat

Chat

Welcome! Let's analyze BHARTIARTL. Here's a sample stock chart:

Chart
Page: 1