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.
1.
Rate of Return (ROI) on Investment = Profit Margin x Investment Turnover
Sales
Electronics Division:
2.
Proposal 1 Proposal 2 Proposal 3
Sales
Cost of goods sold
Gross profit
Operating expenses
Income from operations
Invested assets
3.
Rate of Return (ROI) on Investment = Profit Margin x Investment Turnover
Sales
Proposal 1:
Proposal 2:
Proposal 3:
4.
meet(s) the required 20% rate of return on investment.
5.
Rate of return on investment (ROI) = Profit margin x Required investment turnover
= x Required investment turnover
Required investment turnover =
Current investment turnover =
Increase in investment turnover =
For the Year Ended December 31, 2014
Rate of Return (ROI) on Investment
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
GIHBLI INDUSTRIES INC.⎯ELECTRONICS DIVISION
Estimated Income Statements
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.
1.
Rate of Return (ROI) on Investment = Profit Margin x Investment Turnover
Sales
Electronics Division:
2.
Proposal 1 Proposal 2 Proposal 3
Sales 1,575,000$ 1,395,000$ 1,575,000$
3.
Rate of Return (ROI) on Investment = Profit Margin x Investment Turnover
Sales
Proposal 1:
Rate of Return (ROI) on Investment
Answers are entered in the cells with gray backgrounds.
For the Year Ended December 31, 2014
GIHBLI INDUSTRIES INC.⎯ELECTRONICS DIVISION
Estimated Income Statements
Rate of Return (ROI) on Investment
Cells with non-gray backgrounds are protected and cannot be edited.
=
x
=