Gandhi Special Tubes

Quick Snapshots

Share Capital

Variable	Current
Market Capitalisation	202.05
Face Value (FV) (#)	5.00
Shares Outstanding	1.47
Equity Capital (Rs. Cr.)	7.35
Foreign (FII) Shareholding (%)	1.93
Promoters Shareholding (%)	73.30
Govt./FI Shareholding (%)	0.06
Others Shareholding (%)	22.56
Corporate Shareholding (%)	1.92

Key Ratios

Variable	Current	Industry Median
Net Profit Margin	33.56	2.63
Operating Profit Margin	41.34	7.40
Asset Turnover	0.74	1.28
Return on Assets	24.95	3.59
Financial Leverage	1.00	1.90
Return on Equity	24.95	10.44
Debt to Equity	0.00	0.89
Return on Capital Employed	35.90	10.61
Interest Coverage	728.80	2.10
Quick Ratio	2.24	1.64
Current Ratio	4.14	2.59
Debtor Days	70.95	52.79
Inventory Days	170.66	84.02

Valuation

Variable	Current	Historical Average	Industry Median
Price Close (Rs.)	137.45
Book Value per share	69.05		40.51
Cash flow per share
Earnings per share	17.23		3.42
Dividend per share	5.00		0.00
Sales per share	51.34		139.35
Free cash flow per share
Price to sales	2.68	1.59	0.26
Price to book value	1.99	1.39	0.64
Price to cash flow
Price to earnings	7.98	6.11	5.72
Price to free cash flow
Dividend Yield	3.64	4.22	0.00

5 Year Snapshots

Performance Snapshot

Variable	FY06	FY07	FY08	FY09	FY10	YoY	5yr CAGR
Sales Turnover (Rs. Cr.)	63.07	69.78	88.34	62.87	81.72	34.34	8.60
Profit After Tax (PAT) (Rs. Cr.)	16.14	12.87	18.84	15.93	25.33	59.01	11.93
Cash from Operating Activities (Rs. Cr.)
Free Cash Flow
Equity Dividend (Rs. Cr.)	2.94	2.94	3.67	3.68	7.35	99.73	25.74
Dividend Payout	18.22	22.84	19.48	23.10	29.02
Net Profit Margin	29.75	21.41	24.74	28.36	33.56
Operating Profit Margin	35.69	35.53	37.80	38.84	41.34
Asset Turnover	1.08	1.01	1.03	0.66	0.74
Return on Assets	32.14	21.64	25.56	18.73	24.95
Financial Leverage	1.02	1.01	1.01	1.00	1.00
Return on Equity	32.88	21.96	25.76	18.79	24.95
Capital Employed	50.22	59.46	73.72	85.07	101.51
Return on Capital Employed	36.92	32.64	36.54	27.35	35.90
Free Cash Flow to Sales
Debt to Equity	0.02	0.01	0.01	0.00	0.00
Interest Coverage		388.20	269.40	290.88	728.80
Interest Cost to Total Debt	0.00	5.88	17.54	27.59
Quick Ratio	1.85	1.82	1.75	1.42	2.24
Current Ratio	3.11	3.23	3.45	3.24	4.14
Debtor Days	60.62	55.07	46.36	64.84	70.95
Inventory Days	124.98	122.08	131.80	231.83	170.66

Historical Valuation Snapshot

Variable	FY06	FY07	FY08	FY09	FY10	Current
Yearly Average Price (Rs.)		69.70	86.53	60.23	71.81	137.45
Book Value per share	33.39	39.87	49.76	57.67	69.05	69.05
Earnings per share	10.98	8.76	12.82	10.84	17.23	17.23
Dividend per share	2.00	2.00	2.50	2.50	5.00	5.00
Sales per share	36.90	40.89	51.80	38.22	51.34	51.34
Cash flow per share
Free cash flow per share
Yearly Average P2BV		1.75	1.74	1.04	1.04	1.99
Yearly Average P2E		7.96	6.75	5.56	4.17	7.98
Yearly Average DivYield		2.87	2.89	4.16	6.96	3.64
Yearly Average P2Sales		1.70	1.67	1.58	1.40	2.68
Yearly Average P2CFlow
Yearly Average P2FreeCFlow

Balance Sheet (Rs in Crs)

Variable	FY06	FY07	FY08	FY09	FY10
Equity Capital (Rs. Cr.)	7.35	7.35	7.35	7.35	7.35
Reserves & Surplus (Rs. Cr.)	41.74	51.26	65.80	77.43	94.16
Total Shareholders Funds (Rs. Cr.)	49.09	58.61	73.15	84.78	101.51
Secured Loans (Rs. Cr.)	0.00	0.00	0.00	0.00	0.00
Unsecured Loans (Rs. Cr.)	1.13	0.85	0.57	0.29	0.00
Total Debt (Rs.Cr.)	1.13	0.85	0.57	0.29	0.00
Total Liabilities (Rs. Cr.)	50.22	59.46	73.72	85.07	101.51
Gross Block (Rs. Cr.)	54.61	67.05	84.67	87.02	86.92
Accumulated Depreciation (Rs. Cr.)	27.15	31.00	35.08	40.13	44.81
Net Block (Rs. Cr.)	27.46	36.05	49.59	46.89	42.11
Capital Work in Progress (Rs. Cr.)	1.79	1.58	0.01	0.00	0.00
Investments (Rs. Cr.)	5.36	5.61	4.02	17.62	30.94
Inventories (Rs. Cr.)	9.69	10.71	14.74	17.74	18.09
Sundry Debtors (Rs. Cr.)	9.01	9.07	9.67	9.98	14.67
Cash and Bank Balance (Rs. Cr.)	2.88	1.24	1.09	1.25	2.63
Loans and Advances (Rs. Cr.)	2.28	3.54	4.47	2.64	4.06
Current Liabilities (Rs. Cr.)	7.67	7.60	8.68	9.75	9.53
Provisions (Rs. Cr.)	0.58	0.74	1.19	1.30	1.46
Net Current Assets (Rs. Cr.)	15.61	16.22	20.10	20.56	28.46
Miscellaneous Expenses (Rs. Cr.)	0.33	0.25	0.99	0.20	0.55
Total Assets (Rs. Cr.)	50.22	59.46	73.72	85.07	101.51
Contingent Liabilities (Rs. Cr.)	0.53	0.51	3.28	1.63	1.61

Cash Flow Statement (Rs in Crs)

Variable	FY06	FY07	FY08	FY09	FY10
Net Profit Before Tax (PBT) (Rs. Cr.)	18.54	19.36	26.84	23.19	36.39
Cash from Operating Activities (Rs. Cr.)
Cash from Investing Activities (Rs. Cr.)
Cash from Financing Activities (Rs. Cr.)
Net Change in Cash
Opening Cash (Rs. Cr.)

P&L Account View (Rs in Crs)

Variable	FY06	FY07	FY08	FY09	FY10
Sales Turnover (Rs. Cr.)	63.07	69.78	88.34	62.87	81.72
Other Income (Rs. Cr.)	2.61	2.14	2.79	6.81	10.32
Stock Adjustments (Rs. Cr.)	0.11	0.22	0.96	-1.02	1.70
Total Income (Rs. Cr.)	65.79	72.14	92.09	68.66	93.74
Raw Materials (Rs. Cr.)	18.48	21.49	25.28	16.76	25.93
Excise Duty (Rs. Cr.)	8.82	9.67	12.20	6.69	6.25
Power & Fuel Cost (Rs. Cr.)	4.50	5.04	7.97	5.55	6.03
Other Manufacturing Expenses (Rs. Cr.)	5.32	5.49	7.57	5.62	6.73
Employee Cost (Rs. Cr.)	1.07	1.31	1.45	1.46	1.62
Selling and Administration Expenses (Rs. Cr.)	5.30	5.39	5.06	3.75	5.11
Miscellaneous Expenses (Rs. Cr.)	0.33	0.25	0.99	0.20	0.55
Preoperative Expenditure Capitalised (Rs. Cr.)	0.00	0.00	0.00	0.00	0.00
Profit before Interest, Depreciation & Tax (Rs. Cr.)	21.97	23.50	31.57	28.63	41.52
Interest & Financial Charges (Rs. Cr.)	0.00	0.05	0.10	0.08	0.05
Depreciation (Rs. Cr.)	3.43	4.09	4.63	5.36	5.08
Net Profit Before Tax (PBT) (Rs. Cr.)	18.54	19.36	26.84	23.19	36.39
Tax (Rs. Cr.)	2.40	6.49	8.00	7.26	11.06
Profit After Tax (PAT) (Rs. Cr.)	16.14	12.87	18.84	15.93	25.33
Adjustment below Net Profit (Rs. Cr.)	0.00	0.00	0.00	0.00	0.00
P&L Balance brought forward (Rs. Cr.)	22.54	33.33	40.85	53.40	63.03
Appropriations (Rs. Cr.)	5.35	5.35	6.29	6.30	11.60
P&L Balance carried down (Rs. Cr.)	33.33	40.85	53.40	63.03	76.76
Equity Dividend (Rs. Cr.)	2.94	2.94	3.67	3.68	7.35
Preference Dividend (Rs. Cr.)	0.00	0.00	0.00	0.00	0.00
Corporate Dividend Tax (Rs. Cr.)	0.41	0.41	0.62	0.62	1.25
Equity Dividend (%)	40.00	40.00	50.00	50.00	100.00
Earnings per share	10.98	8.76	12.82	10.84	17.23
Book Value per share	33.39	39.87	49.76	57.67	69.05
Extraordinary Items (Rs. Cr.)	0.24	-0.04	-0.01	0.02	0.94