/*! This file is auto-generated */ .wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none} Q3RQ Question: What is horizontal ana... [FREE SOLUTION] | 91Ó°ÊÓ

91Ó°ÊÓ

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 91Ó°ÊÓ!

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

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.

The financial statements of Ion Corporation include the following items:

Current Year Preceding Year

Balance Sheet:

Cash \( 6,000 \) 8,000

Short-term Investments 4,400 10,700

Net Accounts Receivable 21,600 29,200

Merchandise Inventory 30,800 27,600

Prepaid Expenses 6,000 3,600

Total Current Assets 68,800 79,100

Total Current Liabilities 53,200 37,200

Income Statement:

Net Sales Revenue $ 184,800

Cost of Goods Sold 126,000

Compute the following ratios for the current year:

7. Current ratio

8. Acid-test ratio

9. Inventory turnover

10. Gross profit percentage

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

Computing EPS and P/E ratio

Requirements

1. Compute earnings per share (EPS) for 2018 for Accel’s. Round to the nearest cent.

2. Compute Accel’s Companies’ price/earnings ratio for 2018. The market price per

share of Accel’s stock is $12.50.

3. What do these results mean when evaluating Accel’s Companies’ profitability?

Using ratios to evaluate a stock investment

Comparative financial statement data of Sanfield, Inc. follow:

SANFIELD, INC.

Comparative Income Statement

Years Ended December 31, 2018, and 2017

2018

2017

Net Sales Revenue

\( 462,000

\) 430,000

Cost of Goods Sold

236,000

213,000

Gross Profit

226,000

217,000

Operating Expense

135,000

133,000

Income from Operations

91,000

84,000

Interest Expense

8,000

12,000

Income Before Income Tax

83,000

72,000

Income Tax Expense

18,000

22,000

Net Income

\( 65,000

\) 50,000

SANFIELD, INC.

Comparative Balance Sheet

December 31, 2018, and 2017

2018

2017

2016

Asset

Current Assets:

Cash

\( 99,000

\) 97,000

Accounts Receivable, Net

109,000

117,000

\( 100,000

Merchandise Inventory

142,000

164,000

207,000

Prepaid Expenses

15,000

5,000

Total Current Assets

365,000

383,000

Property, Plant, and Equipment, Net

215,000

177,000

Total Assets

\) 580,000

\( 560,000

\) 599,000

Liabilities

Total Current Liabilities

\( 222,000

\) 244,000

Long-term Liabilities

113,000

92,000

Total Liabilities

335,000

336,000

Stockholders’ Equity

Preferred Stock, 4%

92,000

92,000

Common Stockholders’ Equity, no par

153,000

132,000

85,000

Total Liabilities and Stockholders’ Equity

\( 580,000

\) 560,000

1. Market price of Sanfield’s common stock: \(51.48 at December 31, 2018, and \)37.08 at December 31, 2017.

2. Common shares outstanding: 16,000 on December 31, 2018 and 15,000 on December 31, 2017 and 2016.

3. All sales are on credit.

Requirements

1. Compute the following ratios for 2018 and 2017:

  1. Current ratio
  2. Cash ratio
  3. Times-interest-earned ratio
  4. Inventory turnover
  5. Gross profit percentage
  6. Debt to equity ratio
  7. Rate of return on common stockholders’ equity
  8. Earnings per share of common stock
  9. Price/earnings ratio

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

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.