Question
ORBIT LIMITED: FINANCIAL PERFORMANCE AND FORECASTINGThe mission of Orbit Limited is to achieve its vision by providing an innovative product and creative customer experiences. Its
Orbit Limited Statement of Financial Position as at 31 December: 20222021 RR ASSETS Non-current assets11 810 0007 560 000Property, plant and equipment10 025 0006 250 000Investments1 785 0001 310 000Current assets4 190 0004 690 000Inventories1 875 0002 350 000Accounts receivable1 925 0002 200 000Cash390 000140 000Total assets16 000 00012 250 000EQUITY AND LIABILITIES Equity??Ordinary share capital5 480 0003 680 000Retained earnings??Non-current liabilities4 500 0003 800 000Loan (20% p.a.)4 500 0003 800 000Current liabilities2 300 0001 500 000Accounts payable2 300 0001 500 000
Total equity and liabilities16 000 00012 250 000
Statement of Comprehensive Income for the year ended 31 December: 20222021 RR Sales10 800 0007 150 000Cost of sales(6 000 000)(3 650 000)Gross profit4 800 0003 500 000Operating expenses(1 800 000)(1 200 000)Depreciation580 000200 000Other selling, general and administrative expenses1 220 0001 000 0000Operating profit3 000 0002 300 000Investment income??Interest expense(880 000)(600 000)Profit before tax2 600 0002 030 000Company tax(728 000)(568 400)Profit after tax1 872 0001 461 600
In addition to the above, the following information is available:All sales and purchases of inventory are on credit. Inventories on 31 December 2020 amounted to R1 500 000. Credit terms of 5/10 net 90 days are granted by creditors. Credit terms of 60 days are granted to debtors. Dividends declared for the years ended 31 December 2021 and 2022 amounted to R1 169 280 and R1 422 000 respectively.The financial manager of Orbit Limited provided the following forecasts for 2023:Sales are estimated at 8 000 units with a selling price of R1 800 each. The manufacturing costs include direct materials of R460 per unit, direct labour of R315 per unit, variable overheads of R170 per unit and fixed overheads of R880 000. Fixed selling and administration costs are estimated at R2 000 000 and the variable selling costs are estimated to be 7.5% of sales.The directors are contemplating diversification in 2024 by entering the passenger transport market. This could be achieved through the purchase of a fleet of midi buses that are expected to cost R9 500 000. An additional R500 000 will be spent on import duties. The cost of operating the buses each year is expected to be R4 100 000 and the annual revenues from transporting the passengers are estimated at R7 000 000. The buses
are expected to have a total salvage value of R1 000 000 and the estimated useful life of the buses is five years. The companys cost of capital is expected to reduce to 15%. Depreciation is calculated using the straight-line method
REQUIRED 1.1 Calculate the increase in the retained earnings over the two-year period. ( 1.2 By how much did the interest income increase or decrease from 2021 to 2022? Provide a possible reason for the change. 1.3 Comment on the investing activities of the company. 1.4 Calculate the amount that would be reflected as Changes in working capital in the Statement of Cash Flows for the year ended 31 December 2022. 1.5 Without making use of any ratios, provide an interpretation of the following over the twoyear period: 1.5.1 Inventories 1.5.2 Accounts receivable 1.6 Calculate the cost (as a percentage) of not accepting discounts from creditors in settlement of accounts.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started