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:
Road Bike Division | Mountain Bike Division | |||
Sales | $ 5,760,000 | $ 6,100,000 | ||
Cost of goods sold | 2,534,000 | 2,867,000 | ||
Operating expenses | 2,304,400 | 2,013,000 | ||
Invested assets | 4,800,000 | 6,100,000 |
Required:
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 | Profit Margin | Investment Turnover | ROI |
Road Bike Division | % | % | |
Mountain Bike Division | % | % |
3. If management desires a minimum acceptable rate of return of 18%, determine the residual income for each division. If required, use the minus sign to indicate a negative income.
Residual Income | |
Road Bike Division | $ |
Mountain Bike Division | $ |
4. On the basis of income from operations, the Division is the more profitable of the two divisions. However, income from operations consider the amount of invested assets in each division. On the basis of residual income, the Division is the more profitable of the two divisions.
Requirement -1: Divisional Income Statement | ||
Road Bike Division | Mountain Bike Division | |
Sales | $5,760,000 | $6,100,000 |
Cost of Goods Sold | -$2,354,000 | -$2,867,000 |
Gross Profit | $3,406,000 | $3,233,000 |
Operating Expense | -$2,304,400 | -$2,013,000 |
Net Income | $1,101,600 | $1,220,000 |
Requirement-2 | ||
Road Bike Division | Mountain Bike Division | |
Profit Margin (a) | 19.13% | 20.00% |
Asset Turnover Ratio (b) | 1.2 | 1.00 |
Return on Investment (axb) | 22.95% | 20.00% |
Requirement-3 | ||
Road Bike Division | Mountain Bike Division | |
Invested Assets (a) | $4,800,000 | $6,100,000 |
Accepted rate of Return (b) | 18% | 18% |
Expected Net Income (c=axb) | $864,000 | $1,098,000 |
Actual Net Income (d) | $1,101,600 | $1,220,000 |
Residual Income (d-c) | $237,600 | $122,000 |
Working Note-1 | ||
Road Bike Division | Mountain Bike Division | |
Net Income (a) | $1,101,600 | $1,220,000 |
Invested Assets (b) | $4,800,000 | $6,100,000 |
Return On Investment (axb) | 22.95% | 20.00% |
Working Note-2 | ||
Road Bike Division | Mountain Bike Division | |
Net Income (a) | $1,101,600 | $1,220,000 |
Sales (b) | $5,760,000 | $6,100,000 |
Profit Margin (axb) | 19.13% | 20.00% |
Working Note-3 | ||
Road Bike Division | Mountain Bike Division | |
Sales (a) | $5,760,000 | $6,100,000 |
Invested Assets (b) | $4,800,000 | $6,100,000 |
Asset Turnover Ratio (a/b) | 1.2 | 1.00 |
Divisional Performance Analysis and Evaluation The vice president of operations of Free Ride Bike Company is...
Divisional Performance Analysis and Evaluation Divisional Performance Analysis and Evaluation The vice president of operations of Recycling Industries 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: Business Division Consumer Division $42,800,000 Sales Cost of goods sold Operating expenses Invested assets 23,500,000 11,424,800 34,240,000 $56,000,000 30,500,000 14,300,000 70,000,000 Required: 1. Prepare condensed divisional income statements for the year ended December 31,...
Divisional Performance Analysis and Evaluation The vice president of operations of Recycling Industries 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: Business Division Consumer Division Sales $42,800,000 $56,000,000 Cost of goods sold 23,500,000 30,500,000 Operating expenses 11,424,800 14,300,000 Invested assets 34,240,000 70,000,000 Required: 1. Prepare condensed divisional income statements for the year ended December 31, 20Y8, assuming that there were...
Divisional Performance Analysis and Evaluation The vice president of operations of Recycling Industries 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: Business Division Consumer Division Sales $42,800,000 $56,000,000 Cost of goods sold 23,500,000 30,500,000 Operating expenses 11,424,800 14,300,000 Invested assets 34,240,000 70,000,000 Required: 1. Prepare condensed divisional income statements for the year ended December 31, 20Y8, assuming that there were...
The vice president of operations of Recycling Industries 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: Business Division Consumer Division Sales $2,200,000 $2,490,000 Cost of goods sold 1,260,000 1,335,000 Operating expenses 698,000 831,300 Invested assets 1,100,000 2,490,000 1. Prepare condensed divisional income statements for the year ended December 31, 20Y8, assuming that there were no service department charges. Recycling Industries...
i need help woth the following The vice president of operations of Pavone 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: Business Division Consumer Division Sales $2,070,000 $2,490,000 Cost of goods sold 1,250,000 1,330,000 Operating expenses 613,000 811,400 Invested assets 862,500 2,766,667 Required: 1. Prepare condensed divisional income statements for the year ended December 31, 2016, assuming that there...
Divisional Income Statements and Return on Investment Analysis E.F. Lynch Company is a diversified investment company with three operating divisions organized as investment centers. Condensed data taken from the records of the three divisions for the year ended June 30, 20Y8, are as follows: Mutual Fund Division Electronic Brokerage Division Investment Banking Division Fee revenue $1,670,000 $1,740,000 $1,620,000 Operating expenses 901,400 730,200 1,224,000 Invested assets 6,100,000 5,100,000 3,300,000 The management of E.F. Lynch Company is evaluating each division as a...
Divisional Income Statements and Return on Investment Analysis E. Lynch Company is a diversified investment company with three operating divisions organized as investment centers, Condensed data taken from the records of the three divisions for the year ended June 30, 2018, are as follows: Mutual Fund Division Electronic Brokerage Division Investment Banking Division Fee revenue $760,000 $790,000 $790,000 Operating expenses 368,000 293,200 559,600 Invested assets 2,800,000 2,300,000 1,600,000 The management of E. Lynch Company is evaluating each division as a...
Divisional income statements and return on investment analysis E.F. Lynch Company is a diversified investment company with three operating divisions organized as investment centers. Condensed data taken from the records of the three divisions for the year ended June 30, 2048, are as follows: Mutual Fund Division Electronic Brokerage Division Investment Banking Division Fee revenue Operating expenses Invested assets $4,140,000 2,980,800 5,175,000 $3,360,000 3,091,200 1,120,000 $4,560,000 3,739,200 3,800,000 The management of E.F. Lynch Company is evaluating each division as a...
Divisional Income Statements and Return on Investment Analysis E.F. Lynch Company is a diversified investment company with three operating divisions organized as investment centers. Condensed data taken from the records of the three divisions for the year ended June 30, 20Y8, are as follows: Mutual Fund Division Electronic Brokerage Division Investment Banking Division Fee revenue $1,610,000 $1,680,000 $1,620,000 Operating expenses 784,000 621,600 1,144,800 Invested assets 5,900,000 4,900,000 3,300,000 The management of E.F. Lynch Company is evaluating each division as a...
Divisional Income Statements and Return on Investment Analysis E.F. Lynch Company is a diversified investment company with three operating divisions organized as investment centers. Condensed data taken from the records of the three divisions for the year ended June 30, 20Y8, are as follows: Mutual Fund Division Electronic Brokerage Division Investment Banking Division Fee revenue $2,270,000 $2,360,000 $2,260,000 Operating 1,108,000 869,600 1,597,600 expenses Invested assets 8,300,000 6,900,000 4,600,000 The management of E.F. Lynch Company is evaluating each division as a...