Models
VST INDUSTRIES LTDVSTINDCigarettes & Tobacco Products
266per 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 model266implied FY26 P/E 16.2× · EV/EBITDA 10.0×
Against CMP ₹204.22+30.1%close of 2026-09-10
Growth the CMP implies(2.5)%revenue, a year for 5 years, on your other inputs
Value after FY3174%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
208381
52-week rangetraded range, a fact not a value
200287

From enterprise to equity · ₹ crore

PV of FY27FY31 free cash flow1,174
PV of terminal value3,315
Enterprise value4,489
less net debt24
less non-controlling interest0
add non-operating investments0
Equity value4,513
÷ 16.99 crore shares266

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

00000000FY21: ₹240 croreFY21FY22: ₹228 croreFY22FY23: ₹(222) croreFY23FY24: ₹73 croreFY24FY25: ₹152 croreFY25FY26: ₹176 croreFY26FY27: ₹283 croreFY27FY28: ₹295 croreFY28FY29: ₹306 croreFY29FY30: ₹314 croreFY30FY31: ₹319 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%274294317346381
10.50%254270289312340
11.00%236250266284307
11.50%221233246262280
12.00%208218229242257
The outlined cell is your model. Green figures sit above the CMP of ₹204.22; 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

P10209P50263P90327
10th · 50th · 90th percentile, ₹ per share209 · 263 · 327
Draws below the CMP8%
Rank correlation with ebitda margin+0.82
Rank correlation with discount rate0.50
Rank correlation with revenue growth+0.17
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
Revenue1,6731,8381,8092,0462,3122,6122,9523,3363,769
growth %7.29.9(1.5)13.113.013.013.013.013.0
EBITDA383353379450509575649734829
margin %22.919.221.022.022.022.022.022.022.0
less depreciation(30)(38)(44)(101)(113)(128)(145)(163)(185)
EBIT352315335349395447505570645
less tax on EBIT(88)(99)(112)(127)(143)(162)
NOPAT261296335378427483
add depreciation303844101113128145163185
less capex(404)(94)(41)(42)(49)(80)(118)(165)(222)
less working-capital build(78)(88)(99)(112)(127)
Free cash flow to firm(222)73152283295306314319
Discount factor0.9490.8550.7700.6940.625
Present value269252236218200
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 0, dividends at 58% of profit

₹ croreFY26FY27FY28FY29FY30FY31
Income statement
EBIT349395447505570645
Interest at 8% on debt00000
Profit before tax395447505570645
Profit after tax292296335378427483
Dividends(170)(172)(194)(219)(248)(280)
Balance sheet, year end
Cash24135236323389428
Working capital5986767638639751,101
Net block and other assets1,3941,3291,2811,2541,2551,292
Debt000000
Equity1,4461,5701,7111,8692,0492,252
Balance check000000
Cash flow
From operations332375424479541
Investing (capex)(49)(80)(118)(165)(222)
Financing (dividends)(172)(194)(219)(248)(280)
Net change in cash111101866639
Free cash flow to equity283295306314319
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 · editingDCF13%22%11.00%5%26630.1%
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.