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 97% 136% 108% 109% 103% 110% 100% 94% 103%
Operating Profit 50% 234% 133% 90% 115% 101% 97% 82% 114%
Net profit 39% -8% -2339% 34% 256% 59% 208% 79% 174%
EIH 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 967.86 845.08 1,251.99 1,407.18 1,468.75 1,547.12 1,668.77 1,660.93 1,528.65 1,598.84 - 1,672.25 1,598.84 1.06
Expenses 766.20 743.80 1,015.15 1,091.37 1,185.21 1,220.11 1,337.57 1,339.06 1,265.26 1,298.44 - 1,362.96 1,598.84 1.06
Operating Profit 201.66 101.28 236.84 315.81 283.54 327.01 331.20 321.87 263.39 300.40 - 309.30 - 1.05
Operating Profit % 20.84 11.98 18.92 22.44 19.30 21.14 19.85 19.38 17.23 18.79 #DIV/0! 18.50 - 0.99
Other Income 245.01 202.16 67.43 53.19 3.23 43.09 27.85 64.14 60.87 121.38 - - - 0.92
Other Income % 121% 200% 28% 17% 1% 13% 8% 20% 23% 40% #DIV/0! 0% #DIV/0! 0.88
EBIDT 446.67 303.44 304.27 369.00 286.77 370.10 359.05 386.01 324.26 421.78 - 309.30 - 0.99
EBIDT % 46.15 35.91 24.30 26.22 19.52 23.92 21.52 23.24 21.21 26.38 #DIV/0! 18.50 - 0.94
Depreciation 74.91 87.76 116.56 129.76 141.14 134.92 167.81 133.37 128.11 117.33 - - - 1.05
Interest 95.29 110.31 169.08 70.42 71.65 52.71 46.18 28.37 17.85 23.11 - - - 0.85
Interest Coverage Ratio 2.12 0.92 1.40 4.48 3.96 6.20 7.17 11.35 14.76 13.00 #DIV/0! #DIV/0! #DIV/0! 1.22
Profit before tax 276.47 105.37 18.63 168.82 73.99 182.48 145.05 224.28 178.30 281.34 - 309.30 - 1.00
Profit before tax % 28.57 12.47 1.49 12.00 5.04 11.79 8.69 13.50 11.66 17.60 #DIV/0! 18.50 - 0.95
Tax 106.97 34.38 31.38 48.04 27.05 71.47 78.03 81.28 60.00 85.53 - 0% 0% 0.98
Tax % 38.69 32.63 168.44 28.46 36.56 39.17 53.80 36.24 33.65 30.40 #DIV/0! - #DIV/0! 0.97
Net profit 169.96 66.31 -5.23 122.31 41.77 107.12 63.10 131.07 103.11 179.20 - 309.30 - 1.01
Net profit % 17.56 7.85 -0.42 8.69 2.84 6.92 3.78 7.89 6.75 11.21 #DIV/0! 18.50 - 0.95
EPS 4.33 1.69 -0.09 2.14 0.73 1.87 1.10 2.29 1.80 3.14 - 5.41 - 0.96
Price to earning 22.92 66.97 -952.23 39.53 78.15 40.00 97.59 46.08 70.03 56.20 - 57.44 - 1.10
Price 99.12 113.02 87.13 84.60 57.12 74.96 107.74 105.68 126.33 176.19 181.30 310.83 - 1.07
#DIV/0!
RATIOS: #DIV/0!
Dividend Payout 27.74% 71.11% 0.00% 54.78% 142.90% 67.54% 99.64% 47.97% 49.89% 28.71% 1.00
OPM 20.84% 11.98% 18.92% 22.44% 19.30% 21.14% 19.85% 19.38% 17.23% 18.79% 0.00% 0.99
Price/Sales 10.24%
TRENDS: 10 YEARS 7 YEARS 5 YEARS 3 YEARS RECENT BEST WORST
Sales Growth 5.74% 3.56% 1.71% -1.42% 4.59% 4.59% -1.42%
OPM 19.24% 19.70% 19.29% 18.50% 0.00% 18.50% 0.00%
Price to Earning 57.50 61.08 61.98 57.44 - 57.44 -
Sales #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Expenses #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Operating Profit #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Net profit #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
EIH 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 - - - - - - - - - -
Expenses - - - - - - - - - -
Operating Profit - - - - - - - - - -
Other Income - - - - - - - - - -
Depreciation - - - - - - - - - -
Interest - - - - - - - - - -
Profit before tax - - - - - - - - - -
Tax - - - - - - - - - -
Net profit - - - - - - - - - -
OPM
EIH 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 78.59 78.59 114.31 114.31 114.31 114.31 114.31 114.31 114.31 114.31
Reserves 1,095.65 1,080.91 2,199.36 2,248.21 2,254.77 2,277.64 2,274.56 2,397.60 2,457.68 2,768.48
Total Shareholder Funds 1,174.24 1,159.50 2,313.67 2,362.52 2,369.08 2,391.95 2,388.87 2,511.91 2,571.99 2,882.79
Borrowings 1,144.53 1,435.65 1,080.43 558.35 743.96 451.75 418.11 318.19 358.93 501.91
Other Liabilities 744.65 725.44 814.05 822.75 866.66 905.05 955.10 815.62 788.92 725.83
Total 3,063.42 3,320.59 4,208.15 3,743.62 3,979.70 3,748.75 3,762.08 3,645.72 3,719.84 4,110.53
Debt/Equity Ratio 0.97 1.24 0.47 0.24 0.31 0.19 0.18 0.13 0.14 0.17
Current Ratio 0.29 0.30 1.08 0.41 0.47 0.46 0.49 0.51 0.49 0.62
Net Block 1,604.63 2,205.95 2,720.38 2,677.63 2,802.28 2,710.67 2,615.08 2,230.20 2,092.26 2,547.68
Capital Work in Progress 617.12 309.57 204.13 316.15 229.98 50.04 92.52 115.37 321.25 147.60
Investments 265.88 241.13 116.42 135.02 201.61 246.54 254.08 301.03 287.64 326.65
Other Assets 575.79 563.94 1,167.22 614.82 745.83 741.50 800.40 999.12 1,018.69 1,088.60
Total 3,063.42 3,320.59 4,208.15 3,743.62 3,979.70 3,748.75 3,762.08 3,645.72 3,719.84 4,110.53
Working Capital -168.86 -161.50 353.17 -207.93 -120.83 -163.55 -154.70 183.50 229.77 362.77
Debtors 106.20 115.92 150.12 169.12 205.40 202.09 223.12 201.30 181.09 223.79
Inventory 34.49 33.72 44.60 43.55 45.02 50.30 48.51 49.71 49.57 51.07
Debtor Days 40.05 50.07 43.77 43.87 51.04 47.68 48.80 44.24 43.24 51.09
Inventory Turnover 28.06 25.06 28.07 32.31 32.62 30.76 34.40 33.41 30.84 31.31
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 228.58 78.42 362.34 277.79 207.23 298.65 321.14 231.27 243.28 271.76 2,520.46 1.02
Cash from Investing Activity -330.03 -336.83 -324.10 -180.14 -241.49 -97.48 -154.39 -58.02 -268.65 -317.87 -2,309.00 1.00
Cash from Financing Activity 134.23 244.54 559.85 -665.94 56.46 -196.27 -151.17 -193.43 -4.20 45.20 -170.73 0.89
Net Cash Flow 32.78 -13.87 598.09 -568.29 22.20 4.90 15.58 -20.18 -29.58 -0.91 40.72
Net profit 169.96 66.31 -5.23 122.31 41.77 107.12 63.1 131.07 103.11 179.2 978.72 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 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 EIH LTD
LATEST VERSION 2.10 PLEASE
CURRENT VERSION 2.10
META
Number of shares 57.15
Face Value 2
Current Price 181.3
Market Capitalization 10362.2
Quarters
Report Date Jun-16 Sep-16 Dec-16 Mar-17
Sales
Expenses
Other Income
Depreciation
Interest
Profit before tax
Tax
Net profit
Operating Profit
BALANCE SHEET
Report Date Mar-09 Mar-10 Mar-11 Mar-12
Equity Share Capital 78.59 78.59 114.31 114.31
Reserves 1095.65 1080.91 2199.36 2248.21
Borrowings 1144.53 1435.65 1080.43 558.35
Other Liabilities 744.65 725.44 814.05 822.75
Total 3,063.42 3,320.59 4,208.15 3,743.62
Net Block 1604.63 2205.95 2720.38 2677.63
Capital Work in Progress 617.12 309.57 204.13 316.15
Investments 265.88 241.13 116.42 135.02
Other Assets 575.79 563.94 1167.22 614.82
Total 3,063.42 3,320.59 4,208.15 3,743.62
Receivables 106.20 115.92 150.12 169.12
Inventory 34.49 33.72 44.6 43.55
Cash & Bank 78.74 64.87 685.4 125.21
No. of Equity Shares 392953972 392953972 571569414 571569414
New Bonus Shares
Face value 2 2 2 2
CASH FLOW:
Report Date Mar-09 Mar-10 Mar-11 Mar-12
Cash from Operating Activity 228.58 78.42 362.34 277.79
Cash from Investing Activity -330.03 -336.83 -324.10 -180.14
Cash from Financing Activity 134.23 244.54 559.85 -665.94
Net Cash Flow 32.78 -13.87 598.09 -568.29
DERIVED:
Adjusted Equity Shares in Cr 39.30 39.30 57.16 57.16
PLEASE DO NOT MAKE ANY CHANGES TO THIS SHEET
2 2 2 2 2 2