Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Income Statements for Xcel Energy from 2011 to 2013 appear below. Xcel Energy Incorporated Annual Income Statements For the Years 2011 to 2013 ($ in
Income Statements for Xcel Energy from 2011 to 2013 appear below. Xcel Energy Incorporated Annual Income Statements For the Years 2011 to 2013 ($ in millions) 2011 2012 Revenue 10,655 10.128 Cost of revenue 5.186 4,534 Gross profil 5,469 3,594 Operation and maintenance 2,140 2,176 Depreciation and amortization 891 926 Other operating expenses 656 669 Operating income 1,782 1,823 Interest Expense 591 602 Other income 119 134 Income before income taxes 1,310 1,355 Provision for income taxes 468 450 Ner income 841 Preferred dividend 7 Net income available to common shareholders 834 905 Basic Shares Outstanding 485 488 Basic EPS 1.72 1.86 Tax Rate 35.73% 33.219 2013 10,915 5.135 5,780 2,274 978 681 1,848 575 160 1,432 484 948 905 9.48 496 1.91 33.80% Required: a. Enter the data into your worksheet. Assume that Cost of Revenue and Operation and Maintenance costs are variable. Depreciation and Other operating expenses are fixed costs. Ignore Other income when calculating EBT for the questions below. b. Given that Xcel Energy is a power company, would you expect that it would have more operating leverage or financial leverage? c. Calculate the degree of operating leverage for each year using the assumptions from part a. d. Calculate the degree of financial leverage for each year. e. Calculate the degree of combined leverage for each of the three years. Does it appear that Xcel's leverage measures have been increasing or decreasing over this period? f. Create a line chart that shows how the various leverage measures have changed over this three- year period
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started