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 1E
To determine
(a)
Introduction:
Horizontal analysis is an analysis used to compare the historical data. It shows the changes in the amount of financial statements over the period of time.
To prepare:
Horizontal analysis and compare the changes that have taken place in the price of gas to the changes in total revenue and cost of crude oil.
To determine
(b)
Introduction:
Vertical analysis helps to express each financial statement line item as a percentage of the base year.
To prepare:
Vertical analysis and compare the gross profit per total revenue for both the years.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
The average price of a gallon of gas in 2015 dropped $0.94 (28 percent) from $3.34 in 2014 (to $2.40 in 2015)
conduct a horizontal analysis by calculating the year-over-year changes in each line item, expressed in dollars and in percentages for the income statement of Insignia Corporation for the year ended December 31, 2015 (amounts in billions). (Decreases should be indicated by a minus sign)
The average price of a gallon of gas in 2018 increased $0.30 (12.4 percent) from $2.42 in 2017 to $2.72 in 2018.
Required:
1. Conduct a horizontal analysis by calculating the year-over-year changes in each line item, expressed in dollars and in percentages
for the income statement of Bronze, Incorporated for the year ended December 31, 2018 (amounts in billions).
2-a. Conduct a vertical analysis by expressing each line as a percentage of total revenues.
2-b. Excluding income tax and other operating costs, did Bronze earn more gross profit per dollar of revenue in 2018 compared to
2017?
Complete this question by entering your answers in the tabs below.
Req 1
Req 2A
Req 2B
Conduct a horizontal analysis by calculating the year-over-year changes in each line item, expressed in dollars and in
percentages for the income statement of Bronze, Incorporated for the year ended December 31, 2018 (amounts in
billions). (Decreases should be indicated by a minus sign. Enter your answers in billions…
Assume the average price of a litre of gas in 2017 jumped $0.16 (15 percent) from $1.06 in 2010 to $1.22 in 2017. Let's see whether this
change is reflected in the income statement of Petroleum Inc. for the year ended December 31, 2017 (amounts in billions).
2017
2016
Total Revenues
$ 574 $ 524
Costs of Crude Oil and Products
356
397
Other Operating Costs
57
54
Income Before Income Tax Expense
Income Tax Expense
161
73
71
29
Net Income
90 $
44
Required:
1-a. Compute the gross profit percentage for each year. (Round your answers to 1 decimal place.)
Gross Profit
2017
%
2016
1-b. Not available in Connect.
2-a. Compute the net profit margin for each year. (Round your answers to 1 decimal place.)
Net Profit
2017
%
2016
%
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
- The average price of a gallon of gas in 2018 increased $0.30 (12.4 percent) from $2.42 in 2017 to $2.72 in 2018. Let's see whether these changes are reflected in the income statement of Tiger Industries for the year ended December 31, 2018 (amounts in billions). Revenues Costs of Purchased Crude Oil and Products Other Operating Costs Income before Income Tax Expense Income Tax Expense Net Income 2018 $ 239 137 72 30 9 $ 21 2017 $ 202 108 81 13 $13 Required: 1. Compute the gross profit percentage for each year. Assuming the change from 2017 to 2018 is the beginning of a sustained trend, is Tiger likely to earn more or less gross profit from each dollar of sales in 2019? 2. Compute the net profit margin for each year. Did Tiger do a better or worse job of controlling expenses other than the costs of crude oil and products in 2018 relative to 2017? 3. Tiger reported average net fixed assets of $364 billion in 2018 and $362 billion in 2017. Compute the fixed asset turnover ratios for both…arrow_forwardThe average price of a gallon of gas in 2018 increased $0.30 (12.4 percent) from $2.42 in 2017 to $2.72 in 2018. Let's see whether these changes are reflected in the income statement of Bronze, Incorporated for the year ended December 31, 2018 (amounts in billions). Revenues Costs of Purchased Crude Oil and Products Other Operating Costs Income before Income Tax Expense Income Tax Expense Net Income 2018 $ 252 144 76 32 9 $ 23 Required 1 Required 2 Required 3 Required 4 Required: 1. Compute the gross profit percentage for each year. Assuming the change from 2017 to 2018 is the beginning of a sustained trend, is Bronze likely to earn more or less gross profit from each dollar of sales in 2019? 2. Compute the net profit margin for each year. Did Bronze do a better or worse job of controlling expenses other than the costs of crude oil and products in 2018 relative to 2017? 3. Bronze reported average net fixed assets of $366 billion in 2018 and $364 billion in 2017. Compute the fixed asset…arrow_forwardThe average price of a gallon of gas in 2018 increased $0.30 (12.4 percent) from $2.42 in 2017 to $2.72 in 2018. Let's see whether these changes are reflected in the income statement of Bronze, Incorporated for the year ended December 31, 2018 (amounts in billions). Revenues Costs of Purchased Crude Oil and Products Other Operating Costs Income before Income Tax Expense Income Tax Expense Net Income 2018 $ 252 144 76 32 9 $ 23 2017 $ 214 115 86 13 $ 13 Required: 1. Compute the gross profit percentage for each year. Assuming that the change from 2017 to 2018 is the beginning of a sustained trend, is Bronze likely to earn more or less gross profit from each dollar of sales in 2019? 2. Compute the net profit margin for each year. Did Bronze do a better or worse job of controlling expenses other than the costs of crude oil and products in 2018 relative to 2017. 3. Bronze reported average net fixed assets of $366 billion in 2018 and $364 billion in 2017. Compute the fixed asset turnover…arrow_forward
- The average price of a gallon of gas In 2018 increased $0.30 (12.4 percent) from $2.42 in 2017 to $2.72 in 2018. Let's see whether these changes are reflected in the Income statement of Mango Corporation for the year ended December 31, 2018 (amounts in billons). 2018 2017 $ 232 $ 274 157 Revenues Costs of Purchased Crude oil and Products 124 Other Operating Costs Income before Income Tax Expense 83 93 34 15 Income Tax Expense 10 Net Income $ 24 $ 15 Requlred: 1. Compute the gross profit percentage for each year. Assuming that the change from 2017 to 2018 Is the beginning of a sustalned trend, Is Mango likely to earn more or less gross profit from each dollar of sales in 2019? 2. Compute the net profit margin for each year. Did Mango do a better or worse job of controlling expenses other than the costs of crude oll and products In 2018 relative to 2017. 3. Mango reported average net fixed assets of $374 billion in 2018 and $372 billion in 2017. Compute the fixed asset turnover ratios…arrow_forwardThe average price of a gallon of gas in 2015 dropped $0.94 (28 percent) from $3.34 in 2014 (to $2.40 in 2015). Let’s see whether these changes are reflected in the income statement of Insignia Corporation for the year ended December 31, 2015 (amounts in billions). Insignia reported average net fixed assets of $190 billion in 2015 and $146 billion in 2014. Compute the fixed asset turnover ratios for both years. Did the company better utilize its investment in fixed assets to generate revenues in 2015 or 2014? Insignia reported average stockholders’ equity of $180 billion in 2015 and $146 billion in 2014. The company has not issued preferred stock. Compute the return on equity ratios for both years. Did the company generate greater returns for stockholders in 2015 or 2014?arrow_forwardThe average price of a gallon of gas in 2015 dropped $0.94 (28 percent) from $3.34 in 2014 (to $2.40 in 2015). Let's see whether these changes are reflected in the income statement of Insignia Corporation for the year ended December 31, 2015 (amounts in billions). 2015 $220 2014 $238 Revenues Cost of Purchased Crude Oil and Products Other Operating Costs Income before Income Tax Expense Income Tax Expense 120 126 57 53 43 59 19 22 Net Income $ 24 $ 37 Required: 1. Compute the gross profit percentage for each year. Assuming that the change from 2014 to 2015 is the beginning of a sustained trend, is Insignia likely to earn more or less gross profit from each dollar of sales in 2016? 2. Compute the net profit margin for each year. Given your calculations here and in requirement 1, explain whether Insignia did a better or worse job of controlling expenses other than the costs of crude oil and products in 2015 relative to 2014. 3. Insignia reported average net fixed assets of $165 billion…arrow_forward
- a. Consider the income statement given below and perform Percentage Change Analysis for the entire Income Statement.b. Comment on what changes PepsiCo has observed as they move from the year 2009 to the year 2010arrow_forwardDetermine the approximate percentage appreciation or depreciation of the NASDAQ Composite, Dow Jones Industrial Average, and the S&P 500 for the last 12 months and provide these figures. In addition to showing the percentage change of each index for the last 12 months, also supply the current value of each index.arrow_forwardFind online the annual 10-K report for Costco Wholesale Corporation (COST) for fiscal year 2015 (filed in October 2015). a. Compute Costco's net profit margin, total asset turnover, and equity multiplier. b. Verify the DuPont Identity for Costco's ROE. c. If Costco's managers wanted to increase its ROE by 1 percentage point, how much higher would their asset turnover need to be? a. Compute Costco's net profit margin, total asset turnover, and equity multiplier. The net profit margin is %. (Round to two decimal places.) The total asset turnover is (Round to two decimal places.) The equity multiplier is (Round to two decimal places.) b. Verify the DuPont Identity forCostco's ROE. The ROE is %. (Round to two decimal places.) c. If Costco's managers wanted to increase its ROE by 1 percentage point, how much higher would their asset turnover need to be? The total assets turnover should be (Round to two decimal places.) The total asset turnover should be % (Round to two decimal places and…arrow_forward
- For 2014, Lindell Company reported its most significant decline in net income in years. At the end of the year, H. Finn, the president, is presented with the following condensed comparative income statement: Instructions1. Prepare a comparative income statement with horizontal analysis for the two-year period, using 2013 as the base year. Round to one decimal place.2. To the extent the data permit, comment on the significant relationships revealed by the horizontal analysis prepared in(1).arrow_forwardSelected comparative financial statements of Haroun Company follow. HAROUN COMPANY Comparative Income Statements For Years Ended December 31, 2021-2015 ($ thousands) Sales 2021 Cost of goods sold $ 1,769 1,271 2020 $ 1,549 2019 2018 2017 2016 2015 $ 1,410 $ 1,292 $ 1,206 $ 1,121 $ 919 1,034 889 778 723 676 539 Gross profit 498 515 521 514 483 445 380 Operating expenses Net income 377 295 271 200 173 171 142 $ 121 $ 220 $ 250 $ 314 $ 310 $ 274 $ 238 HAROUN COMPANY Comparative Year-End Balance Sheets December 31, 2021-2015 ($ thousands) Assets Cash Accounts receivable, net Merchandise inventory Other current assets Long-term investments Plant assets, net Total assets Liabilities and Equity 2021 2020 2019 2018 2017 2016 2015 $ 108 773 $ 142 812 $ 148 735 2,797 2,036 1,779 $ 151 564 1,499 $ 157 496 $ 155 $ 160 470 332 1,346 1,144 829 72 65 40 71 60 61 32 e B 220 220 220 220 3,422 3,409 2,982 1,683 $ 7,172 $ 6,464 $ 5,684 $ 4,188 $ 4,019 1,740 1,546 $ 3,596 $ 2,900 1,327 Current liabilities…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
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage LearningFinancial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim 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