Data for Dumouchelle, Inc follow

Dumouchelle, Inc
Comparative Balance Sheet
December 31, 2017 and 2016
2017 2016
Assets
Current Assets:
Cash $12,000 $10,200
Accounts Receivable, Net 16,100 16,800
Merchandise Inventory 45,000 31,000
Prepaid Expenses 6,500 3,900
Total Current Assets 79,600 61,900
Property, Plant, and Equipment, Net 265,000 233,000
Total Assets $344,600 $294,900
Liabilities
Total Current Liabilities $9,900 $11,200
Long-term Liabilities 60,000 50,000
Total Liabilities 69,900 61,200
Stockholders' Equity
Preferred Stock, 3%, $50 par 75,000 75,000
Common Stockholders' Equity, no par 199,700 158,700
Total Liabilities and Stockholders' Equity $344,600 $294,900

Prepare a horizontal analysis of the comparative balance sheet of Dumouchelle, Inc (Round to one decimal place.)

What will be an ideal response

Comparative Balance Sheet—Horizontal Analysis

Dumouchelle, Inc.
Comparative Balance Sheet
December 31, 2017 and 2016
Increase (Decrease)
2017 2016 Amount Percentage
Assets
Current Assets:
Cash $12,000 $10,200 $1,800 17.6
Accounts Receivables, Net 16,100 16,800 (700 ) (4.2 )
Merchandise Inventory 45,000 31,000 14,000 45.2
Prepaid Expenses 6,500 3,900 2,600 66.7
Total Current Assets 79,600 61,900 17,700 28.6
Property, Plant, and Equipment, Net 265,000 233,000 32,000 13.7
Total Assets $344,600 $294,900 $49,700 16.9
Liabilities
Total Current Liabilities $9,900 $11,200 $(1,300 ) (11.6 )
Long-term Liabilities 60,000 50,000 10,000 20.0
Total Liabilities 69,900 61,200 8,700 14.2
Stockholders' Equity
Preferred Stock, 3%, $50 PV 75,000 75,000 $0 0.0
Common Stockholders' Equity, no par 199,700 158,700 41,000 25.8
Total Liabilities and Stockholders'
Equity $344,600 $294,900 $49,700 16.9