Colgate
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Colgate as PDF for free.
More details
- Words: 2,277
- Pages: 32
Colgate-Palmolive India Limited (Amt in lakhs) FY 3/02 Sales 116,394.93 Excise duty 4,851.73 Net sales 111,543.20 Growth Cost of goods sold 58,149.48 GROSS PROFIT 53,393.72 Growth Margin 47.9% Employee costs 6,268.04 Other expenses 35,600.19 Other income 631.04 EBITDA 12,156.53 Growth Margin 10.9% Depreciation and amortization 2,686.35 EBIT 9,470.18 Growth Margin 8.5% Interest expenses 107.61 Interest received 1,680.77 EBT 11,043.34 Growth Margin 9.9% Tax 4,509.96 Net income 6,533.38 Growth Margin 5.9% Outstanding shares 1,359.93 Growth EPS INR 4.80 Growth Non recurring items Other expenses Loss on sale of fixed assets (net) 73.24 Loss on disposal of subsidiary co Loss on sale of long term investments Employee costs Voluntary Retirement Scheme Other income Gain on pre-payment of sales tax deferral liability Provision no longer required written back Profit on sale of investments 164.76 Profit on sale of assets Total assets Investments Deferred tax assets Cash and bank Miscellaneous expenditure Goodwill Operating assets Return on operating assets
60,946.18 4,285.88 10,459.86 0.19 2,217.97 43,982.28 21.5%
FY 3/03 106,030.54 3,954.84 102,075.70 -8.5% 44,857.10 57,218.60 7.2% 56.1% 7,302.35 29,191.10 703.88 21,429.03 76.3% 21.0% 2,339.50 19,089.53 101.6% 18.7% 142.86 1,874.03 20,820.70 88.5% 20.4% 5,726.11 15,094.59 131.0% 14.8% 1,359.93 0.0% INR 11.10 131.0%
FY 3/04 104,520.37 10,289.11 94,231.26 -7.7% 46,222.86 48,008.40 -16.1% 50.9% 7,228.99 25,045.29 682.63 16,416.75 -23.4% 17.4% 2,761.93 13,654.82 -28.5% 14.5% 179.19 1,950.56 15,426.19 -25.9% 16.4% 4,604.48 10,821.71 -28.3% 11.5% 1,359.93 0.0% INR 7.96 -28.3%
FY 3/05 107,576.48 10,831.36 96,745.12 2.7% 47,117.17 49,627.95 3.4% 51.3% 7,067.52 24,656.96 334.93 18,238.40 11.1% 18.9% 2,073.76 16,164.64 18.4% 16.7% 172.06 2,437.56 18,430.14 19.5% 19.1% 6,493.85 11,936.29 10.3% 12.3% 1,359.93 0.0% INR 8.78 10.3%
64.61 51.53
15.28
23.01
-
-
638.65
438.13 115.67
32.59 331.55 68.04
13.33 250.00 158.12
64,370.15 9,459.00 10,047.57 2,149.73 42,713.85 44.7%
57,864.79 10,526.17 1,317.98 13,043.22 136.49 32,840.93 41.6%
58,489.54 15,015.48 492.62 5,741.84 356.03 36,883.57 43.8%
Fixed assets excluding goodwill Current assets excluding cash Interest accrued Inventories Sundry debtors Loans and advances Current liabilities excluding debt Liabilities Provisions Capital invested Return on capital invested
18,033.37 25,948.91 196.90 8,018.59 7,288.50 10,444.92 30,558.60 25,392.35 5,166.25 13,423.68 70.5%
16,097.67 26,616.18 450.16 5,998.68 4,416.75 15,750.59 33,356.73 26,133.82 7,222.91 9,357.12 204.0%
11,487.40 21,353.53 463.96 6,591.29 3,316.98 10,981.30 30,012.12 23,269.96 6,742.16 2,828.81 482.7%
16,400.69 20,482.88 546.98 7,841.77 1,773.93 10,320.20 31,872.35 22,101.90 9,770.45 5,011.22 322.6%
Cash and bank Investments Cash and cash equivalents
10,459.86 4,285.88 14,745.74
10,047.57 9,459.00 19,506.57
13,043.22 10,526.17 23,569.39
5,741.84 15,015.48 20,757.32
2,217.97 628.13 3,203.81 109.46 7,207.05 7,211.06 1,155.70 52.36 21,785.54 1,870.00 19,915.54 335.80 20,251.34
2,149.73 531.50 2,966.49 96.27 6,692.10 4,691.35 816.93 52.34 17,996.71 17,996.71 250.69 18,247.40
136.49 67.64 249.19 93.86 6,003.93 4,246.32 369.21 28.37 11,195.01 11,195.01 428.88 11,623.89
424.48 5,552.01 3,291.27 367.43 16.12 9,651.31 9,651.31 6,749.38 16,400.69
Inventories Stores and spares Raw and packing materials Work in process Finished goods Total
287.21 1,675.15 323.83 5,732.40 8,018.59
225.23 1,624.60 335.02 3,813.83 5,998.68
202.68 1,148.06 132.14 5,108.41 6,591.29
219.80 1,074.87 300.80 6,246.30 7,841.77
Sundry debtors Unsecured considered good Over six months Others Total
203.83 7,084.67 7,288.50
73.82 4,342.93 4,416.75
0.07 3,316.91 3,316.98
1,773.93 1,773.93
306.83
326.22
6,544.00 1,335.50 873.50
5,383.00 1,683.07 1,541.52
Fixed assets Goodwill and trademarks Copyrights and design Technical know how Land - leasehold Buildings Plant and machinery Furniture and equipments Vehicles Less: Provision for under utilised assets Capital work in progress & advances Total Fixed assets
Loans and advances Secured: Loans to employees 200.77 254.69 Unsecured: Inter - corporate deposits 6,576.00 12,167.00 Advances recoverable in cash or in kind or for value 1,324.62 to be received755.71 Advance tax (net of provision for taxation) Balances with excise authorities 508.38 25.66
Deposits - others
Total
Liabilities Acceptances Sundry creditors Unclaimed dividend Other liabilities Interest accured but not due Total Provisions Taxations (net of advance tax payments) Fringe benefit taxation Second interim dividend - proposed Third interim dividend Special dividend Dividend tax on second interim dividend Gratuity Leave encashments Others Total Cash Debt Secured loans Bank loan Unsecured loans Loans Sales tax deferral Shareholder's equity Tangible book value (TBV) TBV/share CASH FLOW Net profit before tax Adjustments Foreign exchange (gain)/loss Depreciation and amortization Interest expenses Profit on sale of investments Loss on disposal of a subsidiary Provision for underutilised assets (gain)/loss on retirement of fixed assets Gain on pre-payment of sale tax deferral liability Interest income (A) Changes in working capital Inventories Sundry debtors Loans and advances Current liabilities and provisions Miscellaneous expenditure (B)
1,835.15 10,444.92
2,547.53 15,750.59
1,921.47 10,981.30
1,386.39 10,320.20
111.70 23,410.73 1,845.97 23.95 25,392.35
2,079.87 22,888.61 408.08 757.26 26,133.82
2,038.03 15,835.92 435.60 4,960.41 23,269.96
3,900.16 16,939.53 472.50 789.71 22,101.90
1,899.56 2,379.87 605.18 281.64 5,166.25
2,905.01 2,719.86 348.48 591.04 658.52 7,222.91
2,109.59 1,699.91 217.81 65.32 340.28 2,309.25 6,742.16
289.25 2,039.89 286.09 572.77 6,582.45 9,770.45
14,745.74 2,330.93 1,406.25 1,406.25 924.68 160.00 764.68
19,506.57 1,620.25 1,406.25 1,406.25 214.00 214.00 -
23,569.39 1,341.88 1,125.00 1,125.00 216.88 216.88 -
20,757.32 919.76 521.88 521.88 397.88 397.88 -
25,456.13 23,237.97 INR 17.09
27,870.23 25,720.50 INR 18.91
25,237.75 25,101.26 INR 18.46
25,697.43 25,341.40 INR 18.63
11,134.85
14,268.36
15,843.09
17,736.61
6.27 2,686.35 107.61 -164.76 1,480.00 73.24 -1,680.77 13,642.79
21.57 2,339.50 142.86 51.53 64.61 160.29 -115.67 -438.13 -1,874.03 14,620.89
4.34 2,761.93 179.19 15.28 -68.04 -32.59 -1,950.56 16,752.64
77.37 2,527.08 172.06 23.01 -158.12 -13.33 -2,437.56 17,927.12
1,651.06 -2,732.49 1,732.22 1,916.48 2,567.27
2,019.90 2,868.46 280.23 2,586.66 0.19 7,755.44
-592.61 1,099.77 -853.71 -1,426.09 -1,772.64
-1,250.47 1,543.05 -499.89 1,748.91 1,541.60
Direct taxes paid Cash from operating activities
-3,874.47 12,335.59
-5,802.79 16,573.54
-6,967.78 8,012.22
-7,275.40 12,193.32
Purchase of fixed assets Sale of fixed assets Purchase of investments Sale of investments Inter-corporate deposits Interest received
-992.24 77.04 -5,305.92 5,584.81 2,594.00 1,919.91
-702.01 221.85 -6,759.00 1,579.35 -5,591.00 1,620.77
-885.46 149.00 -1,176.22 93.77 5,623.00 1,936.76
-8,091.47 589.68 -4,709.24 196.91 1,161.00 2,354.53
Cash from investing activities
3,877.60
-9,630.04
5,740.85
-8,498.59
Proceeds from long term loans Sales tax deferral Interest paid Dividend paid Dividend tax paid
954.10 71.83 -99.49 -12,961.67 -1,491.16
54.00 -326.54 -166.81 -6,877.57 -
-278.37 32.59 -179.19 -9,152.00 -1,176.11
-422.13 13.33 -172.06 -9,142.58 -1,195.30
Cash from financing activities
-13,526.39
-7,316.92
-10,753.08
-10,918.74
2,686.80 7,779.33 -6.27 10,459.86
-373.42 10,459.86 -21.57 -17.30 10,047.57
2,999.99 10,047.57 -4.34 13,043.22
-7,224.01 13,043.22 -77.37 5,741.84
108,187.44
99,858.11 -7.7% 94.2% 5,651.74 -28.6% 5.3% 520.69 81.2% 0.5% 106,030.54 -8.9%
Net increase / (decrease) in cash Opening cash Forex loss Cash of subsidiary disposed off Closing cash SEGMENT - Business Revenue (before excise duty) Oral care Growth % on total sales Personal care Growth % on total sales Others Growth % on total sales Total Total growth Segment results Oral care Growth Margin Personal care Growth Margin Others Growth Margin Corporate overheads Total growth Total margin
92.9% 7,920.12 6.8% 287.37 0.2% 116,394.93
16,325.49 15.1% -650.10 -8.2% 25.83
Total
9.0% -6,304.29 9,396.93 8.1%
19,041.23 16.6% 19.1% 309.92 -147.7% 5.5% 49.01 89.7% 9.4% -6,818.74 12,581.42 33.9% 11.9%
Depreciation and amortization Oral care Personal care Others Corporate assets Total Capex Oral care Personal care Others Corporate assets Assets Oral care Personal care Others Corporate assets Liabilities Oral care Personal care Others Corporate liabilities
1,388.56 305.94 991.84 2,686.34
1,369.47 106.04 863.99 2,339.50
Total
633.37 23.82 570.83 1,228.02
423.94 64.95 298.23 787.12
Total
38,017.22 2,529.69 58.59 20,340.50 60,946.00
31,773.48 2,149.87 65.90 30,380.90 64,370.15
Total
25,472.82 2,063.41 31.32 7,922.50 35,490.05
25,688.52 1,110.35 27.67 9,673.38 36,499.92
114,246.59
103,788.17 -9.2% 97.9% 2,242.37 4.4% 2.1% 106,030.54 -8.9%
92,158.48 -11.2% 97.8% 2,072.78 -7.6% 2.2% 94,231.26 -11.1%
94,680.62 2.7% 97.9% 2,064.50 -0.4% 2.1% 96,745.12 2.7%
Total
56,470.15 4,475.84 60,945.99
59,923.33 4,446.82 64,370.15
54,090.10 3,774.69 57,864.79
55,302.42 3,187.12 58,489.54
Total
1,141.24 86.78 1,228.02
700.79 86.33 787.12
707.69 82.67 790.36
7,691.54 43.90 7,735.44
50 24 74 148
57 21 78 197
50 15 65 169
56 10 66 150
SEGMENT - Geographical Revenue India Growth % on total sales Outside India Growth % on total sales Total Total growth Assets India Outside India Capex India Outside India
Working capital cycle Inventories turnover ratio Debtors turnover ratio Gross working capital cycle Creditors turnover ratio
98.2% 2,148.34 1.8% 116,394.93
Net working capital cycle
-73
-119
-104
-84
FY 3/06 121,925.68 9,331.85 112,593.83 16.4% 49,430.61 63,163.22 27.3% 56.1% 9,856.89 34,454.96 2,453.59 21,304.96 16.8% 18.9% 4,329.56 16,975.40 5.0% 15.1% 66.02 1,476.24 18,385.62 -0.2% 16.3% 5,068.42 13,317.20 11.6% 11.8% 1,359.93 0.0% INR 9.79 11.6% 7.33
FY 3/07 138,585.82 9,024.09 129,561.73 15.1% 57,265.94 72,295.79 14.5% 55.8% 11,342.33 40,143.87 4,026.44 24,836.03 16.6% 19.2% 1,957.34 22,878.69 34.8% 17.7% 98.04 1,688.26 24,468.91 33.1% 18.9% 4,705.61 19,763.30 48.4% 15.3% 1,359.93 0.0% INR 14.53 48.4% -
148.46
5,802.00
842.33
878.23
63,818.26 14,521.03 760.40 8,920.81 39,616.02 42.8%
70,758.08 13,021.03 2,566.95 11,486.42 43,683.68 52.4%
FY 3/08 6,213.73 -6,213.73 -6,213.73
-6,213.73
-6,213.73 -6,213.73
#DIV/0!
17,347.21 22,268.81 424.04 7,584.49 751.14 13,509.14 35,311.49 28,419.00 6,892.49 4,304.53 394.4%
19,202.78 24,480.90 386.32 8,033.06 940.80 15,120.72 42,490.91 30,554.54 11,936.37 1,192.77 1918.1%
8,920.81 14,521.03 23,441.84
11,486.42 13,021.03 24,507.45
428.19 7,437.56 7,940.53 603.94 10.49 16,420.71 16,420.71 926.50 17,347.21
406.43 6,906.40 8,794.54 656.20 4.76 16,768.33 16,768.33 2,434.45 19,202.78
243.29 1,554.84 286.28 5,500.08 7,584.49
418.36 1,400.97 186.56 6,027.17 8,033.06
751.14 751.14
940.80 940.80
342.05
413.92
6,929.00 2,666.19 759.40 756.20
6,819.00 3,617.35 1,183.57 136.75
2,056.30 13,509.14
2,950.13 15,120.72
2,912.64 21,515.72 2,917.15 1,073.49 28,419.00
4,047.19 23,265.68 1,049.04 2,192.63 30,554.54
210.00 827.43 5,855.06 6,892.49
349.00 2,719.86 462.24 946.18 7,459.09 11,936.37
23,441.84 435.52 435.52 435.52 -
24,507.45 427.50 427.50 427.50 -
28,071.25 28,071.25 INR 20.64
27,839.67 27,839.67 INR 20.47
19,072.16
19,545.14
48.76 4,329.56 66.02 7.33 -842.33 -1,476.24 21,205.26
22.07 1,957.34 98.04 -878.23 -1,688.26 19,056.10
257.28 1,022.79 -883.54 4,038.66 4,435.19
-448.57 -282.00 -1,205.07 4,825.62 2,889.98
-6,862.55 18,777.90
-6,177.68 15,768.40
-5,015.11 937.39 487.12 -1,546.00 1,599.18
-3,846.28 911.60 1,500.00 110.00 1,725.98
-3,537.42
401.30
-484.24 -66.02 -9,794.69 -1,716.56
-8.02 -98.04 -12,067.56 -1,430.47
-12,061.51
-13,604.09
3,178.97 5,741.84 8,920.81
2,565.61 8,920.81 11,486.42
111,792.91 18.1% 99.3% 800.92 -61.2% 0.7% 112,593.83 16.4%
128,583.06 15.0% 99.2% 978.67 22.2% 0.8% 129,561.73 15.1%
-
62,334.14 1,484.12 63,818.26
41,367.11 325.89 41,693.00
-
4,934.62 29.51 4,964.13
3,622.24 7.49 3,629.73
-
57 4 61 167
50 2 52 165
-
-106
-113
-
130,000.00 120,000.00 110,000.00 100,000.00 90,000.00 80,000.00 70,000.00 60,000.00 50,000.00 40,000.00 30,000.00 20,000.00 10,000.00 FY 3/02
FY 3/03
FY 3/04
FY 3/05
FY 3/06
FY 3/07
FY 3/08
0.18 0.16 0.14 0.12 0.10 0.08 0.06 0.04 0.02 -0.02 -0.04 -0.06 -0.08 -0.10 FY 3/02
FY 3/03
FY 3/04
FY 3/05
FY 3/06
FY 3/07
FY 3/08
-0.08 -0.10 FY 3/02
FY 3/03
75,000.00 70,000.00 65,000.00 60,000.00 55,000.00 50,000.00 45,000.00 40,000.00 35,000.00 30,000.00 25,000.00 20,000.00 15,000.00 10,000.00 5,000.00 -5,000.00 -10,000.00 FY 3/02
FY 3/04
FY 3/03
FY 3/05
FY 3/04
FY 3/05
FY 3/06
FY 3/06
60.0% 55.0% 50.0% 45.0% 40.0% 35.0% 30.0% 25.0% 20.0% 15.0% 10.0% 5.0% 0.0% FY 3/02
FY 3/03
FY 3/04
FY 3/05
FY 3/06
FY 3/07
FY 3/07
FY 3/08
FY 3/08
20.0% 15.0% 10.0% 5.0% 0.0% FY 3/02
FY 3/03
FY 3/04
FY 3/05
FY 3/06
FY 3/07
25,000.00 22,500.00 20,000.00 17,500.00 15,000.00 12,500.00 10,000.00 7,500.00 5,000.00 2,500.00 -2,500.00 -5,000.00 -7,500.00 FY 3/02 FY 3/03
20.0% 19.0% 18.0% 16.0% 14.0% 12.0% 10.0% 8.0% 6.0% 4.0%
FY 3/04
FY 3/05
FY 3/06
FY 3/07
FY 3/08
FY 3/08
12.0% 10.0% 8.0% 6.0% 4.0% 2.0% 0.0% FY 3/02
FY 3/03
FY 3/04
FY 3/05
FY 3/06
FY 3/07
FY 3/08
24,000.00 22,000.00 20,000.00 18,000.00 16,000.00 14,000.00 12,000.00 10,000.00 8,000.00 6,000.00 4,000.00 2,000.00 -2,000.00 -4,000.00 -6,000.00 -8,000.00 FY 3/02
18.0% 17.0% 16.0% 15.0% 14.0% 12.0%
FY 3/03
FY 3/04
FY 3/05
FY 3/06
FY 3/07
FY 3/08
18.0% 17.0% 16.0% 15.0% 14.0% 12.0% 10.0% 8.0% 6.0% 4.0% 2.0% 0.0% FY 3/02
FY 3/03
FY 3/04
FY 3/05
FY 3/06
FY 3/07
FY 3/08
20,000.00 18,000.00 16,000.00 14,000.00 12,000.00 10,000.00 8,000.00 6,000.00 4,000.00 2,000.00 -2,000.00 -4,000.00 -6,000.00 -8,000.00 FY 3/02
15.0% 14.0% 13.0% 12.0%
FY 3/03
FY 3/04
FY 3/05
FY 3/06
FY 3/07
FY 3/08
15.0% 14.0% 13.0% 12.0% 11.0% 10.0% 9.0% 8.0% 7.0% 6.0% 5.0% 4.0% 3.0% 2.0% 1.0% 0.0% FY 3/02
FY 3/03
FY 3/04
FY 3/05
FY 3/06
FY 3/07
FY 3/08
25,000.00 22,500.00 20,000.00 17,500.00 15,000.00 12,500.00 10,000.00 7,500.00 5,000.00 2,500.00 -2,500.00 -5,000.00 -7,500.00 FY 3/02
INR 15.00 INR 14.00
FY 3/03
FY 3/04
FY 3/05
FY 3/06
FY 3/07
FY 3/08
INR 15.00 INR 14.00 INR 13.00 INR 12.00 INR 11.00 INR 10.00 INR 9.00 INR 8.00 INR 7.00 INR 6.00 INR 5.00 INR 4.00 INR 3.00 INR 2.00 INR 1.00 INR FY 3/02
FY 3/03
FY 3/04
FY 3/05
FY 3/06
FY 3/07
26,000.00 24,000.00 22,000.00 20,000.00 18,000.00 16,000.00 14,000.00 12,000.00 10,000.00 8,000.00 6,000.00 4,000.00 2,000.00 Column B Column D
Column E
Column F
Column G
FY 3/08
Column B Column D
Column E
Column F
Column G
300 275 250 225 200 175 150 125 100 75 50 25 FY 3/02
FY 3/03
FY 3/04
FY 3/05
FY 3/06
FY 3/07
-10 -20 -30 -40 -50 -60 -70 -80 -90 -100 -110 -120 FY 3/02
FY 3/03
FY 3/04
FY 3/05
FY 3/06
-80 -90 -100 -110 -120 FY 3/02
FY 3/03
FY 3/04
FY 3/05
FY 3/06
21,000.00 20,000.00 19,000.00 18,000.00 17,000.00 16,000.00 15,000.00 14,000.00 13,000.00 12,000.00 11,000.00 10,000.00 8,000.00 6,000.00 4,000.00 2,000.00 Column B
30,000.00 27,500.00 25,000.00 22,500.00 20,000.00 17,500.00 15,000.00 12,500.00 10,000.00 7,500.00 5,000.00
Column C
Column D
Column E
Column F
Column G
17,500.00 15,000.00 12,500.00 10,000.00 7,500.00 5,000.00 2,500.00 FY 3/02 FY 3/03
100.00% 95.00% 90.00% 85.00% 80.00% 75.00% 70.00% 65.00% 60.00% 55.00% 50.00% 45.00% 40.00% 35.00% 30.00% 25.00% 20.00% 15.00% 10.00% 5.00% 0.00% FY 3/02
FY 3/03
FY 3/04
FY 3/04
FY 3/05
FY 3/05
FY 3/06
FY 3/06
FY 3/07
FY 3/07
FY 3/08
FY 3/08
3/07
07
FY 3/08
FY 3/08
07
3/07
FY 3/08
FY 3/08
07
3/08
FY 3/08
Row 61
07
3/07
FY 3/08
FY 3/08
07
3/07
FY 3/08
FY 3/08
07
07
FY 3/08
Row 61 Row 65 Row 80
FY 3/08
3/07
nG
FY 3/08
Row 123
nG
Row 327 Row 325 Row 324
/06
FY 3/07
FY 3/06
FY 3/08
FY 3/07
FY 3/08
F
FY 3/06
Column G
FY 3/07
FY 3/08
/07
FY 3/08
Row 236 Row 219
FY 3/08
60,946.18 4,285.88 10,459.86 0.19 2,217.97 43,982.28 21.5%
FY 3/03 106,030.54 3,954.84 102,075.70 -8.5% 44,857.10 57,218.60 7.2% 56.1% 7,302.35 29,191.10 703.88 21,429.03 76.3% 21.0% 2,339.50 19,089.53 101.6% 18.7% 142.86 1,874.03 20,820.70 88.5% 20.4% 5,726.11 15,094.59 131.0% 14.8% 1,359.93 0.0% INR 11.10 131.0%
FY 3/04 104,520.37 10,289.11 94,231.26 -7.7% 46,222.86 48,008.40 -16.1% 50.9% 7,228.99 25,045.29 682.63 16,416.75 -23.4% 17.4% 2,761.93 13,654.82 -28.5% 14.5% 179.19 1,950.56 15,426.19 -25.9% 16.4% 4,604.48 10,821.71 -28.3% 11.5% 1,359.93 0.0% INR 7.96 -28.3%
FY 3/05 107,576.48 10,831.36 96,745.12 2.7% 47,117.17 49,627.95 3.4% 51.3% 7,067.52 24,656.96 334.93 18,238.40 11.1% 18.9% 2,073.76 16,164.64 18.4% 16.7% 172.06 2,437.56 18,430.14 19.5% 19.1% 6,493.85 11,936.29 10.3% 12.3% 1,359.93 0.0% INR 8.78 10.3%
64.61 51.53
15.28
23.01
-
-
638.65
438.13 115.67
32.59 331.55 68.04
13.33 250.00 158.12
64,370.15 9,459.00 10,047.57 2,149.73 42,713.85 44.7%
57,864.79 10,526.17 1,317.98 13,043.22 136.49 32,840.93 41.6%
58,489.54 15,015.48 492.62 5,741.84 356.03 36,883.57 43.8%
Fixed assets excluding goodwill Current assets excluding cash Interest accrued Inventories Sundry debtors Loans and advances Current liabilities excluding debt Liabilities Provisions Capital invested Return on capital invested
18,033.37 25,948.91 196.90 8,018.59 7,288.50 10,444.92 30,558.60 25,392.35 5,166.25 13,423.68 70.5%
16,097.67 26,616.18 450.16 5,998.68 4,416.75 15,750.59 33,356.73 26,133.82 7,222.91 9,357.12 204.0%
11,487.40 21,353.53 463.96 6,591.29 3,316.98 10,981.30 30,012.12 23,269.96 6,742.16 2,828.81 482.7%
16,400.69 20,482.88 546.98 7,841.77 1,773.93 10,320.20 31,872.35 22,101.90 9,770.45 5,011.22 322.6%
Cash and bank Investments Cash and cash equivalents
10,459.86 4,285.88 14,745.74
10,047.57 9,459.00 19,506.57
13,043.22 10,526.17 23,569.39
5,741.84 15,015.48 20,757.32
2,217.97 628.13 3,203.81 109.46 7,207.05 7,211.06 1,155.70 52.36 21,785.54 1,870.00 19,915.54 335.80 20,251.34
2,149.73 531.50 2,966.49 96.27 6,692.10 4,691.35 816.93 52.34 17,996.71 17,996.71 250.69 18,247.40
136.49 67.64 249.19 93.86 6,003.93 4,246.32 369.21 28.37 11,195.01 11,195.01 428.88 11,623.89
424.48 5,552.01 3,291.27 367.43 16.12 9,651.31 9,651.31 6,749.38 16,400.69
Inventories Stores and spares Raw and packing materials Work in process Finished goods Total
287.21 1,675.15 323.83 5,732.40 8,018.59
225.23 1,624.60 335.02 3,813.83 5,998.68
202.68 1,148.06 132.14 5,108.41 6,591.29
219.80 1,074.87 300.80 6,246.30 7,841.77
Sundry debtors Unsecured considered good Over six months Others Total
203.83 7,084.67 7,288.50
73.82 4,342.93 4,416.75
0.07 3,316.91 3,316.98
1,773.93 1,773.93
306.83
326.22
6,544.00 1,335.50 873.50
5,383.00 1,683.07 1,541.52
Fixed assets Goodwill and trademarks Copyrights and design Technical know how Land - leasehold Buildings Plant and machinery Furniture and equipments Vehicles Less: Provision for under utilised assets Capital work in progress & advances Total Fixed assets
Loans and advances Secured: Loans to employees 200.77 254.69 Unsecured: Inter - corporate deposits 6,576.00 12,167.00 Advances recoverable in cash or in kind or for value 1,324.62 to be received755.71 Advance tax (net of provision for taxation) Balances with excise authorities 508.38 25.66
Deposits - others
Total
Liabilities Acceptances Sundry creditors Unclaimed dividend Other liabilities Interest accured but not due Total Provisions Taxations (net of advance tax payments) Fringe benefit taxation Second interim dividend - proposed Third interim dividend Special dividend Dividend tax on second interim dividend Gratuity Leave encashments Others Total Cash Debt Secured loans Bank loan Unsecured loans Loans Sales tax deferral Shareholder's equity Tangible book value (TBV) TBV/share CASH FLOW Net profit before tax Adjustments Foreign exchange (gain)/loss Depreciation and amortization Interest expenses Profit on sale of investments Loss on disposal of a subsidiary Provision for underutilised assets (gain)/loss on retirement of fixed assets Gain on pre-payment of sale tax deferral liability Interest income (A) Changes in working capital Inventories Sundry debtors Loans and advances Current liabilities and provisions Miscellaneous expenditure (B)
1,835.15 10,444.92
2,547.53 15,750.59
1,921.47 10,981.30
1,386.39 10,320.20
111.70 23,410.73 1,845.97 23.95 25,392.35
2,079.87 22,888.61 408.08 757.26 26,133.82
2,038.03 15,835.92 435.60 4,960.41 23,269.96
3,900.16 16,939.53 472.50 789.71 22,101.90
1,899.56 2,379.87 605.18 281.64 5,166.25
2,905.01 2,719.86 348.48 591.04 658.52 7,222.91
2,109.59 1,699.91 217.81 65.32 340.28 2,309.25 6,742.16
289.25 2,039.89 286.09 572.77 6,582.45 9,770.45
14,745.74 2,330.93 1,406.25 1,406.25 924.68 160.00 764.68
19,506.57 1,620.25 1,406.25 1,406.25 214.00 214.00 -
23,569.39 1,341.88 1,125.00 1,125.00 216.88 216.88 -
20,757.32 919.76 521.88 521.88 397.88 397.88 -
25,456.13 23,237.97 INR 17.09
27,870.23 25,720.50 INR 18.91
25,237.75 25,101.26 INR 18.46
25,697.43 25,341.40 INR 18.63
11,134.85
14,268.36
15,843.09
17,736.61
6.27 2,686.35 107.61 -164.76 1,480.00 73.24 -1,680.77 13,642.79
21.57 2,339.50 142.86 51.53 64.61 160.29 -115.67 -438.13 -1,874.03 14,620.89
4.34 2,761.93 179.19 15.28 -68.04 -32.59 -1,950.56 16,752.64
77.37 2,527.08 172.06 23.01 -158.12 -13.33 -2,437.56 17,927.12
1,651.06 -2,732.49 1,732.22 1,916.48 2,567.27
2,019.90 2,868.46 280.23 2,586.66 0.19 7,755.44
-592.61 1,099.77 -853.71 -1,426.09 -1,772.64
-1,250.47 1,543.05 -499.89 1,748.91 1,541.60
Direct taxes paid Cash from operating activities
-3,874.47 12,335.59
-5,802.79 16,573.54
-6,967.78 8,012.22
-7,275.40 12,193.32
Purchase of fixed assets Sale of fixed assets Purchase of investments Sale of investments Inter-corporate deposits Interest received
-992.24 77.04 -5,305.92 5,584.81 2,594.00 1,919.91
-702.01 221.85 -6,759.00 1,579.35 -5,591.00 1,620.77
-885.46 149.00 -1,176.22 93.77 5,623.00 1,936.76
-8,091.47 589.68 -4,709.24 196.91 1,161.00 2,354.53
Cash from investing activities
3,877.60
-9,630.04
5,740.85
-8,498.59
Proceeds from long term loans Sales tax deferral Interest paid Dividend paid Dividend tax paid
954.10 71.83 -99.49 -12,961.67 -1,491.16
54.00 -326.54 -166.81 -6,877.57 -
-278.37 32.59 -179.19 -9,152.00 -1,176.11
-422.13 13.33 -172.06 -9,142.58 -1,195.30
Cash from financing activities
-13,526.39
-7,316.92
-10,753.08
-10,918.74
2,686.80 7,779.33 -6.27 10,459.86
-373.42 10,459.86 -21.57 -17.30 10,047.57
2,999.99 10,047.57 -4.34 13,043.22
-7,224.01 13,043.22 -77.37 5,741.84
108,187.44
99,858.11 -7.7% 94.2% 5,651.74 -28.6% 5.3% 520.69 81.2% 0.5% 106,030.54 -8.9%
Net increase / (decrease) in cash Opening cash Forex loss Cash of subsidiary disposed off Closing cash SEGMENT - Business Revenue (before excise duty) Oral care Growth % on total sales Personal care Growth % on total sales Others Growth % on total sales Total Total growth Segment results Oral care Growth Margin Personal care Growth Margin Others Growth Margin Corporate overheads Total growth Total margin
92.9% 7,920.12 6.8% 287.37 0.2% 116,394.93
16,325.49 15.1% -650.10 -8.2% 25.83
Total
9.0% -6,304.29 9,396.93 8.1%
19,041.23 16.6% 19.1% 309.92 -147.7% 5.5% 49.01 89.7% 9.4% -6,818.74 12,581.42 33.9% 11.9%
Depreciation and amortization Oral care Personal care Others Corporate assets Total Capex Oral care Personal care Others Corporate assets Assets Oral care Personal care Others Corporate assets Liabilities Oral care Personal care Others Corporate liabilities
1,388.56 305.94 991.84 2,686.34
1,369.47 106.04 863.99 2,339.50
Total
633.37 23.82 570.83 1,228.02
423.94 64.95 298.23 787.12
Total
38,017.22 2,529.69 58.59 20,340.50 60,946.00
31,773.48 2,149.87 65.90 30,380.90 64,370.15
Total
25,472.82 2,063.41 31.32 7,922.50 35,490.05
25,688.52 1,110.35 27.67 9,673.38 36,499.92
114,246.59
103,788.17 -9.2% 97.9% 2,242.37 4.4% 2.1% 106,030.54 -8.9%
92,158.48 -11.2% 97.8% 2,072.78 -7.6% 2.2% 94,231.26 -11.1%
94,680.62 2.7% 97.9% 2,064.50 -0.4% 2.1% 96,745.12 2.7%
Total
56,470.15 4,475.84 60,945.99
59,923.33 4,446.82 64,370.15
54,090.10 3,774.69 57,864.79
55,302.42 3,187.12 58,489.54
Total
1,141.24 86.78 1,228.02
700.79 86.33 787.12
707.69 82.67 790.36
7,691.54 43.90 7,735.44
50 24 74 148
57 21 78 197
50 15 65 169
56 10 66 150
SEGMENT - Geographical Revenue India Growth % on total sales Outside India Growth % on total sales Total Total growth Assets India Outside India Capex India Outside India
Working capital cycle Inventories turnover ratio Debtors turnover ratio Gross working capital cycle Creditors turnover ratio
98.2% 2,148.34 1.8% 116,394.93
Net working capital cycle
-73
-119
-104
-84
FY 3/06 121,925.68 9,331.85 112,593.83 16.4% 49,430.61 63,163.22 27.3% 56.1% 9,856.89 34,454.96 2,453.59 21,304.96 16.8% 18.9% 4,329.56 16,975.40 5.0% 15.1% 66.02 1,476.24 18,385.62 -0.2% 16.3% 5,068.42 13,317.20 11.6% 11.8% 1,359.93 0.0% INR 9.79 11.6% 7.33
FY 3/07 138,585.82 9,024.09 129,561.73 15.1% 57,265.94 72,295.79 14.5% 55.8% 11,342.33 40,143.87 4,026.44 24,836.03 16.6% 19.2% 1,957.34 22,878.69 34.8% 17.7% 98.04 1,688.26 24,468.91 33.1% 18.9% 4,705.61 19,763.30 48.4% 15.3% 1,359.93 0.0% INR 14.53 48.4% -
148.46
5,802.00
842.33
878.23
63,818.26 14,521.03 760.40 8,920.81 39,616.02 42.8%
70,758.08 13,021.03 2,566.95 11,486.42 43,683.68 52.4%
FY 3/08 6,213.73 -6,213.73 -6,213.73
-6,213.73
-6,213.73 -6,213.73
#DIV/0!
17,347.21 22,268.81 424.04 7,584.49 751.14 13,509.14 35,311.49 28,419.00 6,892.49 4,304.53 394.4%
19,202.78 24,480.90 386.32 8,033.06 940.80 15,120.72 42,490.91 30,554.54 11,936.37 1,192.77 1918.1%
8,920.81 14,521.03 23,441.84
11,486.42 13,021.03 24,507.45
428.19 7,437.56 7,940.53 603.94 10.49 16,420.71 16,420.71 926.50 17,347.21
406.43 6,906.40 8,794.54 656.20 4.76 16,768.33 16,768.33 2,434.45 19,202.78
243.29 1,554.84 286.28 5,500.08 7,584.49
418.36 1,400.97 186.56 6,027.17 8,033.06
751.14 751.14
940.80 940.80
342.05
413.92
6,929.00 2,666.19 759.40 756.20
6,819.00 3,617.35 1,183.57 136.75
2,056.30 13,509.14
2,950.13 15,120.72
2,912.64 21,515.72 2,917.15 1,073.49 28,419.00
4,047.19 23,265.68 1,049.04 2,192.63 30,554.54
210.00 827.43 5,855.06 6,892.49
349.00 2,719.86 462.24 946.18 7,459.09 11,936.37
23,441.84 435.52 435.52 435.52 -
24,507.45 427.50 427.50 427.50 -
28,071.25 28,071.25 INR 20.64
27,839.67 27,839.67 INR 20.47
19,072.16
19,545.14
48.76 4,329.56 66.02 7.33 -842.33 -1,476.24 21,205.26
22.07 1,957.34 98.04 -878.23 -1,688.26 19,056.10
257.28 1,022.79 -883.54 4,038.66 4,435.19
-448.57 -282.00 -1,205.07 4,825.62 2,889.98
-6,862.55 18,777.90
-6,177.68 15,768.40
-5,015.11 937.39 487.12 -1,546.00 1,599.18
-3,846.28 911.60 1,500.00 110.00 1,725.98
-3,537.42
401.30
-484.24 -66.02 -9,794.69 -1,716.56
-8.02 -98.04 -12,067.56 -1,430.47
-12,061.51
-13,604.09
3,178.97 5,741.84 8,920.81
2,565.61 8,920.81 11,486.42
111,792.91 18.1% 99.3% 800.92 -61.2% 0.7% 112,593.83 16.4%
128,583.06 15.0% 99.2% 978.67 22.2% 0.8% 129,561.73 15.1%
-
62,334.14 1,484.12 63,818.26
41,367.11 325.89 41,693.00
-
4,934.62 29.51 4,964.13
3,622.24 7.49 3,629.73
-
57 4 61 167
50 2 52 165
-
-106
-113
-
130,000.00 120,000.00 110,000.00 100,000.00 90,000.00 80,000.00 70,000.00 60,000.00 50,000.00 40,000.00 30,000.00 20,000.00 10,000.00 FY 3/02
FY 3/03
FY 3/04
FY 3/05
FY 3/06
FY 3/07
FY 3/08
0.18 0.16 0.14 0.12 0.10 0.08 0.06 0.04 0.02 -0.02 -0.04 -0.06 -0.08 -0.10 FY 3/02
FY 3/03
FY 3/04
FY 3/05
FY 3/06
FY 3/07
FY 3/08
-0.08 -0.10 FY 3/02
FY 3/03
75,000.00 70,000.00 65,000.00 60,000.00 55,000.00 50,000.00 45,000.00 40,000.00 35,000.00 30,000.00 25,000.00 20,000.00 15,000.00 10,000.00 5,000.00 -5,000.00 -10,000.00 FY 3/02
FY 3/04
FY 3/03
FY 3/05
FY 3/04
FY 3/05
FY 3/06
FY 3/06
60.0% 55.0% 50.0% 45.0% 40.0% 35.0% 30.0% 25.0% 20.0% 15.0% 10.0% 5.0% 0.0% FY 3/02
FY 3/03
FY 3/04
FY 3/05
FY 3/06
FY 3/07
FY 3/07
FY 3/08
FY 3/08
20.0% 15.0% 10.0% 5.0% 0.0% FY 3/02
FY 3/03
FY 3/04
FY 3/05
FY 3/06
FY 3/07
25,000.00 22,500.00 20,000.00 17,500.00 15,000.00 12,500.00 10,000.00 7,500.00 5,000.00 2,500.00 -2,500.00 -5,000.00 -7,500.00 FY 3/02 FY 3/03
20.0% 19.0% 18.0% 16.0% 14.0% 12.0% 10.0% 8.0% 6.0% 4.0%
FY 3/04
FY 3/05
FY 3/06
FY 3/07
FY 3/08
FY 3/08
12.0% 10.0% 8.0% 6.0% 4.0% 2.0% 0.0% FY 3/02
FY 3/03
FY 3/04
FY 3/05
FY 3/06
FY 3/07
FY 3/08
24,000.00 22,000.00 20,000.00 18,000.00 16,000.00 14,000.00 12,000.00 10,000.00 8,000.00 6,000.00 4,000.00 2,000.00 -2,000.00 -4,000.00 -6,000.00 -8,000.00 FY 3/02
18.0% 17.0% 16.0% 15.0% 14.0% 12.0%
FY 3/03
FY 3/04
FY 3/05
FY 3/06
FY 3/07
FY 3/08
18.0% 17.0% 16.0% 15.0% 14.0% 12.0% 10.0% 8.0% 6.0% 4.0% 2.0% 0.0% FY 3/02
FY 3/03
FY 3/04
FY 3/05
FY 3/06
FY 3/07
FY 3/08
20,000.00 18,000.00 16,000.00 14,000.00 12,000.00 10,000.00 8,000.00 6,000.00 4,000.00 2,000.00 -2,000.00 -4,000.00 -6,000.00 -8,000.00 FY 3/02
15.0% 14.0% 13.0% 12.0%
FY 3/03
FY 3/04
FY 3/05
FY 3/06
FY 3/07
FY 3/08
15.0% 14.0% 13.0% 12.0% 11.0% 10.0% 9.0% 8.0% 7.0% 6.0% 5.0% 4.0% 3.0% 2.0% 1.0% 0.0% FY 3/02
FY 3/03
FY 3/04
FY 3/05
FY 3/06
FY 3/07
FY 3/08
25,000.00 22,500.00 20,000.00 17,500.00 15,000.00 12,500.00 10,000.00 7,500.00 5,000.00 2,500.00 -2,500.00 -5,000.00 -7,500.00 FY 3/02
INR 15.00 INR 14.00
FY 3/03
FY 3/04
FY 3/05
FY 3/06
FY 3/07
FY 3/08
INR 15.00 INR 14.00 INR 13.00 INR 12.00 INR 11.00 INR 10.00 INR 9.00 INR 8.00 INR 7.00 INR 6.00 INR 5.00 INR 4.00 INR 3.00 INR 2.00 INR 1.00 INR FY 3/02
FY 3/03
FY 3/04
FY 3/05
FY 3/06
FY 3/07
26,000.00 24,000.00 22,000.00 20,000.00 18,000.00 16,000.00 14,000.00 12,000.00 10,000.00 8,000.00 6,000.00 4,000.00 2,000.00 Column B Column D
Column E
Column F
Column G
FY 3/08
Column B Column D
Column E
Column F
Column G
300 275 250 225 200 175 150 125 100 75 50 25 FY 3/02
FY 3/03
FY 3/04
FY 3/05
FY 3/06
FY 3/07
-10 -20 -30 -40 -50 -60 -70 -80 -90 -100 -110 -120 FY 3/02
FY 3/03
FY 3/04
FY 3/05
FY 3/06
-80 -90 -100 -110 -120 FY 3/02
FY 3/03
FY 3/04
FY 3/05
FY 3/06
21,000.00 20,000.00 19,000.00 18,000.00 17,000.00 16,000.00 15,000.00 14,000.00 13,000.00 12,000.00 11,000.00 10,000.00 8,000.00 6,000.00 4,000.00 2,000.00 Column B
30,000.00 27,500.00 25,000.00 22,500.00 20,000.00 17,500.00 15,000.00 12,500.00 10,000.00 7,500.00 5,000.00
Column C
Column D
Column E
Column F
Column G
17,500.00 15,000.00 12,500.00 10,000.00 7,500.00 5,000.00 2,500.00 FY 3/02 FY 3/03
100.00% 95.00% 90.00% 85.00% 80.00% 75.00% 70.00% 65.00% 60.00% 55.00% 50.00% 45.00% 40.00% 35.00% 30.00% 25.00% 20.00% 15.00% 10.00% 5.00% 0.00% FY 3/02
FY 3/03
FY 3/04
FY 3/04
FY 3/05
FY 3/05
FY 3/06
FY 3/06
FY 3/07
FY 3/07
FY 3/08
FY 3/08
3/07
07
FY 3/08
FY 3/08
07
3/07
FY 3/08
FY 3/08
07
3/08
FY 3/08
Row 61
07
3/07
FY 3/08
FY 3/08
07
3/07
FY 3/08
FY 3/08
07
07
FY 3/08
Row 61 Row 65 Row 80
FY 3/08
3/07
nG
FY 3/08
Row 123
nG
Row 327 Row 325 Row 324
/06
FY 3/07
FY 3/06
FY 3/08
FY 3/07
FY 3/08
F
FY 3/06
Column G
FY 3/07
FY 3/08
/07
FY 3/08
Row 236 Row 219
FY 3/08
Related Documents
Colgate
November 2019 22
Colgate Brand
April 2020 10
Porter Colgate
August 2019 24
Project Report (colgate Palmolive)
April 2020 5
Colgate Ar March 2006
November 2019 21