MCX IPO Valuation....!!!

Jai shree krishna
Public Offer	6427378
Offer by sale					Other Investors
Financial Technologies (India) Limited
State Bank India Limited
Glc Financial Fund
Alexandra Mauritius Limited
Corporation Bank Limited
ICICI lombard General Insurance company Limited
Bank Of Baroda
Net Offer	6177378
Reservation for employees	250000
	6427378
12.60%	The post offer paid up equity capital
12.11%	The net Offer of the post offer paid up Equity capital
Expected post offer capital 40000 million
Allotment
50%	QIB(qualified Institutional Buyers)
15%	Non Institutional bidders
35%	retail individual Investors
100%	Total

 

Price Band						Market Capitalisation
Lower	Higher								No Of shares
860	1032					At Higher Price Band		1032	6427378	6,633,054,096.00
Face value	10					At Lower Price Band		860	6427378	5,527,545,080.00
86	103.2	Times the face value
						2153	Members
						296000	Terminals
Stand alone basis						1572	Cities
Period	Basic	Diluted	Weightage				Marker Cap		Members/value	Terminal/value	Cities/value
31-Mar-11	34.46	34.46	3				At Higher Price band		3,080,842.59	22,408.97	4,219,500.06
31-Mar-10	43.22	43.21	2				At Lower Price Band		2,567,368.82	18,674.14	3,516,250.05
31-Mar-09	31.71	31.55	1			Contracts traded
						No of future contracts	31 Dec 2011 (9 Months)	2011		In Billion	9 Months	2011	2010	2009
Avg	36.92166667	36.89166667				Gold	72800000	30500000		Sales /Total value of commodity traded	1,198,068,900,000.00	984,150,300,000.00	639,330,300,000.00	458,809,500,000.00
						silver	101800000	46000000
Dec-11		Basic EPS	42.65			crude oil	42660000	46300000	Higher	sales/MCAP	180.6210054	148.3706127	96.38550971	69.1701731
						copper	26870000	31000000	Lower	sales/MCAP	216.7452065	178.0447352	115.6626117	83.00420772
		P/E at lower Price Band	P/E at higher Price band			Gold
EPS Weighted Avg Basic		23.29255631	27.95106758			At Higher Price Band	91.11	217.48
EPS Weighted Avg Diluted		23.31149763	27.97379715			At Lower Price Band	75.93	181.23		Book Value
						Silver					2007	2008	2009	2010	2011	Dec-11
						At Higher Price Band	65.16	144.20		Net Worth.	2918.81	3586.99	5148.08	6969.83	8484.87	10730.84
Net Worth	Return On Net Worth	Weightage				At Lower Price Band	54.30	120.16		Outstanding Shares	390.75	392.41	407.96	407.99	509.99	509.99
2011	23%	3				Crude Oil				Book Value	74.69763276	91.40924034	126.190803	170.8333538	166.3732622	210.4127532
2010	32%	2				At Higher Price Band	155.49	143.26
2009	20%	1	NW At Lower price Band	NW At Higher Price band		At Lower Price Band	129.57	119.39		Price band No Of Times
						copper			Higher	1032	13.81569886	11.28988706	8.178092027	6.040974887	6.202919785	4.904645675
AVG	25%		3401.543196	4081.851835		At Higher Price Band	246.86	213.97	Lower	860	11.51308239	9.40823922	6.815076689	5.03414574	5.169099821	4.08720473
						At Lower Price Band	205.71	178.31
Return On net worth for 9 Months
Nine Months	21%		4190.287873	5028.345448