Question

Condensed data from the comparative statement of financial position of Greencastle Inc. follow:

		2018		2017		2016
Current assets		$ 118,000		$ 112,000		$ 104,000
Non-current assets		400,000		328,000		298,000
Current liabilities		110,000		99,000		95,000
Non-current liabilities		91,000		110,000		121,000
Common shares		110,000		101,000		101,000
Retained earnings		207,000		130,000		85,000

Part 1

Using horizontal analysis, calculate the percentage of a base-year amount, using 2016 as the base year. (Round answers to 1 decimal place, e.g. 15.2%.)

GREENCASTLE INC. Horizontal Analysis of Statement of Financial Position (% of base-year amount)
		2018			2017			2016
Current assets		enter percentages	%		enter percentages	%		enter percentages	%
Non-current assets		enter percentages	%		enter percentages	%		enter percentages	%
Current liabilities		enter percentages	%		enter percentages	%		enter percentages	%
Non-current liabilities		enter percentages	%		enter percentages	%		enter percentages	%
Common shares		enter percentages	%		enter percentages	%		enter percentages	%
Retained earnings		enter percentages	%		enter percentages	%		enter percentages	%

eTextbook and Media

Part 2

Using horizontal analysis, calculate the percentage change for each year. (Round percentage to 1 decimal place, e.g. 15.2%. Enter negative amounts using either a negative sign preceding the number e.g. -45.1 or parentheses e.g. (45.1)%.)

GREENCASTLE INC. Horizontal Analysis of Statement of Financial Position (% change between periods)
		2018		Increase (Decrease)					2017		Increase (Decrease)					2016
				Amount		%					Amount		%
Assets
Current assets		$ enter a dollar amount		$ enter a dollar amount		enter percentages rounded to 1 decimal place	%		$ enter a dollar amount		$ enter a dollar amount		enter percentages rounded to 1 decimal place	%		$ enter a dollar amount
Non-current assets		enter a dollar amount		enter a dollar amount		enter percentages rounded to 1 decimal place	%		enter a dollar amount		enter a dollar amount		enter percentages rounded to 1 decimal place	%		enter a dollar amount
Total assets		$ enter a total of the two previous amounts		$ enter a total of the two previous amounts		enter percentages rounded to 1 decimal place	%		$ enter a total of the two previous amounts		$ enter a total of the two previous amounts		enter percentages rounded to 1 decimal place	%		$ enter a total of the two previous amounts
Liabilities and Shareholders’ Equity
Liabilities
Current liabilities		$ enter a dollar amount		$ enter a dollar amount		enter percentages rounded to 1 decimal place	%		$ enter a dollar amount		$ enter a dollar amount		enter percentages rounded to 1 decimal place	%		$ enter a dollar amount
Non-current liabilities		enter a dollar amount		enter a dollar amount		enter percentages rounded to 1 decimal place	%		enter a dollar amount		enter a dollar amount		enter percentages rounded to 1 decimal place	%		enter a dollar amount
Total liabilities		enter a total of the two previous amounts		enter a total of the two previous amounts		enter percentages rounded to 1 decimal place	%		enter a total of the two previous amounts		enter a total of the two previous amounts		enter percentages rounded to 1 decimal place	%		enter a total of the two previous amounts
Shareholders’ equity
Common shares		enter a dollar amount		enter a dollar amount		enter percentages rounded to 1 decimal place	%		enter a dollar amount		enter a dollar amount		enter percentages rounded to 1 decimal place	%		enter a dollar amount
Retained earnings		enter a dollar amount		enter a dollar amount		enter percentages rounded to 1 decimal place	%		enter a dollar amount		enter a dollar amount		enter percentages rounded to 1 decimal place	%		enter a dollar amount
Total shareholders’ equity		enter a total of the two previous amounts		enter a total of the two previous amounts		enter percentages rounded to 1 decimal place	%		enter a total of the two previous amounts		enter a total of the two previous amounts		enter percentages rounded to 1 decimal place	%		enter a total of the two previous amounts
Total liabilities and shareholders’ equity		$ enter a dollar amount		$ enter a dollar amount		enter percentages rounded to 1 decimal place	%		$ enter a dollar amount		$ enter a dollar amount		enter percentages rounded to 1 decimal place	%		$ enter a dollar amount

Answer 1

Greencastle Inc.
Balance sheet Data in Trend percentage
(Percentage of Base year)
	2018		2017		2016
	(i)	(i) / (iii)	(ii)	(ii) / (iii)	(iii)
Current Assets	$ 1,18,000	113.5%	$ 1,12,000	107.7%	$ 1,04,000	100.0%
Non - Current Assets	$ 4,00,000	134.2%	$ 3,28,000	110.1%	$ 2,98,000	100.0%
Current liabilities	$ 1,10,000	115.8%	$     99,000	104.2%	$     95,000	100.0%
Non - Current liabilities	$     91,000	75.2%	$ 1,10,000	90.9%	$ 1,21,000	100.0%
Common stock	$ 1,10,000	108.9%	$ 1,01,000	100.0%	$ 1,01,000	100.0%
Retained earnings	$ 2,07,000	243.5%	$ 1,30,000	152.9%	$     85,000	100.0%
Greencastle Inc.
Balance sheet Data in Trend percentage
(Percentage change between periods of Base year)
	2018	Increase (decrease)		2017	Increase (decrease)		2016
		Amount	%		Amount	%
	(i)	(a)	(a) / (ii)	(ii)	(b)	(b) / (iii)	(iii)
Assets
Current Assets	$ 1,18,000	$     6,000	5.36%	$ 1,12,000	$       8,000	7.7%	$ 1,04,000
Non - Current Assets	$ 4,00,000	$   72,000	21.95%	$ 3,28,000	$     30,000	10.1%	$ 2,98,000
Total Assets	$ 5,18,000	$   78,000	17.73%	$ 4,40,000	$     38,000	9.5%	$ 4,02,000
Liabilities
Current liabilities	$ 1,10,000	$   11,000	11.11%	$     99,000	$       4,000	4.2%	$     95,000
Non - Current liabilities	$     91,000	$ -19,000	-17.27%	$ 1,10,000	$   -11,000	-9.1%	$ 1,21,000
Total liabilities	$ 2,01,000	$   -8,000	-3.83%	$ 2,09,000	$     -7,000	-3.2%	$ 2,16,000
Shareholder's Stock
Common stock	$ 1,10,000	$     9,000	8.91%	$ 1,01,000	$              -	0.0%	$ 1,01,000
Retained earnings	$ 2,07,000	$   77,000	59.23%	$ 1,30,000	$     45,000	52.9%	$     85,000
Total Shareholder's Stock	$ 3,17,000	$   86,000	37.23%	$ 2,31,000	$     45,000	24.2%	$ 1,86,000
Total liabilities and Shareholder's Stock	$ 5,18,000	$   78,000	17.73%	$ 4,40,000	$     38,000	9.5%	$ 4,02,000