Scribd
Upload
103 views10 pages

Castrol India Ltd Financial Overview

The document provides financial information for Castrol India Ltd. over multiple years. It includes metrics such as sales, expenses, operating profit, net profit, assets and liabilities. Sales increased from 2010 to 2019 while expenses also grew. Profits fluctuated over the years but showed an overall increase from 2010 to 2019. Assets exceeded liabilities for all periods reported. Key financial ratios like return on equity and return on capital employed were mostly stable from 2010 to 2019.

Uploaded by

jaackson10
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
103 views10 pages

Castrol India Ltd Financial Overview

The document provides financial information for Castrol India Ltd. over multiple years. It includes metrics such as sales, expenses, operating profit, net profit, assets and liabilities. Sales increased from 2010 to 2019 while expenses also grew. Profits fluctuated over the years but showed an overall increase from 2010 to 2019. Assets exceeded liabilities for all periods reported. Key financial ratios like return on equity and return on capital employed were mostly stable from 2010 to 2019.

Uploaded by

jaackson10
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

CASTROL INDIA LTD SCREENER.

IN

Narration Dec-10 Dec-11 Dec-12 Dec-13 Dec-14 Dec-15 Dec-16 Dec-17 Dec-18 Dec-19 Trailing Best Case Worst Case
Sales 2,734.76 2,993.27 3,120.86 3,179.62 3,392.33 3,298.03 3,370.33 3,584.32 3,904.55 3,876.82 3,588.60 4,062.03 3,851.33
Expenses 2,007.37 2,313.68 2,496.15 2,492.14 2,674.66 2,397.29 2,370.98 2,551.20 2,833.78 2,723.12 2,545.60 2,881.43 2,861.93
Operating Profit 727.39 679.59 624.71 687.48 717.67 900.74 999.35 1,033.12 1,070.77 1,153.70 1,043.00 1,180.60 989.40
Other Income 37.04 63.15 70.39 106.44 47.15 90.01 87.39 83.65 84.31 64.14 63.50 - -
Depreciation 24.33 25.11 26.64 30.45 36.13 38.97 44.96 45.50 55.57 69.74 75.70 75.70 75.70
Interest 2.42 1.68 2.14 1.71 2.38 0.83 1.48 1.20 1.09 1.19 2.00 2.00 2.00
Profit before tax 737.68 715.95 666.32 761.76 726.31 950.95 1,040.30 1,070.07 1,098.42 1,146.91 1,028.80 1,102.90 911.70
Tax 247.37 234.92 218.93 253.19 251.75 335.69 369.92 378.26 390.06 319.54 261.20 25% 25%
Net profit 490.31 481.03 447.39 508.57 474.56 615.26 670.38 691.81 708.36 827.37 767.60 822.89 680.23
EPS 4.96 4.86 4.52 5.14 4.80 6.22 6.78 6.99 7.16 8.36 7.76 8.32 6.88
Price to earning 23.15 21.32 32.95 30.12 52.31 35.48 28.08 27.62 21.12 15.46 16.53 20.18 16.53
Price 114.75 103.69 149.05 154.88 251.00 220.68 190.33 193.20 151.25 129.30 128.30 167.91 113.70

RATIOS:
Dividend Payout 75.65% 77.11% 116.07% 68.07% 78.16% 72.34% 81.15% 100.08% 69.82% 65.75%
OPM 26.60% 22.70% 20.02% 21.62% 21.16% 27.31% 29.65% 28.82% 27.42% 29.76% 29.06%

TRENDS: 10 YEARS 7 YEARS 5 YEARS 3 YEARS RECENT BEST WORST


Sales Growth 3.95% 3.15% 2.71% 4.78% -0.71% 4.78% -0.71%
OPM 25.69% 26.67% 28.60% 28.66% 29.06% 29.06% 25.69%
Price to Earning 27.65 28.34 24.05 20.18 16.53 20.18 16.53
CASTROL INDIA LTD SCREENER.IN

Narration Dec-17 Mar-18 Jun-18 Sep-18 Dec-18 Mar-19 Jun-19 Sep-19 Dec-19 Mar-20
Sales 970.30 927.10 1,017.20 926.90 1,033.40 976.20 1,039.60 849.20 1,011.80 688.00
Expenses 663.70 652.80 765.50 699.50 716.00 693.20 755.30 604.70 670.60 515.00
Operating Profit 306.60 274.30 251.70 227.40 317.40 283.00 284.30 244.50 341.20 173.00
Other Income 16.40 22.80 17.30 18.60 25.60 21.10 15.90 11.60 16.20 19.80
Depreciation 10.30 14.30 13.20 13.50 14.60 16.20 16.60 18.60 18.30 22.20
Interest 0.60 0.70 0.30 -0.20 0.30 0.30 0.30 0.30 0.30 1.10
Profit before tax 312.10 282.10 255.50 232.70 328.10 287.60 283.30 237.20 338.80 169.50
Tax 115.40 100.30 91.30 82.30 116.20 102.60 100.60 48.80 67.50 44.30
Net profit 196.70 181.80 164.20 150.40 211.90 185.00 182.70 188.40 271.30 125.20

OPM 32% 30% 25% 25% 31% 29% 27% 29% 34% 25%
CASTROL INDIA LTD SCREENER.IN

Narration Dec-10 Dec-11 Dec-12 Dec-13 Dec-14 Dec-15 Dec-16 Dec-17 Dec-18 Dec-19
Equity Share Capital 247.28 247.28 494.56 494.56 247.28 247.28 247.28 494.56 494.56 494.56
Reserves 306.22 356.92 154.67 256.86 249.50 328.33 734.26 525.59 671.10 872.39
Borrowings - - - - - - - - - -
Other Liabilities 783.28 788.62 830.34 863.59 995.37 1,086.01 906.79 956.80 941.11 861.83
Total 1,336.78 1,392.82 1,479.57 1,615.01 1,492.15 1,661.62 1,888.33 1,976.95 2,106.77 2,228.78

Net Block 120.32 112.52 126.12 143.46 172.07 148.84 146.97 138.97 186.04 199.70
Capital Work in Progress 16.57 29.30 30.96 31.87 15.67 36.41 37.26 57.27 35.04 27.33
Investments - - - - - - - - - -
Other Assets 1,199.89 1,251.00 1,322.49 1,439.68 1,304.41 1,476.37 1,704.10 1,780.71 1,885.69 2,001.75
Total 1,336.78 1,392.82 1,479.57 1,615.01 1,492.15 1,661.62 1,888.33 1,976.95 2,106.77 2,228.78

Working Capital 416.61 462.38 492.15 576.09 309.04 390.36 797.31 823.91 944.58 1,139.92
Debtors 178.43 218.95 216.62 237.24 271.50 236.46 255.22 284.97 391.80 482.03
Inventory 244.20 300.92 315.76 374.01 365.47 304.58 343.88 319.57 456.79 304.72

Debtor Days 23.81 26.70 25.33 27.23 29.21 26.17 27.64 29.02 36.63 45.38
Inventory Turnover 11.20 9.95 9.88 8.50 9.28 10.83 9.80 11.22 8.55 12.72

Return on Equity 89% 80% 69% 68% 96% 107% 68% 68% 61% 61%
Return on Capital Emp 124% 107% 109% 117% 178% 134% 107% 101% 91%
CASTROL INDIA LTD SCREENER.IN

Narration Dec-10 Dec-11 Dec-12 Dec-13 Dec-14 Dec-15 Dec-16 Dec-17 Dec-18 Dec-19
Cash from Operating Activity 509.90 352.38 467.16 396.45 547.60 740.01 664.11 608.30 549.48 879.49
Cash from Investing Activity -10.83 11.05 0.78 29.86 -13.74 2.26 -32.97 151.37 66.12 -448.26
Cash from Financing Activity -420.51 -432.77 -433.18 -406.68 -696.63 -477.83 -568.03 -655.78 -567.42 -627.72
Net Cash Flow 78.56 -69.34 34.76 19.63 -162.77 264.44 63.11 103.89 48.18 -196.49
How to use it?
You can customize this workbook as you want.
You can add custom formating, add conditional formating, add your own formulas… do ANYTHING.
Please don't edit the "Data Sheet" only.

After customization, you can upload this back on Screener.


Upload on: https://www.screener.in/excel/

Download your customized workbooks now onwards.


Now whenever you will "Export to excel" from Screener, it will export your customized file.

TESTING:
This is a testing feature currently.
You can report any formula errors on the worksheet at: [email protected]
s… do ANYTHING.

@dalal-street.in
COMPANY NAME CASTROL INDIA LTD
LATEST VERSION 2.10 PLEAS
CURRENT VERSION 2.10

META
Number of shares 98.91
Face Value 5.00
Current Price 128.30
Market Capitalization 12,690.44

PROFIT & LOSS


Report Date Dec-10 Dec-11 Dec-12 Dec-13
Sales 2,734.76 2,993.27 3,120.86 3,179.62
Raw Material Cost 1,408.27 1,721.30 1,836.27 1,819.89
Change in Inventory 23.60 26.81 12.00 31.42
Power and Fuel 3.64 3.83 4.20 5.51
Other Mfr. Exp 126.12 126.01 136.76 142.84
Employee Cost 103.78 116.19 128.69 146.27
Selling and admin 440.11 359.58 376.70 383.02
Other Expenses -50.95 13.58 25.53 26.03
Other Income 37.04 63.15 70.39 106.44
Depreciation 24.33 25.11 26.64 30.45
Interest 2.42 1.68 2.14 1.71
Profit before tax 737.68 715.95 666.32 761.76
Tax 247.37 234.92 218.93 253.19
Net profit 490.31 481.03 447.39 508.57
Dividend Amount 370.92 370.92 519.29 346.19

Quarters
Report Date Dec-17 Mar-18 Jun-18 Sep-18
Sales 970.30 927.10 1,017.20 926.90
Expenses 663.70 652.80 765.50 699.50
Other Income 16.40 22.80 17.30 18.60
Depreciation 10.30 14.30 13.20 13.50
Interest 0.60 0.70 0.30 -0.20
Profit before tax 312.10 282.10 255.50 232.70
Tax 115.40 100.30 91.30 82.30
Net profit 196.70 181.80 164.20 150.40
Operating Profit 306.60 274.30 251.70 227.40

BALANCE SHEET
Report Date Dec-10 Dec-11 Dec-12 Dec-13
Equity Share Capital 247.28 247.28 494.56 494.56
Reserves 306.22 356.92 154.67 256.86
Borrowings
Other Liabilities 783.28 788.62 830.34 863.59
Total 1,336.78 1,392.82 1,479.57 1,615.01
Net Block 120.32 112.52 126.12 143.46
Capital Work in Progress 16.57 29.30 30.96 31.87
Investments
Other Assets 1,199.89 1,251.00 1,322.49 1,439.68
Total 1,336.78 1,392.82 1,479.57 1,615.01
Receivables 178.43 218.95 216.62 237.24
Inventory 244.20 300.92 315.76 374.01
Cash & Bank 619.26 549.00 574.59 594.22
No. of Equity Shares ### ### ### ###
New Bonus Shares ###
Face value 10.00 10.00 10.00 10.00

CASH FLOW:
Report Date Dec-10 Dec-11 Dec-12 Dec-13
Cash from Operating Activity 509.90 352.38 467.16 396.45
Cash from Investing Activity -10.83 11.05 0.78 29.86
Cash from Financing Activity -420.51 -432.77 -433.18 -406.68
Net Cash Flow 78.56 -69.34 34.76 19.63

PRICE: 114.75 103.69 149.05 154.88

DERIVED:
Adjusted Equity Shares in Cr 98.92 98.92 98.91 98.91
PLEASE DO NOT MAKE ANY CHANGES TO THIS SHEET

Dec-14 Dec-15 Dec-16 Dec-17 Dec-18 Dec-19


3,392.33 3,298.03 3,370.33 3,584.32 3,904.55 3,876.82
1,920.69 1,585.98 1,546.57 1,671.33 1,971.11 1,671.92
-16.81 -14.81 14.98 5.43 64.55 -75.73
5.29 4.84 4.60 5.26 5.96 6.39
163.18 163.71 175.26 186.81 217.88 221.81
161.89 177.08 178.42 196.35 204.23 214.03
383.48 419.09 440.26 437.82 455.47 482.82
23.32 31.78 40.85 59.06 43.68 50.42
47.15 90.01 87.39 83.65 84.31 64.14
36.13 38.97 44.96 45.50 55.57 69.74
2.38 0.83 1.48 1.20 1.09 1.19
726.31 950.95 1,040.30 1,070.07 1,098.42 1,146.91
251.75 335.69 369.92 378.26 390.06 319.54
474.56 615.26 670.38 691.81 708.36 827.37
370.92 445.10 544.02 692.38 494.56 544.02

Dec-18 Mar-19 Jun-19 Sep-19 Dec-19 Mar-20


1,033.40 976.20 1,039.60 849.20 1,011.80 688.00
716.00 693.20 755.30 604.70 670.60 515.00
25.60 21.10 15.90 11.60 16.20 19.80
14.60 16.20 16.60 18.60 18.30 22.20
0.30 0.30 0.30 0.30 0.30 1.10
328.10 287.60 283.30 237.20 338.80 169.50
116.20 102.60 100.60 48.80 67.50 44.30
211.90 185.00 182.70 188.40 271.30 125.20
317.40 283.00 284.30 244.50 341.20 173.00

Dec-14 Dec-15 Dec-16 Dec-17 Dec-18 Dec-19


247.28 247.28 247.28 494.56 494.56 494.56
249.50 328.33 734.26 525.59 671.10 872.39

995.37 1,086.01 906.79 956.80 941.11 861.83


1,492.15 1,661.62 1,888.33 1,976.95 2,106.77 2,228.78
172.07 148.84 146.97 138.97 186.04 199.70
15.67 36.41 37.26 57.27 35.04 27.33

1,304.41 1,476.37 1,704.10 1,780.71 1,885.69 2,001.75


1,492.15 1,661.62 1,888.33 1,976.95 2,106.77 2,228.78
271.50 236.46 255.22 284.97 391.80 482.03
365.47 304.58 343.88 319.57 456.79 304.72
431.45 696.50 821.88 784.23 743.85 946.00
### ### ### ### ### ###

5.00 5.00 5.00 5.00 5.00 5.00

Dec-14 Dec-15 Dec-16 Dec-17 Dec-18 Dec-19


547.60 740.01 664.11 608.30 549.48 879.49
-13.74 2.26 -32.97 151.37 66.12 -448.26
-696.63 -477.83 -568.03 -655.78 -567.42 -627.72
-162.77 264.44 63.11 103.89 48.18 -196.49

251.00 220.68 190.33 193.20 151.25 129.30

98.91 98.91 98.91 98.91 98.91 98.91

You might also like