I will leave a great rating

table 3.1

table 3.2

table 3.10

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 management 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. You also have the following balance sheet information as of December 31,2019 and 2018, respectively. You also have the following balance sheet information as of December 31,2019 and 2018 , respectively. a. Create a spreadsheet similar to Table 3.10 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.100 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," Table 3.1 Bartlett Company Income Statements (\$000) Table 3.2 Bartlett Company Balance Sheets (5000) December 31 Assets Cash Marketable securities Accounts recelvable Inventories Total current assets Land and buildings Machinery and equipment Furniture and fixtures vehicles Other (includes financial leases) Total gross fixed assets (at cost) Less: Accumulated depreciation Net fixed assets Total assets 20192018 5363 $288 68 51 503 365 289 300 \begin{tabular}{cc} \hline$1,223 & $1,004 \\ \hline$2,072 & $1,903 \end{tabular} 1,866 1,693 358 275 98 316 314 96 \begin{tabular}{rr} \hline$4,669 & $4,322 \\ 2,295 & 2,056 \\ \hline$2,374 & $2,266 \\ \hline$3,597 & $3,270 \\ \hline \end{tabular} Liabilities and Stockholders' Equity Accounts payable Notes payable Accruals Total current liabilities Long-term debt (includes financial leases) Total liabilities Preferred stock: cumulative 5%, $100 par, Liabilities and Stockholders' Equity Accounts payable Notes payable Accruals Total current liabilities Long-term debt (includes financial leases) Total liabilities Preferred stock: cumulative 5%, $100 par, 2,000 shares authorized and issued Common stock: \$2.50 par, 100,000 shares 191 191 authorized, shares issued and outstanding in 79 $270 $382 99 2019: 76,262; in 2018:76,244 Paid-in capital in excess of par on common 428 417 stock Retained earnings Total stockholders' equity Total liabilities and stockholders' equity 1.135 1,012 $1,954 $1,820 $3,597 $3,270 Table 3.10 Profitability