Fundamentals of Financial Accounting
5th Edition
ISBN: 9780078025914
Author: Fred Phillips Associate Professor, Robert Libby, Patricia Libby
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 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
2014
Revenues
$
245
$
258
Cost of Purchased Crude Oil and Products
125
131
Other Operating Costs
61
55
Income before Income Tax Expense
59
72
Income Tax Expense
28
35
Net Income
$
31
$
37
Required:
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?
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…
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). 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).
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?
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.
Chapter 13 Solutions
Fundamentals of Financial Accounting
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
- 7 According to the producer price index database maintained by the Bureau of Labor Statistics, the average cost of computer equipment fell 3.8 percent between January and December 2016. Let's see whether these changes are reflected in the income statement of Computer Tycoon Inc. for the year ended December 31, 2016. 2016 2015 Sales Revenue $113,000 66,500 46,500 $139,500 76,700 62,800 Cost of Goods Sold Gross Profit Вook Selling, General, and Administrative Expenses Interest Expense Income before Income Tax Expense Income Tax Expense 37,300 39,600 630 540 Hint 8,570 2,000 $ 6,570 22,660 6,300 $ 16,360 Print Net Income erences Required: 1. Compute the gross profit percentage for each year. Assuming that the change from 2015 to 2016 is the beginning of a sustained trend, is Computer Tycoon likely to earn more or less gross profit from each dollar of sales in 2017? 2. Compute the net profit margin for each year. Given your calculations here and in requirement 1, explain whether Computer…arrow_forward7arrow_forwardRamos Company Ramos Company included the following information in its annual report: 2011 2010 2009 Sales $178,400 $162,500 $155,500 Cost of goods sold 115,000 102,500 100,000 Operating expenses 50,000 50,000 45,000 Net income 13,400 10,000 10,500 Refer to the information for Ramos Company. In a common size income statement for 2011, the operating expenses are expressed as: Group of answer choices 100 % 50.6 % 30.3 % 28.0 %arrow_forward
- Ansarrow_forwardIncome 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_forwardProblem 11-17 (Algo) Return on Investment (ROI) and Residual Income [LO11-1, LO11-2] Financial data for Joel de Paris, Inc., for last year follow: Joel de Paris, Inc.Balance Sheet BeginningBalance EndingBalance Assets Cash $ 138,000 $ 134,000 Accounts receivable 342,000 483,000 Inventory 580,000 473,000 Plant and equipment, net 810,000 820,000 Investment in Buisson, S.A. 400,000 435,000 Land (undeveloped) 248,000 250,000 Total assets $ 2,518,000 $ 2,595,000 Liabilities and Stockholders' Equity Accounts payable $ 375,000 $ 340,000 Long-term debt 1,046,000 1,046,000 Stockholders' equity 1,097,000 1,209,000 Total liabilities and stockholders' equity $ 2,518,000 $ 2,595,000 Joel de Paris, Inc.Income Statement Sales $ 5,103,000 Operating expenses 4,235,490 Net operating income 867,510 Interest and taxes:…arrow_forward
- QUESTION: NAYLOR COMPANY HAD $155.400 OF NET INCOME IN 2013 WHEN THE SELLING PRICE PER UNIT WAS $160. THE VARIABLE COSTS PER UNIT WERE $100, AND THE FIXED COSTS WERE $574.200. MANAGEMENT EXPECTS PER UNIT DATA AND TOTAL FIXED COSTS TO REMAIN THE SAME IN 2014. THE PRESIDENT OF NAYLOR COMPANY IS UNDER PRESSURE FROM STOCKHOLDERS TO INCREASE NET INCOME BY $64.200 IN 2014. A) COMPUTE THE NUMBER OF UNITS SOLD IN 2013. B) COMPUTE THE NUMBER OF UNITS THAT WOULD HAVE TO BE SOLD IN 2014 TO REACH THE STOCKHOLDERS' DESIRED PROFIT LEVEL. **ASSUME THAT NAYLOR COMPANY SELLS THE SAME NUMBER OF UNITS IN 2014 AS IT DID IN 2013.arrow_forwardMargin of safety Use the data from E11-12 and assume that break-even sales are $2,798 million. Determine the following for Molson-Coors Brewing Company. Round to one decimal place. Margin of safety expressed as a percentage.arrow_forwardAnalyzing and Assessing Research and Development Expenses Agilent Technologies, Inc., the high-tech spin-off from Hewlett-Packard Company, reports the following operating profit for 2014 in its 10-K ($ millions): Net revenue Products $5,686 Services and other 1,295 Total net revenue 6,981 Costs and expenses Cost of products 2,673 Cost of services and other 715 Total costs 3,388 Research and development 719 Selling, general and administrative 2,043 Total costs and expenses 6,150 Income from operations $831 Required What percentage of its total net revenue is Agilent spending on research and development? Round to one decimal place.arrow_forward
- Intro Income statement for 2016 (in $) 2016 Sales 400,000 Costs (incl. depr.) 280,000 EBIT 120,000 25,000 26,600 68,400 Interest Taxes (28%) Net income Sales are expected to increase by 20% in 2017, while costs including depreciation are expected to reach 60% of sales. Interest expenses and the average tax rate are expected to stay constant. Part 1 Prepare a pro forma income statement for 2017. What is the expected net income?arrow_forwardAccording to the producer price index database maintained by the Bureau of Labor Statistics, the average cost of computer equipment fell 3.8 percent between January and December 2018. Let's see whether these changes are reflected in the income statement of Wizard Computers for the year ended December 31, 2018. Sales Revenue Cost of Goods Sold Gross Profit Selling, General, and Administrative Expenses Interest Expense Income before Income Tax Expense Income Tax Expense Net Income Required: 2018 $ 114,000 67,000 2017 $ 141,000 77,100 47,000 63,900 37,400 39,800 640 545 8,960 2,000 23,555 6,400 $ 6,960 $ 17,155 1. Compute the times interest earned ratios for 2018 and 2017. 2. Does Wizard generate sufficient net income in both years (before taxes and interest) to cover the cost of debt financing? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Compute the times interest earned ratios for 2018 and 2017. (Round your answers to 1 decimal place.) Times…arrow_forwardPro forma income statement The marketing department of Metroline Manufacturing estimates that its sales next year will be $1.58 million. Interest expense is expected to remain unchanged at $32,000, and the firm plans to pay $69,000 in cash dividends. Metroline Manufacturing's income statement for the previous year is given in the table, along with a breakdown of the firm's cost of goods sold and operating expenses into their fixed and variable components. a. Use the percent-of-sales method to prepare a pro forma income statement for next year.arrow_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
Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
Financial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning