Question

Problem 17-1A Calculation and analysis of trend percents LO A1, P1 Selected comparative financial statements of Haroun Company follow. HAROUN COMPANY Comparative Income Statements For Years Ended December 31, 2017–2011 ($ thousands) 2017 2016 2015 2014 2013 2012 2011 Sales $ 2,870 $ 2,514 $ 2,287 $ 2,096 $ 1,956 $ 1,819 $ 1,491 Cost of goods sold 2,063 1,678 1,444 1,264 1,174 1,098 875 Gross profit 807 836 843 832 782 721 616 Operating expenses 614 480 440 325 282 278 231 Net income $ 193 $ 356 $ 403 $ 507 $ 500 $ 443 $ 385 HAROUN COMPANY Comparative Balance Sheets December 31, 2017–2011 ($ thousands) 2017 2016 2015 2014 2013 2012 2011 Assets Cash $ 89 $ 118 $ 122 $ 125 $ 130 $ 128 $ 132 Accounts receivable, net 640 672 608 467 411 389 275 Merchandise inventory 2,315 1,685 1,472 1,241 1,114 946 686 Other current assets 59 54 33 59 50 51 26 Long-term investments 0 0 0 182 182 182 182 Plant assets, net 2,832 2,821 2,469 1,392 1,439 1,280 1,099 Total assets $ 5,935 $ 5,350 $ 4,704 $ 3,466 $ 3,326 $ 2,976 $ 2,400 Liabilities and Equity Current liabilities $ 1,491 $ 1,254 $ 822 $ 684 $ 594 $ 561 $ 362 Long-term liabilities 1,595 1,390 1,352 628 641 694 521 Common stock 1,080 1,080 1,080 960 960 840 840 Other paid-in capital 270 270 270 240 240 210 210 Retained earnings 1,499 1,356 1,180 954 891 671 467 Total liabilities and equity $ 5,935 $ 5,350 $ 4,704 $ 3,466 $ 3,326 $ 2,976 $ 2,400 Required: 1. Complete the below table to calculate the trend percents for all components of both statements using 2011 as the base year. (Round your percentage answers to 1 decimal place.)

please solve both tabs for me

Answer 1

HAROUN COMPANY Income Statement Trends For Years Ended December 31, 2017-2011
	2017	%	2016	%	2015	%	2014	%	2013	%	2012	%	2011	%
Sales	192.5		168.6		153.4		140.6		131.2		122		100
Cost of goods sold	235.8		191.8		165		144.5		134.2		125.5		100
Gross profit	131		135.7		136.9		135.1		127		117		100
Operating expenses	265.8		207.8		190.5		140.7		122.1		120.3		100
Net income	50.1	%	92.5	%	104.7	%	131.7	%	129.9	%	115.1	%	100	%

2.

HAROUN COMPANY Balance Sheet Trends December 31, 2017-2011
	2017	%	2016	%	2015	%	2014	%	2013	%	2012	%	2011	%
Assets
Cash	67.4		89.4		92.4		94.7		98.5		97		100
Accounts receivable, net	232.7		244.4		221.1		169.8		149.5		141.5		100
Merchandise inventory	337.5		245.6		214.6		180.9		162.4		138		100
Other current assets	227		207.7		127		227		192.3		196.2		100
Long term investments	0		0		0		100		100		100		100
Plant assets, net	257.7		256.7		224.7		126.7		131		116.5		100
Total assets	247.3		223		196		144.4		138.6		124		100
Liabilities and Equity
Current liabilities	411.9		346.4		227.1		189		164.1		155		100
Long term liabilities	306		266.8		259.5		120.5		123		133		100
Common stock	128.6		128.6		128.6		114.3		114.3		100		100
Other paid in capital	128.6		128.6		128.6		114.3		114.3		100		100
Retained earnings	320		290.4		252.7		204.3		190.8		143.7		100
Total liabilities and equity	247.3	%	223	%	196	%	144.4	%	138.6	%	124	%	100	%