Question

In: Finance

PRO FORMA INCOME STATEMENT At the end of last year, Roberts Inc. reported the following income...

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 this information:

  • Year-end sales are expected to be 14% 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? Enter your answer in millions. For example, an answer of $25,000,000 should be entered as 25. Round your answer to two decimal places.

$___ million

Solutions

Expert Solution


Related Solutions

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 5% higher than the $3 billion in sales generated last year. Year-end operating costs, excluding depreciation, are expected to equal 80%...
eBook At the end of last year, Roberts Inc. reported the following income statement (in millions...
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 11% higher than the $3 billion in sales generated last year. Year-end operating costs, excluding depreciation, are expected to equal...
At the end of last year, Edwin Inc. reported the following income statement (in millions of...
At the end of last year, Edwin Inc. reported the following income statement (in millions of dollars): Sales $4,190.00 Operating costs (excluding depreciation) 3,048.00 EBITDA $1,142.00 Depreciation 325.00 EBIT $817.00 Interest 150.00 EBT $667.00 Taxes (25%) 166.75 Net income $500.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.19 billion in sales generated last year. Year-end operating costs, excluding depreciation, are expected to increase at the...
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,290.00 Operating costs (excluding depreciation) 3,058.00 EBITDA $1,232.00 Depreciation 345.00 EBIT $887.00 Interest 130.00 EBT $757.00 Taxes (40%) 302.80 Net income $454.20 Looking ahead to the following year, the company's CFO has assembled this information: Year-end sales are expected to be 5% higher than $4.29 billion in sales generated last year. Year-end operating costs, excluding depreciation, are expected to increase...
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,100.00 Operating costs excluding depreciation 3,011.00 EBITDA $1,089.00 Depreciation 300.00 EBIT $789.00 Interest 150.00 EBT $639.00 Taxes (40%) 255.60 Net income $383.40 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.1 billion in sales generated last year. Year-end operating costs, excluding depreciation, will equal 60% of...
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 Operating costs excluding depreciation 3,055 EBITDA $1,095 Depreciation 305 EBIT $790 Interest 160 EBT $630 Taxes (40%) 252 Net income $378 Looking ahead to the following year, the company's CFO has assembled this information: •Year-end sales are expected to be 5% higher than $4.15 billion in sales generated last year. •Year-end operating costs, including depreciation, are expected to increase...
PRO FORMA INCOME STATEMENT Austin Grocers recently reported the following 2016 income statement (in millions of...
PRO FORMA INCOME STATEMENT Austin Grocers recently reported the following 2016 income statement (in millions of dollars): Sales $700 Operating costs including depreciation 500 EBIT $200 Interest 40 EBT $160 Taxes (40%) 64 Net income $96 Dividends $32 Addition to retained earnings $64 For the coming year, the company is forecasting a 15% increase in sales, and it expects that its year-end operating costs, including depreciation, will equal 65% of sales. Austin's tax rate, interest expense, and dividend payout ratio...
prepare a 3-year pro forma income statement and pro forma balance sheet, including expected cash flows...
prepare a 3-year pro forma income statement and pro forma balance sheet, including expected cash flows and all associated assumptions. Company: Bishrom (Nepali eyewear brand) outsources all the manufacturing in china. Please assume all the data. you can make a fake statement. Subject: Entrepreneurial finance
• Describe pro forma income and the importance of pro forma income in the evaluation of...
• Describe pro forma income and the importance of pro forma income in the evaluation of the income statement. Choose at least two items that are excluded from pro forma income. Suggest to management why including the items would be misleading to investors and creditors.
Which of the following budgeted pro forma financial statements is prepared first? A. Pro forma statement...
Which of the following budgeted pro forma financial statements is prepared first? A. Pro forma statement of cash flows B. Pro forma income statement C .Pro forma balance sheet D. May be prepared in any order explain why please
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT