Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1) common- size income statement 2019-2018 2) common size balance sheet 2019-2018 please only common size income this is what I have, mosty I have
1) common- size income statement 2019-2018
2) common size balance sheet 2019-2018
please only common size income
this is what I have, mosty I have problems with the percentage change on part the multi step comparative income statement.
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 constructs for use by management and for distribution to stockholders, regulatory bodies, and the general public. They are the primary sources of historical financial information about the firm. Dayton Products Inc. is a moderate-sized manufacturer. The company's man- agement has asked you to perform a detailed financial statement analysis of the firm, 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) Sales Cost of goods sold Selling, general, and administrative expenses Other tax expense Depreciation and amortization Other income (add to EBIT to arrive at EBTI Interest expense Income tax rate Dividends paid per share Basic EPS from total operations For the year ended December 31, 2019 December 31, 2018 $178.909 $187,510 109.701 111.631 12,356 12.900 33,572 33,377 12,103 7,944 3.147 3.323 398 293 21% $1.15 $1.64 21% $0.91 $2.87 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 $ 9,090 $ 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 Deferred income taxes 16,484 16,359 Other noncurrent liabilities 21.733 16,441 Total stockholders' equity 76.458 73,161 Total common shares outstanding 6.7 billion 6.8 billion December 31, 2018 187,510 111,631 75,879 percentage change -4.59 -1.73 Common size Dec 31, Dec 31, 2018 2019 100.00% 100.00% 61.32% 59.53% 8.79 38 68% 40.47% Multi step Comparative income statement December 31 2019 Sales Revenue $178,909 Cost of goods sold 109,701 Gross profit 69,208 Operating expense Selling general, and 12,356 administrative expense Other tax expense 33,572 Depreciation and amortization 12,103 Total operating expense $8.0211 Operating profit (EBIT) 11,177 Non operating Expense Other income (3,143) Interest expense 398 12,900 4.2296 6.91% 6.88% 0.58% 4.24% 33,377 7,944 54,221 21,658 18.76% 6.76% 32.44% 6.25% 17.80% 4.24% 28.92% 11.55% 18 69 (3,323) 293 (1.76%) 0.22% (1.77%) 0.16% 15.30 0.2% - 1.7396 -8.7996 35 84 Net Profit before taxes Income tax expense 13,926 2,924 24,688 5,184 7.78% 1.73% 13.17% 2.76% Net profit after taxes 11,002 $19,504 -17.85 6.15% 10.40% 21% Income tax rate Dividends per share 21% 1.15 1.64 + 0.00 26.37% 42.86% 0.91 2.87 Basiceps 2) Balance sheet Dec 31, 2019 Dec 31, 2018 Dec. 31, 2019 Dec 31, 2018 Assets Current assets cash Account reciables $9,909 21, 163 6 547 19,549 5.88% 13.70% 4.57% 13.65% 5.52% Inventories Other current asset Total current assets 8,068 1,831 40152 7,904 1,681 35 681 5.22% 1. 19% 25.99% 24.92% 204,960 187,519 132.66% 130.97% Non-current asset Property, plant, and equipment Less, Acumulated depreciation Other current asset Total asset (110,020) (97,917) (71.21%) (68.31%) 19,413 154,505 17 891 143,174 12 56% 100% 12.50% 100% Liabilities and stakeholder's equity Current liabilities Accounts payable Short term debt payable 13.792 4,093 22,862 3,703 8.93% 265% 15.97% 2.59% Other current liabilities Total current liabilities 15 290 33,175 3,549 30,114 9.90% 21.47% 2 48% 21.03% Non current liabilities Long term debt payable Deferred income statements Other non current liabilities 6,655 16.484 21,733 7,099 16,359 16,441 4.31% 10.67% 14.07% 4.96% 11.43% 11.48% Total liabilities 78,047 70,013 50.51% 48.90% Stakeholders equity Retained earnings 76.458 73 161 40.49% 51. 10% alish (United States Arrascibili Intimate I found this balance sheet in a chegg answer but I don't know if it is comparative or common size balance sheet, or both
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started