EXHIBIT 7.28 Data for Ratio Detective Exercise (Problem 30) 1 2 3 5 6 7 8 9 10 11 12 BALANCE SHEET AT END OF YEAR Cash and Marketable Securities . . . . . . . . . . 4.7% 16.4% 8.9% 8.4% 16.7% 7.4% 16.1% 21.3% 72.0% 8.3% 1.4% 338.8% Receivables .. . 8.5 15.9 16.5 27.6 35.9 17.7 81.1 29.6 24.0 10.5 5.9 533.4 9.9 5.8 25.7 20.0 2.9 Inventories . . . . 2.8 9.9 6.4 1.3 Property, Plant, and Equipment Cost. . . . . . . 8 0+ 20.9 59.0 69.6 88.3 130.9 3.0 110.3 83.3 278.9 535.4 15.3 (15.0) (9.1) (33.2) (17.8) (50.5) (67.7) (11.8) (35.5) (35.2) (112.5) (284.9) (12.9) Accumulated Depreciation Property, Plant, and Equipment, Net . . . . .. . 5.8 11.8 25.8 51.8 37.8 63.2 11.2 74.8 48.1 166.4 250.5 2.4 Intercorporate Investments 4.0 14.3 3.0 0.6 18.8 10.3 1.3 10.7 7.7 22.4 16.9 $1.9 7.1 1.9 63.5 $2.1 69.1 56.3 5.4 61.9 Other Assets. . . . 15.0 0.9 11.7 3.6 173.2% 179.8% 240.9% 266.8% 280.1% 978.4% Total Assets . 67.9% 72. 1% 75.8% 97.8% 122.7% 126.2% 51.3% 820.8% Current Liabilities .. 37.3% 25.5% 29.7% 26.4% 42.7% 34.5% 106.0% 65.1% 48.3% 42.6% 56.4 95.8 167.7 76.9 Long-Term Debt 12.0 6.1 6.6 9.1 2.2 23.3 22.7 49.6 17.2 10.6 10.9 24.5 27.8 24.7 42.2 Other Noncurrent Liabilities 2.1 1.8 5.9 2.3 4.2 16.5 38.7 33.6 60.0 53.6 51.2 33.9 54.2 111.7 100.6 36.4 38.5 Shareholders' Equity . ... 266.8% 280.1% 978.4% Total Liabilities and Shareholders' Equity .. 67.9%1 72. 1% 75.8% 97.8% 122.7% 126.2% 173.2% 179.8% 240.9% INCOME STATEMENT FOR YEAR 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% Operating Revenues. . . 100.0% 100.0% 100.0% 100.0% 100.0% 0.7% 2.3% 1.9% 0.3% 13.8% . 7% Other Revenues. . .. 1.1% 2.7% 1.0% 0.2% 32.6 68.0 81.0 55.3 75.5 27.2 45.0 57.3 Cost of Goods Sold . .. . . . . . . 7.8 45.2 44.5 64.6 5.9 5.3 2.0 7.1 9.9 23.9 19.9 3.0 4.9 4.1 3.2 Depreciation and Amortization Expense . . .. . 40.0 15.2 7.3 22.5 24.3 16.4 13.6 27.8 8.1 38.9 Selling and Administrative Expense . . . . . ... 6.3 24.8 35.4 0.4 3.5 1.9 3.0 5.2 8.6 8.6 Interest Expense. . .. . . . ..... 1.4 0.4 2.0 1.3 1.3 3.7 13.8 Research and Development Expense . . . . . . . . 9.8 2.8 2.2 3.1 2.4 2.5 0.3 5.9 3.7 4.4 3.9 Income Tax Expense 1.3 5.8 0.3 0.6 (2.1 ) 0.7 (1.1) 0.6 1.7 (0.8) 0.8 All Other Items (net) . . . 97.5% 101.6% 93.7% 95.8% 100.5% 97.2% 95.9% 94.4% . . . 99.0% 90.9% 94.7% 96.1% Total Expenses . 8.2% 1.5% 13.3% 3.5% 4.1% 5.6% Cengage Learning 2014 0.7% Net Income .. . .. 2.1% 11.8% 6.3% 4.1% 3.2%% Focus to APR "tv 4 O zoon w 6Qu Sear Detective_12_Excercise_Mar2023.pdf Detective Exercise - Industry Economics and Company Analysis Effective financial statement analysis requires an understanding of a firm's economic characteristics. The relations among various financial statement items provide evidence of many of these economic characteristics. The following table 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 indicates that the amount is not sufficiently large for the firm to disclose it. The 12 companies, the country of their headquarters, and a brief description of their activities are as follows. (1) Accor (France): World's 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. (2) Arbed-Acier (Luxembourg): Offers flat-rolled steel products, primarily to the European automobile industry. (3) Carrefour (France): Operates grocery supermarkets and hypermarkets in Europe, Latin America, and Asia. (4) Deutsche Telekom (Germany): Europe's largest provider of wired and wireless telecommunication services. The telecommunications industry has experienced increased deregulation in recent years. (5) Fortis (Netherlands): Offers both 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. (6) Interpublic Group (United States): Creates advertising copy for clients. Purchases advertising time and space from various media and sells it to clients. Operating revenues represent the commission or fee earned by Interpublic for advertising copy created and media time and space sold. Operating expenses include compensation paid to employees. Interpublic acquired other marketing services firms in recent years. (7) Marks & Spencer (United Kingdom): Operates department stores in England and other retail stores In Europe and the United States. It offers its own credit card for customers' purchases. (8) Nestle (Switzerland): World's largest food processor, offering prepared foods, coffees, milk-based products, and mineral waters. (9) Roche Holding (Switzerland): Creates, manufactures, and distributes a wide variety of prescription drugs. (10) Sun Microsystems (United States): Designs, manufactures, and sells engineering workstations and servers used to maintain integrated computer networks. Sun outsources the manufacture of many of its computer components. (11) Tokyo Electric Power (Japan): Provides electric power services, primarily to the Tokyo community. It maintains almost a monopoly position in its service area. (12) Toyota Motor (Japan): Manufactures automobiles and offers financing services to its customers. Use whatever clues you can to match the companies in the following table with the companies and industries listed above. Adapted from Stickney, 14th edition