The Crunchy Granola Company is a diversified food company that specializes in all natural foods. The company has three operating divisions organized as investment centers. Condensed data taken from the records of the three divisions for the year ended June 30, 20Y7, are as follows:
Cereal Division |
Snack Cake Division |
Retail Bakeries Division |
|
Sales | $25,000,000 | $8,120,000 | $9,750,000 |
Cost of goods sold | 16,620,000 | 5,555,000 | 6,720,000 |
Operating expenses | 7,130,000 | 1,915,400 | 2,542,500 |
Invested assets | 7,142,857 | 2,030,000 | 3,250,000 |
The management of The Crunchy Granola Company is evaluating each division as a basis for planning a future expansion of operations.
Required: | |
1. | Prepare condensed divisional income statements for the three divisions, assuming that there were no service department charges. |
2. | Using the DuPont formula for return on investment, compute the profit margin, investment turnover, and return on investment for each division. If required, round your final answers to one decimal place. |
1. Prepare condensed divisional income statements for the three divisions, assuming that there were no service department charges.
The Crunchy Granola Company |
Divisional Income Statements |
For the Year Ended June 30, 20Y7 |
1 |
Cereal Division |
Snack Cake Division |
Retail Bakeries Division |
|
2 |
Sales |
|||
3 |
Cost of goods sold |
|||
4 |
Gross profit |
|||
5 |
Operating expenses |
|||
6 |
Income from operations |
For each division, subtract operating expenses from gross profit.
2. Using the DuPont formula for return on investment, compute the profit margin, investment turnover, and return on investment for each division. If required, round your final answers to one decimal place.
Division |
Profit Margin |
Investment Turnover |
ROI |
Cereal | % | % | |
Snack Cake | % | % | |
Retail Bakeries | % | % |
1. Prepare condensed divisional income statements for the three divisions, assuming that there were no service department charges.
The Crunchy Granola Company |
Divisional Income Statements |
For the Year Ended June 30, 20Y7 |
1 |
Cereal Division |
Snack Cake Division |
Retail Bakeries Division |
|
2 |
Sales |
25000000 | 8120000 | 9750000 |
3 |
Cost of goods sold |
16620000 | 5555000 | 6720000 |
4 |
Gross profit |
8380000 | 2565000 | 3030000 |
5 |
Operating expenses |
7130000 | 1915400 | 2542500 |
6 | Income from operation | 1250000 | 649600 | 487500 |
2. Using the DuPont formula for return on investment, compute the profit margin, investment turnover, and return on investment for each division. If required, round your final answers to one decimal place.
Division |
Profit Margin |
Investment Turnover |
ROI |
Cereal | 5% | 3.5 | 17.5% |
Snack Cake | 8% | 4 | 32% |
Retail Bakeries | 5% | 3 | 15% |
The Crunchy Granola Company is a diversified food company that specializes in all natural foods. The...
The Crunchy Granola Company is a diversified food company that specializes in all natural foods. The company has three operating divisions organized as investment centers. Condensed data taken from the records of the three divisions for the year ended June 30, 20Y7, are as follows: Cereal Division Snack Cake Division Retail Bakeries Division Sales $27,100,000 $8,040,000 $9,750,000 Cost of goods sold 16,690,000 5,575,000 6,710,000 Operating expenses 8,784,000 1,741,400 2,260,000 Invested assets 9,033,333 2,010,000 3,900,000 The management of The Crunchy Granola...
Divisional Income Statements and Rate of Return on Investment Analysis Sunshine Food Company is a diversified food company that specializes in all natural foods. The company has three operating divisions organized as investment centers. Condensed data taken from the records of the three divisions for the year ended June 30, 2016, are as follows: Retail Bakeries Division Cereal Snack Cake Division Division $3,220,000 1,960,000 551,600 4,600,000 $3,000,000 1,770,000 390,000 2,500,000 Sales Cost of goods sold Operating expenses Invested assets The...
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...
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.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,560,000 $1,640,000 $1,530,000 Operating expenses 762,000 603,200 1,083,600 Invested assets 5,700,000 4,800,000 3,100,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 $930,000 $960,000 $930,000 Operating expenses 454,000 355,200 656,400 Invested assets 3,400,000 2,800,000 1,900,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, 2048, are as follows: Mutual Fund Division Electronic Brokerage Division Investment Banking Division $740,000 Fee revenue Operating expenses 399,800 2,700,000 $790,000 376,000 2,300,000 $740,000 560,000 1,500,000 Invested assets 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...