(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
Determine ROI of MN Segment, if income from operations is $6,818,000,000, sales are $20,356,000,000, and assets invested are $28,627,000,000.
Determine ROI of PR Segment, if income from operations is $2,220,000,000, sales are $14,087,000,000, and assets invested are $22,056,000,000.
Determine ROI of SE Segment, if income from operations is $661,000,000, sales are $5,979,000,000, and assets invested are $14,750,000,000.
Determine ROI of CP Segment, if income from operations is $1,112,000,000, sales are $3,811,000,000, and assets invested are $7,506,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 33.5%, and 0.71 and producing high ROI of 23.8%.
- Investment turnover of SE Segment is very low comparably and produces low ROI of 4.6%.
- CP Segment stands in the second place with 29.2% profit margin and produces ROI of 14.9%.
- PR Segment stands in the third place with 0.64 investment turnover and produces ROI of 10.1%.
Want to see more full solutions like this?
Chapter 23 Solutions
Bundle: Financial & Managerial Accounting, 13th + CengageNOWv2, 2 terms (12 months) Printed Access Card
- The Walt Disney Company (DIS) has four business segments, described as follows: Media Networks: Television and radio Parks and Resorts: Resorts, including Disneyland Studio Entertainment: Motion pictures, musical recordings, and stage plays Consumer Products Interactive Media: Character merchandising, Disney stores, books, and games Disney recently reported segment operating income, revenue, and invested assets (in millions) as follows: a. Use the DuPont formula to determine the return on investment for the four Disney segments. Round percentages to one decimal place and investment turnover to two decimal places. b. How do the four segments differ in their profit margin, investment turnover, and return on investment?arrow_forwardStarwood Hotels (Starwood) owns and operates many hotel properties under well-known brand names, including Sheraton, W, Westin, and St. Regis. Starwood focuses on the upper end of the lodging industry. Choice Hotels (Choice) is primarily a franchisor of several hotel chains, including Comfort Inn, Sleep Inn, Clarion, EconoLodge, and Rodeway Inn. Choice properties represent primarily the midscale and economy segments of the lodging industry. Exhibit 4.39 (page 315) presents selected profitability ratios and other data for Starwood, and Exhibit 4.40 (page 315) presents data for Choice. (Note that ROCE is not meaningful for Choice because of negative common shareholders equity due to open market share repurchases, not accumulated deficits. As of the end of 2008, Choice had repurchased over one-third of all common shares issued: 34,640,510 out of 95,345,362 shares.) One of the closely followed metrics in the lodging industry is occupancy rate, which gives an indication of the capacity utilization of available hotel rooms. A second measure is the ADR (average daily rate), which measures the amount actually collected for an average room per night. Finally, REVPAR (revenue per available room) also is an important measure, which measures periodto-period growth in revenues per room for comparable properties (adjusted for properties sold or closed or otherwise not comparable across years). The interaction of occupancy rate and ADR is REVPAR. Exhibit 4.39 Exhibit 4.40 REQUIRED Analyze the changes and the differences in the profitability of these two hotel chains to the deepest levels available given the data provided. Compare and contrast the ROAs and ROCEs of both companies. Do the results match your prior expectations given the type of lodging for which each company specializes?arrow_forwardHasbro is a leading firm in the toy, game, and amusement industry. Its promoted brands group includes products from Playskool, Tonka, Milton Bradley, Parker Brothers, Tiger, and Wizards of the Coast. Sales of toys and games are highly variable from year to year depending on whether the latest products meet consumer interests. Hasbro also faces increasing competition from electronic and online games. Hasbro develops and promotes its core brands and manufactures and distributes products created by others under license arrangements. Hasbro pays a royalty to the creator of such products. In recent years, Hasbro has attempted to reduce its reliance on license arrangements, placing more emphasis on its core brands. Hasbro also has embarked on a strategy of reducing fixed selling and administrative costs in an effort to offset the negative effects on earnings of highly variable sales. Exhibit 4.30 presents the balance sheets for Hasbro for the years ended December 31, Years 1 through 4. Exhibit 4.31 presents the income statements and Exhibit 4.32 presents the statements of cash flows for Years 2 through 4. Exhibit 4.30 Exhibit 4.31 Exhibit 4.32 REQUIRED a. Exhibit 4.33 presents profitability ratios for Hasbro for Year 2 and Year 3. Calculate each of these financial ratios for Year 4. The income tax rate is 35%. b. Analyze the changes in ROA and its components for Hasbro over the three-year period, suggesting reasons for the changes observed. c. Analyze the changes in ROCE and its components for Hasbro over the three-year period, suggesting reasons for the changes observed. Exhibit 4.33arrow_forward
- Identify the type of responsibility center (revenue center, cost center, profit center, or investment center) for each of the following situations. A. the legal department for Avon Manufacturing B. the Macys store in Mansfield, Ohio C. the food and beverage division of the Best Western D. the marketing department of the Hershey Company E. the Walmart #5030 on Central Avenue in Toledo, Ohio F. Apples Braeburn Capital Inc., where most of Apples billions of dollars are invested G. Zappos department store H. the mens clothing department in the Walmart #5030 in Toledo, Ohioarrow_forwardEntrepreneur magazine ranks franchises. Among the factors that the magazine uses in its rankings are growth rate, number of locations, start-up costs, and financial stability. A recent ranking listed the top 20 U.S. franchises and the number of locations as follows: These data can be found in the file Franchises. Create a PivotTable to summarize these data using classes 09,999, 10,00019,999, 20,00029,999, 30,00039,999 to answer the following questions. (Hint: Use Number of U.S. Locations as the COLUMNS, and use Count of Number of U.S. Locations as the VALUES in the PivotTable.) a. How many franchises have between 0 and 9,999 locations? b. How many franchises have more than 30,000 locations?arrow_forwardProfit center responsibility reporting for a service company Red Line Railroad Inc. has three regional divisions organized as profit centers. The chief executive officer (CEO) evaluates divisional performance, using operating income as a percent of revenues. The following quarterly income and expense accounts were provided from the trial balance as of December 31: The company operates three support departments: Shareholder Relations, Customer Support, and Legal. The Shareholder Relations Department conducts a variety of services for shareholders of the company. The Customer Support Department is the companys point of contact for new service, complaints, and requests for repair. The department believes that the number of customer contacts is a cost driver for this work. The Legal Department provides legal services for division management. The department believes that the number of hours billed is a cost driver for this work. The following additional information has been gathered: Instructions 1. Prepare quarterly income statements showing operating income for the three divisions. Use three column headings: East, West, and Central. 2. Identify the most successful division according to the profit margin. Round to the nearest whole percent. 3. Provide a recommendation to the CEO for a better method for evaluating the performance of the divisions. In your recommendation, identify the major weakness of the present method.arrow_forward
- CASE STUDY: INTRODUCING KBC DECORATING CO. Henri Martin and Wes Corbett have decided to go into business together and have chosen the name KBC Decorating Co. Their business will have two main divisions: a retail department to sell paint, wallpaper, and related interior decorating supplies; and a service department to do painting and decorating of office buildings, apartment blocks, and private homes. Martin and Corbett were previously in this same type of work but operated separate businesses. KBC Decorating Co. is located in Paris, Ontario, about an hour from Toronto. Martin and Corbett found a suitable location from which to operate their business, renting half of a warehouse building owned by Frank Bailes. Their space includes an office, retail space, and warehouse space. Your job is to keep the books for KBC Decorating Co. for the first calendar year (January to December). As you progress through these chapters, you will learn and do. Each chapter will introduce new concepts…arrow_forwardCASE STUDY: INTRODUCING KBC DECORATING CO. Henri Martin and Wes Corbett have decided to go into business together and have chosen the name KBC Decorating Co. Their business will have two main divisions: a retail department to sell paint, wallpaper, and related interior decorating supplies; and a service department to do painting and decorating of office buildings, apartment blocks, and private homes. Martin and Corbett were previously in this same type of work but operated separate businesses. KBC Decorating Co. is located in Paris, Ontario, about an hour from Toronto. Martin and Corbett found a suitable location from which to operate their business, renting half of a warehouse building owned by Frank Bailes. Their space includes an office, retail space, and warehouse space. Your job is to keep the books for KBC Decorating Co. for the first calendar year (January to December). As you progress through these chapters, you will learn and do. Each chapter will introduce new concepts that…arrow_forwardCase Analysis 2: Speed Racer in Victoria makes bicycles for people of all ages. The frames division makes and paints the frames and supplies them to the assembly division where the bicycles are assembled. Speed Racer is a successful and profitable corporation that attributes much of its success to its decentralized operating style. Each division manager is compensated on the basis of division operating income. The assembly division currently acquires all its frames from the frames division. The assembly division manager could purchase similar frames in the market for $480. The frames division is currently operating at 80% of its capacity of 4,000 frames (units) and has the following details: Voltage Regulator Direct materials ($150 per unit x 320 units) $480,000 Direct manufacturing labour ($60 per unit x 3,200 units) 192,000 Variable manufacturing overhead costs ($30 per unit × 3,200 units) 96,000 Fixed manufacturing overhead costs $624,000 All…arrow_forward
- Case Analysis 2: Speed Racer in Victoria makes bicycles for people of all ages. The frames division makes and paints the frames and supplies them to the assembly division where the bicycles are assembled. Speed Racer is a successful and profitable corporation that attributes much of its success to its decentralized operating style. Each division manager is compensated on the basis of division operating income. The assembly division currently acquires all its frames from the frames division. The assembly division manager could purchase similar frames in the market for $480. The frames division is currently operating at 80% of its capacity of 4,000 frames (units) and has the following details: Voltage Regulator Direct materials ($150 per unit x 320 units) $480,000 Direct manufacturing labour ($60 per unit x 3,200 units) 192,000 Variable manufacturing overhead costs ($30 per unit × 3,200 units) 96,000 Fixed manufacturing overhead costs $624,000 All the…arrow_forwardCase Analysis 2: Speed Racer in Victoria makes bicycles for people of all ages. The frames division makes and paints the frames and supplies them to the assembly division where the bicycles are assembled. Speed Racer is a successful and profitable corporation that attributes much of its success to its decentralized operating style. Each division manager is compensated on the basis of division operating income. The assembly division currently acquires all its frames from the frames division. The assembly division manager could purchase similar frames in the market for $480. The frames division is currently operating at 80% of its capacity of 4,000 frames (units) and has the following details: Voltage Regulator Direct materials ($150 per unit x 320 units) $480,000 Direct manufacturing labour ($60 per unit x 3,200 units) 192,000 Variable manufacturing overhead costs ($30 per unit × 3,200 units) 96,000 Fixed manufacturing overhead costs $624,000 All the…arrow_forwardQuestion Two relates to company A and company B. Company A: ‘Our company’s objective is to focus on the maximization of global shareholder wealth. We aim at all times to serve our shareholders by paying a high level of dividends and adopting strategies that will increase the company’s share price. Company B: ‘Our company’s primary objectives are to enhance our customers’ satisfaction and to grow our business. We aim to supply our customers with the highest quality products and provide outstanding levels of sales and delivery service, incapable of being matched by our competitors, and thereby increasing our market share.’ Required: (a) Discuss and contrast these objectives. Comment upon any possible ethical implications of the objectives. (b) Provide examples of ethical issues that might affect capital investment decisions.arrow_forward
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubEssentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage LearningFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
- Financial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeAccounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,