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

Computing inventory, gross profit, and receivables ratios

Requirements

1. Compute the inventory turnover, daysโ€™ sales in inventory, and gross profit

percentage for Accelโ€™s Companies for 2018.

2. Compute daysโ€™ sales in receivables during 2018. Round intermediate calculations to

three decimal places. Assume all sales were on account.

3. What do these ratios say about Accelโ€™s Companiesโ€™ ability to sell inventory and

collect receivables?

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?

Question: What are the three main ways to analyze financial statements?

The Klein Department Stores, Inc. chief executive officer (CEO) has asked you tocompare the companyโ€™s profit performance and financial position with the averages for the industry. The CEO has given you the companyโ€™s income statement and balance sheet as well as the industry average data for retailers.

Requirements

1.Prepare a vertical analysis for Klein for both its income statement and balance sheet.

2.Compare the companyโ€™s profit performance and financial position with the averagefor the industry.

Data for Oxford State Bank follow:


2018

2017

Net Income

\(71,900

\)64,300

Dividendsโ€”Common

22,000

22,000

Dividendsโ€”Preferred

16,800

16,800

Total Stockholdersโ€™ Equity at Year-End (includes 95,000 shares of common stock)

770,000

610,000


Net Income

\( 71,900

\) 64,300

Market Price per Share of Common Stock

\( 16.50

\) 10.00


Evaluate the common stock of Oxford State Bank as an investment. Specifically,

use the three stock ratios to determine whether the common stock has increased or decreased in attractiveness during the past year. Round to two decimal places.

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