EduNinja

IB Business Management SL3.5 Profitability and liquidity ratio analysisQuestion Bank

Question 1

[Maximum number: 8]

1. LuxEclairage (LE)
LuxEclairage (LE) was founded by Maurice Dahman, an Electrical Engineer from Algeria. He has a degree in electrical engineering and is fluent in French. In 2007, after 12 years working for a large lighting business in Luxembourg, Maurice established LE. His business produces energy-efficient parts for various indoor and outdoor lighting.
L E has a unique selling point (USP): the lowest price in the market. Although most sales are in Europe, all production is in Algeria, where costs are much lower. As a result, growth in sales revenue has been rapid and significant, and L E has gained market share each year.
Selected financial information for L E (all figures in €m):

Table

With the rapid growth in sales revenue since it was first established, L E has experienced some diseconomies of scale, especially in the administration of the business. Production occurs in 12 small factories located around the city of Algiers, rather than in one large factory. Coordination between factories and the administrative offices is, therefore, complicated, and the internet is sometimes unavailable. Whereas French is the language used by managers and customers of L E, the workers generally speak only basic French and prefer to speak Arabic. In addition, patterns of non-verbal communication differ widely between Europe and Algeria.

Question 1(c)

(a)

Calculate for L E :

[ 5 ]

Question 1(c)(ii)

(i)

the gross profit margin for 2013.

[ 1 ]

Question 1(c)(iv)

(ii)

the current ratio for 2009 and 2013.

[ 2 ]

Question 1(c)(v)

(iii)

the acid test (quick) ratio for 2009 and 2013.

[ 2 ]

Question 1(d)

(b)

Comment on the decline in liquidity at L E.

[ 3 ]

Question 1

[Maximum number: 2]

1. MiniVS (MV)
MiniVS (MV) imports light bulbs, which it sells business to business (B2B) to customers in the UK. In 2020, MV ran into cash-flow problems and had to use debt factoring.
M V has now solved its cash-flow problems. It operates a cost-plus (mark-up) pricing strategy and places a 100 % mark-up on the light bulbs that it purchases from suppliers.
The forecasted opening cash balance for January 2021 is £ 20000.

Table 1: Forecasted data per month for M V for the first six months of 2021 (all figures in £)

Table 1: Forecasted data per month for M V for the first six months of 2021 (all figures in £)

The finance director is concerned that the online market for light bulbs in the UK is becoming increasingly price competitive. She believes that if suppliers raise prices in the second half of 2021 , M V will have to abandon its cost-plus (mark-up) pricing strategy to be price competitive.

Question 1(c)

(a)

Explain the potential impact on MM \vee s gross profit margin if the prices charged by its suppliers increase in the second half of 2021.

[ 2 ]

Question 1

[Maximum number: 4]

Tipin (TI)

Tipin (TI) manufactures shirts using a batch production method.
Table 1 provides selected financial information for TI from:
- its profit and loss account for the year ending 31 May 2022
- its balance sheet at 31 December 2021.

Table 1: Selected financial information for TI (all figures in \$000s)

Table 1: Selected financial information for TI (all figures in \$000s)

At the end of 2021, Tl's current ratio was 2.1. Its net profit margin declined from 14.8 % in 2021 to 10.0 \% in 2022.

Question 1(c)

(a)

Calculate Tl's current ratio at 31 December 2022 (show all your working).

[ 2 ]

Question 1(d)

(b)

Using your answer in part (c), comment on the relationship between the changes in Tl's current ratio from 2021 to 2022 and the changes in its net profit margin from 2021 to 2022.

[ 2 ]

Question 1

[Maximum number: 1]

1. Suparman Fish ( SF )
Gepa Suparman owns and operates four fishing boats in Indonesia. There is a growing demand for canned (tinned) food, including cans of fish. Gepa wants to enter the secondary sector by opening a small factory producing cans of fish.
Gepa's business will be called Suparman Fish ( S F ) and will be a private limited company. Gepa will own all of the shares. The factory will be located in a village three miles from the harbour. Because unemployment is high in the village, Gepa should easily find workers for the new factory. In addition to the manager's salary, workers' wages, and the cost of fish, supplies, and cans, S F will have the semi-variable cost of electricity.
Gepa has prepared a four-month cash-flow forecast based on the following information:
- opening balance month 1: $ 15000.
- month 1 : sales revenue of $ 1000, increasing by 20 % per month.
- manager's salary: $ 300 per month.
- workers' wages: $ 175 per worker per month.

Table

- variable costs (fish, supplies, and cans) are equal to 40 % of sales revenue.
- semi-variable cost of electricity: fixed cost of $ 100 per month, plus a variable cost of $ 0.10 per kilowatt hour (kwh). Month 1 usage: 100 kwh , increasing by 10 % each month.

Although S F would create several jobs in the village, many residents are not happy about the new factory. The new factory would use chemicals, which cause pollution. Residents are concerned about the unpleasant smells from the factory. A representative from the local employment office is concerned whether Gepa's factory will provide a safe working environment.

Question 1(e)

(a)

Calculate S F 's forecast net profit margin for the first four months of operation.

[ 1 ]

Question 1

[Maximum number: 1]

1. Nzuri Kio (NK)
Nzuri Kio ( N K ) is a company that manufactures products made of glass, such as windows and table tops. NK sells its products in its own regional trading bloc, a group of eight countries that all have developing economies. NK is located in a poor country where the national government is not very efficient and public sector services are limited. The country's infrastructure needs investment, and quality of life is low. At school, students are in very big classes, with over sixty students in each; few students complete middle school.
The manager of N K is considering purchasing new, high-quality equipment for its factory: glass-making machines from Carrucci SpA. Carrucci SpA is an Italian company that makes the best glass manufacturing equipment in the world. Its computerized equipment is innovative and very efficient. Glass can be cut perfectly, with almost no waste. However, the equipment is expensive and requires highly skilled workers. The new equipment would lead to a better product, which should result in higher sales and a higher gross profit margin.
The total cost of the equipment is $ 800000. NK is considering two different sources of finance:
- (Option A) a seven-year $720000 bank loan.
- (Option B) selling $ 800000 in shares.
Financial information for N K, for the year ending 31 May 2014:

Table

Question 1(b)

(a)

Using data from the table:

[ 1 ]

Question 1(b)(iii)

(i)

calculate N K 's gross profit margin (no working required);

[ 1 ]

Question 1

[Maximum number: 2]

1. Rio Mobiliário (RM)
Rio Mobiliário (RM) is a Brazilian furniture manufacturer. It generates sales in South America, North America and Europe. It has successfully outsourced production and distribution facilities to North America.
Selected financial data for the year ended and as of 31 December 2015. All figures in millions of Brazilian reals.

Table

Question 1(b)

Question 1(b)(ii)

(a)
(i)

Calculate Y and hence, calculate the net profit margin for RM (no working required).

[ 2 ]

Question 2

[Maximum number: 1]

KPJ

KPJ operates a cinema in a small town. It uses a price discrimination strategy for cinema tickets.

Table 2: Selected financial information for KPJ for year ending 31 December 2019 at 31 Dec 2019 (all figures in \$)

Table 2: Selected financial information for KPJ for year ending 31 December 2019 at 31 Dec 2019 (all figures in \$)

Question 2(b)

(a)

Using Table 2, calculate:

[ 1 ]

Question 2(b)(ii)

(i)

the current ratio for 2019 (no working required).

[ 1 ]

Question 2

Question 2(c)

(a)

Using information from Appendix 5a,

[ 4 ]

Question 2(c)(i)

(i)

calculate the net profit margin and the gross profit margin for Kos Palouk from his current operation (Option 1).

[ 2 ]

Question 2(c)(ii)

(ii)

calculate the net profit margin and the gross profit margin for Kos Palouk from his forecast operation (Option 2).

[ 2 ]

Question 2(d)

(b)

Interpret your results from part (c) and the data from Appendix 5a and 5b.

[ 7 ]

Question 2

Question 2(b)

(a)

Using data from the additional information on page 3, calculate RDB's:

[ 4 ]

Question 2(b)(i)

(i)

gross profit margin in 1970 and 1975.

[ 2 ]

Question 2(b)(ii)

(ii)

acid test (quick) ratio in 1970 and 1975.

[ 2 ]

Question 2(c)

(b)

Interpret the results from your calculations in part (b).

[ 7 ]

Question 2

Question 2(b)

(a)

Using data from the additional information on page 3, calculate RDB's:

[ 2 ]

Question 2(b)(i)

(i)

return on capital employed (ROCE) in 1965 and 1975.

[ 2 ]
0 selected