Question

You have been asked to analyze the financial statements of the Dayton Corporation for the two years ending 2015 and 2016.

Dayton Corporation
Financial Data
	2015	2016
Net Sales	$47,715	$40,363
Cost Sales	$27,842	$21,485
SG & A expenses	$8,090	$7,708
Depreciation expense	$628	$555
Interest expense	$754	$792
Tax expense	$3,120	$3,002
Cash & equivalents	$2,144	$2,536
Receivables	$5,215	$5,017
Inventory	$3,579	$3,021
Other current assets	$2,022	$2,777
Plant & equipment	$18,956	$16,707
Accumulated depreciation	$5,853	$5,225
Intangible assets	$7,746	$7,374
Other non current assets	$10,456	$7,700
Payables	$5,108	$4,361
Short term notes payable	$4,066	$3,319
Other current liabilities	$2,369	$2,029
Long term ebt	$4,798	$3,600
Other non current liabilities	$4,837	$5,020
Common stock	$6,776	$6,745
Retained earning	$16,050	$14,832
Common shares outstanding	$2,300	$2,300
Current markert price of stock	$45	$45

Create the following in excel.

a. Create a comparative balance sheet for the years 2016 and 2015,

b. Create a comparative income statement for the years 2016 and 2015,

c. Create a spreadsheet to calculate the listed financial ratios for both 2016 and 2015,

Answer 1

On analyzing the financial information by putting it into trial balance form it was found that it has differences in balance of $ 261 and $ 1 in 2015 and 2016 respectively as shown below. On putting it into balance sheet it was observed that the same amount of balance came naturally. Put this into your note while submitting answer

Dayton Corporation
Financial Data
	2015		2016
PARTICULARS	DEBIT	CREDIT	DEBIT	CREDIT
Net Sales		$47,715		$40,363
Cost Sales	$27,842		$21,485
SG & A expenses	$8,090		$7,708
Depreciation expense	$628		$555
Interest expense	$754		$792
Tax expense	$3,120		$3,002
Cash & equivalents	$2,144		$2,536
Receivables	$5,215		$5,017
Inventory	$3,579		$3,021
Other current assets	$2,022		$2,777
Plant & equipment	$18,956		$16,707
Accumulated depreciation		$5,853		$5,225
Intangible assets	$7,746		$7,374
Other non current assets	$10,456		$7,700
Payables		$5,108		$4,361
Short term notes payable		$4,066		$3,319
Other current liabilities		$2,369		$2,029
Long term ebt		$4,798		$3,600
Other non current liabilities		$4,837		$5,020
Common stock		$6,776		$6,745
Retained earning		$8,769		$8,011
TOTAL	$ 90,552.00	$ 90,291.00	$ 78,674.00	$ 78,673.00
DIFFERENCE		261		$1
note: Retained earnings after adjusting current year profit

Answer to Part 1

Dayton Corporation
BALANCE SHEET
Particulars	Debit	Credit
Cash & equivalents	$2,144	$2,536
Receivables	$5,215	$5,017
Inventory	$3,579	$3,021
Other current assets	$2,022	$2,777
Plant & equipment	$18,956	$16,707
Accumulated depreciation	($5,853)	($5,225)
Intangible assets	$7,746	$7,374
Other non current assets	$10,456	$7,700
	$44,265	$39,907
Payables	$5,108	$4,361
Short term notes payable	$4,066	$3,319
Other current liabilities	$2,369	$2,029
Long term ebt	$4,798	$3,600
Other non current liabilities	$4,837	$5,020
Common stock	$6,776	$6,745
Retained earning	$16,050	$14,832
	$44,004	$39,906
	$261	$1

Answer to part 2

Dayton Corporation
INCOME STATEMENT
	2015	2016
Net Sales	$47,715	$40,363
Cost Sales	$27,842	$21,485
SG & A expenses	$8,090	$7,708
Depreciation expense	$628	$555
Interest expense	$754	$792
Tax expense	$3,120	$3,002
	$7,281	$6,821

List of ratios not given for part 3 so not attempted. For more info or clarity please get into comments. Thanks