Net sales revenue, net income, and common stockholders’ equity for Eyesight Mission Corporation, a manufacturer of contact lenses, follow for a four-year period.

2019

2018

2017

2016

Net Sales Revenue

\(766000

\)708000

\(644000

\)664000

Net Income

60000

38000

36000

44000

Ending Common Stockholder’s Equity

368000

352000

326000

296000

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.

Short Answer

Expert verified

1) Trend analysis shown in Step 2.

(2) Rate of return for year 2017-2019 equals 11.576%, 11.209% and 16.667%, respectively.

Step by step solution

01

Step1:Definition of Trend Analysis

It is a method of making comparative study of financial statements over a series of accounting year. More specifically its a statistical device of identifying direction, speed and extends of trends in individual items in financial statements over a long period of time.It is calculated as follows:

Trend%=AccountingnumberofcurrentyearAccountingnumberofbaseyear×100

02

 Step2: Calculations of Trend Analysis

Net revenue, net income and ending common stockholder’s equity as follows:

Calculate trend analysis for each item for 2017-2019 by using 2016 as the base year:

Particulars

2019

2018

2017

2016

Net Sales Revenue

$766000

$708000

$644000

$664000

Trend% for net revenues

115%

107%

97%

100%

Net income

$60000

$38000

$36000

$44000

Trend % for net income

136%

86%

82%

100%

03

Step3:Notes

Note: Using 2016 as the base year.

04

Calculation of rate of return on common stockholders’ equity

Calculate rate of return on common equity for 2017-2019:

For 2019:

Rateofreturnonequity=Netincome--PreferreddividendAveragecommonshareoutstanding=$60,000-$0($352,000+$368,0002)=16.667%

For 2018:

Rateofreturnonequity=Netincome--PreferreddividendAveragecommonshareoutstanding=$38000-$0($326,000+$352,0002)=11.209%

For 2017:

role="math" localid="1656690545281" Rateofreturnonequity=Netincome--PreferreddividendAveragecommonshareoutstanding=$36000-$0($296,000+$326,0002)=11.576%

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

Verifine Corp. reported the following on its comparative income statement:

(In millions)2019 2018 2017

Revenue \( 9,890 \) 9,690 $ 9,135

Cost of Goods Sold 6,250 6,000 5,890

Prepare a horizontal analysis of revenues and gross profit—both in dollar amounts

and in percentages—for 2019 and 2018.

Consider the data for Klein Department Stores presented in Problem P15-24A.

Requirements

1.Prepare a common-size income statement and balance sheet for Klein. The first column of each statement should present Klein’s common-size statement, and the second column, the industry averages.

2.For the profitability analysis, compute Klein’s

  1. gross profit percentage and
  2. profit margin ratio. Compare these figures with the industry averages. Is Klein’s profit performance better or worse than the industry average?

3.For the analysis of financial position, compute Klein’s

  1. current ratio and
  2. debt to equity ratio. Compare these ratios with the industry averages.

Assume the current ratio industry average is 1.47, and the debt-to-equity industry average is 1.83. Is Klein’s financial position better or worse than the industry averages?

Old Mills’s income statement appears as follows (amounts in thousands):

Use the following ratio data to complete Old Mills’s income statement:


1. Inventory turnover is 3.70 (beginning Merchandise Inventory was \(810; ending

Merchandise Inventory was \)770).

2. Profit margin ratio is 14%.

Using ratios to evaluate a stock investment

Comparative financial statement data of Sanfield, Inc. follow:

SANFIELD, INC.

Comparative Income Statement

Years Ended December 31, 2018, and 2017

2018

2017

Net Sales Revenue

\( 462,000

\) 430,000

Cost of Goods Sold

236,000

213,000

Gross Profit

226,000

217,000

Operating Expense

135,000

133,000

Income from Operations

91,000

84,000

Interest Expense

8,000

12,000

Income Before Income Tax

83,000

72,000

Income Tax Expense

18,000

22,000

Net Income

\( 65,000

\) 50,000

SANFIELD, INC.

Comparative Balance Sheet

December 31, 2018, and 2017

2018

2017

2016

Asset

Current Assets:

Cash

\( 99,000

\) 97,000

Accounts Receivable, Net

109,000

117,000

\( 100,000

Merchandise Inventory

142,000

164,000

207,000

Prepaid Expenses

15,000

5,000

Total Current Assets

365,000

383,000

Property, Plant, and Equipment, Net

215,000

177,000

Total Assets

\) 580,000

\( 560,000

\) 599,000

Liabilities

Total Current Liabilities

\( 222,000

\) 244,000

Long-term Liabilities

113,000

92,000

Total Liabilities

335,000

336,000

Stockholders’ Equity

Preferred Stock, 4%

92,000

92,000

Common Stockholders’ Equity, no par

153,000

132,000

85,000

Total Liabilities and Stockholders’ Equity

\( 580,000

\) 560,000

1. Market price of Sanfield’s common stock: \(51.48 at December 31, 2018, and \)37.08 at December 31, 2017.

2. Common shares outstanding: 16,000 on December 31, 2018 and 15,000 on December 31, 2017 and 2016.

3. All sales are on credit.

Requirements

1. Compute the following ratios for 2018 and 2017:

  1. Current ratio
  2. Cash ratio
  3. Times-interest-earned ratio
  4. Inventory turnover
  5. Gross profit percentage
  6. Debt to equity ratio
  7. Rate of return on common stockholders’ equity
  8. Earnings per share of common stock
  9. Price/earnings ratio

2. Decide (a) whether Sanfield’s ability to pay debts and sell inventory improved or deteriorated during 2018 and (b) whether the investment attractiveness of its common stock appears to have increased or decreased.

Preparing common-size income statements

Refer to the data presented for Mulberry Designs, Inc. in Exercise E15-13.

Requirements

1. Prepare a comparative common-size income statement for Mulberry Designs,

Inc. using the 2018 and 2017 data. Round percentages to one-tenth percent (three

decimal places).

2. To an investor, how does 2018 compare with 2017? Explain your reasoning.

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