Question

In: Finance

Millions of Dollars) 2020 2019 Sales $ 13,000 $ 11,000 Operating costs excluding depreciation 11,564 9,722...

Millions of Dollars) 2020 2019 Sales $ 13,000 $ 11,000 Operating costs excluding depreciation 11,564 9,722 Depreciation and amortization 420 370 Earnings before interest and taxes $ 1,016 $ 908 Less interest 260 200 Pre-tax income $ 756 $ 708 Taxes (25%) 189 177 Net income available to common stockholders $ 567 $ 531 Common dividends $ 201 $ 200 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2020 2019 Assets Cash $ 650 $ 600 Short-term investments 110 100 Accounts receivable 2,750 2,500 Inventories 1,250 1,200 Total current assets $ 4,760 $ 4,400 Net plant and equipment 3,750 3,500 Total assets $ 8,510 $ 7,900 Liabilities and Equity Accounts payable $ 1,300 $ 1,200 Accruals 650 600 Notes payable 192 100 Total current liabilities $ 2,142 $ 1,900 Long-term debt 1,300 1,200 Total liabilities $ 3,442 3,100 Common stock 3,502 3,600 Retained earnings 1,566 1,200 Total common equity $ 5,068 $ 4,800 Total liabilities and equity $ 8,510 $ 7,900 Suppose the federal-plus-state tax corporate tax is 25%. Answer the following questions. What is the net operating profit after taxes (NOPAT) for 2020? Enter your answer in millions. For example, an answer of $1 million should be entered as 1, not 1,000,000. Round your answer to the nearest whole number. $ million What are the amounts of net operating working capital for both years? Enter your answers in millions. For example, an answer of $1 million should be entered as 1, not 1,000,000. Round your answers to the nearest whole number. 2020: $ million 2019: $ million What are the amounts of total net operating capital for both years? Enter your answers in millions. For example, an answer of $1 million should be entered as 1, not 1,000,000. Round your answers to the nearest whole number. 2020: $ million 2019: $ million What is the free cash flow for 2020? Enter your answer in millions. For example, an answer of $1 million should be entered as 1, not 1,000,000. Cash outflow, if any, should be indicated by a minus sign. Round your answer to the nearest whole number. $ million What is the ROIC for 2020? Round your answer to two decimal places. % How much of the FCF did Rhodes use

I have roc is 1.4% I'm told its wrong. im confued why my ROIC percentage is wrong

Solutions

Expert Solution


Related Solutions

Baresse Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2019 2018 Sales $11,000...
Baresse Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2019 2018 Sales $11,000 $10,000 Operating costs excluding depreciation 9,360 8,500 Depreciation and amortization 380 360 Earnings before interest and taxes $1,260 $1,140 Less interest 120 100 Pre-tax income $1,140 $1,040 Taxes (40%) $456 $416 Net income available to common shareholders $684 $624 Common dividends $220 $200 Baresse Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2019 2018 Assets Cash $550 $500 Short term investments 110...
Hermann Industries is forecasting the following income statement: Sales $4,000,000 Operating costs excluding depreciation & amortization...
Hermann Industries is forecasting the following income statement: Sales $4,000,000 Operating costs excluding depreciation & amortization 2,200,000 EBITDA $1,800,000 Depreciation and amortization 440,000 EBIT $1,360,000 Interest 240,000 EBT $1,120,000 Taxes (40%) 448,000 Net income $672,000 The CEO would like to see higher sales and a forecasted net income of $1,142,400. Assume that operating costs (excluding depreciation and amortization) are 55% of sales and that depreciation and amortization and interest expenses will increase by 8%. The tax rate, which is 40%,...
Edmonds Industries is forecasting the following income statement: Sales $8,000,000 Operating costs excluding depreciation & amortization...
Edmonds Industries is forecasting the following income statement: Sales $8,000,000 Operating costs excluding depreciation & amortization 4,400,000 EBITDA $3,600,000 Depreciation and amortization 480,000 EBIT $3,120,000 Interest 400,000 EBT $2,720,000 Taxes (25%) 680,000 Net income $2,040,000 The CEO would like to see higher sales and a forecasted net income of $4,000,000. Assume that operating costs (excluding depreciation and amortization) are 55% of sales and that depreciation and amortization and interest expenses will increase by 14%. The tax rate, which is 25%,...
Edmonds Industries is forecasting the following income statement: Sales $7,000,000 Operating costs excluding depreciation & amortization...
Edmonds Industries is forecasting the following income statement: Sales $7,000,000 Operating costs excluding depreciation & amortization 3,850,000 EBITDA $3,150,000 Depreciation and amortization 980,000 EBIT $2,170,000 Interest 420,000 EBT $1,750,000 Taxes (25%) 437,500 Net income $1,312,500 The CEO would like to see higher sales and a forecasted net income of $2,490,000. Assume that operating costs (excluding depreciation and amortization) are 55% of sales and that depreciation and amortization and interest expenses will increase by 6%. The tax rate, which is 25%,...
Edmonds Industries is forecasting the following income statement: Sales $9,000,000 Operating costs excluding depreciation & amortization...
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 1,170,000 EBIT $2,880,000 Interest 900,000 EBT $1,980,000 Taxes (25%) 495,000 Net income $1,485,000 The CEO would like to see higher sales and a forecasted net income of $2,350,000. Assume that operating costs (excluding depreciation and amortization) are 55% of sales and that depreciation and amortization and interest expenses will increase by 13%. The tax rate, which is 25%,...
Edmonds Industries is forecasting the following income statement: Sales $7,000,000 Operating costs excluding depreciation & amortization...
Edmonds Industries is forecasting the following income statement: Sales $7,000,000 Operating costs excluding depreciation & amortization 3,850,000 EBITDA $3,150,000 Depreciation and amortization 1,050,000 EBIT $2,100,000 Interest 700,000 EBT $1,400,000 Taxes (25%) 350,000 Net income $1,050,000 The CEO would like to see higher sales and a forecasted net income of $1,320,000. 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 is 25%,...
Edmonds Industries is forecasting the following income statement: Sales $7,000,000 Operating costs excluding depreciation & amortization...
Edmonds Industries is forecasting the following income statement: Sales $7,000,000 Operating costs excluding depreciation & amortization 3,850,000 EBITDA $3,150,000 Depreciation and amortization 350,000 EBIT $2,800,000 Interest 700,000 EBT $2,100,000 Taxes (25%) 525,000 Net income $1,575,000 The CEO would like to see higher sales and a forecasted net income of $1,920,000. Assume that operating costs (excluding depreciation and amortization) are 55% of sales and that depreciation and amortization and interest expenses will increase by 14%. The tax rate, which is 25%,...
Edmonds Industries is forecasting the following income statement: Sales $7,000,000 Operating costs excluding depreciation & amortization...
Edmonds Industries is forecasting the following income statement: Sales $7,000,000 Operating costs excluding depreciation & amortization 3,850,000 EBITDA $3,150,000 Depreciation and amortization 350,000 EBIT $2,800,000 Interest 350,000 EBT $2,450,000 Taxes (40%) 980,000 Net income $1,470,000 The CEO would like to see higher sales and a forecasted net income of $1,837,500. Assume that operating costs (excluding depreciation and amortization) are 55% of sales and that depreciation and amortization and interest expenses will increase by 8%. The tax rate, which is 40%,...
Edmonds Industries is forecasting the following income statement: Sales $5,000,000 Operating costs excluding depreciation & amortization...
Edmonds Industries is forecasting the following income statement: Sales $5,000,000 Operating costs excluding depreciation & amortization 2,750,000 EBITDA $2,250,000 Depreciation and amortization 500,000 EBIT $1,750,000 Interest 300,000 EBT $1,450,000 Taxes (25%) 362,500 Net income $1,087,500 The CEO would like to see higher sales and a forecasted net income of $1,970,000. Assume that operating costs (excluding depreciation and amortization) are 55% of sales and that depreciation and amortization and interest expenses will increase by 10%. The tax rate, which is 25%,...
Sales $3,000,000 Operating costs (excluding depreciation) 1,500,000 Gross margin $1,500,000 Depreciation 500,000 EBIT $1,000,000 Interest 500,000...
Sales $3,000,000 Operating costs (excluding depreciation) 1,500,000 Gross margin $1,500,000 Depreciation 500,000 EBIT $1,000,000 Interest 500,000 EBT $500,000 Taxes 200,000 Net income $ 300,000 The company’s president is disappointed with the forecast and would like to see the company generate higher sales and a forecasted net income of $750,000. Assume that the president wants to maintain the same proportion of operating costs (excluding depreciation). Also, assume that depreciation and the company’s tax rate will remain the same. The president wants...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT