/*! This file is auto-generated */ .wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none} Q27PGA Using ratios to evaluate a stock... [FREE SOLUTION] | 91Ó°ÊÓ

91Ó°ÊÓ

Using ratios to evaluate a stock investment

Comparative financial statement data of Sanfield, Inc. follow:

SANFIELD, INC.

Comparative Income Statement

Years Ended December 31, 2018, and 2017

2018

2017

Net Sales Revenue

\( 462,000

\) 430,000

Cost of Goods Sold

236,000

213,000

Gross Profit

226,000

217,000

Operating Expense

135,000

133,000

Income from Operations

91,000

84,000

Interest Expense

8,000

12,000

Income Before Income Tax

83,000

72,000

Income Tax Expense

18,000

22,000

Net Income

\( 65,000

\) 50,000

SANFIELD, INC.

Comparative Balance Sheet

December 31, 2018, and 2017

2018

2017

2016

Asset

Current Assets:

Cash

\( 99,000

\) 97,000

Accounts Receivable, Net

109,000

117,000

\( 100,000

Merchandise Inventory

142,000

164,000

207,000

Prepaid Expenses

15,000

5,000

Total Current Assets

365,000

383,000

Property, Plant, and Equipment, Net

215,000

177,000

Total Assets

\) 580,000

\( 560,000

\) 599,000

Liabilities

Total Current Liabilities

\( 222,000

\) 244,000

Long-term Liabilities

113,000

92,000

Total Liabilities

335,000

336,000

Stockholders’ Equity

Preferred Stock, 4%

92,000

92,000

Common Stockholders’ Equity, no par

153,000

132,000

85,000

Total Liabilities and Stockholders’ Equity

\( 580,000

\) 560,000

1. Market price of Sanfield’s common stock: \(51.48 at December 31, 2018, and \)37.08 at December 31, 2017.

2. Common shares outstanding: 16,000 on December 31, 2018 and 15,000 on December 31, 2017 and 2016.

3. All sales are on credit.

Requirements

1. Compute the following ratios for 2018 and 2017:

  1. Current ratio
  2. Cash ratio
  3. Times-interest-earned ratio
  4. Inventory turnover
  5. Gross profit percentage
  6. Debt to equity ratio
  7. Rate of return on common stockholders’ equity
  8. Earnings per share of common stock
  9. Price/earnings ratio

2. Decide (a) whether Sanfield’s ability to pay debts and sell inventory improved or deteriorated during 2018 and (b) whether the investment attractiveness of its common stock appears to have increased or decreased.

Short Answer

Expert verified

S. no.

2018

2017

1

a.

1.64

1.57

b.

0.45

0.39

c.

11.38

7.00

d.

1.54

1.15

e.

48.9%

50.5%

f.

1.37

1.50

g.

43.0%

42.7%

h.

$3.96

$3.09

i.

13.0

12.0

2

a.The company's capacity to sell inventory increased as the inventory turnover improved.
b.The desirability of Sanfield's stock increased in 2018.

Step by step solution

01

Meaning of Ratio Analysis

Ratio analysis is a fundamental approach to assessing a company's health by examining the relationships between key financial indicators. According to many analysts, ratio analysis is the most critical aspect of the analytical process.

02

(1) Computing ratios

a).Current ratio

2018

Current ratio=Total current assetTotal current liabilities=$365,000$222,000=1.64

2017

Current ratio=Total current assetTotal current liabilities=$383,000$244,000=1.57

b) Cash ratio

2018

Cash ratio=Cash+Cash equivalentTotal current liabilities=$99,000+$0$222,000=0.45
2017

Cash ratio=Cash+Cash equivalentTotal current liabilities=$97,000+$0$244,000=0.39

c)Times interest earned ratio

2018

Times interest earned ratio=Net Income+Income tax expense+Interest​â¶Ä„expenseInterest expense=$65,000+$18,000+$8,000$8,000=11.38

2017

Times interest earned ratio=Net Income+Income tax expense+Interest​â¶Ä„expenseInterest expense=$50,000+$22,000+$12,000$12,000=7.00

d) Inventory turnover ratio

2018

Inventory turnover ratio=Cost of goods soldAverage merchandise Inventory=$236,000$142,000+$164,0002=1.54

2017

Inventory turnover ratio=Cost of goods soldAverage merchandise Inventory=$213,000$164,000+$207,0002=1.15

e) Gross profit percentage

2018

Grossprofitpercentage=Gross profitNet sales revenue=$226,000$462,000=48.9%

2017

Grossprofitpercentage=Gross profitNet sales revenue=$217,000$430,000=50.5%

f) Debt to equity ratio

2018

Debttoequityratio=Total liabilitiesTotal equity=$335,000$245,000=1.37

2017

Debttoequityratio=Total liabilitiesTotal equity=$336,000$224,000=1.50

g) Rate of return on common stockholder’s equity

2018

Returnoncommonstockholder'sequity=Net income−Preferred dividendsAverage common stockholder's equity=$65,000−4%×$92,000$153,000+$132,0002=$65,000−$3,680142,500=43%

2017

 Return on common stockholder's equity=Net income−Preferred dividendsAverage common stockholder's equity=$50,000−4%×$92,000$132,000+$85,0002=$50,000−$3,680$108,500=42.7%

h) Earnings per share of common stock

2018

Earningpershareofcommonstock=Net income−Preferred dividendWeighted average number of common share of common stock=$65,000−$3,86016,000+15,0002=$3.96

2017

Earningpershareofcommonstock=Net income−Preferred dividendWeighted average number of common share of common stock=$50,000−$3,86015,000=$3.09

i) Price/earnings ratio

2018

Price/Earning ratio=Market price per share of common stockEarnings per share=$51.48$3.96=13.0

2017

Price/Earning ratio=Market price per share of common stockEarnings per share=$37.08$3.09=12.0

03

(2) Explaining the situation of Sanfield’s

  1. Compared to 2017, Sanfield is better positioned to pay off the debt in 2018. The times-interest-earned ratio, cash ratio, and current ratio all increased. The company's capacity to sell inventory increased as the inventory turnover improved.
  2. 2018 has seen an improvement in Sanfield's stock's appeal. The earnings per share and price/earnings ratio increased with the rate of return on common stockholders' equity.

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with 91Ó°ÊÓ!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

Measuring ability to pay liabilities

Requirements

1. Compute the debt ratio and the debt-to-equity ratio at May 31, 2018, for Accel’s

Companies.

2. Is Accel’s ability to pay its liabilities strong or weak? Explain your reasoning.

Preparing common-size income statements

Refer to the data presented for Mulberry Designs, Inc. in Exercise E15-13.

Requirements

1. Prepare a comparative common-size income statement for Mulberry Designs,

Inc. using the 2018 and 2017 data. Round percentages to one-tenth percent (three

decimal places).

2. To an investor, how does 2018 compare with 2017? Explain your reasoning.

Theta Designs, Inc. has the following data:

Theta Designs INC
Vertical Analysis
For the year ended December 31, 2017, and 2018

Assets

2018 (\()

2017 (\))

Total current assets

25,000

73,440

Property, Plant and Equipment, Net

153,600

168,300

Other Assets

21,400

64,260

Total Assets

200,000

306,000

Liabilities

Total current liabilities

27,600

49,266

Long term debt

72,400

208,998

Total Liabilities

100,000

258,264

Stockholders’ Equity

Total stockholders’ Equity

100,000

47,736

Total liabilities and stockholders’ equity

200,000

306,000

Perform a vertical analysis of Theta Designs’s balance sheet for each year.

The Klein Department Stores, Inc. chief executive officer (CEO) has asked you tocompare the company’s profit performance and financial position with the averages for the industry. The CEO has given you the company’s income statement and balance sheet as well as the industry average data for retailers.

Requirements

1.Prepare a vertical analysis for Klein for both its income statement and balance sheet.

2.Compare the company’s profit performance and financial position with the averagefor the industry.

Question: P15-38 Using ratios to evaluate a stock investment

This problem continues the Canyon Canoe Company situation from Chapter 14. The company wants to invest some of its excess cash in trading securities and is considering two investments, The Paddle Company (PC) and Recreational Life Vests (RLV). The income statement, balance sheet, and other data for both companies follow for 2019 and 2018, as well as selected data for 2017:


THE PADDLE COMPANY

Comparative Financial Statements

Years Ended December 31


RECREATIONAL LIFE VESTS
Comparative Financial Statements
Years Ended December 31

Income statement

2019

2018

2017

2019

2018

2017

Net sales revenue

\(430,489

\)425,410

\(410,570

\)383,870

Cost of goods sold

258,756

256,797

299,110

280,190

Gross profit

171,733

168,613

111,460

103,680

Operating expenses

153,880

151,922

78,290

70,830

Operating income

17,853

16,691

33,170

32,850

Interest expenses

865

788

2,780

2,980

Income before income tax

16,988

15,903

30,390

29,870

Income tax expenses

5,137

4,809

8,780

8,630

Net income

\(11,851

\)11,094

\(21,610

\)21,240

Balance sheet

Assets

Cash & Cash Equivalents

\(69,159

\)70,793

\(65,730

\)55,270

Accounts Receivable

44,798

44,452

\(44,104

39,810

38,650

\)36,460

Merchandise Inventory

79,919

66,341

76,363

68,500

65,230

59,930

Other Current Assets

15,494

16,264

24,450

37,630

Total Current Assets

209,370

197,850

198,490

196,780

Long-term Assets

89,834

90,776

116,760

116,270

Total Assets

\(299,204

\)288,626

\(276,482

\)315,250

$$313,050

\(310,640

Liabilities

Current Liabilities

\)69,554

\(60,232

\)90,810

\(90,010

Long-term Liabilities

31,682

29,936

96,310

105,890

Total Liabilities

101,236

90,168

187,120

195,900

Stockholders’ Equity

Common Stock

72,795

80,885

111,530

102,480

Retained Earnings

125,173

117,573

16,600

14,670

Total Stockholders’ Equity

197,968

198,458

128,130

117,150

103,840

Total Liabilities and Stockholder’s Equity

\)299,204

\(288,626

\)315,250

\(313,050

Other data

Market price per share

\)21.38

\(33.82

\)46.37

$51.64

Annual dividend per share

0.32

0.30

0.53

0.45

Weighted average number of shares outstanding

9,000

8,000

9,000

8,000

Requirements

  1. Using the financial statements given, compute the following ratios for both companies for 2019 and 2018. Assume all sales are credit sales. Round all ratios to two decimal places.
  2. a. Current ratio

    h. Profit margin ratio

    b. Cash ratio

    i. Asset turnover ratio

    c. Inventory turnover

    j. Rate of return on common stockholders’ equity

    d. Accounts receivable turnover

    k. Earnings per share

    e. Gross profit percentage

    l. Price/earnings ratio

    f. Debt ratio

    m. Dividend yield

    g. Debt to equity ratio

    n. Dividend payout

  1. Compare the companies’ performance for 2019 and 2018. Make a recommendation to Canyon Canoe Company about investing in these companies. Which company would be a better investment, The Paddle Company or Recreational Life Vests? Base your answer on the ability to pay current liabilities, ability to sell merchandise and collect receivables, ability to pay the long-term debt, profitability, and attractiveness as an investment.
See all solutions

Recommended explanations on Business Studies Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.