Question

Elsies Limited is a nationally recognised supplier of catering equipment. It offers safe and secure shopping via its online store and its state-of-the-art premises in each of the provinces of South Africa. The company offers a wide selection of catering equipment and supplies at competitive prices. The target market includes restaurants, hotels, hostels and spaza shops. Their products carry an industry-leading warranty that is backed by good after-sales service and availability of spares. The company was established in 2015 with an authorised share capital of 1 500 000 ordinary shares of which 900 000 were issued at R2 each at the initial public offering in 2015. The financial manager and her team were in the process of forecasting the financial performance for 2024 and financial position of the company as of 31 December 2024. The starting point was the following figures that were obtained from the financial statements for the year ended 31 December 2023: The sales amounted to R9 600 000, and the cost price of the goods sold was R7 200 000. Operating expenses totaled R1 200 000 whilst the company tax amounted to R336 000. The carrying value of the fixed assets was R4 200 000 whilst the inventories, trade debtors and cash reflected values of R1 200 000, R1 800 000 and R600 000 respectively. The ordinary share capital balance remained unchanged since the establishment of the company in 2015 whilst the undistributed profits of the company accumulated to R2 100 000. An amount of R2 400 000 was owed to Jip Bank for a long-term loan. The amount owed to trade creditors was R1 467 000 and the company tax payable to SARS was R33 000. The following predictions were made for the financial year ended 31 December 2024: Sales are expected to increase by 25%. Seventy-five percent (75%) of the total sales is estimated to be on credit. Company tax will be calculated at 27% of the pre-tax profit and 10% of this amount is expected to be unpaid on 31 December 2024. A final dividend of R400 000 is expected to be declared on 31 December 2024, and is payable during 2025. The unsold shares are expected to be issued on 31 March 2024 at R3 each. The amount owed by trade debtors will be based on a collection period of 54.75 days. The company’s closing inventory and the amount owed to trade creditors are expected to change directly with the change in sales in 2024. A new machine with a cost price of R700 000 will be purchased during January 2024. Depreciation for 2024 (included in the operating expenses) is expected to amount to R300 000. R760 000 will be paid to Jip Bank during 2024 and this amount includes R360 000 for interest. The cash balance must be calculated (balancing figure). Elsies Limited is considering the purchase of a machine to manufacture some of the spare parts for the catering equipment during 2025. The company desires a minimum required rate of return of 12%. The machine will cost R2 000 000 plus R400 000 for installation and is predicted to have a useful life of five years. A salvage value of R100 000 is estimated. The machine is expected to generate cash inflows of R800 000 per year but will require the employment of two new machine operators at R100 000 per year for each operator, and it will require maintenance and repairs averaging R40 000 per year. Depreciation will be calculated using the straight-line method. Refer to the investment opportunity for 2025 and calculate the following. (Ignore taxes.) Where discount factors are required, use the four decimals present value tables that appear in the module guide. 2.1 Accounting Rate of Return on average investment (expressed to two decimal places). (3) 2.2 Benefit Cost Ratio (expressed to two decimal places). (4) 2.3 Internal Rate of Return (expressed to two decimal places). Your answer must reflect two NPV calculations (using consecutive rates/percentages) and interpolation.

78

likes
389 views

Answer to a math question Elsies Limited is a nationally recognised supplier of catering equipment. It offers safe and secure shopping via its online store and its state-of-the-art premises in each of the provinces of South Africa. The company offers a wide selection of catering equipment and supplies at competitive prices. The target market includes restaurants, hotels, hostels and spaza shops. Their products carry an industry-leading warranty that is backed by good after-sales service and availability of spares. The company was established in 2015 with an authorised share capital of 1 500 000 ordinary shares of which 900 000 were issued at R2 each at the initial public offering in 2015. The financial manager and her team were in the process of forecasting the financial performance for 2024 and financial position of the company as of 31 December 2024. The starting point was the following figures that were obtained from the financial statements for the year ended 31 December 2023: The sales amounted to R9 600 000, and the cost price of the goods sold was R7 200 000. Operating expenses totaled R1 200 000 whilst the company tax amounted to R336 000. The carrying value of the fixed assets was R4 200 000 whilst the inventories, trade debtors and cash reflected values of R1 200 000, R1 800 000 and R600 000 respectively. The ordinary share capital balance remained unchanged since the establishment of the company in 2015 whilst the undistributed profits of the company accumulated to R2 100 000. An amount of R2 400 000 was owed to Jip Bank for a long-term loan. The amount owed to trade creditors was R1 467 000 and the company tax payable to SARS was R33 000. The following predictions were made for the financial year ended 31 December 2024: Sales are expected to increase by 25%. Seventy-five percent (75%) of the total sales is estimated to be on credit. Company tax will be calculated at 27% of the pre-tax profit and 10% of this amount is expected to be unpaid on 31 December 2024. A final dividend of R400 000 is expected to be declared on 31 December 2024, and is payable during 2025. The unsold shares are expected to be issued on 31 March 2024 at R3 each. The amount owed by trade debtors will be based on a collection period of 54.75 days. The company’s closing inventory and the amount owed to trade creditors are expected to change directly with the change in sales in 2024. A new machine with a cost price of R700 000 will be purchased during January 2024. Depreciation for 2024 (included in the operating expenses) is expected to amount to R300 000. R760 000 will be paid to Jip Bank during 2024 and this amount includes R360 000 for interest. The cash balance must be calculated (balancing figure). Elsies Limited is considering the purchase of a machine to manufacture some of the spare parts for the catering equipment during 2025. The company desires a minimum required rate of return of 12%. The machine will cost R2 000 000 plus R400 000 for installation and is predicted to have a useful life of five years. A salvage value of R100 000 is estimated. The machine is expected to generate cash inflows of R800 000 per year but will require the employment of two new machine operators at R100 000 per year for each operator, and it will require maintenance and repairs averaging R40 000 per year. Depreciation will be calculated using the straight-line method. Refer to the investment opportunity for 2025 and calculate the following. (Ignore taxes.) Where discount factors are required, use the four decimals present value tables that appear in the module guide. 2.1 Accounting Rate of Return on average investment (expressed to two decimal places). (3) 2.2 Benefit Cost Ratio (expressed to two decimal places). (4) 2.3 Internal Rate of Return (expressed to two decimal places). Your answer must reflect two NPV calculations (using consecutive rates/percentages) and interpolation.

Expert avatar
Cristian
4.7
111 Answers
Let's tackle each of the required calculations step by step:

### Part 2.1: Accounting Rate of Return (ARR) on Average Investment

**Solution By Steps**

*Step 1: Calculate the Total Annual Net Cash Inflow*
- Annual Cash Inflows: R800,000
- Annual Expenses:
- Machine Operators: 2 \times R100,000 = R200,000
- Maintenance and Repairs: R40,000
- Net Annual Cash Inflows: R800,000 - R200,000 - R40,000 = R560,000

*Step 2: Calculate Annual Depreciation Expense*
- Cost of Machine: R2,000,000 + R400,000 = R2,400,000
- Salvage Value: R100,000
- Useful Life: 5 years
- Annual Depreciation: \frac{R2,400,000 - R100,000}{5} = R460,000

*Step 3: Calculate Annual Accounting Profit*
- Annual Accounting Profit: R560,000 - R460,000 = R100,000

*Step 4: Calculate Average Investment*
- Initial Investment: R2,400,000
- Average Investment: \frac{R2,400,000 + R100,000}{2} = R1,250,000

*Step 5: Calculate ARR*
- ARR: \frac{R100,000}{R1,250,000} \times 100 = 8.00\%

**Final Answer**
The Accounting Rate of Return (ARR) on average investment is 8.00%.

### Part 2.2: Benefit-Cost Ratio (BCR)

**Solution By Steps**

*Step 1: Calculate the Total Present Value (PV) of Cash Inflows*
- Annual Cash Inflows: R560,000
- Present Value Factor (for 12%, 5 years): 3.6048 (from PV tables)
- Total PV of Cash Inflows: R560,000 \times 3.6048 = R2,018,688

*Step 2: Calculate the Initial Investment*
- Initial Investment: R2,400,000

*Step 3: Calculate BCR*
- BCR: \frac{Total PV of Cash Inflows}{Initial Investment} = \frac{R2,018,688}{R2,400,000} = 0.84

**Final Answer**
The Benefit-Cost Ratio (BCR) is 0.84.

### Part 2.3: Internal Rate of Return (IRR)

**Solution By Steps**

*Step 1: Calculate NPV at a Lower Discount Rate (10%)*
- PV Factor (10%, 5 years): 3.7908
- Total PV of Cash Inflows: R560,000 \times 3.7908 = R2,123,848
- NPV at 10%: R2,123,848 - R2,400,000 = -R276,152

*Step 2: Calculate NPV at a Higher Discount Rate (14%)*
- PV Factor (14%, 5 years): 3.4331
- Total PV of Cash Inflows: R560,000 \times 3.4331 = R1,922,536
- NPV at 14%: R1,922,536 - R2,400,000 = -R477,464

*Step 3: Interpolate to find IRR*
- Using the formula: IRR = R_1 + \frac{NPV_1 \times (R_2 - R_1)}{(NPV_1 - NPV_2)}
- R_1 = 10\% , R_2 = 14\%
- IRR = 10 + \frac{(-R276,152) \times (14 - 10)}{(-R276,152 - -R477,464)}
- IRR = 10 + \frac{-R276,152 \times 4}{R201,312}
- IRR = 10 + \frac{-1,104,608}{201,312}
- IRR = 10 + (-5.48)
- IRR = 4.52\%

**Final Answer**
The Internal Rate of Return (IRR) is 4.52%.

### Key Concept

**Key Concept**
Investment evaluation methods such as ARR, BCR, and IRR are critical for determining the viability and profitability of capital investments. They provide insights into the expected returns and help compare different investment opportunities.

**Key Concept Explanation**
- **ARR**: Measures the average annual profit of an investment as a percentage of the initial investment, useful for evaluating the profitability in accounting terms.
- **BCR**: Compares the present value of cash inflows to the initial investment cost, helping to assess the overall value generated by the investment.
- **IRR**: The discount rate at which the net present value of cash flows from an investment is zero, indicating the expected annualized return and aiding in comparing the profitability of multiple investments.

Frequently asked questions (FAQs)
Question: Simplify √(16) + √(25) - √(9)
+
Find the unit vector in the direction of vector v = 2i + 3j - 6k.
+
What is the sum of the mixed numbers 3 1/2 and 2 3/4, after factoring the number 12 and considering real numbers?
+
New questions in Mathematics
reduction method 2x-y=13 x+y=-1
a ferry travels 1/6 of the distance between two ports in 3/7 hour. The ferry travels at a constant rate. At this rate, what fraction of the distance between the two ports can the ferry travel in one hour.
-6(3x-4)=-6
A normally distributed population has a mean of 118 with a standard deviation of 18. What score separates the lowest 72% of the distribution from the rest of the scores?
Let X be a discrete random variable with range {1, 3, 5} and whose probability function is f(x) = P(X = x). If it is known that P(X = 1) = 0.1 and P(X = 3) = 0.3. What is the value of P(X = 5)?
Write 32/25 as a percent
90 divided by 40
Which of the following is the product of multiplying twenty-seven and twenty-five hundredths by nine and twenty-seven hundredths?
You have been hired to estimate the average weight of quarters in circulation. Based on the sample of quarters you collect (below), create a 90% confidence interval for the weight of quarters in circulation. Quarter Weights (grams) 5.631 5.714 5.719 5.689 5.551 5.723 5.705 5.627 5.627 5.715 5.576 5.632 5.641 5.676 5.660 5.699 5.609 5.634 5.713 5.591 5.674 5.675 5.684 5.694 5.655 5.632 5.598 5.675 5.628 5.562 5.636 5.583 5.567 5.551 5.649 5.708 5.696 5.614 5.637 5.601 5.628 5.711 5.566 5.653 5.653 5.597 5.687 5.717 5.678 5.654 5.556 5.707 5.563 5.628 5.679 5.714 5.555 5.719 5.634 5.647 5.717 5.612 5.705 5.657 5.670 5.607 5.687 5.666 5.612 5.718 5.714 5.713 5.663 5.641 5.589 5.656 5.712 5.639 5.577 5.580 5.674 5.636 5.625 5.597 5.616 5.591 5.616 5.700 5.706 5.695 5.562 5.699 5.607 5.573 5.659 5.632 5.654 5.568 5.628 5.687 5.605 5.689 5.687 5.554 5.618 5.701 5.681 5.645 5.714 5.665 5.661 5.634 5.714 5.586 5.656 5.673 5.657 5.717 5.611 5.578 5.579 5.614 5.644 5.724 5.647 5.566 5.697 5.558 5.586 5.586 5.611 5.573 5.573 5.709 5.629 5.649 5.552 5.615 5.645 5.611 5.686 5.588 5.641 5.704 5.703 5.696 5.557 5.551 5.725 5.608 5.725 5.603 5.677 5.638 5.573 5.640 5.561 5.631 5.563 5.671 5.662 5.569 5.648 5.680 5.681 5.551 5.555 5.578 5.701 5.645 5.670 5.574 5.594 5.705 5.633 5.719 5.680 5.647 5.641 5.553 5.616 5.698 5.552 5.566 5.559 5.697 5.686 5.560 5.629 5.701 5.622 5.615 5.553 5.608 5.637 5.663 5.696 5.714 5.675 5.613 5.594 5.669 5.569 5.716 5.705 5.603 5.709 5.717 5.606 5.581 5.575 5.601 5.600 5.664 5.715 5.705 5.583 5.586 5.592 5.550 5.628 5.662 5.603 5.559 5.676 5.558 5.678 5.671 5.642 5.581 5.568 5.706 5.665 5.712 5.574 5.602 5.699 5.716 5.693 5.711 5.635 5.612 BLANK #1: Is this a question involving mean or proportion? ***ANSWER "MEAN" OR "PROPORTION" (WITHOUT THE QUOTATION MARKS)*** BLANK #2: What is the LOW end of the estimate ***ANSWER TO 3 DECIMALS*** BLANK #3: What is the HIGH end of the estimate ***ANSWER TO 3 DECIMALS***
By direct proof, how can you prove that “The sum of any three consecutive even integers is always a multiple of 6”.
12(3+7)-5
Log5 625
During a fishing trip Alex notices that the height h of the tide (in metres) is given by h=1−(1/2)*cos(πt/6) where t is measued in hours from the start of the trip. (a) Enter the exact value of h at the start of the trip in the box below.
At the dance there are 150 boys the rest are girls. If 65% are girls what is the total amount in the room
Find the number of pounds of nails required for 17850 square feet of drywall if each thousand square feet requires 4.5 pounds of nails.
To find the increased amount on a standard term deposit with the following conditions: starting amount: BGN 13000, type of deposit: annual, annual compound interest rate: 1.4%, after 4 years;
draw the condensed formula fpr 3,3,4 triethylnonane
A small box measures 10 in. by 4 in. by 6 in. high. Find the volume of the box.
Mark is gluing a ribbon around the sides of a picture frame. The frame is 11 inches long and 7 includes wide. How much ribbon does Mark need?
An export company grants a bonus of $100,000 pesos to distribute among three of its best employees, so that the first receives double the second and the latter receives triple the third. How much did each person receive?