Urgent Please

Pankaj Arora (Learner) (3134 Points)

07 June 2011

Please let me know how to calculate EBIT Margin from below mention P & L A/c?

Profit & Loss account of Sonata Software

------------------- in Rs. Cr. -------------------

	Mar '06	Mar '07	Mar '08	Mar '09	Mar '10

	12 mths	12 mths	12 mths	12 mths	12 mths

Income
Sales Turnover	148.67	185.83	198.82	243.58	236.09
Excise Duty	0.00	0.00	0.00	0.00	0.00
Net Sales	148.67	185.83	198.82	243.58	236.09
Other Income	-15.41	0.50	2.12	-11.46	0.03
Stock Adjustments	1.34	-3.67	-1.57	-1.57	0.00
Total Income	134.60	182.66	199.37	230.55	236.12
Expenditure
Raw Materials	0.00	0.00	0.00	0.00	0.00
Power & Fuel Cost	2.98	3.56	3.52	0.00	0.00
Employee Cost	69.45	81.92	90.97	108.64	116.19
Other Manufacturing Expenses	0.25	0.27	0.30	3.89	3.97
Selling and Admin Expenses	19.12	20.22	20.10	20.34	18.93
Miscellaneous Expenses	25.70	32.83	35.50	33.12	27.77
Preoperative Exp Capitalised	0.00	0.00	0.00	0.00	0.00
Total Expenses	117.50	138.80	150.39	165.99	166.86
	Mar '06	Mar '07	Mar '08	Mar '09	Mar '10

	12 mths	12 mths	12 mths	12 mths	12 mths

Operating Profit	32.51	43.36	46.86	76.02	69.23
PBDIT	17.10	43.86	48.98	64.56	69.26
Interest	0.00	0.50	0.11	0.39	0.00
PBDT	17.10	43.36	48.87	64.17	69.26
Depreciation	6.96	9.11	9.45	8.13	7.77
Other Written Off	0.00	0.00	0.00	0.00	0.00
Profit Before Tax	10.14	34.25	39.42	56.04	61.49
Extra-ordinary items	0.43	0.51	0.16	0.50	1.65
PBT (Post Extra-ord Items)	10.57	34.76	39.58	56.54	63.14
Tax	2.80	-0.38	2.89	3.18	2.95
Reported Net Profit	7.78	35.13	36.69	53.36	60.20
Total Value Addition	117.50	138.81	150.39	165.99	166.85
Preference Dividend	0.00	0.00	0.00	0.00	0.00
Equity Dividend	10.52	11.57	11.57	15.77	17.88
Corporate Dividend Tax	1.47	1.81	1.97	2.68	3.01
Per share data (annualised)
Shares in issue (lakhs)	1,051.59	1,051.59	1,051.59	1,051.59	1,051.59
Earning Per Share (Rs)	0.74	3.34	3.49	5.07	5.72
Equity Dividend (%)	100.00	110.00	110.00	150.00	170.00
Book Value (Rs)	14.91	16.98	18.95	21.28	27.78