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

Monroe Corp. reported the following amounts on its balance sheet at December 31, 2018 and 2017:

2018, 2017

Cash and Receivables 35,000 40,000

Merchandise Inventory 20,000 15,000

Property, Plant, and Equipment, Net 80,000 60,000

Total Assets 135,000 115,000

Prepare a vertical analysis of Monroe Corp. for 2018 and 2017.

Short Answer

Expert verified

Answer

Vertical analysis of Monroe Corp is given below indicating that value of current assets increase in balance sheet.

Step by step solution

01

Calculations

Balance Sheet(partial)

Dec 31, 2018 and 2017


2018($)
Percent of Total
2017($)
Percent of Total

Cash &

receivables

35,000
35,000
35,000
35,000
Merchandise Inventory
20,000
20,000
15,000
15,000
Property plant and Equipment
80,000
59.26%
60,000
52.17%
Total Assets
135,000
100%
115,000
100%
02

Workings

Balance Sheet(partial)

Dec 31, 2018 and 2017


2018($)
Percent of Total
2017($)
Percent of Total35,000

Cash &

receivables


35,000
(35,000/135,000)*100
40,000
(40,000/115,000)*100
Merchandise Inventory
Total Assets
(20,000/135,000)*100
15,000
(15,000/115,000)*100
Property plant and Equipment
80,000
(80,000/135,000)*100
60,000
(60,000/115,000)*100
Total Assets
135,000
100%
115,000

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

Net sales revenue, net income, and commonA stockholdersโ€™ equity for Azbel Mission Corporation, a manufacturer of contact lenses, follow for a four-year period.

Requirements

1.Compute trend analyses for each item for 2017โ€“2019. Use 2016 as the base year,and round to the nearest whole percent.

2.Compute the rate of return on common stockholdersโ€™ equity for 2017โ€“2019, rounding to three decimal places.

Rossโ€™s Lipstick Companyโ€™s long-term debt agreements make certain demands on the business. For example, Ross may not purchase treasury stock in excess of the balance of retained earnings. Also, long-term debt may not exceed stockholdersโ€™ equity, and the current ratio may not fall below 1.50. If Ross fails to meet any of these requirements, the companyโ€™s lenders have the authority to take over management of the company.Changes in consumer demand have made it hard for Ross to attract customers.

Current liabilities have mounted faster than current assets, causing the current ratio to fall to 1.47. Before releasing financial statements, Rossโ€™s management is scrambling to improve the current ratio. The controller points out that an investment can be classified as either long-term or short-term, depending on managementโ€™s intention. By deciding to convert an investment to cash within one year, Ross can classify the investment as short-termโ€”a current asset. On the controllerโ€™s recommendation, Rossโ€™s board of directors votes to reclassify long-term investments as short-term.

Requirements

1. What effect will reclassifying the investments have on the current ratio? Is Rossโ€™s true financial position stronger as a result of reclassifying the investments?

2. Shortly after the financial statements are released, sales improve; so, too, does the current ratio. As a result, Rossโ€™s management decides not to sell the investments it had reclassified as short-term. Accordingly, the company reclassified the investments as long-term. Has management behaved unethically? Give the reasoning underlying of your answer.

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 Research Enterprises follows:

2019

2018

2017

Total current assets

\(490,000

\)320,000

\(230,000

Total current liabilities

\)235,000

\(160,000

\)115,000

Compute the dollar amount of change and the percentage of change in Research Enterprisesโ€™ working capital each year during 2019 and 2018. What do the calculated changes indicate?

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

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