Spreadsheet Exercise
The income statement and
The income statements for the years ending December 31, 2019 and 2018, respectively, are presented in the following table.
Annual Income Statements (Values in Millions)
For the year ended | ||
December 31, 2019 | December 31, 2018 | |
Sales | $178,909 | $187,510 |
Cost of goods sold | 109,701 | 11 1,631 |
Selling, general, and administrative expenses | 12,356 | 12,900 |
Other tax expense | 33,572 | 33,377 |
12,103 | 7,944 | |
Other income (add to EBIT to arrive at EBT) | 3,147 | 3,323 |
Interest expense | 398 | 293 |
Income tax rate (average) | 35.324% | 37.945% |
Dividends paid per share | $1.13 | $0.91 |
Basic EPS from total operations | $1.34 | $2.25 |
You also have the following balance sheet information as of December 31, 2019 and 2018, respectively.
Annual Balance Sheets (Values in Millions)
December 31, 2019 | December 31, 2018 | |
Cash | $ 7.229 | $ 6.547 |
Receivables | 21,163 | 19,549 |
Inventories | 8,068 | 7,904 |
Other current assets | 1,831 | 1,681 |
Property, plant, and equipment, gross | 204,960 | 187,519 |
Accumulated depreciation and depletion | 110,020 | 97,917 |
Other noncurrent assets | 19,413 | 17,891 |
Accounts payable | 13,792 | 22,862 |
Short-term debt payable | 4,093 | 3,703 |
Other current liabilities | 15,290 | 3,549 |
Long-term debt payable | 6,655 | 7,099 |
16,484 | 16,359 | |
Other noncurrent liabilities | 21,733 | 16,441 |
74,597 | 73,161 | |
Total common shares outstanding | 6.7 billion | 6.8 billion |
To Do
- a. Create a spreadsheet similar to Table 3.1 to model the following:
- 1. A multiple-step comparative income statement for Dayton Inc. for the periods ending December 31, 2019 and 2018. You must calculate the cost of goods sold for the year 2019.
- 2. A common-size income statement for Dayton Inc. covering the years 2019 and 2018.
- b. Create a spreadsheet similar to Table 3.2 to model the following:
- 1. A detailed, comparative balance sheet for Dayton Inc. for the years ended December 31, 2019 and 2018.
- 2. A common-size balance sheet for Dayton Inc. covering the years 2019 and 2018.
- c. Create a spreadsheet similar to Table 3.10 to perform the following analysis:
- 1. Create a table that reflects both 2019 and 2018 operating ratios for Dayton Inc., segmented into (a) liquidity, (b) activity, (c) debt, (d) profitability, and (e) market. Assume that the current market price for the stock is $90.
- 2. Compare the 2019 ratios to the 2018 ratios. Indicate whether the results “outperformed the prior year” or “underperformed relative to the prior year.”
Want to see the full answer?
Check out a sample textbook solutionChapter 3 Solutions
Gitman: Principl Manageri Finance_15 (15th Edition) (What's New in Finance)
- Profitability Ratios Tinker Corporation operates in the highly competitive consulting industry. Tinkers balance sheet indicates the following balances as of December 31, 2019. Required: Calculate Tinkers return on equity if Tinkers 2019 net income is $90,000.arrow_forwardFinancial information for Lighthizer Trading Company for the fiscal year-ended September 30, 20xx, was collected. As part of a management training session, you have been asked to prepare an income statement format that will be used to distribute to management. Subtotals and totals are included in the information, but you will need to calculate the values. A. In the correct format, prepare the income statement using this information: B. Calculate the profit margin, return on investment, and residual income. Assume an investment base of $42,000 and 8% cost of capital. C. Prepare a short response to accompany the income statement that explains why uncontrollable costs are included in the income statement.arrow_forwardPURPOSE OF ACCOUNTING Match the following users with the information needed. 1. Ownersa. Whether the firm can pay its bills on time 2. Managersb. Detailed, up-to-date information to measure business performance (and plan for future operations) 3. Creditorsc. To determine taxes to be paid and whether other regulations are met 4. Government agenciesd. The firms current financial conditionarrow_forward
- Effect of Industry Economics on Balance Sheets. Access the investor relations or corporate information section of the websites of American Airlines (www.aa.com), Intel (www.intel.com), and Disney (http://disney.com). Study the business strategies of each firm. Examine the financial ratios below and indicate which firm is likely to be American Airlines, Intel, and Disney. Explain your reasoning.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.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_forward
- The following information is taken from the records of Baklava Bakery for the year 2019. A. Calculate net income or net loss for January. B. Calculate net income or net loss for February. C. Calculate net income or net loss for March. D. For each situation, comment on how a stakeholder might view the firms performance. (Hint: Think about the source of the income or loss.)arrow_forwardReturn on assets The financial statements of The Hershey Company (HSY) are shown in Exhibits 6 through 9 of this chapter. Based upon these statements, answer the following questions. What is the percentage of net income to sales for Hershey? Round to one decimal place.arrow_forwardComparing Two Companies in the Same Industry: Chipotle and Panera Bread Refer to the financial information for Chipotle and Panera Bread reproduced at the end of this book and answer the following questions: Required What is the dollar amount of inventories that each company reports on its balance sheet at the end of the most recent year? What percentage of total assets do inventories represent for each company? What does this tell you about the nature of their business? Refer to Note 1 in Chipotles annual report. What inventory valuation method does the company use? Refer to Note 2 in Panera Breads annual report. What inventory valuation method does the company use? How do both companies deal with situations in which the market value of inventory is less than its cost? Given the nature of their businesses, which inventory system, periodic or perpetual, would you expect both Chipotle and Panera Bread to use? Explain your answer.arrow_forward
- Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:CengagePrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningFinancial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning