You also have the following balance sheet information as of December 31, 2019 and 2018, respectively....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 $ 6,547 19,549 Cash $9,090 21,163 8,068 Receivables Inventories Other current assets 7,904 1,831 Property, plant, and equipment, gross Accumulated depreciation and depletion Other noncurrent assets 1,681 187,519 97,917 204,960 110,020 19,413 13,792 17,891 Accounts payable Short-term debt payable 22,862 4,093 3,703 Other current liabilities 3,549 7,099 16,359 16,441 15,290 Long-term debt payable Deferred income taxes 6,655 16,484 Other noncurrent liabilities 21,733 Retained earnings 76,458 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 peri- ods 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." The income statement and balance sheet are the primary reports that a firm constr a for use by management and for distribution to stockholders, regulatory bodies, a agement has asked you to perform a detailed financial statement analysis of theb the firm. Dayton Products Inc. is a moderate-sized manufacturer. The company's general public. They are the primary sources of historical financial information a and firm and 201 respectively, are presented in the following table. Annual Income Statements (Values in Millions) For the year ended December 31, 2018 December 31, 2019 $187,510 $178,909 109,701 111,631 Sales 12,900 12,356 Cost of goods sold Selling, general, and administrative expenses Other tax expense Depreciation and amortization Other income (add to EBIT to arrive at EBT) Interest expense 33,377 33,572 7,944 12,103 3,147 3,323 398 293 21% 21% Income tax rate $1.15 $0.91 Dividends paid per share Basic EPS from total operations $1.64 $2.87 ma 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 $ 6,547 19,549 Cash $9,090 21,163 8,068 Receivables Inventories Other current assets 7,904 1,831 Property, plant, and equipment, gross Accumulated depreciation and depletion Other noncurrent assets 1,681 187,519 97,917 204,960 110,020 19,413 13,792 17,891 Accounts payable Short-term debt payable 22,862 4,093 3,703 Other current liabilities 3,549 7,099 16,359 16,441 15,290 Long-term debt payable Deferred income taxes 6,655 16,484 Other noncurrent liabilities 21,733 Retained earnings 76,458 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 peri- ods 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." The income statement and balance sheet are the primary reports that a firm constr a for use by management and for distribution to stockholders, regulatory bodies, a agement has asked you to perform a detailed financial statement analysis of theb the firm. Dayton Products Inc. is a moderate-sized manufacturer. The company's general public. They are the primary sources of historical financial information a and firm and 201 respectively, are presented in the following table. Annual Income Statements (Values in Millions) For the year ended December 31, 2018 December 31, 2019 $187,510 $178,909 109,701 111,631 Sales 12,900 12,356 Cost of goods sold Selling, general, and administrative expenses Other tax expense Depreciation and amortization Other income (add to EBIT to arrive at EBT) Interest expense 33,377 33,572 7,944 12,103 3,147 3,323 398 293 21% 21% Income tax rate $1.15 $0.91 Dividends paid per share Basic EPS from total operations $1.64 $2.87 ma
Expert Answer:
Answer rating: 100% (QA)
1 MultiStep Income Statement MultiStep Income Statement Dec 31 2019 De... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
The following balance sheet information represents actual data for 2011 and forecasted data for 2012: The actual income statement for 2011 is as follows: Sales . . . . . . . . . . . . . . . . . . . ....
-
You are provided with the following balance sheet information and summarized income statement for Rivulet Inc.: All sales are credit sales. Accounts payable pertains exclusively to the purchase of...
-
The Marino Company had the following balance sheet on January 1, 2007: On January 2, 2007 the Paul Company purchased the Marino Company by acquiring all its outstanding shares for $300,000 cash. On...
-
Three components can be used to build an Oracle statement: Statement, Prepared-Statement and CallableStatement.(True/False)
-
The 2012 General Social Survey (GSS) asked its respondents to report their political party affiliation. The graphs show the results for 1081 women. a. Which political affiliation has the most women?...
-
Kittlitz (1999) presents data on homicides in Waco, Texas, for the years 1980-1989 (data taken from the Waco Tribune-Herald, December 29, 1989). There were 29 homicides in 1989. Table 7E.20 gives the...
-
Exercise 3.58 describes a study in which college students found it unpleasant to sit alone and think. The same article describes a second study in which college students appear to prefer receiving an...
-
Below are the account balances of Bruins Company at the end of November. Required: Prepare a trial balance by placing amounts in the appropriate debit or credit column and determining the balance of...
-
25 1 QS 2-7 (Algo) Computing 1-account balance LO CZ Determine the ending balance of each of the following T-accounts. Cash Accounts Payable oints 300 250 4,000 14,000 500 260 6,500 eBook 220 Hint...
-
Selected transactions for M. Acosta, an interior decorator, in her first month of business, are as follows. Jan. 2 Invested $10,000 cash in business. 3 Purchased used car for $3,000 cash for use in...
-
Suppose H(z) is a type 4 linear-phase FIR filter. -1 H(2) co + c1z - C1z2 -3 Coz (a) Find the amplitude response of this filter. (b) Find the phase offset, a, and group delay, D(f), of this filter....
-
A table outfitted with springs on its feet bounces vertically in simple harmonic motion. A cup of coffee is sitting on the table. Discuss whether any of the following changes to this system could...
-
A \(5.0-\mathrm{kg}\) object is suspended from the ceiling by a strong spring, which stretches \(0.10 \mathrm{~m}\) when the object is attached. The object is lifted \(0.050 \mathrm{~m}\) from this...
-
Two balls of unequal mass are hung from two springs that are not identical. The springs stretch the same distance as the two systems reach equilibrium. Then both springs are compressed and released....
-
Verify that the time constant \(\tau=m / b\) has units of time for damped oscillations.
-
You want to build a pendulum clock in which the time interval between the "tick" sound (when the pendulum is swinging one way) and the "tock" sound (when the pendulum is swinging the other way) is...
-
An interior room is maintained at an air temperature of 210C by a radiant panel covering one of the room walls, calculate the temperature of the radiant panel necessary to achieve the thermal comfort...
-
Let X be a random variable taking on values a1, a2, . . . , pr with probabilities p1, p2, . . . , pr and with E(X) = μ. Define the spread of X as follows: This, like the standard deviation, is a...
-
The second paragraph under accounts receivable in Note 1 explain that CAE is involved in a program in which can sell some of its accounts receivable. What's the maximum amount CAE can receive under...
-
Innerkip Ltd. (Innerkip) uses the percent age-of-credit-sales method of estimating the bad debt expense. Since 2014, Innerkip has used too low a percentage in calculating the bad debt expense each...
-
Early in 2017, Mr. Peribonka purchased a machine for $80,000 to produce a new gadget he designed. Mr. Peribonka invested $50,000 of his own money to buy the machine and borrowed the remainder from...
-
What is the difference between real objects and virtual objects? Give an example for each.
-
How do business classes differ from utility classes? Provide one example for each.
-
Give three specialized subclasses for the Student class.
Study smarter with the SolutionInn App