1.Last year's Margin = Net operating income ÷ Sales = $504,000 ÷ $7,200,000 = 7.0%
2.Last year's Turnover = Sales ÷ Average operating assets = $7,200,000 ÷ $4,000,000 = 1.80
3.Last year's ROI = Net operating income ÷ Average operating assets = $504,000 ÷ $4,000,000 = 12.6%
or
ROI = Margin × Turnover = 7.0% × 1.80 = 12.6%
4.The margin for this year's investment opportunity is:
Margin = Net operating income ÷ Sales = $124,800 ÷ $1,560,000 = 8.0%
5.The turnover for this year's investment opportunity is:
Turnover = Sales ÷ Average operating assets = $1,560,000 ÷ $1,200,000 = 1.30
6.The ROI for this year's investment opportunity is:
ROI = Net operating income ÷ Average operating assets = $124,800 ÷ $1,200,000 = 10.4%
or
ROI = Margin × Turnover = 8.0% × 1.30 = 10.4%
7.If the company pursues the investment opportunity and otherwise performs the same as last year, the margin will be:
Net operating income = $504,000 + $124,800 = $628,800
Sales = $7,200,000 + $1,560,000 = $8,760,000
Margin = Net operating income ÷ Sales = $628,800 ÷ $8,760,000 = 7.2%
8.If the company pursues the investment opportunity and otherwise performs the same as last year, the turnover will be:
Sales = $7,200,000 + $1,560,000 = $8,760,000
Average operating assets = $4,000,000 + $1,200,000 = $5,200,000
Turnover = Sales ÷ Average operating assets = $8,760,000 ÷ $5,200,000 = 1.68
9.If the company pursues the investment opportunity and otherwise performs the same as last year, the ROI will be:
ROI = Net operating income ÷ Average operating assets = $628,800 ÷ $5,200,000 = 12.1%
or
ROI = Margin × Turnover = 7.2% × 1.68 = 12.1%
10.The CEO would not pursue the investment opportunity because it decreases the overall ROI.The owners of the company would not want the CEO to pursue the investment opportunity because its ROI is less than the company's minimum required rate of return.