Question

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

Sales	$4,120.00
Operating costs (excluding depreciation)	3,003.00
EBITDA	$1,117.00
Depreciation	310.00
EBIT	$807.00
Interest	160.00
EBT	$647.00
Taxes (25%)	161.75
Net income	$485.25

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.12 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 intermediate calculations. Round your answers to two decimal places.

Edwin Inc. Income Statement
	(in millions of dollars)
Sales	$
Operating costs (excluding depreciation)
EBITDA	$
Depreciation
EBIT	$
Interest
EBT	$
Taxes (25%)
Net income	$

Answer 1

Calculate the income statement as follows:

А В Forecasted amount 135 Particulars $4,367.20 $3,183.18 $1,184.02 $328.60 136 Sales 137 Operating cost 138 EBITDA 139 Depreciation $855.42 140 EBIT $160.00 $695.42 141 Interest 142 ЕВT $173.86 143 Taxes @25% $521.57 144 Net income

Formulas:

А В Forecasted amount 135 Particulars 4120*(1+6%) 136 Sales 137 Operating cost 3003*(1+6%) - B136-B137 =310*(1+6%) -B138-B139 160 -B140-B141 -B142*25% 138 EBITDA 139 Depreciation 140 EBIT 141 Interest 142 ЕВT 143 Taxes @25% 144 Net income B142-B143