Exercise 22-23 Profit margin and investment turnover LO A2 L'Oréal reports the following for a recent year for the major divisions in its cosmetics branch. Total Assets Total Assets € millions Professional products Consumer products Luxury products Sales Income End of Year € 2,717 € 552 € 2,624 Beginning of Year € 2,516 9,530 4,507 1,765 5,994 3,651 5,496 4,059 791 Active cosmetics 1,386 278 830 817 Total €18,140 € 3,386 €13,099 €12,888 1. Compute profit margin for each division. Which L'Oréal division has the highest profit margin? 2. Compute investment turnover for each division. Which L'Oréal division has the best investment turnover? Completo thic quection by ontoxing voUN ancua Ns in the tahc holou
Q: EX 17-5 Horizontal analysis of the income statement Income statement data for Winthrop Company for…
A: Horizontal analysis is a financial statement analysis which shows changes in values of corresponding…
Q: %24 %24 Perez Company reported the following operating results for two consecutive years: Required…
A: Comparative balance sheet used to compare the financial statement of two or more periods. It is…
Q: Problem 14-46 (Static) Equipment Replacement and Performance Measures (LO 14-2) Oscar Clemente is…
A: Return on investment Return on income is used as a measure to the divisional performance. This a…
Q: Based on the data in Table 11.10, you have been asked to determine:a) The company's percentage of…
A: Common size analysis is one of the analysis which shows each item of balance asset as a percentage…
Q: The following data are available for the Eastern Division of Meyers Products, Inc. The company makes…
A: SOLUTION- FORMULAS= 1-DESIRED PROFIT=AVERAGE OPERATING ASSETS * ROI 2-UNITS MUST BE DIVISION SELL…
Q: Windsor Corporation is a diversified company that operates in five different industries: A, B, C, D,…
A:
Q: Question 4: Oman Company manufactures two products OM1 and OM2. Its sales department has three…
A: Sales budget is that budget which tells estimates about expected sales units and expected sales…
Q: EX 14-5 Horizontal analysis of the income statement Income statement data for Winthrop Company for…
A: Comparative income statement with horizontal analysis shows the absolute and percentage increase/…
Q: BCO Mortgage Company has the following two service and production departments related to its lending…
A: Using direct method, the service department costs are directly allocated to production department.
Q: QUESTION 23 ABCO Mortgage Company has the following two service and production departments…
A: Overhead can be allocated on the basis of a predetermined overhead rate and also by using activity…
Q: Quarter 1 Quarter 2 Sales $208,460 $211,540 Direct material purchases 115,295 120,831 Direct labor…
A: Cash Budget shows the amount of beginning cash balance, expected cash receipts and expected cash…
Q: For a recent year L’Oréal reported operating profit of €3,385 (in millions) for its Cosmetics…
A: Average Total Assets = (Beginning Total assets + Ending Total assets) / 2 Average Total Assets =…
Q: QUESTION 27 The following information pertains to Hepburn Company: Month Sales Purchases January…
A: The cash budget is prepared to record cash receipts and payments during the period.
Q: Selected sales and operating data for three divisions of different structural engineering firms are…
A: ROI or return on investment is a used for not only evaluating the profitability but also the…
Q: QS 9-14 (Algo) Components of performance measures LO A1, A2 Fill in the blanks in the schedule below…
A: profit margin ratio is a ratio that is calculated by taking net income on numerator and dividing it…
Q: EXERCISE 12-5 Contrasting Return on Investment (ROI) and Residual Income [LO2, LO31 Meiji Isetan…
A: 1. Formulas:
Q: Week13 Unit 11 Additional questions Question 1 Shown below are selected financial data for AB and XY…
A: Since you have posted a question with multiple sub-parts, we will solve the first three subparts for…
Q: PR 17-2A Vertical analysis of income statement OBJ. 1 For 2014, Kasay Company initiated a sales…
A: Comparative Income statement: Income statement is the statement that is given for net income from…
Q: Exercise 10-5 (Algo) Return on Investment (ROI) [LO10-1] Provide the missing data in the following…
A: Return on investment is a method used by investors to evaluate the investment and its performance in…
Q: Performance measures LO A1, A2 Investment center Department A…
A: Ratio analysis is a method of measuring the financial position of the organization with different…
Q: HORRISEY&BROMN, LTD. Income Statements For the Four Quarters Ending Decemnber 31 Quarter 1 Quarter 2…
A: I am answering question number 3 as asked by the skip. The income statement represents the net…
Q: Exercise 23-9 (Algo) Segment elimination LO P4 [The following information applies to the questions…
A: An avoidable expense is one which will not be incurred if a particular behavior is avoided. In…
Q: Problem #12: Profitability & Cost Analysis Car Deals Inc. has two divisions: New Cars and Used Cars.…
A:
Q: table by allocating the expenses of the two service departments
A: The allocation base for advertising department expenses is departmental sales and the allocation…
Q: Question 4:Dhofar Company manufactures two products M1 and Z1. Its sales department has three…
A: Please find the answer to the above question below:
Q: Unruh Corp. and its divisions are engaged solely in manufacturing operations. The following data…
A: For finding out if a segment is reportable or not, three tests are to be done; Revenue test, Profit…
Q: Jansen Company reports the following for its ski department for the year 2019. All of its costs are…
A: 1. Jansen Company Departmental Income Statement—Ski Department For Year Ended December…
Q: Case 11. Essence Company and its divisions are engaged solely in manufacturing. The following data…
A: A segment is reportable if its total revenue ( internal + external ) is 10% or more of total revenue…
Q: EXERCISE 12-4 The Income Statement columns of the August 31 (year-end) work sheet for Ralley Company…
A: An income statement seems to be a part of the financial statement of the firm and it includes the…
Q: Oscar Clemente is the manager of Forbes Division of Pitt, Inc., a manufacturer of biotech products.…
A: a. ROI, if Oscar does not acquire the new machine: ROI = Net Income / Total Investment * 100 =…
Q: Problem 7-5A a, b1-b3, c (Part Level Submission) (Video) Brislin Company has four operating…
A: Solution: Introduction: Contribution margin is the incremental Profit earned for the units sold by…
Q: Question 22 nts -/1 View Policies Current Attempt in Progress ns Drew Enterprises reports all its…
A: The correct answer is $312,000.
Q: Q # 1: The income statement for the Stylo Company for the past year is: Sales (150000 units @ $30)…
A: Since you have asked multiple questions, we will solve the first question for you. If you want any…
Q: Problem 14-44 (Algo) Comparing Business Units Using Economic Value Added (EVA) (LO 14-4) Colonial…
A: Answer - Working note- 1. Calculation of NOPAT (net operating profit after tax) : Statement of…
Q: Larson, Inc., manufactures backpacks. Last year, it sold 105,000 of its basic model for $20 per…
A: Answer) Calculation of Larsen’s Estimated Sales Revenue for Coming Year Larsen’s Expected Sales…
Q: PROBLEM 13-30 Restructuring a Segmented Income Statement [LO1] Losses have been incurred at Millard…
A: Since you have posted a question with many sub-parts, we will solve three sub-parts for you. To get…
Q: Williams Company began operations in January 2019 with two operating (selling) departments and one…
A: Solution: Williams Company Forecasted Departmental Income statement For the year ended Dec…
Q: Exercise 11-8 (Algo) Computing and Interpreting Return on Investment (ROI) [LO11-1) Selected…
A: Lets understand the basics. For calculating division's margin, we will need to use below formula.…
Q: PROBLEM 13-30 Restructuring a Segmented Income Statement [LO1] Losses have been incurred at Millard…
A: Segmented income statement:- Segmented income statement is the financial report that helps to…
Q: Problem 19-1A Midlands Inc. had a bad year in 2016. For the first time in its history, it operated…
A: Break-even point in value is the point of sales at which the profit is zero. Break-even point is the…
Q: Exercise 7 (Transfer Pricing from Viewpoint of the Entire Company) Division E manufactures picture…
A: Income statement is a part of financial statements. It shows the company’s income and expenditures…
Q: Exercise 9-10A Residual income Claire Cough Drops operates two divisions. The following information…
A: Computation of Division Residual Income:::: Particulars. Division A. Division B Desired…
Exercise 22-23 Profit margin and investment turnover LO A2
L’Oréal reports the following for a recent year for the major divisions in its cosmetics branch.
€ millions | Sales | Income | Total Assets End of Year |
Total Assets Beginning of Year |
|||||||||||
Professional products | € | 2,717 | € | 552 | € | 2,624 | € | 2,516 | |||||||
Consumer products | 9,530 | 1,765 | 5,994 | 5,496 | |||||||||||
Luxury products | 4,507 | 791 | 3,651 | 4,059 | |||||||||||
Active cosmetics | 1,386 | 278 | 830 | 817 | |||||||||||
Total | € | 18,140 | € | 3,386 | € | 13,099 | € | 12,888 | |||||||
1. Compute profit margin for each division. Which L’Oréal division has the highest profit margin?
2. Compute investment turnover for each division. Which L’Oréal division has the best investment turnover?
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
- Evaluating division performance Last Resort Industries Inc. is a privately held diversified company with live separate divisions organized as investment centers. A condensed income statement for the Specialty Products Division for the past year, assuming no service department charges, is as follows: Last Resort Industries Inc.Specialty Products Division Income Statement For the Year Ended December 31,20Y5 Sales 32,400,000 Cost of goods sold 24,300,000 Gross profit 8,100,000 Operating expenses 3,240,000 Income from operations 4,860,000 Invested assets 27,000,000 The manager of the Specialty Products Division was recently presented with the opportunity to add an additional product line, which would require invested assets of 14,400,000. A projected income statement for the new product line is as follows: New Product Line Projected Income Statement For the Year Ended December 31,20Y6 Sales 12,960,000 Cost of goods sold 7,500,000 Gross profit 5,460,000 Operating expenses 3,127,200 Income from operations 2,332,800 The Specialty Products Division currently has 27,000,000 in invested assets, and Last Resort Industries Inc.s overall return on investment, including all divisions, is 10%. Each division manager is evaluated on the basis of divisional return on investment. A bonus is paid, in 58,000 increments, for each whole percentage point that the divisions return on investment exceeds the company average. The president is concerned that the manager of the Specialty Products Division rejected the addition of the new product line, even though all estimates indicated that the product line would be profitable and would increase overall company income. You have been asked to analyze the possible reasons the Specialty Products Division manager rejected the new product line. 1. Determine the return on investment for the Specialty Products Division for the past year. 2. Determine the Specialty Products Division managers bonus for the past year. 3. Determine the estimated return on investment for the new product line. Round whole percents to one decimal place and investment turnover to two decimal places. 4. Why might the manager of the Specialty Products Division decide to reject the new product line? Support your answer by determining the projected return on investment for 20Y6, assuming that the new product line was launched in the Specialty Products Division, and 20Y6 actual operating results were similar to those of 20Y5. 5. Suggest an alternative performance measure for motivating division managers to accept new investment opportunities that would increase the overall company income and return on investment.Effect of proposals on divisional performance A condensed income statement for the Electronics Division of Gihbli Industries Inc. for live year ended December 31 is as follows: Sales 1.575,000 Cost of goods sold 891,000 Gross profit 684,000 Operating expenses 558,000 Income from operations 126,000 Invested assets 1,050,000 Assume that the Electronics Division received no charges from service departments. The president of Gihbli Industries Inc. has indicated that the divisions return on a 1,050,000 investment must be increased to at least 20% by the end of tin- next year if operations are to continue. The division manager is considering the following three proposals: Proposal 1: Transfer equipment with a book value of 300,000 to other divisions at no gain or loss and lease similar equipment. The annual lease payments would be less than the amount of depreciation expense on the old equipment by 31,400. This decrease in expense would be included as part of the cost of goods sold. Sales would remain unchanged. Proposal 2: Reduce invested assets by discontinuing a product line. This action would eliminate sales of 180,000, reduce cost of goods sold by 119,550, and reduce operating expenses by 60,000. Assets of 112,500 would be transferred to other divisions at no gain or loss. Proposal 3: Purchase new and more efficient machinery and thereby reduce the cost of goods sold by 189,000 after considering the effects of depreciation expense on the new equipment. Sales would remain unchanged, and the old machinery, which has no remaining book value, would be scrapped at no gain or loss. The new machinery would increase invested assets by 918,750 for the year. Instructions 1. Using the DuPont formula for return on investment, determine the profit margin, investment turnover, and return on investment for the Electronics Division for the past year. Round percentages and the investment turnover to one decimal place. 2. Prepare condensed estimated income statements and compute the invested assets for each proposal. 3. Using the DuPont formula for return on investment, determine the profit margin, investment turnover, and return on investment for each proposal. Round percentages and the investment turnover to one decimal place. 4. Which of the three proposals would meet the required 20% return on investment? 5. If the Electronics Division were in an industry where the profit margin could not be increased, how much would the investment turnover have to increase to meet the president's required 20% return on investment? Round to one decimal place.Effect of proposals on divisional performance A condensed income statement for the Electronics Division of Gihbli Industries Inc. for live year ended December 31 is as follows: Sales 1.575,000 Cost of goods sold 891,000 Gross profit 684,000 Operating expenses 558,000 Income from operations 126,000 Invested assets 1,050,000 Assume that the Electronics Division received no charges from service departments. The president of Gihbli Industries Inc. has indicated that the divisions return on a 1,050,000 investment must be increased to at least 20% by the end of tin- next year if operations are to continue. The division manager is considering the following three proposals: Proposal 1: Transfer equipment with a book value of 300,000 to other divisions at no gain or loss and lease similar equipment. The annual lease payments would be less than the amount of depreciation expense on the old equipment by 31,400. This decrease in expense would be included as part of the cost of goods sold. Sales would remain unchanged. Proposal 2: Reduce invested assets by discontinuing a product line. This action would eliminate sales of 180,000, reduce cost of goods sold by 119,550, and reduce operating expenses by 60,000. Assets of 112,500 would be transferred to other divisions at no gain or loss. Proposal 3: Purchase new and more efficient machinery and thereby reduce the cost of goods sold by 189,000 after considering the effects of depreciation expense on the new equipment. Sales would remain unchanged, and the old machinery, which has no remaining book value, would be scrapped at no gain or loss. The new machinery would increase invested assets by 918,750 for the year. Instructions 1. Using the DuPont formula for return on investment, determine the profit margin, investment turnover, and return on investment for the Electronics Division for the past year. Round percentages and the investment turnover to one decimal place. 2. Prepare condensed estimated income statements and compute the invested assets for each proposal. 3. Using the DuPont formula for return on investment, determine the profit margin, investment turnover, and return on investment for each proposal. Round percentages and the investment turnover to one decimal place. 4. Which of the three proposals would meet the required 20% return on investment? 5. If the Electronics Division were in an industry where the profit margin could not be increased, how much would the investment turnover have to increase to meet the president's required 20% return on investment? Round to one decimal place.
- Profit center responsibility reporting Glades Sporting Goods Co. operates two divisionsthe Winter Sports Division and the Summer Sports Division. The following income and expense accounts were provided from the trial balance as of December 31, 20Y8, the end of the fiscal year, after all adjustments, including those for inventories, were recorded and posted: SalesWinter Sports Division 12,600,000 SalesSummer Sports Division 16,300,000 Cost of Goods SoldWinter Sports Division 7,560,000 Cost of Goods SoldSummer Sports Division 9,454,000 Sales ExpenseWinter Sports Division 2,016,000 Sales ExpenseSummer Sports Division 2,282,000 Administrative ExpenseWinter Sports Division 1,260,000 Administrative ExpenseSummer Sports Division 1.450,700 Advertising Expense 578,000 Transportation Expense 265,660 Accounts Receivable Collection Expense 174,000 Warehouse Expense 1,540,000 The bases to be used in allocating expenses, together with other essential information, are as follows: a.Advertising expenseincurred at headquarters, charged back to divisions on the basis of usage: Winter Sports Division, 252,000; Summer Sports Division, 326,000. b.Transportation expensecharged back to divisions at a charge rate of 7.40 per bill of lading: Winter Sports Division, 17,200 bills of lading; Summer Sports Division, 18,700 bills of lading. c.Accounts receivable collection expenseincurred at headquarters, charged back to divisions at a charge rate of 6.00 per invoice: Winter Sports Division, 11,500 sales invoices; Summer Sports Division, 17,500 sales invoices. d.Warehouse expensecharged back to divisions on the basis of floor space used in storing division products: Winter Sports Division, 102,000 square feet; Summer Sports Division, 118,000 square feet. Prepare a divisional income statement with two column headings: Winter Sports Division and Summer Sports Division. Provide supporting calculations for service department charges.Effect of proposals on divisional performance A condensed income statement for the Commercial Division of Maxell Manufacturing Inc. for the year ended December 31 is as follows: Sales 3,500,000 Cost of goods sold 2,480,000 Gross profit 1,020,000 Operating expenses 600,000 Income from operations 420,000 Invested assets 2,500,000 Assume that the Commercial Division received no charges from service departments. The president of Maxell Manufacturing has indicated that the divisions return on a 2,500,000 investment must be increased to at least 21% by the end of the next year if operations are to continue. The division manager is considering tin- following three proposals: Proposal 1: Transfer equipment with a hook value of 312,500 to other divisions at no gain or loss and lease similar equipment. The annual lease payments would exceed the amount of depreciation expense on the old equipment by 105,000. This increase in expense would be- included as part of the cost of goods sold. Sales would remain unchanged. Proposal 2: Purchase new and more efficient machining equipment and thereby reduce the cost of goods sold by 560,000 after considering the effects of depreciation expense on the new equipment. Sales would remain unchanged, and the old equipment, which has no remaining book value, would be scrapped at no gain or loss. The new equipment would increase invested assets by an additional 1,875,000 for the year. Proposal 3: Reduce invested assets by discontinuing a product line. This action would eliminate sales of 595,000, reduce cost of goods sold by 406,700, and reduce operating expenses by 175,000. Assets of 1,338,000 would the transferred to other divisions at no gain or loss. Instructions 1. Using the DuPont formula for return on investment, determine the profit margin, investment turnover, and return on investment for the Commercial Division for the past year. 2. Prepare condensed estimated income statements and compute the invested assets for each proposal. 3. Using the DuPont formula for return on investment, determine the profit margin, investment turnover, and return on investment for each proposal. Round percentages and the investment turnover to one decimal place. 4. Which of the three proposals would meet the required 21% return on investment? 5. If the Commercial Division were in an industry where the profit margin could not be increases, how much would the investment turnover have to increase to meet the president's required 21% return on investment? Round to one decimal place.Effect of proposals on divisional performance A condensed income Statement for the Commercial Division of Maxell Manufacturing Inc. for the year ended December 31, 2016, is as follows: Sales 3,500,000 Cost of goods sold 2,480,000 Gross profit 1,020,000 Operating expenses 600,000 Income from operations 420,000 Invested assets 2,500,000 Assume that the Commercial Division received no charges from Service departments. The president of Maxell Manufacturing has indicated that the divisions rate of return on a 2,500,000 investment must be increased to at least 21% by the end of the next year if operations are to continue. The division manager is considering the following three proposals: Proposal 1: Transfer equipment with a book value of 312,500 to other divisions at no gain or loss and lease similar equipment. The annual lease payments would exceed the amount of depredation expense on the old equipment by 105,000. This increase in expense would be included as pan of the cost of goods sold. Sales would remain unchanged. Proposal 2: Purchase new and more efficient machining equipment and thereby reduce the cost of goods sold by 560,000 after considering the effects of depredation expense on the new equipment Sales would remain unchanged, and the old equipment, which has no remaining book value, would be scrapped at no gain or loss. The new equipment would increase invested assets by an additional 1,875,000 for the year. Proposal .3: Reduce invested assets by discontinuing a product line. This action would eliminate sales of 595,000, reduce cost of goods sold by 406,700, and reduce operating expenses by 175,000. Assets of 1,338,000 would be transferred to other divisions at no gain or loss. Instructions 1. Using the DuPont formula for rate of return on investment, determine the profit margin, investment turnover, and rate of return on investment for the Commercial Division for the past year 2. Prepare condensed estimated income statements and compute the invested assets for each proposal. 3. Using the DuPont formula for rate of return on investment, determine the profit margin, investment turnover, and rate of return on investment for each proposal. 4. Which of the three proposals would meet the required 21% rate of return on investment? 5. If the Commercial Division were in an industry where the profit margin could not be increased, how much would the investment turnover have to increase to meet the presidents required 21% rate of return on investment? Round to one decimal place.