ADVANCED ENZYME TECHNOLOGIES LTD SCREENER.

IN

Narration Mar-11 Mar-12 Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Trailing Best Case Worst Case
Sales 115.55 170.97 219.22 238.74 221.71 293.04 328.99 391.02 419.59 443.99 478.89 490.65 481.63
Expenses 92.89 108.67 129.67 188.91 130.84 155.47 177.33 226.08 236.09 240.60 253.54 259.77 285.74
Operating Profit 22.66 62.30 89.55 49.83 90.87 137.57 151.66 164.94 183.50 203.39 225.35 230.88 195.90
Other Income 3.72 3.12 3.70 0.98 1.16 -2.81 2.58 1.39 4.78 5.63 9.00 - -
Depreciation 4.99 5.50 7.55 9.87 9.02 8.72 12.76 18.30 21.12 25.78 26.67 26.67 26.67
Interest 2.51 12.24 9.55 13.19 9.26 7.86 4.43 9.06 5.20 4.08 1.87 1.87 1.87
Profit before tax 18.88 47.68 76.15 27.75 73.75 118.18 137.05 138.97 161.96 179.16 205.81 202.34 167.36
Tax 1.87 14.01 25.88 6.40 22.82 41.44 44.11 45.41 46.06 46.11 55.45 27% 27%
Net profit 16.82 33.34 49.22 20.09 50.10 75.85 91.55 90.06 111.06 129.29 145.86 147.83 122.27
EPS 1.62 3.22 4.52 1.85 4.60 6.97 8.20 8.07 9.95 11.57 13.05 13.23 10.94
Price to earning 50.21 26.42 18.35 12.31 27.87 27.87 21.24
Price - - - - - - 411.89 213.20 182.60 142.50 363.90 368.81 232.42

RATIOS:
Dividend Payout 6.18% 0.63% 7.07% 6.17% 3.65% 2.87% 4.88% 6.20% 6.03% 5.18%
OPM 19.61% 36.44% 40.85% 20.87% 40.99% 46.95% 46.10% 42.18% 43.73% 45.81% 47.06%

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

Sales Growth 16.13% 10.61% 14.90% 10.51% 7.86% 10.51% 7.86%
OPM 40.67% 42.01% 44.82% 43.98% 47.06% 47.06% 40.67%
Price to Earning 27.03 27.03 27.03 21.24 27.87 27.87 21.24
ADVANCED ENZYME TECHNOLOGIES LTD SCREENER.IN

Narration Sep-18 Dec-18 Mar-19 Jun-19 Sep-19 Dec-19 Mar-20 Jun-20 Sep-20 Dec-20
Sales 103.15 101.74 110.42 110.34 111.44 111.94 110.26 110.50 120.39 137.74
Expenses 61.03 60.01 60.72 56.85 64.17 59.08 61.56 58.76 61.87 71.35
Operating Profit 42.12 41.73 49.70 53.49 47.27 52.86 48.70 51.74 58.52 66.39
Other Income 2.02 - 2.64 1.06 1.54 1.21 1.84 5.23 0.58 1.35
Depreciation 5.25 5.41 5.28 6.26 6.47 6.39 6.65 6.72 6.80 6.50
Interest 2.26 -0.34 0.58 0.82 0.74 0.79 0.69 0.46 0.39 0.33
Profit before tax 36.63 36.66 46.48 47.47 41.60 46.89 43.20 49.79 51.91 60.91
Tax 10.77 11.32 13.03 13.50 9.75 12.33 10.52 14.98 13.35 16.60
Net profit 24.73 24.45 32.21 33.40 30.95 33.61 31.33 34.25 37.19 43.09

OPM 41% 41% 45% 48% 42% 47% 44% 47% 49% 48%
ADVANCED ENZYME TECHNOLOGIES LTD SCREENER.IN

Narration Mar-11 Mar-12 Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20
Equity Share Capital 20.73 20.73 21.77 21.77 21.77 21.77 22.33 22.33 22.33 22.34
Reserves 42.41 75.23 140.20 144.60 188.27 256.32 441.72 536.76 656.52 817.32
Borrowings 64.14 206.73 185.72 166.87 115.03 101.34 54.06 66.77 35.03 33.38
Other Liabilities 25.26 46.32 48.32 73.00 92.41 70.88 64.55 101.55 91.31 98.15
Total 152.54 349.01 396.01 406.24 417.48 450.31 582.66 727.41 805.19 971.19

Net Block 51.36 204.41 286.52 287.12 287.10 285.46 421.36 491.29 495.46 562.87
Capital Work in Progress 18.87 60.23 2.09 2.40 5.33 6.90 8.05 10.54 10.50 10.13
Investments 0.06 0.06 0.06 0.06 0.06 0.06 0.07 0.07 111.05 123.59
Other Assets 82.25 84.31 107.34 116.66 124.99 157.89 153.18 225.51 188.18 274.60
Total 152.54 349.01 396.01 406.24 417.48 450.31 582.66 727.41 805.19 971.19

Working Capital 56.99 37.99 59.02 43.66 32.58 87.01 88.63 123.96 96.87 176.45
Debtors 22.16 32.66 39.07 32.37 37.01 41.80 49.82 58.59 58.73 74.69
Inventory 17.87 29.08 44.59 49.93 52.63 60.49 68.48 75.57 76.90 80.03

Debtor Days 70.00 69.73 65.05 49.49 60.93 52.06 55.27 54.69 51.09 61.40
Inventory Turnover 6.47 5.88 4.92 4.78 4.21 4.84 4.80 5.17 5.46 5.55

Return on Equity 27% 35% 30% 12% 24% 27% 20% 16% 16% 15%
Return on Capital Emp 28% 26% 12% 25% 36% 32% 26% 25% 23%
ADVANCED ENZYME TECHNOLOGIES LTD SCREENER.IN

Narration Mar-11 Mar-12 Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20
Cash from Operating Activity 15.86 48.59 41.10 43.26 53.73 93.40 107.35 115.98 128.57 140.90
Cash from Investing Activity -29.82 -186.52 -39.74 -24.68 -15.44 -9.74 -59.81 -60.29 -123.55 -42.74
Cash from Financing Activity 26.86 128.41 -3.19 -19.70 -36.33 -62.58 -65.30 -2.07 -43.09 -38.55
Net Cash Flow 12.90 -9.52 -1.83 -1.12 1.96 21.09 -17.76 53.62 -38.07 59.60
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 ADVANCED ENZYME TECHNOLOGIES LTD
LATEST VERSION 2.10 PLEAS
CURRENT VERSION 2.10

META
Number of shares 11.17
Face Value 2.00
Current Price 363.90
Market Capitalization 4,065.80

PROFIT & LOSS

Report Date Mar-11 Mar-12 Mar-13 Mar-14
Sales 115.55 170.97 219.22 238.74
Raw Material Cost 40.50 51.50 59.54 57.86
Change in Inventory -6.52 3.68 8.41 10.80
Power and Fuel 9.04 12.67 15.64 14.89
Other Mfr. Exp 6.08 8.94 11.78 10.72
Employee Cost 13.50 20.25 27.01 32.91
Selling and admin 16.24 16.30 19.79 79.21
Other Expenses 1.01 2.69 4.32 4.12
Other Income 3.72 3.12 3.70 0.98
Depreciation 4.99 5.50 7.55 9.87
Interest 2.51 12.24 9.55 13.19
Profit before tax 18.88 47.68 76.15 27.75
Tax 1.87 14.01 25.88 6.40
Net profit 16.82 33.34 49.22 20.09
Dividend Amount 1.04 0.21 3.48 1.24

Quarters
Report Date Sep-18 Dec-18 Mar-19 Jun-19
Sales 103.15 101.74 110.42 110.34
Expenses 61.03 60.01 60.72 56.85
Other Income 2.02 2.64 1.06
Depreciation 5.25 5.41 5.28 6.26
Interest 2.26 -0.34 0.58 0.82
Profit before tax 36.63 36.66 46.48 47.47
Tax 10.77 11.32 13.03 13.50
Net profit 24.73 24.45 32.21 33.40
Operating Profit 42.12 41.73 49.70 53.49

BALANCE SHEET
Report Date Mar-11 Mar-12 Mar-13 Mar-14
Equity Share Capital 20.73 20.73 21.77 21.77
Reserves 42.41 75.23 140.20 144.60
Borrowings 64.14 206.73 185.72 166.87
Other Liabilities 25.26 46.32 48.32 73.00
Total 152.54 349.01 396.01 406.24
Net Block 51.36 204.41 286.52 287.12
Capital Work in Progress 18.87 60.23 2.09 2.40
Investments 0.06 0.06 0.06 0.06
Other Assets 82.25 84.31 107.34 116.66
Total 152.54 349.01 396.01 406.24
Receivables 22.16 32.66 39.07 32.37
Inventory 17.87 29.08 44.59 49.93
Cash & Bank 14.88 5.30 3.70 2.65
No. of Equity Shares 20,732,000.00 20,732,000.00 21,766,000.00 21,766,000.00
New Bonus Shares
Face value 10.00 10.00 10.00 10.00

CASH FLOW:
Report Date Mar-11 Mar-12 Mar-13 Mar-14
Cash from Operating Activity 15.86 48.59 41.10 43.26
Cash from Investing Activity -29.82 -186.52 -39.74 -24.68
Cash from Financing Activity 26.86 128.41 -3.19 -19.70
Net Cash Flow 12.90 -9.52 -1.83 -1.12

PRICE:

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

Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20

221.71 293.04 328.99 391.02 419.59 443.99
47.99 69.66 70.14 80.33 65.95 90.83
0.27 7.99 -0.89 -1.14 -11.29 9.92
10.13 10.17 12.87 18.10 19.29 19.02
9.96 10.94 9.67 11.86 11.31 16.24
36.13 44.55 50.80 68.79 80.46 80.38
23.88 23.45 25.51 38.22 39.81 37.39
3.02 4.69 7.45 7.64 7.98 6.66
1.16 -2.81 2.58 1.39 4.78 5.63
9.02 8.72 12.76 18.30 21.12 25.78
9.26 7.86 4.43 9.06 5.20 4.08
73.75 118.18 137.05 138.97 161.96 179.16
22.82 41.44 44.11 45.41 46.06 46.11
50.10 75.85 91.55 90.06 111.06 129.29
1.83 2.18 4.47 5.58 6.70 6.70

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

111.44 111.94 110.26 110.50 120.39 137.74
64.17 59.08 61.56 58.76 61.87 71.35
1.54 1.21 1.84 5.23 0.58 1.35
6.47 6.39 6.65 6.72 6.80 6.50
0.74 0.79 0.69 0.46 0.39 0.33
41.60 46.89 43.20 49.79 51.91 60.91
9.75 12.33 10.52 14.98 13.35 16.60
 30.95 33.61 31.33 34.25 37.19 43.09
47.27 52.86 48.70 51.74 58.52 66.39

Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20

21.77 21.77 22.33 22.33 22.33 22.34
188.27 256.32 441.72 536.76 656.52 817.32
115.03 101.34 54.06 66.77 35.03 33.38
92.41 70.88 64.55 101.55 91.31 98.15
417.48 450.31 582.66 727.41 805.19 971.19
287.10 285.46 421.36 491.29 495.46 562.87
5.33 6.90 8.05 10.54 10.50 10.13
0.06 0.06 0.07 0.07 111.05 123.59
124.99 157.89 153.18 225.51 188.18 274.60
417.48 450.31 582.66 727.41 805.19 971.19
37.01 41.80 49.82 58.59 58.73 74.69
52.63 60.49 68.48 75.57 76.90 80.03
4.34 26.31 7.87 61.42 23.41 83.02
21,766,000.00 21,765,600.00 22,326,005.00 ### ### ###

10.00 10.00 10.00 2.00 2.00 2.00

Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20

53.73 93.40 107.35 115.98 128.57 140.90
-15.44 -9.74 -59.81 -60.29 -123.55 -42.74
-36.33 -62.58 -65.30 -2.07 -43.09 -38.55
1.96 21.09 -17.76 53.62 -38.07 59.60

411.89 213.20 182.60 142.50

10.88 10.88 11.16 11.16 11.16 11.17