Problem 13-17A (Algo) Horizontal analysis LO 13-1

Prepare a horizontal analysis of both the balance sheet and income statement.

Complete this question by entering your answers in the tabs below.

Analysis Bal Sheet

Analysis Inc Stmt

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).)

ROONEY COMPANY
Horizontal Analysis of Balance Sheets
	Year 4	Year 3	% Change
Assets
Current assets
Cash	$17,100	$12,100		%
Marketable securities	20,200	7,500
Accounts receivable (net)	54,400	47,500
Inventories	136,600	144,700
Prepaid items	26,600	10,700
Total current assets	254,900	222,500
Investments	27,800	21,700
Plant (net)	270,300	256,900
Land	29,700	25,800
Total long-term assets	327,800	304,400
Total assets	$582,700	$526,900
Liabilities and Stockholders Equity
Liabilities
Current liabilities
Notes payable	$15,100	$5,700
Accounts payable	113,300	98,400
Salaries payable	20,300	13,200
Total current liabilities	148,700	117,300
Noncurrent liabilities
Bonds payable	98,900	98,900
Other	31,000	25,100
Total noncurrent liabilities	129,900	124,000
Total liabilities	278,600	241,300
Stockholders' equity
Preferred stock (par value $10, 4% cumulative, nonparticipating; 6,300 shares authorized and issued)	63,000	63,000
Common stock (no par; 50,000 shares authorized; 10,000 shares issued)	63,000	63,000
Retained earnings	178,100	159,600
Total stockholders' equity	304,100	285,600
Total liabilities & stockholders equity	$582,700	$526,900		%

Prepare a horizontal analysis of the income statement. (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).)

ROONEY COMPANY
Horizontal Analysis of Income Statements
	Year 4	Year 3	% Change
Revenues
Sales (net)	$232,000	$211,600		%
Other revenues	8,200	6,900
Total revenues	240,200	218,500
Expenses
Cost of goods sold	119,700	102,900
Selling, general, and administrative expenses	54,700	49,400
Interest expense	7,000	6,200
Income tax expense	21,200	20,200
Total expenses	202,600	178,700
Net income (loss)	$37,600	$39,800		%