Sharescart Research Club logo
Products
Research
Tools
About
ChatGPT Claude Perplexity
Summarize with
ChatGPT Claude Perplexity
Join Channel
Apollo Green₹ 72 (28.6%)ASK Investment₹ 895 (-3.2%)AVPL ₹ 49 (0%)Bootes Impex₹ 775 (-8.8%)CIAL ₹ 442 (-0.5%)CSK ₹ 254 (-3.1%)ESDS Software₹ 478 (2.8%)Garuda Aerospace₹ 468 (-2.1%)Goodluck Defence₹ 385 (16%)Hero Motors₹ 325 (0%)Hinduja Leyland₹ 248 (0%)ICL Fincorp₹ 25 (0%)Incred Holdings₹ 154 (2.7%)Kineco Limited₹ 3285 (0%)Lava ₹ 60 (15.4%)Market Simplified₹ 26 (-7.1%)Matrix Gas₹ 12 (-20%)Motilal Oswal₹ 12.25 (-2%)MSEI ₹ 6.35 (-2.3%)NCDEX ₹ 368 (-1.6%)NSE ₹ 1985 (-2%)Onix Renewable₹ 68 (21.4%)OYO ₹ 23 (-4.2%)OYO Assets₹ 9.25 (-7%)Philips India₹ 1250 (0%)Polymatech Electronics₹ 56 (-3.4%)SBI Mutual₹ 768 (-0.9%)Taparia Tools₹ 6050 (0%)VCI Chemical₹ 64 (0%)Zepto ₹ 40 (-4.8%)

15 Days Price Change

Bharti Hexacom Ltd. IPO

Closing In

  • days
  • Hours
  • Minutes
  • Seconds
Profile
Issue Size --
Profile
Price Range 542  to  570 per share
Profile
Min Investment ₹570
Profile
Lot Size 1
Profile
Face Value ₹5
Profile
Draft Prospectus --
Invest Before the IPO Goes Live

Buy unlisted shares early and participate in the growth before public listing.

Profile
  • Basic Info
  • IPO Tentative Timetable
  • IPO Lot Size
  • Subscription Status
  • Financials
  • Profit & Loss
  • Balance Sheet
  • Cash Flow
  • Ratios
  • Growth Rates
  • Other info

Overview

Bharti Hexacom Limited is a telecommunications company operating primarily in India. Established as a joint venture between Bharti Enterprises and the Government of India, it provides mobile, broadband, and enterprise services under the Airtel brand. Bharti Hexacom plays a significant role in expanding telecommunication infrastructure, offering voice and data services to both urban and rural areas. With a focus on innovation and customer satisfaction, the company has contributed to India's digital transformation, connecting millions of people across the country. Its robust network and diverse services cater to individual consumers, businesses, and government organizations, driving connectivity and socio-economic development. Read More

Basic Info

Face Value 5 per share

Price 542  to  570 per share

P/E (x) 19.1

Sales( Cr.) 8548

PAT( Cr.) 1494

EPS 29.9

Draft Prospectus --

Exchange BSE-NSE

Promoter

Company Promoters

Bharti Airtel Limited

Pre Issue Share Holding 100%

Post Issue Share Holding 27.37%

Listing Details:

Listing Price: 755.2

Listing Gain: 24.52%

Current Price: 1495.5

Gain On Issue: 1495.5 | 0%

GMP: --

GMP %: -- %

IPO Tentative Timetable

Opening Date Apr 03, 2024
Closing Date Apr 05, 2024
Allotment Apr 08, 2024
Refund Apr 09, 2024
Delivery of Shares Apr 09, 2024
Listing Date Apr 10, 2024

IPO Lot Size

Application Lots Shares Amount
Retail (Min) 1 26 14,820
Retail (Max) 13 338 192,660
S-HNI (Min) 14 364 207,480
S-HNI (Max) 67 1742 992,940
B-HNI (Min) 68 1768 1,007,760

Objective of the Issue

1. To carry out the Offer for Sale of up to 75,000,000 Equity Shares by the Selling Shareholder 2. Achieve the benefits of listing the Equity Shares on the Stock Exchanges.

Issue

Category Nos Bid Bid (x)
QIB 56250000 2732062500 48.6x
NII 11250000 118350000 10.5x
Retail 7500000 21225000 2.8x
EMP 0 0 0x
Total 75000000 2241000000 29.9x

Net Sales (in cr.)

Total Income (in cr.)

Operating Profit (in cr.)

Net Profit (in cr.)

Shareholder Funds (in cr.)

Total Assets (in cr.)

Bharti Hexacom Ltd. Profit & Loss

#(Fig in Cr.) Mar 2015 Mar 2016 Mar 2017 Mar 2018 Mar 2019 Mar 2020 Mar 2021 Mar 2022 Mar 2023 Mar 2024 Mar 2025 TTM
Net Sales 4700 5189 5126 4408 3614 3874 4602 5405 6579 7089 8548
Other Income 382 9 14 67 14 53 149 94 140 250 182
Total Income 5082 5198 5139 4475 3627 3928 4751 5499 6719 7338 8730
Total Expenditure 2998 3069 3178 3641 3599 3399 3550 3596 3793 3728 4351
Operating Profit 2084 2130 1962 835 29 528 1202 1903 2926 3611 4379
Interest 11 41 94 135 248 526 564 572 639 645 688
Depreciation 460 516 851 869 1009 1250 1285 1441 1553 1739 2095
Exceptional Income / Expenses 0 -20 -38 -8 105 -2187 -342 1951 0 -303 213
Profit Before Tax 1613 1552 980 -176 -1123 -3435 -989 1841 734 923 1809
Provision for Tax 534 523 319 -64 -401 -718 45 167 185 419 315
Profit After Tax 1079 1029 660 -112 -722 -2717 -1034 1675 549 504 1494
Adjustments 0 0 0 0 0 0 0 -0 -0 0 0
Profit After Adjustments 1079 1029 660 -112 -722 -2717 -1034 1675 549 504 1494
Adjusted Earnings Per Share 21.6 20.6 13.2 -2.2 -14.4 -54.3 -20.7 33.5 11 10.1 29.9

Bharti Hexacom Ltd. Balance Sheet

#(Fig in Cr.) Mar 2015 Mar 2016 Mar 2017 Mar 2018 Mar 2019 Mar 2020 Mar 2021 Mar 2022 Mar 2023 Mar 2024 Mar 2025
Shareholder's Funds 5229 6255 6683 6489 5768 3020 1986 3661 4210 4639 5932
Minority's Interest 0 0 0 0 0 0 0 0 0 0 0
Borrowings 480 747 176 88 0 1045 3693 4808 4730 2792 2652
Other Non-Current Liabilities 145 140 151 93 -71 390 720 1080 2409 2677 2803
Total Current Liabilities 3833 1286 2635 3595 5249 9819 7489 6179 6142 7551 6841
Total Liabilities 9687 8428 9645 10265 10946 14273 13887 15727 17490 17660 18229
Fixed Assets 2607 3893 8308 8683 9226 9874 10304 10234 11174 13615 14733
Other Non-Current Assets 5138 3990 721 688 719 1360 1564 1471 3418 1647 1578
Total Current Assets 1942 544 615 893 1001 3040 2020 4022 2898 2397 1918
Total Assets 9687 8428 9645 10265 10946 14273 13887 15727 17490 17660 18229

Bharti Hexacom Ltd. Cash Flow

#(Fig in Cr.) Mar 2015 Mar 2016 Mar 2017 Mar 2018 Mar 2019 Mar 2020 Mar 2021 Mar 2022 Mar 2023 Mar 2024 Mar 2025
Opening Cash & Cash Equivalents 22 -3 -27 -150 -362 -476 -3 28 86 52 40
Cash Flow from Operating Activities 1208 1511 1516 988 493 -316 1517 1258 5108 3546 4583
Cash Flow from Investing Activities -2673 -694 -1644 -1488 -1166 -1076 -883 -1383 -2031 -1155 -2341
Cash Flow from Financing Activities 1445 -841 5 288 560 1864 -604 183 -3111 -2404 -2265
Net Cash Inflow / Outflow -19 -24 -123 -212 -114 473 31 59 -34 -13 -23
Closing Cash & Cash Equivalent 3 -27 -150 -362 -476 -3 28 86 52 40 17

Bharti Hexacom Ltd. Ratios

# Mar 2015 Mar 2016 Mar 2017 Mar 2018 Mar 2019 Mar 2020 Mar 2021 Mar 2022 Mar 2023 Mar 2024 Mar 2025
Earnings Per Share (Rs) 21.58 20.58 13.2 -2.24 -14.44 -54.33 -20.68 33.49 10.98 10.09 29.87
CEPS(Rs) 30.78 30.91 30.22 15.14 5.73 -29.34 5.03 62.31 42.05 44.87 71.76
DPS(Rs) 1.8 3.85 4.63 1.36 0 0 0 0 1.5 4 10
Book NAV/Share(Rs) 104.57 125.09 133.66 129.79 115.35 60.4 39.72 73.21 84.19 92.77 118.64
Core EBITDA Margin(%) 36.22 40.86 38.01 17.42 0.41 12.26 22.87 33.47 42.34 47.42 49.1
EBIT Margin(%) 34.56 30.7 20.94 -0.94 -24.22 -75.08 -9.24 44.64 20.86 22.13 29.21
Pre Tax Margin(%) 34.32 29.92 19.11 -3.99 -31.07 -88.66 -21.49 34.06 11.15 13.02 21.16
PAT Margin (%) 22.96 19.83 12.88 -2.54 -19.98 -70.12 -22.46 30.98 8.35 7.12 17.47
Cash Profit Margin (%) 32.74 29.78 29.48 17.17 7.93 -37.86 5.46 57.64 31.96 31.65 41.98
ROA(%) 13.45 11.36 7.31 -1.12 -6.81 -21.54 -7.34 11.31 3.31 2.87 8.32
ROE(%) 22.75 17.92 10.2 -1.7 -11.78 -61.83 -41.31 59.31 13.96 11.4 28.26
ROCE(%) 29.55 22.9 14.03 -0.5 -10.1 -34.38 -5.26 25.64 12.87 15.72 26.03
Receivable days 8.13 9.75 12.27 13.89 12.68 15.48 14.72 75.59 62.27 15.28 11.8
Inventory Days 0.03 0 0 0 0 0 0 0 0 0 0
Payable days 0 0 0 0 0 0 0 0 0 0 0
PER(x) 0 0 0 0 0 0 0 0 0 0 48.79
Price/Book(x) 0 0 0 0 0 0 0 0 0 0 12.28
Dividend Yield(%) 0 0 0 0 0 0 0 0 0 0 0.69
EV/Net Sales(x) 0.37 0.22 0.31 0.52 0.87 1.33 1.34 1.36 0.98 0.71 8.96
EV/Core EBITDA(x) 0.84 0.55 0.81 2.72 110.89 9.72 5.13 3.85 2.2 1.39 17.5
Net Sales Growth(%) 15.52 10.4 -1.22 -13.99 -18.03 7.21 18.8 17.45 21.72 7.75 20.58
EBIT Growth(%) 89.98 -1.93 -32.63 -103.88 -2004.09 -232.32 85.38 667.21 -43.11 14.28 59.19
PAT Growth(%) 78.79 -4.66 -35.84 -116.95 -545.22 -276.25 61.94 261.97 -67.2 -8.16 196.11
EPS Growth(%) 78.79 -4.66 -35.84 -116.95 -545.22 -276.25 61.94 261.97 -67.2 -8.16 196.11
Debt/Equity(x) 0.29 0.15 0.22 0.33 0.51 1.72 3.01 1.97 1.49 1.04 0.64
Current Ratio(x) 0.51 0.42 0.23 0.25 0.19 0.31 0.27 0.65 0.47 0.32 0.28
Quick Ratio(x) 0.51 0.42 0.23 0.25 0.19 0.31 0.27 0.65 0.47 0.32 0.28
Interest Cover(x) 146.33 39.23 11.45 -0.31 -3.54 -5.53 -0.75 4.22 2.15 2.43 3.63
Total Debt/Mcap(x) 0 0 0 0 0 0 0 0 0 0 0.05

Sihora Industries Growth Rates

# 1 Year 3 Year 5 Year 10 Year
Sales CAGR 21% 17% 17% 6%
Operating Profit CAGR 21% 32% 53% 8%
PAT CAGR 196% -4% 0% 3%
# 1 Year 3 Year 5 Year 10 Year
Share Price CAGR -16% NA% NA% NA%
ROE Average 28% 18% 14% 4%
ROCE Average 26% 18% 15% 9%

Company Contact Information

Bharti Hexacom Ltd.

Airtel Center, Plot No. 16 Udyog Vihar Phase I V

IPO Lead Manager(s)

Bharti Hexacom Ltd.

Axis Capital Ltd.

BOB Capital Markets Ltd

ICICI Securities Ltd

IIFL Securities Ltd.

SBI Capital Markets Ltd

Registrar Info

Bharti Hexacom Ltd.

Frequently Asked Questions

All You Need To Know About IPO

When you leave without vesting, generally unvested ESOPs are cancelled. Vested ESOPs usually can be exercised after you depart, often within 3 to 6 months, depending on the company's ESOP plan.

For companies listed on a stock exchange, you can sell the shares any time after you exercise the ESOP option and the shares are in your demat account. If the company is unlisted or otherwise a startup, you can only sell the shares if and when the company announces a buyback or has a process for secondary sales.

Whenever you exercised your options to hold shares, you entered into a market risk situation, and if the valuation of the company drops, so do the shares.

Yes. ESOPs are valuable to the employer in that the employer is able to retain the best talent, align employee interests with company goals, and preserve cash while rewarding performance.

Wealth Icon
Don’t Miss Out on Unlisted Shares

Open your account today and gain instant access to top unlisted shares and pre-IPO opportunities.

whatsapp

Error!