Financial Accounting: Tools for Business Decision Making, 8th Edition
8th Edition
ISBN: 9781118953808
Author: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso
Publisher: WILEY
expand_more
expand_more
format_list_bulleted
Videos
Question
Chapter 13, Problem 13.8BE
To determine
Vertical Analysis: Vertical analysis is prepared to analyze the relationship among various financial statements with a particular base amount. Use the following formula to calculate vertical analysis percentage:
Formula:
This analysis is otherwise called as common-size statement.
To prepare: Vertical analysis for 2017, 2016, and 2015.
Given info: Sales, cost of goods sold, and expenses for the years 2018, 2017, and 2016.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Find in Amount ($) and Percentage(%) for Year 2 over Year 1:
Income Statement -
(a) Sales Revenue
(b) Cost of sales
(c) Gross Margin
-
1. Prepare a comparative income statement with horizontal analysis for the two-year period, using 20Y1 as the base year. Round percentages to one decimal place. Use the minus sign
to indicate a decrease in the "Difference" columns.
McDade Company
Comparative Income Statement
For the Years Ended December 31, 20Y2 and 20Y1
Sales
Cost of merchandise sold
Gross profit
Selling expenses
Net income
Administrative expenses
Total operating expenses
Income from operations
Other revenue
Income before income tax expense $100,382 $170,000
Income tax expense
28,100 51,000
$72,282 $119,000
2. Net income has
Difference
Amount
7
20Y2 20Y1
$818,551 $703,000
589,600 440,000
$228,951 $263,000 $
$84,080 $59,000
48,320 37,000
$132,400 $96,000 $
$96,551 $167,000
3,831
3,000
from 20Y1 to 20Y2. Sales have
Difference
Percent
-
%
%
%
%
%
%
%
1%
%
%
1%
increased
decreased
however, the cost of merchandise sold has
causing the gross profit to
Previous
Next
Vertical analysis (common-size) percentages for Baker Company’s sales revenue, cost of goods sold, and expenses are as follows. Did Baker’s net income as a percent of sales increase, decrease, or remain unchanged over the 3-year period? Provide numerical support for your answer.
Vertical Analysis
2020
2019
2018
Sales revenue
100.0%
100.0%
100.0%
Cost of goods sold
60.0
63.9
65.0
Expenses
26.0
26.6
27.5
Chapter 13 Solutions
Financial Accounting: Tools for Business Decision Making, 8th Edition
Ch. 13 - Prob. 1QCh. 13 - Prob. 2QCh. 13 - Prob. 3QCh. 13 - Prob. 4QCh. 13 - Prob. 5QCh. 13 - Prob. 6QCh. 13 - Prob. 7QCh. 13 - Prob. 8QCh. 13 - Prob. 9QCh. 13 - (a) Distinguish among the following bases of...
Ch. 13 - Prob. 11QCh. 13 - Prob. 12QCh. 13 - Prob. 13QCh. 13 - Prob. 14QCh. 13 - Prob. 15QCh. 13 - Prob. 16QCh. 13 - Prob. 17QCh. 13 - Prob. 18QCh. 13 - Prob. 19QCh. 13 - Prob. 20QCh. 13 - Prob. 21QCh. 13 - Prob. 22QCh. 13 - Prob. 13.1BECh. 13 - Prob. 13.2BECh. 13 - Prob. 13.3BECh. 13 - Prob. 13.4BECh. 13 - Prob. 13.5BECh. 13 - Prob. 13.6BECh. 13 - Prob. 13.7BECh. 13 - Prob. 13.8BECh. 13 - Prob. 13.9BECh. 13 - Prob. 13.10BECh. 13 - Prob. 13.11BECh. 13 - Prob. 13.12BECh. 13 - Prob. 13.13BECh. 13 - Prob. 13.14BECh. 13 - Prob. 13.15BECh. 13 - Prob. 13.1DIECh. 13 - Prob. 13.2DIECh. 13 - Prob. 13.3DIECh. 13 - Prob. 13.1ECh. 13 - Prob. 13.2ECh. 13 - Prob. 13.3ECh. 13 - Prob. 13.4ECh. 13 - Prob. 13.5ECh. 13 - Prob. 13.6ECh. 13 - Prob. 13.7ECh. 13 - Prob. 13.8ECh. 13 - Prob. 13.9ECh. 13 - Prob. 13.10ECh. 13 - Prob. 13.11ECh. 13 - Prob. 13.12ECh. 13 - Prob. 13.13ECh. 13 - Prob. 13.1APCh. 13 - Prob. 13.2APCh. 13 - Prob. 13.3APCh. 13 - Prob. 13.4APCh. 13 - Prob. 13.5APCh. 13 - Prob. 13.1EYCTCh. 13 - Prob. 13.2EYCTCh. 13 - Prob. 13.3EYCTCh. 13 - Prob. 13.4EYCTCh. 13 - Prob. 13.7EYCTCh. 13 - Prob. 13.8EYCTCh. 13 - Prob. 13.9EYCTCh. 13 - Prob. 13.1IFRS
Knowledge Booster
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
- Cuneo Companys income statements for the last 3 years are as follows: Refer to the information for Cuneo Company above. Required: 1. Prepare a common-size income statement for Year 1 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.) 2. Prepare a common-size income statement for Year 2 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.) 3. Prepare a common-size income statement for Year 3 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.)arrow_forwardSundahl Companys income statements for the past 2 years are as follows: Refer to the information for Sundahl Company above. Required: 1. Prepare a common-size income statement for Year 1 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.) 2. Prepare a common-size income statement for Year 2 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.)arrow_forwardThe following is select account information for August Sundries. Sales: $850,360; Sales Returns and Allowances: $148,550; COGS: $300,840; Operating Expenses: $45,770; Sales Discounts: $231,820. If August Sundries uses a multi-step income statement format, what is their gross margin?arrow_forward
- Jasmine Company provided the following income statements for its first 3 years of operation: Refer to the information for Jasmine Company above. Required: Prepare common-size income statements by using net sales as the base. (Note: Round answers to the nearest whole percentage.)arrow_forwardThe following data (in millions) were taken from the financial statements of Costco Wholesale Corporation: a. For Costco, determine the amount of change in millions and the percent of change (round to one decimal place) from the prior year to the recent year for: 1. Revenue 2. Operating expenses 3. Operating income b. Comment on the results of your horizontal analysis in part (a). c. Based upon Exercise 2-23, compare and comment on the operating results of Target and Costco for the recent year.arrow_forwardThe following data (in millions) are taken from recent financial statements of Nike Inc.: a. Determine the amount of change (in millions) and percent of change in net income for Year 2. Round to one decimal place. b. Determine the percentage relationship between net income and net sales (net income divided by net sales) for Year 2 and Year 1. Round to one decimal place. c. What conclusions can you draw from your analysis?arrow_forward
- Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows: Current Year Previous Year Sales Cost of merchandise sold Selling expenses Administrative expenses Income tax expense Sales a. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. If required, round percentages to one decimal place. Enter all amounts as positive numbers. Innovation Quarter Inc. Comparative Income Statement For the Years Ended December 31 Current year Amount Current year Percent $388,000 100 248,320 Cost of merchandise sold Gross profit Selling expenses Administrative expenses Total operating expenses Income from operations Income tax expense $388,000 248,320 54,320 62,080 7,760 Net income $353,000 208,270 56,480 52,950 14,120 $ 54,320 62,080 7,760 % % % % % % % % % Previous year Amount Previous year Percent $353,000 100 ✓ % 208,270 $ 56,480 52,950 14,120 % % % % % % % %arrow_forwardVertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows: Previous Year Sales Cost of goods sold Selling expenses Administrative expenses Income tax expense Current Year $447,000 272,670 71,520 71,520 13,410 $384,000 215,040 69,120 57,600 15,360arrow_forwardIncome statements for Campbell Company for Year 3 and Year 4 follow: CAMPBELL COMPANY Income Statements Year 4 Year 3 $180,800 120,400 19,900 14,500 Sales $200,800 Cost of goods sold Selling expenses Administrative expenses Interest expense Total expenses 142,400 21,900 12,500 3,900 $180,700 5,900 $160,700 20,100 3,700 Income before taxes 20,100 Income taxes expense 6,500 Net income $ 13,600 $ 16,400 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. Complete this question by entering your answers in the tabs below. Required A Required B 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…arrow_forward
- Comparative income statements for Pearle Company are provided: Required: Perform a horizontal analysis of Pearle Company's income statement by computing horizontal percentages for each item. Note: Round your answers to 1 decimal place. Sales Less cost of goods sold Gross margin Less operating expenses Income before taxes Income taxes Net income Pearle Company Comparitive Income Statement Years Ended December 31, Year 2 Year 1 $ 600,000 $ 539,700 388,700 361,650 $ 211,300 113,950 97,350 42,440 54,910 $ 178,050 103,770 74,280 33,412 40,868 Percentage Change 90.0 % % % % % % %arrow_forwardHorizontal Analysis of the Income Statement Income statement data for Winthrop Company for two recent years ended December 31, are as follows: Sales Cost of goods sold Gross profit Selling expenses Administrative expenses Total operating expenses Income before income tax Income tax expenses Net income Current Year $381,300 312,000 $69,300 $19,210 18,150 $37,360 $31,940 12,800 $19,140 Previous Year $310,000 260,000 $50,000 $17,000 15,000 $32,000 $18,000 7,200 $10,800arrow_forwardAssume the following sales data for a company:Current year$832,402 Preceding year608,082What is the percentage increase in sales from the preceding year to the current year? a.136.89% b.36.89% c.73.05% d.26.95% The relationship of $242,729 to $104,267, expressed as a ratio, is a.0.8 b.2.3 c.0.4 d.0.7arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Financial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning
Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Financial ratio analysis; Author: The Finance Storyteller;https://www.youtube.com/watch?v=MTq7HuvoGck;License: Standard Youtube License