Models
POLYSPIN EXPORTS LTD.POLYSPINIndustrial Products
-6per 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 model(6)implied FY26 P/E (1.0)× · EV/EBITDA 5.8×
Against CMP ₹29.58119.0%close of 2026-09-10
Growth the CMP implies45.0%revenue, a year for 5 years, on your other inputs
Value after FY3167%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
(19)21

From enterprise to equity · ₹ crore

PV of FY27FY31 free cash flow21
PV of terminal value44
Enterprise value65
less net debt(71)
less non-controlling interest0
add non-operating investments0
Equity value(6)
÷ 1.00 crore shares(6)

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

000000FY21: ₹(10) croreFY21FY22: ₹11 croreFY22FY23: ₹5 croreFY23FY24: ₹(5) croreFY24FY25: ₹(10) croreFY25FY26: ₹29 croreFY26FY27: ₹6 croreFY27FY28: ₹6 croreFY28FY29: ₹5 croreFY29FY30: ₹5 croreFY30FY31: ₹4 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%(4)161321
10.50%(8)(5)(0)511
11.00%(12)(9)(6)(1)4
11.50%(16)(13)(10)(7)(2)
12.00%(19)(17)(14)(11)(8)
The outlined cell is your model. Green figures sit above the CMP of ₹29.58; 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(20)P50(6)P9010
10th · 50th · 90th percentile, ₹ per share(20) · (6) · 10
Draws below the CMP100%
Rank correlation with ebitda margin+0.87
Rank correlation with discount rate0.45
Rank correlation with revenue growth0.06
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
Revenue241202225226227228229230231
growth %(12.8)(16.2)11.30.30.50.50.50.50.5
EBITDA4(1)13111111111212
margin %1.8(0.5)5.75.05.05.05.05.05.0
less depreciation(4)(3)(4)(5)(5)(5)(5)(5)(5)
EBIT0(4)8777777
less tax on EBIT(1)(1)(1)(1)(1)(1)
NOPAT555555
add depreciation434555555
less capex(10)(13)(1)(3)(3)(4)(4)(5)(6)
less working-capital build(0)(0)(0)(0)(0)
Free cash flow to firm5(5)(10)66554
Discount factor0.9490.8550.7700.6940.625
Present value65433
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 71, dividends at 0% of profit

₹ croreFY26FY27FY28FY29FY30FY31
Income statement
EBIT777777
Interest at 7.3% on debt(5)(5)(5)(5)(5)
Profit before tax22222
Profit after tax011111
Dividends000000
Balance sheet, year end
Cash034667
Working capital616162626263
Net block and other assets10210010099100101
Debt717171717171
Equity707172747576
Balance check00(0)000
Cash flow
From operations66666
Investing (capex)(3)(4)(4)(5)(6)
Financing (dividends)00000
Net change in cash22110
Free cash flow to equity22110
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 · editingDCF0.5%5%11.00%5%(6)(119.0)%
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.