Income Statements for Caterpillar, Inc., from 1997 to 2001 appear below. a. Enter the data into your
Question:
Income Statements for Caterpillar, Inc., from 1997 to 2001 appear below.
a. Enter the data into your worksheet. Assume that 50% of SG&A expense is a variable cost, with the balance being a fixed cost.
b. Given that Caterpillar is a manufacturing company, would you expect that it would have more operating leverage or financial leverage?
c. Calculate the degree of operating leverage, degree of financial leverage, and the degree of combined leverage for each of the five years. Does it appear that Caterpillarís leverage measures have been increasing or decreasing over this period?
d. Create a chart that shows how the various leverage measures have changed over this five-year period.
Step by Step Answer:
Financial Analysis With Microsoft Excel
ISBN: 9780324407501
4th Edition
Authors: Timothy R Mayes, Todd M Shank