Question

In: Finance

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%, will remain the same. (Note that while the tax rate remains constant, the taxes paid will change.) What level of sales would generate $1,837,500 in net income? If necessary, round your answer to the nearest dollar at the end of the calculations.

Solutions

Expert Solution

We will make reverse making for calculation purpose:

Earning before tax =Net income /(1-Tax rate)

                         = 1837500/(1-.40)

                         = 3062500

Interest : 350000(1+.08)= 378000

EBIT =EBT + interest

           = 3062500+378000

           = 3440500

Depreciation and amortization = 350000(1+.08)=378000

EBITDA = 3440500+378000

                = 3818500

level of sales would generate $1,837,500 in net income = EBITDA/(1-variable cost ratio)

                         =3818500/(1-.55)

                        = 3818500/.45

                          = $ 8,485,556

jeff jeffy answered 3 years ago
Next > < Previous

Related Solutions

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 $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 $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 $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 $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%,...
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%,...
Income Statement Hermann Industries is forecasting the following income statement: Sales $10,000,000 Operating costs excluding depreciation...
Income Statement Hermann Industries is forecasting the following income statement: Sales $10,000,000 Operating costs excluding depreciation & amortization 5,500,000 EBITDA $4,500,000 Depreciation and amortization 1,200,000 EBIT $3,300,000 Interest 900,000 EBT $2,400,000 Taxes (40%) 960,000 Net income $1,440,000 The CEO would like to see higher sales and a forecasted net income of $1,728,000. Assume that operating costs (excluding depreciation and amortization) are 55% of sales and that depreciation and amortization and interest expenses will increase by 9%. The tax rate, which...
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...
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
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT