Question

In: Accounting

Mastery Problem: Return on Investment, margin, and turnover Return on Investment (ROI) The manager of an...

Mastery Problem: Return on Investment, margin, and turnover

Return on Investment (ROI)

The manager of an investment center should be evaluated based on revenues, costs, and investments. An evaluation based on net income ignores the amount of investment the investment center required. One way to measure operating profit in relation to investment is a calculation called the return on investment.

One formula for calculating return on investment is:
Operating income
Invested Assets

ROI is effective because it takes into consideration the three factors under the control of an investment center manager: revenues, costs, and investments. ROI measures the income (or return) earned on each dollar of investment.

APPLY THE CONCEPTS: Calculating return on investment

The divisional income statements for three divisions of the Chung Company are shown.

Chung Company
Divisional Income Statements
For the Year Ending December 31, 20Y8
Division A Division B Division C
Sales Revenue $960,000 $900,000 $320,000
Operating expenses (564,500) (675,000) (170,000)
Operating income before service department charges $395,500 $225,000 $150,000
Service department charges (275,500) (135,000) (70,000)
Operating income $120,000 $90,000 $80,000

Additional financial data from the three divisions of the Chung Company are shown.

Division A Division B Division C
Invested assets $1,000,000 $600,000 $400,000

Calculate the return on investment for each division. If required, round the ROI to the nearest hundredth of a percent (for example, 16.943% would be rounded to 16.94%).

Division A Division B Division C
Return on investment % % %

Margin and Turnover

One way to analyze the difference in return on investment for each division is to separate the return on investment formula into two calculations: margin and turnover. Margin shows the relationship between operating income and sales. It measures the profit earned for each dollar of sales, which is a measure of . Turnover shows the relationship between sales and invested assets. It measures how many dollars of sales result from each dollar of invested assets, which is a measure of .

The formulas for margin and turnover are:

Margin =
Turnover =

APPLY THE CONCEPTS: Calculating margin and turnover

Calculate the margin and the turnover for each division. If required, round margin to the nearest tenth of a percent (for example, 14.6%) and turnover to two decimal places (for example, 0.82).

Division A Division B Division C
Margin % % %
Turnover

The division showing the highest operating profitability is Division .

The division showing the highest operating efficiency is Division .

APPLY THE CONCEPTS: Using margin and turnover to calculate return on investment

A second way to calculate return on investment (ROI) is Return on Investment = Margin x Turnover. Using the margins and turnovers you recorded above, calculate the return on investment for each division. If required, round the return on investment to the nearest hundredth of a percent (for example, 16.94%).

Division A Division B Division C
Return on investment % % %

APPLY THE CONCEPTS: Determining which ROI formula to use

There are two formulas for calculating ROI:

  1. ROI = Operating income / Invested Assets
  2. ROI = Margin x Turnover

Why would a company use the second formula (ROI = Margin x Turnover) to calculate ROI? Select the YES or NO to the following statements.

a. Margin can be tracked separately.
b. If ROI changes, managers can determine which factor caused overall ROI to change.
c. It is easier to calculate.
d. Turnover can be tracked separately.
e. Both formulas give exactly the same information, so there is no reason to use the second formula.

Solutions

Expert Solution

Solution

Chung Company

Calculation of return on investment for each division:

Return on investment = operating income/invested assets

Division A –

ROI = $120,000/$1,000,000 = 12%

Division B -
ROI = 90,000/600,000 = 15%

Division C –

ROI = 80,000/400,000 = 20%

Margin and Turnover –

Division A

Division B

Division C

Margin

12.50%

10%

25%

Turnover

0.96

1.5

0.8

Computations:

Margin = operating income/sales revenue

Division A = 120,000/960,000 = 12.5%

Division B = 90,000/900,000 = 10%

Division C = 80,000/320,000 = 25%

Turnover = sales revenue/invested assets

Division A = 960,000/1,000,000 = 0.96

Division B = 900,000/600,000 = 1.5

Division C = 320,000/400,000 = 0.80

The Division showing the highest operating profitability is Division C, as its margin is highest.

The division showing the highest operating efficiency is Division B, because its turnover is highest.

Calculation of ROI applying concepts of margin and turnover:

ROI = margin x turnover

Division A = 12.5% x 0.96 = 12%

Division B = 10% x 1.5 = 15%

Division C = 25% x 0.80 = 20%

Division A

Division B

Division C

Margin

12.50%

10%

25%

Turnover

0.96

1.5

0.8

ROI

12%

15%

20%

A company would use the second formula (ROI = margin x turnover) to calculate ROI because if ROI changes, managers could determine which factor caused overall ROI to change.


Related Solutions

Mastery Problem: Return on Investment, margin, and turnover Return on Investment (ROI) The manager of an...
Mastery Problem: Return on Investment, margin, and turnover Return on Investment (ROI) The manager of an investment center should be evaluated based on revenues, costs, and investments. An evaluation based on net income ignores the amount of investment the investment center required. One way to measure operating profit in relation to investment is a calculation called the return on investment. One formula for calculating return on investment is: Operating income Invested Assets ROI is effective because it takes into consideration...
Calculating Average Operating Assets, Margin, Turnover, Return on Investment (ROI) Forchen, Inc., provided the following information...
Calculating Average Operating Assets, Margin, Turnover, Return on Investment (ROI) Forchen, Inc., provided the following information for two of its divisions for last year: Small Appliances Division Cleaning Products Division Sales $34,670,000 $34,800,000 Operating income 2,773,600 1,392,000 Operating assets, January 1 6,394,000 5,600,000 Operating assets, December 31 7,474,000 6,000,000 Required: 1. For the Small Appliances Division, calculate: a. Average operating assets $ b. Margin % c. Turnover d. Return on investment (ROI) % 2. For the Cleaning Products Division, calculate:...
Calculating Average Operating Assets, Margin, Turnover, Return on Investment (ROI) Forchen, Inc., provided the following information...
Calculating Average Operating Assets, Margin, Turnover, Return on Investment (ROI) Forchen, Inc., provided the following information for two of its divisions for last year: Small Appliances Division Cleaning Products Division Sales $34,670,000 $29,000,000 Operating income 2,773,600 1,160,000 Operating assets, January 1 6,394,000 5,600,000 Operating assets, December 31 7,474,000 6,000,000 Required: 1. For the Small Appliances Division, calculate: a. Average operating assets $ fill in the blank 1 b. Margin fill in the blank 2 % c. Turnover fill in the...
22. How is return on investment calculated and how it is used? Investment turnover? Profit Margin?...
22. How is return on investment calculated and how it is used? Investment turnover? Profit Margin? Residual income? 23. What is meant by centralized vs. decentralized organization? 24. What is the difference between controllable and uncontrollable costs?
Profit Margin, Investment Turnover, and return on investment The condensed income statement for the Consumer Products...
Profit Margin, Investment Turnover, and return on investment The condensed income statement for the Consumer Products Division of Fargo Industries Inc. is as follows (assuming no service department charges): Sales $912,000 Cost of goods sold 410,400 Gross profit $501,600 Administrative expenses 228,000 Income from operations $273,600 The manager of the Consumer Products Division is considering ways to increase the return on investment. a. Using the DuPont formula for return on investment, determine the profit margin, investment turnover, and return on...
Profit Margin, investment turnover, and return on investment The condensed income statement for the Consumer Products...
Profit Margin, investment turnover, and return on investment The condensed income statement for the Consumer Products Division of Fargo Industries Inc. is as follows (assuming no service department charges): Sales $82,500,000 Cost of goods sold 53,625,000 Gross profit $28,875,000 Administrative expenses 15,675,000 Income from operations $13,200,000 The manager of the Consumer Products Division is considering ways to increase the return on investment. a. Using the DuPont formula for return on investment, determine the profit margin, investment turnover, and return on...
Mastery Problem: Target Income and Margin of Safety Target Income and Margin of Safety At the...
Mastery Problem: Target Income and Margin of Safety Target Income and Margin of Safety At the break-even point, sales and costs are exactly equal. However, the goal of most companies is to make a profit. When a company decides that it wants to earn more than the break-even point of income, it must define the amount it thinks it will realistically make. By modifying the break-even equation, the sales required to earn a target or desired amount of profit may...
Mastery Problem: Target Income and Margin of Safety Target Income and Margin of Safety At the...
Mastery Problem: Target Income and Margin of Safety Target Income and Margin of Safety At the break-even point, sales and costs are exactly equal. However, the goal of most companies is to make a profit. When a company decides that it wants to earn more than the break-even point of income, it must define the amount it thinks it will realistically make. By modifying the break-even equation, the sales required to earn a target or desired amount of profit may...
I have the formulas for how to calculate ROI, Margin and Turnover. But I don't know...
I have the formulas for how to calculate ROI, Margin and Turnover. But I don't know if I am using the right numbers and it gets frustrating. A worked out calculation for each would really be helpful so I know what numbers from what years you plugged in. Your time is valuable and would really appreciate the help. If the response is correct, I would not mind giving a like! Return on Investment, Margin, Turnover Ready Electronics is facing stiff...
Explain in detail what is Return of Investment (ROI) & Discounted Return on Investment (DROI).
Explain in detail what is Return of Investment (ROI) & Discounted Return on Investment (DROI).
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT