- 15 Marks
MA – L1 – Q61 – Performance analysis
Calculate ROI for Keta Textiles Ltd for 5 years and assess division performance using ROI and other measures.
Question
Keta Textiles Ltd is planning to open a new investment centre, which will make and sell a single product. The investment in the new division at the beginning of the year will be GH¢2 million, consisting entirely of non-current assets. These are expected to have a five-year life with no residual value, and they will be depreciated each year at the rate of 20% of cost.
Sales in the first year of operation are expected to be GH¢4 million and the budgeted gross profit is 30%. Overhead costs excluding depreciation of non-current assets will be GH¢600,000 in Year 1.
The estimates for the first five years of operation are as follows:
(1) The company will not make any additional investment in non-current assets for the division in the first five years.
(2) The cost of sales per unit in the five years will remain constant, with no increases.
(3) Sales volume will be the same in Year 2 as in Year 1. Sales volume will then increase in Year 3 by 5% but will fall by 10% in Year 4 and a further 10% in Year 5.
(4) The sales price per unit will be increased by 5% in Year 2. There will be no change in sales prices in Year 3, but prices will be increased by 5% in Year 4 and again by 5% in Year 5.
(5) Overhead costs excluding depreciation will remain at GH¢600,000 for the first three years, but will then be GH¢700,000 in each of Years 4 and 5.
Required:
Calculate the return on investment for the division for each of the first five years, assuming that ROI is calculated using the net book value of assets at the beginning of the year.
Using ROI and any other measures of performance, assess the expected performance of the division over the five-year period.
Find Related Questions by Tags, levels, etc.