Question: Do this is excel P 1 2 - 8 EBIT sensitivity Stewart Industries sells its finished product for $ 9 per unit. Its fixed operating

Do this is excel
P12-8 EBIT sensitivity Stewart Industries sells its finished product for $9 per unit. Its fixed operating costs are $20,000, and the variable operating cost per unit is $5.
a. Calculate the firm's earnings before interest and taxes (EBIT) for sales of 10,000 units.
b. Calculate the firm's EBIT for sales of 8,000 and 12,000 units, respectively.
c. Calculate the percentage changes in sales (from the 10,000-unit base level) and associated percentage changes in EBIT for the shifts in sales indicated in part b.
d. On the basis of your findings in part c, comment on the sensitivity of changes in EBIT in response to changes in sales.
Do and answer this in an excel worksheet!!!!!!!!!!!!!
 Do this is excel P12-8 EBIT sensitivity Stewart Industries sells its

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!