Managerial Accounting
3rd Edition
ISBN: 9780077826482
Author: Stacey M Whitecotton Associate Professor, Robert Libby, Fred Phillips Associate Professor
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Question
Chapter 13, Problem 4.2GBP
To determine
Introduction:
Vertical analysis help to express each financial statement line item as a percentage of the base year.
To states:
The percentage decline in fuel cost had anything to do with company’s profit from 2012 to 2013.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
If you are told that LSJ Company’s net income (12/31/2023) increased 55% when compared to net income (12/31/2022) …this would represent an example of what type of analysis:
a. Vertical Analysis
b. Horizontal Analysis
c. Ratio Analysis
A condensed income statement for Northeast Airlines and a partially completed vertical analysis are
presented below.
ts
Required:
1. Complete the vertical analysis by computing each missing line item as a percentage of sales revenues.
(Round your answers to the nearest whole percent.)
еВook
Print
NORTHEAST AIRLINES
Income Statement (summarized)
For the Year Ended December 31
eferences
(in millions of U.S. dollars)
2016
2015
Sales Revenues
$ 20,925
100
$ 20,320
100 %
Salaries and Wages Expense
6,823
33
6,408
Fuel, Oil, Repairs, and Maintenance
4,717
4,646
Other Operating Expenses
5,200
4,725
23
Other Expenses (Revenues)
238
1
652
Income before Income Tax Expense
3,947
19
3,889
19
Income Tax Expense
Net Income
1,370
7
1,361
7
$ 2,577
% $ 2,528
%
中
Computing and Interpreting Financial Statement Ratios
Following are selected ratios of Norfolk Southern for 2018 and 2017.
Return on Assets (ROA) Component
2018
2017
Profitability (Net income/Sales)
25.3%
53.2%
Productivity (Sales/Average assets)
0.338
0.319
a. Was the company profitable in 2018?Answer
b. Was the company more profitable in 2018 or 2017?Answer
c. Is the change in productivity a positive or negative development?Answer
d. Compute the company’s ROA for 2018 and for 2017.
Note: Round answers to one decimal places (example: 10.4%).
ROA
2018
Answer
2017
Answer
e. From the information provided, which of the following best explains the change in ROA during 2018?
Answer
Chapter 13 Solutions
Managerial Accounting
Ch. 13 - Prob. 1QCh. 13 - Prob. 2QCh. 13 - What is ratio analysis? Why is it useful?
Ch. 13 - What benchmarks are commonly used for interpreting...Ch. 13 - Prob. 5QCh. 13 - Why are some analyses called horizontal and others...Ch. 13 - Slow Cellar’s current ratio increased from 1.2 to...Ch. 13 - From last year to this year. Colossal Company’s...Ch. 13 - From last year to this year, Berry Barn reported...Ch. 13 - Prob. 10Q
Ch. 13 - Prob. 1MCCh. 13 - Prob. 2MCCh. 13 - Prob. 3MCCh. 13 - Prob. 4MCCh. 13 - Prob. 5MCCh. 13 - Prob. 6MCCh. 13 - Prob. 7MCCh. 13 - Prob. 8MCCh. 13 - Prob. 9MCCh. 13 - Prob. 1MECh. 13 - Prob. 2MECh. 13 - Prob. 3MECh. 13 - Prob. 4MECh. 13 - Prob. 5MECh. 13 - Prob. 6MECh. 13 - Prob. 7MECh. 13 - Prob. 8MECh. 13 - Prob. 9MECh. 13 - Prob. 10MECh. 13 - Prob. 11MECh. 13 - Prob. 12MECh. 13 - Prob. 13MECh. 13 - Prob. 14MECh. 13 - Prob. 1ECh. 13 - Prob. 2ECh. 13 - Prob. 3ECh. 13 - Prob. 4ECh. 13 - Prob. 5ECh. 13 - Prob. 6ECh. 13 - Prob. 7ECh. 13 - Computing and Interpreting Liquidity Ratios...Ch. 13 - Prob. 9ECh. 13 - Prob. 10ECh. 13 - Prob. 11ECh. 13 - Prob. 12ECh. 13 - Prob. 13ECh. 13 - Analyzing the Impact of Selected Transactions on...Ch. 13 - Prob. 15ECh. 13 - Prob. 1.1GAPCh. 13 - Prob. 1.2GAPCh. 13 - Prob. 2.1GAPCh. 13 - Prob. 2.2GAPCh. 13 - Prob. 2.3GAPCh. 13 - Prob. 2.4GAPCh. 13 - Prob. 2.5GAPCh. 13 - Prob. 2.6GAPCh. 13 - Prob. 2.7GAPCh. 13 - Prob. 2.8GAPCh. 13 - Prob. 3.1GAPCh. 13 - Prob. 3.2GAPCh. 13 - Prob. 3.3GAPCh. 13 - Prob. 4.1GAPCh. 13 - Prob. 4.2GAPCh. 13 - Prob. 4.3GAPCh. 13 - Prob. 5.1GAPCh. 13 - Prob. 5.2GAPCh. 13 - Prob. 5.3GAPCh. 13 - Prob. 5.4GAPCh. 13 - Prob. 6.1GAPCh. 13 - Prob. 6.2GAPCh. 13 - Prob. 7GAPCh. 13 - Prob. 1.1GBPCh. 13 - Prob. 1.2GBPCh. 13 - Prob. 2.1GBPCh. 13 - Prob. 2.2GBPCh. 13 - Prob. 2.3GBPCh. 13 - Prob. 2.4GBPCh. 13 - Prob. 2.5GBPCh. 13 - Prob. 2.6GBPCh. 13 - Prob. 2.7GBPCh. 13 - Prob. 2.8GBPCh. 13 - Prob. 3.1GBPCh. 13 - Prob. 3.2GBPCh. 13 - Prob. 3.3GBPCh. 13 - Prob. 4.1GBPCh. 13 - Prob. 4.2GBPCh. 13 - Prob. 4.3GBPCh. 13 - Prob. 5.1GBPCh. 13 - Prob. 5.2GBPCh. 13 - Prob. 5.3GBPCh. 13 - Prob. 5.4GBPCh. 13 - Prob. 6.1GBPCh. 13 - Prob. 6.2GBPCh. 13 - Prob. 7GBP
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
- Computing and Interpreting Financial Statement Ratios Following are selected ratios of Norfolk Southern for 2018 and 2017. Return on Assets (ROA) Component 2018 2017 Profitability (Net income/Sales) 24.3% 52.2% Productivity (Sales/Average assets) 0.328 0.309 a. Was the company profitable in 2018?AnswerYesNo b. Was the company more profitable in 2018 or 2017?Answer20172018 c. Is the change in productivity a positive or negative development?AnswerPositiveNegative d. Compute the company’s ROA for 2018 and for 2017.Note: Round answers to one decimal places (example: 10.4%). ROA 2018 Answer 2017 Answerarrow_forwardUse the following tables to answer the question: LOGIC COMPANY Income Statement For years ended December 31, 2016 and 2017 (values in $) 2016 2017 Gross sales 19,800 15,600 Sales returns and allowances 900 100 Net sales 18,900 15,500 COGS 11,800 8,800 Gross profit 7,100 6,700 Depreciation 780 640 Selling and administrative expenses 2,800 2,400 Research 630 540 Miscellaneous 440 340 Total operating expenses 4,650 3,920 Income before interest and taxes 2,450 2,780 Interest expense 640 540 Income before taxes 1,810 2,240 Provision for taxes 724 896 LOGIC COMPANY Balance Sheet For years ended December 31, 2016 and 2017 (values in $) 2016 2017 Current assets 12,300 9,400 Accounts receivable 16,900 12,900 Merchandise inventory 8,900 14,400 Prepaid expenses 24,400 10,400 Total current assets 62,500 47,100 Building (net) 14,900 11,400 Land 13,900 9,400 Total plant and equipment 28,800 20,800 Total assets 91,300 67,900 Accounts payable 13,400 7,400 Salaries payable 7,500 5,400 Total current…arrow_forwardI need assistance calculating ratios with the attached income statement and balance sheet: Fiscal 2017 Fiscal 2016 Gross margin, as reported 35.6% 35.2% Mark-to-market effects (0.1) (0.4) Restructuring costs 0.3 0.5 Project-related costs 0.3 0.3 Adjusted gross margin 36.1% 35.6% Calculate the following financial ratios for 2016 and 2017 1. Gross profit percentage 2. Return on sales 3. Asset turnover (2015, total assets = $21,932.0 million)arrow_forward
- GIVE THE COMPARATIVE INCOME STATEMENT HORIZONTAL AND VERTICAL ANALYSIS FROM THE FOLLOWING INCOME STATEMENT BELOW JOLLIBEE INCOME STATEMENT ITEM 2016 2017 2018 2019 2020 Sales/Revenue 113.81B 133.61B 161.17B 179.63B 129.31B Sales Growth - 17.40% 20.62% 11.45% -28.01% Cost of Goods Sold (COGS) incl. D&A - - 132.96B 150.88B 115.39B COGS Growth - - - 13.47% -23.52% COGS excluding D&A 89.27B 105.39B 121.08B 137.38B 100.82B Depreciation & Amortization Expense 4B 4.75B 11.89B 13.5B 14.57B Depreciation 3.93B 4.66B 11.73B 13.34B 14.32B Amortization of Intangibles 68.99M 78.95M 151.82M 145.42M 245.23M Gross Income 20.54B 23.48B 28.21B 28.75B 13.92B Gross Income Growth - 14.30% 20.12% 1.93% -51.57% Gross Profit Margin - - - - 10.77% SG&A Expense - - 17.64B 20.21B 20.42B SGA Growth - - -…arrow_forwardComplete a margin analysis for Associated Industries and answer the questions below. Associated Industries Year Ending Year Ending Change 2016 2017 Gross Margin 43.7% 43.7% 0% Operating Margin 3.9% 3.0% (.9%) Net Margin 3.0% 2.4% (.6%) 1. What was the change to the Operating Margin and what does that indicate for the operation of the business?arrow_forwardA condensed income statement for Weber Associates and a partially completed vertical analysis follow. Required: 1. Complete the vertical analysis by computing each missing line item as a percentage of net revenues. TIP: In the prior year, Cost of Goods Sold was 31 percent of Net Revenues, computed as ($1,397 ÷ $4,571). 2. Does Cost of Goods Sold, as a percentage of Net Revenues, represent better or worse performance in 2019 as compared to 2018? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Complete the vertical analysis by computing each missing line item as a percentage of net revenues. TIP: In the prior year, Cost of Goods Sold was 31 percent of Net Revenues, computed as ($1,397 ÷ $4,571). (Decreases should be indicated by a minus sign. Round your answers to the nearest whole percent.) Net Revenues Cost of Goods Sold Research and Development Expense Sales and Marketing Expense General and Administrative Expense Income from Operations Other…arrow_forward
- GIVE THE COMPARATIVE INCOME STATEMENT VERTICAL ANALYSIS FROM THE FOLLOWING INCOME STATEMENT BELOW JOLLIBEE INCOME STATEMENT ITEM 2016 2017 2018 2019 2020 Sales/Revenue 113.81B 133.61B 161.17B 179.63B 129.31B Sales Growth - 17.40% 20.62% 11.45% -28.01% Cost of Goods Sold (COGS) incl. D&A - - 132.96B 150.88B 115.39B COGS Growth - - - 13.47% -23.52% COGS excluding D&A 89.27B 105.39B 121.08B 137.38B 100.82B Depreciation & Amortization Expense 4B 4.75B 11.89B 13.5B 14.57B Depreciation 3.93B 4.66B 11.73B 13.34B 14.32B Amortization of Intangibles 68.99M 78.95M 151.82M 145.42M 245.23M Gross Income 20.54B 23.48B 28.21B 28.75B 13.92B Gross Income Growth - 14.30% 20.12% 1.93% -51.57% Gross Profit Margin - - - - 10.77% SG&A Expense - - 17.64B 20.21B 20.42B SGA Growth - - - 14.57% 1.02%…arrow_forwardHello, can you help me in this problem of doing the horizontal analysis. below are the data. Horizontal analysis using: 2016 2017 2018 Sales 227,279 251,589 286,378 Less: Cost of Sales 152,108 168,460 194,236 Gross Profit 75,171 83,129 92,142 Less: Selling and Administrative Expenses 38,128 40,728 46,192 Operating Income 37,043 42,401 45,950 Other income and expenses 268 118 409 Net Income Before Finance Charges and Tax 37,311 42,519 46,359 Less: Finance charges 3,212 2,658 2,998 Net Income Before Tax 34,099 39,861 43,361 Less: Income Tax Expense 10,097 11,635 12,828 Net Income After Tax 24,002 28,226 30,533 using the index numbers: Horizontal Anaysis using index numbers 2016 2017 2018 Sales Less: Cost of Sales Gross Profit Less: Selling and Administrative Expenses Operating Income and the increase/decrease method: horizontal using Increase/decrease method 2016 2017 2018 Operating Income…arrow_forwardIn the income statement below, ABC Trade Inc. wants to find the resulting net income for the year 2018 (in million). What is the right amount? Income Statement ($ Million) Year End 2015 2016 2017 2018 Sales 1,234.90 1,251.70 1,300.40 1,334.40 Cost of Sales (679.10) (659.00) (681.30) (667.00) Gross Operating Income Selling & Administration (339.70) (348.60) (351.20) (373.30) Depreciation (47.50) (52.00) (55.90) (75.20) Other Income/Expenses 11.80 7.60 7.00 8.20 Earnings Before Interest and Taxes Interest Income 1.30 1.40 1.70 2.00 Interest Expense (16.20) (15.10) (20.50) (23.70) Pre Tax Income Income Taxes (56.80) (64.20) (67.50) (72.60) Net Income Dividends (38.30) (38.70) (39.80) (40.10) Addition to Retained Earnings Group of answer choices 121.8 108.7 132.7 132.8 No choice givenarrow_forward
- GIVE THE COMPARATIVE INCOME STATEMENT HORIZONTAL ANALYSIS FROM THE FOLLOWING INCOME STATEMENT BELOW JOLLIBEE INCOME STATEMENT ITEM 2016 2017 2018 2019 2020 Sales/Revenue 113.81B 133.61B 161.17B 179.63B 129.31B Sales Growth - 17.40% 20.62% 11.45% -28.01% Cost of Goods Sold (COGS) incl. D&A - - 132.96B 150.88B 115.39B COGS Growth - - - 13.47% -23.52% COGS excluding D&A 89.27B 105.39B 121.08B 137.38B 100.82B Depreciation & Amortization Expense 4B 4.75B 11.89B 13.5B 14.57B Depreciation 3.93B 4.66B 11.73B 13.34B 14.32B Amortization of Intangibles 68.99M 78.95M 151.82M 145.42M 245.23M Gross Income 20.54B 23.48B 28.21B 28.75B 13.92B Gross Income Growth - 14.30% 20.12% 1.93% -51.57% Gross Profit Margin - - - - 10.77% SG&A Expense - - 17.64B 20.21B 20.42B SGA Growth - - - 14.57% 1.02%…arrow_forwardCurrent Attempt in Progress Operating data for Grouper Corp. are presented as follows. Net sales Cost of goods sold Selling expenses Administrative expenses Income tax expense Net income 2022 $840,000 540,120 133,560 57,120 31,920 77,280 2021 $610,000 405,650 80,520 46,970 26,840 50,020 Prepare a schedule showing a vertical analysis for 2022 and 2021. (Round percentages to 1 decimal place, e.g. 12.1%.)arrow_forwardQ1) You are required to calculate the Relative Percentage Change in the company for the blanks below and the Net Profit for the other blanks. Show all working out below including the formula used for each year and include the completed table here. Year 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 Net Profit ($ 000’) <blank> 50 200 150 225 250 <blank> 200 250 260 Relative Percentage Change N/A -50% 300% <blank> 50% 11% -30% 14% 25% <blank> Table 1: Net Profit ($) per financial year Q1 a) Using Excel, create a column chart of the Net Profit calculated in part (a) for the years 2010-2019. label the axis and provide an appropriate title. Q1 b) Using Excel, create a Sparkline of the Relative Percentage Change calculated in part (a) for the years 2011-2019. use the Sparkline options to mark if there are any negative values and include a horizontal axis to easily visualise…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningFinancial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
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: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Financial ratio analysis; Author: The Finance Storyteller;https://www.youtube.com/watch?v=MTq7HuvoGck;License: Standard Youtube License