Ratio analysis of TATA

Mahindra & Mahindra
Particular 2010 2011
1
liquidity ratio
Current Assest 6046.51 6143.48
Current Liailities 51!6.54 6"6".56
Current ratio 1.2 0.!
2
Quick Assets 4857.73 4449.27
Current Liabilities 5196.54 6767.56
#uic$ %atio 0.23 0.25
3
le&era'e %atio
Debts 2880.15 2405.29
Equit 7826.77 10313.39
(ets )quity %atio 0.4 0.2
4
Debts 2880.15 2405.29
!"tal Asset 16147.25 19840.62
(ets ratio 0.18 0.12
5
E#$!A 3003.6 3590.47
$nterest 156.85 70.86
*nterest Co&era'e ratio 1!.1 50."
+urno&er
6
A%era&e 'a( )aterial 1356.35 1666.58
c"st "* )aterial c"nsu)e+ 11695.56 14708.94
%a, Material +urno&er-days. 42 41
"
A,. -"rk in .r"&ress 614.51 689.42
C/01 13531.39 17709.5
/or$ in 0ro'ress turno&er-day 1" 14
8
A.,. 2inis3e+ 4r"+uct 2161.31 1528.52
C/01 14097.15 19997.84
1inished stoc$ +urno&er in -day 56 28
!
A%era&e Cre+it"r 1582.49 1901.21
4urc3ases 14998.23 19627.12
Creditor turno&er -days. 39 35
10
A%era&e Debt"r 1053.56 1306.4
10 1ales 18038.05 22757.51
(etor turno&er-days. 21 21
11
Pro2tality %atio
3et sale 231!8.65 2!"0"."
4ross 0ro2t 3348.1! 54!2.43
'ross 0ro2t ratio 14.43 18.4!
12
4A! 2478.56 3079.73
5et sale 23198.65 29707.7
3et 0ro2t %atio 10.68 10.3"
13
4A! 2478.56 3079.73
!"tal assets 35614.7 50162.2
%eturn on Assets 0.0" 0.06
14
PA+ 2478.56 3079.73
Ca0ital )50loyed 23641.73 31352.16
%eturn on ca0ital e50loyed 0.10 0.10
6aluation
15
6arket .rice .er s3are 607 626
Earnin& .er 13are 35.61 44.33
Price )arnin' %atio 1".05 14.12
16
Di%i+en+ .ai+ 367.13 739.9
5" "* 13are 6139401.09 6139401.09
(i&idend 0er 7hare 0.00005!"!! 0.0001205166
1"
4A! 2478.56 3079.73
5u)ber "* 13are 6139401.09 6139401.09
)arnin' Per 7hare 35.61 44.33
18
Earnin& 4er 13are 35.61 44.33
6arket 4rice 607 626
)arnin' 8ield 5.8" ".08
1!
Di%i+en+ 4er 13are 367.13 739.9
6arket 4rice 607 626
(i&idend 8ield 60.48 118.1!
(9 Pont Analysis
20
4r"7t 2478.56 3079.73
net 1ale 23198.65 29707.7
Pro2t Mar'in 0.1 0.1
21
net sale 23198.65 29707.7
Asset 35614.73 50162.18
Asset +urno&er 0." 0.6
22
Asset 35614.73 50162.18
equit 10155.88 14284.08
)quity 5ulti0lier 3.5 3.5
23du 0ont Analysis 0.2 0.2
Mahindra & Mahindra
2012 2013 2014
liquidity ratio
"!!0."2 34020.1 3!5!4.43
"360.1" 26103.33 2"588.36
1.1 1.3 1.4
5632.33 25603.2 31240.89
7360.17 26103.33 27588.36
0.32 0.32 0.30
le&era'e %atio
3173.83 19860.26 258491.75
12171.09 19960.7 23306.86
0.3 1.0 1.1
3173.83 19860.26 258491.75
23911.98 76469.79 88270.26
0.13 0.26 0.2!
4346.27 14263.23 6495.96
162.75 629.75 676.36
26." 22.6 !.6
+urno&er
2463.64 2932.97 3070.11
35190.22 39409.5 43252.55
26 2" 26
1071.44 1225.65 1455.22
42074.53 48883.02 51778.53
! ! 10
1525.87 1465.69 1269.45
35473.19 41892.17 44892.59
16 13 10
4374.42 10971.88 11855.23
35627.85 39693.94 42920.09
45 101 101
1624.33 5261.01 8385.22
54705.87 62643.54 66930.97
11 31 46
Pro2tality %atio
5!41".63 62643.54 66!30.!"
21615.43 20360.23 21560.44
36.38 32.50 32.21
3126.66 4099.2 4666.93
59417.63 62643.54 66930.97
5.26 6.54 6.!"
3126.66 4099.2 4666.93
63869.2 76469.8 88270.3
0.05 0.05 0.05
3126.66 4099.2 4666.93
32810.07 39821.96 48798.61
0.10 0.10 0.10
6aluation
703 714 754
50.92 66.76 75.83
13.81 10."0 !.!4
900.27 997.3 1094.2
6139401.09 6139748.39 6139807.56
0.0001466381 0.0001624334 0.0001"82141
3126.66 4099.2 4666.93
6139401.09 6139748.39 6139807.56
50.!2 66."6 "5.83
50.92 66.76 75.83
703 714 754
".24 !.35 10.06
900.27 997.3 1094.2
703 714 754
128.06 13!.68 145.12
(9 Pont Analysis
3126.66 4099.2 4666.93
59417.63 62643.54 66930.97
0.1 0.1 0.1
59417.63 62643.54 66930.97
63869.18 76469.79 88270.26
0.! 0.8 0.8
63869.18 76469.79 88270.26
16770.21 19960.7 23306.86
3.8 3.8 3.8
0.2 0.2 0.2
4a&e
2010 74
1or5ula 2011 74
Current Assest:current Lia. 2012 92
2013 152
2014 169
#uic$ Assets: current lia.
det:equity i !ake "nl L"n& ter) +ebts
lon' ter5 dets:+A
);*+:*3+.
156.85 70.86 162.75 629.75 676.36
-A& %M:CMC. M&M and +A+A 1.11 0.83 0.!! 1.0!5
#uic$ %atio AL
#uic$ %atio A6 0.485 0.38 0.4"5 0.465
'ross 0ro2t ratio AL
'ross 0ro2t ratio A6 0.235 0.2" 0.35 0.345
3et Pro2t ratio AL
3et Pro2t ratio A6 0.0" 0.0! 0.065 0.06
%eturn on Assets AL
%eturn on Assets A6 0.065 0.0"5 0.0" 0.055
%eturn on ca0ital e50loyed AL
%eturn on ca0ital e50loyed A6 0.08 0.1"5 0.16 0.12
(ets Asset ratio AL
(ets Asset ratio A6 0.325 0.16 0.16 0.225
det equity AL
det equity A6 2.34 0.62 0.5" 0.!25
*nterest Co&era'e ratio AL
*nterest Co&era'e ratio A6 12.0"5 28.4 15.62 13.22
%a, Material +urno&er-days. AL
%a, Material +urno&er-days. A6 51 45 51 36
/or$ in 0ro'ress turno&er-days. AL
/or$ in 0ro'ress turno&er-days. 11 8 5 5
1inished stoc$ +urno&er in -days. AL
1inished stoc$ +urno&er in -days. 3" 18 11 10
Creditor turno&er -days. AL
Creditor turno&er -days. A6 56 80 86 103
(etor turno&er-days. AL
(etor turno&er-days. A6 23 21 14 25
Price )arnin' %atio AL
Price )arnin' %atio A6 12.675 9.165 8.57 7.52
)arnin' Per 7hare AL
)arnin' Per 7hare A6 40.3"5 !4.83 45.865 48.!
(i&idend 8ield AL
(i&idend 8ield A6
(9 P=*3+ AL
(9 P=*3+ A6 0.2" 0.355 0.3 0.225
1.4
0.52
0.35
0.065
0.055
0.115
0.25
0.8!5
6.795
2!
6
8
90
32
7.25
5!."15
0.205
2009910 2010911 2011912 2012913 2013914
0.00
208000.00
408000.00
608000.00
808000.00
1008000.00
1208000.00
C1=
A@is +itle
2009910 2010911 2011912 2012913 2013914
9508000.00
0.00
508000.00
1008000.00
1508000.00
2008000.00
2508000.00
PA+
A@is +itle
2009910 2010911 2011912 2012913 2013914
9508000.00
0.00
508000.00
1008000.00
1508000.00
2008000.00
2508000.00
PA+
A@is +itle

doc_433436094.xlsx
 

Attachments

Back
Top