Required a. Perform a horizontal analysis, showing the percentage change in each income statement component between Year 3 and Year 4. b. Perform a vertical analysis, showing each income statement component as a percentage of sales for each year.

Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Chapter15: Financial Statement Analysis
Section: Chapter Questions
Problem 40E: Cuneo Companys income statements for the last 3 years are as follows: Refer to the information for...
icon
Related questions
Question
100%
Income statements for Walton Company for Year 3 and Year 4 follow:
WALTON COMPANY
Income Statements.
Sales
Cost of goods sold.
Selling expenses
Administrative expenses
Interest expense
Total expenses
Income before taxes
Income taxes expense
Net income
Required A Required B
Year 4
$200, 300
143,300
20,900
12,900
3,200
Required
a. Perform a horizontal analysis, showing the percentage change in each income statement component between Year 3 and Year 4.
b. Perform a vertical analysis, showing each income statement component as a percentage of sales for each year.
Sales
Cost of goods sold
Selling expenses
Administrative expenses
Interest expense
Total expenses
Income before taxes
Income taxes expense
Net income
$180,300
$160,300
20,000
20,000
3,300
5,600
$ 14,400 $ 16,700
Complete this question by entering your answers in the tabs below.
Year 3
$180,300
X Answer is complete but not entirely correct.
Perform a vertical analysis, showing each income statement component as a percentage of sales for each year. (Percentages
may not add exactly due to rounding. Round your percentage answers to 1 decimal place. (i.e., 0.234 should be entered as
23.4).)
WALTON COMPANY
Vertical Analysis of Income Statements
Percentage of
Sales Year 4
121,300
18,900
14,900
5,200
100.0 %
71.0 X
10.0 X
6.0 X
2.0 X
90.0
10.0
3.0 X
7.0 %
Percentage of
Sales Year 3
100.0 %
67.0 X
10.0 X
8.0 X
3.0
89.0
11.0✓
2.0 X
9.0 %
< Required A
Required B
Transcribed Image Text:Income statements for Walton Company for Year 3 and Year 4 follow: WALTON COMPANY Income Statements. Sales Cost of goods sold. Selling expenses Administrative expenses Interest expense Total expenses Income before taxes Income taxes expense Net income Required A Required B Year 4 $200, 300 143,300 20,900 12,900 3,200 Required a. Perform a horizontal analysis, showing the percentage change in each income statement component between Year 3 and Year 4. b. Perform a vertical analysis, showing each income statement component as a percentage of sales for each year. Sales Cost of goods sold Selling expenses Administrative expenses Interest expense Total expenses Income before taxes Income taxes expense Net income $180,300 $160,300 20,000 20,000 3,300 5,600 $ 14,400 $ 16,700 Complete this question by entering your answers in the tabs below. Year 3 $180,300 X Answer is complete but not entirely correct. Perform a vertical analysis, showing each income statement component as a percentage of sales for each year. (Percentages may not add exactly due to rounding. Round your percentage answers to 1 decimal place. (i.e., 0.234 should be entered as 23.4).) WALTON COMPANY Vertical Analysis of Income Statements Percentage of Sales Year 4 121,300 18,900 14,900 5,200 100.0 % 71.0 X 10.0 X 6.0 X 2.0 X 90.0 10.0 3.0 X 7.0 % Percentage of Sales Year 3 100.0 % 67.0 X 10.0 X 8.0 X 3.0 89.0 11.0✓ 2.0 X 9.0 % < Required A Required B
Income statements for Walton Company for Year 3 and Year 4 follow:
WALTON COMPANY
Income Statements
Sales
Cost of goods sold
Selling expenses
Administrative expenses
Interest expense
Total expenses
Income before taxes
Income taxes expense
Net income
Required A Required B
Year 4
$200,300
143,300
20,900
12,900
3,200
Required
a. Perform a horizontal analysis, showing the percentage change in each income statement component between Year 3 and Year 4.
b. Perform a vertical analysis, showing each income statement component as a percentage of sales for each year.
Sales
Cost of goods sold
Selling expenses
$180,300
$160,300
20,000
20,000
3,300
5,600
$ 14,400 $ 16,700
Complete this question by entering your answers in the tabs below.
Administrative expenses
Interest expense
Total expenses
Income before taxes
Income taxes expense
Net income (loss)
Year 3
$180,300
121,300
18,900
14,900
5,200
> Answer is complete but not entirely correct.
Perform a horizontal analysis, showing the percentage change in each income statement component between Year 3 and Year
4. (Negative answers should be indicated by a minus sign. Round your percentage answers to 1 decimal place. (i.e., 0.234
should be entered as 23.4).)
WALTON COMPANY
Horizontal Analysis of Income Statements
Percentage Change
over Year 3
11.0 %
18.0
11.0 x
(13.0) X
(38.0) X
12.0 X
0.0-
70.0 x
(14.0) X %
Required B >
Transcribed Image Text:Income statements for Walton Company for Year 3 and Year 4 follow: WALTON COMPANY Income Statements Sales Cost of goods sold Selling expenses Administrative expenses Interest expense Total expenses Income before taxes Income taxes expense Net income Required A Required B Year 4 $200,300 143,300 20,900 12,900 3,200 Required a. Perform a horizontal analysis, showing the percentage change in each income statement component between Year 3 and Year 4. b. Perform a vertical analysis, showing each income statement component as a percentage of sales for each year. Sales Cost of goods sold Selling expenses $180,300 $160,300 20,000 20,000 3,300 5,600 $ 14,400 $ 16,700 Complete this question by entering your answers in the tabs below. Administrative expenses Interest expense Total expenses Income before taxes Income taxes expense Net income (loss) Year 3 $180,300 121,300 18,900 14,900 5,200 > Answer is complete but not entirely correct. Perform a horizontal analysis, showing the percentage change in each income statement component between Year 3 and Year 4. (Negative answers should be indicated by a minus sign. Round your percentage answers to 1 decimal place. (i.e., 0.234 should be entered as 23.4).) WALTON COMPANY Horizontal Analysis of Income Statements Percentage Change over Year 3 11.0 % 18.0 11.0 x (13.0) X (38.0) X 12.0 X 0.0- 70.0 x (14.0) X % Required B >
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Income Statement Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Financial Accounting: The Impact on Decision Make…
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781337272124
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,