Models
INNOVA CAPTAB LIMITEDINNOVACAPPharmaceuticals & Biotechnology
309per 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 model309implied FY26 P/E 11.5× · EV/EBITDA 8.7×
Against CMP ₹1,153.0073.2%close of 2026-09-10
Growth the CMP implies45.0%revenue, a year for 5 years, on your other inputs
Value after FY3184%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
218491
52-week rangetraded range, a fact not a value
6221,200

From enterprise to equity · ₹ crore

PV of FY27FY31 free cash flow346
PV of terminal value1,762
Enterprise value2,108
less net debt(340)
less non-controlling interest0
add non-operating investments0
Equity value1,768
÷ 5.72 crore shares309
84% of the value sits after FY31. Usual when return on capital sits near the cost of capital; the 5 explicit years carry little of it.

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

00000FY24: ₹(141) croreFY24FY25: ₹(109) croreFY25FY26: ₹48 croreFY26FY27: ₹42 croreFY27FY28: ₹60 croreFY28FY29: ₹85 croreFY29FY30: ₹121 croreFY30FY31: ₹170 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%322352389434491
10.50%290315345382426
11.00%262284309339374
11.50%239257278303332
12.00%218234252273297
The outlined cell is your model. Green figures sit above the CMP of ₹1,153.00; 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

P10125P50300P90464
10th · 50th · 90th percentile, ₹ per share125 · 300 · 464
Draws below the CMP100%
Rank correlation with ebitda margin+0.90
Rank correlation with revenue growth0.28
Rank correlation with discount rate0.26
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
₹ croreFY24FY25FY26FY27FY28FY29FY30FY31
Revenue1,0811,2441,6302,1192,7553,5814,6556,052
growth %15.031.130.030.030.030.030.0
EBITDA154186243316410534694902
margin %14.315.014.914.914.914.914.914.9
less depreciation(16)(25)(45)(59)(77)(100)(130)(169)
EBIT138161198256333433563732
less tax on EBIT(50)(64)(84)(109)(141)(184)
NOPAT148192250325422548
add depreciation1625455977100130169
less capex(287)(172)(68)(89)(110)(135)(166)(203)
less working-capital build(121)(157)(204)(265)(345)
Free cash flow to firm(141)(109)426085121170
Discount factor0.9490.8550.7700.6940.625
Present value39516684106
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 344, dividends at 0% of profit

₹ croreFY26FY27FY28FY29FY30FY31
Income statement
EBIT198256333433563732
Interest at 5% on debt(17)(17)(17)(17)(17)
Profit before tax239316416546715
Profit after tax0179237312409536
Dividends(11)00000
Balance sheet, year end
Cash33279151259416
Working capital4025236808841,1491,494
Net block and other assets1,4321,4621,4951,5301,5661,600
Debt344344344344344344
Equity1,0911,2701,5071,8182,2272,763
Balance check00000(0)
Cash flow
From operations118157208274360
Investing (capex)(89)(110)(135)(166)(203)
Financing (dividends)00000
Net change in cash294772108157
Free cash flow to equity294772108157
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 · editingDCF30%14.9%11.00%5%309(73.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.