BOROSIL RENEWABLES 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 117.53 125.99 134.41 155.74 175.22 222.21 267.00 295.83 216.76 271.16 340.53 340.53 272.92
Expenses 131.66 126.64 131.18 150.62 176.31 213.46 247.96 256.42 182.35 234.25 287.71 287.71 252.69
Operating Profit -14.13 -0.65 3.23 5.12 -1.09 8.75 19.04 39.41 34.41 36.91 52.82 52.82 20.23
Other Income 816.17 42.01 25.13 40.76 70.35 12.75 125.86 36.36 30.10 3.14 12.21 - -
Depreciation 0.82 0.75 2.05 3.72 5.48 5.32 5.81 5.22 17.89 32.10 33.06 33.06 33.06
Interest 2.35 0.18 0.27 0.50 0.25 1.16 1.17 0.28 0.43 6.67 8.31 8.31 8.31
Profit before tax 798.87 40.43 26.04 41.66 63.53 15.02 137.92 70.27 46.19 1.28 23.66 11.45 -21.14
Tax 151.07 7.90 6.21 4.51 14.37 -0.55 11.22 23.89 -0.08 0.82 6.55 28% 28%
Net profit 647.80 32.53 19.84 37.15 49.16 15.57 126.69 46.37 46.27 0.45 17.10 8.28 -15.29
EPS 40.49 2.62 1.65 3.10 4.10 1.69 13.77 5.02 5.01 0.04 1.50 0.73 -1.34
Price to earning 0.11 2.03 2.49 1.90 2.59 10.35 2.94 10.70 10.87 944.49 50.56 254.16 50.56
Price 4.45 5.32 4.11 5.87 10.63 17.52 40.48 53.72 54.45 37.25 75.80 184.51 -67.78

RATIOS:
Dividend Payout 2.45% 14.48% 22.78% 16.20% 15.30% 37.12% 4.56% 12.46% 12.99% 0.00%
OPM 0.00% 0.00% 2.40% 3.29% 0.00% 3.94% 7.13% 13.32% 15.87% 13.61% 15.51%

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

Sales Growth 9.73% 10.55% 9.13% 0.52% 25.58% 25.58% 0.52%
OPM 7.41% 8.96% 10.88% 14.13% 15.51% 15.51% 7.41%
Price to Earning 94.46 129.30 171.65 254.16 50.56 254.16 50.56
BOROSIL RENEWABLES LTD SCREENER.IN

Narration Mar-18 Jun-18 Sep-18 Dec-18 Mar-19 Jun-19 Sep-19 Dec-19 Mar-20 Jun-20
Sales 87.50 72.12 86.97 113.59 62.13 43.82 117.02 75.18 94.26 54.07
Expenses 76.65 65.25 78.95 102.10 55.43 41.12 103.17 65.93 74.10 44.51
Operating Profit 10.85 6.87 8.02 11.49 6.70 2.70 13.85 9.25 20.16 9.56
Other Income 11.46 10.21 9.81 14.27 2.79 0.99 9.73 0.93 1.03 0.52
Depreciation 1.32 1.24 1.25 1.24 4.42 4.26 1.47 8.98 12.19 10.42
Interest 0.10 0.07 0.45 1.14 0.25 0.32 0.96 2.24 3.01 2.10
Profit before tax 20.89 15.77 16.13 23.38 4.82 -0.89 21.15 -1.04 5.99 -2.44
Tax 6.11 4.71 4.93 8.65 1.12 -0.32 5.37 -0.17 1.93 -0.58
Net profit 14.78 11.05 11.20 14.72 3.70 -0.56 15.79 -0.87 4.05 -1.87

OPM 12% 10% 9% 10% 11% 6% 12% 12% 21% 18%

BOROSIL RENEWABLES 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 3.96 3.14 3.01 3.01 3.01 2.31 2.31 2.31 9.24 11.41
Reserves 662.96 620.52 624.23 654.34 694.45 633.89 769.44 819.38 322.96 315.03
Borrowings - - 1.79 0.86 2.17 32.54 - - 42.41 92.29
Other Liabilities 29.54 35.51 29.84 32.79 50.09 36.69 40.86 65.44 50.60 80.99
Total 696.46 659.17 658.87 691.00 749.72 705.43 812.61 887.13 425.21 499.72

Net Block 8.43 34.11 80.35 172.73 156.43 158.14 108.82 107.78 116.81 344.74
Capital Work in Progress 3.02 47.40 14.25 6.04 5.61 5.11 4.61 4.13 125.20 0.96
Investments 495.58 424.85 409.09 380.24 444.81 379.99 454.43 508.78 45.70 7.04
Other Assets 189.43 152.81 155.18 131.99 142.87 162.19 244.75 266.44 137.50 146.98
Total 696.46 659.17 658.87 691.00 749.72 705.43 812.61 887.13 425.21 499.72

Working Capital 159.89 117.30 125.34 99.20 92.78 125.50 203.89 201.00 86.90 65.99
Debtors 25.72 24.96 28.66 29.10 31.63 37.12 44.17 69.78 24.07 40.63
Inventory 17.44 22.77 29.96 30.36 36.24 39.74 40.46 38.80 37.01 46.79

Debtor Days 79.88 72.31 77.83 68.20 65.89 60.97 60.38 86.10 40.53 54.69
Inventory Turnover 6.74 5.53 4.49 5.13 4.83 5.59 6.60 7.62 5.86 5.80

Return on Equity 97% 5% 3% 6% 7% 2% 16% 6% 14% 0%

Return on Capital Emp 6% 4% 7% 9% 2% 19% 9% 8% 2%
BOROSIL RENEWABLES 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 -157.92 -4.59 -1.47 0.79 3.51 6.19 25.34 29.91 -49.02 26.20
Cash from Investing Activity 217.24 86.08 15.96 6.23 1.53 157.08 6.47 -17.07 -48.50 -60.72
Cash from Financing Activity -58.32 -79.18 -14.13 -7.54 -4.82 -161.95 -33.55 -7.16 88.22 35.09
Net Cash Flow 1.00 2.31 0.36 -0.52 0.22 1.32 -1.74 5.68 -9.31 0.57
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 BOROSIL RENEWABLES LTD
LATEST VERSION 2.10 PLEAS
CURRENT VERSION 2.10

META
Number of shares 11.41
Face Value 1.00
Current Price 75.80
Market Capitalization 864.57

PROFIT & LOSS

Report Date Mar-11 Mar-12 Mar-13 Mar-14
Sales 117.53 125.99 134.41 155.74
Raw Material Cost 71.73 77.80 81.91 90.59
Change in Inventory 0.37 6.26 7.14 0.34
Power and Fuel
Other Mfr. Exp 4.20 5.29 5.50 4.58
Employee Cost 11.49 13.12 14.91 17.70
Selling and admin 16.67 26.40 31.89 29.47
Other Expenses 27.94 10.29 4.11 8.62
Other Income 816.17 42.01 25.13 40.76
Depreciation 0.82 0.75 2.05 3.72
Interest 2.35 0.18 0.27 0.50
Profit before tax 798.87 40.43 26.04 41.66
Tax 151.07 7.90 6.21 4.51
Net profit 647.80 32.53 19.84 37.15
Dividend Amount 15.84 4.71 4.52 6.02

Quarters
Report Date Mar-18 Jun-18 Sep-18 Dec-18
Sales 87.50 72.12 86.97 113.59
Expenses 76.65 65.25 78.95 102.10
Other Income 11.46 10.21 9.81 14.27
Depreciation 1.32 1.24 1.25 1.24
Interest 0.10 0.07 0.45 1.14
Profit before tax 20.89 15.77 16.13 23.38
Tax 6.11 4.71 4.93 8.65
Net profit 14.78 11.05 11.20 14.72
Operating Profit 10.85 6.87 8.02 11.49

BALANCE SHEET
Report Date Mar-11 Mar-12 Mar-13 Mar-14
Equity Share Capital 3.96 3.14 3.01 3.01
Reserves 662.96 620.52 624.23 654.34
Borrowings 1.79 0.86
Other Liabilities 29.54 35.51 29.84 32.79
Total 696.46 659.17 658.87 691.00
Net Block 8.43 34.11 80.35 172.73
Capital Work in Progress 3.02 47.40 14.25 6.04
Investments 495.58 424.85 409.09 380.24
Other Assets 189.43 152.81 155.18 131.99
Total 696.46 659.17 658.87 691.00
Receivables 25.72 24.96 28.66 29.10
Inventory 17.44 22.77 29.96 30.36
Cash & Bank 10.04 8.84 7.51 4.98
No. of Equity Shares 3,963,928.00 3,135,351.00 3,006,000.00 3,006,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 -157.92 -4.59 -1.47 0.79
Cash from Investing Activity 217.24 86.08 15.96 6.23
Cash from Financing Activity -58.32 -79.18 -14.13 -7.54
Net Cash Flow 1.00 2.31 0.36 -0.52

PRICE: 4.45 5.32 4.11 5.87

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

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

175.22 222.21 267.00 295.83 216.76 271.16
106.43 129.99 144.59 148.34 64.37 72.56
5.21 3.64 0.64 -0.60 8.56 -11.67
41.26 55.46
4.80 6.62 8.18 11.43 27.32 32.41
20.63 25.10 27.64 32.65 27.50 27.50
35.60 47.62 51.16 55.90 25.67 29.33
14.06 7.77 17.03 7.50 4.79 5.32
70.35 12.75 125.86 36.36 30.10 3.14
5.48 5.32 5.81 5.22 17.89 32.10
0.25 1.16 1.17 0.28 0.43 6.67
63.53 15.02 137.92 70.27 46.19 1.28
14.37 -0.55 11.22 23.89 -0.08 0.82
49.16 15.57 126.69 46.37 46.27 0.45
7.52 5.78 5.78 5.78 6.01

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

62.13 43.82 117.02 75.18 94.26 54.07
55.43 41.12 103.17 65.93 74.10 44.51
2.79 0.99 9.73 0.93 1.03 0.52
4.42 4.26 1.47 8.98 12.19 10.42
0.25 0.32 0.96 2.24 3.01 2.10
4.82 -0.89 21.15 -1.04 5.99 -2.44
1.12 -0.32 5.37 -0.17 1.93 -0.58
3.70 -0.56 15.79 -0.87 4.05 -1.87
6.70 2.70 13.85 9.25 20.16 9.56

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

3.01 2.31 2.31 2.31 9.24 11.41
694.45 633.89 769.44 819.38 322.96 315.03
2.17 32.54 42.41 92.29
50.09 36.69 40.86 65.44 50.60 80.99
749.72 705.43 812.61 887.13 425.21 499.72
156.43 158.14 108.82 107.78 116.81 344.74
5.61 5.11 4.61 4.13 125.20 0.96
444.81 379.99 454.43 508.78 45.70 7.04
142.87 162.19 244.75 266.44 137.50 146.98
749.72 705.43 812.61 887.13 425.21 499.72
31.63 37.12 44.17 69.78 24.07 40.63
36.24 39.74 40.46 38.80 37.01 46.79
5.33 6.93 4.49 10.06 4.84 4.35
3,006,000.00 2,310,000.00 2,310,000.00 23,100,000.00 92,400,000.00 ###

10.00 10.00 10.00 1.00 1.00 1.00

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

3.51 6.19 25.34 29.91 -49.02 26.20
1.53 157.08 6.47 -17.07 -48.50 -60.72
-4.82 -161.95 -33.55 -7.16 88.22 35.09
0.22 1.32 -1.74 5.68 -9.31 0.57

10.63 17.52 40.48 53.72 54.45 37.25

12.00 9.20 9.20 9.24 9.24 11.41