Problem 13-1A Calculation and analysis of trend percents LO A1, P1 Selected comparative financial statements of...

  
 

Transcribed Image Text:

Problem 13-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 (S thousands) Sales 2017 2016 2015 2014 2013 2012 2011 $1,694 $1,496 $1,370 $1,264 $1,186 $1,110 $928 586 342 118 710 Cost of goods sold Groas profit Operating expenses 1,246 1,032 902 468 802 752 434 146 448 464 462 400 330 256 234 170 144 Net income $ 118 $ 208 $ 234S 292 $ 288 $ 256 $224 HAROUN COMPANY Comparative Balance Sheets December 31, 2017-2011 2017 LS thousandn) 2016 2015 2014 2013 2012 2011 Assets Cash Accounts receivable, net Merchandise inventory Other current assets Long-term investments Plant ansets, net 58 $ 490 1,838 36 78 $ 82 $ 466 1,204 84 360 1,032 34 88 318 86 $ 89 514 302 216 1,364 32 936 810 615 14 28 28 0. 146 146 978 146 146 2,014 2,020 $4,442 $4,002 $3,518 $2,600 $2,494 $2,232 1,752 944 860 725 Total assets $1,800 Liabilities and Equity Current liabilitien Long-term liabilitios Common stock Other paid-in capital Retained earnings $1,220 $1,042 1,294 1,000 250 718 $ 1,112 1,000 250 138 $4,442 $4,002 $3,518 614 546 $ 522 $ 620 282 400 1,140 1,000 250 570 580 850 850 650 650 170 170 150 150 678 570 290 $2,600 62,494 $2, 232 396 348 318 Total 1iabil1ities and equity $1,800 Required: 1. Complete the below table to calculate the trend percents for all components of both statements using 2011 as the base ye your percentage answers to 1 decimal place.) Complete this question by entering your answers in the tabs below. Comp IS Comp BS Complete the below table to calculate the trend percents for all components of comparative income statements using 2011 as the 1,032 810 615 Merchandise inventory Other current assets 1,838 1,364 32 1,204 14 936 28 36 34 28 9. Long-term investments Plant assetS, net 146 146 146 978 146 2,020 2,014 1,752 944 860 725 Total assets $4,442 $4, 002 $3,518 $2,600 $2,494 $2,232 $1,800 Liabilities and Equity 614 $4 546 282 522 620 Current liabilities Long-term liabilities Common stock $1,220 $1,042 $ 1,294 1,000 718 1,112 1,000 1,140 400 570 850 170 396 580 850 170 348 650 150 1,000 650 Other paid-in capital Retained earnings 150 250 678 250 250 570 438 290 318 Total liabilities and equity $4,442 $4,002 $3,518 $2,600 $2,494 $2,232 $1,800 Required: 1. Complete the beiow table to calculate the trend percents for all components of both statements using 2011 as the base your percentage answers to 1 decimal place.) Complete this question by entering your answers in the tabs below. Comp IS Comp BS Complete the below table to calculate the trend percents for all components of comparative income statements using 2011 as ti HAROUN COMPANY Income Statement Trends For Years Ended December 31, 2017-2011 2017 2016 2015 2014 2013 2012 2011 Sales 100.0 % Cost of goods sold 100.0 Gross profit 100.0 Operating expenses 100.0 Net income 100.0 % Cump to Comp BS 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.) Complete this question by entering your answers in the tabs below. Comp IS Comp BS Complete the below table to calculate the trend percents for all components of comparative balance sheets using 2011 as the base year. HAROUN COMPANY Balance Sheet Trends December 31, 2017-2011 2017 2016 2015 2014 2013 2012 2011 Assets Cash Accounts receivable, net Merchandise inventory % 100.0 % 100.0 100.0 Other current assets 100.0 Long-term investments Plant assets, net 100.0 100.0 Total assets 100.0 % Liabilities and Equity Current liabilities 100.0 % Long-term liabilities 100.0 Common stock 100.0 Other paid-in capital Retained eamings 100.0 100.0 Tolal tabilities & equity 100.0 % < Comp IS Com Problem 13-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 (S thousands) Sales 2017 2016 2015 2014 2013 2012 2011 $1,694 $1,496 $1,370 $1,264 $1,186 $1,110 $928 586 342 118 710 Cost of goods sold Groas profit Operating expenses 1,246 1,032 902 468 802 752 434 146 448 464 462 400 330 256 234 170 144 Net income $ 118 $ 208 $ 234S 292 $ 288 $ 256 $224 HAROUN COMPANY Comparative Balance Sheets December 31, 2017-2011 2017 LS thousandn) 2016 2015 2014 2013 2012 2011 Assets Cash Accounts receivable, net Merchandise inventory Other current assets Long-term investments Plant ansets, net 58 $ 490 1,838 36 78 $ 82 $ 466 1,204 84 360 1,032 34 88 318 86 $ 89 514 302 216 1,364 32 936 810 615 14 28 28 0. 146 146 978 146 146 2,014 2,020 $4,442 $4,002 $3,518 $2,600 $2,494 $2,232 1,752 944 860 725 Total assets $1,800 Liabilities and Equity Current liabilitien Long-term liabilitios Common stock Other paid-in capital Retained earnings $1,220 $1,042 1,294 1,000 250 718 $ 1,112 1,000 250 138 $4,442 $4,002 $3,518 614 546 $ 522 $ 620 282 400 1,140 1,000 250 570 580 850 850 650 650 170 170 150 150 678 570 290 $2,600 62,494 $2, 232 396 348 318 Total 1iabil1ities and equity $1,800 Required: 1. Complete the below table to calculate the trend percents for all components of both statements using 2011 as the base ye your percentage answers to 1 decimal place.) Complete this question by entering your answers in the tabs below. Comp IS Comp BS Complete the below table to calculate the trend percents for all components of comparative income statements using 2011 as the 1,032 810 615 Merchandise inventory Other current assets 1,838 1,364 32 1,204 14 936 28 36 34 28 9. Long-term investments Plant assetS, net 146 146 146 978 146 2,020 2,014 1,752 944 860 725 Total assets $4,442 $4, 002 $3,518 $2,600 $2,494 $2,232 $1,800 Liabilities and Equity 614 $4 546 282 522 620 Current liabilities Long-term liabilities Common stock $1,220 $1,042 $ 1,294 1,000 718 1,112 1,000 1,140 400 570 850 170 396 580 850 170 348 650 150 1,000 650 Other paid-in capital Retained earnings 150 250 678 250 250 570 438 290 318 Total liabilities and equity $4,442 $4,002 $3,518 $2,600 $2,494 $2,232 $1,800 Required: 1. Complete the beiow table to calculate the trend percents for all components of both statements using 2011 as the base your percentage answers to 1 decimal place.) Complete this question by entering your answers in the tabs below. Comp IS Comp BS Complete the below table to calculate the trend percents for all components of comparative income statements using 2011 as ti HAROUN COMPANY Income Statement Trends For Years Ended December 31, 2017-2011 2017 2016 2015 2014 2013 2012 2011 Sales 100.0 % Cost of goods sold 100.0 Gross profit 100.0 Operating expenses 100.0 Net income 100.0 % Cump to Comp BS 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.) Complete this question by entering your answers in the tabs below. Comp IS Comp BS Complete the below table to calculate the trend percents for all components of comparative balance sheets using 2011 as the base year. HAROUN COMPANY Balance Sheet Trends December 31, 2017-2011 2017 2016 2015 2014 2013 2012 2011 Assets Cash Accounts receivable, net Merchandise inventory % 100.0 % 100.0 100.0 Other current assets 100.0 Long-term investments Plant assets, net 100.0 100.0 Total assets 100.0 % Liabilities and Equity Current liabilities 100.0 % Long-term liabilities 100.0 Common stock 100.0 Other paid-in capital Retained eamings 100.0 100.0 Tolal tabilities & equity 100.0 % < Comp IS Com