Managerial Finance

profileSullah-bcu
AppendixCRSain.xlsx
Home>Business & Finance homework help>Management homework help>Managerial Finance

Sain

J SAINSBURY PLC
Ratios
3/9/19 3/10/18 3/11/17 3/12/16 3/14/15 3/15/14 3/16/13 3/17/12 3/19/11 3/20/10 3/21/09 3/22/08 3/24/07 3/25/06 3/26/05 3/27/04 3/29/03 3/30/02 3/31/01 3/31/00
GBP GBP GBP GBP GBP GBP GBP GBP GBP GBP GBP GBP GBP GBP GBP GBP GBP GBP GBP GBP
Original Documents PDF PDF PDF PDF PDF PDF PDF PDF PDF PDF PDF PDF PDF PDF PDF PDF PDF PDF PDF PDF
11 months 12 months 12 months 12 months 12 months 12 months 12 months 12 months 12 months 12 months 12 months 12 months 12 months 12 months 12 months 12 months 12 months 12 months 12 months 12 months
Cons. Cons. Cons. Cons. Cons. Cons. Cons. Cons. Cons. Cons. Cons. Cons. Cons. Cons. Cons. Cons. Cons. Cons. Cons. Cons.
Unqualified Unqualified Unqualified Unqualified Unqualified Unqualified Unqualified Unqualified Unqualified Unqualified Unqualified Unqualified Unqualified Unqualified Unqualified Unqualified Unqualified Unqualified Unqualified Unqualified
IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS UK GAAP UK GAAP UK GAAP UK GAAP
Profitability ratios
Return on Shareholders Funds (%) 3.08 5.52 7.32 8.61 -1.30 14.96 13.74 14.19 15.25 14.76 10.65 9.71 10.97 2.68 0.34 11.95 13.33 11.78 8.84 10.73
Return on Capital Employed (%) 2.34 3.50 4.51 5.35 -0.75 9.19 8.23 8.68 9.78 9.09 6.55 6.83 6.96 1.31 0.23 7.94 9.19 8.97 7.18 8.73
Return on Total Assets (%) 1.15 1.86 2.55 3.23 -0.44 5.43 6.21 6.47 7.26 6.75 4.64 4.98 4.98 0.82 0.13 4.84 5.54 5.16 4.19 4.82
Profit margin (%) 0.82 1.44 1.92 2.33 -0.30 3.75 3.38 3.58 3.92 3.67 2.46 2.69 2.78 0.65 0.10 3.56 3.83 3.33 2.52 3.13
Gross margin (%) 6.92 6.61 6.23 6.19 5.08 5.79 5.48 5.43 5.50 5.42 5.48 5.62 6.83 6.64 4.43 8.65 7.98 7.32 6.74 6.58
Berry ratio (x) 1.18 1.37 1.53 1.83 1.07 3.27 2.94 3.09 3.04 2.78 2.60 2.06 1.78 1.27 0.80 1.79 1.94 1.99 1.85 1.97
EBIT margin (%) 1.08 1.82 2.45 3.01 0.34 4.21 3.81 3.92 4.03 3.56 3.56 2.97 3.03 1.43 -1.08 3.83 3.87 3.64 3.09 3.25
EBITDA margin (%) 3.82 4.39 5.05 5.45 5.08 6.90 6.02 6.16 6.32 5.96 6.03 5.67 5.95 4.35 3.87 6.36 6.20 5.81 5.56 5.84
Operational ratios
Net Assets Turnover (x) 2.83 2.43 2.35 2.29 2.47 2.45 2.43 2.42 2.50 2.48 2.66 2.54 2.50 2.02 2.36 2.23 2.40 2.70 2.85 2.79
Fixed Assets Turnover (x) 2.11 2.01 1.95 1.88 1.98 1.97 2.16 2.16 2.18 2.22 2.23 2.26 2.25 1.80 2.11 2.01 2.21 2.34 2.59 2.33
Interest Cover (x) 3.41 3.92 4.70 4.28 0.60 6.65 6.55 6.79 8.13 5.95 4.15 4.63 5.46 1.67 1.12 8.18 7.35 5.46 4.12 8.07
Stock Turnover (x) 16.40 15.72 14.77 24.28 23.85 23.83 23.61 23.77 25.99 28.44 27.45 26.19 29.07 27.88 27.57 22.76 21.79 22.85 22.60 16.50
Debtors Turnover (x) 8.37 8.18 9.39 13.12 13.99 14.47 182.05 202.67 226.90 281.18 385.94 557.41 571.70 486.70 5.94 7.88 10.60 209.29 215.55 301.31
Debtor Collection (days) 43.62 44.60 38.86 27.81 26.10 25.22 2.00 1.80 1.61 1.30 0.95 0.65 0.64 0.75 61.45 46.31 34.43 1.74 1.69 1.21
Creditors Payment (days) 98.71 96.44 91.44 79.32 84.19 28.13 29.89 31.16 31.76 32.58 33.35 34.85 36.31 32.25 33.00 26.17 25.90 24.22 22.31 25.73
Structure ratios
Current ratio (x) 0.66 0.76 0.74 0.66 0.65 0.65 0.61 0.65 0.58 0.66 0.54 0.66 0.71 0.80 0.85 0.83 0.87 0.79 0.86 0.76
Liquidity ratio (x) 0.50 0.59 0.53 0.52 0.51 0.50 0.30 0.35 0.31 0.41 0.30 0.40 0.50 0.68 0.74 0.67 0.70 0.63 0.68 0.55
Shareholders liquidity ratio (x) 3.12 1.73 1.60 1.64 1.36 1.59 1.49 1.57 1.79 1.60 1.60 2.37 1.74 0.96 2.04 1.98 2.22 3.20 4.34 4.35
Solvency ratio (Asset based) (%) 37.45 33.68 34.82 37.50 33.49 36.29 45.16 45.62 47.58 45.75 43.62 51.30 45.42 30.49 37.65 40.53 41.58 43.79 47.37 44.94
Solvency ratio (Liability based) (%) 59.86 50.80 53.42 60.00 50.36 56.97 82.35 83.88 90.78 84.33 77.36 n.s. 83.20 43.86 60.38 68.15 71.19 77.90 90.01 81.62
Asset Cover (x) 24.20 12.30 9.68 7.75 6.60 7.35 4.85 4.72 4.87 4.61 4.61 4.62 4.58 4.00 6.82 5.81 6.50 9.25 10.67 10.98
Gearing (%) 43.25 68.16 66.72 66.38 78.26 71.73 69.98 66.18 57.28 63.81 66.09 44.54 65.97 169.92 58.00 59.03 49.53 38.37 30.65 41.02
Per employee ratios
Profit per employee (unit) 2,240 3,375 4,238 5,060 -673 8,393 7,505 7,841 8,328 7,533 4,789 4,858 4,995 1,081 154 5,370 6,136 5,263 3,889 4,352
Turnover per employee (unit) 271,856 234,785 220,927 217,045 222,196 223,822 221,933 218,783 212,508 205,180 194,358 180,903 179,592 166,954 158,203 150,889 160,350 158,175 154,516 139,133
Salaries/Turnover 10.93 11.01 10.97 10.81 10.28 10.17 9.96 9.75 10.04 10.39 10.59 10.97 10.41 11.16 10.76 11.67 10.98 11.13 10.46 11.12
Average Remuneration per employee (unit) 29,709 25,858 24,246 23,463 22,850 22,757 22,114 21,325 21,339 21,326 20,586 19,848 18,691 18,638 17,023 17,606 17,599 17,604 16,156 15,477
Shareholders Funds per employee (unit) 72,646 61,147 57,894 58,772 51,766 56,103 54,600 55,240 54,622 51,038 44,974 50,051 45,539 40,395 44,908 44,930 46,026 44,682 44,005 40,549
Working Capital per employee (unit) -24,459 -18,416 -16,874 -21,690 -26,047 7,607 -7,552 -8,391 -9,376 -10,370 -10,175 -10,041 -11,372 -8,420 18,070 14,956 11,104 -2,820 -1,891 -915
Total Assets per employee (unit) 194,003 181,526 166,276 156,722 154,551 154,579 120,905 121,099 114,794 111,562 103,114 97,566 100,272 132,505 119,281 110,854 110,681 102,037 92,894 90,230
http://fame1.be.bvdep.net/fame/1/Companies/JordansDocuments/DownloadLastFile?rid=internal:28957&closingDate=09%2f03%2f2019 http://fame1.be.bvdep.net/fame/1/Companies/JordansDocuments/DownloadLastFile?rid=internal:28957&closingDate=20%2f03%2f2010 http://fame1.be.bvdep.net/fame/1/Companies/JordansDocuments/DownloadLastFile?rid=internal:28957&closingDate=21%2f03%2f2009 http://fame1.be.bvdep.net/fame/1/Companies/JordansDocuments/DownloadLastFile?rid=internal:28957&closingDate=22%2f03%2f2008 http://fame1.be.bvdep.net/fame/1/Companies/JordansDocuments/DownloadLastFile?rid=internal:28957&closingDate=24%2f03%2f2007 http://fame1.be.bvdep.net/fame/1/Companies/JordansDocuments/DownloadLastFile?rid=internal:28957&closingDate=25%2f03%2f2006 http://fame1.be.bvdep.net/fame/1/Companies/JordansDocuments/DownloadLastFile?rid=internal:28957&closingDate=26%2f03%2f2005 http://fame1.be.bvdep.net/fame/1/Companies/JordansDocuments/DownloadLastFile?rid=internal:28957&closingDate=27%2f03%2f2004 http://fame1.be.bvdep.net/fame/1/Companies/JordansDocuments/DownloadLastFile?rid=internal:28957&closingDate=29%2f03%2f2003 http://fame1.be.bvdep.net/fame/1/Companies/JordansDocuments/DownloadLastFile?rid=internal:28957&closingDate=30%2f03%2f2002 http://fame1.be.bvdep.net/fame/1/Companies/JordansDocuments/DownloadLastFile?rid=internal:28957&closingDate=31%2f03%2f2001 http://fame1.be.bvdep.net/fame/1/Companies/JordansDocuments/DownloadLastFile?rid=internal:28957&closingDate=10%2f03%2f2018 http://fame1.be.bvdep.net/fame/1/Companies/JordansDocuments/DownloadLastFile?rid=internal:28957&closingDate=31%2f03%2f2000 http://fame1.be.bvdep.net/fame/1/Companies/JordansDocuments/DownloadLastFile?rid=internal:28957&closingDate=11%2f03%2f2017 http://fame1.be.bvdep.net/fame/1/Companies/JordansDocuments/DownloadLastFile?rid=internal:28957&closingDate=12%2f03%2f2016 http://fame1.be.bvdep.net/fame/1/Companies/JordansDocuments/DownloadLastFile?rid=internal:28957&closingDate=14%2f03%2f2015 http://fame1.be.bvdep.net/fame/1/Companies/JordansDocuments/DownloadLastFile?rid=internal:28957&closingDate=15%2f03%2f2014 http://fame1.be.bvdep.net/fame/1/Companies/JordansDocuments/DownloadLastFile?rid=internal:28957&closingDate=16%2f03%2f2013 http://fame1.be.bvdep.net/fame/1/Companies/JordansDocuments/DownloadLastFile?rid=internal:28957&closingDate=17%2f03%2f2012 http://fame1.be.bvdep.net/fame/1/Companies/JordansDocuments/DownloadLastFile?rid=internal:28957&closingDate=19%2f03%2f2011

Tesco

TESCO PLC
Ratios
2/23/19 2/24/18 2/25/17 2/27/16 2/28/15 2/22/14 2/23/13 2/25/12 2/26/11 2/27/10 2/28/09 2/23/08 2/24/07 2/25/06 2/26/05 2/28/04 2/22/03 2/23/02 2/28/01 2/29/00
GBP GBP GBP GBP GBP GBP GBP GBP GBP GBP GBP GBP GBP GBP GBP GBP GBP GBP GBP GBP
Profitability ratios
Return on Shareholders Funds (%) 11.27 12.39 2.25 1.88 -90.17 15.35 11.78 21.58 21.38 21.76 22.83 23.72 25.25 23.83 21.79 20.14 20.89 21.72 19.68 19.56
Return on Capital Employed (%) 5.90 5.07 0.55 0.67 -26.13 7.85 6.29 12.05 11.99 10.58 10.55 14.08 15.93 14.86 13.68 12.36 12.23 13.73 14.35 14.62
Return on Total Assets (%) 3.41 2.89 0.32 0.37 -14.42 4.50 3.91 7.55 7.49 6.90 6.41 9.29 10.69 9.91 9.61 8.62 8.25 8.86 8.98 9.45
Profit margin (%) 2.62 2.26 0.26 0.30 -10.24 3.55 3.02 5.94 5.80 5.58 5.44 5.93 6.22 5.66 5.78 5.19 5.17 5.08 5.02 4.96
Gross margin (%) 6.48 5.83 5.19 5.24 -3.39 6.31 6.31 8.15 8.30 8.10 7.76 7.67 8.12 7.67 7.96 7.82 7.58 7.56 7.57 7.61
Berry ratio (x) 2.08 2.19 1.51 1.57 -0.57 2.59 2.15 3.41 3.27 3.26 3.57 3.72 3.92 3.76 3.58 3.57 3.89 3.84 3.76 3.57
EBIT margin (%) 3.37 3.20 1.82 1.92 -9.30 4.14 3.38 6.17 6.25 6.07 5.90 5.90 6.21 5.78 5.74 5.63 5.63 5.59 5.56 5.48
EBITDA margin (%) 5.62 6.27 4.73 4.75 0.07 7.93 7.84 8.56 8.60 8.67 7.98 7.94 8.31 7.88 8.08 8.07 7.93 7.85 7.82 7.79
Efficiency ratios
Net Assets Turnover (x) 2.25 2.24 2.11 2.25 2.55 2.21 2.08 2.03 2.07 1.90 1.94 2.38 2.56 2.62 2.37 2.38 2.37 2.70 2.86 2.95
Fixed Assets Turnover (x) 1.76 1.85 1.84 1.87 1.93 1.71 1.75 1.70 1.70 1.66 1.70 1.98 2.11 2.12 2.00 2.00 1.87 2.06 2.09 2.20
Interest Cover (x) 4.12 3.06 1.17 1.18 -8.65 5.01 4.37 7.89 8.32 6.49 7.18 12.21 13.28 10.27 9.35 7.20 7.00 6.95 7.27 7.35
Stock Turnover (x) 24.42 25.40 24.30 22.40 21.06 17.77 17.31 17.94 19.27 20.85 20.35 19.46 22.08 26.95 25.95 25.70 23.10 25.46 25.05 25.26
Debtors Turnover (x) 106.87 123.37 114.12 109.74
Debtor Collection (days) 3.42 2.96 3.20 3.33
Creditors Payment (days) 32.84 34.39 32.08 30.48 29.75 33.49 33.99 33.77 34.64 32.61 31.90 30.37 28.39 26.20 30.29 28.83 30.43 28.24 26.75 24.23
Structure ratios
Current ratio (x) 0.61 0.71 0.79 0.75 0.60 0.61 0.69 0.68 0.65 0.73 0.78 0.61 0.56 0.52 0.57 0.56 0.45 0.43 0.39 0.38
Liquidity ratio (x) 0.49 0.60 0.68 0.63 0.45 0.44 0.49 0.49 0.47 0.56 0.63 0.38 0.32 0.33 0.35 0.35 0.24 0.23 0.20 0.17
Shareholders liquidity ratio (x) 1.10 0.69 0.32 0.55 0.41 1.05 1.15 1.26 1.28 0.95 0.86 1.46 1.71 1.66 1.69 1.59 1.41 1.72 2.70 2.96
Solvency ratio (Asset based) (%) 30.29 23.36 14.04 19.65 15.99 29.33 33.20 35.00 35.03 31.71 28.09 39.17 42.35 41.57 44.13 42.80 39.49 40.79 45.65 48.32
Solvency ratio (Liability based) (%) 43.46 30.48 16.33 24.45 19.04 41.51 49.70 53.85 53.91 46.44 39.07 64.39 73.46 71.15 78.97 74.83 65.26 68.90 84.00 93.51
Asset Cover (x) 5.47 4.44 3.92 4.10 4.15 5.39 4.98 5.12 4.87 3.92 3.72 5.05 5.98 6.03 4.52 4.27 4.09 4.95 6.09 6.33
Gearing (%) 161.26 233.35 454.71 213.35 273.85 108.61 91.93 91.70 86.66 116.35 149.14 87.06 74.54 78.78 64.82 73.67 91.38 85.10 63.48 51.58
Per employee ratios
Profit per employee (unit) 3,604 3,958 312 336 -16,514 5,765 4,707 9,444 9,196 8,530 8,115 8,107 8,335 8,186 8,075 7,164 7,232 6,991 6,925 6,916
Turnover per employee (unit) 137,589 175,322 120,376 112,896 161,322 162,190 155,667 158,929 158,514 152,845 149,244 136,797 133,972 144,507 139,822 137,972 139,955 137,682 137,888 139,337
Salaries/Turnover 11.96 12.58 13.17 12.80 13.28 11.44 10.88 10.62 11.11 10.89 10.67 11.19 10.78 10.82 10.40 10.50 10.07 9.88 9.75 9.92
Average Remuneration per employee (unit) 16,461 22,057 15,849 14,452 21,418 18,555 16,929 16,886 17,607 16,638 15,928 15,309 14,437 15,636 14,544 14,480 14,098 13,598 13,449 13,825
Shareholders Funds per employee (unit) 31,987 31,959 13,859 17,891 18,315 37,551 39,965 43,771 43,016 39,201 35,542 34,172 33,008 34,356 37,065 35,574 34,626 32,190 35,188 35,353
Working Capital per employee (unit) -5,457 -8,194 -4,570 -3,358 -5,488 -5,754 -5,504 -5,844 -6,816 -6,325 -5,711 -4,356 -4,355 -5,011 -6,215 -5,530 -5,612 -5,245 -4,599 -3,736
Total Assets per employee (unit) 105,590 136,809 98,710 91,058 114,519 128,012 120,375 125,049 122,808 123,605 126,514 87,241 77,940 82,641 83,999 83,113 87,686 78,908 77,078 73,160