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

SHAREHOLDING PATTERN for quarter ended on 30th June, 2006
(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 6317869 6317869 23.50 23.50
(b) Central Government / State Government(s) 0 0 0 0.00 0.00
(c) Bodies Corporate 5 11775844 11775844 43.81 43.81
(d) Financial Institutions / Banks 0 0 0 0.00 0.00
(e) Financial Institutions / Banks - - - - -
  Sub-Total (A)(1) 14 18093713 18093713 67.31 67.31
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

 

 

Sub-Total (A)(2) 0 0 0 0 0.00
  Total Shareholding of Prom. & Prom. Grp.(A)=(A)(1)+(A)(2) 14 18093713 18093713 67.31 67.31
(B) Public Share Holding          
1 Institutions          
(a) Mutual Funds/ UTI 5 1681494 1681494 6.26 6.26
(b) Financial Institutions / Banks 3 1140 1140 0.00 0.00
(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 0 0 0 0.00 0.00
(f) Foreign Institutional Investors 11 2114276 2114276 7.87 7.87
(g) Foreign Venture Capital Investors 0 0 0 0.00 0.00
             
  Sub-Total (B)(1) 19 3796910 3796910 14.13 14.13
2 Non-institutions          
(a) Bodies Corporate 739 2270575 2270575 8.45 8.45
(b) (i) Individuals holding nominal share capital < = Rs. 1 Lakh 19876 2509485 2024579 9.34 9.34
(ii) Individuals holding nominal share capital > Rs. 1 Lakh 7 208520 208520 0.78 0.78
  Sub-Total (B)(2) 20622 4988580 4503674 18.56 18.56
  Total Public Shareholding (B) = (B)(1)+(B)(2) 21310 17570980 16768747 32.69 32.69
  TOTAL (A)+(B) 21324 53758406 52956173 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) 21324 53758406 52956173 100.00 100.00
 


 

LIST OF SHAREHOLDING OF PROMOTER AND PROMOTER GROUP
AS ON JUNE 30, 3007

S.No Name No. of Shares Shares as a % of Total Shares
1 QIMAT RAI GUPTA 1704772
6.34
2 SURJEET KUMAR GUPTA 1632540 6.07
3 VINOD GUPTA 933740 3.47
4 AMEET GUPTA 78308 0.29
5 ANIL GUPTA 866987 3.23
6 SANTOSH GUPTA 115836 0.43
7 QIMAT RAI GUPTA 679200 2.53
8 SHALINI GUPTA 194925 0.73
9 SANGEETA GUPTA 111561 0.42
10 TTL LIMITED 962044 3.58
11 AJANTA MERCANTILE LIMITED 3092400 11.50
12 HAVELLS FINANCIAL SERVICES LTD 300000 1.12
13 HAVELLS SWITCHGEARS PVT. LIMITED 216800 0.81
14 QRG ENTERPRISES LIMITED 7204600 26.80
  Total 18093713 67.31

 

LIST OF PUBLIC SHAREHOLDERS WITH MORE THAN 1% OF TOTAL NO. OF SHARES
AS ON JUNE 30.06.2006

S.No Name No. of Shares Shares as a % of Total Shares
1 SBIMF-MAGNUM SECTOR FUNDS UMBRELLA-EMERGING BUSINESS FUND 444797 1.65
2 SBI MUTUAL FUND A/C MAGNUM GLOBAL FUND 501108 1.86
3 SBI MUTUAL FUND - MAGNUM TAX GAIN 1993 398488 1.48
4 HSBC MIDCAP EQUITY FUND 333101 1.24
5 CITIGROUP GLOBAL MARKETS MAURITIUS PRIVATE LTD 396500 1.48
6 BSMA LIMITED 1168825 4.35
7 SHINE LIMITED 1709090 6.36
  Total 4951909 18.42





HAVELLS INDIA LIMITED  

STATEMENT SHOWING DETAILS OF LOCKED IN SHARES AS ON 30.06.2006

S.No Name No. of Shares Shares as a % of Total Shares
1 QRG ENTERPRISES LIMITED 496952 1.85
  Total 496952 1.85