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

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.

Short Answer

Expert verified

(1) Vertical analysis is shown in Step 1 and 2.

(2) Company is less profitable than industry average. Also, liabilities are higher than the industry average

Step by step solution

01

Step1:Vertical analysis of income statement 

In vertical analysis of income statement, sales revenue (100%) taken as base.

K D S INC.

Income Statement

Year Ended December 31, 2018

K D S Inc.

Percentage

Industry Average

Net Sales Revenue

$778000

100%

100.00%

Less: Cost of Goods Sold

524372

67.4%

65.80%

Gross Profit

253628

32.6%

34.20%

Operating expenses

159490

20.5%

19.70%

Operating income

94138

12.1%

14.50%

Other expenses

6224

0.8%

0.40%

Net income

87914

11.3%

14.10%

02

Step2:Vertical analysis of Balance Sheet

K D S INC.

Balance Sheet

Year Ended December 31, 2018

K D S Inc.

Percentage

Industry Average

Current Assets

$339000

67.8%

70.90%

Property plant & equipment net

130000

26%

23.6

Intangible Asset, net

7000

1.4%

0.8

Other assets

24000

4.8%

4.7

Total Assets

500000

100%

100.00%

Current Liabilities

232000

46.4%

48.10%

Long Term Liabilities

111000

22.2%

16.60%

Total Liabilities

343000

68.6%

64.70%

Stockholder’s equity

157000

31.4%

35.30%

Total liabilities &stockholder’s equity

500000

100.00%

100.00%

03

Step3:Performance and financial position analysis 

The Industrial Average is a useful measure for evaluating a company. KDS Inc. Net income percentage 11.3 % is significantly lower than the industrial average. Hence, company should control its cost to increase the net income.

From the above analysis company’s fixed assets percentage is more than the industry average. It indicates that company invested more money on fixed assets Company’s long term liabilities percentage is also higher than the industry average rate. This indicates that company has borrowed money from long term liabilities more than the industries average

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

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.

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

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

Question: 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 All Digital Corp. and Green Zone, Inc. and have assembled the following data.

Selected income statement data for the current year:

All digital

Green Zone

Net sales revenue (all on credit)

\(417,925

\)493,115

Cost of goods sold

209,000

258,000

Interest expenses

0

14,000

Net income

58,000

72,000

Selected balance sheet and market price data at the end of the current year:

All digital

Green Zone

Current assets:

Cash

\(23,000

\)18,000

Short-term investment

37,000

17,000

Accounts receivables, Net

39,000

49,000

Merchandise inventory

64,000

102,000

Prepaid expenses

21,000

17,000

Total current assets

\(184,000

\)203,000

Total assets

\(263,000

\)326,000

Total current liabilities

105,000

99,000

Total liabilities

105,000

134,000

Common stock:

\(1 par (10,000 shares)

10,000

\)2 par (14,000 shares)

28,000

Total stockholder’s equity

158,000

192,000

Market price per share of common stock

92.80

128.50

Dividend paid per common share

1.20

0.90

Selected balance sheet data at the beginning of the current year:

All digital

Green Zone

Balance sheet:

Accounts receivables, Net

\(41,000

\)54,000

Merchandise inventory

81,000

89,000

Total assets

258,000

277,000

Common stock:

\(1 par (10,000 shares)

10,000

\)2 par (14,000 shares)

28,000

Your strategy is to invest in companies with low price/earnings ratios but in good financial shape. 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

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?

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