Question
Simon Companys year-end balance sheets follow. At December 31 Current Year 1 Year Ago 2 Years Ago Assets Cash $ 31,800 $ 35,625 $ 37,800
Simon Companys year-end balance sheets follow.
At December 31 | Current Year | 1 Year Ago | 2 Years 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 | 98,500 | 101,500 | 83,500 |
Common stock, $10 par value | 163,500 | 163,500 | 163,500 |
Retained earnings | 131,100 | 104,750 | 79,250 |
Total liabilities and equity | $ 523,000 | $ 445,000 | $ 377,500 |
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 | $ 673,500 | $ 532,000 | ||
Cost of goods sold | $ 411,225 | $ 345,500 | ||
Other operating expenses | 209,550 | 134,980 | ||
Interest expense | 12,100 | 13,300 | ||
Income tax expense | 9,525 | 8,845 | ||
Total costs and expenses | 642,400 | 502,625 | ||
Net income | $ 31,100 | $ 29,375 | ||
Earnings per share | $ 1.90 | $ 1.80 |
(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