Build Income Statement for Rosemont. from 2017 to 2020. Calculate Break-even points and conduct leverage analysis.

The facts of Rosemont in 2016:

1. Sales = 310,000 units; Annual sales (units) growth rate = 5.5%

2. Price per unit = $29, annual price growth rate is 2.5%

3. Variable costs as a percent of sales = 56.8%

4. Annual fixed costs = $ 2,100,000.

5. The annual depreciation expense is 12% of the annual fixed costs.

6. Annual interest expense = $ 350,000.

7. Annual preferred dividends = $ 300,000.

8. Common shares outstanding = 1,800,000 shares

9. Tax rate = 28%

a) Enter the above data into the worksheet. Build Income Statement for Rosemont. from 2017 to 2020.

b) Calculate annual operating break-even points (in both units and dollars) and cash Break-even points (in both units and dollars) for the firm.

c) Calculate DOL, DFL, and DCL for each of four years using their definitions.

d) Calculate DOL, DFL, and DCL for each of five years using alternative formulas

e) Create a chart that shows the various leverage measures (DOL, DFL, DCL) have declined as sales increases over the five-year period.

f) Discuss the major findings.