Table and formulas are included.

Important: EXCEL Spreadsheet Must be Used for this Problem.

Only steps c and d are needed. Thank you.

The Hurricane Lamp Company forecasts that next years sales will be $6 million. Fixed operating costs are estimated to be $800,000, and the variable cost ratio (that is, variable costs as a fraction of sales) is estimated to be 0.75. The firm has a $600,000 loan at 10 percent interest. It has 20,000 shares of $3 preferred stock and 60,000 shares of common stock outstanding. Hurricane Lamp is in the 40 percent corporate income tax bracket.

a) Forecast Hurricane Lamps earnings per share (EPS) for next year. Develop a complete income statement using the revised format illustrated in Table 14.1. Then determine what Hurricane Lamps EPS would be if sales were 10 percent above the projected $6 million level.

c) Calculate Hurricane Lamps degree of financial leverage (DFL) at the EBIT level corresponding to sales of $6 million using the following:

1. (Equation 14.3)

2. The simpler computational formula (Equation 14.4)

3. What is the economic interpretation of this value?

d) Calculate Hurricane Lamps degree of combined leverage (DCL) using the following:

1. The definitional formula (Equation 14.5)

2. The simpler computational formula (Equation 14.7)

3. The degree of operating and financial leverage calculated in Parts b and c

What is the economic interpretation of this value?

EQUATION 14.1: DOL at X = ( EBIT/EBIT) / (Sales /Sales)

Equation 14.2 : DOL at X = (- Variable costs) / EBIT

Equation 14.3: DFL at X = (EPS / EPS) / (EBIT/ EBIT)

Equation 14.4: DFL at X = EBIT / ( EBIT- I Dp/(1 T))

Equation 14.5: (DCL at X = (EPS / EPS) / ( Sales / Sales )

Equation 14.7: DCL at X = (Sales - Variable costs) / ( EBIT- I -Dp/(1 -T))

-------------------------------------------------------------------------------------------------------------------------------------------------------

Allegan Manufacturing Company Year Ending December 31, 2016 Traditional Income Statement Format