Original Price: $4.99 Now at: $2.99 Reads (2288)

Forecasting net income using pro forma income statement

Pro forma income statement 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 the following information:

1.Year-end sales are expected to be 10 percent higher than the $3 billion in sales generated last year.

2.Year-end operating costs, excluding depreciation, are expected to equal 80 percent of year-end sales

3. Depreciation is expected to increase at the same rate as sales

4.Interest costs are expected to remain unchanged.

5.The tax rate is expected to remain at 40 percent.

On the basis of this information, what will be the forecast for Robert’s year-end net income?

Click here to download the question

Attached file(s)

Solution Attachment

Solution document is in Excel format