FUND OF FIN ACCT W/CONNECT (LL)>CUSTOM
5th Edition
ISBN: 9781259684654
Author: PHILLIPS
Publisher: MCG CUSTOM
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 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 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?
Chapter 13 Solutions
FUND OF FIN ACCT W/CONNECT (LL)>CUSTOM
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 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.arrow_forwardCompute trend percentages for the following items taken from the financial statements of Lopez Plumbing over a five-year period. Treat 2014 as the base year. State whether the trends are favorable or unfavorable. (Dollar amounts are stated in thousands.) 2018 2017 2016 2015 2014 Sales $81,400 $74,000 $61,500 $59,000 $50,000 Cost of Goods Sold 58,500 48,000 40,500 37,000 30,000arrow_forward
- The income statement of Carlson Company for the year ended March 31,2012 are as follows: (in million of pesos) 2012 2011 Sales P 320.5 P305.4 Cost of sales 274.1 253.9 Gross profit 46.4 51.5 Distribution costs 11.6 10.4 Administrative expenses 22.6 23.5 Other operating income 4.5 6.4 Earnings before interest and taxes 16.7 24.0 .Interest charges 1.9 4.3 .Earnings before taxes 14.8 19.7 Which of the following is correct?a. The company sold more goods by volume in 2012 than in 2011.b. The gross margin as a percentage of sales was higher in 2012 than in 2011.c. The increase in distribution costs in 2012 over and above the 2011 amount isdue to the higher sales turnover.d. The net profit margin as a percentage of sales fell in 2012 and about 2/3 ofthe 2011 level.arrow_forwardAnalyzing the quality of firm earnings) Kabutell, Inc. had net income of ,$ 800,000 cash flow from financing activities of $60,000 , depreciation expenses of $60,000 , and cash flow from operating activities of $500,000 . a. Calculate the quality of earnings ratio. What does this ratio tell you? b. Kabutell, Inc. reported the following in its annual reports for 2011–2013: ($ million) 2011 2012 2013 Cash Flow from Operations $477 $403 $472 Capital Expenditures (CAPEX) $459 $447 $455 a. What is Kabutell's quality of earnings ratio? 62.562.5% (Round to one decimal place.) Part 3 b. What is Kabutell's average capital acquisitions ratio over the three-year period? enter your response here% (Round to one decimal place.)arrow_forwardAnalytical case—comparative analysis of profitability and financialleverage measures The annual reports of the Coca-Cola Co. and PepsiCo, Inc. ,indicate the following for the year ended December 31, 2011 (amounts in millions):Coca-Cola Co. PepsiCo, Inc.Net revenues.................................................................................. $46,452 $66,504Net income..................................................................................... 8,634 6,462Total assets, January 1, 2011......................................................... 72,921 68,153Total liabilities, January 1, 2011 ....................................................... 41,607 46,667Total liabilities, December 31, 2011 ................................................. 48,053 51,983Total stockholders’ equity, December 31, 2011.............................. 31,921 20,899Required:a. Calculate ROI and ROE for each company for 2011. (Hint: You will need to calculate some of the numbers used in the…arrow_forward
- Y plc's income statement for the year ended 31 December 2012 and statements of financial position as at 31 December 2011 and 31 December 2012 were as follows: Y plc - Income statement for the year ended 31 December 2012 £’000 £’000 Sales revenue 360 Raw materials consumed (35) Staff costs (47) Depreciation (59) Loss on disposal of machinery (9) (150) Operating profit 210 Interest payable (14) Profit before tax 196 Income tax expense (62) Profit after tax 134 Y plc – Statement of Financial Position as at 31 December 2012 2012 2011 2011 £'000 £'000 £'000 £'000 Non-current assets Cost 798 780 Depreciation (159) (112) 639 668 Current asset Inventory 12 10 Trade receivables 33 25 Bank 24 28 69 63 708 731 Equity and liabilities Share capital 180 170 Share premium 18 12 Retained earnings 358 257 556 439 Non-current…arrow_forwardXYZ Co. wants to know if its profitability performance has increased from 2009 to 2010. The company had net income of $48,000 in 2009 and $50,000 in 2010. Total assets were $480,000 at the end of 2009, and $560,000 at the end of 2010. Calculate return on assets(ROA) for 2009 and 2010and Comment on the results.arrow_forwardChanges in Various RatiosPresented below is selected information for Brimmer Company: 2013 2012 Sales revenue $911,000 $840,000 Cost of goods sold 576,000 542,000 Interest expense 21,000 20,000 Income tax expense 28,000 24,000 Net income 62,000 52,000 Cash flow from operating activities 66,000 55,000 Capital expenditures 43,000 45,000 Accounts receivable (net), December 31 127,000 120,000 Inventory, December 31 197,000 160,000 Stockholders' equity, December 31 451,000 400,000 Total assets, December 31 731,000 660,000 RequiredCalculate the following ratios for 2013. The 2012 results are given for comparative purposes. Round answers to one decimal place. Use 365 days in a year. 2012 2013 1. Gross profit percentage 35.5% Answer % 2. Return on assets 8.3% Answer % 3. Return on sales 6.2% Answer % 4. Return on common stockholders' equity (no preferred stock was outstanding) 13.9% Answer % 5. Accounts receivable…arrow_forward
- The following information is available for Crest Company: Annual Data 2013 2012 Sales revenue $6,600,000 $6,000,000 Cost of goods sold 4,008,400 3,720,000 Net income 310,300 264,000 Year-End Data Dec. 31, 2013 Dec. 31, 2012 Total assets $2,750,000 $2,360,000 Common stockholders' equity 1,800,800 1,800,000 Calculate the following ratios for 2013: a. Gross profit percentage b. Return on salesarrow_forwardThe following information is available to you for the Wooden Company: 2011 2010 Net Income. 53,394 39,510 Net Sales 233,715 182,795 From the information provided, calculate Wooden’s profit margin ratio for each year. Be sure to show your calculations. 2011 2010 Comment on the results, assuming that the industry average for the profit margin ratio is 25% for each of the two years.arrow_forwardCalculating ROA and Its Components. Nucor, a steel manufacturer, reported net income for 2008 of $1,831 million on sales of $23,663 million. Interest expense for 2008 was $135 million, and noncontrolling interest was $314 million for 2008. The income tax rate is 35%. Total assets were $9,826 million at the beginning of 2008 and $13,874 million at the end of 2008. Compute the rate of ROA for 2008 and disaggregate ROA into profit margin for ROA and assets turnover components.arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning