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 ability to pay long-term debt.

Great Value Optical Company reported the following amounts on its balance sheet at

December 31, 2018 and 2017:

2018 2017

Cash and Receivables \( 80,640 \) 80,575

Merchandise Inventory 56,840 54,450

Property, Plant, and Equipment, Net 142,520 139,975

Total Assets \( 280,000 \) 275,000

Prepare a vertical analysis of Great Value’s assets for 2018 and 2017.

Question:Theater by Design and Show Cinemas are asking you to recommend their stock to your clients. Because Theater by Design and Show Cinemas earn about the same net income and have similar financial positions, your decision depends on their statement of cash flows, summarized as follows:

Theater by Design Show Cinemas

Net Cash Provided by Operating Activities \( 30,000 \) 70,000

Cash Provided by (Used for) Investing Activities:

Purchase of Plant Assets \( (20,000) \) (100,000)

Sale of Plant Assets 40,000 20,000 10,000 (90,000)

Cash Provided by (Used for) Financing Activities:

Issuance of Common Stock 0 30,000

Payment of Long-term Debt (40,000) 0

Net Increase (Decrease) in Cash \( 10,000 \) 10,000

Based on their cash flows, which company looks better? Give your reasons.

The following data are adapted from the financial statements of Bridget’s Shops, Inc.:

Total Current Assets $ 1,216,000

Accumulated Depreciation 2,000,000

Total Liabilities 1,540,000

Preferred Stock 0

Debt Ratio 55%

Current Ratio 1.60

Prepare Bridget’s condensed balance sheet as of December 31, 2018.

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

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