Question

In: Accounting

Assume that you are considering purchasing stock as an investment. You have narrowed the choice to...

Assume that you are considering purchasing stock as an investment. You have narrowed the choice to either Verge Corporation stock or Express Company stock and have assembled the following data for the two companies.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.

Selected income statement data for the current​ year:

  

Verge

Express

Net sales (all on credit). . . . . . . . . . . . . . . .

$599,000

$527,000

Cost of goods sold. . . . . . . . . . . . . . . . . . . .

458,000

382,000

Income from operations. . . . . . . . . . . . . . .

91,000

69,000

Interest expense. . . . . . . . . . . . . . . . . . . . .

10,000

Net income. . . . . . . . . . . . . . . . . . . . . . . . . .

70,000

34,000

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

  

Verge

Express

Current assets:

Cash. . . . . . . . . . . . . . . . . . . . . . .

$28,000

$38,000

Short-term investments. . . . . . . . . .

7,000

13,000

Current receivables, net. . . . . . . . . . .

189,000

168,000

Inventories. . . . . . . . . . . . . . . . . . . . . .

219,000

190,000

Prepaid expenses. . . . . . . . . . . . . . . .

18,000

12,000

Total current assets. . . . . . . . . . . . . . .

461,000

421,000

Total assets. . . . . . . . . . . . . . . . . . . . . . . . . . .

975,000

936,000

Total current liabilities. . . . . . . . . . . . . . . . .

364,000

340,000

Total liabilities. . . . . . . . . . . . . . . . . . . . . . . . .

666,000

693,000

Preferred stock, 9%, $150 par. . . . . . . . . . . .

30,000

Common stock, $1 par (115,000 shares). . . .

115,000

$5 par (10,000 shares)

50,000

Total stockholders' equity. . . . . . . . . . . . . . . .

309,000

243,000

Market price per share of common stock. . . .

$7.32

$65.73

Selected balance sheet data at beginning of current​ year:

  

Verge

Express

Balance sheet:

Current receivables, net. . . . . . . . . . . . . . . . .

$146,000

$192,000

Inventories. . . . . . . . . . . . . . . . . . . . . . . . . . . .

205,000

193,000

Total assets. . . . . . . . . . . . . . . . . . . . . . . . . . .

852,000

914,000

Long-term debt. . . . . . . . . . . . . . . . . . . . . . . .

311,000

Preferred stock, 9%, $150 par. . . . . . . . . . . .

30,000

Common stock, $1 par (115,000 shares). . . .

115,000

$5 par (10,000 shares)

50,000

Total stockholders' equity. . . . . . . . . . . . . . . .

265,000

219,000

1.

Compute the following ratios for both companies for the current​year, and decide which​ company's stock better fits your investment strategy.

a.

Quick​ (acid-test) ratio

b.

Inventory turnover

c.

​Days' sales in average receivables

d.

Debt ratio

e.

​Times-interest-earned ratio

f.

Return on common​ stockholders' equity

g.

Earnings per share of common stock

h.

​Price-earnings ratio

Requirement 1. Compute the ratios for both companies for the current year and decide which​ company's stock better fits your investment strategy.
Begin by computing the​ ratios, starting with the quick​(acid-test) ratio. ​(Abbreviations used: Avg.​ = average,​ Cash* = cash and cash​ equivalents, Mkt​ = market,​ o/s =​ outstanding, SE​= stockholders'​ equity, and ST​ = short-term.)
a. Quick​ (acid-test) ratio
Select the formula and then enter the amounts to calculate the quick​ (acid-test) ratios. ​(Round the ratios to two decimal​places, X.XX.)

(

+

+

) /

=
Quick ratio
Verge
(

+

+

) /

=

Express
(

+

+

) /

=


b. Inventory turnover
Select the formula and then enter the amounts to calculate the inventory turnover for each company. ​(Round the ratios to two decimal​ places, X.XX.)


/

=
Inventory turnover
Verge

/

=

Express

/

=


c.​ Days' sales in average receivables
Select the formula and then enter the amounts to calculate​ days' sales in average receivables for each company. ​(Use a​ 365-day year. Round intermediary calculations to the nearest whole​ number, X. Round your final answers to one decimal​ place, X.X.)


/

=
Days' sales in average receivables
Verge

/

=

Express

/

=


d. Debt ratio
Select the formula and then enter the amounts to calculate the debt ratio for each company. ​(Enter the debt ratio in decimal form to two decimal​ places, X.XX.)


/

=
Debt ratio
Verge

/

=

Express

/

=


e. ​Times-interest-earned ratio
Select the formula and then enter the amounts to calculate the​times-interest-earned ratio for Express. ​(Round the ratio to one decimal​ place, X.X.)


/

=
Times-interest-earned ratio
Express

/

=


f. Return on common​ stockholders' equity
Select the formula and then enter the amounts to calculate the return on common​ stockholders' equity​ (ROE) for each company.​(Complete all answer boxes. If an account has a zero​ balance, enter a​ "0". Enter the ROE as a percentage rounded to the nearest​one-tenth percent,​ X.X%.)

(

-

) /

=
ROE
Verge
(

-

) /

=

%
Express
(

-

) /

=

%

g. Earnings per share of common stock
Select the formula and then enter the amounts to calculate earnings per share​ (EPS) for each company. ​(Complete all answer boxes. If an account has a zero​ balance, enter a​ "0". Round EPS to two decimal​ places, X.XX.)

(

-

) /

=
EPS
Verge
(

-

) /

=

Express
(

-

) /

=


h.​ Price-earnings ratio
Select the formula and then enter the amounts to calculate the​price-earnings (P/E) ratio for each company. ​(Enter amounts in the formula to two decimal​ places, X.XX, but then round the​ P/E ratios to one decimal​ place, X.X, as​ needed.)


/

=
P/E ratio
Verge

/

=

Express

/

=


Which​ company's stock better fits your investment​ strategy?

The common stock of

Express Company

Verge Corporation

seems to fit the investment strategy better. Its​ price-earnings ratio is

higher than that of Express Company

higher than that of Verge Corporation

lower than that of Express Company

lower than that of Verge Corporation

​,

and

Express Company appears to be in slightly better shape than Verge Corporation

Verge Corporation appears to be in slightly better shape than Express Company

.

Solutions

Expert Solution

1-QUICK(ACID TEST ) RATIO: Current assets, loans &advances - inventories/ Current liability  

verge: 461000- 219000/ 364000 = .67

express: 421000-190000/ 340000 = .68

2-INVENTORY TURNOVER RATIO; Cost of goods sold or sales / average inventory

average inventory;  opening + closing /2

verge; 219000 + 205000 / 2 = 212000

express; 190000+193000 /2 = 191500

ITR

; VERGE = 458000 / 212000 =2.16

EXPRESS=382000/ 191500 =1.99

3-DAYS SALES IN AVERAGE RECEIVABLES;  average receivables/ credit sales × 365

average receivables; opening+ closing/2

verge; 146000+189000/2= 167500

express; 192000+168000/2= 180000

Here all sales are in credit

ratio;

verge; 167500/599000 ×365 = 102.06

express; 180000/ 527000 × 365 = 124.67

DEBT RATIO; Total liabilities/ total assets

verge; 666000/975000 =.683

express; 693000/936000 =.740

TIMES INTEREST EARNED RATIO; EBIT/ Interst expense

verge; 70000/0= 0

express; 34000+10000/10000= 4.4

RETURN ON STOCKHOLDERS EQUITY; Net income/ share holders equity

verge; 70000/309000= .23

express; 34000/243000=.14

EPS OF COMMON STOCK; Earning available for equity shareholders/ outstanding equity shares

verge; net income-preference dividend/ ouststanding equity share

70000-0/ 115000=.609

express; 34000-27000/10000=.70

PRICE EARNING RATIO; Market price per share/ earning per share

verge; 1/.609=1.642

express; 5/.7 =7.14

interpretation;

NOTE; Higher P/E ratio means investors are paying higher price for the stock as compared to its earnings.

The common stock of verge corp. seems to fit the investment strategy better, its price earning ratio lower than that of express company and verge corp appears to be slightly better shape than express company.


Related Solutions

Suppose you are considering purchasing a new car. You and your spouse have narrowed it down...
Suppose you are considering purchasing a new car. You and your spouse have narrowed it down to two choices: a. Sedan Initial Price: $27,300 Annual O&M: $4,456 Expected trade-in value after 5 years: $9,100 b. SUV Initial Price: $38,795 Annual O&M: $3,050 Expected trade-in value after 5 years: $18,544 If you intend to keep your new vehicle for 5 years, then trade it in, determine the net present value (NPV) of each alternative, assuming a discount rate of 4.0%. Which...
You are thinking about investing money in the stock market and have narrowed your choices to...
You are thinking about investing money in the stock market and have narrowed your choices to one of two stocks: TD Bank or Cenovas Energy. For TD Bank you have the following statistics: •  Mean monthly closing price: $75.00      • Sample standard deviation: $6.00 The monthly closing stock prices of Cenovas Energy for the last eight months is shown below: Closing Stock Price:  ($) 14.00  14.50  11.00  13.00  13.75  11.00   8.75  10.00 Calculate the mean stock price of Cenovas Energy.  [2 marks]    Calculate the standard deviation for the sample prices...
Assume an investor with a 5 year investment horizon is considering purchasing an 8 year semiannual...
Assume an investor with a 5 year investment horizon is considering purchasing an 8 year semiannual 5% coupon bond that is currently selling at 99. The investor expects to reinvest the coupons at 2% and that the bond will be selling to offer a yield to maturity of 6% in five years. What is the expected total return for this bond? Express your answer on a bond-equivalent basis and on an effective annual rate basis.
You are considering an investment in the stock market and have identified two potential stocks
Risk and return You are considering an investment in the stock market and have identified two potential stocks, they are Rio Tinto (NYSE: RIO) and Amazon (NASDAQ: AMZN). The year-end historical prices for the years 2010 to 2018 are shown in the table below. YearRio TintoAmazon201048.51125.41201169.48169.64201260.46194.44201356.47264.27201453.15358.69201544.13354.53201624.65587.00201744.79823.48201856.111450.891. Which stocks would you prefer to own? Would every rational investor make the same choice? Explain your answer(s). 2. Calculate the covariance and correlation coefficient between the two stocks. Does it appear that a portfolio consisting of...
You are considering an investment in the stock market and have identified two potential stocks, they...
You are considering an investment in the stock market and have identified two potential stocks, they are Rio Tinto (NYSE: RIO) and Amazon (NASDAQ: AMZN). The historical prices for the past 10 years are shown in the table below. Year Rio Tinto Amazon 2010 48.51 125.41 2011 69.48 169.64 2012 60.46 194.44 2013 56.47 264.27 2014 53.15 358.69 2015 44.13 354.53 2016 24.65 587.00 2017 44.79 823.48 2018 56.11 1450.89 1. Which stocks would you prefer to own? Would everyone...
Risk and return You are considering an investment in the stock market and have identified three...
Risk and return You are considering an investment in the stock market and have identified three potential stocks, they are Crown (ASX: CWN), Tencent (HKG: 0700), and Commonwealth Bank (ASX: CBA). The historical prices for the past 10 years are shown in the table below. Assume no dividend is distributed during this period. Year Crown Tencent Commonwealth (CBA) 2010 7.76 29.04 53.63 2011 8.57 40.40 52.15 2012 8.09 37.94 50.39 2013 11.59 54.28 64.10 2014 16.68 108.70 73.83 2015 13.61...
Risk and return You are considering an investment in the stock market and have identified three...
Risk and return You are considering an investment in the stock market and have identified three potential stocks, they are Crown (ASX: CWN), Tencent (HKG: 0700) and Commonwealth Bank (ASX: CBA). The historical prices for the past 10 years are shown in the table below. Assume no dividend is distributed during this period. Year Crown Tencent Commonwealth (CBA) 2010 7.76 29.04 53.63 2011 8.57 40.40 52.15 2012 8.09 37.94 50.39 2013 11.59 54.28 64.10 2014 16.68 108.70 73.83 2015 13.61...
Risk and return You are considering an investment in the stock market and have identified three...
Risk and return You are considering an investment in the stock market and have identified three potential stocks, they are Crown (ASX: CWN), Tencent (HKG: 0700), and Commonwealth Bank (ASX: CBA). The historical prices for the past 10 years are shown in the table below. Assume no dividend is distributed during this period. Year Crown Tencent Commonwealth (CBA) 2010 7.76 29.04 53.63 2011 8.57 40.40 52.15 2012 8.09 37.94 50.39 2013 11.59 54.28 64.10 2014 16.68 108.70 73.83 2015 13.61...
You are considering an investment in the stock market and have identified three potential stocks, they...
You are considering an investment in the stock market and have identified three potential stocks, they are Crown (ASX: CWN), Tencent (HKG: 0700) and Commonwealth Bank (ASX: CBA). The historical prices for the past 10 years are shown in the table below. Assume no dividend is distributed during this period. Year Crown Tencent Commonwealth (CBA) 2010 7.76 29.04 53.63 2011 8.57 40.40 52.15 2012 8.09 37.94 50.39 2013 11.59 54.28 64.10 2014 16.68 108.70 73.83 2015 13.61 132 88.85 2016...
Risk and return You are considering an investment in the stock market and have identified two...
Risk and return You are considering an investment in the stock market and have identified two potential stocks, they are Westpac Banking Corp. (ASX: WBC) and Singapore Airlines Ltd. (SGX: C6L). The historical prices for the past 10 years are shown in the table below. Year ASX:WBC SGX:C6L 2011 23.70 13.82 2012 22.85 14.76 2013 21.01 11.1 2014 27.85 10.99 2015 30.85 11.03 2016 31.71 9.90 2017 30.96 11.31 2018 24.55 9.65 1. Which stocks would you prefer to own?...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT