Answered step by step
Verified Expert Solution
Question
1 Approved Answer
help pls begin{tabular}{|r|l|r|r|r|} hline & multicolumn{1}{|c|}{ A } & multicolumn{1}{|c|}{ B } & multicolumn{1}{|c|}{D} hline 1 & multicolumn{1}{|c|}{} & & hline 2 &
help pls
\begin{tabular}{|r|l|r|r|r|} \hline & \multicolumn{1}{|c|}{ A } & \multicolumn{1}{|c|}{ B } & \multicolumn{1}{|c|}{D} \\ \hline 1 & \multicolumn{1}{|c|}{} & & \\ \hline 2 & Simon Company's year-end balance sheets follow. & & \\ \hline 3 & & & & \\ \hline 4 & At December 31 & Current Year & 1 Year Ago & 2 Years Ago \\ \hline 5 & Assets & & & \\ \hline 6 & Cash & $31,800 & $35,625 & $37,800 \\ \hline 7 & Accounts receivable, net & 89,500 & 62,500 & 50,200 \\ \hline 8 & Merchandise inventory & 112,500 & 82,500 & 54,000 \\ \hline 9 & Prepaid expenses & 10,700 & 9,375 & 5,000 \\ \hline 10 & Plant assets, net & 278,500 & 255,000 & 230,500 \\ \hline 11 & Total assets & $523,000 & $445,000 & $377,500 \\ \hline 12 & Liabilities and Equity & & & \\ \hline 13 & Accounts payable & $129,900 & $75,250 & $51,250 \\ \hline 14 & Long-term notes payable & 98,500 & 1,01,500 & 83,500 \\ \hline 15 & Common stock, $10 par value & 163,500 & 163,500 & 163,500 \\ \hline 16 & Retained earnings & 131,100 & 104,750 & 79,250 \\ \hline 17 & Total liabilities and equity & $523,000 & $343,500 & $377,500 \\ \hline \hline \end{tabular} The company's income statements for the current year and one year ago follow. Assume that all sales are on credit: (1-b) Determine if days' sales uncollected improved or worsened in the current year. Days' sales uncollected (2-a) Compute accounts receivable turnover. (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. Accounts receivable turnover (3-a) Compute inventory turnover. (3-b) Determine if inventory turnover ratio improved or worsened in the current year. Inventory turnover (4-a) Compute days' sales in inventory. (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. Days' sales in inventoryStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started