(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:
To determine: 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 23 Solutions
Financial & Managerial Accounting
- Effect of Industry Characteristics on Financial Statement Relations. Effective financial statement analysis requires an understanding of a firms economic characteristics. The relations between various financial statement items provide evidence of many of these economic characteristics. Exhibit 1.22 (pages 6061) presents common-size condensed balance sheets and income statements for 12 firms in different industries. These common-size balance sheets and income statements express various items as a percentage of operating revenues. (That is, the statement divides all amounts by operating revenues for the year.) Exhibit 1.22 also shows the ratio of cash flow from operations to capital expenditures. A dash for a particular financial statement item does not necessarily mean the amount is zero. It merely indicates that the amount is not sufficiently large enough for the firm to disclose it. Amounts that are not meaningful are shown as n.m. A list of the 12 companies and a brief description of their activities follow. A. Amazon.com: Operates websites to sell a wide variety of products online. The firm operated at a net loss in all years prior to that reported in Exhibit 1.22. B. Carnival Corporation: Owns and operates cruise ships. C. Cisco Systems: Manufactures and sells computer networking and communications products. D. Citigroup: Offers a wide range of financial services in the commercial banking, insurance, and securities business. Operating expenses represent the compensation of employees. E. eBay: Operates an online trading platform for buyers to purchase and sellers to sell a variety of goods. The firm has grown in part by acquiring other companies to enhance or support its online trading platform. F. Goldman Sachs: Offers brokerage and investment banking services. Operating expenses represent the compensation of employees. G. Johnson Johnson: Develops, manufactures, and sells pharmaceutical products, medical equipment, and branded over-the-counter consumer personal care products. H. Kelloggs: Manufactures and distributes cereal and other food products. The firm acquired other branded food companies in recent years. I. MGM Mirage: Owns and operates hotels, casinos, and golf courses. J. Molson Coors: Manufactures and distributes beer. Molson Coors has made minority ownership investments in other beer manufacturers in recent years. K. Verizon: Maintains a telecommunications network and offers telecommunications services. Operating expenses represent the compensation of employees. Verizon has made minority investments in other cellular and wireless providers. L. Yum! Brands: Operates chains of name-brand restaurants, including Taco Bell, KFC, and Pizza Hut. REQUIRED Use the ratios to match the companies in Exhibit 1.22 with the firms listed above.arrow_forwardEffect of Industry Characteristics on Financial Statement Relations. Effective financial statement analysis requires an understanding of a firms economic characteristics. The relations between various financial statement items provide evidence of many of these economic characteristics. Exhibit 1.23 (pages 6263) presents common-size condensed balance sheets and income statements for 12 firms in different industries. These common-size balance sheets and income statements express various items as a percentage of operating revenues. (That is, the statement divides all amounts by operating revenues for the year.) Exhibit 1.23 also shows the ratio of cash flow from operations to capital expenditures. A dash for a particular financial statement item does not necessarily mean the amount is zero. It merely indicates that the amount is not sufficiently large for the firm to disclose it. A list of the 12 companies and a brief description of their activities follow. A. Abercrombie Fitch: Sells retail apparel primarily through stores to the fashionconscious young adult and has established itself as a trendy, popular player in the specialty retailing apparel industry. B. Allstate Insurance: Sells property and casualty insurance, primarily on buildings and automobiles. Operating revenues include insurance premiums from customers and revenues earned from investments made with cash received from customers before Allstate pays customers claims. Operating expenses include amounts actually paid or expected to be paid in the future on insurance coverage outstanding during the year. C. Best Buy: Operates a chain of retail stores selling consumer electronic and entertainment equipment at competitively low prices. D. E. I. du Pont de Nemours: Manufactures chemical and electronics products. E. Hewlett-Packard: Develops, manufactures, and sells computer hardware. The firm outsources manufacturing of many of its computer components. F. HSBC Finance: Lends money to consumers for periods ranging from several months to several years. Operating expenses include provisions for estimated uncollectible loans (bad debts expense). G. Kelly Services: Provides temporary office services to businesses and other firms. Operating revenues represent amounts billed to customers for temporary help services, and operating expenses include amounts paid to the temporary help employees of Kelly. H. McDonalds: Operates fast-food restaurants worldwide. A large percentage of McDonalds restaurants are owned and operated by franchisees. McDonalds frequently owns the restaurant buildings of franchisees and leases them to franchisees under long-term leases. I. Merck: A leading research-driven pharmaceutical products and services company. Merck discovers, develops, manufactures, and markets a broad range of products to improve human and animal health directly and through its joint ventures. J. Omnicom Group: Creates advertising copy for clients and is the largest marketing services firm in the world. Omnicom purchases advertising time and space from various media and sells it to clients. Operating revenues represent commissions and fees earned by creating advertising copy and selling media time and space. Operating expenses includes employee compensation. K. Pacific Gas Electric: Generates and sells power to customers in the western United States. L. Procter Gamble: Manufactures and markets a broad line of branded consumer products. REQUIRED Use the ratios to match the companies in Exhibit 1.23 with the firms listed above.arrow_forwardEffect of Industry Characteristics on Financial Statement Relations: A Global Perspective. Effective financial statement analysis requires an understanding of a firms economic characteristics. The relations between various financial statement items provide evidence of many of these economic characteristics. Exhibit 1.24 (pages 6667) presents common-size condensed balance sheets and income statements for 12 firms in different industries. These common-size balance sheets and income statements express various items as a percentage of operating revenues. (That is, the statement divides all amounts by operating revenues for the year.) A dash for a particular financial statement item does not necessarily mean the amount is zero. It merely indicates that the amount is not sufficiently large for the firm to disclose it. A list of the 12 companies, the country of their headquarters, and a brief description of their activities follow. A. Accor (France): Worlds largest hotel group, operating hotels under the names of Sofitel, Novotel, Motel 6, and others. Accor has grown in recent years by acquiring established hotel chains. B. Carrefour (France): Operates grocery supermarkets and hypermarkets in Europe, Latin America, and Asia. C. Deutsche Telekom (Germany): Europes largest provider of wired and wireless telecommunication services. The telecommunications industry has experienced increased deregulation in recent years. D. E.ON AG (Germany): One of the major public utility companies in Europe and the worlds largest privately owned energy service provider. E. Fortis (Netherlands): Offers insurance and banking services. Operating revenues include insurance premiums received, investment income, and interest revenue on loans. Operating expenses include amounts actually paid or amounts it expects to pay in the future on insurance coverage outstanding during the year. F. Interpublic Group (U.S.): Creates advertising copy for clients. Interpublic purchases advertising time and space from various media and sells it to clients. Operating revenues represent the commissions or fees earned for creating advertising copy and selling media time and space. Operating expenses include employee compensation. G. Marks Spencer (U.K.): Operates department stores in England and other retail stores in Europe and the United States. Offers its own credit card for customers purchases. H. Nestl (Switzerland): Worlds largest food processor, offering prepared foods, coffees, milk-based products, and mineral waters. I. Roche Holding (Switzerland): Creates, manufactures, and distributes a wide variety of prescription drugs. J. Sumitomo Metal (Japan): Manufacturer and seller of steel sheets and plates and other construction materials. K. Sun Microsystems (U.S.): Designs, manufactures, and sells workstations and servers used to maintain integrated computer networks. Sun outsources the manufacture of many of its computer components. L. Toyota Motor (Japan): Manufactures automobiles and offers financing services to its customers. REQUIRED Use the ratios to match the companies in Exhibit 1.24 with the firms listed above.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 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_forwardE.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,360,000 $1,440,000 $1,330,000 Operating expenses 660,000 608,400 941,200 Invested assets 5,000,000 4,200,000 2,700,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 support department allocations. E.F. Lynch CompanyDivisional Income StatementsFor the Year Ended June 30, 20Y8 MutualFundDivision ElectronicBrokerageDivision InvestmentBankingDivision Fee revenue Operating expenses Operating income…arrow_forward
- ) Cecil Inc. operates with three divisions: Naperville, Metropolitan and Urbana. Below areselected results for each division over the last two fiscal years.a. Calculate Return on Assets (ROA) for Cecil Inc. in 2021 and 2020 (report percentages rounded twodecimals).b. Calculate Return on Sales (ROS) for Cecil Inc. in 2021 and 2020 (report percentages rounded twodecimals).c. Industry Averages are 15% for ROA and 10% for ROS in 2021 and 2020. Discuss Cecil Inc.’sperformance trends and results compared to industry averages (discuss performance, do not repeatcalc’s from above).Revenues: 2021 2020 Naperville 22,500,000 19,600,000 Metropolitan 15,300,000 12,500,000 Urbana 9,500,000 8,700,000Operating Income: Naperville 1,900,000 1,800,000 Metropolitan 1,100,000 900,000 Urbana 1,100,000 1,050,000Average Total Assets: Naperville 10,000,000 9,500,000 Metropolitan 8,000,000 6,500,000 Urbana 4,500,000 4,300,000Number of Managers: Naperville 15 5 Metropolitan 9 10 Urbana 12arrow_forwardDivisional Income Statements with Service Department Charges Yozamba Technology has two divisions, Consumer and Commercial, and two corporate service departments, Tech Support and Purchasing. The corporate expenses for the year ended December 31, 20Y7, are as follows: Tech Support Department $516,000 Purchasing Department 89,600 Other corporate administrative expenses 560,000 Total corporate expense $1,165,600 The other corporate administrative expenses include officers' salaries and other expenses required by the corporation. The Tech Support Department charges the divisions for services rendered, based on the number of computers in the department, and the Purchasing Department charges divisions for services, based on the number of purchase orders for each department. The usage of service by the two divisions is as follows: Tech Support Purchasing Consumer Division 375 computers 1,960 purchase orders Commercial Division 225 3,640 Total 600 computers…arrow_forwardDivisional Income Statements with Service Department Charges Yozamba Technology has two divisions, Consumer and Commercial, and two corporate service departments, Tech Support and Purchasing. The corporate expenses for the year ended December 31, 20Y7, are as follows: Tech Support Department $1,072,800 Purchasing Department 244,500 Other corporate administrative expenses 566,000 Total corporate expense $1,883,300 The other corporate administrative expenses include officers’ salaries and other expenses required by the corporation. The Tech Support Department charges the divisions for services rendered, based on the number of computers in the department, and the Purchasing Department charges divisions for services, based on the number of purchase orders for each department. The usage of service by the two divisions is as follows: Tech Support Purchasing Consumer Division 440 computers 5,700 purchase orders Commercial Division 280 10,600 Total 720 computers…arrow_forward
- Divisional Income Statements with Service Department Charges Yozamba Technology has two divisions, Consumer and Commercial, and two corporate service departments, Tech Support and Purchasing. The corporate expenses for the year ended December 31, 20Y7, are as follows: Tech Support Department $1,201,200 Purchasing Department 231,000 Other corporate administrative expenses 616,000 Total corporate expense $2,048,200 The other corporate administrative expenses include officers’ salaries and other expenses required by the corporation. The Tech Support Department charges the divisions for services rendered, based on the number of computers in the department, and the Purchasing Department charges divisions for services, based on the number of purchase orders for each department. The usage of service by the two divisions is as follows: Tech Support Purchasing Consumer Division 480 computers 5,400 purchase orders Commercial Division 300 10,000 Total 780 computers…arrow_forwardDivisional Income Statements with Service Department Charges Yozamba Technology has two divisions, Consumer and Commercial, and two corporate service departments, Tech Support and Purchasing. The corporate expenses for the year ended December 31, 20Y7, are as follows: Tech Support Department $786,600 Purchasing Department 338,000 Other corporate administrative expenses 484,000 Total corporate expense $1,608,600 The other corporate administrative expenses include officers’ salaries and other expenses required by the corporation. The Tech Support Department charges the divisions for services rendered, based on the number of computers in the department, and the Purchasing Department charges divisions for services, based on the number of purchase orders for each department. The usage of service by the two divisions is as follows: Tech Support Purchasing Consumer Division 350 computers 5,900 purchase orders Commercial Division 220 11,000 Total 570 computers…arrow_forwardDivisional Income Statements with Service Department Charges Yozamba Technology has two divisions, Consumer and Commercial, and two corporate service departments, Tech Support and Purchasing. The corporate expenses for the year ended December 31, 20Y7, are as follows: Tech Support Department $786,600 Purchasing Department 338,000 Other corporate administrative expenses 484,000 Total corporate expense $1,608,600 The other corporate administrative expenses include officers’ salaries and other expenses required by the corporation. The Tech Support Department charges the divisions for services rendered, based on the number of computers in the department, and the Purchasing Department charges divisions for services, based on the number of purchase orders for each department. The usage of service by the two divisions is as follows: Tech Support Purchasing Consumer Division 350 computers 5,900 purchase orders Commercial Division 220 11,000 Total 570 computers…arrow_forward
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning