0% found this document useful (0 votes)
19 views24 pages

Premier and Hilton Food Group Ratios Analysis

The document presents financial ratios for Premier Food Group and Hilton Food Group for the years 2022 and 2021, highlighting key metrics such as profitability, efficiency, liquidity, and capital structure. Premier Food Group shows a decline in several performance metrics, including ROCE and ROE, while Hilton Food Group exhibits a decrease in profitability ratios but improved asset turnover. Both companies face challenges in maintaining liquidity and managing debt levels, with varying impacts on their financial stability.

Uploaded by

Bilal Ahmed
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
19 views24 pages

Premier and Hilton Food Group Ratios Analysis

The document presents financial ratios for Premier Food Group and Hilton Food Group for the years 2022 and 2021, highlighting key metrics such as profitability, efficiency, liquidity, and capital structure. Premier Food Group shows a decline in several performance metrics, including ROCE and ROE, while Hilton Food Group exhibits a decrease in profitability ratios but improved asset turnover. Both companies face challenges in maintaining liquidity and managing debt levels, with varying impacts on their financial stability.

Uploaded by

Bilal Ahmed
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

PREMIER FOOD GROUP

Working Working
Ratios Formula 2022 2021
2022 2021

Profitablity and Performance

2533.5 / - 2274.9 / -
Capital Employed Total Assets - Current liabilities 258.7 2,275 263.7 2,011
131.1 152.6
ROCE Operating profit/CE /2274.8 5.8% /2011.2 8%
131.1 152.6
ROTA Operating profit/Total Assets /2533.5 5.2% /2274.9 6.7%

ROS Operating profit/Sales 131.1 /900.5 14.56% 152.6 /947 16.11%


900.5
Asset Turnover (times) sales/Total Assets /2533.5 0.36 947 /2274.9 0.42
Net cash inflow from
Quality of Profit (%) operations/operating profit 90.1 /131.1 69% 85.6 /152.6 56%
Cash received from
Quality of Sales (%) customers/sales 13.1 /900.5 1.45% 5.7 /947 0.60%
Net cash inflow from 85.6
Cash Return on CE (%) operations/CE 90.1 /2274.8 4.0% /2011.2 4.3%

ROE (%) Profit for the year/Equity 77.5 /1506.9 5.14% 106 /1183.6 8.96%
Profit for the year/No. of shares
EPS (pence) in issue Given 0.09 Given 0.125
0.946
P/E Ratio (times) market price per share/EPS 1.156 /0.09 12.84 /0.125 7.57
0.125
Earning Yield (%) EPS/Market price per share 0.09 /1.156 8% /0.946 13%
Dividend per share/Market price
Dividend Yield (%) per share 0.012 /1.156 1.0% 0.01 /0.946 1.1%
Efficiency and Effectiveness

Debtors collection (96.5 /900.5 (83.4 /947 )


period (days) [Trade debtors/Sales] x 365 ) *365 28 *365 23

(254 (249.8
Creditors payment [Trade creditors/purchases] x /573.4 ) /611.7 )
period (days) 365 *365 162 *365 149

(68.8
Stock turnover period (78.1 /573.4 /611.7 )
(days) [Stock/Cost of sales] x 365 ) *365 50 *365 41
Wages to sales ratio
(%) Wages/Sales 155.5 /900.5 17.3% 153.6 /947 16.2%

Liquidity and Stability

156.5
Current Ratio (times) Current assets/Current liabilities 231.3 /258.7 0.89 /263.7 0.59

(156.5 -
(Current assets-Stock)/Current (231.3 -78.1 68.8 )
Quick Ratio (times) liabilities ) /258.7 0.59 /263.7 0.33
Operating Profit / Interest
Interest cover (times) Expense 131.1 /29 5 152.6 /36.2 4

(NCI after tax from operations


Cash dividend cover +/- Net Interest + div. (90.1 -21.2 )
(times) Received ) / Dividend paid /8.5 8.11 NA NA

Capital Structure and Finanial Risk


L-T debt to equity ratio 767.9 827.6
(%) Long term loan / Equity /1506.9 51.0% /1183.6 69.9%

Total debt to total (L-T loans + Short-term loans)/ 1026.6 1091.3


assets (%) Total Assets /2533.5 40.5% /2274.9 48.0%

Total owing to total Total Liabilities (S-T + L-T) / 1026.6 1091.3


assets (%) (Total Assets /2533.5 40.5% /2274.9 48.0%

Profit on ord. Activities before


interest and tax / (Profit on ord. 152.6
Capital gearing (times) Activities before tax) 131.1 /102.6 1.28 /122.8 1.24

Profit available for paying


ordinary dividends / (Ordinary
Dividend cover (times) Dividends) 77.5 /8.5 9.12 NA NA
Working
2020
2020
2022 2021

Total Assets 2,533.5 2,274.9


2274.9 / -
263.7 2,685 / Current liabilities 258.7 263.7
95.3
/2685.4 3.5% - Operating profit 131.1 152.6
95.3
/3029.8 3.1% Revenue/Sales 900.5 947
95.3
/847.1 11.25% NCI from Oper. 90 85.6
847.1
/3029.8 0.28 Trade Receivables 96.5 83.4

85.9 /95.3 90% Cash received from customers 13.1 5.70


###

0.1 /847.1 0.01% Equity 1,506.9 1,183.6


85.9
/2685.4 3.2% Net profit 77.5 106.0
46.5
/1680 2.77% Current Asset 231.3 156.5

Given 0.055 Share price 1.16 0.95


0.245
/0.055 4.45 Dividend per share 0.01 0.01
0.055
/0.245 22% Trade Payables 254.0 249.8

0 /0.245 0.0% Purchases (Cost of sales) 573.4 611.7


Inventory 78.1 68.8
Wages 155.5 153.6
(89.1
/847.1 )
*365 28 EBIT
(249.7
/549.6 )
*365 166 Interest Expense 29.0 36.2
(68
/549.6 )
*365 45 Dividend Paid 8.5 0.0
145.5
/847.1 17.2% Interest paid 21.2 34.1
Long term liabilities 767.90 827.60
Total Liabilities 1,026.60 1,091.30
Profit before tax 102.60 122.80
335.9
/344.4 0.98

(335.9 -
68 )
/344.4 0.78

95.3 /44.1 2

(85.9 -
38 ) /0 NA

1005.4
/1680 59.8%

1349.8
/3029.8 44.6%

1349.8
/3029.8 44.6%

95.3 /53.6 1.78

NA NA
2020

3,029.8

344.4

95.3

847.1

85.9

89.1 89.2

0.10

1,680.0

46.5

335.9

0.25

0.00

249.7

549.6
68.0
145.5

44.1

0.0
38.0
1,005.40
1,349.80
53.60
HILTON FOOD GROUP
Working Working
Ratios Formula 2022 2021
2022 2021

Profitablity and Performance

1295786- 1167424-
Capital Employed Total Assets - Current liabilities 473886 821,900 626366 541,058
54026 63432
ROCE Operating profit/CE /821900 6.6% /541058 12%
54026 63432
ROTA Operating profit/Total Assets /1295786 4.2% /1167424 5.4%
54026 63432
ROS Operating profit/Sales /3847600 1.40% /3301970 1.92%
3847600 3301970
Asset Turnover (times) sales/Total Assets /1295786 2.97 /1167424 2.83
Net cash inflow from 59663 86005
Quality of Profit (%) operations/operating profit /54026 110% /63432 136%
Cash received from 40772 30746
Quality of Sales (%) customers/sales /3847600 1.06% /3301970 0.93%
Net cash inflow from 59663 86005
Cash Return on CE (%) operations/CE /821900 7.3% /541058 15.9%
19492 39282
ROE (%) Profit for the year/Equity /305317 6.38% /307949 12.76%
Profit for the year/No. of shares
EPS (pence) in issue Given 0.198 Given 0.45

P/E Ratio (times) market price per share/EPS 5.53 /0.198 27.93 11.4 /0.45 25.33

Earning Yield (%) EPS/Market price per share 0.198 /5.53 4% 0.45 /11.4 4%
Dividend per share/Market price
Dividend Yield (%) per share 0.215 /5.53 3.9% 0.272 /11.4 2.4%
Efficiency and Effectiveness

(271160 (230388
Debtors collection /3847600 ) /3301970 )
period (days) [Trade debtors/Sales] x 365 *365 19 *365 18

(426203 (387215
Creditors payment [Trade creditors/purchases] x /3464837 ) /2982155 )
period (days) 365 *365 45 *365 47

(206729 (156517
Stock turnover period /3464837 ) /2982155 )
(days) [Stock/Cost of sales] x 365 *365 22 *365 19
Wages to sales ratio 211054 182736
(%) Wages/Sales /3847600 5.5% /3301970 5.5%

Liquidity and Stability

571108 533427
Current Ratio (times) Current assets/Current liabilities /473886 1.21 /626366 0.85

(571108 - (533427 -
(Current assets-Stock)/Current 206729 ) 156517 )
Quick Ratio (times) liabilities /473886 0.77 /626366 0.60
Operating Profit / Interest 54026 63432
Interest cover (times) Expense /24768 2 /16044 4

(NCI after tax from operations (59663 - (86005 -


Cash dividend cover +/- Net Interest + div. 24768 ) 16044 )
(times) Received ) / Dividend paid /26756 1.30 /24084 2.90

Capital Structure and Finanial Risk


L-T debt to equity ratio 516583 233109
(%) Long term loan / Equity /305317 169.2% /307949 75.7%

Total debt to total (L-T loans + Short-term loans)/ 990469 859475


assets (%) Total Assets /1295786 76.4% /1167424 73.6%

Total owing to total Total Liabilities (S-T + L-T) / 990469 859475


assets (%) (Total Assets /1295786 76.4% /1167424 73.6%

Profit on ord. Activities before


interest and tax / (Profit on ord. 54026 63432
Capital gearing (times) Activities before tax) /29614 1.82 /47398 1.34

Profit available for paying


ordinary dividends / (Ordinary 19492 39282
Dividend cover (times) Dividends) /26756 0.73 /24084 1.63
Working
2020
2020
2022 2021

Total Assets 1,295,786.0 1,167,424.0


1055292-
382429 672,863 Current liabilities 473,886.0 626,366.0
66867
/672863 9.9% Operating profit 54,026.0 63,432.0
66867
/1055292 6.3% Revenue/Sales 3,847,600.0 3,301,970.0
66867
/2774036 2.41% NCI from Oper. 59,663 86,005.0
2774036 /
1055292 2.63 Trade Receivables 271,160.0 230,388.0
91656
/66867 137% Cash received from customers 40,772.0 30,746.0
-14969
/2774036 -0.54% Equity 305,317.0 307,949.0
91656
/672863 13.6% Net profit 19,492.0 39,282.0
42040
/221938 18.94% Current Asset 571,108.0 533,427.0

Given 0.486 Share price 5.53 11.4


11.4
/0.486 23.46 Dividend per share 0.22 0.27
0.486
/11.4 4% Trade Payables 426,203.0 387,215.0
0.224
/11.4 2.0% Purchases (Cost of sales) 3,464,837.0 2,982,155.0
Inventory 206,729.0 156,517.0
Wages 211,054.0 182,736.0
(199642 /
2774036 )
*365 19 EBIT
(332354 /
2452093 )
*365 49 Interest Expense 24,768.0 16,044.0
(116941 /
2452093 )
*365 17 Dividend Paid 26,756.0 24,084.0
161986
/2774036 5.8% Interest paid 24,768.0 16,044.0
Long term liabilities 516,583.00 233,109.00
Total Liabilities 990,469.00 859,475.00
Profit before tax 29,614.00 47,398.00
440399
/382429 1.15

(440399 -
116941 ) /
382429 0.85 1,143.1 1,041.9
66867
/12861 5

(91656 -
12861 )
/20097 3.92

450925
/221938 203.2%

833354
/1055292 79.0%

833354
/1055292 79.0%

66867
/54028 1.24

42040
/20097 2.09
2020

1,055,292.0

382,429.0

66,867.0

2,774,036.0

91,656.0

199,642.0 214,611.0

-14,969.0

221,938.0

42,040.0

440,399.0

11.4

0.22

332,354.0

2,452,093.0
116,941.0
161,986.0

12,861.0

20,097.0
12,861.0
450,925.00
833,354.00
54,028.00

995.0
CRANSWICK PLC
Working Working
Ratios Formula 2022 2021
2022 2021

Profitablity and Performance

1143.1 - 1041.9 -
Capital Employed Total Assets - Current liabilities 259.8 883.3 232.2 809.7

ROCE Operating profit/CE 133.6 / 883.3 15.1% 117.6 / 809.7 14.5%


117.6 /
ROTA Operating profit/Total Assets 133.6 / 1143.1 11.7% 1041.9 11.3%
117.6/
ROS Operating profit/Sales 133.6 / 2008.5 6.65% 1898.4 6.19%
1898.4/1041.
Asset Turnover (times) sales/Total Assets 2008.5/1143.1 1.76 9 1.82
Net cash inflow from
Quality of Profit (%) operations/operating profit 160/140.6 120% 181.4/132.5 154%

Quality of Sales (%) Cash received from customers/sales 22.7/2008.5 1.13% 8.1/1898.4 0.43%

Cash Return on CE (%) Net cash inflow from operations/CE 160/883.3 18.1% 181.4/809.7 22.4%

ROE (%) Profit for the year/Equity 103.5/768.9 13.46% 92.5/686.1 13.48%
Profit for the year/No. of shares in
EPS (pence) issue Given in I.S 1.957 Given in I.S 1.764

P/E Ratio (times) market price per share/EPS 35.86/1.957 18.32 36/1.764 20.41

Earning Yield (%) EPS/Market price per share 1.957/35.86 5% 1.764/36 5%


Dividend per share/Market price per
Dividend Yield (%) share 0.71/35.86 2.0% 0.62/36 1.7%
Efficiency and Effectiveness

Debtors collection period (244.4/2008.5 (221.7/1898.


(days) [Trade debtors/Sales] x 365 )*365 32 4)*365 31

Creditors payment period (238.7/1730.3 (217.2/1640.


(days) [Trade creditors/purchases] x 365 )*365 50 6)*365 48
Stock turnover period (105.2/1730.3 (81.8/1640.6)
(days) [Stock/Cost of sales] x 365 )*365 22 *365 18
264.4 /
Wages to sales ratio (%) Wages/Sales 291.1 / 2008.5 14.5% 1898.4 13.9%

Liquidity and Stability

Current Ratio (times) Current assets/Current liabilities 400.5/259.8 1.54 384.5/232.2 1.66
(Current assets-Stock)/Current (400.5- (384.5-
Quick Ratio (times) liabilities 105.2/259.8 1.14 81.8/232.2 1.30

Interest cover (times) Operating Profit / Interest Expense 133.6/3.7 36 117.6/2.8 42

(NCI after tax from operations +/-


Cash dividend cover Net Interest + div. Received ) / (181.4-0.5)/
(times) Dividend paid (160-1.6)/32.8 4.83 27.9 6.48

Capital Structure and Financial Risk


L-T debt to equity ratio
(%) Long term loan / Equity 114.4/768.9 14.9% 123.6/686.1 18.0%

Total debt to total assets (L-T loans + Short-term loans)/


(%) Total Assets 374.2/1143.1 32.7% 355.8/1041.9 34.1%

Total owing to total assets Total Liabilities (S-T + L-T) / (Total


(%) Assets 374.2/1143.1 32.7% 355.8/1041.9 34.1%

Profit on ord. Activities before


interest and tax / (Profit on ord.
Capital gearing (times) Activities before tax) 133.6 / 129.9 1.03 117.6 / 114.8 1.02

Profit available for paying ordinary


Dividend cover (times) dividends / (Ordinary Dividends) 103.5/32.8 3.16 92.5/27.9 3.32
Working
2020
2020
2022 2021

Total Assets 1,143.1 1,041.9

995 - 213.8 781.2 Current liabilities 259.8 232.2


106.8/781.
2 13.7% Operating profit 133.6 117.6

106.8/995 10.7% Revenue/Sales 2,008.5 1,898.4


106.8/1667
2.2 6.41% NCI from Oper. 160 181.4

1667.2/995 1.68 Trade Receivables 244.4 221.7

117/105.1 110% Cash received from customers 22.7 8.1


51.9/1667.
2 3.11% Equity 768.9 686.1

117/781.2 15.0% Net profit 103.5 92.5

82.7/614.5 13.46% Current Asset 400.5 384.5


Given in
I.S 1.591 Share price 35.86 36.0

34.8/1.591 21.86 Dividend per share 0.71 0.62

1.591/34.8 5% Trade Payables 238.7 217.2

0.57/34.8 1.6% Purchases (Cost of sales) 1,730.3 1,640.6


Inventory 105.2 81.8
Wages 291.1 264.4
(213.6/672.
2)*365 34 EBIT 201.7 196.7

(191.4/144
0.5)*265 48 Interest Expense 3.70 2.80
(75.5/1440.
5)*265 19 Dividend Paid 32.8 27.9
208.7/1667
2.2 12.5% Interest paid 1.6 0.5
Long term liabilities 114.40 123.60
Total Liabilities 374.20 355.80
Profit before tax 129.90 114.80
354.7/213.
8 1.66
(354.7-
75.5/213.8 1.31 1,143.1 1,041.9

106.8/2.8 38

(117-1.2)/
22.6 5.12

167.2/614.
5 27.2%

381/995 38.3%

381/995 38.3%

106.8/104 1.03

82.7/22.6 3.66
2020

995.0

213.8

106.8

1,667.2

117.0

213.6 161.7

51.9

614.5

82.7

354.7

34.8

0.57

191.4

1,440.5
75.5
208.7

155.3

2.80

22.6

1.2
167.20
381.00
104.00
995.0
2022 2021 2020 2022 2021 2020
ROCE 15.1% 14.5% 13.7% ROCE 6.6% 11.7% 9.9%
ROTA 11.7% 11.3% 10.7% ROTA 4.2% 5.4% 6.3%
ROS 6.7% 6.2% 6.4% ROS 1.4% 1.9% 2.4%
Quality of
Quality of Profit (%) 119.8% 154.3% 109.6% Profit (%) 110.4% 135.6% 137.1%
Quality of
Quality of Sales (%) 1.1% 0.4% 3.1% Sales (%) 1.1% 0.9% -0.5%
Cash
Return on
Cash Return on CE (%) 18.1% 22.4% 15.0% CE (%) 7.3% 15.9% 13.6%
ROE (%) 13.5% 13.5% 13.5% ROE (%) 6.4% 12.8% 18.9%
cranswick hilton

Hilton Profitability a
160.0%
140.0%
120.0%
100.0%
CRANSWICK
80.0% Profitablity and pe
60.0%
180.0%
160.0% 40.0%
140.0% 20.0%
120.0% 0.0%
100.0%
-20.0% OCE TA RO
S
80.0% R RO ofi
t
60.0% Pr
40.0% f
yo
20.0% a lit
0.0% Qu Q
E A S )
OC OT RO ( % ( %
R R fit es
Pro S al
of 2022of 202
l ity ity
ua u al
Q Q sh
Ca

2022 2021 2020

cranswick hilton
2022 2021 2020 2022 2021 2020
Debtors collection period (d 32.25 30.95 33.95 Debtors coll 18.68 18.49 19.07
Creditors payment period (d 50.35 48.32 48.50 Creditors pa 44.90 47.39 49.47
Stock turnover period (days 22.19 18.20 19.13 Stock turnov 21.78 19.16 17.41

Cranswick
60.00 Hilton
60.00
50.00
50.00
40.00
Cranswick
60.00 Hilton
60.00
50.00
50.00
40.00
40.00
30.00
30.00
20.00
20.00
10.00
10.00
-
2022 2021 2020
-
2022 20
Debtors collection period (days) Creditors payment period (days)
Stock turnover period (days) Debtors collection period (days) C
Stock turnover period (days)
cranswick hilton
2022 2021 2020 2022 2021 2020
Current Ratio (times) 1.54 1.66 1.66 Current Rati 1.21 0.85 1.15
Quick Ratio (times) 1.14 1.30 1.31 Quick Ratio 0.77 0.60 0.85
Interest cover (times) 36.11 42.00 38.14 Interest cov 2.18 3.95 5.20
Cash dividend cover (tim 4.83 6.48 5.12 Cash divide 1.30 2.90 3.92

Cranswick
45.00
40.00
35.00 6.00
30.00
5.00
25.00
20.00 4.00
15.00
3.00
10.00
5.00 2.00
-
Current Ratio Quick Ratio (times) Interest cover Cash dividend cover 1.00
(times) (times) (times)
-
2022 2021 2020 Current Ratio Quick
(times)

cranswick hilton
2022 2021 2020 2022 2021 2020
Current Ratio (times) 1.54 1.66 1.66 Current Rati 1.21 0.85 1.15
Quick Ratio (times) 1.14 1.30 1.31 Quick Ratio 0.77 0.60 0.85
Interest cover (times) 36.11 42.00 38.14 Interest cov 2.18 3.95 5.20
Cash dividend cover (tim 4.83 6.48 5.12 Cash divide 1.30 2.90 3.92
2022 2021 2020
ROCE 5.8% 7.6% 3.5%
ROTA 5.2% 6.7% 3.1%
ROS 14.6% 16.1% 11.3%
Quality of
Profit (%) 68.7% 56.1% 90.1%
Quality of
Sales (%) 1.5% 0.6% 0.0%
Cash
Return on
CE (%) 4.0% 4.3% 3.2%
ROE (%) 5.1% 9.0% 2.8%
premier

Hilton Profitability and Performance


Premier Profitability and Performance
100.0%
80.0%
K Profitablity and performance
60.0%
40.0%
20.0%

CE S ) 0.0% ) ) )
TA RO % (% CE ( % TA ( % S ) ) ) )
RO RO t( s E E RO % % (% (%
ro
fi e O
al R C RO RO t( s(
fP fS on rofi a le CE OE
o o rn P S on R
ity ity tu of of rn
al al Re li ty
li ty tu
Q u Q u sh a a Re
S ) ) Ca %) ) Qu Qu s h
R O
t ( %
s ( % ( (% Ca
fi l e CE O E
ro a on R
ofP 2022of S 2021 rn2020 2022 2021 2020
ity ity tu
u al u al Re
Q Q s h
Ca

2022 2021 2020

Premier
2022 2021 2020
Debtors coll 28.40 23.34 27.87
Creditors pa 161.68 149.06 165.83
Stock turnov 49.71 41.05 45.16

Premier
180.00
Hilton 160.00
140.00
120.00
100.00
Premier
180.00
Hilton 160.00
140.00
120.00
100.00
80.00
60.00
40.00
20.00
-
2022 2021 2020

Debtors collection period (days) Creditors payment period (days)


2022 2021 2020
Stock turnover period (days)
tors collection period (days) Creditors payment period (days)
ck turnover period (days)
Premier
2022 2021 2020
Current Rati 0.89 0.59 0.98
Quick Ratio 0.59 0.33 0.78
Interest cov 4.52 4.22 2.16
Cash divide 8.11
Premier
9.00
8.00
Hilton 7.00
6.00
0
5.00
0 4.00
3.00
0
2.00
0 1.00
-
0 Current Ratio Quick Ratio (times) Interest cover Cash d
(times) (times)
0
2022 2021 2020

Current Ratio Quick Ratio (times) Interest cover Cash dividend cover
(times) (times) (times)

2022 2021 2020


Premier
2022 2021 2020
Current Rati 0.89 0.59 0.98
Quick Ratio 0.59 0.33 0.78
Interest cov 4.52 4.22 2.16
Cash divide 8.11
2020

yment period (days)

remier

times) Interest cover Cash dividend cover


(times) (times)

2021 2020

You might also like