MANORAMA INDUSTRIES LTD SCREENER.

IN

Narration Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24 Trailing Best Case Worst Case
Sales 133.36 131.33 145.48 210.29 102.40 188.24 202.63 279.12 350.80 457.08 667.36 667.36 554.97
Expenses 129.07 127.33 142.71 193.45 73.40 144.39 167.97 240.10 294.35 383.56 519.45 519.45 478.20
Operating Profit 4.29 4.00 2.77 16.84 29.00 43.85 34.66 39.02 56.45 73.52 147.91 147.91 76.76
Other Income 0.92 0.63 0.90 1.54 2.92 5.95 6.15 8.16 6.12 13.15 13.29 - -
Depreciation 0.58 0.78 0.82 0.71 0.81 7.66 7.96 7.89 10.85 13.61 19.49 19.49 19.49
Interest 2.99 2.05 0.80 1.75 4.55 9.77 10.49 5.77 8.66 19.89 34.10 34.10 34.10
Profit before tax 1.64 1.80 2.05 15.92 26.56 32.37 22.36 33.52 43.06 53.17 107.61 94.32 23.17
Tax 0.56 0.64 0.68 6.00 7.50 9.03 7.78 9.36 13.29 13.07 25.33 24% 24%
Net profit 1.08 1.17 1.38 9.93 19.06 23.34 14.58 24.15 29.78 40.11 82.28 72.12 17.72
EPS 1.23 1.08 1.28 2.63 3.43 4.20 2.62 4.05 5.00 6.73 13.84 12.13 2.98
Price to earning 11.52 14.53 61.70 57.42 41.12 59.19 73.85 73.85 45.62
Price - - - - 39.50 61.00 161.80 232.66 205.44 398.35 1,022.00 895.78 135.95

RATIOS:
Dividend Payout 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 7.99% 5.93%
OPM 3.22% 3.05% 1.90% 8.01% 28.32% 23.29% 17.11% 13.98% 16.09% 16.08% 22.16%

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

Sales Growth 14.67% 17.77% 34.88% 31.15% 46.01% 46.01% 14.67%
OPM 13.83% 16.38% 16.75% 15.55% 22.16% 22.16% 13.83%
Price to Earning 45.62 45.62 51.30 57.89 73.85 73.85 45.62

2020
NI / AVG EQ ROE
ROE 40.11 12.6269065496
317.66

ROE 2 NI / ATA ATA / AVG EQ NI / ATA ATA / AVG EQ

40.11 580.54 0.069090846453 1.83 12.63
580.54 317.66

ROE 3 NI / REV REV / ATA ATA / AVG EQ NI / REV REV / ATA ATA / AVG EQ
40.11 457.08 580.54 0.087752690995 0.78733592862 1.82758023642 12.6269065496
457.08 580.54 317.66

ROE 4 NI / EBT EBT / EBIT EBIT / REV REV / ATA ATA / AVG EQ NI / EBT EBT / EBIT EBIT / REV REV /ATA 12.6269065496
40.11 53.17 73.06 457.08 580.54 0.754372766598 0.72775800712 0.1598407281 0.78733592862
53.17 73.06 457.08 580.54 317.66 ATA / AVG EQ
1.82758023642

2019
NI / AVG EQ ROE
ROE 29.78 10.5125670714
283.28

ROE 2 NI / ATA ATA / AVG EQ NI / ATA ATA / AVG EQ

29.78 410.11 0.072615549676 1.45 10.51
410.11 283.28

ROE 3 NI / REV REV / ATA ATA / AVG EQ NI / REV REV / ATA ATA / AVG EQ
29.78 350.80 410.11 0.084891676169 0.85539069263 1.44770192036 10.5125670714
350.80 410.11 283.28

ROE 4 NI / EBT EBT / EBIT EBIT / REV REV / ATA ATA / AVG EQ NI / EBT EBT / EBIT EBIT / REV REV /ATA 10.5125670714
29.78 43.06 51.72 350.80 410.11 0.691593125871 0.83255993813 0.14743443558 0.85539069263
43.06 51.72 350.80 410.11 283.28 ATA / AVG EQ
1.44770192036

2018
NI / AVG EQ ROE
ROE 24.15 11.695198431
206.49

ROE 2 NI / ATA ATA / AVG EQ NI / ATA ATA / AVG EQ

24.15 324.84 0.074345436914 1.57 11.70
324.84 206.49

ROE 3 NI / REV REV / ATA ATA / AVG EQ NI / REV REV / ATA ATA / AVG EQ
24.15 279.12 324.84 0.086521926053 0.85926701248 1.57308893678 11.695198431
279.12 324.84 206.49

ROE 4 NI / EBT EBT / EBIT EBIT / REV REV / ATA ATA / AVG EQ NI / EBT EBT / EBIT EBIT / REV REV /ATA 11.695198431
24.15 33.52 39.29 279.12 324.84 0.720465393795 0.85314329346 0.14076382918 0.85926701248
33.52 39.29 279.12 324.84 206.49 ATA / AVG EQ
1.57308893678

2017
NI / AVG EQ ROE
ROE 14.58 10.7209823891
136.00

ROE 2 NI / ATA ATA / AVG EQ NI / ATA ATA / AVG EQ

14.58 271.34 0.053734313671 2.00 10.72
271.34 136.00

ROE 3 NI / REV REV / ATA ATA / AVG EQ NI / REV REV / ATA ATA / AVG EQ
14.58 202.63 271.34 0.071953807432 0.74678902464 1.99518364646 10.7209823891
202.63 271.34 136.00

ROE 4 NI / EBT EBT / EBIT EBIT / REV REV / ATA ATA / AVG EQ NI / EBT EBT / EBIT EBIT / REV REV /ATA 10.7209823891
14.58 22.36 32.85 202.63 271.34 0.652057245081 0.68066971081 0.16211814638 0.74678902464
22.36 32.85 202.63 271.34 136.00 ATA / AVG EQ
1.99518364646

2016
NI / AVG EQ ROE
ROE 23.34 20.1911847398
115.60

ROE 2 NI / ATA ATA / AVG EQ NI / ATA ATA / AVG EQ

23.34 211.14 0.110542767832 1.83 20.19
211.14 115.60

ROE 3 NI / REV REV / ATA ATA / AVG EQ NI / REV REV / ATA ATA / AVG EQ
23.34 188.24 211.14 0.123990650234 0.89154115753 1.82654959125 20.1911847398
188.24 211.14 115.60

ROE 4 NI / EBT EBT / EBIT EBIT / REV REV / ATA ATA / AVG EQ NI / EBT EBT / EBIT EBIT / REV REV /ATA 20.1911847398
23.34 32.37 42.14 188.24 211.14 0.721037998146 0.76815377314 0.22386315342 0.89154115753
32.37 42.14 188.24 211.14 115.60 ATA / AVG EQ
1.82654959125

2015
NI / AVG EQ ROE
ROE 19.06 29.72551466
64.12

ROE 2 NI / ATA ATA / AVG EQ NI / ATA ATA / AVG EQ

19.06 89.44 0.213115670599 1.39 29.73
89.44 64.12

ROE 3 NI / REV REV / ATA ATA / AVG EQ NI / REV REV / ATA ATA / AVG EQ
19.06 102.40 89.44 0.1861328125 1.14496561749 1.3948066126 29.72551466
102.40 89.44 64.12

ROE 4 NI / EBT EBT / EBIT EBIT / REV REV / ATA ATA / AVG EQ NI / EBT EBT / EBIT EBIT / REV REV /ATA 29.72551466
19.06 26.56 31.11 102.40 89.44 0.717620481928 0.8537447766 0.30380859375 1.14496561749
26.56 31.11 102.40 89.44 64.12 ATA / AVG EQ
1.3948066126

2014
NI / AVG EQ ROE
ROE 9.93 51.3443640124
19.34

ROE 2 NI / ATA ATA / AVG EQ NI / ATA ATA / AVG EQ

9.93 34.00 0.292101779673 1.76 51.34
34.00 19.34

ROE 3 NI / REV REV / ATA ATA / AVG EQ NI / REV REV / ATA ATA / AVG EQ
9.93 210.29 34.00 0.047220505017 6.1859096926 1.75775594623 51.3443640124
210.29 34.00 19.34

ROE 4 NI / EBT EBT / EBIT EBIT / REV REV / ATA ATA / AVG EQ NI / EBT EBT / EBIT EBIT / REV REV /ATA 51.3443640124
9.93 15.92 17.67 210.29 34.00 0.623743718593 0.90096208263 0.08402682011 6.1859096926
15.92 17.67 210.29 34.00 19.34 ATA / AVG EQ
1.75775594623

2013
NI / AVG EQ ROE
ROE 1.38 9.91379310345
13.92

ROE 2 NI / ATA ATA / AVG EQ NI / ATA ATA / AVG EQ

1.38 21.90 0.06301369863 1.57 9.91
21.90 13.92

ROE 3 NI / REV REV / ATA ATA / AVG EQ NI / REV REV / ATA ATA / AVG EQ
1.38 145.48 21.90 0.009485839978 6.64292237443 1.57327586207 9.91379310345
145.48 21.90 13.92

ROE 4 NI / EBT EBT / EBIT EBIT / REV REV / ATA ATA / AVG EQ NI / EBT EBT / EBIT EBIT / REV REV /ATA 9.91379310345
1.38 2.05 2.85 145.48 21.90 0.673170731707 0.71929824561 0.01959032169 6.64292237443
2.05 2.85 145.48 21.90 13.92 ATA / AVG EQ
1.57327586207

2012
NI / AVG EQ ROE
ROE 1.17 9.95744680851
11.75

ROE 2 NI / ATA ATA / AVG EQ NI / ATA ATA / AVG EQ

1.17 19.33 0.060527677186 1.65 9.96
19.33 11.75

ROE 3 NI / REV REV / ATA ATA / AVG EQ NI / REV REV / ATA ATA / AVG EQ
1.17 131.33 19.33 0.008908855555 6.79410243145 1.64510638298 9.95744680851
131.33 19.33 11.75

ROE 4 NI / EBT EBT / EBIT EBIT / REV REV / ATA ATA / AVG EQ NI / EBT EBT / EBIT EBIT / REV REV /ATA 9.95744680851
1.17 1.80 3.85 131.33 19.33 0.65 0.46753246753 0.02931546486 6.79410243145
1.80 3.85 131.33 19.33 11.75 ATA / AVG EQ
1.64510638298
MA INDUSTRIES LTD
2011 2012 2013 2014 2015
Net Profit 1.08 1.17 1.38 9.93 19.06
Net Sales 133.36 131.33 145.48 210.29 102.4
Total Assets 17.47 21.19 22.61 45.38 133.49
Equity 10.03 13.47 14.37 24.31 103.93
EPS 1.23 1.08 1.28 2.63 3.43
Share Issued (Cr) 0.17587 0.21571 0.21571 0.75497 1.11279

ROE = NP/NS * NS/TA * TA/EQ

2012 9.96% 0.89% 6.794 1.645
2013 9.91% 0.95% 6.643 1.573
2014 51.34% 4.72% 6.186 1.758
2015 29.73% 18.61% 1.145 1.395
2016 20.19% 12.40% 0.892 1.827 As on - 22/12/2020
2017 10.72% 7.20% 0.747 1.995 CMP
2018 11.70% 8.65% 0.859 1.573 1,022.00
2019 10.51% 8.49% 0.855 1.448
2020 12.63% 8.78% 0.787 1.828 P/E (TTM)
5yrAvg 13.15% 9.10% 0.83 1.73 73.85
9yrAvg 18.52% 7.85% 2.77 1.67
 Mar
2016 2017 2018 2019 2020
23.34 14.58 24.15 29.78 40.11
188.24 202.63 279.12 350.8 457.08
288.79 253.88 395.79 424.42 736.66
127.26 144.73 268.26 298.30 337.01
4.20 2.62 4.05 5.00 6.73
1.11279 1.11279 1.19198 1.19198 5.95991

As on - 22/12/2020
BV Div Pay% EPS (TTM) FV Mkt Cap (Cr)
56.55 0.05933682373 13.84 2 6,075.99

P/B P/S Div Yld (%) Ear Yld (%)

18.07 13.3259 - 1.35%
CAGR Growth
5yr 9yr
16.04% 49.43%
34.88% 14.67%
40.72% 51.55%
26.53% 47.77%
14.44% 20.81%
39.88% 47.91%
MANORAMA INDUSTRIES LTD SCREENER.IN

Narration Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24
Equity Share Capital 1.76 2.16 2.16 7.55 11.13 11.13 11.13 11.92 11.92 11.92
Reserves 8.27 11.31 12.21 16.76 92.80 116.13 133.60 256.34 286.38 325.09
Borrowings 4.00 4.92 0.11 17.95 24.45 119.35 85.35 108.44 110.02 346.38
Other Liabilities 3.44 2.80 8.13 3.12 5.11 42.18 23.80 19.09 16.10 53.27
Total 17.47 21.19 22.61 45.38 133.49 288.79 253.88 395.79 424.42 736.66

Net Block 3.13 3.16 2.51 3.26 6.33 51.38 56.60 55.32 96.63 129.33
Capital Work in Progress - 0.11 - 0.69 15.51 - - 41.58 50.17 41.91
Investments 0.01 0.01 0.01 - - - - - - -
Other Assets 14.33 17.91 20.09 41.43 111.65 237.41 197.28 298.89 277.62 565.42
Total 17.47 21.19 22.61 45.38 133.49 288.79 253.88 395.79 424.42 736.66

Working Capital 10.89 15.11 11.96 38.31 106.54 195.23 173.48 279.80 261.52 512.15
Debtors 1.05 0.44 1.07 1.64 14.16 16.26 22.36 25.09 27.58 41.82
Inventory 2.86 5.51 1.90 18.03 37.00 150.06 123.24 181.07 157.69 389.23

Debtor Days 2.87 1.22 2.68 2.85 50.47 31.53 40.28 32.81 28.70 33.40
Inventory Turnover 46.63 23.83 76.57 11.66 2.77 1.25 1.64 1.54 2.22 1.17

Return on Equity 11% 9% 10% 41% 18% 18% 10% 9% 10% 12%
Return on Capital Emp 24% 17% 62% 36% 22% 14% 13% 13% 13%
MANORAMA INDUSTRIES LTD SCREENER.IN

Narration Sep-22 Dec-22 Mar-23 Jun-23 Sep-23 Dec-23 Mar-24 Jun-24 Sep-24 Dec-24
Sales 80.71 95.38 101.74 111.56 117.73 98.45 129.33 133.41 195.42 209.20
Expenses 68.57 80.17 85.26 92.92 99.24 82.84 108.56 106.65 150.21 154.03
Operating Profit 12.14 15.21 16.48 18.64 18.49 15.61 20.77 26.76 45.21 55.17
Other Income 0.95 1.22 3.30 3.19 2.10 4.09 3.78 4.09 3.48 1.94
Depreciation 2.63 3.13 3.24 2.99 3.28 3.58 3.77 4.12 5.61 5.99
Interest 2.07 2.34 2.41 2.38 5.10 5.53 6.88 8.50 7.78 10.94
Profit before tax 8.39 10.96 14.13 16.46 12.21 10.59 13.90 18.23 35.30 40.18
Tax 2.54 3.80 4.14 4.91 3.61 3.14 1.39 4.69 8.59 10.66
Net profit 5.85 7.16 10.00 11.55 8.61 7.44 12.50 13.54 26.71 29.53

OPM 15% 16% 16% 17% 16% 16% 16% 20% 23% 26%
MANORAMA INDUSTRIES LTD SCREENER.IN

Narration Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24
Cash from Operating Activity - 2.14 - -11.28 -10.95 -60.08 33.49 -33.36 59.28 -153.50
Cash from Investing Activity - 1.94 - -0.85 -49.81 -9.99 10.88 -34.54 -99.47 -62.09
Cash from Financing Activity - -0.83 - 15.51 62.50 85.27 -44.57 116.69 -7.12 214.12
Net Cash Flow - 3.25 - 3.39 1.74 15.19 -0.20 48.79 -47.31 -1.47
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 MANORAMA INDUSTRIES LTD
LATEST VERSION 2.10 PLEAS
CURRENT VERSION 2.10

META
Number of shares 5.95
Face Value 2.00
Current Price 1,022.00
Market Capitalization 6,075.99

PROFIT & LOSS

Report Date Mar-15 Mar-16 Mar-17 Mar-18
Sales 133.36 131.33 145.48 210.29
Raw Material Cost 102.96 111.05 121.01 192.31
Change in Inventory -3.61 15.67
Power and Fuel 0.17 0.49 0.39 0.36
Other Mfr. Exp 7.18 2.54
Employee Cost 1.80 2.45 2.98 2.99
Selling and admin 9.18 8.52 7.54 7.65
Other Expenses 14.96 4.82 3.27
Other Income 0.92 0.63 0.90 1.54
Depreciation 0.58 0.78 0.82 0.71
Interest 2.99 2.05 0.80 1.75
Profit before tax 1.64 1.80 2.05 15.92
Tax 0.56 0.64 0.68 6.00
Net profit 1.08 1.17 1.38 9.93
Dividend Amount

Quarters
Report Date Sep-22 Dec-22 Mar-23 Jun-23
Sales 80.71 95.38 101.74 111.56
Expenses 68.57 80.17 85.26 92.92
Other Income 0.95 1.22 3.30 3.19
Depreciation 2.63 3.13 3.24 2.99
Interest 2.07 2.34 2.41 2.38
Profit before tax 8.39 10.96 14.13 16.46
Tax 2.54 3.80 4.14 4.91
Net profit 5.85 7.16 10.00 11.55
Operating Profit 12.14 15.21 16.48 18.64

BALANCE SHEET
Report Date Mar-15 Mar-16 Mar-17 Mar-18
Equity Share Capital 1.76 2.16 2.16 7.55
Reserves 8.27 11.31 12.21 16.76
Borrowings 4.00 4.92 0.11 17.95
Other Liabilities 3.44 2.80 8.13 3.12
Total 17.47 21.19 22.61 45.38
Net Block 3.13 3.16 2.51 3.26
Capital Work in Progress 0.11 0.69
Investments 0.01 0.01 0.01
Other Assets 14.33 17.91 20.09 41.43
Total 17.47 21.19 22.61 45.38
Receivables 1.05 0.44 1.07 1.64
Inventory 2.86 5.51 1.90 18.03
Cash & Bank 6.93 10.18 15.74 19.12
No. of Equity Shares 1,758,726.00 2,157,066.00 2,157,066.00 7,549,731.00
New Bonus Shares
Face value 10.00 10.00 10.00 10.00

CASH FLOW:
Report Date Mar-15 Mar-16 Mar-17 Mar-18
Cash from Operating Activity 2.14 -11.28
Cash from Investing Activity 1.94 -0.85
Cash from Financing Activity -0.83 15.51
Net Cash Flow 3.25 3.39

PRICE:

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

Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24

102.40 188.24 202.63 279.12 350.80 457.08
68.78 139.67 91.10 149.03 193.84 323.08
19.24 57.78 -23.80 25.44 -17.54 80.59
0.41 4.29 9.47 11.15 16.26 19.89
8.65 26.51 15.50 60.54 18.59 42.59
3.50 6.91 7.52 9.64 12.82 19.53
10.37 23.88 19.12 33.67 33.29 55.86
0.93 0.91 1.46 1.51 2.01 3.20
2.92 5.95 6.15 8.16 6.12 13.15
0.81 7.66 7.96 7.89 10.85 13.61
4.55 9.77 10.49 5.77 8.66 19.89
26.56 32.37 22.36 33.52 43.06 53.17
7.50 9.03 7.78 9.36 13.29 13.07
19.06 23.34 14.58 24.15 29.78 40.11
2.38 2.38

Sep-23 Dec-23 Mar-24 Jun-24 Sep-24 Dec-24

117.73 98.45 129.33 133.41 195.42 209.20
99.24 82.84 108.56 106.65 150.21 154.03
2.10 4.09 3.78 4.09 3.48 1.94
3.28 3.58 3.77 4.12 5.61 5.99
5.10 5.53 6.88 8.50 7.78 10.94
12.21 10.59 13.90 18.23 35.30 40.18
3.61 3.14 1.39 4.69 8.59 10.66
 8.61 7.44 12.50 13.54 26.71 29.53
18.49 15.61 20.77 26.76 45.21 55.17

Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24

11.13 11.13 11.13 11.92 11.92 11.92
92.80 116.13 133.60 256.34 286.38 325.09
24.45 119.35 85.35 108.44 110.02 346.38
5.11 42.18 23.80 19.09 16.10 53.27
133.49 288.79 253.88 395.79 424.42 736.66
6.33 51.38 56.60 55.32 96.63 129.33
15.51 41.58 50.17 41.91

111.65 237.41 197.28 298.89 277.62 565.42

133.49 288.79 253.88 395.79 424.42 736.66
14.16 16.26 22.36 25.09 27.58 41.82
37.00 150.06 123.24 181.07 157.69 389.23
42.39 36.37 17.41 53.04 59.94 87.54
11,127,910.00 11,127,910.00 11,127,910.00 11,919,810.00 11,919,810.00 59,599,050.00

10.00 10.00 10.00 10.00 10.00 2.00

Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24

-10.95 -60.08 33.49 -33.36 59.28 -153.50
-49.81 -9.99 10.88 -34.54 -99.47 -62.09
62.50 85.27 -44.57 116.69 -7.12 214.12
1.74 15.19 -0.20 48.79 -47.31 -1.47

39.50 61.00 161.80 232.66 205.44 398.35

5.56 5.56 5.56 5.96 5.96 5.96