(a)
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:
Investment turnover: This ratio gauges the operating efficiency by quantifying the amount of sales generated from the assets invested.
Formula of investment turnover:
Formula of ROI according to Dupont formula:
To determine: Return on investment of MN Segment, PR Segment, SE Segment, and CP Segment, using Dupont formula
(a)
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.
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.
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.
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.
(b)
To explain: The differences in profit margin, investment turnover, and return on investment of MN Segment, PR Segment, SE Segment, and CP Segment.
(b)
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%.
Want to see more full solutions like this?
Chapter 23 Solutions
Financial & Managerial Accounting
- Return on investment Commodore Entertainment has four profitable business segments, described as follows: • Media Networks: Television and radio• Parks and Resorts: Resorts, including Commodore land• Studio Entertainment: Motion pictures, musical recordings, and stage plays• Consumer Products: Character merchandising, Commodore stores, books, and magazines Commodore Entertainment recently reported sector income from operations, revenue, and invested assets as follows: Income from Operations Revenue Invested Assets Media Networks $193,644 $586,800 $978,000 Parks and Resorts 63,954 392,700 561,000 Studio Entertainment 12,927 333,600 417,000 Consumer Products 118,233 469,800 261,000 a. Use the DuPont formula to determine the return on investment for the four Commodore Entertainment sectors. Round Profit Margin and ROI to one decimal place and Investment Turnover to two decimal places. Profit Margin Investment Turnover ROI…arrow_forwardThe income statement comparison for Rush Delivery Company shows the income statement for the current and prior year. A. Determine the operating income (loss) (dollars) for each year. B. Determine the operating income (percentage) for each year. C. The company made a strategic decision to invest in additional assets in the current year. These amounts are provided. Using the total assets amounts as the investment base, calculate the ROI. Was the decision to invest additional assets in the company successful? Explain. D. Assuming an 8% cost of capital, calculate the RI for each year. Explain how this compares to your findings in part C.arrow_forwardRequired information [The following information applies to the questions displayed below.] Megamart provides the following information on its two investment centers. Investment Center Electronics Income $ 3,114,000 2,261,000 Average Assets $ 17,300,000 13,300,000 Sporting goods Sales $ 41,520,000 18,088,000 1. Compute return on investment for each center. Using return on investment, which center is most efficient at using assets to generate income? 2. Assume a target income of 11% of average assets. Compute residual income for each center. Which center generated the most residual income? 3. Assume the Electronics center is presented with a new investment opportunity that will yield a 14% return on investment. Should the new investment opportunity be accepted? The target return is 11%. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Compute return on investment for each center. Using return on investment, which center is most efficient…arrow_forward
- Required Information [The following Information applies to the questions displayed below.] Megamart provides the following Information on its two Investment centers. Investment Center Electronics Sporting goods Sales $ 63,460,000 19,050,000 1. Compute return on Investment for each center. Using return on investment, which center is most efficient at using assets to generate Income? 2. Assume a target Income of 12% of average assets. Compute residual income for each center. Which center generated the most residual Income? 3. Assume the Electronics center is presented with a new Investment opportunity that will yield a 14% return on Investment. Should the new Investment opportunity be accepted? The target return is 12%. Complete this question by entering your answers in the tabs below. Numerator: Required 1 Required 2 Required 3 Compute return on investment for each center. Using return on investment, which center is most efficient at using assets to generate income? Income $ 3,173,000…arrow_forwardConsider the following data and determine which of the corporate divisions is more profitable. Explain your reasoning. Domestic International Operating income $8,000,000 $ 11,000,000 Average total assets 20,000,000 32,000,000 C Begin by selecting the formula to calcula return on investment (ROI), and then enter the amounts to calculate each division's ROI. (Enter your answer as a percent rounded to one decimal place, X.X%) ROI % Domestic % International In terms of return on investment (ROI) the Division is more profitable becausearrow_forwardProfit Margin, Investment Turnover, and ROI Snodgrass Company has income from operations of $232,800, invested assets of $970,000, and sales of $3,880,000. Use the DuPont formula to compute the return on investment and show (a) the profit margin, (b) the investment turnover, and (c) the return on investment. Round your answers to one decimal place. a. Profit margin b. Investment turnover c. Return on investment %arrow_forward
- Please send answer in chart set up Megamart, a retailer of consumer goods, provides the following information on two of its departments (each considered an investment center). Investment Center Sales Income AverageInvested Assets Electronics $ 39,840,000 $ 2,988,000 $ 16,600,000 Sporting goods 25,200,000 2,142,000 12,600,000 1. Compute return on investment for each department. Using return on investment, which department is most efficient at using assets to generate returns for the company?2. Assume a target income level of 11% of average invested assets. Compute residual income for each department. Which department generated the most residual income for the company?3. Assume the Electronics department is presented with a new investment opportunity that will yield a 15% return on investment. Should the new investment opportunity be accepted?arrow_forwardReturn on Investment The income from operations and the amount of invested assets in each division of Beck Industries are as follows: Income from Operations Retail Division Commercial Division Internet Division Division Retail Division Commercial Division $91,200 126,500 a. Compute the return on investment for each division. (Round to the nearest whole number.) Percent Internet Division 81,900 % Invested Assets % $480,000 390,000 550,000 b. Which division is the most profitable per dollar invested?arrow_forwardB. ABC Corporation is a diversified company with 3 divisions organized as investment centers. Data for the year ended Dec 31, 20X2 are as follows: Fee Revenue Operating Expenses Invested Assets Retail Division 1,250,000 750,000 3,125,000 Electronic Division 750,000 682,500 250,000 Banking Division 1,500,000 1,170,000 2,000,000 REQUIRED: Compute for the profit margin, investment turnover and return on investment. Explain which of the divisions will you recommend for additional funding.arrow_forward
- Profit Margin, Investment Turnover, and ROI Briggs Company has income from operations of $132,756, invested assets of $299,000, and sales of $1,106,300. Use the DuPont formula to compute the return on investment. If required, round your answers to two decimal places. a. Profit margin % b. Investment turnover c. Return on investment %arrow_forwardProfit 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 Cost of goods sold Gross profit Administrative expenses Income from operations 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 investment of the Consumer Products Division, assuming that $1,950,000 of assets have been invested in the Consumer Products Division. Round the investment turnover to one decimal place. Profit margin Investment turnover Rate of return on investment Profit margin Investment turnover $1,170,000 526,500 $643,500 409,500 $234,000 b. If expenses could be reduced by $58,500 without decreasing sales, what would be the impact on the profit margin, investment turnover, and return on…arrow_forwardThe income statement comparison for Forklift Material Handling shows the income statement for the current and prior year. A. Determine the operating income (loss) (dollars) for each year. B. Determine the operating income (percentage) for each year. C. The company made a strategic decision to invest in additional assets in the current year. These amounts are provided. Using the total assets amounts as the investment base, calculate the return on investment. Was the decision to invest additional assets in the company successful? Explain. D. Assuming an 8% cost of capital, calculate the residual income for each year. Explain how this compares to your findings in part C.arrow_forward
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning