Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am posting this for the 4th time now without receiving any response Read the following case study and answer the questions: FINANCIAL PROJECTIONS OF

image text in transcribed

I am posting this for the 4th time now without receiving any response

Read the following case study and answer the questions: FINANCIAL PROJECTIONS OF EMPIRE LIMITED Empire Limited was established in Gauteng in 2017, manufacturing medical equipment and supplies with an initial capital of 5000000 ordinary shares that were issued at R1 each. The sales of the company, which are all on credit, grew steadily during 2018 and 2019 but increased rapidly during 2020 and 2021 following the business opportunities presented to the company by Covid-19. The sales for 2021 increased to R9 000000 and the directors predicted that the sales for 2022 would increase by 20%. At the end of 2021 the accumulated undistributed profits amounted to R1600 000 , fixed assets (at carrying value) totalled R6 000000 , R900 000 was owed to trade creditors, inventories amounted to R5 500000 and an amount of R4 000000 was owed to Jap Bank in respect of a long-term loan. The directors were interested to know what the financial position of the company would look like at the end of 2022 based on the following additional predictions and information for 2022: A gross margin of 45% and net profit margin of 20% were forecast. The cost of production of finished goods for the year is estimated at R6 500000 . The company provides its customers credit terms of 60 days but a collection period of 73 days is predicted. The percentage-of-sales method is used to estimate the accounts payable. A favourable bank balance of R300000 is expected on 31 December 2022. Vehicles with a cost price of R500 000 and accumulated depreciation of R400 000 are expected to be sold at the end of 2022 at a profit of R50 000. Due to the expected growth in sales, delivery vehicles with a cost price of R5000 000 will be purchased. The total depreciation for 2022 is estimated at R1200000. Dividends of R1 500000 are expected to be recommended by the directors at the end of December 2022. These dividends will be paid to the shareholders during 2023. R1 200000 will be paid to Jap Bank during 2022. This amount includes R500 000 for interest. The amount of external funding (non-current debt) required to fund the growth in the company must be determined (balancing figure). The directors are also considering investment opportunities for 2023 and have identified, amongst others, the purchase of additional machinery to increase the productive capacity. The expected cost of the machinery is R8 000000 with a useful life of five years and no scrap value. Depreciation is calculated on a straight-line basis. The new machinery is expected to increase net profit by R950 000 per year. The company's cost of capital is 15%. Answer ALL the questions in this section. Question 1: (14 Marks) Prepare the Pro Forma Statement of Financial Position as at 31 December 2022. Question 2: Refer to the investment opportunity for 2023 and calculate the following: 2.1 Payback period (expressed in years, months and days). (3 marks) 2.2 Accounting Rate of Return on average investment (expressed to two decimal places). (4 marks) 2.3 Benefit Cost ratio (expressed to two decimal places). (4 marks) 2.4 Internal Rate of Return using interpolation (answer expressed to two decimal places). (5 marks) Read the following case study and answer the questions: FINANCIAL PROJECTIONS OF EMPIRE LIMITED Empire Limited was established in Gauteng in 2017, manufacturing medical equipment and supplies with an initial capital of 5000000 ordinary shares that were issued at R1 each. The sales of the company, which are all on credit, grew steadily during 2018 and 2019 but increased rapidly during 2020 and 2021 following the business opportunities presented to the company by Covid-19. The sales for 2021 increased to R9 000000 and the directors predicted that the sales for 2022 would increase by 20%. At the end of 2021 the accumulated undistributed profits amounted to R1600 000 , fixed assets (at carrying value) totalled R6 000000 , R900 000 was owed to trade creditors, inventories amounted to R5 500000 and an amount of R4 000000 was owed to Jap Bank in respect of a long-term loan. The directors were interested to know what the financial position of the company would look like at the end of 2022 based on the following additional predictions and information for 2022: A gross margin of 45% and net profit margin of 20% were forecast. The cost of production of finished goods for the year is estimated at R6 500000 . The company provides its customers credit terms of 60 days but a collection period of 73 days is predicted. The percentage-of-sales method is used to estimate the accounts payable. A favourable bank balance of R300000 is expected on 31 December 2022. Vehicles with a cost price of R500 000 and accumulated depreciation of R400 000 are expected to be sold at the end of 2022 at a profit of R50 000. Due to the expected growth in sales, delivery vehicles with a cost price of R5000 000 will be purchased. The total depreciation for 2022 is estimated at R1200000. Dividends of R1 500000 are expected to be recommended by the directors at the end of December 2022. These dividends will be paid to the shareholders during 2023. R1 200000 will be paid to Jap Bank during 2022. This amount includes R500 000 for interest. The amount of external funding (non-current debt) required to fund the growth in the company must be determined (balancing figure). The directors are also considering investment opportunities for 2023 and have identified, amongst others, the purchase of additional machinery to increase the productive capacity. The expected cost of the machinery is R8 000000 with a useful life of five years and no scrap value. Depreciation is calculated on a straight-line basis. The new machinery is expected to increase net profit by R950 000 per year. The company's cost of capital is 15%. Answer ALL the questions in this section. Question 1: (14 Marks) Prepare the Pro Forma Statement of Financial Position as at 31 December 2022. Question 2: Refer to the investment opportunity for 2023 and calculate the following: 2.1 Payback period (expressed in years, months and days). (3 marks) 2.2 Accounting Rate of Return on average investment (expressed to two decimal places). (4 marks) 2.3 Benefit Cost ratio (expressed to two decimal places). (4 marks) 2.4 Internal Rate of Return using interpolation (answer expressed to two decimal places)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Valuation Workbook Step By Step Exercises And Tests To Help You Master Valuation

Authors: McKinsey & Company Inc.

7th Edition

1119611814, 978-1119611813

More Books

Students also viewed these Finance questions

Question

Build a DPDA that accepts the language L= {(ab)^n (aab)b^2n |n>0}.

Answered: 1 week ago