Loose-leaf for Fundamentals of Financial Accounting with Connect
5th Edition
ISBN: 9781259619007
Author: Fred Phillips Associate Professor
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Question
Chapter 13, Problem 13.1E
1)
To determine
To Conduct: A Horizontal analysis by calculating the year-over-year changes of CorporationC and the effect of change in gas price comparing to the changes in CorporationC’s total revenue, cost of crude oil and products.
2)
To determine
vertical analysis by expressing each line as a percentage of total revenues and to find out whether Company C earned more revenue in 20 l3 compared to 2012
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these 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 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…
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…
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)
Chapter 13 Solutions
Loose-leaf for Fundamentals of Financial Accounting with Connect
Ch. 13 - What is the general goal of trend analysis?Ch. 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 - Prob. 6QCh. 13 - Slow Cellars current ratio increased from 1.2 to...Ch. 13 - From last year to this year, Colossal Companys...Ch. 13 - From last year to this year, Berry Bam reported...Ch. 13 - Explain whether the following situations, taken...
Ch. 13 - What are the two essential characteristics of...Ch. 13 - Prob. 12QCh. 13 - Prob. 13QCh. 13 - Prob. 14QCh. 13 - Prob. 15QCh. 13 - Prob. 16QCh. 13 - 1. Which of the following ratios is not used to...Ch. 13 - Prob. 2MCCh. 13 - Prob. 3MCCh. 13 - Analysts use ratios to a. Compare different...Ch. 13 - Which of the following ratios incorporates stock...Ch. 13 - Prob. 6MCCh. 13 - Prob. 7MCCh. 13 - A bank is least likely to use which of the...Ch. 13 - Prob. 9MCCh. 13 - (Supplement 13A) Which of the following items is...Ch. 13 - Calculations for Horizontal Analyses Using the...Ch. 13 - Calculations for Vertical Analyses Refer to M13-1....Ch. 13 - Interpreting Horizontal Analyses Refer to the...Ch. 13 - Interpreting Vertical Analyses Refer to the...Ch. 13 - Prob. 13.5MECh. 13 - Prob. 13.6MECh. 13 - Prob. 13.7MECh. 13 - Analyzing the Inventory Turnover Ratio A...Ch. 13 - Inferring Financial Information Using the Current...Ch. 13 - Prob. 13.10MECh. 13 - Identifying Relevant Ratios Identify the ratio...Ch. 13 - Prob. 13.12MECh. 13 - Analyzing the Impact of Accounting Alternatives...Ch. 13 - Describing the Effect of Accounting Decisions on...Ch. 13 - Prob. 13.1ECh. 13 - Prob. 13.2ECh. 13 - Prob. 13.3ECh. 13 - Computing Profitability Ratios Use the information...Ch. 13 - Prob. 13.5ECh. 13 - Matching Each Ratio with Its Computational Formula...Ch. 13 - Computing and Interpreting Selected Liquidity...Ch. 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.14ECh. 13 - Analyzing the Impact of Alternative Inventory...Ch. 13 - Prob. 13.1CPCh. 13 - Analyzing Comparative Financial Statements Using...Ch. 13 - Prob. 13.3CPCh. 13 - Prob. 13.4CPCh. 13 - Prob. 13.5CPCh. 13 - Prob. 13.6CPCh. 13 - Prob. 13.7CPCh. 13 - Prob. 13.1PACh. 13 - Analyzing Comparative Financial Statements Using...Ch. 13 - Prob. 13.3PACh. 13 - Prob. 13.4PACh. 13 - Interpreting Profitability, Liquidity, Solvency,...Ch. 13 - Using Ratios to Compare Loan Requests from Two...Ch. 13 - Prob. 13.7PACh. 13 - Prob. 13.1PBCh. 13 - Prob. 13.2PBCh. 13 - Prob. 13.3PBCh. 13 - Prob. 13.4PBCh. 13 - Interpreting Profitability, Liquidity, Solvency,...Ch. 13 - Using Ratios to Compare Loan Requests from Two...Ch. 13 - Prob. 13.7PBCh. 13 - Prob. 13.1SDCCh. 13 - Prob. 13.2SDCCh. 13 - Prob. 13.5SDCCh. 13 - Prob. 13.6SDCCh. 13 - Prob. 13.7SDCCh. 13 - Prob. 13.1CC
Knowledge Booster
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 vertical analysis by expressing each line as a percentage of total revenues. (Round percentage values to 1 decimal place.)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_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_forward
- Q. Using 2008 as the base year, prepare a trend analysis of the following data, and tell whether the situation shown by the trends is favorable or unfavorable. (Round your answers to one decimal place.). 2012 2011 2010 2009 2008 Net sales $25,520 $23,980 $24,200 $22,880 $22,000 Cost of goods sold 17,220 15,400 15,540 14,700 14,000 General and administrative expenses 5,280 5,184 5,088 4,896 4,800 Operating income 3,020 3,396 3,572 3,284 3,200arrow_forwardIncome Statement for Xenon Manufacturing: 2008 2009 Total sales 202 212 Cost of sales…arrow_forwardProblems in Financial Statement Analysis Shera Company just completed its second year of operations. The comparative income statements for these years a as follows: Prepare the horizontal analysis 2012 2013 Sales revenue Less: Cost of goods sold Gross margin $500,000 300,000 $200,000 80,000 20,000 $100,000 34,000 $66.000 $800,000 464,000 $336,000 Operating expenses Interest expense 164,000 20,000 $152,000 51,680 Income before taxes Income taxes Net Income $100.320 Selected information from the balance sheet for 2013 is also given. Prepare the vertical analysis Current assets $100,000 Long term 400,000 assets $500.000 $80,000 Total assets Current liabilities Long term liabilities 220,000 Total liabilities $300.000 $100,000 100,000 Common stock Retained earnings Total equity $200.000 Shera had 100,000 shares of stock outstanding. At the end of 2013, a share had a market value of $1.80. The shares outstanding have not changed since the original issue. Dividends of $30,000 were paid in…arrow_forward
- 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). 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 Insignia Corporation for the year ended December 31, 2015 (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 Insignia earn more profit per dollar of revenue in 2015 compared to 2014?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. 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…arrow_forwardAssume the average cost of computer equipment fell 24.5 percent between 2016 and 2017. Let’s see whether these changes are reflected in the income statement of Computer Tycoon Inc. for the year ended December 31, 2017. 2017 2016 Sales Revenues $ 100,300 $ 128,468 Cost of Goods Sold 61,700 77,081 Gross Profit 38,600 51,387 Selling, General, and Administrative Expenses 30,200 30,200 Interest Expense 586 480 Income Before Income Tax Expense 7,814 20,707 Income Tax Expense 4,708 6,737 Net Income $ 3,106 $ 13,970 Required: 1-a. Conduct a horizontal analysis by calculating the year-over-year changes in each line item, expressed in dollars and in percentages. (Round your "Percentage" to 1 decimal place. Any decrease in amounts should be indicated with minus sign)arrow_forward
- Income statement for 2016 (in $) Sales 2016 360,000 Costs (incl. depr.) 252,000 EBIT 108,000 Interest 25,000 Taxes (28%) 23,240 Net income 59,760 Sales are expected to increase by 10% in 2017, while costs including depreciation are expected to reach 60% of sales. Interest expenses and the average tax rate are expected to stay constantarrow_forwardYear Under Armour Performances NS Trend (Base Year: Previous Year) Net Sales 2009 $856,411,000.00 N.A. 2010 $1,063,927,000.00 2011 $1,472,684,000.00 2012 $1,834,921,000.00 2013 $2,332,051,000.00 2014 $3,084,370,000.00 2015 $3,963,313,000.00 2016 $4,825,335,000.00 2017 $4,976,553,000.00 2018 $5,193,185,000.00 2019 $5,267,132,000.00 2020 $4,474,667,000.00 2021 $5,683,466,000.00 2022 $1,300,945,000.00 43 NS Trend (Base Year: 2009) N.A.arrow_forward2011 Cost of goods sold. $4,878 Interest 238 Dividends. 420 Depreciation 789 Change in retained earnings 631 Tax rate 34% What is operating cash flow for 2011?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSON
Intermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill Education
Financial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education