CHAMBAL FERTILISERS & CHEMICALS 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 9,732.71 9,007.95 7,553.45 7,541.02 10,094.52 12,205.95 12,719.01 16,068.83 27,772.81 17,966.41 17,310.36 20,158.77 17,334.32
Expenses 8,996.10 8,354.17 6,794.57 6,730.43 8,894.49 10,280.64 10,249.34 13,803.69 25,950.66 15,919.40 15,148.36 17,641.01 15,613.93
Operating Profit 736.61 653.78 758.88 810.59 1,200.03 1,925.31 2,469.67 2,265.14 1,822.15 2,047.01 2,162.00 2,517.76 1,720.39
Other Income 103.02 32.22 133.11 171.70 -2.05 192.41 469.96 374.38 222.49 325.82 401.35 - -
Depreciation 216.49 111.25 92.20 85.39 118.76 286.86 289.22 299.74 308.29 312.79 317.87 317.87 317.87
Interest 163.91 266.94 255.31 156.56 246.95 503.86 290.88 108.88 320.02 173.06 158.44 158.44 158.44
Profit before tax 459.23 307.81 544.48 740.34 832.27 1,327.00 2,359.53 2,230.90 1,416.33 1,886.98 2,087.04 2,041.45 1,244.08
Tax 179.72 160.46 185.52 244.93 247.42 101.44 611.94 664.84 382.54 611.23 701.57 34% 34%
Net profit 294.61 220.96 362.14 498.84 590.21 1,226.19 1,654.76 1,565.98 1,034.22 1,275.80 1,385.52 1,355.20 825.88
EPS 7.08 5.31 8.70 11.99 14.18 29.46 39.76 37.63 24.85 31.84 34.58 33.82 20.61
Price to earning 9.54 10.34 9.97 13.74 11.78 3.68 5.76 11.22 10.63 10.74 14.50 14.50 9.42
Price 67.55 54.90 86.75 164.65 167.05 108.45 229.05 422.10 264.10 342.00 501.30 490.33 194.20

RATIOS:
Dividend Payout 26.70% 35.79% 21.84% 15.85% 14.10% 13.58% 18.86% 19.93% 30.18% 23.55%
OPM 7.57% 7.26% 10.05% 10.75% 11.89% 15.77% 19.42% 14.10% 6.56% 11.39% 12.49%

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

Sales Growth 7.05% 13.18% 12.22% 12.20% -3.65% 12.20% -3.65%
OPM 11.24% 12.02% 12.14% 9.92% 12.49% 12.49% 9.92%
Price to Earning 10.17 10.26 9.42 11.77 14.50 14.50 9.42
CHAMBAL FERTILISERS & CHEMICALS LTD SCREENER.IN

Narration Mar-22 Jun-22 Sep-22 Dec-22 Mar-23 Jun-23 Sep-23 Dec-23 Mar-24 Jun-24
Sales 3,307.37 7,291.18 8,586.75 8,296.21 3,598.67 5,589.28 5,385.52 4,348.57 2,643.04 4,933.23
Expenses 2,945.94 6,697.80 8,142.25 7,626.37 3,490.78 4,955.97 4,770.51 3,720.10 2,476.54 4,181.21
Operating Profit 361.43 593.38 444.50 669.84 107.89 633.31 615.01 628.47 166.50 752.02
Other Income 73.64 41.99 122.87 22.86 41.31 14.47 90.35 151.30 73.42 86.28
Depreciation 75.05 76.06 78.22 78.09 75.92 77.16 78.44 79.11 78.08 82.24
Interest 26.55 48.11 84.95 120.07 66.89 54.83 45.77 36.47 35.99 40.21
Profit before tax 333.47 511.20 404.20 494.54 6.39 515.79 581.15 664.19 125.85 715.85
Tax 89.67 169.49 130.01 170.63 -87.59 177.19 200.19 204.79 29.06 267.53
Net profit 243.57 341.82 274.27 324.03 94.10 338.64 380.97 459.41 96.78 448.36

OPM 11% 8% 5% 8% 3% 11% 11% 14% 6% 15%

CHAMBAL FERTILISERS & CHEMICALS 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 413.95 416.21 416.21 416.21 416.21 416.21 416.21 416.21 416.21 400.65
Reserves 1,837.15 1,450.69 1,707.33 2,089.34 2,467.03 3,123.09 4,832.58 5,983.37 6,651.90 6,872.90
Borrowings 4,089.35 5,317.13 4,618.59 6,079.35 9,045.22 10,112.94 3,936.16 4,336.86 3,358.40 1,873.93
Other Liabilities 1,297.83 939.25 1,314.66 877.05 1,996.66 880.43 1,061.74 2,552.56 2,343.56 2,361.49
Total 7,638.28 8,123.28 8,056.79 9,461.95 13,925.12 14,532.67 10,246.69 13,289.00 12,770.07 11,508.97

Net Block 2,948.28 1,792.92 1,162.02 1,233.88 6,905.18 6,701.03 6,479.84 6,357.67 6,262.39 6,422.64
Capital Work in Progress 119.15 638.94 1,712.20 4,134.63 121.42 84.99 160.79 156.90 102.62 183.86
Investments 30.11 211.08 173.58 207.08 300.20 217.16 298.33 559.19 2,377.09 2,431.34
Other Assets 4,540.74 5,480.34 5,008.99 3,886.36 6,598.32 7,529.49 3,307.73 6,215.24 4,027.97 2,471.13
Total 7,638.28 8,123.28 8,056.79 9,461.95 13,925.12 14,532.67 10,246.69 13,289.00 12,770.07 11,508.97

Working Capital 3,242.91 4,541.09 3,694.33 3,009.31 4,601.66 6,649.06 2,245.99 3,662.68 1,684.41 109.64
Debtors 3,171.16 3,861.20 3,036.20 2,534.69 4,827.40 5,563.11 1,174.59 2,151.30 1,760.48 191.56
Inventory 738.71 868.39 849.35 795.10 1,323.15 1,135.60 789.14 3,123.21 1,373.83 1,254.66

Debtor Days 118.93 156.45 146.72 122.68 174.55 166.36 33.71 48.87 23.14 3.89
Inventory Turnover 13.18 10.37 8.89 9.48 7.63 10.75 16.12 5.14 20.22 14.32

Return on Equity 13% 12% 17% 20% 20% 35% 32% 24% 15% 18%
Return on Capital Emp 8% 11% 12% 11% 14% 23% 23% 16% 21%
CHAMBAL FERTILISERS & CHEMICALS 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,063.78 -26.52 1,279.50 1,171.53 -1,129.87 827.09 6,943.55 -24.23 3,239.26 3,326.75
Cash from Investing Activity -149.26 -347.53 -703.31 -1,784.46 -1,131.51 -462.31 -194.92 -118.87 -1,872.36 -382.41
Cash from Financing Activity -936.98 361.99 -499.88 563.88 2,263.00 -283.19 -6,006.85 -212.79 -1,861.99 -2,871.41
Net Cash Flow -22.46 -12.05 76.31 -49.05 1.62 81.59 741.78 -355.89 -495.09 72.93
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: support@screener.in
s… do ANYTHING.
COMPANY NAME CHAMBAL FERTILISERS & CHEMICALS LTD
LATEST VERSION 2.10 PLEAS
CURRENT VERSION 2.10

META
Number of shares 40.07
Face Value 10.00
Current Price 501.30
Market Capitalization 20,084.70

PROFIT & LOSS

Report Date Mar-15 Mar-16 Mar-17 Mar-18
Sales 9,732.71 9,007.95 7,553.45 7,541.02
Raw Material Cost 5,706.04 6,109.95 4,757.16 4,585.90
Change in Inventory 52.67 298.50 -2.61 -46.57
Power and Fuel 1,381.81 1,249.52 958.80 1,098.79
Other Mfr. Exp 697.57 170.92 175.66 129.49
Employee Cost 338.03 167.12 142.11 149.60
Selling and admin 786.93 787.58 696.15 624.30
Other Expenses 138.39 167.58 62.08 95.78
Other Income 103.02 32.22 133.11 171.70
Depreciation 216.49 111.25 92.20 85.39
Interest 163.91 266.94 255.31 156.56
Profit before tax 459.23 307.81 544.48 740.34
Tax 179.72 160.46 185.52 244.93
Net profit 294.61 220.96 362.14 498.84
Dividend Amount 78.65 79.08 79.08 79.08

Quarters
Report Date Mar-22 Jun-22 Sep-22 Dec-22
Sales 3,307.37 7,291.18 8,586.75 8,296.21
Expenses 2,945.94 6,697.80 8,142.25 7,626.37
Other Income 73.64 41.99 122.87 22.86
Depreciation 75.05 76.06 78.22 78.09
Interest 26.55 48.11 84.95 120.07
Profit before tax 333.47 511.20 404.20 494.54
Tax 89.67 169.49 130.01 170.63
Net profit 243.57 341.82 274.27 324.03
Operating Profit 361.43 593.38 444.50 669.84

BALANCE SHEET
Report Date Mar-15 Mar-16 Mar-17 Mar-18
Equity Share Capital 413.95 416.21 416.21 416.21
Reserves 1,837.15 1,450.69 1,707.33 2,089.34
Borrowings 4,089.35 5,317.13 4,618.59 6,079.35
Other Liabilities 1,297.83 939.25 1,314.66 877.05
Total 7,638.28 8,123.28 8,056.79 9,461.95
Net Block 2,948.28 1,792.92 1,162.02 1,233.88
Capital Work in Progress 119.15 638.94 1,712.20 4,134.63
Investments 30.11 211.08 173.58 207.08
Other Assets 4,540.74 5,480.34 5,008.99 3,886.36
Total 7,638.28 8,123.28 8,056.79 9,461.95
Receivables 3,171.16 3,861.20 3,036.20 2,534.69
Inventory 738.71 868.39 849.35 795.10
Cash & Bank 203.93 54.27 132.14 77.65
No. of Equity Shares ### ### ### ###
New Bonus Shares
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,063.78 -26.52 1,279.50 1,171.53
Cash from Investing Activity -149.26 -347.53 -703.31 -1,784.46
Cash from Financing Activity -936.98 361.99 -499.88 563.88
Net Cash Flow -22.46 -12.05 76.31 -49.05

PRICE: 67.55 54.90 86.75 164.65

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

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

10,094.52 12,205.95 12,719.01 16,068.83 27,772.81 17,966.41
6,592.45 6,680.65 6,984.35 11,930.30 17,918.16 10,756.85
510.64 -208.66 -353.86 2,326.99 -1,786.13 -145.41
1,767.89 2,113.57 1,645.56 3,019.28 4,838.21 3,650.12
144.79 194.94 203.03 235.21 269.24 259.54
127.00 156.33 176.69 180.96 191.25 221.27
682.21 750.24 838.36 699.81 853.83 780.24
90.79 176.25 47.49 65.12 93.84 105.97
-2.05 192.41 469.96 374.38 222.49 325.82
118.76 286.86 289.22 299.74 308.29 312.79
246.95 503.86 290.88 108.88 320.02 173.06
832.27 1,327.00 2,359.53 2,230.90 1,416.33 1,886.98
247.42 101.44 611.94 664.84 382.54 611.23
590.21 1,226.19 1,654.76 1,565.98 1,034.22 1,275.80
83.24 166.48 312.16 312.16 312.16 300.49

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

3,598.67 5,589.28 5,385.52 4,348.57 2,643.04 4,933.23
3,490.78 4,955.97 4,770.51 3,720.10 2,476.54 4,181.21
41.31 14.47 90.35 151.30 73.42 86.28
75.92 77.16 78.44 79.11 78.08 82.24
66.89 54.83 45.77 36.47 35.99 40.21
6.39 515.79 581.15 664.19 125.85 715.85
-87.59 177.19 200.19 204.79 29.06 267.53
 94.10 338.64 380.97 459.41 96.78 448.36
107.89 633.31 615.01 628.47 166.50 752.02

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

416.21 416.21 416.21 416.21 416.21 400.65
2,467.03 3,123.09 4,832.58 5,983.37 6,651.90 6,872.90
9,045.22 10,112.94 3,936.16 4,336.86 3,358.40 1,873.93
1,996.66 880.43 1,061.74 2,552.56 2,343.56 2,361.49
13,925.12 14,532.67 10,246.69 13,289.00 12,770.07 11,508.97
6,905.18 6,701.03 6,479.84 6,357.67 6,262.39 6,422.64
121.42 84.99 160.79 156.90 102.62 183.86
300.20 217.16 298.33 559.19 2,377.09 2,431.34
6,598.32 7,529.49 3,307.73 6,215.24 4,027.97 2,471.13
13,925.12 14,532.67 10,246.69 13,289.00 12,770.07 11,508.97
4,827.40 5,563.11 1,174.59 2,151.30 1,760.48 191.56
1,323.15 1,135.60 789.14 3,123.21 1,373.83 1,254.66
81.09 167.53 907.40 554.14 57.63 132.89
### ### ### ### ### ###

10.00 10.00 10.00 10.00 10.00 10.00

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

-1,129.87 827.09 6,943.55 -24.23 3,239.26 3,326.75
-1,131.51 -462.31 -194.92 -118.87 -1,872.36 -382.41
2,263.00 -283.19 -6,006.85 -212.79 -1,861.99 -2,871.41
1.62 81.59 741.78 -355.89 -495.09 72.93

167.05 108.45 229.05 422.10 264.10 342.00

41.62 41.62 41.62 41.62 41.62 40.07