Unlock access to all the studying documents.
View Full Document
An asterisk (*) will appear to the right of an incorrect entry in the income statement and above or below
elements in the equations. The essay answer will not be graded.
1.
Division Division
Sales
Cost of goods sold
Gross profit
Operating expenses
Income from operations
2.
Rate of Return (ROI) on Investment = Profit Margin x Investment Turnover
Sales
Business Division:
Consumer Division:
3.
Business Consumer
Division Division
Income from operations
Minimum acceptable return
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Divisional Income Statements
For the Year Ended December 31, 2014
Rate of Return (ROI) on Investment
An asterisk (*) will appear to the right of an incorrect entry in the income statement and above or below
elements in the equations. The essay answer will not be graded.
1.
Division Division
Sales 2,500,000$ 2,550,000$
2.
Rate of Return (ROI) on Investment = Profit Margin x Investment Turnover
Sales
Business Division:
$250,000 $2,500,000
3.
Business Consumer
Division Division
Income from operations 250,000$ 357,000$
Rate of Return (ROI) on Investment
Answers are entered in the cells with gray backgrounds.
For the Year Ended December 31, 2014
Divisional Income Statements
Cells with non-gray backgrounds are protected and cannot be edited.