MANAGERIAL ACCOUNTING >C<
3rd Edition
ISBN: 9781259948503
Author: Whitecotton
Publisher: MCG CUSTOM
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
Hello, 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…
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
Horizontal analysis of income statement
(What did I do wrong? Anyone know the correct answers to the ones I got wrong?)
For 20Y2, McDade Company reported a decline in net income. At the end of the year, T. Burrows, the president, is presented with the following condensed comparative income statement:
McDade Company
Comparative Income Statement
For the Years Ended December 31, 20Y2 and 20Y1
20Y2
20Y1
Sales
$ 16,800,000
$ 15,000,000
Cost of goods sold
(11,500,000)
(10,000,000)
Gross profit
$ 5,300,000
$ 5,000,000
Selling expenses
$ (1,770,000)
$ (1,500,000)
Administrative expenses
(1,220,000)
(1,000,000)
Total operating expenses
$ (2,990,000)
$ (2,500,000)
Operating income
$ 2,310,000
$ 2,500,000
Other revenue
256,950
225,000
Income before income tax expense
$ 2,566,950
$ 2,725,000
Income tax expense
(1,413,000)
(1,500,000)
Net income
$ 1,153,950
$ 1,225,000
1. Prepare a comparative income statement with horizontal analysis for the two-year period,…
Chapter 13 Solutions
MANAGERIAL ACCOUNTING >C<
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
- 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 2018 2017 2016 Sales revenue 100.0% 100.0% 100.0% Cost of goods sold 60.0 63.9 65.0 Expenses 26.0 26.6 27.5arrow_forwardSave Mivatin Products Ltd. reported the following on its 2011 comparative income statement: (In millions) 2011 2010 2009 Net sales $148.5 $139.0 $149.5 Cost of sales 129.5 108.0 114.0 Perform a horizontal analysis of net sales, cost of sales, and gross margin, both in dollar amounts and in percentages, for 2011 and 2010. (Round the percentages to one decimal place, X.X%. Use a minus sign or parentheses to indicate a decrease.) Mivatin Products Ltd. Income Statement - (Adapted) For the Year Ended December 31, 2011 and 2010 Increase/(Decrease) (amounts in millions) 2011 2010 2011 2010 2009 Amt. % Amt % Net sales $148.5 $139.0 $149.5 Cost of sales 129.5 108.0 114.0 Gross marginarrow_forwardSolvency and Profitability Trend Analysis Addai Company has provided the following comparative information: 20Y8 20Y7 20Y6 20Y5 20Y4 Net income $1,078,700 $929,900 $781,400 $667,900 $566,000 Interest expense 366,800 334,800 289,100 220,400 175,500 Income tax expense 345,184 260,372 218,792 173,654 135,840 Total assets (ending balance) 8,226,651 8,779,231 6,276,721 6,620,869 5,020,826 Total stockholders' equity (ending balance) 2,543,681 3,148,667 2,003,133 2,553,135 1,531,881 Average total assets 8,502,941 7,527,976 6,448,795 5,517,391 4,722,930 Average stockholders' equity 2,846,174 2,575,900 2,278,134 2,042,508 1,808,307 You have been asked to evaluate the historical performance of the company over the last five years. Selected industry ratios have remained relatively steady at the following levels for the last five years:…arrow_forward
- Solvency and Profitability Trend Analysis Addai Company has provided the following comparative information: 20Y8 20Y7 20Y6 20Y5 20Y4 Net income $1,078,700 $929,900 $781,400 $667,900 $566,000 Interest expense 366,800 334,800 289,100 220,400 175,500 Income tax expense 345,184 260,372 218,792 173,654 135,840 Total assets (ending balance) 8,226,651 8,779,231 6,276,721 6,620,869 5,020,826 Total stockholders' equity (ending balance) 2,543,681 3,148,667 2,003,133 2,553,135 1,531,881 Average total assets 8,502,941 7,527,976 6,448,795 5,517,391 4,722,930 Average stockholders' equity 2,846,174 2,575,900 2,278,134 2,042,508 1,808,307 You have been asked to evaluate the historical performance of the company over the last five years. Selected industry ratios have remained relatively steady at the following levels for the last five years:…arrow_forwardComputing 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_forwardHorizontal analysis of income statementFor 2012, McDade Company reported a decline in net income. At the endof the year, T. Burrows, the president, is presented with the followingcondensed comparative income Statement: Instructions 1. Prepare a comparative income statement with horizontal analysis forthe two-year period, using 20Y1 as the base year. Round percentages toone decimal place.2. To the extent the data permit, comment on the significant relationshipsrevealed by the horizontal analysis prepared in (1).arrow_forward
- Solvency and Profitability Trend Analysis Crosby Company has provided the following comparative information: 20Y8 20Y7 20Y6 20Y5 20Y4 Net income $5,571,720 $3,714,480 $2,772,000 $1,848,000 $1,400,000 Interest expense 1,052,060 891,576 768,600 610,000 500,000 Income tax expense 1,225,572 845,222 640,320 441,600 320,000 Total assets (ending balance) 29,378,491 22,598,839 17,120,333 12,588,480 10,152,000 Total stockholders’ equity (ending balance) 18,706,200 13,134,480 9,420,000 6,648,000 4,800,000 Average total assets 25,988,665 19,859,586 14,854,406 11,370,240 8,676,000 Average total stockholders' equity 15,920,340 11,277,240 8,034,000 5,724,000 4,100,000 You have been asked to evaluate the historical performance of the company over the last five years. Selected industry ratios have remained relatively steady at the following levels for the last five years: 20Y4–20Y8…arrow_forwardAnalysis and Interpretation of ProfitabilityBalance sheets and income statements for 3M Company follow. 3M COMPANY Consolidated Statements of Income For Years ended December 31 ($ millions) 2018 2017 Net sales $32,765 $31,657 Operating expenses Cost of sales 16,682 16,055 Selling, general and administrative expenses 7,602 6,626 Research, development and related expenses 1,821 1,870 Gain on sale of businesses (547) (586) Total operating expenses 25,558 23,965 Operating income 7,207 7,692 Other expense, net* 207 144 Income before income taxes 7,000 7,548 Provision for income taxes 1,637 2,679 Net income including noncontrolling interest 5,363 4,869 Less: Net income attributable to noncontrolling interest 14 11 Net income attributable to 3M $ 5,349 $ 4,858 *Interest expense, gross $350 million in 2018 and $322 million in 2017. 3M COMPANY Consolidated Balance Sheets At December 31 ($ millions, except per share amount) 2018 2017…arrow_forwardCalculate profitability measures The following information was available for the year ended December 31, 2013: Sales ....................................... $200,000Net income ............................. 30,000Average total assets ................ 500,000Average total stockholders’equity .................................. 300,000Dividends per share ................ $ 1.20Earnings per share .................. 3.00Market price per shareat year-end .......................... 48.00 Required:a. Calculate margin, turnover, and ROI for the year ended December 31, 2013.b. Calculate ROE for the year ended December 31, 2013.c. Calculate the price/earnings ratio for 2013.d. Calculate the dividend payout ratio for 2013.e. Calculate the dividend yield for 2013.arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
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 ratio analysis; Author: The Finance Storyteller;https://www.youtube.com/watch?v=MTq7HuvoGck;License: Standard Youtube License