how do i do the following 1. Compute trend percents for all components of both statements using 2011 as the base year. (Round percents to one decimal.)

2. For 2017 only, create a common-sized Income Statement and Balance Sheet.

3. For 2017 and 2016, create a horizontal analysis of the Income Statement and Balance Sheet showing the amount and percentage changes.

Financial Statement Analysis Homework Handout PROBLEM 17-1A (modified from the problem on page 750 in Fundamental Accounting Principles, 23 ed.) Selected comparative financial statements of Haroun Company follow. Haroun Company Comparative Income Statements For Years Ended December 31, 2017 2011 $ thousands) Sales 2017 2016 2015 2014 2013 2012 2011 $1,694 $1,496 $1,370 $1,264 $1,186 $1,110 $928 400 342 S 118 S 208 234 S 292 288 256 $224 Cost of goods sold 1246 1,032 902 802 752 710 586 Gross profit 448 464 468 462 434 Operating expenses 330 256 234170146144 118 Net income Haroun Company Comparative Balance Sheets December 31, 2017-2011 ($ thousands) Assets Cash Accounts receivable, net Merchandise inventory Other current assets Long-term investments Plant assets, net Total assets 2017 2016 2015 2014 2013 2012 2011 $ 58 $ 78 $ 82 466 84 $88 $ 86 89 216 615 360 1,838 1,364 1,204 1,032 34 146 490 318 936 28 146 302 810 28 146 514 36 0 32 0 146 2,0202,014 1944 978 80 725 4,442 $4,002 S3,518 S2,600 2,494 $2,232 S1,800 Liabilities & Equity Current liabilities Long-term liabiltiies Common stock Other paid-in capital Retained earnings Total liabilities & equity 1,220 $1,042 718 614 546 522 282 400 650 150 1,294 1,140 1,112 1,000 1,000 1,000 250 570 850 170 580 850 170 620 650 150 250 250 $4,442 $4,002 S3,518 $2,600 $2,494 S2,232 S1,800