Switch to:
Xcel Energy Inc  (NYSE:XEL) Operating Income: $2,230 Mil (TTM As of Sep. 2017)

Xcel Energy Inc's Operating Income for the three months ended in Sep. 2017 was $818 Mil. ts operating income for the trailing twelve months (TTM) ended in Sep. 2017 was $2,230 Mil.

Operating Margin % is calculated as Operating Income divided by its Revenue. Xcel Energy Inc's Operating Income for the three months ended in Sep. 2017 was $818 Mil. Xcel Energy Inc's Revenue for the three months ended in Sep. 2017 was $3,017 Mil. Therefore, Xcel Energy Inc's Operating Margin % for the quarter that ended in Sep. 2017 was 27.13%.

Good Sign:

Xcel Energy Inc operating margin is expanding. Margin expansion is usually a good sign.

Xcel Energy Inc's 5-Year average Growth Rate for Operating Margin % was 2.60% per year.

Operating Income or EBIT is linked to Return on Capital for both regular definition and Joel Greenblatt's definition. Xcel Energy Inc's annualized ROC % for the quarter that ended in Sep. 2017 was 8.71%. Xcel Energy Inc's annualized ROC (Joel Greenblatt) % for the quarter that ended in Sep. 2017 was 10.10%.


Historical Data

* All numbers are in millions except for per share data and ratio. All numbers are in their local exchange's currency.

* Premium members only.

Xcel Energy Inc Annual Data

Dec07 Dec08 Dec09 Dec10 Dec11 Dec12 Dec13 Dec14 Dec15 Dec16
Operating Income Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only 1,822.68 1,847.56 1,948.13 2,000.51 2,213.86

Xcel Energy Inc Quarterly Data

Dec12 Mar13 Jun13 Sep13 Dec13 Mar14 Jun14 Sep14 Dec14 Mar15 Jun15 Sep15 Dec15 Mar16 Jun16 Sep16 Dec16 Mar17 Jun17 Sep17
Operating Income Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only 827.05 465.35 486.22 459.69 818.36

Calculation

Operating income, is the profit a company earned through operations. All expenses, including cash expenses such as cost of goods sold (COGS), research & development, wages, and non-cash expenses, such as depreciation, depletion and amortization, have been deducted from the sales.

Xcel Energy Inc's Operating Income for the fiscal year that ended in Dec. 2016 is calculated as

Operating Income(A: Dec. 2016 )
=Revenue-Cost of Goods Sold-Selling, General, & Admin. Expense
=11106.92-4486.449-244.784
-Research & Development-Depreciation, Depletion and Amortization-Others
-0-1318.752-2843.08
=2,214

Xcel Energy Inc's Operating Income for the quarter that ended in is calculated as

Operating Income(Q: Sep. 2017 )
=Revenue-Cost of Goods Sold-Selling, General, & Admin. Expense
=3016.897-1078.609-73.728
-Research & Development-Depreciation, Depletion and Amortization-Others (1)
-0-405.789-640.412
=818

Operating Income(Q: Sep. 2017 )
=EBITDA-Depreciation, Depletion and Amortization-Others (2)
=1264.601-405.789-40.453
=818

Operating Income for the trailing twelve months (TTM) ended in Sep. 2017 was 465.35 (Dec. 2016 ) + 486.219 (Mar. 2017 ) + 459.692 (Jun. 2017 ) + 818.359 (Sep. 2017 ) = $2,230 Mil.

* All numbers are in millions except for per share data and ratio. All numbers are in their local exchange's currency.


Explanation

1. Operating Income or EBIT is linked to Return on Capital for both regular definition and Joel Greenblatt's definition.

Xcel Energy Inc's annualized ROC % for the quarter that ended in Sep. 2017 is calculated as:

ROC %(Q: Sep. 2017 )
=NOPAT/Average Invested Capital
=Operating Income*(1-Tax Rate)/( (Invested Capital (Q: Jun. 2017 ) + Invested Capital (Q: Sep. 2017 ))/2)
=3273.436 * ( 1 - 29.38% )/( (26442.951 + 26663.918)/2)
=2311.7005032/26553.4345
=8.71 %

where

Invested Capital(Q: Jun. 2017 )
=Book Value of Debt + Book Value of Equity - Cash
=Long-Term Debt & Capital Lease Obligation + Current Portion of Long-Term Debt + Total Equity - Cash
=14091.833 + 1289.345 + 11123.155 - 61.382
=26442.951

Invested Capital(Q: Sep. 2017 )
=Book Value of Debt + Book Value of Equity - Cash
=Long-Term Debt & Capital Lease Obligation + Current Portion of Long-Term Debt + Total Equity - Cash
=14572.967 + 819.415 + 11439.377 - 167.841
=26663.918

Note: The Operating Income data used here is four times the quarterly (Sep. 2017) operating income data.

2. Joel Greenblatt's definition of Return on Capital:

Xcel Energy Inc's annualized ROC (Joel Greenblatt) % for the quarter that ended in Sep. 2017 is calculated as:

ROC (Joel Greenblatt's)(Q: Sep. 2017 )
=EBIT/Average of (Net fixed Assets + Net Working Capital)
=EBIT/Average of (Property, Plant and Equipment+Net Working Capital)
     Q: Jun. 2017  Q: Sep. 2017
=EBIT/( ( (Property, Plant and Equipment + Net Working Capital) + (Property, Plant and Equipment + Net Working Capital) )/2 )
=3435.248/( ( (33543.843 + max(293.809, 0)) + (33949.952 + max(210.042, 0)) )/2 )
=3435.248/( ( 33837.652 + 34159.994 )/2 )
=3435.248/33998.823
=10.10 %

where Working Capital is:

Working Capital(Q: Jun. 2017 )
=(Accounts Receivable + Total Inventories + Other Current Assets) - (Accounts Payable & Accrued Expense + Defer. Rev. + Other Current Liabilities)
=(759.378 + 542.044 + 1393.746) - (1672.252 + 0 + 729.107)
=293.809

Working Capital(Q: Sep. 2017 )
=(Accounts Receivable + Total Inventories + Other Current Assets) - (Accounts Payable & Accrued Expense + Defer. Rev. + Other Current Liabilities)
=(807.621 + 616.675 + 1306.737) - (1750.428 + 0 + 770.563)
=210.042

When net working capital is negative, 0 is used.

Note: The EBIT data used here is four times the quarterly (Sep. 2017) EBIT data.

3. Operating Income is also linked to Operating Margin:

Xcel Energy Inc's Operating Margin % for the quarter that ended in Sep. 2017 is calculated as:

Operating Margin %=Operating Income (Q: Sep. 2017 )/Revenue (Q: Sep. 2017 )
=818.359/3016.897
=27.13 %

* All numbers are in millions except for per share data and ratio. All numbers are in their local exchange's currency.

4. Please click Growth Rate Calculation Example (GuruFocus) to see how GuruFocus calculates Wal-Mart Stores Inc (WMT)'s revenue growth rate. You can apply the same method to get the operating income growth rate using operating income per share data.


Be Aware

Compared with a company's EBITDA margin, Operating Margin can be manipulated by adjusting the rate of depreciation, depletion and amortization (DDA).

If a company is facing competition, its Operating Margin may decline. Often the Operating Margin declines well before the company's revenue or even profit decline. Therefore, Operating Margin is a very important indicator of whether the company is facing problems.

For instance, by 2012, Nokia (NOK)'s problems were well known and its stock had lost more than 90% of its market value since 2007. But Nokia's Operating Margin had already been in decline since 2002, although its earnings per share were still rising. Investors who paid attention to Operating Margin would have avoided this huge loss. The same can be said for Research-in-Motion (RIMM).

Therefore, Operating Margin is a very important screening filter for GuruFocus. GuruFocus's Buffett-Munger screener requires that the profit margin is either consistent or expanding. The Model Portfolio of the Buffett-Munger screener has outperformed the market every year since inception in 2009.


Related Terms


Headlines

No Headline

Get WordPress Plugins for easy affiliate links on Stock Tickers and Guru Names | Earn affiliate commissions by embedding GuruFocus Charts
GuruFocus Affiliate Program: Earn up to $400 per referral. ( Learn More)

GF Chat

{{numOfNotice}}
FEEDBACK