Question

In: Accounting

Your answer is partially correct. Try again. The condensed financial statements of Sheridan Company for the...

Your answer is partially correct. Try again.

The condensed financial statements of Sheridan Company for the years 2016 and 2017 are presented as follows. (Amounts in thousands.)

SHERIDAN COMPANY
Balance Sheets
December 31

2017

2016

Current assets
   Cash and cash equivalents

$330

$360

   Accounts receivable (net)

660

590

   Inventory

660

590

   Prepaid expenses

120

160

     Total current assets

1,770

1,700

Investments

200

200

Property, plant, and equipment (net)

420

380

Intangibles and other assets

530

510

     Total assets

$2,920

$2,790

Current liabilities

$1,090

$980

Long-term liabilities

610

580

Stockholders’ equity—common

1,220

1,230

     Total liabilities and stockholders’ equity

$2,920

$2,790

SHERIDAN COMPANY
Income Statements
For the Year Ended December 31

2017

2016

Sales revenue

$4,000

$3,660

Costs and expenses
   Cost of goods sold

1,145

1,080

   Selling & administrative expenses

2,400

2,330

   Interest expense

25

20

     Total costs and expenses

3,570

3,430

Income before income taxes

430

230

Income tax expense

129

69

Net income

$ 301

$ 161


Compute the following ratios for 2017 and 2016. (Round current ratio and inventory turnover to 2 decimal places, e.g. 1.83 and all other answers to 1 decimal place, e.g. 1.8 or 12.6%.)

(a) Current ratio.
(b) Inventory turnover. (Inventory on 12/31/15 was $410.)
(c) Profit margin.
(d) Return on assets. (Assets on 12/31/15 were $2,230.)
(e) Return on common stockholders’ equity. (Stockholders’ equity on 12/31/15 was $980.)
(f) Debt to assets ratio.
(g) Times interest earned.

2017

2016

Current ratio. :1 :1
Inventory turnover. times times
Profit margin. % %
Return on assets. % %
Return on common stockholders’ equity. % %
Debt to assets ratio. % %
Times interest earned. times times

Solutions

Expert Solution

Answer :-

a. Current Ratio = Current assets/ Current liabilities

For 2017 = $1,770 / $1,090 = 1.62

For 2016 = $1,700 / $980 = 1.73

b. Inventory Turnover = Cost of goods sold / Average inventory

For 2017 = $1,145 / ($660+$590)/2 = 1.832

For 2016 = $1,080 / ($590+$410)/2 = 2.16

c. Profit Margin = Net Income / Sales

For 2017 = $301/$4,000 = 7.525%

For 2016 = $161 / $3,660 = 4.39%

d. Return on assets = Net income / Average total assets

For 2017 = $301/($2,920+$2,790)/2 = 10.54%

For 2016 = $161/($2,790+$2,230)/2 = 6.41%

e. Return on common stockholders' equity = Net Income / Average common stockholders equity

For 2017 = $301 / ($1,220 + $1,230)/2 = 24.57%

For 2016 = $161 / ($1,230 + $980)/2 = 14.57%

f. Debt to assets ratio = Total Debt / Total assets

For 2017 = $1,700 / $2,920 = 58.21%

For 2016 = $1,560 / $2,790 = 55.91%

g. Times Interest earned = EBIT / Interest expense

For 2017 = $455 / $25 = 18.2

For 2016 = $250 / $20 = 12.5

If you have any query feel free to ask in comment section. Thanks


Related Solutions

Question 4 Your answer is partially correct. Try again. The condensed financial statements of Wildhorse Co....
Question 4 Your answer is partially correct. Try again. The condensed financial statements of Wildhorse Co. for the years 2019 and 2020 are presented below. WILDHORSE CO. Balance Sheets December 31 (in thousands) 2020 2019 Current assets    Cash and cash equivalents $330 $360    Accounts receivable (net) 550 480    Inventory 660 590    Prepaid expenses 130 160      Total current assets 1,670 1,590 Property, plant, and equipment (net) 410 380 Investments 90 90 Intangibles and other assets 530 510      Total assets $2,700 $2,570...
Problem 18-6A Partially correct answer. Your answer is partially correct. Try again. The comparative statements of...
Problem 18-6A Partially correct answer. Your answer is partially correct. Try again. The comparative statements of Corbin Company are presented below. CORBIN COMPANY Income Statement For the Years Ended December 31 2017 2016 Net sales (all on account) $600,500 $520,800 Expenses Cost of goods sold 414,600 353,300 Selling and administrative 119,900 113,000 Interest expense 7,800 6,300 Income tax expense 17,900 14,200 Total expenses 560,200 486,800 Net income $ 40,300 $ 34,000 CORBIN COMPANY Balance Sheets December 31 Assets 2017 2016...
Exercise 21-4 Partially correct answer. Your answer is partially correct. Try again. Turney Company produces and...
Exercise 21-4 Partially correct answer. Your answer is partially correct. Try again. Turney Company produces and sells automobile batteries, the heavy-duty HD-240. The 2017 sales forecast is as follows. Quarter HD-240 1 5,100 2 7,490 3 8,330 4 10,350 The January 1, 2017, inventory of HD-240 is 2,040 units. Management desires an ending inventory each quarter equal to 40% of the next quarter’s sales. Sales in the first quarter of 2018 are expected to be 25% higher than sales in...
Exercise 21-4 Partially correct answer. Your answer is partially correct. Try again. Klean Fiber Company is...
Exercise 21-4 Partially correct answer. Your answer is partially correct. Try again. Klean Fiber Company is the creator of Y-Go, a technology that weaves silver into its fabrics to kill bacteria and odor on clothing while managing heat. Y-Go has become very popular in undergarments for sports activities. Operating at capacity, the company can produce 1,048,000 Y-Go undergarments a year. The per unit and the total costs for an individual garment when the company operates at full capacity are as...
Exercise 10-4 [Partially correct answer.] Your answer is partially correct. Try again. Myers Company uses a...
Exercise 10-4 [Partially correct answer.] Your answer is partially correct. Try again. Myers Company uses a flexible budget for manufacturing overhead based on direct labor hours. Variable manufacturing overhead costs per direct labor hour are as follows. Indirect labor $1.00 Indirect materials 0.70 Utilities 0.40 Fixed overhead costs per month are Supervision $4,200, Depreciation $1,800, and Property Taxes $600. The company believes it will normally operate in a range of 7,000–13,000 direct labor hours per month. Assume that in July...
Partially correct answer. Your answer is partially correct. Try again. The actual selling expenses incurred in...
Partially correct answer. Your answer is partially correct. Try again. The actual selling expenses incurred in March 2017 by Fallon Company are as follows. Variable Expenses Fixed Expenses Sales commissions $14,228 Sales salaries $35,000 Advertising 10,086 Depreciation 7,200 Travel 8,355 Insurance 1,900 Delivery 3,422 (a) Prepare a flexible budget performance report for March, assuming that March sales were $167,100. Variable costs and their percentage relationship to sales are sales commissions 8%, advertising 6%, traveling 5%, and delivery 2%. Fixed selling...
Exercise 9-24 [Partially correct answer.] Your answer is partially correct. Try again. Culver Company began operations...
Exercise 9-24 [Partially correct answer.] Your answer is partially correct. Try again. Culver Company began operations on January 1, 2016, adopting the conventional retail inventory system. None of the company’s merchandise was marked down in 2016 and, because there was no beginning inventory, its ending inventory for 2016 of $37,300 would have been the same under either the conventional retail system or the LIFO retail system. On December 31, 2017, the store management considers adopting the LIFO retail system and...
Problem 13-3A [Partially correct answer.] Your answer is partially correct. Try again. The income statement of...
Problem 13-3A [Partially correct answer.] Your answer is partially correct. Try again. The income statement of Whitlock Company is presented here. WHITLOCK COMPANY Income Statement For the Year Ended November 30, 2017 Sales revenue $7,524,400 Cost of goods sold     Beginning inventory $1,816,200     Purchases 4,438,600     Goods available for sale 6,254,800     Ending inventory 1,364,600 Total cost of goods sold 4,890,200 Gross profit 2,634,200 Operating expenses 1,191,900 Net income $1,442,300 Additional information: 1. Accounts receivable increased $204,700 during the year, and inventory decreased...
Exercise 14-12 Partially correct answer. Your answer is partially correct. Try again. On January 2, 2012,...
Exercise 14-12 Partially correct answer. Your answer is partially correct. Try again. On January 2, 2012, Cheyenne Corporation issued $2,100,000 of 10% bonds at 97 due December 31, 2021. Interest on the bonds is payable annually each December 31. The discount on the bonds is also being amortized on a straight-line basis over the 10 years. (Straight-line is not materially different in effect from the preferable “interest method”.) The bonds are callable at 102 (i.e., at 102% of face amount),...
Your answer is partially correct. Try again. The South Division of Wiig Company reported the following...
Your answer is partially correct. Try again. The South Division of Wiig Company reported the following data for the current year. Sales $3,062,000 Variable costs 2,033,168 Controllable fixed costs 609,300 Average operating assets 5,032,600 Top management is unhappy with the investment center’s return on investment (ROI). It asks the manager of the South Division to submit plans to improve ROI in the next year. The manager believes it is feasible to consider the following independent courses of action. 1. Increase...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT