Nifty

:

22147.00

Sensex

:

73088.33

151.15 (0.69%)
599.34 (0.83%)

Login

Nifty
Sensex

:
:

22147.00
73088.33

151.15 (0.69%)
599.34 (0.83%)

Spencer's Retail Ltd.

Retailing - Supermarts

Rating :

53/99

BSE: 542337 | NSE: SPENCERS

Watchlist

NSE BSE

98.80

19-Apr-2024

Open
High
Low
Previous Close

98.20
101.65
95.40
98.45

Volume
Traded Value (lacs)
52 Week High
52 Week Low

212694
208.72
139.30
56.50

Stock Summary

Market Cap(Crs)
Stock P:E
Face Value

893.30
N/A
5

Enterprise Value(Crs)
Dividend Yield
Price:Book Value

1,515.54
N/A
-2.66

Chart

Price | P:E | P:BV | EV:EBITDA | MCap:Sales | EPS

Revenue CAGR (%)

10 Years
5 Years
3 Years

4.15
2.32
0.34

EBITDA CAGR (%)

10 Years
5 Years
3 Years

-12.30
-
203.70

PAT CAGR (%)

10 Years
5 Years
3 Years

-0.79
-
8.69

P:E (Median)

8 Years
5 Years
3 Years

-
-
-

P:BV (Average)

8 Years
5 Years
3 Years

-
1.75
1.58

EV:EBITDA (Average)

8 Years
5 Years
3 Years

-
24.42
32.87

Quarterly Results

Consolidated Figures in Rs. Crores /

Standalone

Description Dec 23 Dec 22 Var% Sep 23 Sep 22 Var% Jun 23 Jun 22 Var% Mar 23 Mar 22 Var%
Net Sales 570.24 563.27 1.24% 499.27 580.76 -14.03% 502.92 554.68 -9.33% 481.54 476.28 1.10%
Expenses 564.32 565.17 -0.15% 507.02 577.65 -12.23% 508.70 548.55 -7.26% 484.45 483.63 0.17%
EBITDA 5.92 -1.90 - -7.74 3.11 - -5.79 6.13 - -2.90 -7.35 -
EBIDTM 1.04% -0.34% -1.55% 0.53% -1.15% 1.11% -0.60% -1.54%
Other Income 6.06 2.89 109.69% 2.76 4.84 -42.98% 6.55 18.17 -63.95% 4.00 20.51 -80.50%
Interest 30.52 23.00 32.70% 28.86 21.52 34.11% 26.50 20.23 30.99% 25.96 19.68 31.91%
Depreciation 22.43 25.60 -12.38% 22.76 23.67 -3.84% 25.98 24.29 6.96% 23.32 21.91 6.44%
PBT -40.98 -47.60 - -56.60 -37.25 - -51.71 -20.21 - -48.17 -28.42 -
Tax 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0
PAT -40.98 -47.60 - -56.60 -37.25 - -51.71 -20.21 - -48.17 -28.42 -
PATM -7.19% -8.45% -11.34% -6.41% -10.28% -3.64% -10.00% -5.97%
EPS -4.55 -5.28 - -6.28 -4.13 - -5.74 -2.24 - -5.35 -3.15 -

Description Dec 23 Dec 22 Var% Sep 23 Sep 22 Var% Jun 23 Jun 22 Var% Mar 23 Mar 22 Var%
Net Sales 654.01 638.91 2.36% 574.04 649.27 -11.59% 570.17 621.01 -8.19% 543.39 541.85 0.28%
Expenses 642.26 640.30 0.31% 580.74 647.66 -10.33% 574.79 615.08 -6.55% 545.97 551.60 -1.02%
EBITDA 11.75 -1.39 - -6.70 1.61 - -4.62 5.93 - -2.58 -9.75 -
EBIDTM 1.80% -0.22% -1.17% 0.25% -0.81% 0.95% -0.47% -1.80%
Other Income 6.25 3.13 99.68% 3.06 5.09 -39.88% 11.95 18.30 -34.70% 6.06 22.82 -73.44%
Interest 37.67 29.58 27.35% 35.64 27.20 31.03% 33.53 25.51 31.44% 32.92 25.15 30.89%
Depreciation 31.61 34.02 -7.08% 30.93 33.38 -7.34% 38.02 32.44 17.20% 31.89 30.51 4.52%
PBT -51.29 -61.85 - -70.21 -53.88 - -64.22 -33.73 - -61.33 -42.59 -
Tax -0.09 -0.10 - -0.09 -0.10 - -0.09 -0.10 - -0.10 -0.12 -
PAT -51.20 -61.75 - -70.12 -53.78 - -64.14 -33.63 - -61.23 -42.47 -
PATM -7.83% -9.67% -12.22% -8.28% -11.25% -5.42% -11.27% -7.84%
EPS -5.68 -6.85 - -7.78 -5.97 - -7.12 -3.73 - -6.79 -4.71 -

Annual Results

Standalone Figures in Rs. Crores /

Consolidated

Right to Left

Description TTM Mar 23 Mar 22 Mar 21 Mar 20 Mar 19 Mar 18 Mar 17 Mar 16 Mar 15 Mar 14
Net Sales 2,053.97 2,180.25 1,999.62 2,068.95 2,373.29 2,187.19 1,042.86 2,012.03 1,796.16 1,665.70 1,451.28 Net Sales Growth -5.56% 9.03% -3.35% -12.82% 8.51% 109.73% -48.17% 12.02% 7.83% 14.77% Cost Of Goods Sold 1,665.88 1,766.34 1,610.74 1,670.49 1,872.14 1,722.66 837.46 1,598.17 1,429.20 1,346.00 1,169.20 Gross Profit 388.09 413.91 388.88 398.46 501.16 464.53 205.40 413.86 366.96 319.70 282.08 GP Margin 18.89% 18.98% 19.45% 19.26% 21.12% 21.24% 19.70% 20.57% 20.43% 19.19% 19.44% Total Expenditure 2,064.49 2,200.92 1,989.57 2,069.03 2,294.03 2,173.25 1,042.43 2,038.02 1,857.86 1,738.98 1,528.12 Power & Fuel Cost - 45.45 38.98 38.59 48.70 43.34 18.04 37.98 36.53 35.89 34.07 % Of Sales - 2.08% 1.95% 1.87% 2.05% 1.98% 1.73% 1.89% 2.03% 2.15% 2.35% Employee Cost - 164.32 152.11 158.35 160.57 142.08 72.09 145.21 136.60 131.05 113.97 % Of Sales - 7.54% 7.61% 7.65% 6.77% 6.50% 6.91% 7.22% 7.61% 7.87% 7.85% Manufacturing Exp. - 43.47 39.21 39.04 41.40 36.10 17.44 75.41 70.24 41.18 30.81 % Of Sales - 1.99% 1.96% 1.89% 1.74% 1.65% 1.67% 3.75% 3.91% 2.47% 2.12% General & Admin Exp. - 93.03 79.43 82.37 107.27 178.30 78.81 146.46 147.73 144.59 139.01 % Of Sales - 4.27% 3.97% 3.98% 4.52% 8.15% 7.56% 7.28% 8.22% 8.68% 9.58% Selling & Distn. Exp. - 53.48 53.06 36.27 44.23 36.51 12.30 28.12 32.23 31.32 28.08 % Of Sales - 2.45% 2.65% 1.75% 1.86% 1.67% 1.18% 1.40% 1.79% 1.88% 1.93% Miscellaneous Exp. - 34.83 16.05 43.92 19.72 14.26 6.29 6.67 5.32 8.94 28.08 % Of Sales - 1.60% 0.80% 2.12% 0.83% 0.65% 0.60% 0.33% 0.30% 0.54% 0.90% EBITDA -10.51 -20.67 10.05 -0.08 79.26 13.94 0.43 -25.99 -61.70 -73.28 -76.84 EBITDA Margin -0.51% -0.95% 0.50% 0.00% 3.34% 0.64% 0.04% -1.29% -3.44% -4.40% -5.29% Other Income 19.37 55.01 74.93 47.18 29.55 27.79 8.95 8.89 8.89 6.22 6.73 Interest 111.84 90.70 76.01 68.86 60.87 7.45 3.80 57.29 52.99 47.65 43.37 Depreciation 94.49 96.87 93.53 106.17 104.96 24.55 14.68 33.19 36.72 36.92 31.93 PBT -197.46 -153.23 -84.56 -127.93 -57.02 9.73 -9.10 -107.58 -142.52 -151.62 -145.41 Tax 0.00 0.00 0.00 0.00 0.00 1.79 0.00 0.00 0.00 0.00 0.00 Tax Rate 0.00% 0.00% 0.00% 0.00% 0.00% 18.40% 0.00% 0.00% 0.00% 0.00% 0.00% PAT -197.46 -153.23 -84.56 -127.93 -57.02 7.94 -9.10 -107.58 -142.52 -151.62 -165.80 PAT before Minority Interest -197.46 -153.23 -84.56 -127.93 -57.02 7.94 -9.10 -107.58 -142.52 -151.62 -165.80 Minority Interest 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 PAT Margin -9.61% -7.03% -4.23% -6.18% -2.40% 0.36% -0.87% -5.35% -7.93% -9.10% -11.42% PAT Growth 0.00% - - - - - - - - - EPS -21.92 -17.01 -9.39 -14.20 -6.33 0.88 -1.01 -11.94 -15.82 -16.83 -18.40

Description TTM Mar 23 Mar 22 Mar 21 Mar 20 Mar 19 Mar 18
Net Sales 2,341.61 2,452.58 2,299.69 2,428.07 2,644.82 2,187.18 1,042.86 Net Sales Growth -4.46% 6.65% -5.29% -8.20% 20.92% 109.73% Cost Of Goods Sold 1,871.10 1,959.66 1,823.02 1,932.26 2,078.90 1,722.66 837.46 Gross Profit 470.51 492.92 476.66 495.80 565.92 464.52 205.40 GP Margin 20.09% 20.10% 20.73% 20.42% 21.40% 21.24% 19.70% Total Expenditure 2,343.76 2,473.57 2,284.23 2,420.12 2,587.49 2,178.27 1,047.32 Power & Fuel Cost - 58.34 50.28 48.70 57.45 43.34 18.05 % Of Sales - 2.38% 2.19% 2.01% 2.17% 1.98% 1.73% Employee Cost - 198.60 188.83 193.15 191.34 147.58 76.02 % Of Sales - 8.10% 8.21% 7.95% 7.23% 6.75% 7.29% Manufacturing Exp. - 51.56 45.68 46.58 46.54 36.93 17.63 % Of Sales - 2.10% 1.99% 1.92% 1.76% 1.69% 1.69% General & Admin Exp. - 110.94 103.00 101.28 130.89 180.20 79.59 % Of Sales - 4.52% 4.48% 4.17% 4.95% 8.24% 7.63% Selling & Distn. Exp. - 50.31 47.38 48.29 57.45 32.55 13.03 % Of Sales - 2.05% 2.06% 1.99% 2.17% 1.49% 1.25% Miscellaneous Exp. - 44.16 26.04 49.85 24.92 15.02 5.54 % Of Sales - 1.80% 1.13% 2.05% 0.94% 0.69% 0.53% EBITDA -2.15 -20.99 15.46 7.95 57.33 8.91 -4.46 EBITDA Margin -0.09% -0.86% 0.67% 0.33% 2.17% 0.41% -0.43% Other Income 27.32 57.14 85.31 53.40 31.81 28.15 9.02 Interest 139.76 115.21 96.97 91.34 81.95 7.45 3.80 Depreciation 132.45 131.73 125.75 134.21 138.15 25.43 14.88 PBT -247.05 -210.79 -121.94 -164.20 -130.97 4.18 -14.13 Tax -0.37 -0.39 -0.48 -0.35 -0.19 1.79 0.00 Tax Rate 0.15% 0.19% 0.39% 0.21% 0.15% 42.82% 0.00% PAT -246.69 -210.40 -121.46 -163.85 -130.78 2.39 -14.13 PAT before Minority Interest -246.69 -210.40 -121.46 -163.85 -130.78 2.39 -14.13 Minority Interest 0.00 0.00 0.00 0.00 0.00 0.00 0.00 PAT Margin -10.54% -8.58% -5.28% -6.75% -4.94% 0.11% -1.35% PAT Growth 0.00% - - - - - EPS -27.38 -23.35 -13.48 -18.19 -14.51 0.27 -1.57

Results Balance Sheet

Standalone Figures in Rs. Crores /

Consolidated

Right to Left

Description Mar 23 Mar 22 Mar 21 Mar 20 Mar 19 Mar 18 Mar 15 Mar 14 Mar 13 Mar 12
Shareholder's Funds 101.83 256.97 344.55 395.25 596.50 589.99 59.52 66.47 136.27 178.41 Share Capital 45.07 45.07 45.07 39.77 39.77 0.00 242.80 173.43 104.06 26.01 Total Reserves 56.36 211.57 299.30 355.48 556.73 550.22 -1,361.57 -1,240.71 -1,110.50 -916.97 Non-Current Liabilities 727.69 623.19 561.66 511.29 9.02 8.91 -72.78 -69.37 -80.09 -186.86 Secured Loans 141.68 92.90 27.06 23.33 0.00 0.00 175.00 236.00 225.00 86.25 Unsecured Loans 0.00 0.00 0.00 0.94 0.85 0.78 58.00 0.00 0.00 0.00 Long Term Provisions 14.59 13.93 11.41 9.76 8.16 8.13 4.76 4.99 5.12 4.39 Current Liabilities 723.22 617.05 544.85 511.30 356.23 315.24 562.89 501.32 399.53 558.24 Trade Payables 298.56 292.03 273.44 310.17 312.45 279.54 193.55 181.89 134.19 133.71 Other Current Liabilities 161.20 140.07 120.80 119.98 29.57 20.74 130.31 75.22 53.12 65.20 Short Term Borrowings 254.35 177.65 138.15 68.56 0.00 0.00 225.00 231.61 200.00 350.00 Short Term Provisions 9.10 7.30 12.45 12.59 14.21 14.96 14.04 12.59 12.22 9.33 Total Liabilities 1,552.74 1,497.21 1,451.06 1,417.84 961.75 914.14 549.63 498.42 455.71 549.79 Net Block 723.11 660.31 686.69 659.48 258.53 233.90 174.12 195.16 181.56 221.28 Gross Block 1,009.94 857.62 859.16 797.18 360.80 313.98 382.59 387.67 353.25 381.01 Accumulated Depreciation 286.83 197.32 172.48 137.69 102.27 80.08 208.47 192.51 171.69 159.73 Non Current Assets 1,240.44 1,182.83 1,109.08 1,047.59 391.20 509.73 341.87 324.04 302.80 411.11 Capital Work in Progress 1.95 5.80 1.79 8.67 1.06 0.15 13.86 0.59 1.60 0.00 Non Current Investment 471.60 457.06 353.27 316.17 67.20 55.04 72.01 32.01 28.01 104.25 Long Term Loans & Adv. 41.98 56.75 60.90 60.33 42.01 49.12 53.23 70.85 71.72 68.85 Other Non Current Assets 1.80 2.92 6.44 2.93 22.41 171.52 28.64 25.44 19.91 16.73 Current Assets 312.30 314.38 341.98 370.25 570.54 404.41 207.77 174.37 152.91 138.69 Current Investments 20.21 20.78 0.00 0.00 9.83 0.00 0.00 0.00 0.00 0.00 Inventories 228.65 229.00 235.82 230.63 269.82 242.49 171.21 140.59 106.45 107.88 Sundry Debtors 19.07 26.17 31.46 61.19 45.68 37.21 21.23 20.93 21.22 16.26 Cash & Bank 16.10 14.90 53.48 59.63 219.04 99.28 3.92 6.10 17.91 6.94 Other Current Assets 28.27 4.50 5.65 6.01 26.17 25.44 11.40 6.75 7.33 7.60 Short Term Loans & Adv. 22.45 19.04 15.58 12.78 14.66 14.65 5.09 6.48 2.56 4.70 Net Current Assets -410.92 -302.67 -202.87 -141.05 214.31 89.18 -355.12 -326.95 -246.62 -419.56 Total Assets 1,552.74 1,497.21 1,451.06 1,417.84 961.74 914.14 549.64 498.41 455.71 549.80

Description Mar 23 Mar 22 Mar 21 Mar 20 Mar 19 Mar 18
Shareholder's Funds -150.47 61.86 186.33 273.95 548.13 547.12 Share Capital 45.07 45.07 45.07 39.77 39.77 0.00 Total Reserves -195.94 16.46 141.08 234.18 508.36 507.35 Non-Current Liabilities 921.31 784.79 711.15 682.43 9.08 9.03 Secured Loans 180.87 126.74 75.47 86.81 0.00 0.00 Unsecured Loans 0.00 0.00 0.00 0.94 0.85 0.78 Long Term Provisions 16.13 15.54 12.51 10.30 8.23 8.25 Current Liabilities 858.52 718.63 662.01 637.53 356.35 317.33 Trade Payables 343.58 333.37 330.91 373.99 312.05 280.22 Other Current Liabilities 204.05 180.79 160.63 167.23 30.09 22.15 Short Term Borrowings 301.41 196.82 157.91 83.35 0.00 0.00 Short Term Provisions 9.49 7.65 12.57 12.97 14.21 14.96 Total Liabilities 1,629.36 1,565.28 1,559.49 1,593.91 913.56 873.48 Net Block 1,131.86 1,048.81 1,053.25 1,054.88 262.73 238.71 Gross Block 1,480.44 1,273.88 1,244.66 1,202.07 366.29 319.21 Accumulated Depreciation 348.58 225.07 191.41 147.19 103.56 80.50 Non Current Assets 1,265.39 1,204.28 1,171.67 1,164.52 341.26 466.55 Capital Work in Progress 2.05 7.97 2.83 9.85 1.06 0.15 Non Current Investment 73.76 73.02 34.93 23.83 12.76 6.85 Long Term Loans & Adv. 56.36 71.76 74.46 75.18 44.01 49.31 Other Non Current Assets 1.37 2.71 6.20 0.78 20.70 171.52 Current Assets 363.97 361.00 387.82 429.38 572.30 406.93 Current Investments 20.21 20.78 0.00 0.00 9.83 0.00 Inventories 264.51 260.41 267.44 248.28 269.82 242.49 Sundry Debtors 19.76 26.63 29.76 66.47 44.77 37.21 Cash & Bank 17.62 18.08 57.75 81.28 219.90 100.01 Other Current Assets 41.86 5.85 6.74 6.34 27.98 27.23 Short Term Loans & Adv. 34.43 29.25 26.12 27.00 16.29 16.41 Net Current Assets -494.55 -357.63 -274.19 -208.15 215.95 89.60 Total Assets 1,629.36 1,565.28 1,559.49 1,593.90 913.56 873.48

Cash Flow

Standalone Figures in Rs. Crores /

Consolidated

Right to Left

Description Mar 23 Mar 22 Mar 21 Mar 20 Mar 19 Mar 18
Cash From Operating Activity 28.81 63.17 -1.80 106.52 -7.50 -42.84 PBT -153.23 -84.56 -127.93 -57.02 9.73 -9.10 Adjustment 161.67 118.52 169.97 154.85 6.70 9.57 Changes in Working Capital 7.35 27.40 -38.98 15.27 -18.76 -43.32 Cash after chg. in Working capital 15.79 61.35 3.06 113.10 -2.33 -42.84 Interest Paid 0.00 0.00 0.00 0.00 0.00 0.00 Tax Paid 13.02 1.82 -4.86 -6.58 -5.17 0.00 Other Direct Exp. Paid 0.00 0.00 0.00 0.00 0.00 0.00 Extra & Other Items 0.00 0.00 0.00 0.00 0.00 0.00 Cash From Investing Activity -34.71 -98.48 -47.08 -63.87 16.33 -236.40 Net Fixed Assets -148.47 -2.47 -55.10 -443.99 -47.73 Net Investments -13.97 -124.57 -37.10 -239.14 -21.99 Others 127.73 28.56 45.12 619.26 86.05 Cash from Financing Activity 3.82 -3.67 41.97 -11.04 -0.09 81.97 Net Cash Inflow / Outflow -2.08 -38.97 -6.91 31.61 8.74 -197.28 Opening Cash & Equivalents 13.75 52.72 59.63 28.03 19.28 0.00 Closing Cash & Equivalent 11.67 13.75 52.72 59.63 28.03 19.28

Description Mar 23 Mar 22 Mar 21 Mar 20 Mar 19 Mar 18
Cash From Operating Activity 26.74 54.60 -2.43 114.09 -12.88 -47.78 PBT -210.79 -121.94 -164.20 -130.97 4.18 -14.13 Adjustment 220.96 165.91 218.13 212.69 7.55 9.85 Changes in Working Capital 1.85 9.88 -52.10 39.59 -21.27 -43.51 Cash after chg. in Working capital 12.03 53.85 1.82 121.30 -9.55 -47.78 Interest Paid 0.00 0.00 0.00 0.00 0.00 0.00 Tax Paid 14.71 0.75 -4.25 -7.21 -3.33 0.00 Other Direct Exp. Paid 0.00 0.00 0.00 0.00 0.00 0.00 Extra & Other Items 0.00 0.00 0.00 0.00 0.00 0.00 Cash From Investing Activity -25.61 -40.16 -18.29 -6.93 21.83 -189.39 Net Fixed Assets -148.47 -2.47 -55.10 -443.99 -47.73 Net Investments -13.97 -124.57 -37.10 -239.14 -21.99 Others 136.83 86.88 73.91 676.20 91.55 Cash from Financing Activity -4.81 -54.50 -3.34 -54.46 -0.10 37.83 Net Cash Inflow / Outflow -3.68 -40.05 -24.06 52.70 8.86 -199.34 Opening Cash & Equivalents 16.85 56.91 80.97 28.27 19.41 0.00 Closing Cash & Equivalent 13.17 16.85 56.91 80.97 28.27 19.41

Financial Ratios

Standalone /

Consolidated

Right to Left

Description Mar 23 Mar 22 Mar 21 Mar 20 Mar 19 Mar 18
Book Value (Rs.) 11.25 28.47 38.21 49.14 74.17 0.00 ROA -10.05% -5.74% -8.92% -4.79% 0.85% -1.00% ROE -85.59% -28.14% -34.59% -11.50% 1.39% -1.65% ROCE -11.46% -1.60% -11.68% 0.71% 2.89% -0.90% Fixed Asset Turnover 2.55 2.54 2.73 4.48 7.11 3.66 Receivable days 3.46 4.83 7.48 7.52 6.31 11.82 Inventory Days 35.03 38.93 37.67 35.20 38.99 77.04 Payable days 61.02 64.07 63.76 50.87 53.14 104.22 Cash Conversion Cycle -22.53 -20.31 -18.60 -8.15 -7.84 -15.36 Total Debt/Equity 4.34 1.14 0.50 0.25 0.00 0.00 Interest Cover -0.69 -0.11 -0.86 0.06 2.31 -1.40

Description Mar 23 Mar 22 Mar 21 Mar 20 Mar 19 Mar 18
Book Value (Rs.) -16.74 6.83 20.65 34.06 68.15 0.00 ROA -13.17% -7.77% -10.39% -10.43% 0.27% -1.62% ROE 0.00% -98.08% -71.23% -31.82% 0.45% -2.78% ROCE -23.49% -5.78% -16.05% -9.65% 2.12% -1.88% Fixed Asset Turnover 1.94 1.97 2.16 3.68 7.00 3.60 Receivable days 3.16 4.15 6.64 7.04 6.24 11.82 Inventory Days 35.80 38.86 35.61 32.79 38.99 77.04 Payable days 63.04 66.50 66.58 49.10 53.08 103.94 Cash Conversion Cycle -24.08 -23.49 -24.33 -9.27 -7.85 -15.08 Total Debt/Equity -3.59 5.87 1.37 0.70 0.00 0.00 Interest Cover -0.83 -0.26 -0.80 -0.60 1.56 -2.72

Top Investors:

india insight value fund

life insurance corporation of india

habrok india master lp

ginni finance pvt. ltd.

cassini partners, l.p.

investor education and protection fund (iepf)

Annual Reports:

News Update:

Spencer's Retail - Quarterly Results
1st Feb 2024, 19:17 PM

Read More

Source: www.accordfintech.com | DISCLAIMER: Information is provided " as is" and solely for informational purposes, not for trading purposes or advice, and may be delayed.

Feedback