DEEPAK NITRITE LTD

Mar-10 Mar-11 Mar-12 Mar-15 Mar-16 Mar-17

Tax 0 0 0 14.3 26.23 38.24
Dividend Per Share #DIV/0! #DIV/0! #DIV/0! 1.00 1.20 1.20
Sales 0 0 0 1327.16 1372.93 1370.71

Tax
300

250

200

150

100

50

0
Jan-10 Jan-11 Jan-12 Jan-13 Jan-14 Jan-15 Jan-16 Jan-17 Jan-18 Jan-19 Jan-20 Jan-21
 Mar-18 Mar-19 Mar-20 Mar-21
31.84 94.32 195.37 265.91
1.30 2.00 4.50 5.50
1651.45 2699.92 4229.71 4359.75

Dividend Per Share

6.00

5.00

4.00

3.00

2.00

1.00

-
Jan-10 Jan-11 Jan-12 Jan-13 Jan-14 Jan-15 Jan-16 Jan-17 Jan-18 Jan-19 Jan-20 Jan-21
 Sales
5000

4500

4000

3500

3000

2500

2000

1500

1000

500

0
Jan-10 Jan-11 Jan-12 Jan-13 Jan-14 Jan-15 Jan-16 Jan-17 Jan-18 Jan-19 Jan-20 Jan-21
Company Name Market Cap

March-17 March-18 March-19

DEEPAK NITRITE LTD 28921.46 Sales Growth Rate 0 20 63
PAT Growth Rate 54 -18 120
Operating Margin 10 12 16
ROCE 14 9 17
Tax Growth Rate 46 -17 196

Scoring

Sales Growth Rate 0 4 4

PAT Growth Rate 4 0 4
Operating Margin 2 2 3
ROCE 2 1 3
Tax Growth Rate 4 0 4

Sales Growth Rate (%) PAT Growth

70
300

60 63
250
57
50
200
40
150
30

100 12
20
20

10 50
54

0 3 0
1
0 2 3 4 5 1 2 3
-10 -18
-50
 March-20 March-21
57 3
252 27
24 29
37 40
107 36

Total Score Scoring System

4 1 13 >75 Invest
4 4 16 50-75 Watchlist
4 4 15 < 50 Discard
4 4 14
4 4 16
74

What to Do? Watchlist

PAT Growth Rate (%)

35

30
252
25

20

120 15

12
10
10

27 5
2 3 4 5
-18
0
1 2
 Operating Margin
5 45

0 40

29 35
5
24 30
0
25

5 20
16

12 15
0 14
10
10
5
5

0 0
1 2 3 4 5 1
 ROCE (%)
45 250

40
40 200
35 37

30 150

25
100
20

15 17
50
14 46
10
9
5 0
1

0
1 2 3 4 5 -50
 Tax Growth Rate (%)
50

00
196

50

00 107

50
46
36
0
1 2 3 4 5
-17
50
 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21
Operating Leverage 111.93 2.34 1.67 2.57 6.78
Financial Leverage -2.96 -0.37 1.13 1.73 1.29
Combined Leverage -331.15 -0.88 1.89 4.44 8.77

Current Ratio 2.61 1.57 2.21 3.14 2.87

Quick Ratio 2.13 1.09 1.60 2.39 2.25
DEEPAK NITRITE LTD SCREENER.IN

Narration Mar-10 Mar-11 Mar-12 Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Trailing Best Case Worst Case
Sales - - - 1,327.16 1,372.93 1,370.71 1,651.45 2,699.92 4,229.71 4,359.75 5,211.48 6,025.51 5,377.88
Expenses - - - 1,187.81 1,204.57 1,232.82 1,447.40 2,278.91 3,194.81 3,109.09 3,694.58 4,271.67 4,316.88
Operating Profit - - - 139.35 168.36 137.89 204.05 421.01 1,034.90 1,250.66 1,516.90 1,753.84 1,061.00
Other Income - - - 1.96 0.02 81.25 6.82 11.31 29.20 21.02 23.02 - -
Depreciation - - - 36.02 39.54 48.04 52.60 77.79 139.73 152.63 165.18 165.18 165.18
Interest - - - 37.99 39.71 36.54 47.42 86.55 117.97 77.33 60.41 60.41 60.41
Profit before tax - - - 67.30 89.13 134.56 110.85 267.98 806.40 1,041.72 1,314.33 1,528.25 835.41
Tax - - - 14.30 26.23 38.24 31.84 94.32 195.37 265.91 334.84 25% 25%
Net profit - - - 52.90 62.73 96.32 79.02 173.66 611.03 775.81 979.49 1,138.91 622.58
EPS - - - 5.06 5.39 7.37 5.79 12.73 44.80 56.88 71.81 83.50 45.65
Price to earning 13.53 12.61 17.81 42.79 21.53 8.60 29.12 29.53 29.53 21.94
Price - - - 68.50 68.00 131.25 247.90 274.15 385.05 1,656.50 2,120.45 2,465.57 1,001.47

RATIOS:
Dividend Payout 0.00% 0.00% 0.00% 19.77% 22.25% 16.28% 22.44% 15.71% 10.05% 9.67%
OPM 0.00% 0.00% 0.00% 10.50% 12.26% 10.06% 12.36% 15.59% 24.47% 28.69% 29.11%

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

Sales Growth 26.00% 38.21% 19.54% 38.21% 19.54%
OPM 19.73% 19.73% 21.30% 23.97% 29.11% 29.11% 19.73%
Price to Earning 21.94 21.94 24.90 22.19 29.53 29.53 21.94

EPS Growth Rate (%) 36.63 -21.39 119.77 251.85 26.97

Operating Profit Growth Rate (EBIDTA) (%) -18.10 47.98 106.33 145.81 20.85

NPM (%) 7.03 4.78 6.43 14.45 17.79

Sales Growth Rate (%) -0.16 20.48 63.49 56.66 3.07

Profit Growth Rate (%) 53.55 -17.96 119.77 251.85 26.97

Operating Leverage 111.93 2.34 1.67 2.57 6.78

Financial Leverage -2.96 -0.37 1.13 1.73 1.29
Combined Leverage -331.15 -0.88 1.89 4.44 8.77
DEEPAK NITRITE LTD SCREENER.IN

Narration Mar-19 Jun-19 Sep-19 Dec-19 Mar-20 Jun-20 Sep-20 Dec-20 Mar-21 Jun-21
Sales 1,008.30 1,050.98 1,003.33 1,119.86 1,055.54 674.49 987.34 1,234.69 1,463.23 1,526.22
Expenses 814.26 797.16 752.86 861.61 793.46 492.86 711.64 899.65 1,008.57 1,074.72
Operating Profit 194.04 253.82 250.47 258.25 262.08 181.63 275.70 335.04 454.66 451.50
Other Income 8.33 11.59 7.85 14.74 2.20 6.75 3.95 4.88 5.94 8.25
Depreciation 28.56 33.22 35.14 35.14 36.23 31.01 31.24 33.92 56.46 43.56
Interest 32.64 30.96 29.75 26.96 27.20 24.73 19.57 15.70 14.20 10.94
Profit before tax 141.17 201.23 193.43 210.89 200.85 132.64 228.84 290.30 389.94 405.25
Tax 49.71 69.62 43.02 54.18 28.55 33.69 58.65 73.74 99.83 102.62
Net profit 91.46 131.61 150.41 156.71 172.30 98.95 170.19 216.56 290.11 302.63

OPM 19% 24% 25% 23% 25% 27% 28% 27% 31% 30%

Quarterly Profit Growth Rate (%) 9.95 -42.57 72.00 27.25 33.96 4.32

Quarterly Tax Growth Rate (%) -47.31 18.00 74.09 25.73 35.38 2.79

Quarterly Sales Growth Rate (%) -5.74 -36.10 46.38 25.05 18.51 4.30

YOY Profit Growth Rate (%) 88.39 -24.82 13.15 38.19 68.37 205.84

YOY Tax Growth Rate (%) -42.57 -51.61 36.33 36.10 249.67 204.60

YOY Sales Growth Rate (%) 4.69 -35.82 -1.59 10.25 38.62 126.28

Quarterly Profit Growth Rate Quarterly Tax Growth Rate Quarterly Sales Growth Rate
80.00 72.00 10 60.00
46.38
60.00 8 74.09
40.00
40.00 33.96 6 25.05
27.25 18.51
20.00
4 35.38
20.00
9.95 25.73 4.30
18.00 0.00
2 -5.74
0.00 2.79 1 2 3 4 5 6
1 2 3 4 5
-20.00 1 2 3 4 5 6 -20.00
-2 -36.10
-42.57
-40.00 -40.00
-4
-47.31
-60.00
-6 -60.00

YOY Profit Growth Rate YOY Tax Growth Rate YOY Sales Growth Rate
250.00 300.00 140.00 126.28
205.84 249.67 120.00
250.00
200.00 204.60 100.00
200.00
80.00
150.00
150.00 60.00
38.62
88.39
100.00 100.00 40.00
68.37 20.00
36.33 36.10 4.69 10.25
50.00
50.00 38.19 -1.59
0.00
13.15 0.00 1 2 3 4 5 6
1
-42.57 2 3 4 5 6 -20.00
0.00 -51.61 -35.82
1 -24.82
2 3 4 5 6 -50.00 -40.00

-50.00 -100.00 -60.00

DEEPAK NITRITE LTD SCREENER.IN

Narration Mar-10 Mar-11 Mar-12 Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21
Equity Share Capital - - - 20.91 23.26 26.14 27.28 27.28 27.28 27.28
Reserves - - - 325.31 449.61 688.72 894.86 1,044.31 1,544.63 2,319.37
Borrowings - - - 544.52 528.81 723.89 986.54 1,186.51 1,106.84 589.74
Other Liabilities - - - 234.65 294.56 350.44 683.62 677.17 537.79 630.26
Total - - - 1,125.39 1,296.24 1,789.19 2,592.30 2,935.27 3,216.54 3,566.65

Net Block - - - 548.72 593.75 585.93 587.56 1,715.83 1,831.98 1,863.74

Capital Work in Progress - - - 43.97 35.91 349.19 954.51 33.87 172.27 220.44
Investments - - - 2.98 86.60 118.08 31.77 2.39 2.38 189.29
Other Assets - - - 529.72 579.98 735.99 1,018.46 1,183.18 1,209.91 1,293.18
Total - - - 1,125.39 1,296.24 1,789.19 2,592.30 2,935.27 3,216.54 3,566.65

Working Capital - - - 295.07 285.42 385.55 334.84 506.01 672.12 662.92

Debtors - - - 310.99 313.19 360.33 411.77 574.96 612.72 756.30
Inventory - - - 107.30 123.11 168.85 327.16 418.22 402.43 389.04

Debtor Days - - - 85.53 83.26 95.95 91.01 77.73 52.87 63.32

Inventory Turnover - - - 12.37 11.15 8.12 5.05 6.46 10.51 11.21

Return on Equity 15% 13% 13% 9% 16% 39% 33%

Return on Capital Emp 24% 14% 14% 9% 17% 37% 40%

Current Ratio 2.61 1.57 2.21 3.14 2.87

Quick Ratio 2.13 1.09 1.60 2.39 2.25
DEEPAK NITRITE LTD SCREENER.IN

Narration Mar-10 Mar-11 Mar-12 Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21
Cash from Operating Activity - - - 108.01 167.28 49.01 183.00 60.28 764.66 999.04
Cash from Investing Activity - - - -89.12 -169.38 -352.55 -524.73 -162.55 -427.92 -396.16
Cash from Financing Activity - - - -22.28 4.33 304.62 345.31 95.81 -337.56 -596.13
Net Cash Flow - - - -3.40 2.23 1.07 3.59 -6.46 -0.82 6.75
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 DEEPAK NITRITE LTD
LATEST VERSION 2.10 PLEAS
CURRENT VERSION 2.10

META
Number of shares 13.64
Face Value 2.00
Current Price 2,120.45
Market Capitalization 28,921.46

PROFIT & LOSS

Report Date Mar-10 Mar-11 Mar-12 Mar-15
Sales 1,327.16
Raw Material Cost 824.49
Change in Inventory -11.53
Power and Fuel 115.92
Other Mfr. Exp 65.37
Employee Cost 100.30
Selling and admin 45.41
Other Expenses 24.79
Other Income 1.96
Depreciation 36.02
Interest 37.99
Profit before tax 67.30
Tax 14.30
Net profit 52.90
Dividend Amount 10.46

Quarters
Report Date Mar-19 Jun-19 Sep-19 Dec-19
Sales 1,008.30 1,050.98 1,003.33 1,119.86
Expenses 814.26 797.16 752.86 861.61
Other Income 8.33 11.59 7.85 14.74
Depreciation 28.56 33.22 35.14 35.14
Interest 32.64 30.96 29.75 26.96
Profit before tax 141.17 201.23 193.43 210.89
Tax 49.71 69.62 43.02 54.18
Net profit 91.46 131.61 150.41 156.71
Operating Profit 194.04 253.82 250.47 258.25

BALANCE SHEET
Report Date Mar-10 Mar-11 Mar-12 Mar-15
Equity Share Capital 20.91
Reserves 325.31
Borrowings 544.52
Other Liabilities 234.65
Total 1,125.39
Net Block 548.72
Capital Work in Progress 43.97
Investments 2.98
Other Assets 529.72
Total 1,125.39
Receivables 310.99
Inventory 107.30
Cash & Bank 3.06
No. of Equity Shares ###
New Bonus Shares
Face value 2.00

CASH FLOW:
Report Date Mar-10 Mar-11 Mar-12 Mar-15
Cash from Operating Activity 108.01
Cash from Investing Activity -89.12
Cash from Financing Activity -22.28
Net Cash Flow -3.40

PRICE: 68.50

DERIVED:
Adjusted Equity Shares in Cr - - - 10.45

Profit Growth Rate (%)

Tax Growth Rate (%)
Tax Per Share (TPS)
TPS Growth Rate (%)

Dividend Growth Rate (%)

Dividend per Share (DPS) #DIV/0! #DIV/0! #DIV/0! 1.00
DPS Growth Rate (%)

Sales Growth Rate (%)

Sales per Share (SPS)
SPS Growth Rate (%)
 PLEASE DO NOT MAKE ANY CHANGES TO THIS SHEET

Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21

1,372.93 1,370.71 1,651.45 2,699.92 4,229.71 4,359.75
832.16 849.58 1,003.71 1,773.71 2,315.30 2,239.55
6.70 25.91 -10.71 153.59 -25.59 10.01
118.15 102.44 119.88 207.33 285.19 264.74
56.27 75.29 75.04 99.11 138.87 110.83
119.25 122.46 136.36 179.96 218.81 250.31
52.11 82.05 76.02 111.24 158.47 179.83
33.33 26.91 25.68 61.15 52.58 73.84
0.02 81.25 6.82 11.31 29.20 21.02
39.54 48.04 52.60 77.79 139.73 152.63
39.71 36.54 47.42 86.55 117.97 77.33
89.13 134.56 110.85 267.98 806.40 1,041.72
26.23 38.24 31.84 94.32 195.37 265.91
62.73 96.32 79.02 173.66 611.03 775.81
13.96 15.68 17.73 27.28 61.38 75.02

Mar-20 Jun-20 Sep-20 Dec-20 Mar-21 Jun-21

1,055.54 674.49 987.34 1,234.69 1,463.23 1,526.22
793.46 492.86 711.64 899.65 1,008.57 1,074.72
2.20 6.75 3.95 4.88 5.94 8.25
36.23 31.01 31.24 33.92 56.46 43.56
27.20 24.73 19.57 15.70 14.20 10.94
200.85 132.64 228.84 290.30 389.94 405.25
28.55 33.69 58.65 73.74 99.83 102.62
 172.30 98.95 170.19 216.56 290.11 302.63
262.08 181.63 275.70 335.04 454.66 451.50

Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21

23.26 26.14 27.28 27.28 27.28 27.28
449.61 688.72 894.86 1,044.31 1,544.63 2,319.37
528.81 723.89 986.54 1,186.51 1,106.84 589.74
294.56 350.44 683.62 677.17 537.79 630.26
1,296.24 1,789.19 2,592.30 2,935.27 3,216.54 3,566.65
593.75 585.93 587.56 1,715.83 1,831.98 1,863.74
35.91 349.19 954.51 33.87 172.27 220.44
86.60 118.08 31.77 2.39 2.38 189.29
579.98 735.99 1,018.46 1,183.18 1,209.91 1,293.18
1,296.24 1,789.19 2,592.30 2,935.27 3,216.54 3,566.65
313.19 360.33 411.77 574.96 612.72 756.30
123.11 168.85 327.16 418.22 402.43 389.04
6.49 14.49 48.20 25.77 31.40 33.43
### ### ### ### ### ###

2.00 2.00 2.00 2.00 2.00 2.00

Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21

167.28 49.01 183.00 60.28 764.66 999.04
-169.38 -352.55 -524.73 -162.55 -427.92 -396.16
4.33 304.62 345.31 95.81 -337.56 -596.13
2.23 1.07 3.59 -6.46 -0.82 6.75

68.00 131.25 247.90 274.15 385.05 1,656.50

11.63 13.07 13.64 13.64 13.64 13.64

53.55 -17.96 119.77 251.85 26.97

 45.79 -16.74 196.23 107.14 36.11
2.26 2.93 2.33 6.91 14.32 19.49
29.73 -20.22 196.23 107.14 36.11

12.32 13.07 53.86 125.00 22.22

1.20 1.20 1.30 2.00 4.50 5.50
-0.05 8.35 53.86 125.00 22.22

-0.16 20.48 63.49 56.66 3.07

118.05 104.87 121.07 197.94 310.10 319.63
-11.16 15.45 63.49 56.66 3.07