Narration Mar-09 Mar-10 Mar-11 Mar-12 Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18 Trailing Best Case Worst Case
Narration Mar-09 Mar-10 Mar-11 Mar-12 Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18 Trailing Best Case Worst Case
Narration Mar-09 Mar-10 Mar-11 Mar-12 Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18 Trailing Best Case Worst Case
Expenses 94% 140% 85% 79% 146% 43% 68% 209% 169%
Operating Profit 274% -8% -71% 908% 265% 44% 185% 36% 73%
Net profit -805% -43% 124% 33% 129% 77% -260% -60% 170%
KIOCL LTD SCREENER.IN
Narration Mar-09 Mar-10 Mar-11 Mar-12 Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18 Trailing Best Case Worst Case 1.01
Sales 1,162.91 925.05 1,676.86 1,389.29 976.29 1,272.35 534.14 184.02 869.83 1,570.59 1,660.13 2,835.90 1,555.14 1.03
Expenses 1,256.52 1,181.38 1,656.93 1,403.43 1,104.70 1,612.73 685.60 464.65 970.83 1,643.97 1,663.96 2,835.90 1,555.14 1.03
Operating Profit -93.61 -256.33 19.93 -14.14 -128.41 -340.38 -151.46 -280.63 -101.00 -73.38 -3.83 - - 0.97
Operating Profit % -8.05 -27.71 1.19 -1.02 -13.15 -26.75 -28.36 -152.50 -11.61 -4.67 -0.23 - - 0.94
Other Income 150.23 92.62 117.79 171.33 205.18 444.82 214.80 213.82 155.28 179.03 157.63 - - 1.02
Other Income % -160% -36% 591% -1212% -160% -131% -142% -76% -154% -244% -4116% #DIV/0! #DIV/0! 1.05
EBIDT 56.62 -163.71 137.72 157.19 76.77 104.44 63.34 -66.81 54.28 105.65 153.80 - - 1.07
EBIDT % 4.87 -17.70 8.21 11.31 7.86 8.21 11.86 -36.31 6.24 6.73 9.26 - - 1.04
Depreciation 31.20 30.81 37.07 40.90 43.22 42.32 32.09 22.51 22.02 18.65 17.82 17.82 17.82 0.94
Interest 1.24 0.43 0.70 0.90 1.19 0.72 - 0.36 1.04 0.90 1.20 1.20 1.20 0.97
Interest Coverage Ratio -75.49 -596.12 28.47 -15.71 -107.91 -472.75 #DIV/0! -779.53 -97.12 -81.53 -3.19 - - 1.01
Profit before tax 24.18 -194.95 99.95 115.40 32.35 61.40 31.26 -89.67 31.21 86.09 134.78 -19.02 -19.02 1.15
Profit before tax % 2.08 -21.07 5.96 8.31 3.31 4.83 5.85 -48.73 3.59 5.48 8.12 -0.67 -1.22 1.11
Tax 2.17 -17.68 23.68 21.09 1.29 21.46 0.45 -9.52 -16.70 4.61 15.91 12% 12% 1.09
Tax % 8.97 9.07 23.69 18.28 3.99 34.95 1.44 10.62 -53.51 5.35 11.80 -0.62 -0.62 0.94
Net profit 22.01 -177.27 76.27 94.30 31.05 39.94 30.82 -80.15 47.93 81.48 118.87 -16.77 -16.77 1.16
Net profit % 1.89 -19.16 4.55 6.79 3.18 3.14 5.77 -43.56 5.51 5.19 7.16 -0.59 -1.08 1.12
EPS 0.35 -2.79 1.20 1.49 0.49 0.63 0.49 -1.26 0.76 1.28 1.91 -0.27 -0.27 1.16
Price to earning 207.52 71.57 139.55 71.57 #VALUE!
Price - - - - - - - - - 266.49 136.80 -37.64 -19.31 #DIV/0!
#DIV/0!
RATIOS: #DIV/0!
Dividend Payout 28.85% 0.00% 20.79% 20.19% 20.45% 20.66% 20.60% 0.00% 48.99% 82.55% 1.12
OPM 0.00% 0.00% 1.19% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% #DIV/0!
Price/Sales 0.00%
TRENDS: 10 YEARS 7 YEARS 5 YEARS 3 YEARS RECENT BEST WORST
Sales Growth 3.40% -0.93% 9.98% 43.26% 80.56% 80.56% -0.93%
OPM 0.19% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Price to Earning 139.55 139.55 139.55 139.55 71.57 139.55 71.57
Sales 78% 538% 141% 63% 163% 98% 90%
Expenses 100% 359% 129% 70% 154% 94% 91%
Operating Profit 177% 82% 5% 2239% 81% 28% 140%
Net profit -81% 2% -42573% 13% 38% 552% 465%
KIOCL LTD SCREENER.IN
Narration Jun-16 Sep-16 Dec-16 Mar-17 Jun-17 Sep-17 Dec-17 Mar-18 Jun-18 Sep-18
Sales 73.69 57.74 310.62 438.52 277.69 451.37 442.81 398.72 393.18 425.42
Expenses 94.80 95.11 341.09 439.92 309.04 476.77 449.90 408.68 423.80 381.58
Operating Profit -21.11 -37.37 -30.47 -1.40 -31.35 -25.40 -7.09 -9.96 -30.62 43.84
Other Income 36.01 35.97 35.28 36.65 44.10 34.12 31.12 69.69 32.22 24.60
Depreciation 5.43 6.51 5.57 4.51 5.28 5.69 6.26 1.41 4.64 5.51
Interest - - - 0.32 - 0.07 - 0.43 0.43 0.34
Profit before tax 9.47 -7.91 -0.76 30.42 7.47 2.96 17.77 57.89 -3.47 62.59
Tax 3.09 -2.74 -0.65 -16.41 1.31 0.62 4.85 -2.17 0.16 13.07
Net profit 6.38 -5.17 -0.11 46.83 6.16 2.34 12.92 60.06 -3.63 49.52
OPM -29% -65% -10% 0% -11% -6% -2% -2% -8% 10%
KIOCL LTD SCREENER.IN
Narration Mar-09 Mar-10 Mar-11 Mar-12 Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18
Equity Share Capital 634.51 634.51 634.51 634.51 634.51 634.51 634.51 634.51 634.51 634.51
Reserves 1,483.50 1,306.23 1,364.00 1,436.11 1,459.73 1,490.02 1,503.96 1,427.90 1,467.05 1,511.12
Total Shareholder Funds 2,118.01 1,940.74 1,998.51 2,070.62 2,094.24 2,124.53 2,138.47 2,062.41 2,101.56 2,145.63
Borrowings - - - - - - 0.75 - - -
Other Liabilities 309.20 388.63 344.03 342.85 352.81 537.41 403.04 410.71 494.27 471.06
Total 2,427.21 2,329.37 2,342.54 2,413.47 2,447.05 2,661.94 2,542.26 2,473.12 2,595.83 2,616.69
Debt/Equity Ratio 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Current Ratio 6.21 4.53 5.11 5.16 5.43 3.89 5.25 5.02 4.36 4.56
Net Block 352.07 322.24 314.78 358.48 332.89 294.99 249.30 238.23 221.05 202.22
Capital Work in Progress 13.42 19.09 61.03 24.02 6.57 0.46 0.02 0.02 0.72 1.76
Investments - - - - - - - - - -
Other Assets 2,061.72 1,988.04 1,966.73 2,030.97 2,107.59 2,366.49 2,292.94 2,234.87 2,374.06 2,412.71
Total 2,427.21 2,329.37 2,342.54 2,413.47 2,447.05 2,661.94 2,542.26 2,473.12 2,595.83 2,616.69
Working Capital 1,752.52 1,599.41 1,622.70 1,688.12 1,754.78 1,829.08 1,889.90 1,824.16 1,879.79 1,941.65
Debtors 8.13 36.61 79.24 85.21 166.89 81.97 13.31 16.05 144.39 54.04
Inventory 710.75 328.59 235.85 220.24 332.99 291.36 339.77 89.52 163.17 232.76
Debtor Days 2.55 14.45 17.25 22.39 62.39 23.51 9.10 31.83 60.59 12.56
Inventory Turnover 1.64 2.82 7.11 6.31 2.93 4.37 1.57 2.06 5.33 6.75
Narration Mar-09 Mar-10 Mar-11 Mar-12 Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18
Cash from Operating Activity -185.44 133.72 36.73 -22.75 -177.80 -93.05 -88.40 -43.50 -261.26 -99.58 -801.33 0.93
Cash from Investing Activity 132.22 67.32 19.54 56.03 151.23 401.61 185.48 45.74 302.32 -12.88 1,348.61 -0.77
Cash from Financing Activity -25.33 -7.42 -5.93 -12.57 -22.20 -7.42 -9.65 -7.61 -8.44 -40.48 -147.05 1.05
Net Cash Flow -78.55 193.62 50.34 20.71 -48.77 301.14 87.44 -5.37 32.62 -152.93 400.25
Net profit 22.01 -177.27 76.27 94.3 31.05 39.94 30.82 -80.15 47.93 81.48 166.38 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
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.
TESTING:
This is a testing feature currently.
You can report any formula errors on the worksheet at: screener.feedback@dalal-street.in
… do ANYTHING.
dalal-street.in
COMPANY NAME KIOCL LTD
LATEST VERSION 2.10 PLEASE
CURRENT VERSION 2.10
META
Number of shares 62.19
Face Value 10
Current Price 136.8
Market Capitalization 8507.94
Quarters
Report Date Jun-16 Sep-16 Dec-16 Mar-17
Sales 73.69 57.74 310.62 438.52
Expenses 94.80 95.11 341.09 439.92
Other Income 36.01 35.97 35.28 36.65
Depreciation 5.43 6.51 5.57 4.51
Interest 0.32
Profit before tax 9.47 -7.91 -0.76 30.42
Tax 3.09 -2.74 -0.65 -16.41
Net profit 6.38 -5.17 -0.11 46.83
Operating Profit -21.11 -37.37 -30.47 -1.4
BALANCE SHEET
Report Date Mar-09 Mar-10 Mar-11 Mar-12
Equity Share Capital 634.51 634.51 634.51 634.51
Reserves 1483.5 1306.23 1364 1436.11
Borrowings
Other Liabilities 309.2 388.63 344.03 342.85
Total 2,427.21 2,329.37 2,342.54 2,413.47
Net Block 352.07 322.24 314.78 358.48
Capital Work in Progress 13.42 19.09 61.03 24.02
Investments
Other Assets 2061.72 1988.04 1966.73 2030.97
Total 2,427.21 2,329.37 2,342.54 2,413.47
Receivables 8.13 36.61 79.24 85.21
Inventory 710.75 328.59 235.85 220.24
Cash & Bank 1199.87 1393.48 1443.83 1464.54
No. of Equity Shares 634513800 634513800 634513800 634513800
New Bonus Shares
Face value 10 10 10 10
CASH FLOW:
Report Date Mar-09 Mar-10 Mar-11 Mar-12
Cash from Operating Activity -185.44 133.72 36.73 -22.75
Cash from Investing Activity 132.22 67.32 19.54 56.03
Cash from Financing Activity -25.33 -7.42 -5.93 -12.57
Net Cash Flow -78.55 193.62 50.34 20.71
PRICE:
DERIVED:
Adjusted Equity Shares in Cr 63.45 63.45 63.45 63.45
PLEASE DO NOT MAKE ANY CHANGES TO THIS SHEET
10 10 10 10 10 10
266.49