0% found this document useful (0 votes)
385 views42 pages

Balance Sheet of Colgate-Palmolive (India) Limited: Particulars 2021 2020

The balance sheet shows the assets, liabilities and equity of Colgate-Palmolive (India) Limited as of 2021 and 2020. Total assets decreased from Rs. 2,60,396.78 lakhs in 2020 to Rs. 2,89,401.48 lakhs in 2021, with non-current assets decreasing from Rs. 1,59,193.68 lakhs to Rs. 1,52,143.09 lakhs and current assets increasing from Rs. 1,01,203.10 lakhs to Rs. 1,37,258.39 lakhs. Total equity decreased from Rs. 1,59,415.89 lakhs to Rs. 1,

Uploaded by

ABHISHEK KHURANA
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
385 views42 pages

Balance Sheet of Colgate-Palmolive (India) Limited: Particulars 2021 2020

The balance sheet shows the assets, liabilities and equity of Colgate-Palmolive (India) Limited as of 2021 and 2020. Total assets decreased from Rs. 2,60,396.78 lakhs in 2020 to Rs. 2,89,401.48 lakhs in 2021, with non-current assets decreasing from Rs. 1,59,193.68 lakhs to Rs. 1,52,143.09 lakhs and current assets increasing from Rs. 1,01,203.10 lakhs to Rs. 1,37,258.39 lakhs. Total equity decreased from Rs. 1,59,415.89 lakhs to Rs. 1,

Uploaded by

ABHISHEK KHURANA
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 42

BALANCE SHEET OF COLGATE-PALMOLIVE (IN

Particulars 2021 2020


ASSETS
Non-Current Assets

Property Plant and Equipment 106471.61 112286.16


Capital Work-in-Progress 14484.96 19003.27
Other Intangible Assets - 0.00
Financial Assets
(i) Investments 1861.45 1861.65
(ii) Loans 140.38 203.56
(iii) Others 1855.63 1769.04
476.81 -
Other Non-Current Assets 1020.76 1596.70
Current Tax Assets 25831.49 22473.30
Total Non-Current Assets 152143.09 159193.68

Current Assets
Inventories 33582.14 29692.18
Financial Assets
(i) Trade Receivables 11708.43 13256.43
(ii) Cash and Cash
Equivalents 29657.29 39781.68
(iii) Bank Balance (Other than
(iii)) 57106.21 2345.17
(iv) Loans 692.72 11347.97
(v) Others 508.74 732.21
Other Current Assets 4002.86 4047.46
Total Current Assets 137258.39 101203.10

Total Assets 289401.48 260396.78

Equity and Liabilities


Equity
Equity Share Capital 2719.86 2719.86
Other Equity 113866.44 156696.03
Total Equity 116586.30 159415.89

Liabilities
Non-Current Liabilities
Financial Liabilities
(i) Lease Liabilities 7735.57 8397.23
(ii) Borrowings 124.03 0.00
(iii) Other Financial Liabilities 3113.13 118.13
Provision - 4882.53
Deferred Tax Liabilities 503.86
Other Non-Current
Total Non-Current Liabilities 47.33 49.01
Liabilities 11020.06 13950.76

Current Liabilities
Financial Liabilities
(i) Lease Liabilities 1381.98 1752.43
(ii) Trade Payables 0.00
-Total Outstanding Dues of
MSME's 1187.40 1272.70
-Total Outstanding Dues of
Creditors other than MSME's 74856.60 59978.64
(iii) Other Financial Liabilities 58111.82 2552.47
Other Current Liabilities 13069.07 10342.43
Provisions 8104.83 6048.24
Current Tax Liabilities 5083.41 5083.41
Total Current Liabilities 161795.11 87030.32

Total Liabilities 172815.17 100981.08


Total Equity and
Liabilities 289401.47 260396.97
E-PALMOLIVE (INDIA) LIMITED

₹ in Lakhs
2019 2018 2017

119085.12 114591.23 110810.85


19870.35 15857.57 16659.11
0.00 0.00 0.00

3115.16 3115.54 3115.76


269.83 306.40 267.20
1431.70 2306.20 2347.65
- - -
2828.40 3921.18 5431.09
15031.88 10215.70 8144.82
161632.44 150313.82 146776.48

24857.37 22670.55 29255.10

20978.64 20103.24 12989.62

37799.83 30538.96 19856.44

2135.37 15077.18 9574.00


11496.42 9058.27 6295.36
647.14 669.50 645.66
3101.09 7954.24 6946.00
101015.86 106071.94 85562.18

262648.30 256385.76 232338.66

2719.86 2719.86 2719.86


141955.46 149740.83 124659.85
144675.32 152460.69 127379.71
0.00 0.00 0.00
7771.09 0.00 0.00
118.13 133.13 114.23
1836.91 1909.96 2513.32
3086.86 3551.84 2747.76
49.52 51.22 54.95
12862.51 5646.15 5430.26

0.00 0.00 0.00


0.00 61446.80 60120.47

602.11 0.00 0.00

60716.09 0.00 0.00


21976.72 15822.44 12817.97
10343.78 10239.30 13586.97
6388.36 6034.63 5642.21
5083.41 4735.75 7361.07
105110.47 98278.92 99528.69

117972.98 103925.07 104958.95

262648.30 256385.76 232338.66


INCOME STATEMEN

Particulars 2021
Revenue from Operations 484121.56
Other Income 3035.38
(A) Total Income 487156.94

Expenses
Cost of Material Consumed 124958.34
Purchase of Stock-in-Trade 32358.71
Changes in Inventory of Finished
Goods, Stock-in-Trade,
and Work-in-Progress -2379.88
Employee Benefit Expense 36564.02
Finance Cost 725.90
Excise Duty
Depreciation and Ammortization
Expense 18249.73
Other Expense 141658.21
(B) Total Expenses 352135.03

(C) Profit Before Exceptional


Items and Tax (A-B) 135021.91

(D) Exceptional Items 0.00

(E) Profit Before Tax (C-D) 135021.91

Tax Expense
Current Tax 32573.16
Deffered Tax -1089.79

(F) Total Tax Expenses 31483.37

(G) Profit of the Year (E-F) 103538.54

Other Comprehensive Income


(net of Tax)
Items that will not be re-
classified to profit and loss
Re-measurement loss/gains on
defined benefit plans -433.55
Tax adjustment on above 109.12
(H) Re-measurement loss/gains
on defined benefits plans (net of
tax) -324.43
(I) Total Comprehensive
Income (G-H) 103862.97
INCOME STATEMENT

₹ in Lakhs
2020 2019 2018 2017
452508.34 446243.18 432842.44 452019.82
4924.27 3765.54 3882.05 4112.43
457432.61 450008.72 436724.49 456132.25

135033.47 132847.32 118896.97 115599.43


24410.57 25458.22 28442.88 31475.29

-2155.89 -2447.67 1667.98 558.40


33228.45 29590.34 30593.49 28850.25
961.55 249.53 0.00 0.00
0.00 0.00 14044.65 53838.05

19794.04 15916.83 15651.00 13324.28


141824.59 137189.16 127959.30 127343.62
353096.78 338803.73 337256.27 370989.32

104335.83 111204.99 99468.22 85142.93

0.00 -3050.52 1165.07 0.00

104335.83 114255.51 98303.15 85142.93

24750.04 37168.69 30218.54 25345.64


-2060.81 -470.06 747.12 2054.05

22689.23 36698.63 30965.66 27399.69

81646.60 77556.88 67337.49 57743.24


2074.80 -14.72 -164.59 790.67
-522.19 5.09 59.96 -273.64

1552.61 -9.63 -104.63 517.03

80093.99 77566.51 67442.12 57226.21


STATEMENT OF CASH FLOW

Particulars 2021

Cash Flow Operating Activities


Profit before Exceptional Items and Tax 135021.91
Adjustment for:
Unrealized Foreign Exchange Gain/Loss 160.28
Depreciation and Amortization Expense 18249.73
Lease Rental received -247.08
Net Gain on disposal of property, plant and equipment 68.54
Interest income on Financial Assets at Amortised Cost -1971.79
Finance Cost 725.90
Inteterest on Income Tax Return 0.00
Bad Debts written off / Provision for Bad Debts 0.00
Bad Debts Recovered -7.04
Provision no longer required written back -509.51
Interest Income from Unwinding of Discount on Security Deposits -127.69
Employee Share based Payment Expense 1118.24
Operating Profit Before Working Capital Changes 152481.49
Adjustment for Increase/Decrease in Working Capital
Increase in Inventories -3890.46
Decrease in Financial Assets -52795.74
Increase/Decrease in Trade Receivables 0.00
Increase /Decrease in Other Assets 178.64
Increase/Decrease in Financial Liabilities 14293.29
Increase in Other Liabilities and Provisions 3955.22
Cash Generated From Operations 114222.44
Direct TaxPaid (net) -35836.66
Exceptional Items 0.00
Net Cash Generated From Operating Activities (A) 78385.78

Cash Flow From Investing Activities


Purchase of Plant, Property and Equipment including
Capital Work-in-Progress and Capital Advances -5776.12
Proceeds from Disposal of Propert, Plant and Equipment 42.43
Proceeds from Disposal of Current Investments 10596.49
Lease Rental Received 247.08
Investment in Inter-Corporate Bank Deposits 0.00
Proceeds from Disposal of Non-Current Investments 0.40
Interest Received 2025.07
Net Cash from Investing Activities (B) 7135.35

Cash Flow from Financing Activities


Payment of Finance Lease Obligation 0.00
Dividends Paid -92111.20
Dividend Distribution Tax Paid 0.00
Payment of Lease liabilities -2501.97
Employee Share based Payments -1032.35
Net Cash Used In Financing Activities (C) -95645.52

Net Increase in Cash and Cash Equivalents (A+B+C) -10124.39


Cash and Cash Equivalents at the beginning of the year 39781.68
Cash and Cash Equivalents at the end of the year 29657.29
F CASH FLOW

₹ in Lakhs
2020 2019 2018 2017

104335.83 111204.99 99468.22 85142.93

-115.58 -121.76 -22.47 -238.78


19794.04 15916.83 15651.00 13324.28
-236.25 -236.25 -196.88 -198.45
-2.13 -9.19 16.59 -0.57
-2543.80 -2891.33 -2725.35 -2816.82
961.55 168.22 0.00 0.00
0.00 0.00 0.00 -52.58
9.50 406.87 68.62 37.21
0.00 0.00 0.00 0.00
-1580.63 0.00 0.00 -148.11
-130.52 -449.19 -176.85 -101.70
974.45 806.77 941.64 885.70
121466.46 124795.96 113024.52 95833.11

-4834.81 -2186.82 6584.55 -102.09


7453.16 12880.35 -5323.59 -135.64
0.00 0.00 -7182.24 -2736.15
-1121.62 4230.30 -1046.53 171.37
999.80 -601.84 1742.03 5165.19
1123.84 620.11 -3663.54 742.90
125086.83 139738.06 104135.20 98938.69
-32128.90 -41438.31 -34742.03 -30138.26
0.00 0.00 0.00 0.00
92957.93 98299.75 69393.17 68800.43

-6039.85 -13880.52 -20892.40 -32125.44


3.44 3458.38 21.87 0.70
73.16 0.38 0.22 0.00
236.25 236.25 173.64 198.45
0.00 -2305.35 -2732.41 -5057.46
1253.31 0.00 0.00 0.00
2608.05 2920.13 2695.27 2773.27
-1865.64 -9570.73 -20733.81 -34210.48

0.00 -1205.00 0.00 0.00


-73149.27 -64621.86 -29856.48 -27170.68
-11181.49 -14535.93 -7198.09 -5536.99
-3967.87
-811.81 -1105.36 -922.27 -1350.61
-89110.44 -81468.15 -37976.84 -34058.28

1981.85 7260.87 10682.52 531.67


37799.83 30538.96 19856.44 19324.77
39781.68 37799.83 30538.96 19856.44
BALANCE SHEET - VERTIC
Particulars 2021 2020
ASSETS
Non-Current Assets
Property Plant and Equipment 106471.61 112286.16
Capital Work-in-Progress 14484.96 19003.27
Other Intangible Assets - 0.00
Financial Assets
(i) Investments 1861.45 1861.65
(ii) Loans 140.38 203.56
(iii) Others 1855.63 1769.04
476.81 -
Other Non-Current Assets 1020.76 1596.70
Current Tax Assets 25831.49 22473.30
Total Non-Current Assets 152143.09 159193.68

Current Assets
Inventories 33582.14 29692.18
Financial Assets
(i) Trade Receivables 11708.43 13256.43
(ii) Cash and Cash Equivalents 29657.29 39781.68
(iii) Bank Balance (Other than (iii)) 57106.21 2345.17
(iv) Loans 692.72 11347.97
(v) Others 508.74 732.21
Other Current Assets 4002.86 4047.46
Total Current Assets 137258.39 101203.10

Total Assets 289401.48 260396.78

Equity and Liabilities


Equity
Equity Share Capital 2719.86 2719.86
Other Equity 113866.44 156696.03
Total Equity 116586.30 159415.89

Liabilities
Non-Current Liabilities
Financial Liabilities
(i) Lease Liabilities 7735.57 8397.23
(ii) Borrowings 124.03 0.00
(iii) Other Financial Liabilities 3113.13 118.13
Provision - 4882.53
Deferred Tax Liabilities 503.86
Other Non-Current Liabilities 47.33 49.01
Total Non-Current Liabilities 11020.06 13950.76

Current Liabilities
Financial Liabilities
(i) Lease Liabilities 1381.98 1752.43
(ii) Trade Payables 0.00
-Total Outstanding Dues of MSME's 1187.40 1272.70
-Total Outstanding Dues of Creditors other than MSME's 74856.60 59978.64
(iii) Other Financial Liabilities 58111.82 2552.47
Other Current Liabilities 13069.07 10342.43
Provisions 8104.83 6048.24
Current Tax Liabilities 5083.41 5083.41
Total Current Liabilities 161795.11 87030.32

Total Liabilities 172815.17 100981.08


Total Equity and Liabilities 289401.47 260396.97
NCE SHEET - VERTICAL ANALYSIS
2019 2018 2017 2021-2 2020-2 2019-2

119085.12 114591.23 110810.85 36.79 43.12 45.34


19870.35 15857.57 16659.11 5.01 7.30 7.57
0.00 0.00 0.00 0.00 0.00
0.00
3115.16 3115.54 3115.76 0.64 0.71 1.19
269.83 306.40 267.20 0.05 0.08 0.10
1431.70 2306.20 2347.65 0.64 0.68 0.55
- - - 0.16
2828.40 3921.18 5431.09 0.35 0.61 1.08
15031.88 10215.70 8144.82 8.93 8.63 5.72
161632.44 150313.82 146776.48 52.57 61.14 61.54

24857.37 22670.55 29255.10 11.60 11.40 9.46


0.00 0.00 0.00
20978.64 20103.24 12989.62 4.05 5.09 7.99
37799.83 30538.96 19856.44 10.25 15.28 14.39
2135.37 15077.18 9574.00 19.73 0.90 0.81
11496.42 9058.27 6295.36 0.24 4.36 4.38
647.14 669.50 645.66 0.18 0.28 0.25
3101.09 7954.24 6946.00 1.38 1.55 1.18
101015.86 106071.94 85562.18 47.43 38.86 38.46

262648.30 256385.76 232338.66 100.00 100.00 100.00

2719.86 2719.86 2719.86 0.94 1.04 1.04


141955.46 149740.83 124659.85 39.35 60.18 54.05
144675.32 152460.69 127379.71 40.29 61.22 55.08

0.00 0.00 0.00 2.67 3.22 0.00


7771.09 0.00 0.00 0.04 0.00 2.96
118.13 133.13 114.23 1.08 0.05 0.04
1836.91 1909.96 2513.32 1.88 0.70
3086.86 3551.84 2747.76 0.00 0.19 1.18
49.52 51.22 54.95 0.02 0.02 0.02
12862.51 5646.15 5430.26 3.81 5.36 4.90

0.00 0.00 0.00 0.48 0.67 0.00


0.00 61446.80 60120.47 0.00 0.00 0.00
602.11 0.00 0.00 0.41 0.49 0.23
60716.09 0.00 0.00 25.87 23.03 23.12
21976.72 15822.44 12817.97 20.08 0.98 8.37
10343.78 10239.30 13586.97 4.52 3.97 3.94
6388.36 6034.63 5642.21 2.80 2.32 2.43
5083.41 4735.75 7361.07 1.76 1.95 1.94
105110.47 98278.92 99528.69 55.91 33.42 40.02

117972.98 103925.07 104958.95 59.71 38.78 44.92


262648.30 256385.76 232338.66 100.00 100.00 100.00
2018-2 2017-2

44.69 47.69
6.19 7.17
0.00 0.00
0.00 0.00
1.22 1.34
0.12 0.12
0.90 1.01

1.53 2.34
3.98 3.51
58.63 63.17

8.84 12.59
0.00 0.00
7.84 5.59
11.91 8.55
5.88 4.12
3.53 2.71
0.26 0.28
3.10 2.99
41.37 36.83

100.00 100.00

1.06 1.17
58.40 53.65
59.47 54.83

0.00 0.00
0.00 0.00
0.05 0.05
0.74 1.08
1.39 1.18
0.02 0.02
2.20 2.34

0.00 0.00
23.97 25.88
0.00 0.00
0.00 0.00
6.17 5.52
3.99 5.85
2.35 2.43
1.85 3.17
38.33 42.84

40.53 45.17
100.00 100.00
STATEMENT OF PROFIT A

Particulars 2021
Revenue from Operations 484121.56
Other Income 3035.38
(A) Total Income 487156.94

Expenses
Cost of Material Consumed 124958.34
Purchase of Stock-in-Trade 32358.71
Changes in Inventory of Finished
Goods, Stock-in-Trade,
and Work-in-Progress -2379.88
Employee Benefit Expense 36564.02
Finance Cost 725.90
Excise Duty
Depreciation and Ammortization
Expense 18249.73
Other Expense 141658.21
(B) Total Expenses 352135.03

(C) Profit Before Exceptional Items


and Tax (A-B) 135021.91

(D) Exceptional Items 0.00

(E) Profit Before Tax (C-D) 135021.91

Tax Expense
Current Tax 32573.16
Deffered Tax -1089.79

(F) Total Tax Expenses 31483.37

(G) Profit of the Year (E-F) 103538.54

Other Comprehensive Income (net of


Tax)
Items that will not be re-classified to
profit and loss
Re-measurement loss/gains on
defined benefit plans -433.55
Tax adjustment on above 109.12
(H) Re-measurement loss/gains on
defined benefits plans (net of tax) -324.43
(I) Total Comprehensive Income
(G-H) 103862.97
MENT OF PROFIT AND LOSS - VERTICAL ANALYSIS

2020 2019 2018 2017 21 20 19 18


452508.34 446243.18 432842.44 452019.82 99.38 98.92 99.16 99.11
4924.27 3765.54 3882.05 4112.43 0.62 1.08 0.84 0.89
457432.61 450008.72 436724.49 456132.25 100.00 100.00 100.00 100.00

135033.47 132847.32 118896.97 115599.43 25.65 29.52 29.52 27.22


24410.57 25458.22 28442.88 31475.29 6.64 5.34 5.66 6.51

-2155.89 -2447.67 1667.98 558.40 -0.49 -0.47 -0.54 0.38


33228.45 29590.34 30593.49 28850.25 7.51 7.26 6.58 7.01
961.55 249.53 0.00 0.00 0.15 0.21 0.06 0.00
0.00 0.00 14044.65 53838.05 0.00 0.00 0.00 3.22

19794.04 15916.83 15651.00 13324.28 3.75 4.33 3.54 3.58


141824.59 137189.16 127959.30 127343.62 29.08 31.00 30.49 29.30
353096.78 338803.73 337256.27 370989.32 72.28 77.19 75.29 77.22
0.00 0.00 0.00 0.00

104335.83 111204.99 99468.22 85142.93 27.72 22.81 24.71 22.78


0.00 0.00 0.00 0.00
0.00 -3050.52 1165.07 0.00 0.00 0.00 -0.68 0.27

104335.83 114255.51 98303.15 85142.93 27.72 22.81 25.39 22.51


0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
24750.04 37168.69 30218.54 25345.64 6.69 5.41 8.26 6.92
-2060.81 -470.06 747.12 2054.05 -0.22 -0.45 -0.10 0.17
0.00 0.00 0.00 0.00
22689.23 36698.63 30965.66 27399.69 6.46 4.96 8.16 7.09
0.00 0.00 0.00 0.00
81646.60 77556.88 67337.49 57743.24 21.25 17.85 17.23 15.42

2074.80 -14.72 -164.59 790.67 -0.09 0.45 0.00 -0.04


-522.19 5.09 59.96 -273.64 0.02 -0.11 0.00 0.01

1552.61 -9.63 -104.63 517.03 -0.07 0.34 0.00 -0.02

80093.99 77566.51 67442.12 57226.21 21.32 17.51 17.24 15.44


₹ in Lakhs
17
99.10
0.90
100.00

25.34
6.90

0.12
6.32
0.00
11.80

2.92
27.92
81.33
0.00

18.67
0.00
0.00

18.67
0.00
0.00
5.56
0.45
0.00
6.01
0.00
12.66

0.17
-0.06

0.11

12.55
BALANCE SHEET - H

Particulars 2021 2020


ASSETS
Non-Current Assets
Property Plant and Equipment 106471.61 112286.16
Capital Work-in-Progress 14484.96 19003.27
Other Intangible Assets
Financial Assets
(i) Investments 1861.45 1861.65
(ii) Loans 140.38 203.56
(iii) Others 1855.63 1769.04
476.81 -
Other Non-Current Assets 1020.76 1596.70
Current Tax Assets 25831.49 22473.30
Total Non-Current Assets 152143.09 159193.68

Current Assets
Inventories 33582.14 29692.18
Financial Assets
(i) Trade Receivables 11708.43 13256.43
(ii) Cash and Cash Equivalents 29657.29 39781.68
(iii) Bank Balance (Other than (iii)) 57106.21 2345.17
(iv) Loans 692.72 11347.97
(v) Others 508.74 732.21
Other Current Assets 4002.86 4047.46
Total Current Assets 137258.39 101203.10

Total Assets 289401.48 260396.78

Equity and Liabilities


Equity
Equity Share Capital 2719.86 2719.86
Other Equity 113866.44 156696.03
Total Equity 116586.30 159415.89

Liabilities
Non-Current Liabilities
Financial Liabilities
(i) Lease Liabilities 7735.57 8397.23
(ii) Borrowings 124.03 0.00
(iii) Other Financial Liabilities 3113.13 118.13
Provision - 4882.53
Deferred Tax Liabilities 503.86
Other Non-Current Liabilities 47.33 49.01
Total Non-Current Liabilities 11020.06 13950.76

Current Liabilities
Financial Liabilities
(i) Lease Liabilities 1381.98 1752.43
(ii) Trade Payables 0.00
-Total Outstanding Dues of MSME's 1187.40 1272.70
-Total Outstanding Dues of Creditors other than MSME's 74856.60 59978.64
(iii) Other Financial Liabilities 58111.82 2552.47
Other Current Liabilities 13069.07 10342.43
Provisions 8104.83 6048.24
Current Tax Liabilities 5083.41 5083.41
Total Current Liabilities 161795.11 87030.32
E SHEET - HORIZONTAL ANALYSIS

2019 2018 2017 Average of 5 years 2021 2020

119085.12 114591.23 110810.85 112648.99 94.52 99.68


19870.35 15857.57 16659.11 17175.05 84.34 110.64

3115.16 3115.54 3115.76 2613.91 71.21 71.22


269.83 306.40 267.20 237.47 59.11 85.72
1431.70 2306.20 2347.65 1942.04 95.55 91.09
- - - 95.36 500.00
2828.40 3921.18 5431.09 2959.63 34.49 53.95
15031.88 10215.70 8144.82 16339.44 158.09 137.54
161632.44 150313.82 146776.48 154011.90 98.79 103.36

24857.37 22670.55 29255.10 28011.47 119.89 106.00

20978.64 20103.24 12989.62 15807.27 74.07 83.86


37799.83 30538.96 19856.44 31526.84 94.07 126.18
2135.37 15077.18 9574.00 17247.59 331.10 13.60
11496.42 9058.27 6295.36 7778.15 8.91 145.90
647.14 669.50 645.66 640.65 79.41 114.29
3101.09 7954.24 6946.00 5210.33 76.83 77.68
101015.86 106071.94 85562.18 106222.29 129.22 95.27
0.00
262648.30 256385.76 232338.66 260234.20 111.21 100.06

2719.86 2719.86 2719.86 2719.86 100.00 100.00


141955.46 149740.83 124659.85 137383.72 82.88 114.06
144675.32 152460.69 127379.71 140103.58 83.21 113.78

0.00 0.00 0.00 3226.56 239.75 260.25


7771.09 0.00 0.00 1579.02 7.85 0.00
118.13 133.13 114.23 719.35 432.77 16.42
1836.91 1909.96 2513.32 2228.54 219.09
3086.86 3551.84 2747.76 1978.06 0.00 25.47
49.52 51.22 54.95 50.41 93.90 97.23
12862.51 5646.15 5430.26 9781.95 112.66 142.62

0.00 0.00 0.00 626.88 220.45 279.55


0.00 61446.80 60120.47 24313.45 0.00 0.00
602.11 0.00 0.00 612.44 193.88 207.81
60716.09 0.00 0.00 39110.27 191.40 153.36
21976.72 15822.44 12817.97 22256.28 261.10 11.47
10343.78 10239.30 13586.97 11516.31 113.48 89.81
6388.36 6034.63 5642.21 6443.65 125.78 93.86
5083.41 4735.75 7361.07 5469.41 92.94 92.94
105110.47 98278.92 99528.69 110348.70 146.62 78.87
2019 2018 2017 Average

105.71 101.72 98.37 100


115.69 92.33 97.00 100

119.18 119.19 119.20 100


113.63 129.02 112.52 100
73.72 118.75 120.89 100
100
95.57 132.49 183.51 100
92.00 62.52 49.85 100
104.95 97.60 95.30 100

88.74 80.93 104.44 100

132.72 127.18 82.17 100


119.90 96.87 62.98 100
12.38 87.42 55.51 100
147.80 116.46 80.94 100
101.01 104.50 100.78 100
59.52 152.66 133.31 100
95.10 99.86 80.55 100

100.93 98.52 89.28 100

100.00 100.00 100.00 100


103.33 108.99 90.74 100
103.26 108.82 90.92 100

0.00 0.00 0.00 100


492.15 0.00 0.00 100
16.42 18.51 15.88 100
82.43 85.70 112.78 100
156.05 179.56 138.91 100
98.24 101.61 109.01 100
131.49 57.72 55.51 100

0.00 0.00 0.00 100


0.00 252.73 247.27 100
98.31 0.00 0.00 100
155.24 0.00 0.00 100
98.74 71.09 57.59 100
89.82 88.91 117.98 100
99.14 93.65 87.56 100
92.94 86.59 134.59 100
95.25 89.06 90.19 100
Particulars
Revenue from Operations
Other Income
(A) Total Income

Expenses
Cost of Material Consumed
Purchase of Stock-in-Trade
Changes in Inventory of Finished
Goods, Stock-in-Trade,
and Work-in-Progress
Employee Benefit Expense
Finance Cost
Excise Duty
Depreciation and Ammortization
Expense
Other Expense
(B) Total Expenses

(C) Profit Before Exceptional


Items and Tax (A-B)

(D) Exceptional Items

(E) Profit Before Tax (C-D)

Tax Expense
Current Tax
Deffered Tax

(F) Total Tax Expenses

(G) Profit of the Year (E-F)

Other Comprehensive Income


(net of Tax)
Items that will not be re-classified
to profit and loss
Re-measurement loss/gains on
defined benefit plans
Tax adjustment on above
(H) Re-measurement loss/gains
on defined benefits plans (net of
tax)
(I) Total Comprehensive
Income (G-H)
PROFIT AND LOSS - HORIZONTAL ANALYSIS

2021 2020 2019 2018 2017 Average of 5


484121.56 452508.34 446243.18 432842.44 452019.82 453547.07
3035.38 4924.27 3765.54 3882.05 4112.43 3943.93
487156.94 457432.61 450008.72 436724.49 456132.25 457491.00

124958.34 135033.47 132847.32 118896.97 115599.43 125467.11


32358.71 24410.57 25458.22 28442.88 31475.29 28429.13

-2379.88 -2155.89 -2447.67 1667.98 558.40 -951.41


36564.02 33228.45 29590.34 30593.49 28850.25 31765.31
725.90 961.55 249.53 0.00 0.00 387.40
0.00 0.00 14044.65 53838.05 13576.54

18249.73 19794.04 15916.83 15651.00 13324.28 16587.18


141658.21 141824.59 137189.16 127959.30 127343.62 135194.98
352135.03 353096.78 338803.73 337256.27 370989.32 350456.23

135021.91 104335.83 111204.99 99468.22 85142.93 107034.78

0.00 0.00 -3050.52 1165.07 0.00 -377.09

135021.91 104335.83 114255.51 98303.15 85142.93 107411.87

32573.16 24750.04 37168.69 30218.54 25345.64 30011.21


-1089.79 -2060.81 -470.06 747.12 2054.05 -163.90

31483.37 22689.23 36698.63 30965.66 27399.69 29847.32

103538.54 81646.60 77556.88 67337.49 57743.24 77564.55

-433.55 2074.80 -14.72 -164.59 790.67 450.52


109.12 -522.19 5.09 59.96 -273.64 -124.33
-324.43 1552.61 -9.63 -104.63 517.03 326.19

103862.97 80093.99 77566.51 67442.12 57226.21 77238.36


ANALYSIS
₹ in Lakhs
21 20 19 18 17 Average
106.74 99.77 98.39 95.43 99.66 100.00
76.96 124.86 95.48 98.43 104.27 100.00
106.48 99.99 98.36 95.46 99.70 100.00

99.59 107.62 105.88 94.76 92.14 100.00


113.82 85.86 89.55 100.05 110.71 100.00

250.14 226.60 257.27 -175.32 -58.69 100.00


115.11 104.61 93.15 96.31 90.82 100.00
187.38 248.21 64.41 0.00 0.00 100.00
0.00 0.00 0.00 103.45 396.55 100.00

110.02 119.33 95.96 94.36 80.33 100.00


104.78 104.90 101.48 94.65 94.19 100.00
100.48 100.75 96.68 96.23 105.86 100.00

126.15 97.48 103.90 92.93 79.55 100.00

0.00 0.00 808.96 -308.96 0.00 100.00

125.70 97.14 106.37 91.52 79.27 100.00

108.54 82.47 123.85 100.69 84.45 100.00


664.92 1257.37 286.80 -455.84 -1253.25 100.00

105.48 76.02 122.95 103.75 91.80 100.00

133.49 105.26 99.99 86.81 74.45 100.00

-96.23 460.53 -3.27 -36.53 175.50 100.00


-87.77 420.00 -4.09 -48.23 220.09 100.00
-99.46 475.98 -2.95 -32.08 158.51 100.00

134.47 103.70 100.42 87.32 74.09 100.00


10-YEAR HIGHLIG

Particulars 2011-12 2012-13 2013-14 2014-15


A. Operating Results:
Sales 273617.00 324451.00 375738.00 421120.00
Other Operating Revenue and
Other Income 12006.00 12963.00 8425.00 6034.00
Net Profit After Tax 44647.00 49675.00 53987.00 55898.00
Total Comprehensive Income 0.00 0.00 0.00 0.00
Cash Profits 48578.00 54045.00 53987.00 63400.00

B. Financial Position:
Net Fixed Assets 32991.00 43746.00 73662.00 94366.00
Investments 4712.00 4712.00 3713.00 3713.00
Other Assets/ (Liabilities) (Net) 5836.00 501.00 -17389.00 -21047.00
TOTAL ASSETS 43539.00 48959.00 59986.00 77032.00
Share Capital 1360.00 1360.00 1360.00 1360.00
Reserves and Surplus 42179.00 47599.00 58628.00 75672.00
SHAREHOLDER'S FUND 43539.00 48959.00 59988.00 77032.00
Loan Funds 0.00 0.00 0.00 0.00
TOTAL CAPITAL EMPLOYED 43539.00 48959.00 59988.00 77032.00

C. Equity Share Data


Earning per share (Rs.) 32.83 36.53 39.70 41.10
Dividend per share (Rs.) 25.00 28.00 27.00 24.00
No. of shares (in lakhs) 1360.00 1360.00 1360.00 1360.00
No. of shareholders (in '000s) 122.00 129.00 132.00 135.00
Market price per share
z
AR HIGHLIGHTS
₹ in Lakhs
2015-16 2016-17 2017-18 2018-19 2019-20 2020-21

431898.00 448985.00 429989.00 443244.00 448757.00 481048.00

6964.00 7147.00 6600.00 6765.00 8676.00 6109.00


58117.00 57743.00 67337.00 77557.00 81647.00 103539.00
57998.00 57236.00 67445.00 77567.00 80094.00 103863.00
69139.00 70550.00 83096.00 93483.00 99888.00 122113.00

109225.00 130570.00 133274.00 140065.00 120664.00 121224.00


3116.00 3116.00 3116.00 3115.00 1862.00 1861.00
-9237.00 -6306.00 16071.00 1495.00 25316.00 -6499.00
103104.00 127380.00 152461.00 144675.00 147842.00 116586.00
2720.00 2720.00 2720.00 2720.00 2720.00 2720.00
100384.00 124660.00 149741.00 141955.00 156696.00 113866.00
103104.00 127380.00 152461.00 144675.00 159416.00 116586.00
0.00 0.00 0.00 0.00 0.00 0.00
103104.00 127380.00 152461.00 144675.00 159416.00 116586.00

21.37 21.23 24.76 28.52 30.02 38.07


10.00 10.00 24.00 23.00 28.00 38.00
2720.00 2720.00 2720.00 2720.00 2720.00 2720.00
181.00 176.00 169.00 176.00 214.00 229.00
762.39 923.62 995.75 1198.54 1223.83 1449.00
Liquitity Ratio
1
2
3

Solvency Ratio / Fianancial Leverag


1
2
3

Turnover/ Asset Mgmt Ratio


1

2
3
4
5
6
7

Profitabiliy ratio
1
2

3
4
5

Market Ratios
1

2
3
Name Formulas 2021 2020
Current Ratio Current assets / current liablity 0.85 1.16
Quick ratio / Acid test CA - Inv / CL 0.64 0.82
Cash Ratio cash + MS / CL 0.54 0.48

Name Formulas 2021 2020


Debt to equity total debt / total equity 1.48 0.63
Debt to Total assets total debt / total assets 0.60 0.39
Interest coverage / Income statement ratio EBIT / Interest Payments 212.15 130.09

Name Formulas 2021 2020


net sales / Avg. Account
Receivalble Turnover receivable 41.35 34.14

Avg collection period days in year / receivable turnover 8.83 10.69


Cash Turnover Sales /Cash & Cash equivalants 5.58 10.74
Inventory turnover Sales / Inventory 14.42 15.24
Total asset turnover Net sales / Avg .Total assets 1.67 1.74
Net working capital Current assets - Current liablities -24536.72 14172.78
Fixed asset turnover Net sales / Avg. Fixed Assets 4.00 3.45

Name Formulas 2021 2020


Gross Profit Margin Gross profit / net sales 68.00% 65.24%
Net Profit Margin Net income / total revenue 21.39% 18.04%
Income from operations /
Operating Profit Margin Revenue 31.81% 27.64%
Return on Assets (ROA) Net income / Total Assets 0.36 0.31
Return on Equity (ROE) Net income / Total Equity 0.89 0.51

Formulas 2021 2020


Price-to-Earnings ratio Market price per share/EPS 38.06 40.77
Cash divident per share/ Market
dividend yield price per share 0.026 0.023
dividend payout ratio Cash divident per share/ EPS 0.998 0.933
2019 2018 2017
0.96 1.08 0.86
0.72 0.85 0.57
0.38 0.46 0.30

2019 2018 2017


0.82 0.68 0.82
0.45 0.41 0.45
510.45 0.00 0.00

2019 2018 2017


21.27 21.53 34.80

17.16 16.95 10.49


11.17 9.49 15.36
17.95 19.09 15.45
1.70 1.69 1.95
-4094.61 7793.02 -13966.51
3.21 3.32 3.55

2019 2018 2017


65.07% 65.57% 67.34%
17.38% 15.56% 12.77%

28.54% 26.60% 21.78%


0.30 0.26 0.25
0.54 0.44 0.45

2019 2018 2017


42.02 40.22 43.51

0.019 0.024 0.011


0.806 0.969 0.471

You might also like