(1)
Income statement: The financial statement which reports revenues and expenses from business operations and the result of those operations as net income or net loss for a particular time period is referred to as income statement.
To prepare: The income statements for MF, EB, and IB Divisions of Company L for the year ended June 30, 2016
(2)
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:
Profit margin, investment turnover, and return on investment of MF, EB, and IB Divisions
(3)
To recommend: The expansion of the profitable division, based on income from operations and ROI, computed in parts (1) and (2)
Want to see the full answer?
Check out a sample textbook solutionChapter 24 Solutions
Working Papers, Chapters 1-17 for Warren/Reeve/Duchac's Accounting, 26th and Financial Accounting, 14th
- Divisional performance analysis and evaluation The vice president of operations of Free Ride Bike Company is evaluating the performance of two divisions organized as investment centers. Invested assets and condensed income statement data for the past year for each division are as follows: Instructions 1. Prepare condensed divisional income statements for the year ended December 31, 20Y7, assuming that there were no support department allocations. 2. Using the DuPont formula for return on investment, determine the profit margin, investment turnover, and return on investment for each division. Round percentages and the investment turnover to one decimal place. 3. If managements minimum acceptable return on investment is 10%, determine the residual income for each division. 4. Discuss the evaluation of the two divisions, using the performance measures determined in parts (1), (2), and (3).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_forwardDivisional Income Statements and Return on Investment Analysis E.F. Lynch Company is a diversified investment company with three operating divisions organized as investment centers. Condensed data taken from the records of the three divisions for the year ended June 30, 20Y8, are as follows: Mutual FundDivision ElectronicBrokerageDivision InvestmentBankingDivision Fee revenue $1,090,000 $1,160,000 $1,080,000 Operating expenses 530,000 486,800 763,200 Invested assets 4,000,000 3,400,000 2,200,000 The management of E.F. Lynch Company is evaluating each division as a basis for planning a future expansion of operations. Required: 1. Prepare condensed divisional income statements for the three divisions, assuming that there were no support department allocations. E.F. Lynch Company Divisional Income Statements For the Year Ended June 30, 20Y8 MutualFundDivision ElectronicBrokerageDivision InvestmentBankingDivision Fee revenue $ $ $…arrow_forward
- Divisional Income Statements and Return on Investment Analysis E.F. Lynch Company is a diversified investment company with three operating divisions organized as investment centers. Condensed data taken from the records of the three divisions for the year ended June 30, 20Y8, are as follows: Mutual FundDivision ElectronicBrokerageDivision InvestmentBankingDivision Fee revenue $1,010,000 $1,060,000 $1,030,000 Operating expenses 492,000 390,400 727,600 Invested assets 3,700,000 3,100,000 2,100,000 The management of E.F. Lynch Company is evaluating each division as a basis for planning a future expansion of operations. Required: Question Content Area 1. Prepare condensed divisional income statements for the three divisions, assuming that there were no service department cost allocations. E.F. Lynch CompanyDivisional Income StatementsFor the Year Ended June 30, 20Y8 MutualFundDivision ElectronicBrokerageDivision InvestmentBankingDivision Fee…arrow_forwardDivisional Income Statements and Return on Investment Analysis E.F. Lynch Company is a diversified investment company with three operating divisions organized as investment centers. Condensed data taken from the records of the three divisions for the year ended June 30, 20Y8, are as follows: Mutual Fund Division Electronic Brokerage Division Investment Banking Division Fee revenue $630,000 $650,000 $640,000 Operating expenses 340,200 308,000 484,000 Invested assets 2,300,000 1,900,000 1,300,000 The management of E.F. Lynch Company is evaluating each division as a basis for planning a future expansion of operations. Required: 1. Prepare condensed divisional income statements for the three divisions, assuming that there were no service department charges. E.F. Lynch Company Divisional Income Statements For the Year Ended June 30, 20Y8 Mutual Fund Division Electronic Brokerage Division Investment Banking Division Fee revenue $fill in…arrow_forwardDivisional income statements with support department allocations Horton Technology has two divisions, Consumer and Commercial, and two corporate support departments, Tech Services and Purchasing. The corporate expenses for the year ended December 31, 2017, are as follows: Tech Services Department Purchasing Department Other corporate administrative expenses Total expense The other corporate administrative expenses include officers' salaries and other expenses required by the corporation. The Tech Services Department allocates costs to the divisions based on the number of computers in the department, and the Purchasing Department allocates costs to the divisions based on the number of purchase orders for each department. The services used by the two divisions are as follows: Consumer Division Commercial Division Total Revenues Cost of goods sold Operating expenses Tech Services $1,170.000 450,000 800,000 $2,420,000 1,100 computers 700 1,800 computers The support department allocations…arrow_forward
- Divisional income statements for the year 2020 for the two divisions of a company appear below. Eastern Division Western Division Sales $5,000,000 $4,500,000 Operating Expenses 3,800,000 3,000,000 Operating Profit $1,200,000 $1,500,000 Invested Assets $6,000,000 $8,000,000 a. Based on the data above, compute the ROI for the Eastern Division and the Western Division. Please use the Du Pont Model. b. The company is planning to invest an additional $600,000 in assets in one or the other of the divisions. Which division should the company expand? Why? c. What is the advantage of using ROI rather than the dollar amount…arrow_forward1)PLEASE ANSWERED WITH IN THE FORMAT BY PROVIDING FORMULA IN DETAILS2)PLEASE PROVIDE ANSWER IN TEXT Divisional income statement with support department allocations Horton Technology has two divisions, Consumer and Commercial, and two corporate support departments, tech services and purchasing.The corporate expenses for the year ended December 21, 20Y7, are as follows:arrow_forwardDivisional income statements with support department allocations Horton Technology has two divisions, Consumer and Commercial, and two corporate support departments, Tech Services and Purchasing. The corporate expenses for the year ended December 31, 20Y7, are as follows: Tech Services Department Purchasing Department Other corporate administrative expenses $2,132,400 The other corporate administrative expenses include officers' salaries and other expenses required by the corporation. The Tech Services Department allocates costs to the divisions based on the number of computers in the department, and the Purchasing Department allocates costs to the divisions based on the number of purchase orders for each department. The services used by the two divisions are as follows: Tech Services Purchasing Consumer Division 480 computers 5,800 purchase orders Commercial Division 300 10,800 4 780 computers 16,600 purchase orders The support department allocations of the Tech Services Department…arrow_forward
- Divisional income statements with support department allocations Horton Technology has two divisions, Consumer and Commercial, and two corporate support departments, Tech Services and Purchasing. The corporate expenses for the year ended December 31, 20Y7, are as follows: Line Item Description Amount Tech Services Department $988,200 Purchasing Department 298,000 Other corporate administrative expenses 553,000 Total expense $1,839,200 The other corporate administrative expenses include officers’ salaries and other expenses required by the corporation. The Tech Services Department allocates costs to the divisions based on the number of computers in the department, and the Purchasing Department allocates costs to the divisions based on the number of purchase orders for each department. The services used by the two divisions are as follows: Line Item Description Tech Services Purchasing Consumer Division 500 computers 5,200 purchase orders Commercial Division 310…arrow_forwardDivisional income statements for the year 2020 for the two divisions of a company appear below. Eastern Division Western Division Sales $5,000,000 $4,500,000 Operating Expenses 3,800,000 3,000,000 Operating Profit $1,200,000 $1,500,000 Invested Assets $6,000,000 $8,000,000 1. Based on the data above, compute the ROI for the Eastern Division and the Western Division. Please use the Du Pont Model. Show all work and round to second decimal places. 2. The company is planning to invest an additional $600,000 in assets in one or the other of the divisions. Which division should the company expand? Why? 3. What is the…arrow_forwardDivisional Income Statements with Support Department Allocations Horton Technology has two divisions, Consumer and Commercial, and two corporate support departments, Tech Services and Purchasing. The corporate expenses for the year ended December 31, 20Y7, are as follows: Tech Services Department $1,170,000 Purchasing Department 450,000 Other corporate administrative expenses 800,000 Total expense $2,420,000 The other corporate administrative expenses include officers’ salaries and other expenses required by the corporation. The Tech Services Department allocates costs to the divisions based on the number of computers in the department, and the Purchasing Department allocates costs to the divisions based on the number of purchase orders for each department. The services used by the two divisions are as follows: Tech Services Purchasing Consumer Division 1,100 computers 4,000 purchase orders Commercial Division 700 8,000 Total 1,800 computers 12,000…arrow_forward
- Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubSurvey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning