Question

The following financial statements are taken from the records of Jade Inc.

a) Use horizontal analysis techniques to compare the changes between 2018 and 2017 balance sheet items.

Do not enter dollar signs or commas in the input boxes.
Use the negative sign for negative values.
Round all percentages to the nearest whole number (i.e. 21.61% should be entered as 22%).

Jade Inc. Balance Sheet As at March 31
	2018	2017	$ Change	% Change
Current Assets
Cash	$337,200	$328,500	$Answer	Answer%
Accounts Receivable	$215,800	$176,500	$Answer	Answer%
Merchandise Inventory	$377,100	$415,200	$Answer	Answer%
Short-Term Investments	$79,200	$94,500	$Answer	Answer%
Total Current Assets	$1,009,300	$1,014,700	$Answer	Answer%
Noncurrent Assets	$415,600	$309,900	$Answer	Answer%
Total Assets	$1,424,900	$1,324,600	$Answer	Answer%
Current Liabilities	$259,600	$225,100	$Answer	Answer%
Long-Term Liabilities	$111,700	$86,100	$Answer	Answer%
Total Liabilities	$371,300	$311,200	$Answer	Answer%
Stockholders’ Equity	$1,053,600	$1,013,400	$Answer	Answer%
Total Liabilities and Equity	$1,424,900	$1,324,600	$Answer	Answer%

b) Perform a vertical analysis of the income statement for 2018, stating all income statement items as a percentage of net sales.

Jade Inc. Income Statement For the Year Ended March 31
	2018
Sales	$708,000	Answer%
Cost of Goods Sold	$318,600	Answer%
Gross Profit	$389,400	Answer%
Operating Expenses
Administrative Expense	$29,600	Answer%
Selling Expense	$73,800	Answer%
Total Operating Expenses	$103,400	Answer%
Other Income and Expenses
Interest Expense	$16,800	Answer%
Income Before Income Tax	$269,200	Answer%
Income Tax Expense	$80,760	Answer%
Net Income	$188,440	Answer%

Answer 1