Question
[The following information applies to the questions displayed below.] Simon Companys year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs
[The following information applies to the questions displayed below.] Simon Companys year-end balance sheets follow.
At December 31 | Current Yr | 1 Yr Ago | 2 Yrs Ago | ||||||||
Assets | |||||||||||
Cash | $ | 32,883 | $ | 38,437 | $ | 39,246 | |||||
Accounts receivable, net | 89,200 | 62,300 | 50,200 | ||||||||
Merchandise inventory | 112,500 | 84,500 | 53,000 | ||||||||
Prepaid expenses | 10,590 | 10,090 | 4,361 | ||||||||
Plant assets, net | 306,651 | 280,383 | 245,693 | ||||||||
Total assets | $ | 551,824 | $ | 475,710 | $ | 392,500 | |||||
Liabilities and Equity | |||||||||||
Accounts payable | $ | 138,778 | $ | 81,199 | $ | 52,328 | |||||
Long-term notes payable secured by mortgages on plant assets | 104,780 | 110,507 | 87,610 | ||||||||
Common stock, $10 par value | 162,500 | 162,500 | 162,500 | ||||||||
Retained earnings | 145,766 | 121,504 | 90,062 | ||||||||
Total liabilities and equity | $ | 551,824 | $ | 475,710 | $ | 392,500 | |||||
The companys income statements for the Current Year and 1 Year Ago, follow. Assume that all sales are on credit:
For Year Ended December 31 | Current Yr | 1 Yr Ago | ||||||||||
Sales | $ | 717,371 | $ | 566,095 | ||||||||
Cost of goods sold | $ | 437,596 | $ | 367,962 | ||||||||
Other operating expenses | 222,385 | 143,222 | ||||||||||
Interest expense | 12,195 | 13,020 | ||||||||||
Income tax expense | 9,326 | 8,491 | ||||||||||
Total costs and expenses | 681,502 | 532,695 | ||||||||||
Net income | $ | 35,869 | $ | 33,400 | ||||||||
Earnings per share | $ | 2.21 | $ | 2.06 | ||||||||
(1-a) Compute days' sales uncollected. (1-b) For each ratio, determine if it improved or worsened in the current year.
(2-a) Compute accounts receivable turnover. (2-b) For each ratio, determine if it improved or worsened in the current year.
(3-a) Compute inventory turnover. (3-b) For each ratio, determine if it improved or worsened in the current year.
(4-a) Compute days' sales in inventory. (4-b) For each ratio, determine if it improved or worsened in the current year.
Required 1A Required 1B Compute days' sales uncollected. Days' Sales Uncollected 1 Choose Denominator: Choose Numerator: X X Days 365 Days' Sales Uncollected Days' Sales Uncollected / = Current Yr: / = 0 days 0 days 1 Yr Ago: / Required 1A Required 1B For each ratio, determine if it improved or worsened in the current year. Days' sales uncollected Improved Required 2A Required 2B Compute accounts receivable turnover. Accounts Receivable Turnover Choose Numerator: 1 Choose Denominator: II Accounts Receivable Turnover Accounts receivable turnover Current Yr: / times 1 Yr Ago: 1 = times Required 2A Required 2B For each ratio, determine if it improved or worsened in the current year. Accounts receivable turnover Required 3A Required 3B Compute inventory turnover. Inventory Turnover | Choose Denominator: Choose Numerator: = Inventory Turnover / II Inventory turnover Current Yr: 1 times 1 Yr Ago: / = times Required 3A Required 3B For each ratio, determine if it improved or worsened in the current year. Inventory turnover Required 4A Required 4B Compute days' sales in inventory. Days' Sales In Inventory Choose Denominator: Choose Numerator: / Days II / = Days' Sales In Inventory Days' sales in inventory days days Current Yr: / = 1 Yr Ago: / II Required 4A Required 4B For each ratio, determine if it 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