Complete the following questions using Microsoft Excel. No other submission format is allowed.. (All amounts in SAR unless otherwise indicated.)
Problem 1
Miller Manufacturing Company is evaluating the results of two divisions:
ItemsEastern 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.