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

Determining the effects of business transactions on selected ratios

Financial statement data of Modern Traveler’s Magazine include the following items:

Cash

\(19,000

Accounts Receivable, Net

82,000

Merchandise Inventory

183,000

Total Assets

638,000

Accounts Payable

102,000

Accrued Liabilities

35,000

Short-term Notes Payable

50,000

Long-term Liabilities

221,000

Net Income

69,000

Common Shares Outstanding

50,000 shares

Requirements

  1. Compute Modern 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.

a. Purchased merchandise inventory of \)42,000 on account.

b. Borrowed \(121,000 on a long-term note payable.

c. Issued 5,000 shares of common stock, receiving cash of \)103,000.

d. Received cash on account, $5,000.

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.

Data for Connor, Inc. and Alto Corp. follow:

Connor Alto

Net Sales Revenue \( 13,000 \) 22,000

Cost of Goods Sold 7,917 15,730

Other Expenses 4,342 5,170

Net Income \( 741 \) 1,100

Requirements

1. Prepare common-size income statements.

2. Which company earns more net income?

3. Which company’s net income is a higher percentage of its net sales revenue?

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?

What is benchmarking, and what are the two main types of benchmarks in financialstatement analysis?

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