GIC HOUSING FINANCE LTD — valuation model

GIC HOUSING FINANCE LTDGICHSGFINFinance

₹132per 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

Inputslive

Template

GIC HOUSING FINANCE LTD is a lender: the loans it makes run through its cash flow, so free cash flow to the firm does not measure it. It is valued on the excess-return template: book equity earning your ROE over the cost of equity.

Explicit years, then flat

Excess returns are projected to FY31; after that they grow flat at the terminal rate.

These inputs are part of the Trader plan; on your plan they stay at the figures shown. See plans

Book equity today

0FY26 filed 2,1062,200

Return on equity

0FY26 as filed40

Dividend payout

0FY26 as filed100

Book equity earns your ROE; what is not paid out compounds the book.

Value per share, your model₹132implied P/B 0.34× on FY26 book

Against CMP ₹123.00+7.0%close of 27 Oct 2026

Cost of equity11.22%risk-free + beta × equity risk premium

Book equity, FY26₹391per share · excess returns add ₹(259)

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

₹ crore	FY27	FY28	FY29	FY30	FY31
Opening book equity	2,106	2,236	2,373	2,519	2,674
Net income at 7.3% ROE	154	163	173	184	195
Cost of equity charge at 11.22%	(236)	(251)	(266)	(283)	(300)
Excess return	(83)	(88)	(93)	(99)	(105)
Present value	(78)	(75)	(71)	(68)	(65)
Closing book equity	2,236	2,373	2,519	2,674	2,839

Book equity today	2,106
PV of 5 years of excess return	(357)
PV of the terminal excess return, 5% flat	(1,040)
add non-operating investments	0
Equity value	709
÷ 5.39 crore shares	₹132

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

₹120₹184

Scenarios side by side · ₹ per share

Scenario	Template	Growth	Margin	Rate	Terminal	₹ / share	vs CMP
Base · editing	Excess return	ROE 7.3%	—	11.22%	5%	₹132	7.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.