Sales Operating costs excluding depreciation EBITDA Depreciation EBIT Interest em: At the end of last year, Edwin Inc. reported the following income statement (in millions of dollars): EBT $791.00 Taxes (40%) 316.40 $474.60 Net income Looking ahead to the following year, the company's CFO has assembled this information: • Year-end sales are expected to be 6% higher than $4.3 billion in sales generated last year. • Year-end operating costs, excluding depreciation, will equal 80% of sales. • Depreciation costs are expected to increase at the same rate as sales. . Interest costs are expected to remain unchanged. • The tax rate is expected to remain at 40%. $4,300.00 3,019.00 $1,281.00 340.00 $941.00 150.00 On the basis of this information, what will be the forecast for Edwin's year-end net income? Enter your answers in millions. For example, an answer of $10,550,000 should be entered as 10.55. Enter all values as positive numbers. Do not round intermediate calculations. Round your answers to two decimal places. Sales Operating costs excluding depreciation EBITDA Depreciation EBIT www Interest EBT Taxes Net income (in millions of dollars) $ $ $ $ $

Sales Operating costs excluding depreciation EBITDA Depreciation EBIT Interest em: At the end of last year, Edwin Inc. reported the following income statement (in millions of dollars): EBT $791.00 Taxes (40%) 316.40 $474.60 Net income Looking ahead to the following year, the company's CFO has assembled this information: • Year-end sales are expected to be 6% higher than $4.3 billion in sales generated last year. • Year-end operating costs, excluding depreciation, will equal 80% of sales. • Depreciation costs are expected to increase at the same rate as sales. . Interest costs are expected to remain unchanged. • The tax rate is expected to remain at 40%. $4,300.00 3,019.00 $1,281.00 340.00 $941.00 150.00 On the basis of this information, what will be the forecast for Edwin's year-end net income? Enter your answers in millions. For example, an answer of $10,550,000 should be entered as 10.55. Enter all values as positive numbers. Do not round intermediate calculations. Round your answers to two decimal places. Sales Operating costs excluding depreciation EBITDA Depreciation EBIT www Interest EBT Taxes Net income (in millions of dollars) $ $ $ $ $

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter16: Financial Statement Analysis

Section: Chapter Questions

Problem 2PB

See similar textbooks

Similar questions

Juroe Company provided the following income statement for last year: Juroes balance sheet as of December 31 last year showed total liabilities of 10,250,000, total equity of 6,150,000, and total assets of 16,400,000. Required: 1. Calculate the return on sales. (Note: Round the percent to two decimal places.) 2. CONCEPTUAL CONNECTION Briefly explain the meaning of the return on sales ratio, and comment on whether Juroes return on sales ratio appears appropriate.
Quantitative Problem: At the end of last year, Edwin Inc. reported the following income statement (in millions of dollars): Sales Operating costs (excluding depreciation) EBITDA Depreciation $4,280.00 3,021.00 $1,259.00 315.00 $944.00 150.00 $ 794.00 198.50 595.50 Looking ahead to the following year, the company's CFO has assembled this information: EBIT Interest EBT Taxes (25%). Net income Year-end sales are expected to be 6% higher than $4.28 billion in sales generated last year. ▪ Year-end operating costs, excluding depreciation, are expected to increase at the same rates as sales. Depreciation costs are expected to increase at the same rate as sales. Interest costs are expected to remain unchanged. ▪ The tax rate is expected to remain at 25%. On the basis of this information, what will be the forecast for Edwin's year-end net income? Enter your answers as positive values. Enter your answers in millions. For example, an answer of $10,550,000 should be entered as 10.55. Do not round…
Topic: Pro Forma Income Statement At the end of last year, John Inc. reported the following income statement (in millions) Sales $3,000 Operating costs excluding depreciation 2450 EBITDA $ 550 Depreciation 250 EBIT $ 300 Interest 125 EBT $ 175 Taxes (40%) 70 Net Income $ 105 Looking ahead to the following year, the company's CFO has assembled this information: - Year-end sales are expected to be 10% higher than the $3 billion in sales generated last year. - Year-end operating costs, excluding depreciation, are expected to equal 80% of year-end…
Quantitative Problem: At the end of last year, Edwin Inc. reported the following income statement (in millions of dollars): Sales $4,300.00 Operating costs (excluding depreciation) 3,095.00 EBITDA $1,205.00 Depreciation 325.00 EBIT $880.00 Interest 160.00 EBT $720.00 Taxes (40%) 288.00 Net income $432.00 Looking ahead to the following year, the company's CFO has assembled this information: Year-end sales are expected to be 6% higher than $4.3 billion in sales generated last year. Year-end operating costs, excluding depreciation, are expected to increase at the same rates as sales. Depreciation costs are expected to increase at the same rate as sales. Interest costs are expected to remain unchanged. The tax rate is expected to remain at 40%. On the basis of this information, what will be the forecast for Edwin's year-end net income? Round your answers to two decimal places. Do not round intermediate calculations. Enter all values as positive numbers. (in…
Following are financial statement numbers and ratios for Martin Corp. for the year ended December 31, Year 1. Total revenue (in millions) $47,248 Net operating profit margin (NOPM) 8.8% Net operating asset turnover (NOAT) 3.3 If we expected revenue growth of 3.5% in the next year, what would projected revenue be for Year 2? Select one: a. $47,248.0 b. $44,598.3 c. None of these are correct d. $48,901.7 e. $53,205.0
PRO FORMA INCOME STATEMENT At the end of last year, Roberts Inc. reported the follow- ing income statement (in millions of dollars): 17-7 Sales $3,000 Operating costs excluding depreciation 2,450 ЕВITDA $ 550 Depreciation 250 EBIT $ 300 Interest 125 EBT $ 175 Taxes (40%) 70 Net income $ 105 Looking ahead to the following year, the company's CFO has assembled this information: • Year-end sales are expected to be 10% higher than the $3 billion in sales generated last year. Year-end operating costs, excluding depreciation, are expected to equal 80% of year- end sales. Depreciation is expected to increase at the same rate as sales. Interest costs are expected to remain unchanged. The tax rate is expected to remain at 40%. On the basis of that information, what will be the forecast for Roberts' year-end net income? 17-8 LONG-TERM FINANCING NEEDED At year-end 2018, total assets for Arrington Inc. were $1.8 million and accounts payable were $450,000. Sales, which in 2018 were $3.0 million,…
At the end of last year, Ralph Inc. reported the following income statement (in millions of dollars): Sales $3,000 Operating costs excluding depreciation 2,450 EBITDA $550 Depreciation 250 EBIT $300 Interest 124 EBT $176 Taxes (25%) 44 Net income $132 Looking ahead to the following year, the company's CFO has assembled this information: Year-end sales are expected to be 8% higher than the $3 billion in sales generated last year. Year-end operating costs, excluding depreciation, are expected to equal 65% of year-end sales. Depreciation is expected to increase at the same rate as sales. Interest costs are expected to remain unchanged. The tax rate is expected to remain at 25%. On the basis of that information, what will be the forecast for Ralphs' year-end net income? Enter your answer in millions. For example, an answer of $25,400,000 should be entered as 25.40. Do not round intermediate calculations. Round your answer to two decimal places. $( )million
Following are financial statement numbers and ratios for Salsa Incorporated for the year ended December 31, Year 1 (in millions). NOPAT $572.7 NOA $3,460.8 Net operating profit margin (NOPM) 15.9% Net operating asset turnover (NOAT) 1.04If we expected revenue growth of 7% in the next year, what would projected revenue be for the year ended December 31, Year 2?
APX Co achieved $16 million revenue in the year that has just ended and expects revenue growth of 8.4% in the next year. Cost of sales in the year that has just ended was $10.88 million and other expenses were $1.44 million. The financial statements of APX for the year that has just ended contain the following statement of financial position: $m $m Non-current assets 22.0 Current assets 2.4 Inventory 2.2 Trade Receivables 4.6 Total Assets 26.6 $m $m Equity Finance 5.0 Ordinary Shares 7.5 Reserves 12.5 Long-term bank loan 10.0 22.5 Current Liabilities 1.9 Trade Payables 2.2 Overdraft 4.1 Total equity and liabilities 26.6 The long-term bank loan has a fixed annual interest rate of 8% per year. APX pays taxation at an annual rate of 30% per year.…
Following is information from Skyway Inc. for the year (in thousands). Total annual revenue $3,206,980 Total revenue growth rate 5.0% Terminal revenue growth rate 2% Net operating profit margin (NOPM) 8.2% Net operating asset turnover (NOAT) 3.42 Projected total revenue for the following year would be: Select one: a. $3,469,952 b. None of these are correct c. $3,316,659 d. $3,271,120 e. $3,367,329
Calculating the Average Total Assets and the Return on Assets The income statement, statement of retained earnings, and balance sheet for Santiago Systems are as follows: Santiago Systems Income Statement For the Year Ended December 31, 20X2 Amount Percent Net sales $5,345,000 100.0% Less: Cost of goods sold (3,474,250) 65.0 Gross margin $1,870,750 35.0 Less: Operating expenses (1,140,300) 21.3 Operating income $730,450 13.7 Less: Interest expense (27,000) 0.5 Income before taxes Less: Income taxes (40%)* $703,450 13.2 (281,380) 5.3 Net income $422,070 7.9 * Includes both state and federal taxes.
Margin, Turnover, Return on Investment, Average OperatingAssetsElway Company provided the following income statement for the last year:Sales $1,040,000,000Less: Variable expenses 700,250,000Contribution margin $ 339,750,000Less: Fixed expenses 183,750,000Operating income $ 156,000,000At the beginning of last year, Elway had $28,300,000 in operating assets. At the end of the year,Elway had $23,700,000 in operating assets.Required:1. Compute average operating assets.2. Compute the margin and turnover ratios for last year. (Note: Round the answer formargin ratio to two decimal places.)3. Compute ROI. (Note: Round answer to two decimal places.)4. CONCEPTUAL CONNECTION Briefly explain the meaning of ROI.5. CONCEPTUAL CONNECTION Comment on why the ROI for Elway Company isrelatively high (as compared to the lower ROI of a typical manufacturing company).