Chapter 8, Problem 9DYS

Computing and Interpreting Financial Statement Ratios Following are selected ratios of Norfolk Southern for 2018 and 2017. Return on Assets (ROA) Component 2018 2017 Profitability (Net income/Sales) 24.3% 52.2% Productivity (Sales/Average assets) 0.328 0.309   a. Was the company profitable in 2018?AnswerYesNo     b. Was the company more profitable in 2018 or 2017?Answer20172018     c. Is the change in productivity a positive or negative development?AnswerPositiveNegative     d. Compute the company’s ROA for 2018 and for 2017.Note: Round answers to one decimal places (example: 10.4%).    ROA 2018 Answer   2017 Answer

Raytheon Company disclosed the following data related to segment sales and operating profits for fis- cal 2018. Total Net Sales Operating Income $ millions 2018 2017 2016 2018 2017 2016 Integrated defense systems.. Intelligence, information and services Missile systems .. Space and airborne systems Forcepoint. $ 6,180 6,722 $ 5,804 6,177 $ 5,529 $1,023 $ 935 $971 538 6,169 7,096 6,182 455 467 8,298 7,787 6,430 973 1,010 921 6,748 884 862 808 634 608 586 33 90 Eliminations (1,514) (1,423) (1,361) Total net sales $27,068 $25,383 $24,201 The company also reported the following on its balance sheet. $ millions 2018 2017 Receivables, net of allowance for doubtful accounts of $12 and $8. . . ....... $1,648 $1,324

In the income statement below, ABC Trade Inc. wants to find the resulting net income for the year 2018 (in million). What is the right amount? Income Statement ($ Million)   Year End   2015 2016 2017 2018 Sales 1,234.90 1,251.70 1,300.40 1,334.40 Cost of Sales (679.10) (659.00) (681.30) (667.00) Gross Operating Income                   Selling & Administration (339.70) (348.60) (351.20) (373.30) Depreciation (47.50) (52.00) (55.90) (75.20) Other Income/Expenses 11.80 7.60 7.00 8.20 Earnings Before Interest and Taxes                   Interest Income 1.30 1.40 1.70 2.00 Interest Expense (16.20) (15.10) (20.50) (23.70) Pre Tax Income                   Income Taxes (56.80) (64.20) (67.50) (72.60) Net Income                   Dividends (38.30) (38.70) (39.80) (40.10) Addition to Retained Earnings           Group of answer choices 121.8 108.7 132.7 132.8 No choice given

Forecast an Income Statement Following is the income statement for Medtronic PLC for the year ended April 29, 2016. Consolidated Statements of Income Apr. 29, 2016 Net sales $29,721 Costs and expenses   Cost of products sold 9,214 Research and development expense 2,224 Selling, general, and administrative expense 9,469 Special charges (gains), net 70 Restructuring charges, net 290 Certain litigation charges, net 26 Acquisition-related items 283 Amortization of intangible assets 1,931 Other expense, net 107 Operating profit 6,107 Interest expense, net 955 Income from operations before income taxes 5,152 Provision for income taxes 979 Net income $4,173   Use the following assumptions to prepare a forecast of the company's income statement for FY2017.   Net sales increase 18% Cost of products sold 31.7% of net sales Research and development expense 7.7% of net sales Selling, general, and administrative expense 32.8% of net sales…

Following are 2017 and 2018 revenue data for Honeywell International's four segments. Use these data to forecast its 2019 revenue. Note: Complete the entire question using the following Excel template: Excel Template. Then enter the answers into the provided spaces below with two decimal places. Honeywell International Segment Sales and Business-Unit Sales by Segment $ millions 2018 2017 Aerospace sales Commercial aviation original equipment Commercial aviation aftermarket Defense and space Transportation systems Total aerospace sales Honeywell building technologies sales Homes Buildings Total Honeywell building technologies sales Performance materials and technologies sales UOP Russell LLP Process solutions Advanced materials Total performance materials and technologies sales $3,591 $2,475 5,373 5,861 5,423 4,053 2,622 3,906 $17,009 $16,295 $4,686 $4,482 5,370 6,053 $10,056 $10,535 $3,603 $2,753 4,981 5,553 3,606 2,791 $12,190 $11,097 Safety and productivity solutions sales Safety…

Financial statement data for years ending December 31 for Latchkey Company follows: a. Determine the ratio of sales to assets for 2016 and 2015. b. Does the change in the ratio of sales to assets from 2015 to 2016 indicate a favorable or an unfavorable trend?

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.

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.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.

Data for Lozano Chip Company and its industry averages follow. Calculate the indicated ratios for Lozano. Construct the extended DuPont equation for both Lozano and the industry. Outline Lozano’s strengths and weaknesses as revealed by your analysis. Lozano Chip Company: Balance Sheet as of December 31, 2019 (Thousands of Dollars) Lozano Chip Company: Income Statement for Year Ended December 31, 2019 (Thousands of Dollars)