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

Net sales revenue, net income, and common stockholders’ equity for Eyesight Mission Corporation, a manufacturer of contact lenses, follow for a four-year period.

2019

2018

2017

2016

Net Sales Revenue

\(766000

\)708000

\(644000

\)664000

Net Income

60000

38000

36000

44000

Ending Common Stockholder’s Equity

368000

352000

326000

296000

Requirements

1.Compute trend analyses for each item for 2017–2019. Use 2016 as the base year, and round to the nearest whole percent.

2.Compute the rate of return on common stockholders’ equity for 2017–2019, rounding to three decimal places.

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?

Measuring profitability

Requirements

1. Compute the profit margin ratio for Accel’s Companies for 2018.

2. Compute the rate of return on total assets for 2018.

3. Compute the asset turnover ratio for 2018.

4. Compute the rate of return on common stockholders’ equity for 2018.

5. Are these rates of return strong or weak? Explain your reasoning.

Net sales revenue, net income, and commonA stockholders’ equity for Azbel Mission Corporation, a manufacturer of contact lenses, follow for a four-year period.

Requirements

1.Compute trend analyses for each item for 2017–2019. Use 2016 as the base year,and round to the nearest whole percent.

2.Compute the rate of return on common stockholders’ equity for 2017–2019, rounding to three 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