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 |
|||||