Models
SOUTH INDIA PAPER MILLS LTD.BSE 516108Paper, Forest & Jute Products
59per share · Base Model Note
Revenue growth, the horizon and scenarios are yours to change. Every other input is part of the Trader plan; saving, sharing a saved link and the live-formula workbook are part of the Institutional plan.
Scenario
Value per share, your model59implied FY26 P/E 10.3× · EV/EBITDA 5.2×
Against CMP ₹118.8050.2%close of 2026-09-10
Growth the CMP implies45.0%revenue, a year for 5 years, on your other inputs
Value after FY3165%share of enterprise value in the terminal
This figure is the arithmetic of your inputs and nothing else. MarketPing publishes no fair value, target or rating; the model is yours.

Where the methods land · ₹ per share · the dashed line is the CMP

DCF, rate ±1 · growth ±1your model across the sensitivity grid
32114
52-week rangetraded range, a fact not a value
65136

From enterprise to equity · ₹ crore

PV of FY27FY31 free cash flow93
PV of terminal value172
Enterprise value265
less net debt(154)
less non-controlling interest0
add non-operating investments0
Equity value111
÷ 1.88 crore shares59

Free cash flow, filed and modelled · ₹ '000 crore

0000000FY20FY22: ₹(69) croreFY22FY23: ₹(26) croreFY23FY24: ₹(22) croreFY24FY25: ₹38 croreFY25FY26: ₹39 croreFY26FY27: ₹27 croreFY27FY28: ₹27 croreFY28FY29: ₹25 croreFY29FY30: ₹22 croreFY30FY31: ₹17 croreFY31
Filed, cash from operations − capexModelled free cash flow to firm

Sensitivity · ₹ per share

Down Across
WACCterminal growth4.0%4.5%5.0%5.5%6.0%
10.00%63738497114
10.50%5461708194
11.00%4552596879
11.50%3844505766
12.00%3236424855
The outlined cell is your model. Green figures sit above the CMP of ₹118.80; n/a marks a terminal growth at or above the discount rate. Steps: WACC and terminal growth ±0.5 point, growth ±2, margin ±1.

Distribution of outcomes · 4,000 draws · growth, margin and the discount rate vary together

P10(16)P5058P90122
10th · 50th · 90th percentile, ₹ per share(16) · 58 · 122
Draws below the CMP88%
Rank correlation with ebitda margin+0.88
Rank correlation with revenue growth0.41
Rank correlation with discount rate0.19
Each driver is drawn from a PERT distribution between the lowest and highest value across your scenarios (or ±50% growth, ±20% margin when there is one scenario), with the discount rate ±1.5 points. Seeded, so the same inputs give the same picture.

Projected cash flow to the firm · ₹ crore

History Forward
₹ croreFY23FY24FY25FY26FY27FY28FY29FY30FY31
Revenue288312369434510599704827972
growth %(5.7)8.518.317.517.517.517.517.517.5
EBITDA717225160708297114
margin %2.45.46.011.711.711.711.711.711.7
less depreciation(16)(18)(17)(17)(19)(23)(27)(31)(37)
EBIT(9)(1)6344047566577
less tax on EBIT(9)(10)(12)(14)(16)(19)
NOPAT253035424957
add depreciation161817171923273137
less capex(27)(4)(3)(4)(5)(11)(19)(30)(44)
less working-capital build(18)(21)(24)(29)(34)
Free cash flow to firm(26)(22)382727252217
Discount factor0.9490.8550.7700.6940.625
Present value2623191510
History columns are the filed years (free cash flow there is cash from operations − capex, as filed); the base year and everything to its right come from the engine. Forward is the explicit horizon of the model itself: 3, 5 or 10 years, then flat.

The three statements, projected · ₹ crore · debt held at 156, dividends at 0.3% of profit

₹ croreFY26FY27FY28FY29FY30FY31
Income statement
EBIT344047566577
Interest at 12.3% on debt(19)(19)(19)(19)(19)
Profit before tax2128364658
Profit after tax111621273543
Dividends(0)(0)(0)(0)(0)(0)
Balance sheet, year end
Cash21527384547
Working capital101118139163192225
Net block and other assets346331319312310318
Debt156156156156156156
Equity222238259286321364
Balance check000(0)00
Cash flow
From operations1823303746
Investing (capex)(5)(11)(19)(30)(44)
Financing (dividends)(0)(0)(0)(0)(0)
Net change in cash13121072
Free cash flow to equity13121072
Other liabilities are held at their FY26 level, so the check tests only what the model moves: cash, working capital, net block and other assets, debt and equity. A non-zero check would mean the three statements no longer tie.

Scenarios side by side · ₹ per share

ScenarioTemplateGrowthMarginRateTerminal₹ / sharevs CMP
Base · editingDCF17.5%11.7%11.00%5%59(50.2)%
A scenario is a full set of inputs under a name. Keep Base as the filed history carried forward; add Bull and Bear by saving the current inputs under those names and moving the two or three assumptions you actually hold a view on. The distribution above draws each driver between the lowest and highest value across your scenarios, so three scenarios give it a real range; with one scenario it falls back to fixed bands.