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

Briefly describe the ratios that can be used to evaluate a company’s stock as an investment.

Evaluating current ratio

Requirements

1. Compute Accel’s Companies’ current ratio at May 31, 2018 and 2017.

2. Did Accel’s Companies’ current ratio improve, deteriorate, or hold steady during 2018?

Measuring profitability

Requirements

1. Compute the profit margin ratio for Accel’s Companies for 2018.

2. Compute the rate of return on total assets for 2018.

3. Compute the asset turnover ratio for 2018.

4. Compute the rate of return on common stockholders’ equity for 2018.

5. Are these rates of return strong or weak? Explain your reasoning.

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.

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?

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