2 | ||||||||
Accounts Receivable Turnover | ||||||||
Choose Numerator: | / | Choose Denominator: | = | Accounts Receivable Turnover | ||||
Net sales | / | Average accounts receivable, net | = | Accounts receivable turnover | ||||
2017 | 732,541 | / | 76,000 | = | 9.6 | times | ||
2016 | 578,066 | / | 60,200 | = | 9.6 | times | ||
3 | ||||||||
Inventory Turnover | ||||||||
Choose Numerator: | / | Choose Denominator: | = | Inventory Turnover | ||||
Cost of goods sold | / | Average inventory | = | Inventory turnover | ||||
2017 | 446,850 | / | 97,750 | = | 4.6 | times | ||
2016 | 375,743 | / | 70,750 | = | 5.3 | times | ||
4 | ||||||||
Days’ Sales In Inventory | ||||||||
Choose Numerator: | / | Choose Denominator: | x | Days | = | Days’ Sales In Inventory | ||
Ending inventory | / | Cost of goods sold | x | 365 | = | Days’ sales in inventory | ||
2017 | 112,000 | / | 446,850 | x | 365 | = | 91.5 | days |
2016 | 83,500 | / | 375,743 | x | 365 | = | 81.1 | days |
Workings: | ||||||||
Average Accounts Receivable: | ||||||||
2017 | 76,000 | =(89000+63000)/2 | ||||||
2016 | 60,200 | =(63000+57400)/2 | ||||||
Average Inventory: | ||||||||
2017 | 97,750 | =(112000+83500)/2 | ||||||
2016 | 70,750 | =(58000+83500)/2 |
Required information Part 2 of 4 Exercise 13-8 Liquidity analysis and interpretation LO P3 [The following...
Required information Exercise 13-8 Liquidity analysis and interpretation LO P3 [The following information applies to the questions displayed below.) Simon Company's year-end balance sheets follow. 2017 2016 2015 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,230 $ 37,673 $ 39,243 89,400 62,800 50, 100...
Required information Exercise 13-8 Liquidity analysis and interpretation LO P3 (The following information applies to the questions displayed below.) Simon Company's year-end balance sheets follow. 2017 2016 2015 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 $ 27,733 $ 32,418 $ 32,457 89,500 63,000 52,300 114,000...
Required information Exercise 13-8 Liquidity analysis and interpretation LO P3 [The following information applies to the questions displayed below.] Simon Companyâ€s year-end balance sheets follow. At December 31 2017 2016 2015 Assets Cash $ 26,619 $ 31,115 $ 32,412 Accounts receivable, net 89,000 62,100 53,200 Merchandise inventory 114,500 83,000 57,000 Prepaid expenses 8,572 8,168 3,601 Plant assets, net 217,041 208,489 184,487 Total assets $ 455,732 $ 392,872 $ 330,700 Liabilities and Equity Accounts payable $ 112,342 $ 65,731 $ 43,216...
Exercise 17-8 Liquidity analysis and interpretation LO P3 [The following information applies to the questions displayed below.j Simon Company's year-end balance sheets follovw At December 31 Assets Cash Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets 2017 $ 31,800 35,625 $37,800 50,200 54,000 5,000 278, 500 255,000 230,500 $523,000 $445,000 377,500 89,500 62,500 112,500 82,500 9,375 10,700 Liabilities and Equity Accounts payable Long-term notes payable secured by $129,900 75,250 $ 51,250 mortgages on plant assets Common...
Exercise 13-8 Liquidity analysis and interpretation LO P3 [The following information applies to the questions displayed below Simon Company's year-end balance sheets follow Assets Cash Accounts receivable, net Nerchandise inventory Prepaid expenses Plant assets, net Total assets $25,396 $ 29,685 30,922 89,90063,000 57,000 110,500 84,000 60,000 8,1787,7923,436 200,810 190,337 164,142 $ 434,784 $374,814 $ 315,500 Liabilities and Equity Accounts payable Long-tern notes payable secured by 107,179 5 62,710 $ 41,230 mortgages on plant assets Common stock, $10 par value 80,922...
Exercise 17-8 Liquidity analysis and interpretation LO P3 [The following information applies to the questions displayed below.] Simon Company’s year-end balance sheets follow. The company’s income statements for the years ended December 31, 2017 and 2016, follow. Assume that all sales are on credit: Exercise 17-8 Part 1 (1) Compute days' sales uncollected. Exercise 17-8 Part 2 (2) Compute accounts receivable turnover. Exercise 17-8 Part 3 (3) Compute inventory turnover. Exercise 17-8 Part 4 (4) Compute days' sales in inventory....
Exercise 13-10 Efficiency and profitability analysis LO P3 [The following information applies to the questions displayed below.] Simon Company’s year-end balance sheets follow. At December 31 2017 2016 2015 Assets Cash $32,200 $ 36,250 $ 38,000 63,000 82,000 9,450 251,000 Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net 89,700 113,000 10,300 50,500 55,000 5,400 282,000 229,000 $527,200 $441,700 $377,900 Total assets Liabilities and Equity Accounts payable Long-term notes payable secured by mortgages on plant assets Common stock, $10...
Required information Exercise 13-10 Efficiency and profitability analysis LO P3 (The following information applies to the questions displayed below.) Simon Company's year-end balance sheets follow. 2017 2016 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 s mortgages on plant assets Common stock, $10 par value Retained earnings Total liabilities and equity $ 30,400 $ 35,000 $ 37,800 87,100 61,500 51,000 111,000 83,600 53,500...
requirea information Exercise 13-9 Risk and capital structure analysis LO P3 The following information applies to the questions displayed below.) Simon Company's year-end balance sheets follow. 2017 2016 2015 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 $ 26,279 $ 30,410 $ 31,367 75,402 52,681 40,580...
Make sure the steps are clear please 4 Check ny w Required information Exercise 13-8 Liquidity analysis and interpretation LO P3 (The following information applies to the questions displayed below] Simon Company's year-end balance sheets follow. Part 1 of 4 714 points Cash Accounts receivable, net Merchandise inventory Prepaid expensers Plant assets, net Total assets 34,644 40,496 42,184 89,200 62,800 50,600 112,500 84,000 5,000 10,630 345,624 313,389 278,929 $593,125 $ 511,315 $430,400 11,157 Hint Liabilities and Equity Accounts payable Long-term...