Case Study PROGRAMME Bachelor of Business Administration Bachelor of Commerce in Supply Chain Management Bachelor of Commerce in Retail Management Bachelor of Commerce in International Business MODULE

Case Study PROGRAMME Bachelor of Business Administration Bachelor of Commerce in Supply Chain Management Bachelor of Commerce in Retail Management Bachelor of Commerce in International Business MODULE Financial Planning and Control YEAR 3 (Three) INTAKE January 2024 Semester 1 Marks 30 Answer ALL questions. [30 MARKS] Read 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 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. QUESTION 1 Prepare the following pro forma statements: 1.1 Statement of Comprehensive Income for the year ended 31 December 2024 using the percentage-of-sales method. (4) 1.2 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. 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. (5) THE END

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Review the scenario and watch this week’s videos before you complete the activity below. This scenario can also be found in the “Problems – Series A” section 8-19A of Ch. 8, “Performance Evaluation” o

Review the scenario and watch this week’s videos before you complete the activity below. This scenario can also be found in the “Problems – Series A” section 8-19A of Ch. 8, “Performance Evaluation” of Fundamentals of Managerial Accounting Concepts. Scenario: The Redmond Management Association held its annual public relations luncheon in April Year 2.

Topic: Interpret income tax disclosures in financial statements In this discussion, please reflect on the previous weeks’ topics. Choose a topic you find to be difficult or hard to understand. Researc

Topic: Interpret income tax disclosures in financial statements In this discussion, please reflect on the previous weeks’ topics. Choose a topic you find to be difficult or hard to understand. Research this topic using AI (Copilot or Chatgpt.com, for example) and present your findings. Include a summary of the topic,

In this discussion, please research pension plans and post-retirement benefits for several public corporations. Find one with a defined benefit plan and one with a defined contribution plan. Interpret

In this discussion, please research pension plans and post-retirement benefits for several public corporations. Find one with a defined benefit plan and one with a defined contribution plan. Interpret the notes disclosing the plans, reviewing the notes and explaining the post-retirement benefits that the corporations offer. This discussion supports CO-3 by

Write 200–250 words that respond to the directions below with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. There are two ways for companies t

Write 200–250 words that respond to the directions below with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. There are two ways for companies to borrow money. They can sign a note to borrow money from a bank or they can issue

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Please complete the following:

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Please complete the following: An entrepreneur is someone who has a passion and desire to organize and operate their own business. Using a business plan, an

Company: Samsung In this discussion, research income tax disclosures for a public corporation and access the impact of the tax differences on the income statement. Research this topic using AI (Copil

Company: Samsung In this discussion, research income tax disclosures for a public corporation and access the impact of the tax differences on the income statement. Research this topic using AI (Copilot or Chatgpt.com, for example) and present your findings. Include a summary of the topic, and what you learned after

KEONIA- UP TO 12/5/2025- *** IMPORTANT: PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI/ PLAGERISE AS THE ASSIGNMENT WILL BE RUN THROUGH TURN IT IN!!!!!* **** THIS ASSIGNMENT HAS 4

KEONIA- UP TO 12/5/2025- ***** IMPORTANT: PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI/ PLAGERISE AS THE ASSIGNMENT WILL BE RUN THROUGH TURN IT IN!!!!!***** ****** THIS ASSIGNMENT HAS 4 PARTS / PLEASE LABEL EACH PART SEPARATELY WITH REFERENCES WHEN COMPLETED****** **** FISCAL ACCOUNTABILITY **** PART

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. For this Discussion Board, ple

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. For this Discussion Board, please complete the following: A virtual business is any kind of business that is run via the Internet. With no physical location

Write 200–250 words that respond to the directions below with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Payroll has many different parts.

Write 200–250 words that respond to the directions below with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Payroll has many different parts. Not only is the employee paying taxes, but the employer is also paying additional payroll taxes. Watch the following

Company: Tesla In this discussion, please reflect on this weeks’ topics of corporate bonds and long-term debt. Choose a public corporation and evaluate the bond disclosure notes included with the fin

Company: Tesla In this discussion, please reflect on this weeks’ topics of corporate bonds and long-term debt. Choose a public corporation and evaluate the bond disclosure notes included with the financial statements. Research this topic using AI (Copilot or Chatgpt.com, for example) and present your findings. Minimum 250 words At

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. For this Discussion Board, ple

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. For this Discussion Board, please complete the following: When multiple employee personalities come into one business unit, there is a possibility of conflict happening.

Write 200–250 words that respond to the directions below with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Internal controls are an important

Write 200–250 words that respond to the directions below with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Internal controls are an important part of business operations. Internal controls are used to protect assets. Both companies and individuals use internal controls. Companies

Module 1 – SLPFinancial ReportingAssignment OverviewTraditional and Triple Bottom Line Reporting For managers in all departments, analyzing Traditional and Triple Bottom Line Reporting is important fo

Module 1 – SLPFinancial ReportingAssignment OverviewTraditional and Triple Bottom Line Reporting For managers in all departments, analyzing Traditional and Triple Bottom Line Reporting is important for making informed decisions that balance financial performance with social and environmental responsibility. It helps managers align strategies with sustainability goals, drive innovation, and support

Module 1 – CaseFinancial ReportingAssignment OverviewCompare Traditional Reporting vs. TBL Reporting Traditional reporting focuses solely on financial performance, while Triple Bottom Line (TBL) repor

Module 1 – CaseFinancial ReportingAssignment OverviewCompare Traditional Reporting vs. TBL Reporting Traditional reporting focuses solely on financial performance, while Triple Bottom Line (TBL) reporting evaluates financial, social, and environmental impacts, providing a broader view of a company’s sustainability and long-term value creation. In analyzing trends over five years of financial

Write 200–250 words that respond to the directions below with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Adjusting entries are used to make

Write 200–250 words that respond to the directions below with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Adjusting entries are used to make sure that all revenue and expenses are recorded in the correct period. Last week you learned about four

Write a 1–2 page executive summary, along with an appendix of supporting information, in which you analyze an organization’s financial performance as well as its level of risk for lending and make and

Write a 1–2 page executive summary, along with an appendix of supporting information, in which you analyze an organization’s financial performance as well as its level of risk for lending and make and present a recommendation to help leadership make a loan decision. Collapse AllIntroduction This portfolio work project will

Listed below are several terms and phrases associated with the accounting concepts. Pair each item from List A with the item from List B that is most appropriately associated with it. 1. Expense recog

Listed below are several terms and phrases associated with the accounting concepts. Pair each item from List A with the item from List B that is most appropriately associated with it. 1. Expense recognition 2. Periodicity 3. Historical cost principle 4. Materiality 5. Revenue recognition 6. Going concern assumption 7.

Module 1 – CaseFinancial ReportingAssignment OverviewCompare Traditional Reporting vs. TBL Reporting Traditional reporting focuses solely on financial performance, while Triple Bottom Line (TBL) repor