Warning: foreach() argument must be of type array|object, bool given in /var/www/html/web/app/themes/studypress-core-theme/template-parts/header/mobile-offcanvas.php on line 20

Data for Oxford State Bank follow:


2018

2017

Net Income

\(71,900

\)64,300

Dividends—Common

22,000

22,000

Dividends—Preferred

16,800

16,800

Total Stockholders’ Equity at Year-End (includes 95,000 shares of common stock)

770,000

610,000


Net Income

\( 71,900

\) 64,300

Market Price per Share of Common Stock

\( 16.50

\) 10.00


Evaluate the common stock of Oxford State Bank as an investment. Specifically,

use the three stock ratios to determine whether the common stock has increased or decreased in attractiveness during the past year. Round to two decimal places.

Short Answer

Expert verified

Answer

The analysis of three stock ratio indicates that attractiveness of common stock of the company has increased because EPS increased from 0.50 to 0.58, Price earnings ratio increased from 20.00 to 28.45 from year 2017 to 2018.

Step by step solution

01

Calculation of EPS & PER

Earnings Per Share = Net Income- Preferred Dividend/ Common Share Outstanding

For 2018

EPS = $71,900-16,800/95,000

= $0.58

For 2017

EPS= $64,300-16,800/95,000

=$0.50

Price-Earnings Ratio= Market Price per share of common stock/ EPS

For 2018

PER = $16.50/$0.58

=28.45

For 2017

PER= $10.00/0.50

=20.00

02

Calculate Dividend Yield Ratio

Dividend Yield Ratio = Annual Dividend per share/ Market price per share

For 2018

Annual dividend for share =Total Dividend Paid / Common Share Outstanding

= $22,000/95,000

=0.23

So, Dividend yield Ratio = $0.23/16.50

=1.40%

For 2017

Annual dividend for share = $22,000/95,000

=0.23

So, Dividend Yield Ratio= $0.23/10.00

=2.3%

03

Calculate dividend payout ratio

Dividend Pay- out Ratio = Annual Dividend per share/ EPS

For 2018

Dividend Pay- out =$0.23/ 0.58

=39.65%

For 2017

Dividend pay- out = $0.23/0.50

=46%

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 Vaia!

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

Computing inventory, gross profit, and receivables ratios

Requirements

1. Compute the inventory turnover, days’ sales in inventory, and gross profit

percentage for Accel’s Companies for 2018.

2. Compute days’ sales in receivables during 2018. Round intermediate calculations to

three decimal places. Assume all sales were on account.

3. What do these ratios say about Accel’s Companies’ ability to sell inventory and

collect receivables?

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.

The Randall Department Stores, Inc. chief executive officer (CEO) has asked you to compare 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.

RANDALL DEPARTMENT STORES, INC.

Income Statement Compared with Industry Average

Year Ended December 31, 2018

Randall

Industry Average

Net Sales Revenue

\( 783,000

100.0%

Cost of Goods Sold

527,742

65.8

Gross Profit

255,258

34.2

Operating Expenses

163,647

19.7

Operating Income

91,611

14.5

Other Expenses

6,264

0.4

Net Income

\) 85,347

14.1%

RANDALL DEPARTMENT STORES, INC.

Balance Sheet Compared with Industry Average

December 31, 2018

Randall

Industry Average

Current Assets

\( 310,040

70.9%

Property, Plant, and Equipment, Net

119,600

23.6

Intangible Assets, Net

7,360

0.8

Other Assets

23,000

4.7

Total Assets

\) 460,000

100.0%

Current Liabilities

\( 210,680

48.1%

Long-term Liabilities

103,960

16.6

Total Liabilities

314,640

64.7

Stockholders’ Equity

145,360

35.3

Total Liabilities and Stockholders’ Equity

\) 460,000

100.0%

Requirements

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

Compare the company’s profit performance and financial position with the average for the industry

Muscateer Corp. reported the following revenues and net income amounts:

(In millions)2019 2018 2017 2016

Revenue \( 9,610 \) 9,355 \( 9,050 \) 8,950

Net Income 7,290 6,790 5,020 4,300

Requirements

1. Calculate Muscateer’s trend analysis for revenues and net income. Use 2016 as the

base year, and round to the nearest percent.

2. Which measure increased at a higher rate during 2017–2019?

Describe a common-size statement and how it might be helpful in evaluating a company.

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.

Sign-up for free