Chapter 23, Problem 23.14EX

(a)

To determine

Profit margin: This ratio gauges the operating profitability by quantifying the amount of income earned from business operations from the sales generated.

Formula of profit margin:

$\text{Profit margin}=\frac{\text{Income from operations}}{\text{Sales}}$

Investment turnover: This ratio gauges the operating efficiency by quantifying the amount of sales generated from the assets invested.

Formula of investment turnover:

$\text{Investment turnover}=\frac{\text{Sales}}{\text{Invested assets}}$

Return on investment (ROI): This financial ratio evaluates how efficiently the assets are used in earning income from operations. So, ROI is a tool used to measure and compare the performance of a units or divisions or a companies.

Formula of ROI according to Dupont formula:

$\begin{array}{c}\text{Return on investment = Profit margin × Investment turnover}\\ \text{=}\frac{\text{Income from operations}}{\text{Sales}}\times \frac{\text{Sales}}{\text{Invested assets}}\\ \text{=}\frac{\text{Income from operations}}{\text{Invested assets}}\end{array}$

To determine: Return on investment of MN Segment, PR Segment, SE Segment, and CP Segment, using Dupont formula

Explanation of Solution

1)

Determine ROI of MN Segment, if income from operations is $7,321,000,000, sales are $21,152,000,000, and assets invested are $29,887,000,000.

$\begin{array}{c}\text{Return on investment = Profit margin × Investment turnover}\\ \text{=}\frac{\text{Income from operations}}{\text{Sales}}\times \frac{\text{Sales}}{\text{Invested assets}}\\ =\frac{\$7,321,000,000}{\$21,152,000,000}\times \frac{\$21,152,000,000}{\$29,887,000,000}\\ \text{= }34.6\%\times 0.71\\ \text{= 24}\text{.6\%}\end{array}$

2)

Determine ROI of PR Segment, if income from operations is $2,663,000,000, sales are $15,099,000,000, and assets invested are $23,335,000,000.

$\begin{array}{c}\text{Return on investment = Profit margin × Investment turnover}\\ \text{=}\frac{\text{Income from operations}}{\text{Sales}}\times \frac{\text{Sales}}{\text{Invested assets}}\\ =\frac{\$2,663,000,000}{\$15,099,000,000}\times \frac{\$15,099,000,000}{\$23,335,000,000}\\ \text{= }17.6\%\times 0.65\\ \text{= 11}\text{.4\%}\end{array}$

3)

Determine ROI of SE Segment, if income from operations is $1,549,000,000, sales are $6,988,000,000, and assets invested are $15,555,000,000.

$\begin{array}{c}\text{Return on investment = Profit margin }\text{× Investment turnover}\\ \text{=}\frac{\text{Income from operations}}{\text{Sales}}\times \frac{\text{Sales}}{\text{Invested assets}}\\ =\frac{\$1,549,000,000}{\$6,998,000,000}\times \frac{\$6,998,000,000}{\$15,555,000,000}\\ \text{= }22.2\%\times 0.46\\ \text{= 10}\text{.2\%}\end{array}$

4)

Determine ROI of CP Segment, if income from operations is $1,356,000,000, sales are $4,274,000,000, and assets invested are $7,526,000,000.

$\begin{array}{c}\text{Return on investment = Profit margin × Investment turnover}\\ \text{=}\frac{\text{Income from operations}}{\text{Sales}}\times \frac{\text{Sales}}{\text{Invested assets}}\\ =\frac{\$1,356,000,000}{\$4,274,000,000}\times \frac{\$4,274,000,000}{\$7,526,000,000}\\ \text{= }31.7\%\times 0.57\\ \text{= 18}\text{.1\%}\end{array}$

(b)

To determine

To explain: The differences in profit margin, investment turnover, and return on investment of MN Segment, PR Segment, SE Segment, and CP Segment.

Explanation of Solution

The following are the differences in profit margin, investment turnover, and return on investment of MN Segment, PR Segment, SE Segment, and CP Segment:

• Profit margin and investment turnover of MN Segment are high comparably, with 34.6%, and 0.71 and producing high ROI of 24.6%.
• Investment turnover of SE Segment is very low comparably and produces low ROI of 10.2%.
• CP Segment stands in the second place with 31.7% profit margin and produces ROI of 18.1%.
• PR Segment stands in the third place with 0.65 investment turnover and produces ROI of 11.4%.