DELTON CABLES LTD SCREENER.

IN

Narration Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24 Mar-25 Trailing Best Case Worst Case
Sales 93.44 106.49 73.01 71.15 125.74 123.16 159.11 272.14 400.86 709.26 722.12 1,254.93 891.66
Expenses 90.96 104.37 76.45 70.71 113.68 113.55 147.45 253.92 372.12 662.51 671.64 1,167.20 836.48
Operating Profit 2.48 2.12 -3.44 0.44 12.06 9.61 11.66 18.22 28.74 46.75 50.48 87.73 55.18
Other Income 8.52 1.22 -0.16 58.98 2.59 1.61 0.60 1.41 8.42 11.92 11.96 - -
Depreciation 0.84 0.57 0.52 0.48 1.30 1.65 1.39 1.26 1.56 3.82 4.74 4.74 4.74
Interest 9.71 11.44 11.90 12.19 7.75 8.27 9.82 11.72 17.82 26.24 28.76 28.76 28.76
Profit before tax 0.45 -8.67 -16.02 46.75 5.60 1.30 1.05 6.65 17.78 28.61 28.94 54.23 21.68
Tax -0.50 -1.47 -2.92 -3.63 -0.29 0.68 0.28 6.07 3.12 8.11 8.38 29% 29%
Net profit 0.94 -7.19 -13.10 50.38 5.89 0.62 0.77 0.58 14.66 20.51 20.57 38.52 15.40
EPS 1.09 -8.36 -15.23 58.58 6.85 0.72 0.90 0.67 17.05 23.85 23.81 44.59 17.83
Price to earning 16.65 -2.94 -1.32 0.31 2.69 45.22 53.39 95.09 21.90 27.43 28.22 43.16 28.22
Price 18.20 24.60 20.05 18.20 18.40 32.60 47.80 64.13 373.25 654.25 671.90 1,924.43 503.06

RATIOS:
Dividend Payout 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 8.87% 8.43%
OPM 2.65% 1.99% 0.00% 0.62% 9.59% 7.80% 7.33% 6.70% 7.17% 6.59% 6.99%

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

Sales Growth 25.26% 38.38% 41.34% 64.58% 76.93% 76.93% 25.26%
OPM 6.19% 6.85% 6.91% 6.78% 6.99% 6.99% 6.19%
Price to Earning 32.32 34.28 45.21 43.16 28.22 43.16 28.22
DELTON CABLES LTD SCREENER.IN

Narration Mar-23 Jun-23 Sep-23 Dec-23 Mar-24 Jun-24 Sep-24 Dec-24 Mar-25 Jun-25
Sales 80.50 69.53 89.87 109.67 131.78 143.48 174.92 188.64 202.23 156.33
Expenses 77.35 64.58 82.13 101.50 123.91 133.92 164.87 177.26 186.48 143.03
Operating Profit 3.15 4.95 7.74 8.17 7.87 9.56 10.05 11.38 15.75 13.30
Other Income 0.62 0.32 0.48 1.44 6.18 0.36 10.67 0.41 0.48 0.40
Depreciation 0.32 0.30 0.31 0.37 0.58 0.57 0.91 1.17 1.16 1.50
Interest 2.47 3.41 4.61 4.66 5.14 5.20 6.43 6.56 8.04 7.73
Profit before tax 0.98 1.56 3.30 4.58 8.33 4.15 13.38 4.06 7.03 4.47
Tax 5.31 0.29 -0.04 0.84 2.03 1.12 4.90 0.70 1.38 1.40
Net profit -4.33 1.27 3.33 3.74 6.31 3.02 8.49 3.36 5.64 3.08

OPM 4% 7% 9% 7% 6% 7% 6% 6% 8% 9%
DELTON CABLES LTD SCREENER.IN

Narration Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24 Mar-25
Equity Share Capital 8.64 8.64 8.64 8.64 8.64 8.64 8.64 8.64 8.64 8.64
Reserves 12.38 3.76 -9.57 40.46 45.98 46.51 47.44 48.07 62.69 81.81
Borrowings 60.75 63.97 68.61 54.81 46.88 62.44 70.60 75.37 113.13 184.22
Other Liabilities 25.11 30.92 30.32 40.13 33.98 25.59 33.83 52.37 82.76 153.44
Total 106.88 107.29 98.00 144.04 135.48 143.18 160.51 184.45 267.22 428.11

Net Block 6.05 4.08 3.00 4.63 10.35 11.16 10.39 10.68 17.61 50.28
Capital Work in Progress - - - - - - - - - -
Investments - - - - - - - - - 0.05
Other Assets 100.83 103.21 95.00 139.41 125.13 132.02 150.12 173.77 249.61 377.78
Total 106.88 107.29 98.00 144.04 135.48 143.18 160.51 184.45 267.22 428.11

Working Capital 75.72 72.29 64.68 99.28 91.15 106.43 116.29 121.40 166.85 224.34
Debtors 37.54 42.16 27.18 31.61 25.94 33.48 34.95 51.46 95.76 160.68
Inventory 41.38 39.96 47.27 36.23 56.69 62.98 81.15 90.65 115.70 170.34

Debtor Days 146.64 144.51 135.88 162.16 75.30 99.22 80.18 69.02 87.19 82.69
Inventory Turnover 2.26 2.66 1.54 1.96 2.22 1.96 1.96 3.00 3.46 4.16

Return on Equity 4% -58% 103% 11% 1% 1% 1% 21% 23%

Return on Capital Emp 4% -6% 69% 13% 9% 9% 14% 22% 24%
DELTON CABLES LTD SCREENER.IN

Narration Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24 Mar-25
Cash from Operating Activity -7.24 6.06 6.57 -28.56 -14.56 -8.46 0.78 2.46 -27.26 -14.02
Cash from Investing Activity 8.20 1.29 0.59 56.66 34.15 -1.72 -0.41 -1.60 10.43 -12.26
Cash from Financing Activity -0.20 -19.57 5.96 -26.35 -13.90 5.94 -1.42 -0.69 19.94 30.20
Net Cash Flow 0.77 -12.22 13.12 1.75 5.69 -4.24 -1.06 0.17 3.10 3.92
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 DELTON CABLES LTD
LATEST VERSION 2.10 PLEAS
CURRENT VERSION 2.10

META
Number of shares 0.86
Face Value 10.00
Current Price 671.90
Market Capitalization 580.52

PROFIT & LOSS

Report Date Mar-16 Mar-17 Mar-18 Mar-19
Sales 93.44 106.49 73.01 71.15
Raw Material Cost 70.46 76.20 60.49 55.56
Change in Inventory 2.62 -1.49 6.03 5.87
Power and Fuel 3.02 3.23 1.88 1.93
Other Mfr. Exp 3.69 3.85 2.17 4.13
Employee Cost 9.87 11.47 9.77 8.63
Selling and admin 5.22 5.59 4.42 3.38
Other Expenses 1.32 2.54 3.75 2.95
Other Income 8.52 1.22 -0.16 58.98
Depreciation 0.84 0.57 0.52 0.48
Interest 9.71 11.44 11.90 12.19
Profit before tax 0.45 -8.67 -16.02 46.75
Tax -0.50 -1.47 -2.92 -3.63
Net profit 0.94 -7.19 -13.10 50.38
Dividend Amount

Quarters
Report Date Mar-23 Jun-23 Sep-23 Dec-23
Sales 80.50 69.53 89.87 109.67
Expenses 77.35 64.58 82.13 101.50
Other Income 0.62 0.32 0.48 1.44
Depreciation 0.32 0.30 0.31 0.37
Interest 2.47 3.41 4.61 4.66
Profit before tax 0.98 1.56 3.30 4.58
Tax 5.31 0.29 -0.04 0.84
Net profit -4.33 1.27 3.33 3.74
Operating Profit 3.15 4.95 7.74 8.17

BALANCE SHEET
Report Date Mar-16 Mar-17 Mar-18 Mar-19
Equity Share Capital 8.64 8.64 8.64 8.64
Reserves 12.38 3.76 -9.57 40.46
Borrowings 60.75 63.97 68.61 54.81
Other Liabilities 25.11 30.92 30.32 40.13
Total 106.88 107.29 98.00 144.04
Net Block 6.05 4.08 3.00 4.63
Capital Work in Progress
Investments
Other Assets 100.83 103.21 95.00 139.41
Total 106.88 107.29 98.00 144.04
Receivables 37.54 42.16 27.18 31.61
Inventory 41.38 39.96 47.27 36.23
Cash & Bank 3.91 2.95 2.33 44.47
No. of Equity Shares 8,640,000.00 8,640,000.00 8,640,000.00 8,640,000.00
New Bonus Shares 5,760,000.00
Face value 10.00 10.00 10.00 10.00

CASH FLOW:
Report Date Mar-16 Mar-17 Mar-18 Mar-19
Cash from Operating Activity -7.24 6.06 6.57 -28.56
Cash from Investing Activity 8.20 1.29 0.59 56.66
Cash from Financing Activity -0.20 -19.57 5.96 -26.35
Net Cash Flow 0.77 -12.22 13.12 1.75

PRICE: 18.20 24.60 20.05 18.20

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

Mar-20 Mar-21 Mar-22 Mar-23 Mar-24 Mar-25

125.74 123.16 159.11 272.14 400.86 709.26
105.58 96.84 139.38 227.89 351.24 615.58
21.08 8.08 18.63 8.12 32.30 42.20
3.29 2.16 3.00 3.73 5.08
4.67 4.39 4.04 6.88 13.87
13.66 12.40 13.56 16.52 23.41 38.67
4.64 3.35 4.56 6.71 8.70
2.92 2.49 1.54 0.31 2.12 50.46
2.59 1.61 0.60 1.41 8.42 11.92
1.30 1.65 1.39 1.26 1.56 3.82
7.75 8.27 9.82 11.72 17.82 26.24
5.60 1.30 1.05 6.65 17.78 28.61
-0.29 0.68 0.28 6.07 3.12 8.11
5.89 0.62 0.77 0.58 14.66 20.51
1.30 1.73

Mar-24 Jun-24 Sep-24 Dec-24 Mar-25 Jun-25

131.78 143.48 174.92 188.64 202.23 156.33
123.91 133.92 164.87 177.26 186.48 143.03
6.18 0.36 10.67 0.41 0.48 0.40
0.58 0.57 0.91 1.17 1.16 1.50
5.14 5.20 6.43 6.56 8.04 7.73
8.33 4.15 13.38 4.06 7.03 4.47
2.03 1.12 4.90 0.70 1.38 1.40
 6.31 3.02 8.49 3.36 5.64 3.08
7.87 9.56 10.05 11.38 15.75 13.30

Mar-20 Mar-21 Mar-22 Mar-23 Mar-24 Mar-25

8.64 8.64 8.64 8.64 8.64 8.64
45.98 46.51 47.44 48.07 62.69 81.81
46.88 62.44 70.60 75.37 113.13 184.22
33.98 25.59 33.83 52.37 82.76 153.44
135.48 143.18 160.51 184.45 267.22 428.11
10.35 11.16 10.39 10.68 17.61 50.28

0.05
125.13 132.02 150.12 173.77 249.61 377.78
135.48 143.18 160.51 184.45 267.22 428.11
25.94 33.48 34.95 51.46 95.76 160.68
56.69 62.98 81.15 90.65 115.70 170.34
10.67 6.18 5.18 5.00 8.48 12.50
8,640,000.00 8,640,000.00 8,640,000.00 8,640,000.00 8,640,000.00

10.00 10.00 10.00 10.00 10.00 10.00

Mar-20 Mar-21 Mar-22 Mar-23 Mar-24 Mar-25

-14.56 -8.46 0.78 2.46 -27.26 -14.02
34.15 -1.72 -0.41 -1.60 10.43 -12.26
-13.90 5.94 -1.42 -0.69 19.94 30.20
5.69 -4.24 -1.06 0.17 3.10 3.92

18.40 32.60 47.80 64.13 373.25 654.25

0.86 0.86 0.86 0.86 0.86 0.86