Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets Cash $ 28,921 $ 33,806 $ 35,215 Accounts receivable, net 89,500 62,500 51,800 Merchandise inventory 112,500 84,500 51,000 Prepaid expenses 9,314 8,874 3,913 Plant assets, net 254,909 237,168 217,372 Total assets $ 495,144 $ 426,848 $ 359,300 Liabilities and Equity Accounts payable $ 122,058 $ 71,416 $ 46,953 Long-term notes payable secured by mortgages on plant assets 92,156 97,193 78,611 Common stock, $10 par value 162,500 162,500 162,500 Retained earnings 118,430 95,739 71,236 Total liabilities and equity $ 495,144 $ 426,848 $ 359,300 The company’s income statements for the Current Year and 1 Year Ago, follow. Assume that all sales are on credit: For Year Ended December 31 Current Yr 1 Yr Ago Sales $ 643,687 $ 507,949 Cost of goods sold $ 392,649 $ 330,167 Other operating expenses 199,543 128,511 Interest expense 10,943 11,683 Income tax expense 8,368 7,619 Total costs and expenses 611,503 477,980 Net income $ 32,184 $ 29,969 Earnings per share $ 1.98 $ 1.84
(2-a) Compute accounts receivable turnover. (2-b) For each ratio, determine if it improved or worsened in the current year.
2a | ||||||
Accounts Receivable Turnover | ||||||
Choose Numerator: | / | Choose Denominator: | = | Accounts Receivable Turnover | ||
Net sales | / | Average accounts receivable, net | = | Accounts receivable turnover | ||
Current Yr | 643687 | / | 76000 | = | 8.5 | times |
1 Yr Ago | 507949 | / | 57150 | = | 8.9 | times |
2b | ||||||
Accounts receivable turnover worsened in the current year | ||||||
Workings: | ||||||
Average accounts receivable, net | ||||||
Current Yr | 76000 | =(89500+62500)/2 | ||||
1 Yr Ago | 57150 | =(62500+51800)/2 |
Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs...
Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets Cash $ 26,445 $ 30,912 $ 31,878 Accounts receivable, net 89,500 62,900 51,500 Merchandise inventory 114,000 85,000 56,000 Prepaid expenses 8,516 8,114 3,542 Plant assets, net 209,763 199,474 179,080 Total assets $ 448,224 $ 386,400 $ 322,000 Liabilities and Equity Accounts payable $ 111,608 $ 65,302 $ 42,504 Long-term notes payable secured by mortgages on plant assets 84,266 88,872 71,162 Common stock,...
Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets Cash $ 26,445 $ 30,912 $ 31,878 Accounts receivable, net 89,500 62,900 51,500 Merchandise inventory 114,000 85,000 56,000 Prepaid expenses 8,516 8,114 3,542 Plant assets, net 209,763 199,474 179,080 Total assets $ 448,224 $ 386,400 $ 322,000 Liabilities and Equity Accounts payable $ 111,608 $ 65,302 $ 42,504 Long-term notes payable secured by mortgages on plant assets 84,266 88,872 71,162 Common stock,...
Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets Cash $ 26,445 $ 30,912 $ 31,878 Accounts receivable, net 89,500 62,900 51,500 Merchandise inventory 114,000 85,000 56,000 Prepaid expenses 8,516 8,114 3,542 Plant assets, net 209,763 199,474 179,080 Total assets $ 448,224 $ 386,400 $ 322,000 Liabilities and Equity Accounts payable $ 111,608 $ 65,302 $ 42,504 Long-term notes payable secured by mortgages on plant assets 84,266 88,872 71,162 Common stock,...
Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets Cash $ 29,254 $ 34,195 $ 35,264 Accounts receivable, net 89,400 62,900 51,400 Merchandise inventory 112,000 83,000 59,000 Prepaid expenses 9,421 8,976 3,918 Plant assets, net 255,755 238,369 206,618 Total assets $ 495,830 $ 427,440 $ 356,200 Liabilities and Equity Accounts payable $ 123,462 $ 72,237 $ 47,018 Long-term notes payable secured by mortgages on plant assets 93,216 98,311 78,720 Common stock,...
Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets Cash $ 34,945 $ 43,374 $ 44,312 Accounts receivable, net 104,412 72,956 58,492 Merchandise inventory 132,591 98,354 63,559 Prepaid expenses 11,369 11,386 4,874 Plant assets, net 327,281 300,308 276,363 Total assets $ 610,598 $ 526,378 $ 447,600 Liabilities and Equity Accounts payable $ 155,080 $ 90,737 $ 57,902 Long-term notes payable secured by mortgages on plant assets 114,792 119,856 98,920 Common stock,...
Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets Cash $ 34,945 $ 43,374 $ 44,312 Accounts receivable, net 104,412 72,956 58,492 Merchandise inventory 132,591 98,354 63,559 Prepaid expenses 11,369 11,386 4,874 Plant assets, net 327,281 300,308 276,363 Total assets $ 610,598 $ 526,378 $ 447,600 Liabilities and Equity Accounts payable $ 155,080 $ 90,737 $ 57,902 Long-term notes payable secured by mortgages on plant assets 114,792 119,856 98,920 Common stock,...
Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets Cash $ 32,935 $ 38,498 $ 38,545 Accounts receivable, net 89,200 62,800 51,100 Merchandise inventory 114,000 85,000 51,000 Prepaid expenses 10,606 10,106 4,283 Plant assets, net 295,220 270,804 233,072 Total assets $ 541,961 $ 467,208 $ 378,000 Liabilities and Equity Accounts payable $ 138,997 $ 81,327 $ 51,393 Long-term notes payable secured by mortgages on plant assets 104,945 110,682 86,044 Common stock,...
Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets Cash $ 31,800 $ 35,625 $ 37,800 Accounts receivable, net 89,500 62,500 50,200 Merchandise inventory 112,500 82,500 54,000 Prepaid expenses 10,700 9,375 5,000 Plant assets, net 278,500 255,000 230,500 Total assets $ 523,000 $ 445,000 $ 377,500 Liabilities and Equity Accounts payable $ 129,900 $ 75,250 $ 51,250 Long-term notes payable secured by mortgages on plant assets 98,500 101,500 83,500 Common stock,...
Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets Cash $ 34,945 $ 43,374 $ 44,312 Accounts receivable, net 104,412 72,956 58,492 Merchandise inventory 132,591 98,354 63,559 Prepaid expenses 11,369 11,386 4,874 Plant assets, net 327,281 300,308 276,363 Total assets $ 610,598 $ 526,378 $ 447,600 Liabilities and Equity Accounts payable $ 155,080 $ 90,737 $ 57,902 Long-term notes payable secured by mortgages on plant assets 114,792 119,856 98,920 Common stock,...
Simon Company's year-end balance sheets follow. Current Yr 1 Yr Ago 2 Yrs Ago 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,111 89,500 112,000 10,341 289,624 $ 533,576 $ 37,534 $ 37,948 62,600 51,900 83,500 60,000 9,853 4,216 266,492 221,736 $ 459,979 $ 375,800...