Question

Quantitative Problem: At the end of last year, Edwin Inc. reported the following income statement (in...

Quantitative Problem: At the end of last year, Edwin Inc. reported the following income statement (in millions of dollars):

Sales $4,150.00
Operating costs excluding depreciation 3,052.00
EBITDA $1,098.00
Depreciation 320.00
EBIT $778.00
Interest 140.00
EBT $638.00
Taxes (40%) 255.20
Net income $382.80

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.15 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%.

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.

(in millions of dollars)
Sales $  
Operating costs excluding depreciation    
EBITDA $  
Depreciation    
EBIT $  
Interest    
EBT $  
Taxes    
Net income $  

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
At the end of last year, Roberts Inc. reported the following income statement (in millions of...
At the end of last year, Roberts 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 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 70%...
At the end of last year, Roberts Inc. reported the following income statement (in millions of...
At the end of last year, Roberts 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 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 11% higher than the $3 billion in sales generated last year. Year-end operating costs, excluding depreciation, are expected to equal 75%...
At the end of last year, Roberts Inc. reported the following income statement (in millions of...
At the end of last year, Roberts 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 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 8% higher than the $3 billion in sales generated last year. Year-end operating costs, excluding depreciation, are expected to equal 80%...
At the end of last year, Roberts Inc. reported the following income statement (in millions of...
At the end of last year, Roberts 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 15% higher than the $3 billion in sales generated last year. Year-end operating costs, excluding depreciation, are expected to equal 75%...
At the end of last year, Roberts Inc. reported the following income statement (in millions of...
At the end of last year, Roberts 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 10% higher than the $3 billion in sales generated last year. Year-end operating costs, excluding depreciation, are expected to equal 80%...
6.  Problem 16.07 (Pro Forma Income Statement) eBook At the end of last year, Roberts Inc. reported...
6.  Problem 16.07 (Pro Forma Income Statement) eBook At the end of last year, Roberts 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 14% higher than the $3 billion in sales generated last year. Year-end operating costs,...
The AFN equation provides useful insights into the forecasting process, but this equation assumes that all...
The AFN equation provides useful insights into the forecasting process, but this equation assumes that all of the firm's key ratios remain constant, which is not likely to hold true. Consequently, it is useful to forecast the firm's financial statements. The firm begins with forecasting its which then feeds into the firm's balance sheet. Management looks at operating ratios and their relationship with industry and benchmark averages. The forecasted income statement begins with the prior year's income statement and is...
Corporate Valuation and Financial Planning: Forecasted Financial Statements The AFN equation provides useful insights into the...
Corporate Valuation and Financial Planning: Forecasted Financial Statements The AFN equation provides useful insights into the forecasting process, but this equation assumes that all of the firm's key ratios remain constant, which is not likely to hold true. Consequently, it is useful to forecast the firm's financial statements. The firm begins with forecasting its -Select-income statementcashflow statementcash budgetCorrect 1 of Item 1 which then feeds into the firm's balance sheet. Management looks at operating ratios and their relationship with industry...
Corporate Valuation and Financial Planning: Forecasted Financial Statements The AFN equation provides useful insights into the...
Corporate Valuation and Financial Planning: Forecasted Financial Statements The AFN equation provides useful insights into the forecasting process, but this equation assumes that all of the firm's key ratios remain constant, which is not likely to hold true. Consequently, it is useful to forecast the firm's financial statements. The firm begins with forecasting its -Select-income statementcashflow statementcash budget which then feeds into the firm's balance sheet. Management looks at operating ratios and their relationship with industry and benchmark averages. The...
INCOME STATEMENT Edmonds Industries is forecasting the following income statement: Sales $9,000,000 Operating costs excluding depreciation...
INCOME STATEMENT Edmonds Industries is forecasting the following income statement: Sales $9,000,000 Operating costs excluding depreciation & amortization 4,950,000 EBITDA $4,050,000 Depreciation and amortization 900,000 EBIT $3,150,000 Interest 720,000 EBT $2,430,000 Taxes (40%) 972,000 Net income $1,458,000 The CEO would like to see higher sales and a forecasted net income of $2,551,500. Assume that operating costs (excluding depreciation and amortization) are 55% of sales and that depreciation and amortization and interest expenses will increase by 15%. The tax rate, which...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT