The note is the current scenario (Base). Download PDF renders this page on the server, fonts and colours exact; Print uses the browser.
Model Note · SPENCER S RETAIL LIMITED · 29 October 2026Page 1 of 2
Model Note
Prepared by the reader · not a MarketPing document
SPENCER S RETAIL LIMITED Discounted cash flow · base FY26
SPENCER S RETAIL LIMITED
Value per share, this model₹(234)
CMP, 29 Oct 2026₹19.69
Difference(1288.1)%
Growth the CMP implies—
This note states the assumptions and the arithmetic of one model of SPENCER S RETAIL LIMITED, built on its filed FY26 consolidated statements. The value is the outcome of the assumptions below and nothing else; it is not a fair value, a target or a recommendation.
Assumptions
Input
This model
Filed reference
Revenue growth, 5 years
-5% a year
FY26 (9.8)% · 5-yr CAGR (5.8)%
EBITDA margin
-0.6%
FY26 (0.6)% · 5-yr average (0.4)%
Depreciation · capex, % of revenue
5.3% · 0.5%, fading to 1.2× depreciation
FY26 5.3% · 0.5%
Working capital, % of added revenue · tax
0% · 25.17%
-18 working-capital days · effective 25.2%
Discount rate
11.00%
1-yr beta 1.25
After FY31
5% flat · mid-year discounting
—
Net debt · non-controlling interest · non-operating investments
₹1,189 · ₹0 · ₹0 cr
FY26 net debt ₹1,189 cr
Shares
9.01 crore
9.01 crore today
Source: SEBI results XBRL as filed with BSE/NSE, exchange prices; the reader's assumptions.
Projected cash flow to the firm
₹ crore
FY26
FY27
FY28
FY29
FY30
FY31
Revenue
1,800
1,710
1,624
1,543
1,466
1,393
growth %
(9.8)
(5.0)
(5.0)
(5.0)
(5.0)
(5.0)
EBITDA
(11)
(10)
(10)
(9)
(9)
(8)
Depreciation
(96)
(91)
(86)
(82)
(78)
(74)
NOPAT
(80)
(75)
(72)
(68)
(65)
(61)
less capex
(9)
(9)
(32)
(53)
(72)
(89)
less working-capital build
—
0
0
0
0
0
Free cash flow to firm
—
7
(18)
(39)
(59)
(76)
Present value
6
(15)
(30)
(41)
(48)
Source: the model; base year as filed.
Every figure is the reader's model over filed numbers · No rating, target or fair value is expressedmarketping.in
Model Note · SPENCER S RETAIL LIMITED · 29 October 2026Page 2 of 2
From enterprise to equity
PV of the 5 explicit years
(127)
PV of the terminal value (—% of EV)
(792)
Enterprise value
(919)
less net debt
(1,189)
less non-controlling interest
0
add non-operating investments
0
Equity value
(2,108)
÷ 9.01 crore shares
₹(234)
Source: the model.
Sensitivity, ₹ per share
WACC ↓ · terminal growth →
4.0%
4.5%
5.0%
5.5%
6.0%
10.0%
(238)
(246)
(257)
(270)
(286)
10.5%
(228)
(236)
(244)
(255)
(267)
11.0%
(221)
(227)
(234)
(242)
(253)
11.5%
(214)
(219)
(225)
(232)
(240)
12.0%
(208)
(213)
(218)
(224)
(230)
Source: the model; n/a where terminal growth reaches the discount rate.
Statement
This note is the reader's own model over publicly filed information: SEBI results XBRL filed with BSE and NSE and exchange price data, assembled by MarketPing software; every assumption above is the reader's. It contains no research recommendation, no price target and no opinion by MarketPing on the merits of any security, and is not a research report within the meaning of the SEBI (Research Analysts) Regulations, 2014, Regulation 2(1)(w)(vii). Historical per-share figures are on the current share count. Where a figure is unavailable the table shows a dash rather than an estimate. Nothing here constitutes investment advice, an offer or a solicitation.
Every figure is the reader's model over filed numbers · No rating, target or fair value is expressedmarketping.in
