Question
Simon Company's year-end balance sheets follow. At December 31 Current Year 1 Year Ago 2 Years Ago Assets Cash $ 28,970 $ 33,193 $ 33,559
Simon Company's year-end balance sheets follow.
At December 31 | Current Year | 1 Year Ago | 2 Years Ago |
---|---|---|---|
Assets | |||
Cash | $ 28,970 | $ 33,193 | $ 33,559 |
Accounts receivable, net | 82,301 | 59,260 | 46,553 |
Merchandise inventory | 104,523 | 78,308 | 47,648 |
Prepaid expenses | 8,960 | 8,625 | 3,804 |
Plant assets, net | 261,400 | 239,712 | 210,836 |
Total assets | $ 486,154 | $ 419,098 | $ 342,400 |
Liabilities and Equity | |||
Accounts payable | $ 119,842 | $ 70,119 | $ 45,197 |
Long-term notes payable | 91,397 | 98,320 | 74,914 |
Common stock, $10 par value | 163,500 | 162,500 | 163,500 |
Retained earnings | 111,415 | 88,159 | 58,789 |
Total liabilities and equity | $ 486,154 | $ 419,098 | $ 342,400 |
For both the current year and one year ago, compute the following ratios:
The companys income statements for the current year and one year ago follow. Assume that all sales are on credit:
For Year Ended December 31 | Current Year | 1 Year Ago | ||
---|---|---|---|---|
Sales | $ 632,000 | $ 498,727 | ||
Cost of goods sold | $ 385,520 | $ 324,173 | ||
Other operating expenses | 195,920 | 126,178 | ||
Interest expense | 10,744 | 11,471 | ||
Income tax expense | 8,216 | 7,481 | ||
Total costs and expenses | 600,400 | 469,303 | ||
Net income | $ 31,600 | $ 29,424 | ||
Earnings per share | $ 1.94 | $ 1.81 |
(1-a) Compute days' sales uncollected.
(1-b) Determine if days' sales uncollected improved or worsened in the current year.
(2-a) Compute accounts receivable turnover.
(2-b) Determine if accounts receivable turnover ratio improved or worsened in the current year.
(3-a) Compute inventory turnover.
(3-b) Determine if inventory turnover ratio improved or worsened in the current year.
(4-a) Compute days' sales in inventory.
(4-b) For each ratio, determine if days' sales in inventory improved or worsened in the current year.
Step 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