Switch to:
Xcel Energy Inc (NYSE:XEL)
Cost of Goods Sold
$5,521 Mil (TTM As of Sep. 2014)

Xcel Energy Inc's cost of goods sold for the three months ended in Sep. 2014 was $1,187 Mil. Its cost of goods sold for the trailing twelve months (TTM) ended in Sep. 2014 was $5,521 Mil.

Cost of Goods Sold is directly linked to profitability of the company through Gross Margin. Xcel Energy Inc's Gross Margin for the three months ended in Sep. 2014 was 58.63%.

Cost of Goods Sold is also directly linked to Inventory Turnover. Xcel Energy Inc's Inventory Turnover for the three months ended in Sep. 2014 was 2.09.


Definition

Cost of goods sold (COGS) refers to the Inventory costs of those goods a business has sold during a particular period.

Xcel Energy Inc Cost of Goods Sold for the trailing twelve months (TTM) ended in Sep. 2014 was 1373.896 (Dec. 2013 ) + 1700.278 (Mar. 2014 ) + 1259.865 (Jun. 2014 ) + 1187.211 (Sep. 2014 ) = $5,521 Mil.

* All numbers are in millions except for per share data and ratio. All numbers are in their own currency.


Explanation

Cost of Goods Sold is directly linked to profitability of the company through Gross Margin.

Xcel Energy Inc's Gross Margin for the three months ended in Sep. 2014 is calculated as:

Gross Margin=(Revenue - Cost of Goods Sold) / Revenue
=(2869.807 - 1187.211) / 2869.807
=58.63 %

* All numbers are in millions except for per share data and ratio. All numbers are in their own currency.

A company that has a “moat” can usually maintain or even expand their Gross Margin. A company can increase its Gross Margin in two ways. It can increase the prices of the goods it sells and keeps its Cost of Goods Sold unchanged. Or it can keep the sales price unchanged and squeeze its suppliers to reduce the Cost of Goods Sold. Warren Buffett believes businesses with the power to raise prices have “moats”.

Cost of Goods Sold is also directly linked to another concept called Inventory Turnover:

Xcel Energy Inc's Inventory Turnover for the three months ended in Sep. 2014 is calculated as:

Inventory Turnover (Q: Sep. 2014 )
=Cost of Goods Sold (Q: Sep. 2014 )/( (Inventory (Q: Jun. 2014 )+Inventory (Q: Sep. 2014 ))/ 2 )
=1187.211/( (501.27+634.262)/ 2 )
=1187.211/567.766
=2.09

* All numbers are in millions except for per share data and ratio. All numbers are in their own currency.

Inventory Turnover measures how fast the company turns over its inventory within a year. A higher inventory turnover means the company has light inventory. Therefore the company spends less money on storage, write downs, and obsolete inventory. If the inventory is too light, it may affect sales because the company may not have enough to meet demand.

Usually retailers pile up their inventories at holiday seasons to meet the stronger demand. Therefore, the inventory of a particular quarter of a year should not be used to calculate inventory turnover. An average inventory is a better indication.


Related Terms

Inventory, Inventory Turnover, Gross Margin, Revenue


Historical Data

* All numbers are in millions except for per share data and ratio. All numbers are in their own currency.

Xcel Energy Inc Annual Data

Dec04Dec05Dec06Dec07Dec08Dec09Dec10Dec11Dec12Dec13
COGS 3,0413,9224,1035,6856,7814,9615,2035,1864,5345,135

Xcel Energy Inc Quarterly Data

Jun12Sep12Dec12Mar13Jun13Sep13Dec13Mar14Jun14Sep14
COGS 9501,0641,2311,3731,2081,1801,3741,7001,2601,187
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)
Free 7-day Trial
FEEDBACK