help in finance and accounting excel sheet

saud.t1

excel_assignment_1_021515_1.docx

Home >Business & Finance homework help >Accounting homework help >help in finance and accounting excel sheet

Excel Assignment #1

Chapter 7 Page 288

Fundamentals of Investing

Due: 11:59 PM February 15, 2015

You have been asked to analyze the financial statements of the Dayton Corp for the 2 years ending 2012 and 2013. Below is the financial data for the two years.

Dayton Corporation
Financial Data

	2012	2013
Net sales	47715	40363
Cost sales	27842	21485
SG&A Expense	8090	7708
Depreciation Expense	628	555
Interest Expense	754	792
Tax Expense	3120	3002
Cash & Equivalents	2144	2536
Receivables	5215	5017
Inventory	3579	3021
Other Current Assets	2022	2777
Plant & Equipment	18956	16707
Accumulated Depreciation	5853	5225
Intangible Assets	7746	7374
Other Non-Current Assets	10465	7700
Payables	5108	4361
Short-Term Notes Payables	4066	3319
Other Current Liabilities	2369	2029
Long-Term Debt	4798	3600
Other Non-Current Liabilities	4837	5020
Common Stock	6776	6746
Retained Earnings	16320	14832
Common Shares Outstanding	2300	2300
Current Market Price Stock	45	45

Questions:

a) Create a comparative balance sheet for the years 2013 and 2012 similar to the spreadsheet for Table 7.3, which can be viewed at www.myfinancelab.com

b) Create a comparative income statement for the years 2013 and 2012 similar to the spreadsheet for Table 7.4, which can be viewed at www.myfinancelab.com

c) Create a spreadsheet to calculate the listed financial ratios for both 2013 and 2012, similar to the spreadsheet for Table 7.6. which can be viewed at www.myfinancelab.com

Ratios	2012	2013
Current Ratio
Quick Ratio
Accounts Receivable Turnover
Inventory Turnover
Total Asset Turnover
Debt-Equity
Times Interest Earned
Net Profit Margin
Return on Equity (ROE)
Earnings per Share
Price-to-Earnings
Book Value per Share
Price-to-Book-Value