Question

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.

Homework Answers

Answer #1

1.

Assuming net income is after tax

Net Income (after tax) i.e, 100-35 , For 65% (a) $ 2.8 millions
Tax 35% (2.8/65*35) (b) 1.51m
Net Income before tax (c) = a+b 4.31m
Interest (d) 0.7m
Net income before interest and tax (e)= c+d 5.01m
Depreciation and amortisation (f) 1.5m
Earnings before interst,tax depreciation and amortisation (EBITDA) = e+f $6.51 m

2. Reverse Calculation

Sales (d) = a+b+c $13.475m
Operating costs (4.5+7%) 4.815m
Depreciation and amortisation 1.5m
Interest 0.7m
Total expenses (c) 7.015m
Tax 35% i.e, (4.2*35/65) (b) 2.26m
Net Income 65% (100%-35%) (a) 4.2m
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
DO NOT USE EXCEL PLS EXPLAIN EACH STEP Use AstroTurf Company's income statement below to answer...
DO NOT USE EXCEL PLS EXPLAIN EACH STEP Use AstroTurf Company's income statement below to answer the following two questions. a. Calculate AstroTurf’s EBITDA. b. Determine what level of sales would generate $3.3m in net income for the following year (Year 2), knowing that operating costs (excl. depreciation and amortization) will increase by 5%. The tax rate will not change. Year 1 Income Statement: Sales: $11,000,000 Operating costs (excl. depreciations & amortization): $4,500,000 Depreciation and amortization: $1,500,000 Interest: $700,000 Net...
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 $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%,...
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 $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%,...
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...
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%...