Question

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,260,000 EBIT $2,790,000 Interest 900,000 EBT $1,890,000 Taxes (40%) 756,000 Net income $1,134,000 The CEO would like to see higher sales and a forecasted net income of $1,814,400. 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 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,814,400 in net income? If necessary, round your answer to the nearest dollar at the end of the calculations.

Homework Answers

Answer #1

Required Sales will be calculated through back calculation as follows:

Required Net Income = $1,814,400

Add: Taxes @ 40% = (1,814,400/60%)*40% = $1,209,600

EBT = $3,024,000

Add: Interest Charges 900,000*113% = $1,017,000

EBIT = $4,041,000

Add: Depreciation and Amortization = 1,260,000*113% = $1,423,800

EBITDA = $5,464,800

Add: Operating Costs = (5,464,800/45%)*55% = $6,679,200

Sales = $12,144,000

Hence, required sales to generate $1,814,400 in net income = $12,144,000

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
INCOME STATEMENT Edmonds Industries is forecasting the following income statement: Sales $9,000,000 Operating costs excluding depreciation...
INCOME STATEMENT 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 900,000 EBIT $3,150,000 Interest 720,000 EBT $2,430,000 Taxes (40%) 972,000 Net income $1,458,000 The CEO would like to see higher sales and a forecasted net income of $2,551,500. 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...
Edmonds Industries is forecasting the following income statement: Sales $6,000,000 Operating costs excluding depreciation & amortization...
Edmonds Industries is forecasting the following income statement: Sales $6,000,000 Operating costs excluding depreciation & amortization 3,300,000 EBITDA $2,700,000 Depreciation and amortization 900,000 EBIT $1,800,000 Interest 360,000 EBT $1,440,000 Taxes (40%) 576,000 Net income $864,000 The CEO would like to see higher sales and a forecasted net income of $1,425,600. 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 40%,...
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 420,000 EBIT $2,730,000 Interest 420,000 EBT $2,310,000 Taxes (40%) 924,000 Net income $1,386,000 The CEO would like to see higher sales and a forecasted net income of $2,079,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 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 750,000 EBIT $1,500,000 Interest 450,000 EBT $1,050,000 Taxes (25%) 262,500 Net income $787,500 The CEO would like to see higher sales and a forecasted net income of $1,460,000. 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 25%,...
eBook Problem Walk-Through Edmonds Industries is forecasting the following income statement: Sales $12,000,000 Operating costs excluding...
eBook Problem Walk-Through Edmonds Industries is forecasting the following income statement: Sales $12,000,000 Operating costs excluding depreciation & amortization 6,600,000 EBITDA $5,400,000 Depreciation and amortization 1,320,000 EBIT $4,080,000 Interest 1,200,000 EBT $2,880,000 Taxes (25%) 720,000 Net income $2,160,000 The CEO would like to see higher sales and a forecasted net income of $3,670,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,...
Simeon Industries is forecasting the following income statement: Sales $16,000,000 Operating costs excluding      depreciation 7,200,000...
Simeon Industries is forecasting the following income statement: Sales $16,000,000 Operating costs excluding      depreciation 7,200,000 EBITDA $ 8,800,000 Depreciation 1,000,000 EBIT $ 7,800,000 Interest 2,500,000 EBT $ 5,300,000 Taxes (40%) 2,120,000 Net income $ 3,180,000 The CEO would like to see higher sales and a forecasted net income of $5,500,000. Assume that operating costs (excluding depreciation) are 45% of sales and that depreciation and interest expenses will increase by 15%. The tax rate will remain at 40%. What level...
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.00 Operating costs excluding depreciation 3,052.00 EBITDA $1,098.00 Depreciation 320.00 EBIT $778.00 Interest 140.00 EBT $638.00 Taxes (40%) 255.20 Net income $382.80 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.15 billion in sales generated last year. Year-end operating costs, excluding depreciation, will equal 80% of...
The AFN equation provides useful insights into the forecasting process, but this equation assumes that all...
The AFN equation provides useful insights into the forecasting process, but this equation assumes that all of the firm's key ratios remain constant, which is not likely to hold true. Consequently, it is useful to forecast the firm's financial statements. The firm begins with forecasting its which then feeds into the firm's balance sheet. Management looks at operating ratios and their relationship with industry and benchmark averages. The forecasted income statement begins with the prior year's income statement and is...
Use AstroTurf Company's income statement below to answer the following questions. Operating costs (excl. depreciations &...
Use AstroTurf Company's income statement below to answer the following questions. Operating costs (excl. depreciations & amortization): $4.5m Depreciation and amortization: $1.5m Interest: $0.7m Net Income: $2.8m Tax Rate: 35% 1. Calculate AstroTurf’s EBITDA. 2. What level of sales would generate a net income of $4.2m for the following year, knowing that operating costs (excl. depreciation and amortization) will increase by 7.5%, and given a 35% tax rate.
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 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 10% higher than the $3 billion in sales generated last year. Year-end operating costs, excluding depreciation, are expected to equal 70%...