Question: 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 All Digital Corp. and Green Zone, Inc. and have assembled the following data.

Selected income statement data for the current year:

All digital

Green Zone

Net sales revenue (all on credit)

\(417,925

\)493,115

Cost of goods sold

209,000

258,000

Interest expenses

0

14,000

Net income

58,000

72,000

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

All digital

Green Zone

Current assets:

Cash

\(23,000

\)18,000

Short-term investment

37,000

17,000

Accounts receivables, Net

39,000

49,000

Merchandise inventory

64,000

102,000

Prepaid expenses

21,000

17,000

Total current assets

\(184,000

\)203,000

Total assets

\(263,000

\)326,000

Total current liabilities

105,000

99,000

Total liabilities

105,000

134,000

Common stock:

\(1 par (10,000 shares)

10,000

\)2 par (14,000 shares)

28,000

Total stockholder’s equity

158,000

192,000

Market price per share of common stock

92.80

128.50

Dividend paid per common share

1.20

0.90

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

All digital

Green Zone

Balance sheet:

Accounts receivables, Net

\(41,000

\)54,000

Merchandise inventory

81,000

89,000

Total assets

258,000

277,000

Common stock:

\(1 par (10,000 shares)

10,000

\)2 par (14,000 shares)

28,000

Your strategy is to invest in companies with low price/earnings ratios but in good financial shape. 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

Answer

  1. Financial ratios:

    Financial ratio

    All digital

    Green Zone

    Acid test ratio

    0.94

    0.85

    Inventory turnover ratio

    2.88

    2.70

    Days’ sales in receivables

    35

    38

    Debt ratio

    0.40

    0.41

    Earnings per share

    $5.8

    $5.14

    Price/earnings ratio

    16

    25

    Dividend payout ratio

    20.69$

    17.51%


  2. The appropriate investment will be All digital.

Step by step solution

01

Definition of Financial Ratios

Financial ratios refer to the calculations between the various line items of the financial statement to arrive at a conclusive decision regarding liquidity, solvency, and profitability.

02

Calculation of financial ratios

a.Acidtestratio:Alldigital:Acid-testratio=Cashandcashequivalents+Shortterminvestments+NetreceivablesTotalcurrentliabilities=$23,000+$37,000+$39,000$105,000=$99,000$105,000=0.94Greenzone:Acid-testratio=Cashandcashequivalents+Shortterminvestments+NetreceivablesTotalcurrentliabilities=$18,000+$17,000+$49,000$99,000=$84,000$99,000=0.85

b.Inventoryturnoverratio:Alldigital:Inventoryturnoverratio=CostofgoodssoldAveragemerchandiseinventory=$209,000$64,000+$81,0002=$209,000$72,500=2.88Greenzone:Inventoryturnoverratio=CostofgoodssoldAveragemerchandiseinventory=$258,000$102,000+$89,0002=$258,000$95,500=2.70c..Days’salesinreceivables:Alldigital:Dayssalesinreceivables=365Accountsreceivablesturnoverratio=36510.45=35daysWorkingnote:Greenzone:Accountsreceivablesturnoverratio=NetcreditsalesAverageaccountsreceivables=$417,925$39,000+$41,0002=$417,925$40,000=10.45

d.Debtratio:Alldigital:Greenzone:Dayssalesinreceivables=365Accountsreceivablesturnoverratio=3659.57=38daysWorkingnote:Accountsreceivablesturnoverratio=NetcreditsalesAverageaccountsreceivables=$493,115$49,000+$54,0002=$493,115$51,500=9.57e.EarningspershareofcommonstockAlldigital:Debtratio=TotalliabilitiesTotalassets=$105,000$263,000=0.40GreenZone:Debtratio=TotalliabilitiesTotalassets=$134,000$326,000=0.41

f.Price/earningsratio:Alldigital:Earningspershare=Netincome-PreferreddividendWeightedaveragesharesoutstanding=$58,000-$010,000=$5.8pershareGreenZone:Earningspershare=Netincome-PreferreddividendWeightedaveragesharesoutstanding=$72,000-$014,000=$5.14pershareg.Dividendpayout:Alldigital:Price/earningsratio=MarketpricepershareEarningspershare=$92.80$5.8=16GreenZone:Dividendpayoutratio=AnnualdividendpershareEarningspershare×100=$0.90$5.14×100=17.51%

03

Appropriate investment according to financial ratios

The investor must invest in All digital investments because it generates a higher pay-pay-out ratio and earnings per share. Also, this company can recover the cash receivable earlier than Green Zone.

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

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.

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.

Data for Mulberry Designs, Inc. follow:


Requirements

1. Prepare a horizontal analysis of the comparative income statement of Mulberry

Designs, Inc. Round percentage changes to one decimal place.

2. Why did 2018 net income increase by a higher percentage than net sales

revenue?

Moss Exports is having a bad year. Net income is only \(60,000. Also, two important overseas customers are falling behind in their payments to Moss, and Moss’s accounts receivable are ballooning. The company desperately needs a loan. The Moss Exports Board of Directors is considering ways to put the best face on the company’s financial statements. Moss’s bank closely examines cash flow from operating activities. Daniel Peavey, Moss’s controller, suggests reclassifying the receivables from the slow-paying clients as long-term. He explains to the board that removing the \)80,000 increase in accounts receivable from current assets will increase net cash provided by operations. This approach may help Moss get the loan.

Requirements

1. Using only the amounts given, compute net cash provided by operations, both without and with the reclassification of the receivables. Which reporting makes Moss look better?

2. Under what condition would the reclassification of the receivables be ethical? Unethical?

Question: What is vertical analysis? What item is used as the base for the income statement? What item is used as the base for the balance sheet?

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