Question: I still need help with question a part 2 and question b part 2. please someone explain how i get those answers PART 2 Financial

 I still need help with question a part 2 and question

b part 2. please someone explain how i get those answers PART

2 Financial Tools TO DO a. Create a spreadsheet similar to Table

I still need help with question a part 2 and question b part 2. please someone explain how i get those answers

PART 2 Financial Tools 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, 2015 and 2014. You must calculate the cost of goods sold for the year 2015 (2) A common-size income statement for Dayton, Inc., covering the years 2015 and 2014. 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, 2015 and 2014. (2) A common-size balance sheet for Dayton, Inc., covering the years 2015 and 2014 c. Create a spreadsheet similar to Table 3.8 to perform the following analysis: (1) Create a table that reflects both 2015 and 2014 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 2015 ratios to the 2014 ratios. Indicate whether the results outperformed the prior year" or "underperformed relative to the prior year." celab Visit www.myfinancelab.com for Chapter Case: Assessing Martin Manufacturing's Current Financial Position, Group Exercises, and numerous online resources. PART 2 Financial Tools 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, 2015 and 2014. You must calculate the cost of goods sold for the year 2015 (2) A common-size income statement for Dayton, Inc., covering the years 2015 and 2014. 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, 2015 and 2014. (2) A common-size balance sheet for Dayton, Inc., covering the years 2015 and 2014 c. Create a spreadsheet similar to Table 3.8 to perform the following analysis: (1) Create a table that reflects both 2015 and 2014 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 2015 ratios to the 2014 ratios. Indicate whether the results outperformed the prior year" or "underperformed relative to the prior year." celab Visit www.myfinancelab.com for Chapter Case: Assessing Martin Manufacturing's Current Financial Position, Group Exercises, and numerous online resources

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!