FINANCIAL PROJECTIONS AND CAPITAL EXPENDITURE OF ELSIES LIMITED Elsies Limited is a nationally recognised supplier of...
Fantastic news! We've Found the answer you've been seeking!
Question:
![image](https://dsd5zvtm8ll6.cloudfront.net/questions/2024/05/663a1abf28e24_966663a1abe7db16.jpg)
Transcribed Image Text:
FINANCIAL PROJECTIONS AND CAPITAL EXPENDITURE OF ELSIES LIMITED 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 camy 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 R380 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. QUESTION 1 Prepare the following pro forma statements: 1.1 Statement of Comprehensive income for the year ended 31 December 20124 using the percentage-of-sales method 12 Statement of Financial Position as of 31 December 2024 (14) QUESTION 2 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. 222 21 Accounting Rate of Return on average investment (expressed to two decimal places). (3) 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. (5) FINANCIAL PROJECTIONS AND CAPITAL EXPENDITURE OF ELSIES LIMITED 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 camy 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 R380 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. QUESTION 1 Prepare the following pro forma statements: 1.1 Statement of Comprehensive income for the year ended 31 December 20124 using the percentage-of-sales method 12 Statement of Financial Position as of 31 December 2024 (14) QUESTION 2 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. 222 21 Accounting Rate of Return on average investment (expressed to two decimal places). (3) 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. (5)
Expert Answer:
Related Book For
Financial Accounting and Reporting a Global Perspective
ISBN: 978-1408076866
4th edition
Authors: Michel Lebas, Herve Stolowy, Yuan Ding
Posted Date:
Students also viewed these accounting questions
-
A 15-year bond with annual coupons sold at par of 1,000 has a Macaulay duration of 9.0101. If the annual effective yield rate of the bond decreases by x, the price of the bond approximated using the...
-
For the given corporate bond, whose annual simple interest rate is provided, find the semiannual simple interest payment and the total interest earned over the life of the bond. Assume 3 6 5 days in...
-
ead the following case study and answer the questions: FINANCIAL PROJECTIONS AND CAPITAL EXPENDITURE OF ELSIES LIMITED Elsies Limited is a nationally recognised supplier of catering equipment. It...
-
What is the "ALDI Way" and what was its quest? Take out costs; eliminate complexity Survival; make enough money to pay overhead costs Increase market share; find more prospective customers Build...
-
Suppose that the nominal interest rate before taxes equals 8 percent, the rate of inflation equals 3 percent, and the tax rate equals 25 percent. (a) Suppose that nominal interest is taxed. What are...
-
If a Leslie matrix has a unique positive eigenvalue 1, what is the significance for the population if is 1 > 1? 1 > 1? 1 = 1?
-
When we use beta in the linear equation of the security market line, it is the: a. Intercept b. Slope c. X-variable d. F-variable
-
According to HowtoAdvice.com, the average price charged to a customer to have a 12 by 18 wall-to-wall carpet shampoo cleaned is about $50. Suppose that a start-up carpet-cleaning company believes...
-
Procter & Gamble Co. invested $3 billion in a sustainability initiative aimed at reducing its environmental footprint. The company provided the following financial information: Investment in...
-
EXHIBIT 13-1 Defined Benefit Plans Minimum Vesting Schedules* Full Years of Service 1 234569 7 5-Year Cliff 7-Year Graded 0% 0% 0 0 0 20 0 40 100 60 N/A 80 N/A 100 *Percent of employee benefit no...
-
1. Evaluate process design with respect to costs and resource utilization and make recommendations for improvement 2. Discuss the importance of design and ongoing maintenance of the physical plant,...
-
Define Supportive pillar, Regulatory Pillar, Normative Pillar, and Cognitive Pillar in detail.
-
Charles Darwin observed that several species of finches native to the Galapagos islands seemed to have evolved so that their beak lengths, as well as how pointy their beaks are, were adapted to their...
-
The cup on the 9th hole of a golf course is located dead center in the middle of a circular green that is 70 feet in diameter. Your ball is located as in the picture below: green 50 feet ball 40 feet...
-
Assignment: Globalizing for Growth Ultimately, having the ability to understand and contribute to a positive organizational culture is key in today's workforce. Those who can add value in this area...
-
In two different Supreme Court opinions concerning the right to counsel, the Court has said that a defendant needs the "guiding hand of counsel" and "lawyers are necessities, not luxuries". What do...
-
Consider the function f and its graph. a. Estimate the zeros of the area function b. Estimate the points (if any) at which A has a local maximum or minimum. c. Sketch a graph of A, for 0 x 10,...
-
Which of the following is NOT a common type of white box test of controls? a. completeness tests b. redundancy tests c. inference tests d. authenticity tests
-
In an automated payroll processing environment, a department manager substituted the time card for a terminated employee with a time card for a fictitious employee. The fictitious employee had the...
-
Which of the following is NOT a test for identifying application errors? a. reconciling the source code b. reviewing test results c. retesting the program d. testing the authority table
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App