Uma Foodstuff Ltd. is a large chain of food stores. The financial statements for Uma Ltd. are given below. Income statement for the year ended 31 December 2021 2020 $m. $m. Revenue 145,000 160,000 Cost of sales 86,000 91,200 Gross profit 59,000 68,800 Selling and distribution expenses 17,500 17,600 Administrative expenses 7,500 6,400 Operating profit 34,000 44,800 Interest expense 2,000 400 Profit before taxation 32,000 44,400 Income tax expense 6,400 8,880 Net profit 25,600 35,520 Statement of financial position as at 31 December 2021 2020 $m. $m. ASSETS Non-current assets Land and buildings 40,000 68,600 Equipment 34,000 35,000 74,000 103,600 Current assets Inventories 20,000 12,000 Trade receivables 4,000 2,000 Cash 4,000 7,000 27,000 21,000 Total assets 102,000 124,600 EQUITY AND LIABILITIES Equity Share capital 54,000 75,600 Retained earnings 10,000 12,000 Total equity 64,000 87,600 Non-current liabilities Long-term borrowings 31,000 25,000 Current liabilities Trade payables 5,000 Short-term borrowings 7,000 7,000 7,000 12,000 Total equity and liabilities 102,000 124,600 Calculate and present the following ratios for the year 2021: a) Total assets turnover b) Average inventory turnover period c) Average settlement period for trade receivables
Financial Ratios
A Ratio refers to a figure calculated as a reference to the relationship of two or more numbers and can be expressed as a fraction, proportion, percentage, or the number of times. When the number is determined by taking two accounting numbers derived from the financial statements, it is termed as the accounting ratio.
Return on Equity
The Return on Equity (RoE) is a measure of the profitability of a business concerning the funds by its stockholders/shareholders. ROE is a metric used generally to determine how well the company utilizes its funds provided by the equity shareholders.
Uma Foodstuff Ltd. is a large chain of food stores. The financial statements for Uma Ltd. are given below.
|
Income statement |
||
|
for the year ended 31 December |
||
|
|
2021 |
2020 |
|
|
$m. |
$m. |
|
Revenue |
145,000 |
160,000 |
|
Cost of sales |
86,000 |
91,200 |
|
Gross profit |
59,000 |
68,800 |
|
Selling and distribution expenses |
17,500 |
17,600 |
|
Administrative expenses |
7,500 |
6,400 |
|
Operating profit |
34,000 |
44,800 |
|
Interest expense |
2,000 |
400 |
|
Profit before |
32,000 |
44,400 |
|
Income tax expense |
6,400 |
8,880 |
|
Net profit |
25,600 |
35,520 |
|
Statement of financial position |
||
|
as at 31 December |
||
|
|
2021 |
2020 |
|
|
$m. |
$m. |
|
ASSETS |
|
|
|
Non-current assets |
|
|
|
Land and buildings |
40,000 |
68,600 |
|
Equipment |
34,000 |
35,000 |
|
|
74,000 |
103,600 |
|
Current assets |
|
|
|
Inventories |
20,000 |
12,000 |
|
Trade receivables |
4,000 |
2,000 |
|
Cash |
4,000 |
7,000 |
|
|
27,000 |
21,000 |
|
Total assets |
102,000 |
124,600 |
|
|
|
|
|
EQUITY AND LIABILITIES |
|
|
|
Equity |
|
|
|
Share capital |
54,000 |
75,600 |
|
|
10,000 |
12,000 |
|
Total equity |
64,000 |
87,600 |
|
|
|
|
|
Non-current liabilities |
|
|
|
Long-term borrowings |
31,000 |
25,000 |
|
Current liabilities |
|
|
|
Trade payables |
5,000 |
|
|
Short-term borrowings |
7,000 |
7,000 |
|
|
7,000 |
12,000 |
|
Total equity and liabilities |
102,000 |
124,600 |
|
|
|
- Calculate and present the following ratios for the year 2021:
|
a) Total assets turnover |
|
b) Average inventory turnover period |
|
c) Average settlement period for trade receivables |
|
d) Average settlement period for trade payables |
|
e) Net profit margin |
|
f) Gross profit margin |
|
g) |
|
h) |
|
i) Current ratio |
|
j) Quick ratio |
|
k) Debt-to-equity ratio |
|
l) Interest cover ratio |
- Using the ratios calculated in (1) and ratios below, compare the performance of Uma Ltd. between 2021 and 2020.
|
2020 |
2019 |
Industry average |
|
|
Total assets turnover (times) |
1.28 |
1.95 |
1.65 |
|
Average inventory turnover period (days) |
32.20 |
30.50 |
38.00 |
|
Average settlement period for trade receivables (days) |
6.15 |
6.05 |
6.50 |
|
Average settlement period for trade payables (days) |
25.00 |
24.50 |
26.00 |
|
Net profit margin |
21.90% |
23.00% |
18.00% |
|
Gross profit margin |
43.00% |
43.20% |
41.00% |
|
ROA |
28.50% |
29.40% |
27.00% |
|
ROE |
40.50% |
51.40% |
50.00% |
|
Current ratio (times) |
1.75 |
1.83 |
1.50 |
|
Quick ratio (times) |
0.75 |
0.78 |
0.65 |
|
Debt-to-equity ratio (times) |
0.42 |
0.48 |
0.55 |
|
Interest cover ratio (times) |
112.00 |
115.00 |
50.00 |
- Evaluate the performance of Uma Ltd. over time using financial ratios with reference to relevant benchmarks above.
- Critically evaluate financial statements to assess organisational performance using a range of measures and benchmarks to make justified conclusions.
Step by step
Solved in 6 steps
