ATUL AUTO LTD SCREENER.

IN

Narration Mar-10 Mar-11 Mar-12 Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Trailing Best Case Worst Case #DIV/0!
Sales 119.85 202.04 298.82 363.84 430.13 492.80 531.04 475.32 555.98 666.76 679.59 799.61 720.32 #DIV/0!
Expenses 106.90 182.61 272.35 323.76 384.74 435.12 454.75 415.82 483.44 585.28 594.96 699.07 634.68 0.0134377
Operating Profit 12.95 19.43 26.47 40.08 45.39 57.68 76.29 59.50 72.54 81.48 84.63 100.55 85.64 0.1222029
Other Income 11% 10% 9% 11% 11% 12% 14% 13% 13% 12% 0.57 - - 0.0002088
Depreciation 3.87 4.25 4.26 4.44 5.21 5.58 5.29 5.28 5.26 5.54 6.22 6.22 6.22 0.0679921
Interest 3.16 1.83 0.76 0.40 0.35 0.59 0.78 0.58 0.42 0.86 1.00 1.00 1.00 7.0374767
Profit before tax 7.15 13.97 23.24 37.22 42.75 59.25 71.53 56.10 69.43 81.95 80.64 93.33 78.42 14.792419
Tax 2.61 4.54 7.65 11.30 12.95 18.68 24.13 19.05 23.25 28.83 20.23 25% 25% 33.523256
Net profit 4.54 9.43 15.59 25.92 29.79 40.57 47.40 37.05 46.19 53.12 60.41 69.91 58.75 0.6482001
EPS - - 7.12 11.84 13.60 18.53 21.64 16.92 21.09 24.26 27.53 31.86 26.77 0.8413357
Price to earning #DIV/0! #DIV/0! 5.37 6.25 13.41 30.04 23.87 27.60 20.92 14.02 5.56 17.02 5.56 0.2638415
Price 12.69 32.89 38.25 74.00 182.48 556.55 516.60 466.95 441.20 339.95 153.05 542.39 148.84 14.015258
0
RATIOS: 0
Dividend Payout 26.87% 25.77% 24.25% 25.93% 28.20% 27.61% 24.81% 25.16% 24.94% 16.53% #DIV/0!
OPM 10.81% 9.62% 8.86% 11.02% 10.55% 11.70% 14.37% 12.52% 13.05% 12.22% 12.45% #DIV/0!

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

Sales Growth 21.01% 12.15% 9.16% 7.88% 19.93% 19.93% 7.88%
OPM 11.89% 12.31% 12.77% 12.57% 12.45% 12.57% 11.89%
Price to Earning 16.34 17.71 20.33 17.02 5.56 17.02 5.56
ATUL AUTO LTD SCREENER.IN

Narration Sep-17 Dec-17 Mar-18 Jun-18 Sep-18 Dec-18 Mar-19 Jun-19 Sep-19 Dec-19 0.170732
Sales 159.86 129.01 150.58 137.31 176.48 186.13 166.84 147.74 172.18 192.83 0.170732
Expenses 132.92 113.42 132.53 122.47 153.56 161.31 147.94 129.54 152.06 165.42
Operating Profit 26.94 15.59 18.05 14.84 22.92 24.82 18.90 18.20 20.12 27.41 0.170732
Other Income 0.52 0.43 0.98 0.12 0.15 0.15 0.13 0.14 0.13 0.17 0.1707317
Depreciation 1.31 1.34 1.32 1.34 1.38 1.39 1.43 1.57 1.60 1.62 0.1707317
Interest 0.07 0.13 0.12 0.18 0.39 0.15 0.15 0.18 0.46 0.21 0.1707317
Profit before tax 26.08 14.55 17.59 15.75 23.30 25.10 17.79 17.41 19.04 26.40 0.1707317
Tax 9.09 4.85 5.90 5.44 8.38 8.99 6.01 6.16 1.34 6.72 0.1707317
Net profit 16.99 9.70 11.69 10.31 14.92 16.11 11.78 11.25 17.70 19.68
11% 8% 8% 8% 8% 9% 7% 8% 10% 10% 0.1707317
OPM 17% 12% 12% 11% 13% 13% 11% 12% 12% 14% 0.170732
ATUL AUTO LTD SCREENER.IN

Narration Mar-10 Mar-11 Mar-12 Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18 Mar-19
Equity Share Capital 6.08 6.08 7.55 11.20 11.20 11.20 11.20 10.97 10.97 10.97
Reserves 27.56 34.27 48.54 63.10 83.27 109.86 143.40 173.27 208.42 247.63 220.07
Borrowings 23.17 6.00 3.89 - - - - - - -
Other Liabilities 20.63 28.43 36.76 49.10 50.25 57.02 67.72 61.87 80.53 95.65
Total 77.44 74.78 96.74 123.40 144.72 178.08 222.32 246.11 299.92 354.25
- -6.77
Net Block 41.77 42.47 39.97 43.07 52.70 79.44 84.60 87.15 86.55 93.71
Capital Work in Progress 1.05 - 1.57 5.00 0.63 0.48 2.86 3.16 5.26 36.60
Investments 2.30 2.30 1.23 1.23 1.23 0.99 0.99 23.70 58.56 22.68 20.38
Other Assets 32.32 30.01 53.97 74.10 90.16 97.17 133.87 132.10 149.55 201.26
Total 77.44 74.78 96.74 123.40 144.72 178.08 222.32 246.11 299.92 354.25

Working Capital 11.69 1.58 17.21 25.00 39.91 40.15 66.15 70.23 69.02 105.61
Debtors 4.51 5.41 6.08 7.15 13.07 32.18 76.35 47.19 78.22 100.32
Inventory 18.57 19.17 29.83 22.95 23.37 26.00 34.72 36.23 46.03 57.45

Debtor Days 13.74 9.77 7.43 7.17 11.09 23.83 52.48 36.24 51.35 54.92
Inventory Turnover 6.45 10.54 10.02 15.85 18.41 18.95 15.29 13.12 12.08 11.61

Return on Equity 13% 23% 28% 35% 32% 34% 31% 20% 21% 21%
Return on Capital Emp 31% 45% 56% 51% 56% 52% 33% 35% 35%
ATUL AUTO LTD SCREENER.IN

Narration Mar-10 Mar-11 Mar-12 Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18 Mar-19
Cash from Operating Activity 9.58 14.05 19.55 40.66 23.96 28.10 10.86 71.11 26.11 34.55
Cash from Investing Activity -1.93 -1.27 -6.11 -9.54 -10.56 -36.37 -9.98 -28.96 -39.20 -27.67
Cash from Financing Activity -7.86 -11.59 -4.91 -4.42 -12.85 -11.08 -13.87 -13.87 -11.23 -13.89
Net Cash Flow -0.21 1.19 8.53 26.70 0.55 -19.34 -12.98 28.29 -24.31 -7.01
Report Date Mar-10 Mar-11 Mar-12 Mar-13 Mar-14 Mar-15
Sales 119.85 202.04 298.82 363.84 430.13 492.80
Net profit 4.54 9.43 15.59 25.92 29.79 40.57
Depreciation 3.87 4.25 4.26 4.44 5.21 5.58
Dividend Amount 1.22 2.43 3.78 6.72 8.4 11.2
Net Block 41.77 42.47 39.97 43.07 52.70 79.44
NFAT 4.80 7.25 8.76 8.98 7.46
NPM 4% 5% 5% 7% 7% 8%
DPR 27% 26% 24% 26% 28% 28%
DEP(DEP as % of NFA) 9% 10% 11% 10% 10% 7%
3 yr nfat 6.94 8.33 8.40
3 yr npm 6% 6% 7%
3 yr dpr 25% 26% 27%
3 yr dep 10% 10% 9%
ssgr 19% 29% 36%
inventory turnover(higher is better) 11 12 14 19 20
receivable days(lower is better) 9 7 7 9 17
asset turnover (higher is better) 4.8 7.2 8.8 9.0 7.5
working capital cycle 43 37 33 28 35
CWIP 1 0 2 5 1 0
CPAT
CFO 10 14 20 41 24 28
CAPEX 4 3 11 10 32
FCF 10 16 30 13 -4
CFI -1.93 -1.27 -6.11 -9.54 -10.56 -36.37
CFF -7.86 -11.59 -4.91 -4.42 -12.85 -11.08
CFI+CFF
debt 23 6 4 0 0 0
Debt taken(paid) -17 -2 -4 0 0
dividend paid
FCF/CAPEX
debt/equity 0.7 0.1 0.1 0.0 0.0 0.0

Mar-10 Mar-11 Mar-12 Mar-13 Mar-14 Mar-15

reserves 6.71 14.27 14.56 20.17 26.59
inventory sold -0.6 -10.66 6.88 -0.42 -2.63
fixed asset sold (0.70) 2.50 (3.10) (9.63) (26.74)
STL 7.59 1.59 2.1 2.08 3.61 4.18
LTL 0 1 4.59 3.85 4.96 9.01
PAYABLES 8.89 10.81 15.68 23.46 27.16 26.75
STL GIVEN -6 0.51 -0.02 1.53 0.57
LTL SOLD -1 -3.59 0.74 -1.11 -4.05

TTL FUND RECEIVED 4.41 2.52 19.08 9.01 (6.83)

LTD+STD PAID 17.17 2.11 3.89 0 0
CASH INCREASE 1.19 8.53 26.7 7.08 -19.35
CREDIT TO CUSTOMERS 0.9 0.67 1.07 5.92 19.11
STL GIVEN -6 0.51 -0.02 1.53 0.57
TRADE PAYABLES PAID -1.92 -4.87 -7.78 -3.7 0.41

TTL FUND OUTFLOW 11.34 6.95 23.86 10.83 0.74

management compensation 2.94

% of npm 7%
Mar-16 Mar-17 Mar-18 Mar-19 GROWTH RATE GROWTH RATE 3 GROWTH RATE 5 YRS
531.04 475.32 555.98 666.76 21% 8% 9%
47.40 37.05 46.19 53.12 31% 4% 12%
5.29 5.28 5.26 5.54
11.76 9.32 11.52 8.78 17% 20%
84.60 87.15 86.55 93.71 25% 15%
6.47 5.54 6.40 7.40
9% 8% 8% 8%
25% 25% 25% 17%
6% 6% 6% 6%
7.64 6.49 6.14 6.44
8% 8% 8% 8%
27% 26% 25% 22%
8% 6% 6% 6%
37% 34% 32% 34%
17 13 14 13
37 47 41 49
6.5 5.5 6.4 7.4
58 75 68 77
3 3 5 37
310
11 71 26 35 279
13 8 7 44 133
-2 63 19 -9 136
-9.98 -28.96 -39.2 -27.67 -172
-13.87 -13.87 -11.23 -13.89 -106
-277
0 0 0 0
0 0 0 0 -23
75
1.03
0.0 0.0 0.0 0.0

Mar-16 Mar-17 Mar-18 Mar-19

33.54 29.87 35.15 39.21
-8.72 -1.51 -9.8 -11.42
(5.16) (2.55) 0.60 (7.16)
5.27 3.1 3.69 5.81
4.71 3.05 3.75 20.9
36 35.96 49.4 58.77
1.09 -2.17 0.59 2.12
4.3 1.66 -0.7 -17.15

23.96 27.47 25.25 3.48 108.35

 0 0 0 0 23.17
-12.98 29.71 -24.67 -1.08 15.13
44.17 -29.16 31.03 22.1 95.81
1.09 -2.17 0.59 2.12 -1.78
-9.25 0.04 -13.44 -9.37 -49.88
0
23.03 -1.58 -6.49 13.77 82.45

2.46 2.83 2.89 3.16

5% 8% 6% 6%
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 ATUL AUTO LTD
LATEST VERSION 2.10 PLEAS
CURRENT VERSION 2.10

META
Number of shares 2.19
Face Value 5.00
Current Price 153.05
Market Capitalization 335.84

PROFIT & LOSS

Report Date Mar-10 Mar-11 Mar-12 Mar-13
Sales 119.85 202.04 298.82 363.84
Raw Material Cost 91.60 157.49 241.86 283.49
Change in Inventory 0.72 -0.98 4.30 -0.74
Power and Fuel 0.52 1.20 1.80 1.66
Other Mfr. Exp 2.33 1.43 3.55 2.87
Employee Cost 7.39 11.60 16.49 21.02
Selling and admin 4.01 6.42 11.09 13.04
Other Expenses 1.77 3.49 1.86 0.94
Other Income 1.23 0.62 1.79 1.98
Depreciation 3.87 4.25 4.26 4.44
Interest 3.16 1.83 0.76 0.40
Profit before tax 7.15 13.97 23.24 37.22
Tax 2.61 4.54 7.65 11.30
Net profit 4.54 9.43 15.59 25.92
Dividend Amount 1.22 2.43 3.78 6.72

Quarters
Report Date Sep-17 Dec-17 Mar-18 Jun-18
Sales 159.86 129.01 150.58 137.31
Expenses 132.92 113.42 132.53 122.47
Other Income 0.52 0.43 0.98 2.43
Depreciation 1.31 1.34 1.32 1.34
Interest 0.07 0.13 0.12 0.18
Profit before tax 26.08 14.55 17.59 15.75
Tax 9.09 4.85 5.90 5.44
Net profit 16.99 9.70 11.69 10.31
Operating Profit 26.94 15.59 18.05 14.84

BALANCE SHEET
Report Date Mar-10 Mar-11 Mar-12 Mar-13
Equity Share Capital 6.08 6.08 7.55 11.20
Reserves 27.56 34.27 48.54 63.10
Borrowings 23.17 6.00 3.89
Other Liabilities 20.63 28.43 36.76 49.10
Total 77.44 74.78 96.74 123.40
Net Block 41.77 42.47 39.97 43.07
Capital Work in Progress 1.05 1.57 5.00
Investments 2.30 2.30 1.23 1.23
Other Assets 32.32 30.01 53.97 74.10
Total 77.44 74.78 96.74 123.40
Receivables 4.51 5.41 6.08 7.15
Inventory 18.57 19.17 29.83 22.95
Cash & Bank 1.65 2.84 11.37 38.07
No. of Equity Shares 6,084,405.00 6,084,405.00 7,955,100.00 11,612,300.00
New Bonus Shares 3,657,200.00
Face value 10.00 10.00 10.00 10.00

CASH FLOW:
Report Date Mar-10 Mar-11 Mar-12 Mar-13
Cash from Operating Activity 9.58 14.05 19.55 40.66
Cash from Investing Activity -1.93 -1.27 -6.11 -9.54
Cash from Financing Activity -7.86 -11.59 -4.91 -4.42
Net Cash Flow -0.21 1.19 8.53 26.70

PRICE: 12.69 32.89 38.25 74.00

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

Mar-14 Mar-15 Mar-16 Mar-17 Mar-18 Mar-19

430.13 492.80 531.04 475.32 555.98 666.76
328.01 373.59 388.08 346.55 402.20 496.51
-1.26 1.38 3.21 0.86 -2.01 1.54
2.70 2.90 3.14 2.78 3.17 2.88
6.77 4.43 4.55 3.84 3.85 4.24
27.37 32.41 37.38 39.26 40.19 47.74
18.05 22.07 23.67 22.94 30.02 32.52
0.58 1.10 1.14 1.31 2.00 2.93
2.92 7.74 1.31 2.46 2.57 6.87
5.21 5.58 5.29 5.28 5.26 5.54
0.35 0.59 0.78 0.58 0.42 0.86
42.75 59.25 71.53 56.10 69.43 81.95
12.95 18.68 24.13 19.05 23.25 28.83
29.79 40.57 47.40 37.05 46.19 53.12
8.40 11.20 11.76 9.32 11.52 8.78

Sep-18 Dec-18 Mar-19 Jun-19 Sep-19 Dec-19

176.48 186.13 166.84 147.74 172.18 192.83
153.56 161.31 147.94 129.54 152.06 165.42
2.15 1.82 0.47 0.96 0.98 0.82
1.38 1.39 1.43 1.57 1.60 1.62
0.39 0.15 0.15 0.18 0.46 0.21
23.30 25.10 17.79 17.41 19.04 26.40
8.38 8.99 6.01 6.16 1.34 6.72
 14.92 16.11 11.78 11.25 17.70 19.68
22.92 24.82 18.90 18.20 20.12 27.41

Mar-14 Mar-15 Mar-16 Mar-17 Mar-18 Mar-19

11.20 11.20 11.20 10.97 10.97 10.97
83.27 109.86 143.40 173.27 208.42 247.63

50.25 57.02 67.72 61.87 80.53 95.65

144.72 178.08 222.32 246.11 299.92 354.25
52.70 79.44 84.60 87.15 86.55 93.71
0.63 0.48 2.86 3.16 5.26 36.60
1.23 0.99 0.99 23.70 58.56 22.68
90.16 97.17 133.87 132.10 149.55 201.26
144.72 178.08 222.32 246.11 299.92 354.25
13.07 32.18 76.35 47.19 78.22 100.32
23.37 26.00 34.72 36.23 46.03 57.45
45.15 25.80 12.82 42.53 17.86 16.78
11,612,300.00 23,224,600.00 23,224,600.00 23,224,600.00 23,224,600.00 23,224,600.00
-36.70
10.00 5.00 5.00 5.00 5.00 5.00

Mar-14 Mar-15 Mar-16 Mar-17 Mar-18 Mar-19

23.96 28.10 10.86 71.11 26.11 34.55
-10.56 -36.37 -9.98 -28.96 -39.20 -27.67
-12.85 -11.08 -13.87 -13.87 -11.23 -13.89
0.55 -19.34 -12.98 28.29 -24.31 -7.01

182.48 556.55 516.60 466.95 441.20 339.95

2.19 2.19 2.19 2.19 2.19 2.19