80.2K

Verified Solution

Link Copied!

Simon Company's year-end balance sheets follow. \begin{tabular}{lr|r|r|} \hline At December 31 & Current Year & 1 Year Ago & 2 Years Ago \\ \hline Assets & & & \\ \hline Cash & $31,800 & $35,625 & $37,800 \\ \hline Accounts receivable, net & 89,500 & 62,500 & 50,200 \\ \hline Merchandise inventory & 112,500 & 82,500 & 54,000 \\ \hline Prepaid expenses & 10,700 & 9,375 & 5,000 \\ \hline Plant assets, net & 278,500 & 255,000 & 230,500 \\ \hline Total assets & $523,000 & $445,000 & $377,500 \\ \hline Llabilitles and Equlty & & & \\ \hline Accounts payable & $129,900 & $75,250 & $51,250 \\ \hline Long-term notes payable & 98,500 & 1,01,500 & 83,500 \\ \hline Common stock, $10 par value & 163,500 & 163,500 & 163,500 \\ \hline Retained earnings & 131,100 & 104,750 & 79,250 \\ \hline Total liabilities and equity & $523,000 & $343,500 & $377,500 \\ \hline \end{tabular} The company's income statements for the current year and one year ago follow. Assume that all sales are on credit: (Use cells A4 to E29 from the given information to complete this queston.) (1-b) Determine if days' sales uncollected improved or worsened in the current year. (Use cells A4 to E29 from the given information to complete this question.) (2-b) Determine if accounts receivable turnover ratio improved or worsened in the current year. (Use cells A4 to E29 from the given Information to complete this question.) (3-b) Determine if inventory turnover ratio improved or worsened in the current year. (Use cells A4 to E29 from the given Information to complete this question.) (4-b) For each ratio, determine if days' sales in inventory improved or worsened in the current year

Answer & Explanation Solved by verified expert

See Answer