Question
Simon Company's year-end balance sheets follow. At December 31 Current Year 1 Year Ago 2 Years Ago Assets Cash $ 31,830 $ 36,101 $ 37,989
Simon Company's year-end balance sheets follow.
At December 31 | Current Year | 1 Year Ago | 2 Years Ago |
---|---|---|---|
Assets | |||
Cash | $ 31,830 | $ 36,101 | $ 37,989 |
Accounts receivable, net | 90,425 | 64,466 | 50,652 |
Merchandise inventory | 112,544 | 87,742 | 54,489 |
Prepaid expenses | 10,250 | 9,476 | 4,138 |
Plant assets, net | 289,095 | 262,684 | 228,932 |
Total assets | $ 534,144 | $ 460,469 | $ 376,200 |
Liabilities and Equity | |||
Accounts payable | $ 135,662 | $ 76,263 | $ 50,652 |
Long-term notes payable | 102,427 | 104,849 | 85,634 |
Common stock, $10 par value | 163,500 | 162,500 | 163,500 |
Retained earnings | 132,555 | 116,857 | 76,414 |
Total liabilities and equity | $ 534,144 | $ 460,469 | $ 376,200 |
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 | $ 694,387 | $ 547,958 | ||
Cost of goods sold | $ 423,576 | $ 356,173 | ||
Other operating expenses | 215,260 | 138,633 | ||
Interest expense | 11,805 | 12,603 | ||
Income tax expense | 9,027 | 8,219 | ||
Total costs and expenses | 659,668 | 515,628 | ||
Net income | $ 34,719 | $ 32,330 | ||
Earnings per share | $ 2.14 | $ 1.99 |
(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