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

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.

Short Answer

Expert verified

Answer

  1. Give below

  2. Total Expenses decreases in 2018 as compared to 2017

Step by step solution

01

Step 1- Preparation of Comparative common-size statement

Mulberry Designs, Inc

Common-size Income Statement

Years Ended December 31, 2018 and 2017


2018 (in amount)

2018 (in %)

2017 (In amount)

2017 amount)

(In %)

Net Sales Revenue

$431,000


100

$372,350


100


Expenses





Cost of Goods sold

203,850

47.3


186,000


50


Selling andAdministrative

expenses

99,000

23

93,250


25

Other expenses

9,000

2.1

4,650

1.2

Total Expenses

311,850

72.4

283,900

76.2

02

Step 2:Working Note

For the purpose of calculation of common size income statement, take net sales of particular year as base to calculate percentage

Sales (2018) = ($431,000 /$431,000) x 100 = 100%

Cost of goods sold (2018) = ($203,850/$431,000) x 100 = 47.30%

Similar we calculate other values in form of percentage by taking net sales as base.

For year 2017, we will take net sales that is $372,350 as base for purpose of calculating the percentage values of related items

Sales (2017) = ($372,350/372,350) x 100 = 100%

Cost of goods sold (2017)= (186,000/372,350) x 100 = 50%

Similar we calculate other values in form of percentage by taking net sales as base.

03

Discuss

Requirement 2

Investors will compare on the basis of the percentage results of the two year 2018 and 2017. Net income has increase from 23.8% in 2017 to 27.6% in year 2018. Also in the year 2018, percentage of total expenses decreases from 76.2% in year 2017to 72.4% in year 2018. As in the both the years, percentage data is calculated by taking the base as net sales revenue. Common size income statement makes it easy for the investors to consider the percentage changes over the period of time for making proper comparisons of net income and total expenses incurred during the different period of time and helps to draw the broader view about the company's performance. Being an investor, the main consideration is net income of the company as compared to the other aspects for making decision about making investments in the company.

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

Traditional Millsโ€™s balance sheet appears as follows (amounts in thousands):

Use the following ratio data to complete Traditional Millsโ€™s balance sheet.

  1. Current ratio is 0.72.

2. Acid-test ratio is 0.36.

Micatin, Inc.โ€™s comparative income statement follows. The 2017 data are given as needed.


MICATIN INC.

Comparative Income Statement

Years Ended December 31, 2019, and 2018

Dollars in thousands

2019

2018

2017

Net Sales Revenue

\( 181,000

\) 160,000

Cost of Goods Sold

93,500

86,500

Selling and Administrative Expenses

45,000

40,500

Interest Expense

8,000

12,000

Income Tax Expense

11,000

10,500

Net Income

\( 23,500

\) 10,500

Additional data:

Total Assets

\( 209,000

\) 187,000

\( 167,000

Common Stockholdersโ€™ Equity

96,000

91,500

80,500

Preferred Dividends

2,000

2,000

0

Common Shares Outstanding During the Year

15,000

15,000

10,000

Requirements

  1. Calculate the profit margin ratio for 2019 and 2018.
  2. Calculate the rate of return on total assets for 2019 and 2018.
  3. Calculate the asset turnover ratio for 2019 and 2018.
  4. Calculate the rate of return on common stockholdersโ€™ equity for 2019 and 2018.
  5. Calculate the earnings per share for 2019 and 2018.
  6. Calculate the 2019 dividend payout on common stock. Assume dividends per share for common stock are equal to \)1.13 per share.
  7. Did the companyโ€™s operating performance improve or deteriorate during 2019?

Preparing common-size statements, analysis of profitability and financial position, comparison with the industry, and using ratios to evaluate a company

Consider the data for Randall Department Stores presented in Problem P15-31B.

Requirements

  1. Prepare a common-size income statement and balance sheet for Randall. The first column of each statement should present Randallโ€™s common-size statement, and the second column, the industry averages.
  2. For the profitability analysis, compute Randallโ€™s (a) gross profit percentage and (b) profit margin ratio. Compare these figures with the industry averages. Is Randallโ€™s profit performance better or worse than the industry average?
  3. For the analysis of financial position, compute Randallโ€™s (a) current ratio and (b) 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 Randallโ€™s financial position better or worse than the industry averages?

Describe a common-size statement and how it might be helpful in evaluating a company.

The financial statements of Valerieโ€™s Natural Foods include the following items:

Compute the following ratios for the current year:

  1. Current ratio

  2. Cash ratio

  3. Acid-test ratio

  4. Inventory turnover

  5. Dayโ€™s sales in inventory

  6. Dayโ€™s sales in receivables

  7. Gross profit percentage

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