Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Read the case study and answer the questions that follow: DREAMIT ELECTRONICS LTD: PROJECTIONS FOR 2 0 2 4 AND 2 0 2 5 After

Read the case study and answer the questions that follow:
DREAMIT ELECTRONICS LTD: PROJECTIONS FOR 2024 AND 2025
After posting excellent sales and net profit in the previous year Dreamit Electronics Ltd set its sights on growth and innovation as it celebrated its 10th anniversary in 2023. It has continually strived to become the leader in the electronics industry in South Africa. The company is also committed to being a good corporate citizen, as it strives to fulfil both its economic and social responsibilities.
The following reflects the financial position of the company on 31 December 2023:
The carrying value of the fixed assets was R30000000 whilst the current assets comprised inventory of R9400000, accounts receivable of R8000000 and cash of R1600000. The equity consisted of ordinary share capital, R17000000, and retained earnings of R6400000. An amount of R22000000 was owed to Mesa Bank for a long-term loan. Trade creditors were owed R3600000.
The following projections and proposals were made by Dreamit Electronics Ltd for 2024:
The sales are expected to increase from R30000000 in 2023 to R40000000 in 2024. All the sales are on credit. Accounts receivable is based on a collection period of 36.5 days. Accounts payable must be calculated using the percentage-of-sales method. The gross margin and net profit margin ratios are expected to be 25% and 10% respectively for 2024. All purchases of inventory are on credit. Purchases for 2024 are projected at R25000000. The company expects to show a net increase in cash of R500000 during 2024. R24000000 will be spent on additional land and buildings during the fourth quarter of 2024. The total depreciation for 2024 is forecasted at R4000000. During January 2024,1000000 ordinary shares are expected to be sold at R4 each. Dividends of R3000000 are expected to be recommended by the directors at the end of 2024. These dividends will be paid during 2025. R5500000 will be paid to Mesa Bank during 2024. This amount includes R2000000 for interest on loan. The amount of external funding (non-current debt) required must be calculated.
Dreamit Electronics Ltd has identified a new machine that it is considering for purchase at the start of 2025. The cost the machine is R4000000. The machine is expected to have a useful life of five years. No scrap value is anticipated. The annual profits that are expected to be generated from the machine are as follows: Year 1 R600000; Year 2 R620000; Year 3 R700000; Year 4 R660000; Year 5 R560000. The cost of capital is 15%. Depreciation is estimated at R800000 per year.
QUESTIONS
1. Prepare the Pro Forma Statement of Financial Position as at 31 December 2024.
(Ignore the investment opportunity for 2025.)
2. Refer to the investment opportunity for 2025(the purchase of a new machine) and calculate the following. Ignore taxes. Use only the four-decimals present value tables that appear in the attached image.
2.1 Accounting Rate of Return on average investment (expressed to two decimal places).
2.2 Net Present Value. Your answer must reflect the calculations of the present values and NPV.
2.3 Internal Rate of Return (expressed to two decimal places) if the net cash flows are R1200000 per year for five years. Your answer must include two net present value calculations (using consecutive rates/percentages) and interpolation.
( To the expert answering this, please ignore all text beyond this point and instead refer to the attached image to answer the questions above, thank you)
NumbPeriods67891012141620260NumberofPeriods411920340S019%6029%0.93270.87060.8131).94200.88800.83750.7903|0.99010.98040.97090.9615I 0.9524094340.93460.98030,96120,94260.92460.90700.89000.87340.97060,9423|0,9151|0.88900.86380,83960.8163340.92350.85350.78940.73070.8360020020.82770.68644|0.9143|0.8368|0.7664|0.70260.90530.82030.7441|0.8195|0.67300,85280,72840.62320.53390 swA o030.57030.47460.39570.74620.75990.71070.7050 D.66630.6651|0.62270.67680.6274).58200.64460.59190.54390.89630.80430.72240.64960.58470.52680.88740.78850.70140.62460.55680.49700.87870.77300.68100.60060.53030,4688 D.4150).87000.75790.66110.57750.50510.4423).387819%0.67170,45290.30660.208329%0.60800.37150,22810.1407L.97041.9416APPENDIX 1: Present value of R10.77980.60950.47760.37510.29530.23300.74190.55210.41200.30836913.003712.106213.865112.84930.45810.39364%0.23140.17410.14200.09720.08720.0543|0.55040.30480.16970.09510.05350,03030.01736020.33050.31187%5%0.47510.444089%0.92590.91740.85730.8417D.79380.77220.73500.70840.68060.64996%0.33870.2919)31660032059025020.63020.59630,56450.53460.50660,48030,45560.58350.,54700.SI320

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

Survey of Accounting

Authors: Thomas P. Edmonds, Frances M. McNair, Philip R. Olds, Bor Yi

3rd Edition

978-1259683794, 77490835, 1259683796, 9780077490836, 978-0078110856

More Books

Students also viewed these Accounting questions

Question

More than 1/2 the U.S. population is female.

Answered: 1 week ago