Havells INDIA LIMITED
Regd. Off. # 1/7, Ram Kishore Road, Civil Lines, Delhi - 110 054

SHAREHOLDING PATTERN AS ON 31-12-2007
(Rs. in crores)
  Category of
Share Holders
No. of
Share holders
Total No.
of Shares
No. of Shares in Demat Form Total Shares as
          % of
A+B
% of A+B+c
A (A) Shareholding of Promoter and Promoter Group      
1 Indian          
(a) Individuals / Hindu Undivided Family 9 12635738 12635738 21.82 21.82
(b) Central Government / State Government(s) 0 0 0 0.00 0.00
(c) Bodies Corporate 5 23551688 23551688 40.66 40.66
(d) Financial Institutions / Banks 0 0 0 0.00 0.00
(e) Others - - - - -
  Sub-Total (A)(1) 14 36187426 36187426 62.48 62.48
2 Foreign          
(a) Individuals (NRIs / Foreign Individuals) 0 0 0 0.00 0.00
(b) Bodies Corporate 0 0 0 0.00 0.00
(c) Institutions 0 0 0 0.00 0.00
(e) Others - - - - -

 

 

Sub-Total (A)(2) 0 0 0 0 0.00
  Total Shareholding of Prom. & Prom. Grp.(A)=(A)(1)+(A)(2) 14 36187426 36187426 62.48 62.48
(B) Public Share Holding          
1 Institutions          
(a) Mutual Funds/ UTI 15 2228009 2228009 3.85 3.85
(b) Financial Institutions / Banks 4 89650 89650 0.15 0.15
(c) Central Government / State Government(s) 0 0 0 0.00 0.00
(d) Venture Capital Funds 0 0 0 0.00 0.00
(e) Insurance Companies 1 50000 50000 0.09 0.09
(f) Foreign Institutional Investors 15 9485079 9485079 16.38 16.38
(g) Others 0 0 0 0.00 0.00
             
  Sub-Total (B)(1) 41 11852738 11852738 20.46 20.46
2 Non-institutions          
(a) Bodies Corporate 706 1077138 1077138 1.86 1.86
(b) (i) Individuals holding nominal share capital < = Rs. 1 Lakh 20606 3626803 3059295 6.26 6.26
(ii) Individuals holding nominal share capital > Rs. 1 Lakh 9 385790 385790 0.67 0.67
(c) Others - - - - -
(1) Trust 1 1200 1200 0.00 0.00
(2) Non Residents Indians 448 426501 245701 0.74 0.74
(3) Clearing Members 313 120852 120852 0.21 0.21
(4) Hindu Undivided Families 345 79958 79958 0.14 0.14
(5) Foreign Corporate Bodies 1 4160000 4160000 7.18 7.18
  Sub-Total (B)(2) 22429 9878242 9129934 17.06 17.06
  Total Public Shareholding (B) = (B)(1)+(B)(2) 22470 21730980 20982672 37.52 37.52
  TOTAL (A)+(B) 22484 57918406 57170098 100.00 100
(c) Shares held by Custodians and against which Depository Receipts have been issued 0 0 0 0 0.00
  GRAND TOTAL (A)+(B)+(C) 22484 57918406 57170098 100.00 100.00
 


 

LIST OF SHAREHOLDING OF PROMOTER AND PROMOTER GROUP
AS ON 31-12-2007

S.No Name No. of Shares Shares as a % of Total Shares
1 QIMAT RAI GUPTA 3409544
5.89
2 SURJEET KUMAR GUPTA 3265080 5.64
3 VINOD GUPTA 1867480 3.22
4 AMEET GUPTA 156616 0.27
5 ANIL GUPTA 1733974 2.99
6 SANTOSH GUPTA 231672 0.40
7 SHALINI GUPTA 389850 0.67
8 SANGEETA GUPTA 223122 0.39
9 QIMAT RAI GUPTA 1358400 2.35
10 TTL LIMITED 1924088 3.32
11 AJANTA MERCANTILE LIMITED 6184800 10.68
12 HAVELLS FINANCIAL SERVICES LTD 600000 1.04
13 HAVELLS SWITCHGEARS PVT. LIMITED 433600 0.75
14 QRG ENTERPRISES LIMITED 14409200 24.88
  Total 36187426 62.48

 

LIST OF PUBLIC SHAREHOLDERS WITH MORE THAN 1% OF TOTAL NO. OF SHARES
AS ON 30-12-2007

S.No Name No. of Shares Shares as a % of Total Shares
1 SBI MUTUAL FUND A/C MAGNUM GLOBAL FUND 802795 1.39
2 SBI MUTUAL FUND - MAGNUM TAX GAIN 1993 796976 1.38
3 CITIGROUP GLOBAL MARKETS MAUTITIUS PVT. LIMITED 1123160 1.94
4 BSMA LIMITED 2219000 3.83
5 SLOANE ROBINSONS A/C SR GLOBAL (MAURITIUS) LIMITED (CLASS B - ASIA) 1737833 3.00
6 SLOANE ROBINSONS A/C SR GLOBAL (MAURITIUS) LIMITED (CLASS G - EMERGING) 1390856 2.40
7 SMALL CAP WORLD FUND, INC 1150335 1.99
8 Seacrest Investment Ltd. 4160000 7.18
  Total 13380955 23.10





HAVELLS INDIA LIMITED  

STATEMENT SHOWING DETAILS OF LOCKED IN SHARES AS ON 30-12- 2007

S.No Name No. of Shares Shares as a % of Total Shares
1 QRG ENTERPRISES LIMITED (Locked in upto 8-7-2009) 993904 1.72
2 25.11.2008 4160000 7.18
  Total 5153904 8.90