Summary

CONTAINER CORPORATION OF INDIA LTD

Total number of shares (cr) 60.93
Current price ₹735.85
Market Cap (cr) ₹44,835

Page 1
 Graham Check list

Input Data
Fixed Assets
Current Assets
Fixed Liabilities
Current Liabilities

1. Size of the company

2. Strong financial stability

3. Earnings Stability

4. Dividend record

5. Earnings Growth

Financial Ratios
PE ratio should be at least less than 14
PB ratio should be less than 2
Debt to Equity ratio should be less than 1
RoE should be atleast 15%
RoA should be atleast 15%

Page 2
 Graham Check list

Input Data Result

15 Yes 64%
153 No 36%
0
15

Sales at least more than 200 crores.

YES
Latest Annual Sales 8,653
1. Current assets must be at least twice current liabilities

2. Long term or Fixed liabilities must be less than net current assets (Current assets – current
liabilities)
Criteria 1 YES
Criteria 2 YES

Should have positive earnings for past 10 years at least YES

Should have paid dividend for last 10 years uninterrupted YES

Average earnings should have increased by at least 100% in 10 years

Current Earnings 19.10
Earnings before 10 years 15.74 NO
Check Value 21.30%

Financial Ratios
ss than 14 50.95 No
2 293.38 No
e less than 1 0.08 Yes
575.80% Yes
6.27% No

Page 3
 EPV method

Avg. Profit 5 years 880

Other income % 15%
EPV at 7% returns 12319
+ Invesments 1,107.06
+ Cash equivalents 3,296
Total 16722
Borrowings 939
Other Liabilities 1,276
IV1 (- all liabilities) IV2 (- Debt alone) 0
238 259
MoS -209% -184%

Page 4
 EPV method

Net Profit 2020 2021 2022 2023 2024

403.52 505.26 1,056.37 1,173.95 1,260.59
Other income 2020 2021 2022 2023 2024
-559.58 223.08 269.96 333.16 400.20

Page 5
 Buffett Method

Profit Growth CAGR 0.50%

Debt 938.70
Avg. Capex 5 years -103.2
Avg. D&A 5 years 570

Net Profit Adjusted Value

2025 1,267 1,438
2026 1,273 1,343
2027 1,280 1,254
2028 1,286 1,171
2029 1,293 1,094
Terminal value 18,096 12,589
Total 18,889
IV3 310
MoS -137%

Page 6
 Buffett Method

Net Profit 2019 2020 2021 2022 2023 2024

1,229.37 403.52 505.26 1,056.37 1,173.95 1,260.59
Capex 2019 2020 2021 2022 2023 2024
-88 -224 -77 -91 -50 -74
Depreciation 2019 2020 2021 2022 2023 2024
452.26 544.41 553.38 561.42 573.01 618.61

Page 7
CONTAINER CORPORATION OF INDIA LTD SCREENER.IN

Narration Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24 Trailing Best Case Worst Case
Sales 6,031.70 6,278.20 5,979.73 6,612.49 6,956.06 6,530.27 6,427.08 7,652.73 8,169.12 8,653.41 8,926.58 9,555.32 9,018.67
Expenses 4,636.74 4,935.73 4,731.64 5,120.09 5,163.94 4,836.05 5,379.69 5,902.71 6,301.32 6,694.73 6,887.27 7,372.37 7,014.58
Operating Profit 1,394.96 1,342.47 1,248.09 1,492.40 1,792.12 1,694.22 1,047.39 1,750.02 1,867.80 1,958.68 2,039.31 2,182.95 2,004.09
Other Income 354.23 347.35 308.56 342.56 363.73 -559.58 223.08 269.96 333.16 400.20 373.69 - -
Depreciation 410.89 354.90 367.07 419.97 452.26 544.41 553.38 561.42 573.01 618.61 659.14 659.14 659.14
Interest 18.49 0.33 6.01 6.29 6.85 46.44 43.41 62.84 64.68 71.73 76.22 76.22 76.22
Profit before tax 1,319.81 1,334.59 1,183.57 1,408.70 1,696.74 543.79 673.68 1,395.72 1,563.27 1,668.54 1,677.64 1,447.59 1,268.73
Tax 263.97 367.99 329.44 348.59 474.40 138.09 172.98 342.20 389.72 406.45 419.09 25% 25%
Net profit 1,054.44 965.90 857.46 1,068.94 1,229.37 403.52 505.26 1,056.37 1,173.95 1,260.59 1,271.24 1,085.97 951.79
EPS 17.31 15.85 14.07 17.55 20.18 6.62 8.29 17.34 19.27 20.69 20.86 17.82 15.62
Price to earning 29.29 25.10 28.96 28.38 26.03 50.08 72.11 38.77 30.12 42.64 35.27 36.70 35.27
Price 506.85 397.87 407.58 498.04 525.30 331.65 598.00 672.15 580.25 882.10 735.85 654.07 550.94

RATIOS:
Dividend Payout 24.78% 27.25% 38.88% 38.99% 42.38% 54.36% 60.30% 51.91% 57.09% 55.59%
OPM 23.13% 21.38% 20.87% 22.57% 25.76% 25.94% 16.30% 22.87% 22.86% 22.63% 22.85%

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

Sales Growth 4.09% 5.42% 4.46% 10.42% 5.93% 10.42% 4.09%
OPM 22.50% 22.75% 22.22% 22.78% 22.85% 22.85% 22.22%
Price to Earning 36.98 40.42 44.83 36.70 35.27 36.70 35.27
CONTAINER CORPORATION OF INDIA LTD SCREENER.IN

Narration Jun-22 Sep-22 Dec-22 Mar-23 Jun-23 Sep-23 Dec-23 Mar-24 Jun-24 Sep-24
Sales 1,993.99 1,986.34 2,004.46 2,184.33 1,922.84 2,194.87 2,210.57 2,325.13 2,103.13 2,287.75
Expenses 1,515.24 1,480.78 1,572.10 1,733.25 1,527.02 1,648.41 1,693.11 1,826.93 1,661.50 1,705.73
Operating Profit 478.75 505.56 432.36 451.08 395.82 546.46 517.46 498.20 441.63 582.02
Other Income 68.51 44.60 104.32 93.77 81.14 104.91 91.55 92.74 93.85 95.55
Depreciation 137.29 138.55 139.63 157.54 142.10 153.10 158.90 164.51 169.42 166.31
Interest 15.49 15.94 15.76 16.70 15.91 16.51 18.73 20.03 18.95 18.51
Profit before tax 394.48 395.67 381.29 370.61 318.95 481.76 431.38 406.40 347.11 492.75
Tax 100.45 99.81 92.99 96.47 76.76 118.97 105.57 105.15 86.87 121.50
Net profit 297.08 303.47 294.20 279.12 245.56 367.36 330.74 316.93 258.17 365.40

OPM 24% 25% 22% 21% 21% 25% 23% 21% 21% 25%
CONTAINER CORPORATION OF INDIA LTD SCREENER.IN

Narration Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24
Equity Share Capital 194.97 194.97 194.97 243.72 304.65 304.65 304.65 304.65 304.65 304.65
Reserves 7,321.82 8,112.36 8,576.18 9,078.05 10,022.76 9,741.45 9,882.61 10,449.27 10,921.64 11,518.56
Borrowings 189.53 10.06 62.00 62.00 770.65 70.00 722.93 735.28 778.14 938.70
Other Liabilities 1,288.73 1,261.92 1,292.64 1,533.93 1,699.56 1,672.66 1,500.26 1,512.56 1,460.89 1,276.25
Total 8,995.05 9,579.31 10,125.79 10,917.70 12,797.62 11,788.76 12,410.45 13,001.76 13,465.32 14,038.16

Net Block 3,675.06 3,007.78 3,657.91 4,019.24 4,564.06 5,347.81 5,662.68 5,722.71 5,620.69 6,014.76
Capital Work in Progress 394.57 622.94 616.62 691.82 626.34 943.07 922.56 755.44 836.74 892.65
Investments 488.20 1,100.62 1,079.94 1,126.28 1,168.80 1,198.92 1,261.32 1,206.54 1,213.52 1,107.06
Other Assets 4,437.22 4,847.97 4,771.32 5,080.36 6,438.42 4,298.96 4,563.89 5,317.07 5,794.37 6,023.69
Total 8,995.05 9,579.31 10,125.79 10,917.70 12,797.62 11,788.76 12,410.45 13,001.76 13,465.32 14,038.16

Working Capital 3,148.49 3,586.05 3,478.68 3,546.43 4,738.86 2,626.30 3,063.63 3,804.51 4,333.48 4,747.44
Debtors 69.05 59.51 63.17 90.94 95.48 164.63 161.03 181.72 216.00 333.63
Inventory 51.17 18.56 23.52 27.95 23.76 26.38 24.09 31.49 37.30 50.34

Debtor Days 4.18 3.46 3.86 5.02 5.01 9.20 9.15 8.67 9.65 14.07
Inventory Turnover 117.88 338.27 254.24 236.58 292.76 247.55 266.79 243.02 219.01 171.90

Return on Equity 14% 12% 10% 11% 12% 4% 5% 10% 10% 11%
Return on Capital Emp 17% 14% 16% 17% 6% 7% 13% 14% 14%
CONTAINER CORPORATION OF INDIA LTD SCREENER.IN

Narration Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24
Cash from Operating Activity 1,166.32 -781.42 2,029.39 1,313.29 -1,941.38 4,285.77 1,029.06 1,369.96 1,405.86 1,388.50
Cash from Investing Activity -648.37 -752.72 -881.97 -745.20 1,381.47 -2,875.04 33.71 -1,068.45 -593.47 -698.67
Cash from Financing Activity -348.61 -298.50 -292.50 -492.43 480.65 -1,470.15 -456.62 -594.98 -853.59 -840.10
Net Cash Flow 169.34 -1,832.64 854.92 75.66 -79.26 -59.42 606.15 -293.47 -41.20 -150.27
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: screener.feedback@dalal-street.in
 s… do ANYTHING.

@dalal-street.in
COMPANY NAME CONTAINER CORPORATION OF INDIA LTD
LATEST VERSION 2.10 PLEAS
CURRENT VERSION 2.10

META
Number of shares 60.93
Face Value 5.00
Current Price 735.85
Market Capitalization 44,835.01

PROFIT & LOSS

Report Date Mar-15 Mar-16 Mar-17 Mar-18
Sales 6,031.70 6,278.20 5,979.73 6,612.49
Raw Material Cost 49.34 1.02
Change in Inventory 30.03 -30.83 -0.18
Power and Fuel 24.73 15.90 16.56 17.81
Other Mfr. Exp 4,234.16 4,578.55 4,183.67 4,468.85
Employee Cost 197.85 158.79 189.15 279.74
Selling and admin 241.26 197.52 366.48 402.10
Other Expenses -80.57 -46.88 -24.22 -48.59
Other Income 354.23 347.35 308.56 342.56
Depreciation 410.89 354.90 367.07 419.97
Interest 18.49 0.33 6.01 6.29
Profit before tax 1,319.81 1,334.59 1,183.57 1,408.70
Tax 263.97 367.99 329.44 348.59
Net profit 1,054.44 965.90 857.46 1,068.94
Dividend Amount 261.26 263.21 333.40 416.76

Quarters
Report Date Jun-22 Sep-22 Dec-22 Mar-23
Sales 1,993.99 1,986.34 2,004.46 2,184.33
Expenses 1,515.24 1,480.78 1,572.10 1,733.25
Other Income 68.51 44.60 104.32 93.77
Depreciation 137.29 138.55 139.63 157.54
Interest 15.49 15.94 15.76 16.70
Profit before tax 394.48 395.67 381.29 370.61
Tax 100.45 99.81 92.99 96.47
Net profit 297.08 303.47 294.20 279.12
Operating Profit 478.75 505.56 432.36 451.08

BALANCE SHEET
Report Date Mar-15 Mar-16 Mar-17 Mar-18
Equity Share Capital 194.97 194.97 194.97 243.72
Reserves 7,321.82 8,112.36 8,576.18 9,078.05
Borrowings 189.53 10.06 62.00 62.00
Other Liabilities 1,288.73 1,261.92 1,292.64 1,533.93
Total 8,995.05 9,579.31 10,125.79 10,917.70
Net Block 3,675.06 3,007.78 3,657.91 4,019.24
Capital Work in Progress 394.57 622.94 616.62 691.82
Investments 488.20 1,100.62 1,079.94 1,126.28
Other Assets 4,437.22 4,847.97 4,771.32 5,080.36
Total 8,995.05 9,579.31 10,125.79 10,917.70
Receivables 69.05 59.51 63.17 90.94
Inventory 51.17 18.56 23.52 27.95
Cash & Bank 2,949.32 891.32 1,746.24 2,017.88
No. of Equity Shares ### ### ### ###
New Bonus Shares 48,743,548.00
Face value 10.00 10.00 10.00 10.00

CASH FLOW:
Report Date Mar-15 Mar-16 Mar-17 Mar-18
Cash from Operating Activity 1,166.32 -781.42 2,029.39 1,313.29
Cash from Investing Activity -648.37 -752.72 -881.97 -745.20
Cash from Financing Activity -348.61 -298.50 -292.50 -492.43
Net Cash Flow 169.34 -1,832.64 854.92 75.66

PRICE: 506.85 397.87 407.58 498.04

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

Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24

6,956.06 6,530.27 6,427.08 7,652.73 8,169.12 8,653.41

-0.03 -0.21 -0.15 -0.03 -1.26

12.44 12.62 12.58 12.76 14.71 14.68
4,441.33 4,295.15 4,097.35 4,863.20 5,299.18 5,687.24
341.07 317.33 428.86 417.77 431.11 463.49
434.87 271.73 882.60 694.96 655.24 646.84
-65.80 -60.99 -41.85 -86.01 -98.92 -118.78
363.73 -559.58 223.08 269.96 333.16 400.20
452.26 544.41 553.38 561.42 573.01 618.61
6.85 46.44 43.41 62.84 64.68 71.73
1,696.74 543.79 673.68 1,395.72 1,563.27 1,668.54
474.40 138.09 172.98 342.20 389.72 406.45
1,229.37 403.52 505.26 1,056.37 1,173.95 1,260.59
520.95 219.35 304.65 548.37 670.23 700.70

Jun-23 Sep-23 Dec-23 Mar-24 Jun-24 Sep-24

1,922.84 2,194.87 2,210.57 2,325.13 2,103.13 2,287.75
1,527.02 1,648.41 1,693.11 1,826.93 1,661.50 1,705.73
81.14 104.91 91.55 92.74 93.85 95.55
142.10 153.10 158.90 164.51 169.42 166.31
15.91 16.51 18.73 20.03 18.95 18.51
318.95 481.76 431.38 406.40 347.11 492.75
 76.76 118.97 105.57 105.15 86.87 121.50
245.56 367.36 330.74 316.93 258.17 365.40
395.82 546.46 517.46 498.20 441.63 582.02

Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24

304.65 304.65 304.65 304.65 304.65 304.65
10,022.76 9,741.45 9,882.61 10,449.27 10,921.64 11,518.56
770.65 70.00 722.93 735.28 778.14 938.70
1,699.56 1,672.66 1,500.26 1,512.56 1,460.89 1,276.25
12,797.62 11,788.76 12,410.45 13,001.76 13,465.32 14,038.16
4,564.06 5,347.81 5,662.68 5,722.71 5,620.69 6,014.76
626.34 943.07 922.56 755.44 836.74 892.65
1,168.80 1,198.92 1,261.32 1,206.54 1,213.52 1,107.06
6,438.42 4,298.96 4,563.89 5,317.07 5,794.37 6,023.69
12,797.62 11,788.76 12,410.45 13,001.76 13,465.32 14,038.16
95.48 164.63 161.03 181.72 216.00 333.63
23.76 26.38 24.09 31.49 37.30 50.34
205.74 2,191.62 2,492.80 2,918.38 3,102.12 3,296.09
### ### ### ### ### ###
###
5.00 5.00 5.00 5.00 5.00 5.00

Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24

-1,941.38 4,285.77 1,029.06 1,369.96 1,405.86 1,388.50
1,381.47 -2,875.04 33.71 -1,068.45 -593.47 -698.67
480.65 -1,470.15 -456.62 -594.98 -853.59 -840.10
-79.26 -59.42 606.15 -293.47 -41.20 -150.27

525.30 331.65 598.00 672.15 580.25 882.10

60.93 60.93 60.93 60.93 60.93 60.93