analysis of two companies ( i have done the whole question but i need more than 1200 words of this solves question, ill provide data and answer i just need more than 1200 words)
Saj 
2017GRAPHS.docx|
|
2017 |
2016 |
2015 |
2014 |
2013 |
|
Tesco |
6.70 |
4.10 |
-27.90 |
9.80 |
7.70 |
|
Morrison |
5.34 |
3.41 |
-11.49 |
-2.24 |
10.73 |
|
|
2017 |
2016 |
2015 |
2014 |
2013 |
|
Tesco |
0.0279 |
0.0215 |
-0.131 |
0.0524 |
0.0436 |
|
Morrison |
3.63 |
2.38 |
-8.64 |
-1.64 |
8.35 |
|
|
2017 |
2016 |
2015 |
2014 |
2013 |
|
Asset turnover |
1.2195 |
1.2398 |
1.4087 |
1.267 |
1.2932 |
|
Morrison |
3.63 |
2.38 |
-8.64 |
-1.64 |
8.35 |
|
|
2017 |
2016 |
2015 |
2014 |
2013 |
|
Net Profit Margin |
0.0229 |
0.0173 |
-0.093 |
0.0414 |
0.0338 |
|
Morrison |
1.99 |
1.35 |
-4.71 |
-1.00 |
4.85 |
|
|
2017 |
2016 |
2015 |
2014 |
2013 |
|
Gross Profit Margin |
0.054 |
0.0515 |
-0.034 |
0.0631 |
0.0631 |
|
Morrison |
3.70 |
3.83 |
4.53 |
6.07 |
6.66 |
|
|
2017 |
2016 |
2015 |
2014 |
2013 |
|
Receivable Collection Period |
10.803 |
10.776 |
12.43 |
12.577 |
14.217 |
|
|
3.06 |
2.99 |
3.86 |
3.72 |
3.38 |
|
|
2017 |
2016 |
2015 |
2014 |
2013 |
|
Payable Payment Period |
63.473 |
60.573 |
56.238 |
64.943 |
66.67 |
|
|
47.56 |
38.26 |
30.32 |
29.65 |
30.24 |
|
|
2017 |
2016 |
2015 |
2014 |
2013 |
|
Inventory Turnover Period |
15.877 |
17.179 |
16.76 |
21.919 |
22.5 |
|
|
26.57 |
26.17 |
25.56 |
20.75 |
23.20 |
|
|
|
|
|
|
|
|
|
2017 |
2016 |
2015 |
2014 |
2013 |
|
Current Ratio |
0.7013 |
0.7522 |
0.6038 |
0.7707 |
0.7002 |
|
|
0.41 |
0.48 |
0.54 |
0.50 |
0.57 |
|
|
2017 |
2016 |
2015 |
2014 |
2013 |
|
Asset Test Ratio |
0.596 |
0.6289 |
0.4545 |
0.5937 |
0.5 |
|
|
0.20 |
0.25 |
0.25 |
0.20 |
0.24 |
|
|
2017 |
2016 |
2015 |
2014 |
2013 |
|
Gearing Ratio |
66.37 |
62.71 |
65.95 |
45.08 |
41.28 |
|
|
49.86 |
74.84 |
92.13 |
79.22 |
57.65 |
|
|
2017 |
2016 |
2015 |
2014 |
2013 |
|
|
|
Interest Coverage Ratio |
2.03 |
1.4 |
-8.76 |
4.66 |
4.77 |
|
|
Payable PAyment Period
63.472560917975763 60.572933816266058 56.238430958444624 64.943238114430613 66.669575382386355 47.557148986000001 38.261381962999998 30.322609419999999 29.645927602 30.242051225000001
Inventory Turnover Period
Inventory Turnover Period 2017 2016 2015 2014 2013 15.876765156241138 17.179298456293946 16.760435430772098 21.919492165852184 22.499629550356456 2017 2016 2015 2014 2013 26.574918567000001 26.172077922 25.556231003000001 20.751173709 23.195902689
Current Ratio
Current Ratio 2017 2016 2015 2014 2013 0.70133736374461852 0.75215582834533834 0.60378692249431964 0.77066217955062855 0.7002085226968936 2017 2016 2015 2014 2013 0.41061452500000001 0.47615580600000001 0.54025516900000004 0.497737557 0.57497857799999996
Asset Test Ratio
0.5959512686635523 0.6288931723648169 0.45448119161827821 0.59368504404632283 0.5000267336790889 0.19622904999999999 0.25191117600000001 0.25076990799999999 0.201183432 0.24035989699999999
Gearing Ratio
Gearing Ratio 2017 2016 2015 2014 2013 66.37 62.71 65.95 45.08 41.28 2017 2016 2015 2014 2013 49.864632045 74.840255591000002 92.125765164000001 79.219948849000005 57.648183555999999
Interest Coverage Ratio 2017 2016 2015 2014 2013 2.0299999999999998 1.4 -8.76 4.66 4.7699999999999996
Profitability Ratio
Tesco 2017 2016 2015 2014 2013 6.7 4.0999999999999996 -27.9 9.8000000000000007 7.7 Morrison 2017 2016 2015 2014 2013 5.3374938409999997 3.408733899 -11.488250653 -2.2403258660000001 10.728670816999999
Return On Asset
Tesco 2017 2016 2015 2014 2013 2.7915294528166094E-2 2.1501457725947522E-2 -0.13099923101280136 5.2447970656247511E-2 4.364738973448503E-2 Morrison 2017 2016 2015 2014 2013 3.6300681340000001 2.3812136509999999 -8.6396858299999995 -1.6404138319999999 8.3499572529999995
Asset Turnover
Asset turnover 2017 2016 2015 2014 2013 1.2194840032277059 1.239818695335277 1.4086940787985707 1.2669842915238019 1.2931835863472241 Morrison 2017 2016 2015 2014 2013 3.6300681340000001 2.3812136509999999 -8.6396858299999995 -1.6404138319999999 8.3499572529999995
Net Profit Margin
Net Profit Margin 2017 2016 2015 2014 2013 2.2891070694064417E-2 1.7342420957874818E-2 -9.2993385139040527E-2 4.1395912330663816E-2 3.3751889673896279E-2 Morrison 2017 2016 2015 2014 2013 1.991787706 1.3459868500000001 -4.7098001900000002 -0.99547511300000002 4.8520644730000004 2017 2016 2015 2014 2013
Gross Profit Margin
Gross Profit Margin 2017 2016 2015 2014 2013 5.3972852620848756E-2 5.1512869031653592E-2 -3.3909190161197096E-2 6.3092971663231426E-2 6.3076543362231202E-2 Morrison 2017 2016 2015 2014 2013 3.7016608450000001 3.8270686020000002 4.525451951 6.0746606329999997 6.6570986970000003
Receivable Collection Period
10.803065257435128 10.775724284900704 12.429596686147326 12.576899476060859 14.21690371147379 3.064595207 2.9884629700000001 3.8635823029999998 3.716063348 3.3848531679999998
