Divisional Performance Analysis and Evaluation The vice president of operations
ID: 2528902 • Letter: D
Question
Divisional Performance Analysis and Evaluation
The vice president of operations of Free Ride Bike Company is evaluating the performance of two divisions organized as investment centers. Invested assets and condensed income statement data for the past year for each division are as follows:
Required:
1. Prepare condensed divisional income statements for the year ended December 31, 20Y7, assuming that there were no service department charges.
Road Bike Division Mountain Bike Division Sales $ 3,600,000 $ 3,780,000 Cost of goods sold 1,584,000 1,777,000 Operating expenses 1,332,000 1,360,400 Invested assets 3,000,000 2,700,000 1. Prepare condensed divisional Income statements for the year ended December 31, 20Y7, assuming that there were no service department charges Free Ride Bike Company Divisional Income Statements For the Year Ended December 31, 20Y7 Road Bike Division Mountain Bike Division Sales Cost of goods sold Gross profit Operating expenses Income from operations 2. Using the DuPont formula for return on investment, determine the profit margin, investment turnover, and rate of return on investment for each division. If required, round your answers to one decimal place Division Road Bike Division Mountain Bike Division 3. If management desires a minimum acceptable rate of return of 14%, determine the residual income for each division. If required, use the minus sign to indicate a negative income Profit Margin Investment Turnover ROI Residual Income Road Bike Division Mountain Bike Division 4. On the basis of income from operations, the assets in each division. On the basis of residual income, the Divislon is the more profitable of the two divislons. However, Income from operations ? consider the amount of invested Division is the more profitable of the two divisions.Explanation / Answer
1)
2) Using of Du pont formula for computing ROI
Profit margin :
Road bike division = Net income / Sales = 684000/3600000 = 19%
Mountain bike division = 649600/3780000 = 17%
Investment Turnover :
Road bike division = Sales / Total investment = 3600000/3000000 = 1.2
mountain bike division = 3780000/2700000 = 1.4
ROI = Profit margin * Investment turonver
Road bike division = 19*1.2 =22.8%
Mountain bike division = 17*1.4 = 23.8%
3)If the management desires a minimum acceptable rate of return of 14% then residual income be,
Residual income = Operating income - (Return required on assets * Avg operating assets )
Road bike division = 684000-(14%*3000000) = $ 264000
Mountain bike division = 649600 - (14%*2700000) = $ 271600
4) On the basis of income from operations, Mountain bike division is more profitable of two divisions.
On the basis of residual income Mountain bike division is more profitable among two divisions.
2) Using of Du pont formula for computing ROI
Profit margin :
Road bike division = Net income / Sales = 684000/3600000 = 19%
Mountain bike division = 649600/3780000 = 17%
Investment Turnover :
Road bike division = Sales / Total investment = 3600000/3000000 = 1.2
mountain bike division = 3780000/2700000 = 1.4
ROI = Profit margin * Investment turonver
Road bike division = 19*1.2 =22.8%
Mountain bike division = 17*1.4 = 23.8%
3)If the management desires a minimum acceptable rate of return of 14% then residual income be,
Residual income = Operating income - (Return required on assets * Avg operating assets )
Road bike division = 684000-(14%*3000000) = $ 264000
Mountain bike division = 649600 - (14%*2700000) = $ 271600
4) On the basis of income from operations, Mountain bike division is more profitable of two divisions.
On the basis of residual income Mountain bike division is more profitable among two divisions.