An asterisk (*) will appear to the right of an incorrect entry in the income statement and above or below
elements in the equations.
1.
Return on Investment (ROI) = Profit Margin x Investment Turnover
Sales
Commercial Division:
2.
Proposal 1 Proposal 2 Proposal 3
Sales
Cost of goods sold
Gross profit
Operating expenses
Operating income
3.
Return on Investment (ROI) = Profit Margin x Investment Turnover
Sales
Proposal 1:
Proposal 2:
=
[Key code here]
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Invested Assets
ROI
=
x
=
Return on Investment (ROI)
=
Operating Income
ROI
x
Sales
Operating Income
Problem 24(10)-4A
Name:
Section:
Score:
Key Code:
Instructions
For the Year Ended December 31, 20Y9
0%
Maxell Manufacturing Inc.⎯Commercial Division
Estimated Income Statements
Return on Investment (ROI)
=
x
=
x
Sales
Invested Assets
Proposal 3:
4.
meet(s) the required 21% return on investment.
5.
Return on Investment (ROI) = Profit Margin x Required Investment Turnover
= x Required Investment Turnover
Required Investment Turnover =
Current Investment Turnover =
Increase in Investment Turnover =
ROI
=
ROI
=
x
=
x
=
An asterisk (*) will appear to the right of an incorrect entry in the income statement and above or below
elements in the equations.
1.
Return on Investment (ROI) = Profit Margin x Investment Turnover
Sales
=
x
=
2.
Proposal 1 Proposal 2 Proposal 3
Sales 3,500,000$ 3,500,000$ 2,905,000$
3.
Return on Investment (ROI) = Profit Margin x Investment Turnover
Sales
=
x
=
Problem 24(10)-4A
Name:
Solution
Section:
ON
Cells with non-gray backgrounds are protected and cannot be edited.
Score:
Instructions
Answers are entered in the cells with gray backgrounds.
Return on Investment (ROI)
=
Operating Income
x
Sales
Invested Assets
For the Year Ended December 31, 20Y9
Maxell Manufacturing Inc.⎯Commercial Division
Estimated Income Statements
Return on Investment (ROI)
Operating Income
Sales
Invested Assets
=
x
Proposal 2:
5.
Return on Investment (ROI) = Profit Margin x Required Investment Turnover