Staples (LTS:0R27) Inventory Turnover : 1.67 (As of Jul. 2017)

View and export this data going back to . Start your Free Trial

What is Staples Inventory Turnover?

Inventory Turnover measures how fast the company turns over its inventory within a year. It is calculated as Cost of Goods Sold divided by Total Inventories. Staples's Cost of Goods Sold for the three months ended in Jul. 2017 was $2,908.00 Mil. Staples's Average Total Inventories for the quarter that ended in Jul. 2017 was $1,746.50 Mil. Staples's Inventory Turnover for the quarter that ended in Jul. 2017 was 1.67.

Days Inventory indicates the number of days of goods in sales that a company has in the inventory. Staples's Days Inventory for the three months ended in Jul. 2017 was 54.80.

Inventory-to-Revenue determines the ability of a company to manage their inventory levels. It measures the percentage of Inventories the company currently has on hand to support the current amount of Revenue. Staples's Inventory-to-Revenue for the quarter that ended in Jul. 2017 was 0.45.

Staples Inventory Turnover Historical Data

The historical data trend for Staples's Inventory Turnover can be seen below:

* For Operating Data section: All numbers are indicated by the unit behind each term and all currency related amount are in USD.
* For other sections: All numbers are in millions except for per share data, ratio, and percentage. All currency related amount are indicated in the company's associated stock exchange currency.

* Premium members only.

Staples Inventory Turnover Chart

Staples Annual Data

Trend

Jan08

Jan09

Jan10

Jan11

Jan12

Jan13

Jan14

Jan15

Jan16

Jan17

Inventory Turnover

Get a 7-Day Free Trial

7.54

7.36

6.55

7.04

7.65

Staples Quarterly Data
	Oct12	Jan13	Apr13	Jul13	Oct13	Jan14	Apr14	Jul14	Oct14	Jan15	Apr15	Jul15	Oct15	Jan16	Apr16	Jul16	Oct16	Jan17	Apr17	Jul17
Inventory Turnover	Get a 7-Day Free Trial															1.39	1.84	1.17	1.83	1.67

Staples Inventory Turnover Calculation

Staples's Inventory Turnover for the fiscal year that ended in Jan. 2017 is calculated as

	Inventory Turnover (A: Jan. 2017 )
=	Cost of Goods Sold	/	Average Total Inventories
=	Cost of Goods Sold (A: Jan. 2017 )	/ (	(Total Inventories (A: Jan. 2016 )	+	Total Inventories (A: Jan. 2017 ))	/	count )
=	13489	/ (	(1791	+	1737)	/	2 )
=	13489	/	1764
=	7.65

Staples's Inventory Turnover for the quarter that ended in Jul. 2017 is calculated as

	Inventory Turnover (Q: Jul. 2017 )
=	Cost of Goods Sold	/	Average Total Inventories
=	Cost of Goods Sold (Q: Jul. 2017 )	/ (	(Total Inventories (Q: Apr. 2017 )	+	Total Inventories (Q: Jul. 2017 ))	/	count )
=	2908	/ (	(1623	+	1870)	/	2 )
=	2908	/	1746.5
=	1.67

Staples (LTS:0R27) Inventory Turnover Explanation

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.

1. Days Inventory indicates the number of days of goods in sales that a company has in the inventory.

Staples's Days Inventory for the three months ended in Jul. 2017 is calculated as:

Days Inventory	=	Average Total Inventories (Q: Jul. 2017 )	/	Cost of Goods Sold (Q: Jul. 2017 )	*	Days in Period
	=	1746.5	/	2908	*	365 / 4
	=	54.80

2. Inventory-to-Revenue determines the ability of a company to manage their inventory levels. It measures the percentage of Inventories the company currently has on hand to support the current amount of Revenue.

Staples's Inventory to Revenue for the quarter that ended in Jul. 2017 is calculated as

Inventory-to-Revenue	=	Average Total Inventories (Q: Jul. 2017 )	/	Revenue (Q: Jul. 2017 )
	=	1746.5	/	3905
	=	0.45

Be Aware

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.

Staples Inventory Turnover Related Terms

Thank you for viewing the detailed overview of Staples's Inventory Turnover provided by GuruFocus.com. Please click on the following links to see related term pages.

Staples (LTS:0R27) Business Description

Industry

GURUFOCUS.COM » STOCK LIST » Consumer Cyclical » Retail - Cyclical » Staples Inc (LTS:0R27) » Definitions » Inventory Turnover

Comparable Companies

Traded in Other Exchanges

N/A

Address

Website

http://www.staples.com

Staples is an American retailer with online and delivery capabilities. Staples offers products in categories: technology, facilities and breakroom, furniture, safety, medical, copy and print, and Staples EasyTech services. Staples operates throughout North and South America, Europe, Asia, Australia, and New Zealand. The company divides its business into three segments: North American stores and online, North American commercial, and international operations. The product offering includes Staples, Quill, and other proprietary branded products. Staples' product price points are generally low.

Staples (LTS:0R27) Headlines

No Headlines