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

Using ratios to decide between two stock investments

Assume that you are purchasing an investment and have decided to invest in a company in the digital phone business. You have narrowed the choice to Digitalized Corp. and Every Zone, Inc. and have assembled the following data.

Selected income statement data for the current year:

Digitalized

Every Zone

Net sales revenue (all on credit)

\(423,035

\)493,845

Cost of goods sold

210,000

260,000

Interest expenses

0

19,000

Net income

51,000

72,000

Selected balance sheet and market price data at the end of the current year:

Digitalized

Every Zone

Current assets:

Cash

\(24,000

\)17,000

Short-term investment

40,000

14,000

Accounts receivables, Net

40,000

48,000

Merchandise inventory

66,000

97,000

Prepaid expenses

23,000

12,000

Total current assets

\(193,000

\)188,000

Total assets

266,000

323,000

Total current liabilities

105,000

96,000

Total liabilities

105,000

128,000

Common stock

\(1 par (12,000 shares)

12,000

\)1 par (17,000 shares)

17,000

Total stockholders equity

161,000

195,000

Market price per share of common stock

76.50

114.48

Dividend paid per common stock

1.10

1.00

Selected balance sheet data at the beginning of the current year:

Digitalized

Every Zone

Balance sheet:

Accounts Receivable, net

\(41,000

\)54,000

Merchandise Inventory

81,000

87,000

Total Assets

261,000

272,000

Common Stock:

\(1 par (12,000 shares)

12,000

\)1 par (17,000 shares)

17,000

Your strategy is to invest in companies that have low price/earnings ratios but appear to be in good shape financially. Assume that you have analyzed all other factors and that your decision depends on the results of ratio analysis.

Requirements

  1. Compute the following ratios for both companies for the current year:

a. Acid-test ratio

b. Inventory turnover

c. Days’ sales in receivables

d. Debt ratio

e. Earnings per share of common stock

f. Price/earnings ratio

g. Dividend payout

2. Decide which company’s stock better fits your investment strategy.

Short Answer

Expert verified
  1. Financial ratios:

Ratio

Digitalized

Every Zone

Acid test ratio

0.99

0.82

Inventory turnover

2.85

2.82

Days sales in receivables

35

38

Debt ratio

0.39

0.40

Earnings per share

$4.25

$4.23

Price-earnings ratio

18

27.06

Dividend payout ratio

0.2588

0.2364

2. The investment must be made in the Digitalized corporation.

Step by step solution

01

Definition of Financial Ratios

The figures that are calculated by comparing various line items of the financial statement to arrive at a conclusive decision regarding liquidity, solvency, and profitability are known as financial ratios.

02

Calculation of financial ratios:

  1. Acid test ratio:

Digitalized:

Acid-testratio=Cashandcashequivalents+Shortterminvestments+NetreceivablesTotalcurrentliabilities=$24,000+$40,000+$40,000$105,000=0.99

Every Zone:

Acid-testratio=Cashandcashequivalents+Shortterminvestments+NetreceivablesTotalcurrentliabilities=$17,000+$14,000+$48,000$96,000=0.82

b. Inventory turnover ratio:


Digitalized:

Inventoryturnoverratio=CostofgoodssoldAveragemerchandiseinventory=$210,000$81,000+$66,0002=$210,000$73,500=2.85


Every Zone:

Inventoryturnoverratio=CostofgoodssoldAveragemerchandiseinventory=$260,000$97,000+$87,0002=$260,000$92,000=2.82

c. Days’ sales in receivables:


Digitalized:

Dayssalesinreceivables=365Accountsreceivablesturnoverratio=36510.44=35days

Working note:

Accountsreceivableturnover=NetsalesAverageaccountsreceivables=$423,035$40,000+$41,0002=10.44

Every Zone:

Dayssalesinreceivables=365Accountsreceivablesturnoverratio=3659.68=38days

Working note:

Accountsreceivableturnover=NetsalesAverageaccountsreceivables=$493,845$48,000+$54,0002=9.68

d. Debt ratio:

Digitalized:

Debtratio=TotalliabilitiesTotalassets=$105,000$266,000=0.39

Every Zone:

Debtratio=TotalliabilitiesTotalassets=$128,000$323,000=0.40

e. Earnings per share of common stock:


Digitalized:

Earningspershareofcommonstock=Netincome-PreferreddividendWeightedaveragecommonsharesoutstanding=$51,000-$012,000=$4.25pershare

Every Zone:

Earningspershareofcommonstock=Netincome-PreferreddividendWeightedaveragecommonsharesoutstanding=$72,000-$017,000=$4.23pershare

f. Price/earnings ratio:


Digitalized:

Priceearningsratio=MarketpricepershareofcommonstockEarningspershare=$76.50$4.25=18

Every Zone:

Priceearningsratio=MarketpricepershareofcommonstockEarningspershare=$114.48$4.23=27.06

g. Dividend payout:


Digitalized:

Dividendpayoutratio=DividendpershareEarningspershare=$1.10$4.25=0.2588



Every Zone:


Dividendpayoutratio=DividendpershareEarningspershare=$1$4.23=0.2364

03

Investment Decision

The business entity must invest in the digitalized corporation because this corporation is having lower price earnings ratio and is financially strong as all other ratios are reflecting efficiency in the operation as compared to Every Zone corporation.

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

Big Beautiful Photo Shop has asked you to determine whether the company’s ability to pay current liabilities and total liabilities improved or deteriorated during 2018. To answer this question, you gather the following data:

2018

2017

Cash

\(58,000

\)47,000

Short-term Investments

34,000

0

Net Accounts Receivable

140,000

124,000

Merchandise Inventory

217,000

272,000

Total Assets

530,000

565,000

Total Current Liabilities

288,000

205,000

Long-term Notes Payable

40,000

50,000

Income from Operations

165,000

158,000

Interest Expense

55,000

41,000

Compute the following ratios for 2018 and 2017, and evaluate the company’s ability to pay its current liabilities and total liabilities:

a. Current ratio

b. Cash ratio

c. Acid-test ratio

d. Debt ratio

e. Debt to equity ratio

Determining the effects of business transactions on selected ratios Financial statement data of Style Traveler Magazine include the following items:

Cash

\( 23,000

Accounts Receivable, Net

81,000

Merchandise Inventory

185,000

Total Assets

635,000

Accounts Payable

99,000

Accrued Liabilities

37,000

Short-term Notes Payable

51,000

Long-term Liabilities

224,000

Net Income

68,000

Common Shares Outstanding

20,000 shares

Requirements

  1. Compute Style Traveler’s current ratio, debt ratio, and earnings per share. Round all ratios to two decimal places, and use the following format for your answer:

Current Ratio Debt Ratio Earnings per Share

2.Compute the three ratios after evaluating the effect of each transaction that follows. Consider each transaction separately

  1. Purchased merchandise inventory of \)49,000 on the account.
  2. Borrowed \(127,000 on a long-term note payable.
  3. Issued 2,000 shares of common stock, receiving cash of \)107,000.
  4. Received cash on account, $5,000.

Completing a comprehensive financial statement analysis

In its annual report, ABC Athletic Supply, Inc. includes the following five-year financial summary:

ABC ATHLETIC SUPPLY, INC.
Five-Year Financial Summary (Partial; adapted)

(Dollar amounts in thousands except per share data)

2018

2017

2016

2015

2014

2013

Net Sales Revenue

\(250,000

\)216,000

\(191,000

\)161,000

\(134,000

Net Sales Revenue Increase

16%

13%

19%

20%

17%

Domestic Comparative Store Sales Increase

5%

6%

4%

7%

9%

Other Income—Net

2,110

1,840

1,760

1,690

1,330

Cost of Goods Sold

189,250

164,592

148,216

126,385

106,396

Selling and Administrative Expenses

41,210

36,330

31,620

27,440

22,540

Interest:

Interest Expense

(1,080)

(1,380)

(1,400)

(1,020)

(830)

Interest Income

125

165

155

235

190

Income Tax Expense

4,470

3,900

3,700

3,320

2,700

Net Income

16,225

11,803

7,979

4,760

3,054

Per Share of Common Stock:

Net Income

1.60

1.30

1.20

1.00

0.78

Dividends

0.40

0.38

0.34

0.30

0.26

Financial Position

Current Assets, Excluding Merchandise Inventory

\)30,700

\(27,200

\)26,700

\(24,400

\)21,500

Merchandise Inventory

24,500

22,600

21,700

19,000

17,500

$16,700

Property, Plant, and Equipment, Net

51,400

45,200

40,000

35,100

25,600

Total Assets

106,600

95,000

88,400

78,500

64,600

Current Liabilities

32,300

28,000

28,300

25,000

16,500

Long-term Debt

23,000

21,500

17,600

19,100

12,000

Stockholders’ Equity

51,300

45,500

42,500

34,400

36,100

Financial Ratios

Acid-Test Ratio

1.0

1.0

0.9

1.0

1.3

Rate of Return on Total Assets

17.2%

14.4%

11.2%

8.1%

7.1%

Rate of Return on Common Stockholders’ Equity

35.5%

26.%

20.8%

13.5%

13.0%

Requirements

Analyze the company’s financial summary for the fiscal years 2014–2018 to decide whether to invest in the common stock of ABC. Include the following sections in your analysis.

  1. Trend analysis for net sales revenue and net income (use 2014 as the base year).
  2. Profitability analysis.
  3. Evaluation of the ability to sell merchandise inventory.
  4. Evaluation of the ability to pay debts.
  5. Evaluation of dividends.
  6. Should you invest in the common stock of ABC Athletic Supply, Inc.? Fully explain your final decision

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.

Question:Theater by Design and Show Cinemas are asking you to recommend their stock to your clients. Because Theater by Design and Show Cinemas earn about the same net income and have similar financial positions, your decision depends on their statement of cash flows, summarized as follows:

Theater by Design Show Cinemas

Net Cash Provided by Operating Activities \( 30,000 \) 70,000

Cash Provided by (Used for) Investing Activities:

Purchase of Plant Assets \( (20,000) \) (100,000)

Sale of Plant Assets 40,000 20,000 10,000 (90,000)

Cash Provided by (Used for) Financing Activities:

Issuance of Common Stock 0 30,000

Payment of Long-term Debt (40,000) 0

Net Increase (Decrease) in Cash \( 10,000 \) 10,000

Based on their cash flows, which company looks better? Give your reasons.

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