Models
GRETEX CORPORATE SERVICESGCSLCapital Markets
166per 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 model166implied FY26 P/E 10.8× · EV/EBITDA 9.6×
Against CMP ₹600.5572.3%close of 2026-09-10
Growth the CMP implies45.0%revenue, a year for 5 years, on your other inputs
Value after FY3170%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
131237
52-week rangetraded range, a fact not a value
213617

From enterprise to equity · ₹ crore

PV of FY27FY31 free cash flow124
PV of terminal value287
Enterprise value411
less net debt(9)
less non-controlling interest0
add non-operating investments0
Equity value402
÷ 2.42 crore shares166

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

00000FY22FY23FY24: ₹(19) croreFY24FY25: ₹(35) croreFY25FY26: ₹(29) croreFY26FY27: ₹35 croreFY27FY28: ₹33 croreFY28FY29: ₹31 croreFY29FY30: ₹29 croreFY30FY31: ₹28 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%172184198215237
10.50%159169181195212
11.00%148157166178192
11.50%139146154164175
12.00%131137144152161
The outlined cell is your model. Green figures sit above the CMP of ₹600.55; 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

P10145P50167P90194
10th · 50th · 90th percentile, ₹ per share145 · 167 · 194
Draws below the CMP100%
Rank correlation with discount rate0.81
Rank correlation with ebitda margin+0.56
Rank correlation with revenue growth0.03
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
Revenue13109259179170161153145138
growth %205.4763.3137.5(31.0)(5.0)(5.0)(5.0)(5.0)(5.0)
EBITDA431434139373533
margin %39.90.524.024.024.024.024.024.0
less depreciation(2)(3)(2)(2)(2)(2)(2)(2)
EBIT42(1)413937353332
less tax on EBIT(12)(12)(11)(10)(10)(9)
NOPAT292726252322
add depreciation23222222
less capex0(4)(1)(1)(1)(1)(2)(2)
less working-capital build77666
Free cash flow to firm(19)(35)3533312928
Discount factor0.9490.8550.7700.6940.625
Present value3428242017
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 10, dividends at 2.4% of profit

₹ croreFY26FY27FY28FY29FY30FY31
Income statement
EBIT413937353332
Interest at 8% on debt(1)(1)(1)(1)(1)
Profit before tax3836343231
Profit after tax282725242322
Dividends(1)(1)(1)(1)(1)(1)
Balance sheet, year end
Cash1356797125152
Working capital142135128122116110
Net block and other assets201200200199199200
Debt101010101010
Equity319345370393415436
Balance check0(0)0(0)0(0)
Cash flow
From operations3634323029
Investing (capex)(1)(1)(1)(2)(2)
Financing (dividends)(1)(1)(1)(1)(1)
Net change in cash3432302827
Free cash flow to equity3533312927
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 · editingDCF-5%24%11.00%5%166(72.3)%
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.