Exercise 17-3 Computation and analysis of trend percents LO P1 Sales Cost of goods sold Accounts receivable 2017 2016 2015 2014 2013 $ 470,735 $ 313,823 $ 255,141 $ 180,312 $ 136,600 233,110 155,323 128,369 89,903 66,934 22,784 18,390 17,452 10,512 9,330 Compute trend percents for the above accounts, using 2013 as the base year. Choose Numerator: Trend Percent for Net Sales: Choose Denominator: Sales 2017: % % 2016: 2015: 2014: * Trend Percent for Cost of Goods Sold: Choose Denominator: Choose Numerator: 2017: 2016: 2015: 2014: Cost of goods sold % % % % Trend Percent for Accounts Recolvables: Choose Denominator: Choose Numerator: 2017: 2016: 2015: Accounts receivable % % % 2014: X Exercise 17-6 Common-size percents LO P2 2017 2016 2015 Simon Company's year-end balance sheets At December 31 Assets Cash Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets Liabilities and Equity Accounts payable Long-term notes payable secured by mortgages on plant assets Common stock, $10 par value Retained earnings Total liabilities and equity $ 32,703 $ 39,007 $ 39,429 95, 751 68,262 51,510 124,037 87,498 55,984 10,532 10,547 4,470 302,579 282, 274 250,907 $ 565, 602 $ 487,588 $ 402,300 $ 139,427 $ 79,930 $ 52,573 104,207 111,024 89, 797 163,500 163,500 163,500 158, 468 133, 134 96,430 $ 565,602 $ 487,588 $ 402,300 Express the balance sheets in common-size percents. (Do not round intermediate calculation answers to 1 decimal place.) SIMON COMPANY Common-Size Comparative Balance Sheets December 31, 2015-2017 2017 2016 2015 SIMON COMPANY Common-Size Comparative Balance Sheets December 31, 2015-2017 2017 2016 2015 Assets Cash % % % % % % Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets Liabilities and Equity Accounts payable Long-term notes payable secured by mortgages on plant assets Common stock, $10 par Retained earnings Total liabilities and equity % % % % % % 2017 2016 2015 At December 31 Assets Cash Accounts receivable, ret Merchandise inventory Prepaid expenses Plant assets, net Total assets Liabilities and Equity Accounts payable Long-term noten payable secured by mortgages on plant assets Common stock, $10 par value Retained earnings Total liabilities and equity $ 35,127 $ 41,060 $ 41,513 89,900 62,900 59,400 112,500 83,500 58,000 11,312 10,778 4,613 334,857 304,948 247,574 $ 583,696 $ 503,186 $ 411,100 $ 148,247 $ 86,739 $ 55,351 111,930 118,047 92,670 162,500 162,500 162,500 161,019 135, 900 100.579 $ 583,696 $ 503, 186 $ 411,100 The company's income statements for the years ended December 31, 2017 and 2016, follow. Assume that all sales are on credit: For Year Ended December 31 Sales Cost of goods sold Other operating expenses Interest expense Income taxes Total costs and expenses Net income 2017 $ 758,805 $ 462,871 235,230 12,900 9,864 720,865 $ 37,940 $ 2.33 2016 $ 598,791 $ 389,214 151, 494 13,772 8,982 563,462 $ 35, 329 Earnings per share $ 2.17 Earnings per share $ 2.33 $ 2.17 Exercise 17-8 Part 1 (1) Compute days' sales uncollected Choose Numerator Days' Salon Uncollected | Choose Denominator Days X - Days Sales Uncollected Days' Sales Uncollected o days X 2017: 2016: X o days 2017 2016 2015 At December 31 Assets Cash Accounts receivable, det Merchandise inventory Prepaid expenses Plant annets, net Total assets Liabilities and Equity Accounts payable Long-term notes payable secured by mortgages on plant annet Common stock, $10 par value Retained onrning Total liabilities and equity $ 35,127 $ 41,060 $ 41,513 89,900 62,900 59,400 112,500 83,500 58,000 11.312 10,778 4,613 334,857 304,948 242,574 $583,696 5 503,186 $ 411.100 $ 148,247 $ 86,239 $ 55,351 111.930 118,047 92.670 162.500 162,500 162,500 161,019 135,900 100,579 $ 503,696 5 503,106 5 411,100 The company's income statements for the years ended December 31, 2017 and 2016, follow. Assume that all soles are on credit: Tor Year Ended December 31 Sales Cost of goods sold Other operating expenses Interest expense Income taxes Total costs and expenses Net income Earnings per share 2017 $758,805 5.462,871 235, 230 12,900 9,864 720965 $ 37,940 5 2.33 2016 $ 598,791 $ 389,214 151, 494 13,272 8,982 563,462 $ 35, 329 2.17 For Year Ended December 31 Sales Coat of goods sold Other operating expenses Interest expense Income taxes Total costs and expenses Net income Turning per share 2017 $ 758,805 $.462,871 235,230 12,900 9,864 720, 665 $ 37,940 2016 $ 598,791 $ 389,214 151,494 13,772 8,982 563,462 S 35,329 $ 2.17 $ 2.33 Exercise 17-8 Part 2 (2) Compute accounts receivable turnover. Choose Numerator Accounts Receivable Turnover Choose Denominator Accounts Receivable Turnover Accounts receivable fumover 2017: 2016: times times