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 $220 2014 $238 Revenues Cost of Purchased Crude Oil and Products 120 126 Other Operating Costs Income before Income Tax Expense Income Tax Expense 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 in 2015 and $136 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?

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 $220 2014 $238 Revenues Cost of Purchased Crude Oil and Products 120 126 Other Operating Costs Income before Income Tax Expense Income Tax Expense 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 in 2015 and $136 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?

Corporate Fin Focused Approach

5th Edition

ISBN:9781285660516

Author:EHRHARDT

Publisher:EHRHARDT

Chapter12: Corporate Valuation And Financial Planning

Section: Chapter Questions

Problem 6P

See similar textbooks

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). 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.
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?
Naylor Company had $210,000 of net income in 2016 when the selling price perunit was $150, the variable costs per unit were $90, and the fi xed costs were $570,000.Management expects per unit data and total fi xed costs to remain the same in 2017. Thepresident of Naylor Company is under pressure from stockholders to increase net incomeby $52,000 in 2017.Instructions(a) Compute the number of units sold in 2016.(b) Compute the number of units that would have to be sold in 2017 to reach the stockholders’ desired profi t level.(c) Assume that Naylor Company sells the same number of units in 2017 as it did in 2016.What would the selling price have to be in order to reach the stockholders’ desiredprofi t level?
The marketing department of Metroline Manufacturing estimates that its sales in 2016 will be $1.68 million. Interest expense is expected to remain unchanged at $35,000, and the firm plans to pay $66,000 in cash dividends during 2016. Metroline Manufacturing's income statement for the year ended December 31, 2015, is given 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 the year ended December 31, 2016. b. Use fixed and variable cost data to develop a pro forma income statement for the year ended December 31, 2016. c. Compare and contrast the statements developed in parts a. and b. Which statement probably provides the better estimate of 2016 income? Explain why.
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.
Given the income statement below, Mega Trade Inc. wants to find the resulting net income for the year 2018 (in million). What is the right amount? Income Statement ($ Million) YEAR END YEAR END YEAR END YEAR END 2015 2016 2017 2018 Sales 1,234.90 1,251.70 1,300.40 1,334.40 Cost Sales -679.1 -659 -681.3 -667 Gross Operating Income Selling & Administration -339.7 -348.6 -351.2 -373.3 Depreciation -47.5 -52 -55.9 -75.2 Other Income/Expenses 11.8 7.6 7 8.2 Earnings Before Interest and Taxes Interest Income 1.3 1.4 1.7 2 Interest Expense -16.2 -15.1 -20.5 -23.7 Pre Tax Income Income Taxes -56.8 -64.2 -67.5 -72.6 Net Income Dividends -38.3 -38.7 -39.8 -40.1 Addition to Retained Earnings
“WalkFast” Footwear Ltd. earned 10 million $ in 2017. The cost of goods sold was 4.75 million $. The annual report shows they made a profit of 1.23 million $ before considering the tax. According to the balance sheet, the year ending inventory is of 1.89 million $ and total asset is worth 18million $ now. However, the management is not satisfied with the performance of supply chain. They have instructed to save at least 2% in purchasing. What will be the financial effect if this instruction is fulfilled. Explain using PM, ROA
Given the income statement below, Mega Trade Inc. wants to find the resulting net income for the year 2016 (in million). What is the right amount? Income Statement ($ Million) YEAR END YEAR END YEAR END YEAR END 2015 2016 2017 2018 Sales 1,234.90 1,251.70 1,300.40 1,334.40 Cost Sales -679.1 -659 -681.3 -667 Gross Operating Income Selling & Administration -339.7 -348.6 -351.2 -373.3 Depreciation -47.5 -52 -55.9 -75.2 Other Income/Expenses 11.8 7.6 7 8.2 Earnings Before Interest and Taxes Interest Income 1.3 1.4 1.7 2 Interest Expense -16.2 -15.1 -20.5 -23.7 Pre Tax Income Income Taxes -56.8 -64.2 -67.5 -72.6 Net Income Dividends -38.3 -38.7 -39.8 -40.1
Given the income statement below, Mega Trade Inc. wants to find the resulting net income for the year 2018 (in million). What is the right amount? Income Statement ($ Million) Year End 2015 2016 2017 2018 Sales 1,234.90 1,251.70 1,300.40 1,334.40 Cost of Sales -679.1 -659 -681.3 -667 Selling & Administration -339.7 -348.6 -351.2 -373.3 Depreciation -47.5 -52 -55.9 -75.2 Other Income/Expenses 11.8 7.6 7 8.2 Interest Income 1.3 1.4 1.7 2 Interest Expense -16.2 -15.1 -20.5 -23.7 Income Taxes -56.8 -64.2 -67.5 -72.6 Dividends -38.3 -38.7 -39.8 -40.1 CHOICES: A. 108.7B. 132.7C. No choice givenD. 132.8E. 121.8
During 2010. Raines Umbrella Corp. had sales of $740,000. Cost of goods sold, administrativeand selling expenses, and depreciation expenses were S610,000, $105,000 & $140,000respectively. In addition, the company had an interest expense of $70,000 and tax rate of 35percent.a. What is Raines's net income for 2010?b. What is its operating cash now?c. Explain your results in (a) and (b)