Complete the following questions using Microsoft Excel. No other submission format is allowed. Review the grading rubric to confirm you are meeting the assignment requirements. (All amounts in SAR unless otherwise indicated.)
Problem 1
Miller Manufacturing Company is evaluating the results of two divisions:
| Items |
Eastern Division |
Western Division |
|
Sales |
40,000,000 |
70,000,000 |
|
Operating income |
3,800,000 |
6,500,000 |
|
Total assets |
21,000,000 |
19,000,000 |
Management expects each division to earn a 25% return on assets.
Required:
- Calculate the profit margin for each division.
- Calculate investment turnover for each division.
- Calculate Return on Investment using the DuPont formula.
- Calculate residual income for each division.
You must show all your work for credit.
Kindly, can you please put the answers with cells formulas and write the steps formulas for each question and make sure to clear each question alone either in a side or different tab. and highlite the givens or color them
0 comments