Historicals (amt in lakhs) Sales Less : Excise duty Net sales Service income Total revenue Total sales growth Other income Dividend - non-trade Dividend - trade and long term investment Current investment - dividend Profit on sale of current investment Dividend from subsidiary companies Mirasu marketing limited Fern Exports Private limited Interest received Interest on bank deposits Interest on long term investments Interest on others FOREX difference Insurance claim received Octroi refund Rent Miscellaneous income
FY 3/01 3,405.27 553.50 2,851.77 2,851.77
Consolidated FY 3/02 FY 3/03 FY 3/04 FY 3/05 3,543.07 3,598.57 4,200.31 6,433.59 354.06 128.99 260.42 390.66 3,189.01 3,469.58 3,939.89 6,042.93 33.66 3.15 3.75 3.04 3,222.66 3,472.73 3,943.64 6,045.97 13.0% 7.8% 13.6% 53.3%
64.28 0.23 -
40.18 0.31 -
35.01 0.29 -
68.40 0.40 -
22.98 4.85 4.95
14.00 4.85 6.98
5.56 2.28
6.77
-
0.22 21.04
0.26 1.18 -
1.29 0.02 2.48 -
10.01
12.60
19.20 7.68
6.16 0.04 1.14 1.25 19.20 33.44
64.94
1,522.60
1,806.85
2,024.83
2,238.59
953.91
41.86 229.78 43.81 227.83
43.81 132.59 40.36 136.05
40.36 184.80 74.29 150.87
74.29 212.57 73.76 213.10
113.17 874.05 91.94 895.28
45.53 438.20 39.30 444.43 12.04 838.30
39.30 302.99 39.37 302.92 9.33 1,358.55
39.37 318.80 35.92 322.25 11.08 1,540.63
35.92 377.91 47.04 366.79 15.23 1,643.47
7.63 41.96 4.60 45.00 13.63
Increase in stock of work in progress & finished goods (12.25) Opening stock Work in progress 19.30 Finished goods 82.26 Less : Prior period adjustments 101.57 Closing stock Work in progress 10.13 Finished goods 103.69 113.82
(26.90)
(30.92)
(9.01)
36.96
10.13 103.69 42.99 70.83
18.38 82.01 100.39
7.47 123.84 131.31
11.34 255.68
18.38 79.35 97.73
7.47 123.84 131.31
11.34 128.98 140.32
11.29 218.77 230.06
Material consumed & purchase of goods Raw material Opening stock Purchases Closing stock Raw material consumed Packing material Opening stock Purchases Closing stock Packing material consumed Consumables Purchase of goods
78.28 0.19 7.70 1.64 -
267.02
Manufacturing expenses Labor charges Power, fuel and water charges Repairs and maintenance - plant and machinery
54.12 36.45 15.30 2.37
44.78 27.43 16.67 0.69
48.56 29.84 17.04 1.68
52.28 32.45 16.81 3.02
59.67 35.86 22.61 1.20
Personnel cost Salary, wages, bonus, gratuity & leave encashments Gratuity SEVA incentive Contribution to PF & welfare funds Staff welfare expenses
54.12 36.45
44.78 27.43
319.03 258.24
15.30 2.37
16.67 0.69
24.78 36.01
394.76 297.08 6.09 60.15 25.28 6.16
604.13 521.80 11.74 18.42 44.26 7.91
Administrative, selling & other expenses 669.76 Rent 3.75 Rates and taxes 0.70 Repairs & maintenance - Buildings 0.44 Repairs & maintenance - Others 4.52 Insurance 5.72 Printing and stationery 8.44 Telephone, postage and telegrams 17.37 Travelling, conveyance and vehicle expenses 126.37 Legal and professional charges 10.14 Auditors remunerations 1.40 Bank charges & commission Directors sitting fees 0.18 Expired stock written off 30.02 Provision for expiry stock Freight, transportation and octroi 57.79 Commission charges on sales 23.62 To sole selling agent To others Excise duty Interest on trade deposits from customers and CFA Sales tax FOREX difference Warehousing and distribution cost Bad debts Provision for doubtful debts Advertisement and publicity 345.58 Loss on sale of assets 2.63 Loss on sale of investment Stock write offs Fixed assets written off Diminution of value of fixed assets Miscellaneous expenses 31.08
828.62 23.43 0.94 1.28 8.48 6.06 14.51 23.95 136.80 38.91 2.16
774.23 11.29 1.17 0.06 10.34 6.27 10.33 24.63 130.60 35.77 2.58
594.77 4.25 20.60 3.45 11.13 11.54 124.68 36.64 2.95
0.18 26.91
0.20 94.21
62.90
32.35 49.01
35.90 46.85
43.04 49.67
14.15 -
11.36 -
11.69
6.03 1.22 338.35 5.20 41.20 57.49
141.58 20.11 161.13 2.21 27.64
5.32 13.24 101.59 6.49 4.93 17.18 63.48
1,709.64 24.75 41.87 8.37 31.29 15.01 18.18 34.22 225.04 76.00 6.41 6.44 1.55 15.50 58.39 56.82 0.51 6.83 0.69 165.70 1.79 878.31 2.34 2.06 31.57
51.10 75.69
72.84 7.33
58.78 6.31
24.85
Depreciation Amortization / expenses written off
82.05 83.17
Deferred revenue expenses written off Amortization of public issue expenses Goodwill written off Amortisation of technical knowhow fees
75.84 6.33 1.00
68.36 6.33 1.00
6.33 1.00
5.31 1.00
0.10 24.74 -
208.10 97.04 111.06
189.98 75.18 114.80
171.10 87.48 83.62
64.57 61.32 3.25
24.58 18.83 5.75
2.00 2.00 -
(182.93) (182.93)
161.76 6.00 155.76
210.74 218.00 (7.26)
289.82 269.00 20.82
30.11
30.06
30.06
30.06
30.07
2,814.28 100.23 47.51 5.40 2,661.14
3,074.83 13.63 297.70 3.86 52.75 5.46 2,701.43
2,710.86 6.31 343.48 2.19 45.67 5.33 2,307.88
2,585.73 0.52 223.44 4.96 2,356.81
2,789.63 86.33 4.99 2,698.31
867.82 #REF! 587.35 #REF!
944.06 1,240.99 758.64 1,426.41
860.90 1,100.09 733.36 1,227.63
945.02 1,064.90 789.60 1,220.32
1,237.04 969.06 1,133.34 1,072.76
1,000.62 301.12 699.50
938.46 300.86 637.60
938.46 300.86 637.60
976.96 300.86 676.10
1,317.73 300.91 1,016.82
Debt 1,226.82 1,495.53 Secured loans 991.96 1,257.33 Debentures 450.00 500.00 Loans and advances from banks Term loans 119.52 135.88 Cash credit facilities 422.45 621.44 Foreign currency denominated loan Unsecured loans 234.86 238.21 Sales tax incentive under package scheme of incentives, 234.861988 238.21
1,001.04 753.69 344.00
787.40 528.29 126.00
287.01 -
88.86 320.83 247.35 247.35
18.27 384.02 259.11 259.11
287.01 287.01
863.09
945.54
1,237.04
Interest and financial charges Debenture and other financial charges Other - including bank charges Tax Current tax Deferred tax Outstanding shares Total assets Misc expenditure Debit balance in P & L A/C Goodwill Cash Cash equivalents in investments Operating assets Fixed assets excl goodwill (net block) Current assets excl cash Current liabilities excl debt Capital invested Shareholders equity Share capital Reserves and surplus
Fixed assets
867.82
947.92
Goodwill Brands Tenancy rights Free hold land Lease hold land Buildings Plant and machinery Electrical Installations Moulds Computers and equipments Furniture and fittings Development of property Vehicles Work in progress
333.42 21.31 6.53 155.94 238.67 22.38 23.33 12.18 42.62 11.43
3.86 65.21 21.31 6.46 453.25 221.68 42.30 52.08 0.78 80.99 -
2.19 3.19 58.21 21.31 6.40 443.02 162.21 16.40 1.90 33.93 43.33 0.75 70.25 -
0.52 2.05 36.49 0.71 6.30 571.19 144.58 15.22 5.57 25.56 33.17 66.22 37.96
0.90 30.96 68.28 6.23 558.68 136.07 13.81 7.13 17.55 30.09 49.81 317.53
Investments 357.76 Government securities - NSC 0.32 Invesment in subsidiaries Fern exports p ltd 0.51 Mirasu marketing ltd - equity 251.25 Mirasu marketing ltd - preference 100.00 Trade investment in companies under same management Pentagon manufacturing & marketing P ltd - equity Pentagon manufacturing & marketing P ltd - preference Other non trade investment in equity shares The north kanara GSB co-op bank ltd 0.50 The saraswat co-op bank ltd 0.10 The Rupee co-op bank ltd Quoted Colgate Palmolive india ltd 0.45 Godrej industries ltd 0.13 Godrej consumer products ltd 0.09 Hindustan lever ltd 1.91 Indusind bank ltd 0.72 P & G Hygiene & health care ltd 0.71 Reckit Benckiser (india) ltd 0.38 Trent ltd 0.69 Current investment, unquoted, non trade Franklin Templeton Mutual Fund LIC Mutual Fund HDFC Balance Fund UTI Fixed Maturity Plan Reliance Growth Fund DSP Merrill Lynch Mutual Fund -
521.84 0.37
352.22 0.63
351.85 0.26
497.20 0.29
4.51 251.25 90.00
4.51 251.25 90.00
4.51 251.25 90.00
4.51 251.25 90.00
Aggreate value of quoted investments Investment in Government securities & MFs Cash equivalents in investments Inventories Raw materials Packing materials
120.00 50.00
-
-
-
0.50 0.10 0.03
1.00 0.10 0.03
1.00 0.10 0.03
1.00 0.10 0.03
0.45 0.13 0.09 1.91 0.72 0.71 0.38 0.69
0.45 0.13 0.09 1.91 0.72 0.71 0.69
0.45 0.13 0.09 1.91 0.72 0.71 0.69
0.45 0.13 0.09 1.91 0.72 0.71 0.69
-
-
-
50.00 65.00 -
-
-
-
30.32
5.08 0.32 5.40
5.08 0.37 5.46
4.70 0.63 5.33
4.70 0.26 4.96
4.70 145.61 150.31
231.06 43.81 39.30
177.46 40.36 39.37
241.51 74.29 35.92
261.12 73.76 47.04
231.58 41.97 54.56
Work in progress Finished goods Software stock in progress
10.13 103.69 34.13
18.38 79.35 -
7.46 123.84 -
11.34 128.98 -
11.29 123.76 -
960.69 87.68
960.27 12.41
744.32 27.15
873.01 873.01
949.08 949.08
718.39 718.39
541.71 22.63 8.17 14.46 533.54 533.54
363.38 7.45 3.12 4.33 360.26 360.26
1.22
1.22
14.46
4.33
47.51
52.75
45.67
223.44
86.33
Loans and advances Advances recoverable in cash or in kind others Loans and advances to staff Advance income tax Balances with customs, port trust, etc
249.21 246.55
103.25 102.61
114.26 109.88
262.07 250.95 2.40
374.10 365.42 1.69
2.66
0.64
4.38
8.72
6.99
Current liabilities Acceptances Sundry creditors SSI Subsidiary companies Others Unclaimed dividend Advance from customers Trade deposits Other liabilities
536.73 77.02
683.09 83.63
642.88 37.26
392.63 52.91
775.19 76.86
42.10 326.81 1.76 3.44 46.50 39.10
136.49 347.35 1.73 8.11 48.70 57.08
285.76 149.99 1.72 32.67 62.55 72.93
113.54 91.05 1.37 7.21 60.55 66.00
234.30 0.87 180.26 2.62 1.50 62.70 216.08
50.62 2.10
75.55 3.93
90.48 4.70
396.97 5.28
358.15 -
16.07 7.62 2.00 22.84
17.23 11.07 2.00 41.32
16.33 12.65 6.00 50.80
10.92 13.64 224.00 39.06 25.49 78.58
269.00 89.15 -
100.23
13.63
6.31
47.04
(34.08)
120.76
610.99
804.34
82.05 2.63
51.10 5.20
72.84 20.11
58.78 6.49
57.94 4.77
Sundy debtors Over six months Considered good Considered doubtful Other debt Other debt - considered good Other debt - considered doubtful Less : Provision for doubtful debts Cash and bank
Provisions Gratuity Wealth tax Bonus and ex gratia Leave encashments Taxation Employee benefits SEVA provision Provision for expired stock claim Proposed dividend Others Misc exp CASH FLOW Net profit before tax and extraordinary items Adjustments Depreciation Loss on sale of assets
-
-
-
Assets discarded Brands written off Loss on sale of investment Provision for contingencies Diminution of value of Fixed Assets Interest and financial charges Misc exp Provision for sale tax under the deferral scheme Provision for doubtful debts Provision for expired stock claims Misc exp written off Unrealised Foreign exchange loss Interest income Rent income Dividend income (A) Changes in working capital Loan and advances Sundry debtors Inventories Liabilities and provisions (B) Cash from operation (A) + (B) Income tax paid Prior period items Cash from operating activities
208.10 -
41.20 333.42 1.93 189.98 0.10 3.35
2.21 171.10 9.14
40.61
86.60
7.33
(4.95)
(6.98)
(28.05) 347.44
Purchase of fixed assets Proceeds from sale of fixed assets Net capex Purchase of investments Proceeds from redemption of preference shares Proceeds from sale of investment Interest received Rent received Dividend received Cash from investing activities Proceeds from long-term borrowings Proceeds from short term borrowings Repayment of long-term borrowings Repayment of short term borrowings Interest and financial charges paid Proceeds from issue of forfeiture shares Dividend & DDT paid Cash from finaning activities Opening cash Cash generated Closing cash SEGMENT
(19.16) 652.67
(2.28) (19.20) (5.86) 376.15
4.93 17.18 64.57 11.76 13.24 13.20 6.31 12.02 (7.34) (19.20) (7.17) 785.76
(2.44) 0.69 23.84 27.90 (10.13) (3.63) (9.60) (12.41) 881.27
43.63 (85.71) (42.10) 110.18 26.00 373.44 (4.65) (5.10) 363.69
66.59 (169.58) 53.60 169.35 119.95 772.63 (443.16) 329.46
(11.07) 215.95 (64.04) (22.28) 118.56 494.71 (9.00) (4.76) 480.95
42.38 189.37 (19.61) (174.97) 37.17 822.93 (190.19) (0.86) 631.88
177.20 188.46 29.53 (14.41) 380.78 1,262.05 (289.23) (0.24) 972.58
(67.87) 1.24 (66.63) (1.25) 4.92
(422.58) 9.47 (413.12) (4.06) 10.00 6.33
9.20 (53.75)
19.16 (381.68)
(30.50) 20.18 (10.32) 169.68 2.28 19.20 5.86 186.70
(204.34) 17.10 (187.24) 0.37 7.34 19.20 7.17 (153.16)
(357.24) 5.46 (351.78) (146.04) 3.63 9.60 12.41 (472.18)
75.00 (44.09) (136.96) (208.10) (314.16)
110.55 201.91 (44.20) (3.13) (207.67) 57.46
11.50 320.84 (214.53) (621.44) (171.10) (674.73)
375.66 (612.04) (64.57) (300.95)
(529.32) (23.84) 0.44 (84.79) (637.51)
51.74 (4.23) 47.51
47.51 5.24 52.75
52.75 (7.08) 45.67
45.67 177.77 223.44
223.44 (137.11) 86.33
REVENUE Consumer products Growth % on total sales Pharma Growth % on total sales Others Growth % on total sales
2,320.60 72.0% 767.75 23.8% 134.31 Total sales
Total growth EBITDA Consumer products Growth Margin Pharma Growth Margin Others Growth Margin Corporate overheads
318.09
Capex Consumer products
845.48 17.4% 26.6% (6.13) -70.4% -0.8% 50.04 39.3% 9.5% (67.88) 821.51 23.4% 18.3% -
3.6%
342.00 23.0% 12.9% (45.65) -13.7% -7.2% (32.19) 156.6% -18.0% (7.33) 256.83 121.9% 7.4%
688.11 101.2% 24.3% (24.18) -47.0% -3.0% 28.90 -189.8% 9.8% (85.67) 607.16 136.4% 15.4%
813.24 18.2% 25.6% (8.56) -64.6% -1.1% 42.82 48.2% 8.2% (83.93) 763.57 25.8% 17.0%
39.96 5.48 5.66 51.10
61.91 3.56 7.37 72.84
32.03 3.48 7.02 16.25 58.78
32.24 2.43 7.22 16.05 57.94
480.33
27.35
18.29
8.06
-5.1% (96.97) 166.83 5.2% 278.13 12.0% (52.89) -6.9% (12.54)
Total
Total growth Total margin Depreciation Consumer products Pharma Others Corporate assets
720.14 78.3% 25.5% (20.70) -50.8% -2.5% 35.92 -244.7% 12.1% (69.42) 665.94 102.0% 16.9% -
-6.2% (6.88)
Total
Total
2,828.90 3,182.33 6.5% 12.5% 71.7% 70.9% 818.95 783.72 28.7% -4.3% 20.8% 17.5% 295.79 525.09 65.0% 77.5% 7.5% 11.7% 3,943.64 4,491.14 13.6% 13.9% (1,554.83)
403.91 27.0% 15.2% (42.09) -11.2% -6.6% (24.82) 260.7% -13.8% (7.33) 329.67 97.6% 9.5% -
13.7% (47.41)
Total growth Total margin EBIT Consumer products Growth Margin Pharma Growth Margin Others Growth Margin Corporate overheads
4.2% 3,222.66
2,657.37 14.5% 76.5% 636.10 -17.1% 18.3% 179.26 33.5% 5.2% 3,472.73 7.8% -
-9.3% (96.97) 115.73
Pharma Others Corporate assets Assets Consumer products Pharma Others Corporate assets
Liabilities Consumer products Pharma Others Corporate liabilities
Total
17.36 34.24 531.93
0.32 2.84 30.51
1.19 6.29 140.62 166.39
0.13 1.91 67.57 77.67
Total
1,770.85 332.03 138.77 521.84 2,763.50
1,621.66 242.11 145.08 352.22 2,361.07
1,087.58 263.46 155.51 1,079.18 2,585.73
774.35 190.75 195.68 1,651.26 2,812.04
Total
559.67 193.13 5.83 1,377.74 2,136.38
493.60 222.28 17.48 1,039.04 1,772.40
311.32 186.55 17.43 2,070.42 2,585.72
388.23 266.52 40.81 798.75 1,494.31
Consolidated FY 3/06 FY 3/07 FY 3/08 7,449.88 414.04 7,035.84 1.97 7,037.81 16.4% -100.0% #DIV/0! 115.75 0.16 23.71 0.91 6.67
0.80 3.15
80.35 885.24 91.94 907.71 181.73 817.92 4.60 47.66 3.77 48.49 18.84 (133.03) 11.29 218.77 6.02 224.04 10.72 346.34 357.06
-
-
61.21 36.93 21.82 2.46 718.28 598.20 7.69 44.58 54.87 12.93 2,280.44 30.15 32.83 0.37 29.84 25.01 18.02 46.74 262.71 82.58 13.33 5.99 1.62 25.62 41.60 149.76 63.61 8.87 19.46 146.11 54.82 1,155.44 1.68 64.28
24.74
245,692.00
2.46
24.74 -
24.88 12.16 12.72
985,546.00 222,591.00 674,785.00 575,427.00
30.08
1,983.30 1,249.86 1,923.86 1,309.30
-
-
1,404.03 300.96 1,103.08
-
-
303.35 303.35 303.35 1,983.30
9.86 2.23 6.75 5.75
43.51 32.23 96.61 6.15 528.03 129.76 26.66 9.63 26.24 33.20 42.53 1,008.75 256.59 0.44 1.00 0.10 0.03 0.45 0.13 0.09 1.91 0.72 0.71 0.69 50.00 150.00 30.32 20.00 12.78 250.76 263.54 541.73 181.73 3.77
10.72 345.52 404.63 60.60 403.18 59.15 323.13 303.50 142.34 7.40 153.43 0.33 1,283.48 133.15 408.47 390.86 3.66 44.42 141.24 161.67 640.38 8.47 1.38 21.21 42.37 179.19 73.50 41.60 272.66 -
-100.0% #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
-100.0% #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
-100.0% #DIV/0! -100.0% (7,037.81)
#DIV/0! #DIV/0! #DIV/0! -
#DIV/0! #DIV/0! #DIV/0! -
-100.0% #DIV/0! -100.0% #DIV/0! -100.0% #DIV/0! -100.0% #DIV/0! -
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -
-100.0% #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
-100.0% #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
-100.0% #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
-100.0% #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
-
-
-
-
-
-
-
-
-
-
-
-