In: Finance
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:
On the basis of that information, what will be the forecast for Roberts' 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
Income Statement of Roberts Inc. | ||
Particulars | Last year | Year-end forecast |
($ in millions) | ($ in millions) | |
Sales | 3,000 | 3,150.00 |
Operating costs excluding depreciation | 2,450 | 2,520.00 |
EBITDA | 550 | 630.00 |
Depreciation | 250 | 262.50 |
EBIT | 300 | 367.50 |
Interest | 124 | 124.00 |
EBT | 176 | 243.50 |
Taxes (25%) | 44 | 60.88 |
Net income | 132 | 182.63 |
From the above income statement we can see that Roberts' year-end net income is $182.63 million.
Excel formulas used: