INDO AMINES LTD SCREENER.

IN

Narration Mar-12 Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Trailing Best Case Worst Case
Sales 191.34 200.07 220.60 234.00 252.58 284.53 355.31 528.06 478.75 540.53 612.24 621.67 615.41
Expenses 178.85 185.36 202.32 211.54 222.46 248.61 314.39 472.82 436.60 479.20 548.96 557.41 552.93
Operating Profit 12.49 14.71 18.28 22.46 30.12 35.92 40.92 55.24 42.15 61.33 63.28 64.25 62.49
Other Income 2.40 2.01 0.64 1.24 0.79 2.86 4.26 7.21 6.58 8.06 11.32 - -
Depreciation 3.42 2.77 5.88 10.23 12.11 12.08 12.27 14.61 19.52 11.18 8.46 8.46 8.46
Interest 4.48 4.20 4.00 5.42 4.10 3.89 7.90 9.83 10.86 9.22 10.27 10.27 10.27
Profit before tax 6.99 9.75 9.04 8.05 14.70 22.81 25.01 38.01 18.35 48.99 55.87 45.52 43.76
Tax 2.97 3.08 3.28 2.80 5.60 6.60 9.02 12.78 5.52 11.45 14.06 25% 25%
Net profit 4.03 6.67 5.76 5.25 9.10 16.21 15.99 25.24 12.81 37.60 41.81 34.07 32.74
EPS 2.07 2.51 1.85 1.64 2.84 5.07 4.80 7.58 3.85 10.65 11.83 9.64 9.26
Price to earning 4.18 4.17 5.31 12.53 13.50 14.25 17.71 12.41 7.37 8.27 21.35 21.35 11.00
Price 8.63 10.45 9.83 20.55 38.40 72.20 85.05 94.10 28.35 88.05 252.50 205.74 101.93

RATIOS:
Dividend Payout 0.00% 19.94% 27.08% 31.43% 36.15% 20.60% 20.89% 13.23% 26.07% 10.35%
OPM 6.53% 7.35% 8.29% 9.60% 11.92% 12.62% 11.52% 10.46% 8.80% 11.35% 10.34%

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

Sales Growth 12.23% 13.66% 16.44% 15.01% 13.27% 15.01% 12.23%
OPM 10.15% 10.78% 10.77% 10.26% 10.34% 10.34% 10.15%
Price to Earning 11.00 13.42 13.56 12.35 21.35 21.35 11.00
INDO AMINES 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 138.68 130.29 111.87 113.87 120.81 105.35 136.69 142.19 156.29 177.07
Expenses 123.48 117.12 101.76 104.03 112.21 93.78 119.75 122.65 143.01 163.55
Operating Profit 15.20 13.17 10.11 9.84 8.60 11.57 16.94 19.54 13.28 13.52
Other Income 0.72 1.74 2.38 0.94 1.51 0.76 1.46 3.36 2.48 4.02
Depreciation 4.27 4.34 4.41 5.00 5.58 5.85 6.46 6.22 -7.35 3.13
Interest 1.96 2.71 2.60 2.66 2.33 2.20 2.47 2.17 2.38 3.25
Profit before tax 9.69 7.86 5.48 3.12 2.20 4.28 9.47 14.51 20.73 11.16
Tax 3.02 3.02 1.08 0.95 0.48 1.43 3.13 2.19 4.71 4.03
Net profit 6.67 4.84 4.39 2.17 1.72 2.85 6.34 12.31 16.03 7.13

OPM 11% 10% 9% 9% 7% 11% 12% 14% 8% 8%

INDO AMINES LTD SCREENER.IN

Narration Mar-12 Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21
Equity Share Capital 12.16 13.28 31.12 32.92 32.92 33.35 33.35 33.35 33.35 35.35
Reserves 14.90 20.62 9.45 11.89 17.02 35.82 47.51 89.56 99.51 127.47
Borrowings 47.00 46.76 53.78 51.10 50.24 62.40 90.53 131.01 143.21 159.26
Other Liabilities 41.50 53.50 62.04 59.52 66.79 81.42 75.04 92.07 85.44 131.06
Total 115.56 134.16 156.39 155.43 166.97 212.99 246.43 345.99 361.51 453.14

Net Block 19.64 26.55 34.28 52.74 51.49 63.50 69.73 115.65 116.97 124.95
Capital Work in Progress 3.04 6.66 12.45 0.58 - 2.39 5.30 8.08 23.73 54.27
Investments 0.29 0.04 0.06 0.06 0.09 0.09 0.09 0.09 0.09 0.09
Other Assets 92.59 100.91 109.60 102.05 115.39 147.01 171.31 222.17 220.72 273.83
Total 115.56 134.16 156.39 155.43 166.97 212.99 246.43 345.99 361.51 453.14

Working Capital 51.09 47.41 47.56 42.53 48.60 65.59 96.27 130.10 135.28 142.77
Debtors 44.73 48.65 50.22 39.60 45.50 60.99 73.90 112.87 95.77 131.35
Inventory 24.38 22.26 24.48 26.98 26.86 33.01 52.26 65.87 81.78 87.84

Debtor Days 85.33 88.76 83.09 61.77 65.75 78.24 75.92 78.02 73.02 88.70
Inventory Turnover 7.85 8.99 9.01 8.67 9.40 8.62 6.80 8.02 5.85 6.15

Return on Equity 15% 20% 14% 12% 18% 23% 20% 21% 10% 23%
Return on Capital Emp 18% 15% 14% 19% 23% 22% 22% 11% 19%
INDO AMINES LTD SCREENER.IN

Narration Mar-12 Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21
Cash from Operating Activity -3.17 19.48 18.75 23.49 19.17 14.60 7.76 27.46 38.75 56.18
Cash from Investing Activity -9.70 -13.78 -20.86 -13.56 -9.97 -22.77 -21.14 -42.72 -36.05 -49.66
Cash from Financing Activity 14.50 -4.94 2.47 -8.78 -8.92 6.90 16.28 17.27 -2.67 -1.12
Net Cash Flow 1.63 0.76 0.36 1.16 0.28 -1.27 2.90 2.02 0.03 5.40
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 INDO AMINES LTD
LATEST VERSION 2.10 PLEAS
CURRENT VERSION 2.10

META
Number of shares 3.53
Face Value 10.00
Current Price 252.50
Market Capitalization 892.56

PROFIT & LOSS

Report Date Mar-12 Mar-13 Mar-14 Mar-15
Sales 191.34 200.07 220.60 234.00
Raw Material Cost 139.55 152.89 159.32 170.51
Change in Inventory 2.11 0.87 -1.70 2.19
Power and Fuel 4.44 4.61 5.73
Other Mfr. Exp 5.20 8.01 8.12
Employee Cost 4.27 5.48 8.81 10.50
Selling and admin 8.15 19.05 18.12
Other Expenses 37.14 10.07 0.82 0.75
Other Income 2.40 2.01 0.64 1.24
Depreciation 3.42 2.77 5.88 10.23
Interest 4.48 4.20 4.00 5.42
Profit before tax 6.99 9.75 9.04 8.05
Tax 2.97 3.08 3.28 2.80
Net profit 4.03 6.67 5.76 5.25
Dividend Amount 1.33 1.56 1.65

Quarters
Report Date Mar-19 Jun-19 Sep-19 Dec-19
Sales 138.68 130.29 111.87 113.87
Expenses 123.48 117.12 101.76 104.03
Other Income 0.72 1.74 2.38 0.94
Depreciation 4.27 4.34 4.41 5.00
Interest 1.96 2.71 2.60 2.66
Profit before tax 9.69 7.86 5.48 3.12
Tax 3.02 3.02 1.08 0.95
Net profit 6.67 4.84 4.39 2.17
Operating Profit 15.20 13.17 10.11 9.84

BALANCE SHEET
Report Date Mar-12 Mar-13 Mar-14 Mar-15
Equity Share Capital 12.16 13.28 31.12 32.92
Reserves 14.90 20.62 9.45 11.89
Borrowings 47.00 46.76 53.78 51.10
Other Liabilities 41.50 53.50 62.04 59.52
Total 115.56 134.16 156.39 155.43
Net Block 19.64 26.55 34.28 52.74
Capital Work in Progress 3.04 6.66 12.45 0.58
Investments 0.29 0.04 0.06 0.06
Other Assets 92.59 100.91 109.60 102.05
Total 115.56 134.16 156.39 155.43
Receivables 44.73 48.65 50.22 39.60
Inventory 24.38 22.26 24.48 26.98
Cash & Bank 3.55 4.31 4.67 5.82
No. of Equity Shares 12,158,390.00 31,116,800.00 31,116,780.00 32,916,780.00
New Bonus Shares 15,558,390.00
Face value 10.00 10.00 10.00 10.00

CASH FLOW:
Report Date Mar-12 Mar-13 Mar-14 Mar-15
Cash from Operating Activity -3.17 19.48 18.75 23.49
Cash from Investing Activity -9.70 -13.78 -20.86 -13.56
Cash from Financing Activity 14.50 -4.94 2.47 -8.78
Net Cash Flow 1.63 0.76 0.36 1.16

PRICE: 8.63 10.45 9.83 20.55

DERIVED:
Adjusted Equity Shares in Cr 1.95 2.66 3.11 3.20
 PLEASE DO NOT MAKE ANY CHANGES TO THIS SHEET

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

252.58 284.53 355.31 528.06 478.75 540.53
165.33 184.48 232.82 359.87 321.17 319.88
2.14 2.74 5.22 8.33 15.56 -14.23
13.66 15.55 18.72 25.33 27.58 28.38
12.71 18.85 25.73 35.52 36.63 38.56
11.73 14.10 17.51 25.78 28.60 28.86
21.18 18.12 24.59 33.49 37.94 47.83
-0.01 0.25 0.24 1.16 0.24 1.46
0.79 2.86 4.26 7.21 6.58 8.06
12.11 12.08 12.27 14.61 19.52 11.18
4.10 3.89 7.90 9.83 10.86 9.22
14.70 22.81 25.01 38.01 18.35 48.99
5.60 6.60 9.02 12.78 5.52 11.45
9.10 16.21 15.99 25.24 12.81 37.60
3.29 3.34 3.34 3.34 3.34 3.89

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

120.81 105.35 136.69 142.19 156.29 177.07
112.21 93.78 119.75 122.65 143.01 163.55
1.51 0.76 1.46 3.36 2.48 4.02
5.58 5.85 6.46 6.22 -7.35 3.13
2.33 2.20 2.47 2.17 2.38 3.25
2.20 4.28 9.47 14.51 20.73 11.16
0.48 1.43 3.13 2.19 4.71 4.03
 1.72 2.85 6.34 12.31 16.03 7.13
8.60 11.57 16.94 19.54 13.28 13.52

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

32.92 33.35 33.35 33.35 33.35 35.35
17.02 35.82 47.51 89.56 99.51 127.47
50.24 62.40 90.53 131.01 143.21 159.26
66.79 81.42 75.04 92.07 85.44 131.06
166.97 212.99 246.43 345.99 361.51 453.14
51.49 63.50 69.73 115.65 116.97 124.95
2.39 5.30 8.08 23.73 54.27
0.09 0.09 0.09 0.09 0.09 0.09
115.39 147.01 171.31 222.17 220.72 273.83
166.97 212.99 246.43 345.99 361.51 453.14
45.50 60.99 73.90 112.87 95.77 131.35
26.86 33.01 52.26 65.87 81.78 87.84
6.10 4.83 7.72 9.74 9.76 15.16
32,916,780.00 33,348,780.00 33,348,780.00 33,348,780.00 33,348,780.00 35,348,780.00

10.00 10.00 10.00 10.00 10.00 10.00

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

19.17 14.60 7.76 27.46 38.75 56.18
-9.97 -22.77 -21.14 -42.72 -36.05 -49.66
-8.92 6.90 16.28 17.27 -2.67 -1.12
0.28 -1.27 2.90 2.02 0.03 5.40

38.40 72.20 85.05 94.10 28.35 88.05

3.20 3.20 3.33 3.33 3.33 3.53