Question: What is horizontal analysis, and how is a percentage change computed?

Short Answer

Expert verified

Answer

It was used for the analysis of horizontal data over the last years to make decisions.

Step by step solution

01

Definition 

Horizontal analysis is used in financial statement analysis to compare historical data, such as ratios, or line items, over a number of accounting periods. Horizontal analysis can either use absolute comparisons of percentage comparisons, where the numbers in each succeeding period are expressed as a percentage of the amount in the baseline year, with the baseline amount being listed as 100%. This is also known as base-year analysis.

02

How is a percentage change computed?

In horizontal analysis the percent change is computed by Subtracting the base period amount from the analysis period amount, dividing the result by base the period amount then multiplying that amount by 100.

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

Question: P15-38 Using ratios to evaluate a stock investment

This problem continues the Canyon Canoe Company situation from Chapter 14. The company wants to invest some of its excess cash in trading securities and is considering two investments, The Paddle Company (PC) and Recreational Life Vests (RLV). The income statement, balance sheet, and other data for both companies follow for 2019 and 2018, as well as selected data for 2017:


THE PADDLE COMPANY

Comparative Financial Statements

Years Ended December 31


RECREATIONAL LIFE VESTS
Comparative Financial Statements
Years Ended December 31

Income statement

2019

2018

2017

2019

2018

2017

Net sales revenue

\(430,489

\)425,410

\(410,570

\)383,870

Cost of goods sold

258,756

256,797

299,110

280,190

Gross profit

171,733

168,613

111,460

103,680

Operating expenses

153,880

151,922

78,290

70,830

Operating income

17,853

16,691

33,170

32,850

Interest expenses

865

788

2,780

2,980

Income before income tax

16,988

15,903

30,390

29,870

Income tax expenses

5,137

4,809

8,780

8,630

Net income

\(11,851

\)11,094

\(21,610

\)21,240

Balance sheet

Assets

Cash & Cash Equivalents

\(69,159

\)70,793

\(65,730

\)55,270

Accounts Receivable

44,798

44,452

\(44,104

39,810

38,650

\)36,460

Merchandise Inventory

79,919

66,341

76,363

68,500

65,230

59,930

Other Current Assets

15,494

16,264

24,450

37,630

Total Current Assets

209,370

197,850

198,490

196,780

Long-term Assets

89,834

90,776

116,760

116,270

Total Assets

\(299,204

\)288,626

\(276,482

\)315,250

$$313,050

\(310,640

Liabilities

Current Liabilities

\)69,554

\(60,232

\)90,810

\(90,010

Long-term Liabilities

31,682

29,936

96,310

105,890

Total Liabilities

101,236

90,168

187,120

195,900

Stockholders’ Equity

Common Stock

72,795

80,885

111,530

102,480

Retained Earnings

125,173

117,573

16,600

14,670

Total Stockholders’ Equity

197,968

198,458

128,130

117,150

103,840

Total Liabilities and Stockholder’s Equity

\)299,204

\(288,626

\)315,250

\(313,050

Other data

Market price per share

\)21.38

\(33.82

\)46.37

$51.64

Annual dividend per share

0.32

0.30

0.53

0.45

Weighted average number of shares outstanding

9,000

8,000

9,000

8,000

Requirements

  1. Using the financial statements given, compute the following ratios for both companies for 2019 and 2018. Assume all sales are credit sales. Round all ratios to two decimal places.
  2. a. Current ratio

    h. Profit margin ratio

    b. Cash ratio

    i. Asset turnover ratio

    c. Inventory turnover

    j. Rate of return on common stockholders’ equity

    d. Accounts receivable turnover

    k. Earnings per share

    e. Gross profit percentage

    l. Price/earnings ratio

    f. Debt ratio

    m. Dividend yield

    g. Debt to equity ratio

    n. Dividend payout

  1. Compare the companies’ performance for 2019 and 2018. Make a recommendation to Canyon Canoe Company about investing in these companies. Which company would be a better investment, The Paddle Company or Recreational Life Vests? Base your answer on the ability to pay current liabilities, ability to sell merchandise and collect receivables, ability to pay the long-term debt, profitability, and attractiveness as an investment.

Old Mills’s income statement appears as follows (amounts in thousands):

Use the following ratio data to complete Old Mills’s income statement:


1. Inventory turnover is 3.70 (beginning Merchandise Inventory was \(810; ending

Merchandise Inventory was \)770).

2. Profit margin ratio is 14%.

Using ratios to evaluate a stock investment

Comparative financial statement data of Garfield, Inc. follow:

GARFIELD, INC
Comparative Income Statement
Years Ended December 31, 2018 and 2017

2018

2017

Net sales revenue

\(461,000

\)424,000

Cost of goods sold

241,000

211,000

Gross profit

220,000

213,000

Operating expenses

137,000

135,000

Income from operations

83,000

78,000

Interest expenses

9,000

13,000

Income before taxes

74,000

65,000

Income tax expenses

18,000

24,000

Net income

\(56,000

\)41,000

GARFIELD, INC
Comparative Income Statement
Years Ended December 31, 2018 and 2017

2018

2017

2016

Assets

Current assets

Cash

\(99,000

\)98,000

Accounts receivables, Net

108,000

114,000

107,000

Merchandise inventory

146,000

164,000

202,000

Prepaid expenses

20,000

9,000

Total current assets

373,000

385,000

Property, plant, and equipment

211,000

181,000

Total assets

\(584,000

\)566,000

\(602,000

Liabilities

Total current liabilities

\)227,000

\(246,000

Long-term liabilities

117,000

100,000

Total liabilities

344,000

346,000

Stockholder’s equity

Preferred stock, 3%

98,000

98,000

Common stockholder equity, no par

142,000

122,000

89,000

Total liabilities and stockholder’s equity

\)584,000

\(566,000

1. Market price of Garfield’s common stock: \)69.36 at December 31, 2018, and $38.04 at December 31, 2017.

2. Common shares outstanding: 14,000 on December 31, 2018 and 12,000 on December 31, 2017 and 2016.

3. All sales are on credit.

Requirements

1. Compute the following ratios for 2018 and 2017:

a. Current ratio

b. Cash ratio

c. Times-interest-earned ratio

d. Inventory turnover

e. Gross profit percentage

f. Debt to equity ratio

g. Rate of return on common stockholders’ equity

h. Earnings per share of common stock

i. Price/earnings ratio

2. Decide (a) whether Garfield’s ability to pay debts and to sell inventory improved or deteriorated during 2018 and (b) whether the investment attractiveness of its common stock appears to have increased or decreased.

Explaining financial statements

Caleb King is interested in investing in Orange Corporation. What types of tools should Caleb use to evaluate the company?

Monroe Corp. reported the following amounts on its balance sheet at December 31, 2018 and 2017:

2018, 2017

Cash and Receivables \( 35,000 \) 40,000

Merchandise Inventory 20,000 15,000

Property, Plant, and Equipment, Net 80,000 60,000

Total Assets \( 135,000 \) 115,000

Prepare a vertical analysis of Monroe Corp. for 2018 and 2017.

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