Question

Prepare a horizontal analysis of both the balance sheet and income statement.  Analysis Bal Sheet Analysis Inc Stmt  Complete this question by entering your answers in the tabs below. Prepare a horizontal analysis of the balance sheet. (Negative answers should be indicated by a minus sign. Round your answers to 1 decimal place. (i.e., .234 should be entered as 23.4).) Analysis Bal Sheet Analysis Inc Stmt $ $ $ $ $ $ $ $ STUART COMPANY Horizontal Analysis of Balance Sheets 2019 2018 Percentage Change

Assets

Current assets

Cash 17,000 13,400 %

Marketable securities 21,200 7,900

Accounts receivable (net) 54,600 46,200

Inventories 136,000 144,100

Prepaid items 26,600 10,300

Total current assets 255,400 221,900

Investments 28,300 21,100

Plant (net) 270,500 255,700

Land 29,900 25,700

Total long-term assets 328,700 302,500

Total assets 584,100 524,400

Liabilities and Stockholders’ Equity Liabilities

Current liabilities Notes payable 15,400 5,200

Accounts payable 113,400 99,200

Salaries payable 19,300 14,100

Total current liabilities 148,100 118,500

Noncurrent liabilities

Bonds payable 99,500 99,500

Other 30,000 25,600

Total noncurrent liabilities 129,500 125,100

Total liabilities 277,600 243,600

Stockholders' equity

Preferred stock (par value $10, 4% cumulative, nonparticipating; 6,400 shares authorized and issued) 64,000 64,000

Common stock (no par; 50,000 shares authorized; 10,000 shares issued) 64,000 64,000

Retained earnings 178,500 152,800

Total stockholders' equity 306,500 280,800

Total liabilities & stockholders’ equity 584,100 524,400 %

We have 2018 and 2019 amounts. Just need the third column which would all be percentages.

If question can't be understood please comment. ASAP.

Answer 1

Horizontal Analysis is shown as follows:-      (Amounts in $)

Stuart Company
Horizontal Analysis of Balance Sheet
	2019 (A)	2018 (B)	Change in $ (C=A-B)	% Change (C/B)*100
Assets
Current Assets
Cash	17,000	13,400	3,600	26.9%
Marketable Securities	21,200	7,900	13,300	168.3%
Account Receivables (net)	54,600	46,200	8,400	18.2%
Inventories	136,000	144,100	(8,100)	(5.6)%
Prepaid items	26,600	10,300	16,300	158.3%
Total Current Assets	255,400	221,900	33,500	15.1%
Investments	28,300	21,100	7,200	34.1%
Plant (net)	270,500	255,700	14,800	5.8%
Land	29,900	25,700	4,200	16.3%
Total Long term Assets	328,700	302,500	26,200	8.7%
Total Assets	584,100	524,400	59,700	11.4%
Liabilities and Stockholders' Equity
Liabilities
Current Liabilities
Notes payable	15,400	5,200	10,200	196.2%
Accounts Payable	113,400	99,200	14,200	14.3%
Salaries Payable	19,300	14,100	5,200	36.9%
Total Current Liabilities	148,100	118,500	29,600	25%
Non-Current Liabilities
Bonds Payable	99,500	99,500	0	0%
Other	30,000	25,600	4,400	17.2%
Total Non-Current Liabilities	129,500	125,100	4,400	3.5%
Total Liabilities	277,600	243,600	34,000	14%
Stockholders' Equity
Preferred Stock	64,000	64,000	0	0%
Common Stock	64,000	64,000	0	0%
Retained Earnings	178,500	152,800	25,700	16.9%
Total Stockholders' Equity	306,500	280,800	25,700	9.2%
Total Liabilities and Stockholders' Equity	584,100	524,400	59,700	11.4%