Models
OSWAL GREENTECH LIMITEDOSWALGREENFinance
₹-32per share · Base Model Note
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₹(32)implied P/B (0.34)× on FY26 book
Against CMP ₹18.56−270.2%close of 28 Oct 2026
Cost of equity17.43%risk-free + beta × equity risk premium
Book equity, FY26₹93per share · excess returns add ₹(124)
This figure is the arithmetic of your inputs and nothing else. MarketPing publishes no fair value, target or rating; the model is yours.

Excess-return schedule · ₹ crore · book equity earns your ROE; value is book plus the returns above the cost of equity

₹ croreFY27FY28FY29FY30FY31
Opening book equity2,3852,3232,2632,2042,146
Net income at -2.6% ROE(62)(60)(59)(57)(56)
Cost of equity charge at 17.43%(416)(405)(394)(384)(374)
Excess return(478)(465)(453)(442)(430)
Present value(441)(366)(303)(252)(209)
Closing book equity2,3232,2632,2042,1462,091
Book equity today2,385
PV of 5 years of excess return(1,570)
PV of the terminal excess return, 5% flat(1,626)
add non-operating investments0
Equity value(811)
÷ 25.68 crore shares₹(32)
ROE is at or below the cost of equity, so every year destroys value against book and the model lands below book value. That is the arithmetic, not a view.

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

52-week rangetraded range, a fact not a value
₹17₹39

Scenarios side by side · ₹ per share

ScenarioTemplateGrowthMarginRateTerminal₹ / sharevs CMP
Base · editingExcess returnROE -2.6%—17.43%5%₹(32)(270.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.