A condensed income statement for Northeast Airlines and a partially completed vertical analysis are presented below. Required: 1. Complete the vertical analysis by computing each missing line item as a percentage of sales revenues. (Round your answers to the nearest whole percent.) NORTHEAST AIRLINES Income Statement (summarized) For the Year Ended December 31 (in millions of U.S. dollars) 2016 2015 Sales Revenues $ 20,925 100 % $ 20,320 100 % Salaries and Wages Expense 6,823 33 6,408 Fuel, Oil, Repairs, and Maintenance 4,717 4,646 Other Operating Expenses 5,200 4,725 23 Other Expenses (Revenues) 238 1 652 3 Income before Income Tax Expense 3,947 19 3,889 19 Income Tax Expense 1,370 7 1,361 7 Net Income $ 2,577 % $ 2,528

A condensed income statement for Northeast Airlines and a partially completed vertical analysis are presented below. Required: 1. Complete the vertical analysis by computing each missing line item as a percentage of sales revenues. (Round your answers to the nearest whole percent.) NORTHEAST AIRLINES Income Statement (summarized) For the Year Ended December 31 (in millions of U.S. dollars) 2016 2015 Sales Revenues $ 20,925 100 % $ 20,320 100 % Salaries and Wages Expense 6,823 33 6,408 Fuel, Oil, Repairs, and Maintenance 4,717 4,646 Other Operating Expenses 5,200 4,725 23 Other Expenses (Revenues) 238 1 652 3 Income before Income Tax Expense 3,947 19 3,889 19 Income Tax Expense 1,370 7 1,361 7 Net Income $ 2,577 % $ 2,528

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Data for Sherman, Inc. are as follows: Net Sales Cost of Goode Sold Selling and Administrative Expenses Other Expenses Income Tax 2017 $850,000 635,000 50,000 20,000 40,000 Use the editor to format your answer 2016 $798,000 580,000 35,000 15,000 55,000 Prepare a horizontal analysis of the comparative income statement of Sherman, Inc. (Round to one decimal place.) Use a multi-step income statement.
I. Complete the horizontal analysis below. Use the name of the company you belong to in your iLS Activity. Round off your answers to the nearest hundredths. Name: Income Statement for the years ending December 31, 201X and December 31, 201Y 2015 2016 Annual Percentage Growth 2015-2016 Sales 475,000 500,000 1. Cost of Goods Sold 265,000 269,000 2. Gross Profit 210,000 231,000 3. Wages 154,000 163,000 4. Repairs 5,800 4,150 5. Rent 13,000 12,000 6. Taxes 16,940 17,930 7. Office Expenses 1,023 587 8. Total Expenses 190,763 197,667 9. Net Income 19,237 33,333 10. II. Analyze the following ratios (Good/Not good, Undervalued/Overvalued, or just OK) based on the given industry averages. Write the answers in the spaces provided. Ratios Annual Data Industry Average Interpretation Current 5.7 4 Days Sales Outstanding 37 days 42 days Total Debt to Total Capital 47.80% 32.60% Times-Interest Earned 2.2 6 Profit Margin 6.10% 6.00% Return on Invested Capital 10.03% 10.00% Enterprise Value to EBITDA…
Common-Sized Income Statement Revenue and expense data for the current calendar year for Tannenhill Company and for the electronics industry are as follows. Tannenhill's data are expressed in dollars. The electronics industry averages are expressed in percentages. Electronics Tannenhill Industry Company Average Sales $1,540,000 100 % Cost of goods sold 1,016,400 72 Gross profit $523,600 28 % Selling expenses $308,000 15 % Administrative expenses 123,200 7 Total operating expenses $431,200 22 % Operating income $92,400 6 % Other revenue 30,800 2 $123,200 8 % Other expense 15,400 1 Income before income tax $107,800 7 % Income tax expense 46,200 4 Net income $61,600 3 % a. Prepare a common-sized income statement comparing the results of operations for Tannenhill Company with the industry average. If required, round percentages to one decimal place. Enter all amounts as positive numbers. Tannenhill Company Common-Sized Income Statement For the Year Ended December 31 Tannenhill Tannenhill…
The Cullumber Supply Company reported the following information for 2017. Prepare a common-size income statement for the year ended June 30, 2017. (Round answers to 1 decimal place, e.g. 52.7%.) Cullumber Supply CompanyIncome Statement for the Fiscal Year Ended June 30, 2017($ thousands) % of Net Sales Net sales $2,111,000 enter percentages of net sales % Cost of goods sold 1,464,000 enter percentages of net sales % Selling and administrative expenses 312,200 enter percentages of net sales % Nonrecurring expenses 27,600 enter percentages of net sales % Earnings before interest, taxes, depreciation, and amortization (EBITDA) $307,200 enter percentages of net sales % Depreciation 117,000 enter percentages of net sales % Earnings before interest and taxes (EBIT) 190,200 enter percentages of net sales % Interest expense 118,600 enter percentages of net sales % Earnings before taxes (EBT)…
Comparative Income Statements Consider the following income statement data from the Mono Company: Sales revenue Cost of goods sold Selling expenses Administrative expenses Income tax expense 2019 2018 $600,000 $450,000 336,000 279,000 105,000 99,000 60,000 50,000 4,000 3,000 Prepare a contparative income statement, showing increases, and decreases in dollars and in percentages. Note: Round "Percent Change" answers to one decimal place (ex: 0.2345 = 23.5%). Sales Revenue Cost of Goods Sold MONO COMPANY Comparative Income Statements ♦ Selling Expenses Administrative Expenses Total Income before Income Taxes ◆ → $ $ 2019 0 $ 0 0 0 0 oooo 0 0 $ 2018 Increase (Decrease) 0 $ 0 0 0 0 0 0 0 0 $ 0 0 0 0 0 0 0 0 0 Percent Change 0% 0% 0% 0% 0% 0% 0% 0% 0 %
Access the February 21, 2017, filing of the December 31, 2016, 10-K report of The Hershey Company (ticker: HSY) at SEC.gov and complete the following requirements. Required Compute or identify the following profitability ratios of Hershey for its years ending December 31, 2016, and December 31, 2015. Interpret its profitability using the results obtained for these two years. 1. Profit margin ratio (round the percent to one decimal). 2. Gross profit ratio (round the percent to one decimal). 3. Return on total assets (round the percent to one decimal). (Total assets at year-end 2014 were $5,622,870 in thousands.) 4. Return on common stockholders’ equity (round the percent to one decimal). (Total shareholders’ equity at year-end 2014 was $1,519,530 in thousands.) 5. Basic net income per common share (round to the nearest cent).
Calculating the Times-Interest-Earned Ratio Beech Company provided the following income statement for last year: Sales $24,350,735 Cost of goods sold 15,300,000 Gross margin $9,050,735 Operating expenses 4,910,685 Operating income $4,140,050 Interest expense 470,015 Income before taxes $3,670,035 Income taxes 1,461,214 Net income $2,208,821 Required: Calculate the times-interest-earned ratio. Round the answer to one decimal place.times
Vertical analysis Two income statements for Cornea Company follow: Cornea Company Income Statements For the Years Ended December 31 20Y9 20Y8 Fees earned $1,570,000 $1,300,000 Expenses (832,100) (780,000) Net income $737,900 $520,000 Required: a. Prepare a vertical analysis of Cornea Company’s income statements. If required, round your percentage to the nearest whole number. Cornea Company Income Statements For the Years Ended December 31 20Y9 20Y8 Amount Percent Amount Percent Fees earned $1,570,000 % $1,300,000 % Expenses (832,100) % (780,000) % Operating income $737,900 % $520,000 % b. Does the vertical analysis indicate a favorable or an unfavorable trend?
Forecast Income Statement and Balance Sheet Following are the income statement and balance sheet for Medtronic PLC. Note: Complete the entire question using the following Excel template: Excel Template. Then enter the answers into the provided spaces below with two decimal places. Medtronic PLC Consolidated Statement of Income $ millions, For Fiscal Year Ended April 26, 2019 Net sales $30,557 Costs and expenses Cost of products sold 9,155 Research and development expense 979 Selling, general, and administrative expense 10,418 Amortization of intangible assets 1,764 Restructuring charges, net 83 Certain litigation charges, net 166 Other operating expense, net 258 Operating profit 7,734 Other nonoperating income, net (157) Interest expense 1,444 Income before income taxes 6,447 Income tax provision 547 Net income 5,900 Net income loss attributable to noncontrolling interests (19) Net income attributable to Medtronic $5,881…
Calculating the Times-Interest-Earned Ratio Beech Company provided the following income statement for last year: Sales $24,350,735 Cost of goods sold 15,300,000 Gross margin $9,050,735 Operating expenses 4,910,685 Operating income $4,140,050 Interest expense 463,015 Income before taxes $3,677,035 Income taxes 1,461,214 Net income $2,215,821 Required: Calculate the times-interest-earned ratio. Round the answer to one decimal place.fill in the blank 1
Operating data for Sheridan Corporation are presented as follows. Net sales Cost of goods sold Selling expenses Administrative expenses Income tax expense Net income Net sales Cost of goods sold Gross profit Selling expenses Administrative expenses Total operating expenses Income before income taxes Income tax expense $ 2027 Prepare a schedule showing a vertical analysis for 2027 and 2026. (Round percentages to 1 decimal place, e.g. 12.1%.) Net income $ $842,800 530,964 126,420 80,066 37,926 67,424 2026 Amount $645,500 413,120 77,460 50,349 25,820 78,751 2027 SHERIDAN CORPORATION Condensed Income Statements For the Years Ended December 31 Percent % % % % % % % % $ % $ Amount 2026 Percent Ih SUPP
Operating data for Cheyenne Corp. are presented below. 2022 2021 Sales revenue $831,900 $629,500 Cost of goods sold 529,700 410,900 Selling expenses 125,400 74,300 Administrative expenses 79,400 52,000 Income tax expense 37,000 24,500 Net income 60,400 67,800 Prepare a schedule showing a vertical analysis for 2022 and 2021. (Round percentages to 1 decimal place, e.g. 12.1%.)