Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

[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. image text in transcribed image text in transcribed

(2-a) Compute accounts receivable turnover. (2-b) For each ratio, determine if it improved or worsened in the current year.image text in transcribedimage text in transcribed

(3-a) Compute inventory turnover. (3-b) For each ratio, determine if it improved or worsened in the current year.image text in transcribedimage text in transcribed

(4-a) Compute days' sales in inventory. (4-b) For each ratio, determine if it improved or worsened in the current year.image text in transcribedimage text in transcribed

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 inventory

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Laboratory Auditing For Quality And Regulatory Compliance

Authors: Donald C. Singer, Raluca-Ioana Stefan, Jacobus F. Van Staden

1st Edition

0367392461, 978-0367392468

More Books

Students also viewed these Accounting questions

Question

Draw a planar graph with 5 nodes and 8 edges.

Answered: 1 week ago

Question

Identify the elements that make up the employee reward package.

Answered: 1 week ago

Question

Understand the purpose, value and drawbacks of the interview.

Answered: 1 week ago